Author Archives: socalgovgis - Michael Carson

Unknown's avatar

About socalgovgis - Michael Carson

Michael Carson, GIS Manager (retired) for the City of Burbank and President of Southern California Government GIS User Group. Currently teaching GIS at College of the Canyons in Santa Clarita.

Student Reviews of Our Apps

Posted on by
1

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

Posted on by
Reply

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

Posted on by
2

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

Posted on by
Reply

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

Posted on by
Reply

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.

Preliminary 3D Agenda for ESRI UC

Posted on by
Reply

Here is the link to the Forum’s website: www.esri.com/3Dforum

Learn new 3D webmap: http://dld.bz/c9sJB (works best in Chrome)

3dforumwebmap

Preliminary Agenda:

Sunday, July 7, 2013
8:00 a.m. –   8:10 a.m. Welcome and Introductions Steve Snow, MAPS Industry Specialist
8:00 a.m. –   8:30 a.m. Esri 3D Imagery Future   Possibilities
Lawrie Jordan, Esri, Director of Imagery
8:30 a.m. –   9:30 a.m. Lidar and ArcGIS: Recent   Advances and the Road Ahead
Clayton Crawford, Esri Product Engineer
9:30 a.m. –   10:00 a.m. 3D Mapping and GeoDesign
Gert van Maren, Esri, Head of Product Management
10:00 a.m. –   10:15 a.m. Gold Sponsor Speaking Slot
10:00 a.m. –   10:30 a.m. Break
10:30 a.m. –   11:00 a.m. Lidar   and Imagery in ArcGIS 10.1
Cody Benkelman, Esri Product Manager
11:00 a.m. –   11:20 a.m. Leveraging data attributes   populated from Lidar with CityEngine
Geoff Taylor, Solutions Engineer
11:20 a.m. –   11:40 a.m. An update on the American   Society for Photogrammetry and Remote Sensing (ASPRS) LIDAR Data Standard
Lewis Graham,  ASPRS Regional Director
11:40 a.m. –   12:00 p.m. Lunch   and Platinum Speaker: Optech
Title TBA
Jim Green, Regional Manager, North America, Airborne Survey Products
12:00 p.m. –   1:00 p.m. Lunch sponsored by Optech   with exhibitors
Exhibition area

 

 

Breakout
Session I

Breakout
Session II

Breakout
Session III

Topic: Unmanned Aerial Vehicles and   Mobile Mapping Smart 3D Cities Military Installation 3D   Management
Moderator: Myles Sutherland Chris Wilkins Terry Martin
1:00 p.m. –   1:15 p.m. Introduction Introduction Introduction
1:15 p.m. –   1:45 p.m. Panel Discussion (TBD) The Instant City
Elliot Hartley,
Garsdale Design Ltd.		 User Speaker (TBD)
1:45 p.m. –   2:15 p.m. Panel Discussion (TBD) Master Plan for 500K
Tal Aisenberg, WATG		 User Speaker (TBD)
2:15 p.m. –   2:30 p.m. Hawkeye
Rowland Harrison		 Geospecific City Modeling
Sponsor, Kevin Devito,
CyberCity3D		 Sponsor Speaker (TBD)
2:30 p.m. –   3:00 p.m. SenseFly
Andrea Hildebrand		 Immersive City Visualization
David Burdick,
E-on Software		 User Speaker (TBD)
Each breakout session will   contain 1 sponsor speaker with 15 minute speaking slot and 3 user speakers   with 30 minute speaking slot each.

 

3:00 p.m. –   3:15 p.m. Break
3:15 p.m. –   3:30 p.m. Gold Sponsor Speaker
3:30 p.m. –   4:00 p.m. User Speaker
4:00 p.m. –   4:30 p.m. User Speaker
4:30 p.m. –   4:45 p.m. Closing
5:00 p.m. –   6:30 p.m. Break