Wednesday, April 15, 2015

Mapping Fire Hydrants in the Staff Site

I have just uploaded pages to the Custom section of the demo Staff web site that lets users map fire hydrants and keep track of them in a database. You can add hydrants visually using a map. You can look up a street address and find all the nearest fire hydrants. This is just a test system that I am working on for a customer but it is also a fun example of the kinds of things you can do with web-based data. You can play with the pages yourself by logging on at www.zpdemo.zpuser.com/staff and using the Dashboard from the Main page to go to Custom Options. From there you will see a menu of options for working with the fire hydrant maps and data.

Friday, April 10, 2015

Connecting to ArcMap 10

One of my customers, Morehead City, is messing around with GIS and ZonePro so I asked if they would send me their steps for making the connection and they were kind enough to do so. Here is what they sent:

ArcMap 10.3
- ArcCatalog -> Database Connections -> Add Database Connection
- In the dropdown box, select “SQL Server”
- Enter server and database information from Zone Pro -> “OK” (ZP Systems can give you this info.)
- Drag and drop the “vBuildCombo” database (for building permits) and/or “vViolateRep” database (for violations) from Database Connections in ArcCatalog to the table of contents in ArcMap
- Identify a unique identifier (e.g., “parcel” field) ->Click Finish
- Add the layer to the map which contains the parcel identification number. Use the layer to create a relate:
- Right click the layer -> “Joins and Relates” -> “Relate” ->
- #1 Select the field which contains the parcel number from the drop down box.
- Make sure #2 contains the correct table.
- #3 Select “parcel” from the dropdown box.
- Click “OK”

To see the connected information, click the identify tool and select a property. Identify from the layer that is connected to the Zone Pro tables. If permit activity exists, you will be able to see it by clicking the “+” sign under the layer name.

It looks like this: