Information System Analyst II (GIS) Position at Pasadena Water & Power

The City of Pasadena is nestled at the foothills of the San Gabriel Mountains approximately 10 miles northeast of downtown Los Angeles. Pasadena is home to the world renowned Tournament of Roses and the Norton-Simon Museum. Pasadena residents enjoy moderate climate year round, ideal weather for enjoying Pasadena’s fine shopping, dining, and entertainment venues.

Department Information System Analyst II (GIS)
$68,817.22 – $86,021.31 Annually

As part of the Pasadena Water & Power (PWP) Information Technology team, the Geographic Information Systems (GIS) Analyst is responsible for assisting the design, development, analysis, support, deployment, administration and maintenance of new and existing enterprise systems and applications. The GIS Analyst also helps to procure, develop, and deploy utility-specialized computer applications. The GIS Analyst provides direct support to PWP staff, monitors application performance and accessibility, creates training materials, trains users on geospatial concepts and software, and provides analysis services.  The GIS Analyst is also involved in system upgrades developing test cases and performing validation of applications prior to full deployement.  The Analyst’s primary role is GIS Helpdesk for the W&P utility department supporting users and interfacing between other utilities, PWP staff, vendors, and City of Pasadena resources.  Must have excellent communication and customer service skills.

A bachelor’s degree in Geography, Computer Science, Information Systems, Math, Engineering or a related field and one year (three years desired) managing GIS data systems. Electric and Water Utility experience is a plus.

Initial Review of application is scheduled for July 1, 2013. Interested applicants should visit the City of Pasadena’s website at for complete job information and online application. EOE

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:

If you want raster data services, use:

And if you want vector data services use:

There is also a NED status service (this shows availability and resolution of USGS digital elevation models) at:

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-6101 fax

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!


And it likes XMIN and YMIN too!