Try the GeoGuessr and Win a Prize!

Ok, had to repost this because I had a link that allowed you to see my location answers, so this is a do over!  RESET…

Try out the GeoGuessr and see if you can beat my score of 11780!  I challenge you!  The closer you guess where you are, the more points you get.  Post your score by replying to this post.  Send the bit.ly share link you can generate at the end of your guessing game to mcarson@burbankca.gov .  Top score by July 1st will get a map or globe themed prize from me!  Good luck.  -mike

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 .