Enterprise: Establish Enterprise GIS Data Connections (Internal)
- Nolan Bertuca (Unlicensed)
- Nina Salvador Barroll (Unlicensed)
- Yonas Birhanemeskel (Unlicensed)
- Reyes, Nichole (Unlicensed)
DISCLAIMER
Please be advised that the City does not warrant the accuracy of the GIS (Geographic Information Systems) data. This data is provided to you "as is," and you agree to use it at your own risk. The City makes no guarantees, representations or warranties of any kind, express or implied, arising by law or otherwise, including but not limited to, content, quality, accuracy, completeness, effectiveness, reliability, fitness for a particular purpose, usefulness, use or results to be obtained from this data, or that the data will be uninterrupted or error-free. By downloading this data, you agree that any use of, and reliance upon, the data will be at your sole discretion and risk, and you agree to take full responsibility therefor.
BACKGROUND
Recently the City of San Jose's Enterprise GIS Team (part of Public Works) has undergone a major data migration and consolidation effort to better serve both City employees and residents. By practicing good data management with a goal of reducing both "bad" data and data redundancy, Public Works now provides a central location for up-to-date authoritative GIS data.
There are two connections that must be made to access data. The first establishes a connection to a collection of databases holding refreshed data from various City departments and external agencies. The second establishes a server connection to consume map services including City basemap, utilities, and current aerial imagery for the entire County. These can be consumed in ArcMap, ArcGIS Pro, and ArcGIS Online through REST URLs and Server Connections.
GEODB CONNECTION
Outlined below are the steps necessary to make a folder connection in ArcCatalog to GeoDB. This folder contains a collection of file geodatabases containing City data as well as reference data from other agencies. These databases are refreshed on a regular basis by behind the scene automotive processes ensuring the availability of up-to-date data.
- Open ArcCatalog (or connect through ArcMap/ArcGIS Pro)
- Click on the “Connect To Folder” button to launch the Connect To Folder dialog box (shown below)
- In the Folder text box at the bottom of the dialog enter \\GEO-DATA\GeoDB\
- Click the OK button at the bottom of the dialog box
- You will now have a folder connection to the new folder GeoDB containing the file geodatabases. These will be available in ArcCatalog, the ArcCatalog window in ArcMap, and ArcGIS Pro anytime they are opened.
MAP SERVICES CONNECTION
Outlined below are the steps necessary to make a GIS Server connection in ArcCatalog containing map services. Map services are pre-configured maps made available by a server for use in both GIS software and other web applications. These include the City Basemap Service, Sanitary Service, Stormwater Service, and multiple Imagery Services. Map services have been optimized for editing and are mainly used for visualization of City data to easily produce maps. The Imagery Service is a more recent and higher resolution alternative to Esri's free Imagery Basemap and is recommended anytime imagery is needed.
- Open ArcCatalog and double-click the plus sign next to the GIS Servers to expand the list.
- Double-click on the Add ArcGIS Server to open the dialog box.
- Make sure the Use GIS services radio button is checked.
- Click on Next.
- In the ArcGIS Server User Connection Properties dialog box enter http://geo.sanjoseca.gov/server/rest/services
- Click the Finish button.
- You will now see an entry underneath the GIS Servers category in the catalog tree called gisserver on geo.sanjoseca.gov (user).
- Expand the DPW folder to examine the services.
- You can now drag and drop the service into the ArcCatalog preview window, or into the map window in ArcMap.
SQL VIEWER CONNECTION
Outlined below are the steps necessary to establish a Viewer only connection to the Public Works Enterprise Production Geodatabase (SQL Server).
- Open ArcCatalog and double-click the plus sign next to the Database Connections to expand the list.
- Double-click on the Add Database Connection and enter the information shown below.
- User name: viewer
Password: Vi3w3r1!
ACKNOWLEDGEMENTS
This documentation was created March 2018, Nolan Bertuca, Public Works Department and updated February 2019, Nina Salvador Barroll, Public Works Department.