SoCal URISA Networking Social

During the ESRI Conference, SoCal URISA invites you to a Networking Social at:

Bootlegger Bar & Restaurant
Corner of 8th & Market, downtown San Diego
(Seven blocks from the Convention Center)
Wednesday, July 10th, 2012
4:00-7:00pm

Drinks and appetizers will be served.  Free for Members!  If you are not a member, you can join online or on-site for $30 individual, $10 students.

Please register at:  www.socalurisa.org

Student Reviews of Our Apps

I was searching on Google for something (I can’t remember what now, like the dog seeing a squirrel I was distracted for sure) and came across a UCLA Advanced GIS class web site that students post their work on.  These students are learning about web GIS and creating applications themselves.  One of the assignments the students had to do was to post reviews of sites that use interactive GIS technology … and some of the sites were ours!  Some of the reviews were eye opening, however we should treat it like a new user trying to use our apps.

So here are some interesting reviews of our sites, sites we post our data on, or other local sites of interest:

LA County’s GIS-NET3 (and here too)

LAPD Crime Map

UCLA Campus Map

Explore Santa Monica

LA Times Mapping LA Neighborhoods

City of Los Angeles Bikeway Map

City of Los Angeles ZIMAS

Beverly Hills Crime Data Map

Beverly Hills Bike Rack Locations

Crimemapping.com

-mike

USGS Map Services for The National Map

Hello California GIS users.

We wanted to make everyone aware of several map services that USGS supports. These allow you to view nationwide data from The National Map in your GIS software. To use these in ArcGIS – select Add Data button then choose GIS Server from the list, then “add ArcGIS Server”

To add the tiled map cache (these are background topographic map images, including topo maps with and without imagery), use: http://basemap.nationalmap.gov/ArcGIS/rest/services

If you want raster data services, use: http://raster.nationalmap.gov/ArcGIS/rest/services

And if you want vector data services use: http://services.nationalmap.gov/ArcGIS/rest/services

There is also a NED status service (this shows availability and resolution of USGS digital elevation models) at: http://igskmncnvs526.cr.usgs.gov/arcgis/rest/services

Hope these help and please let us know if you have any questions.  Thanks,

Carol Ostergren
Drew Decker
USGS Geospatial Liaison for Pacific Region
NSDI Partnership Office, U.S. Geological Survey
4165 Spruance Road, Suite 200
San Diego, CA 92101
619-225-6430
619-225-6101 fax
ddecker@usgs.gov
http://liaisons.usgs.gov/geospatial/California/
http://liaisons.usgs.gov/geospatial/Hawaii/

Reserved PostgreSQL System Column Names

So I’m looking at possibly using PostgreSQL for our enterprise geodatabase.  I was working on installing ESRI’s Public Safety COP web mapping application and I was copying feature classes from a file based geodatabase that comes with the app into PostgrSQL and received this error:

“ERROR 000210: Cannot create output Database Connections … Column already exists [ERROR: column name “xmin” conflicts with a system column name …”

What?  You got to be kidding me!  I was following the directions!  I tried ESRI tech support but for some reason they were swamped and could not help me … I’m still waiting for their call back.  Probably everyone is installing their apps!  So I decided to figure this thing out myself.

So I cannot have a field named XMIN as an attribute to my data?  After consulting the PostgreSQL documentation, sure enough, I cannot have XMIN or XMAX as field names because they are reserved system columns.

Great!  So I guess I cannot use the Public Safety COP or any data that has XMIN or XMAX field names with PostgreSQL.  Hmm.  So I thought I would try our Oracle enterprise geodatabase to see if that works. NOOOOOOOOOOOOOOOOOOOO!  I got this error:

“Underlying DBMS error [ORA-00972: identifier is too long (DEV.DamageResidentialBuilding_ATTACH)] …”

This is very sad!  I think I will go fire up Workstation ArcInfo and be happy!

arc

And it likes XMIN and YMIN too!

-mike

US DOT PHMSA Public Awareness Workshop & Webcast

It’s not too late to register to attend the US DOT PHMSA Public Awareness Workshop on June 19 – 20, 2013 – either in person at the Hyatt Regency N. Dallas Hotel or via webcast.

Since 2005 pipeline operators have been required to have a Public Awareness Program per federal pipeline safety regulations. They must provide information to four stakeholder audiences categorized as: (1) affected public, (2) emergency officials, (3) local public officials, and (4) excavators.

The workshop will bring together stakeholders to discuss findings from recent federal and state public awareness inspections, and gain perspectives from various stakeholders on public awareness challenges and successes to identify ways to strengthen pipeline safety public awareness.

The primary goals of this workshop are to:

  1. Provide an overview of the public awareness program and discuss recent inspection findings;
  2. Understand what’s working and not working with API RP 1162 (1st edition) from various stakeholder perspectives (industry, pipeline operators, public, emergency response officials, local public officials, and excavators);
  3. Share ways to improve public awareness outreach efforts; and
  4. Discuss the path forward for improving public awareness

For more details, please visit http://primis.phmsa.dot.gov/meetings/MtgHome.mtg?mtg=90 .

Spatial@ucsb.local13 Poster & Plenary Sessions

Spatial data come in many forms—from geo-referenced coordinates and areal units on a map to diagrams and the coding of sound with musical notation. The sources of such data include, among many others, human creativity, the Census, trajectories of movements from GPS, and the social networks represented by online contacts. Problem solving in the science, business, and design disciplines, and aesthetic renderings in the arts increasingly make use of spatial visualization technologies to represent and interpret the patterns and processes that define natural and human worlds at scales ranging from the molecular to the astronomical.  spatial@ucsb.local2013 brings together leading contributors to the art and science of visualization for demonstrations of applications and discussion. The Visualization of Spatial Data Plenary Session will feature presentations by Jason Dykes (School of Informatics, City University London), JoAnn Kuchera-Morin (Media Arts and Technology Program, UCSB), and Ross Whitaker  (Scientific Computing and Imaging Institute (SCI), University of Utah).

On Thursday, June 6, 2013, spatial@ucsb.local2013 will host a Poster Session and Plenary Session on this theme. The event will be held at Corwin Pavilion. Posters can be viewed from 11:30 a.m. to 1:00 p.m.; the Plenary Session will be from 1:00 to 3:30 p.m. If you plan to attend, please RSVP to Karen Doehner, kdoehner@spatial.ucsb.edu.