Difference between revisions of "Connecting to IMSMA Staging area from ArcGIS"

From IMSMA Wiki
Jump to: navigation, search
Line 10: Line 10:
 
There is also a special mxd-file, ''staging.mxd'', that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called '''staging''' for all layers. You find the ''staging-MM-DD-YY.mxd'' in C:\IMSMAETLTool\data.
 
There is also a special mxd-file, ''staging.mxd'', that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called '''staging''' for all layers. You find the ''staging-MM-DD-YY.mxd'' in C:\IMSMAETLTool\data.
  
If your IMSMA Staging area database is called something else than '''staging''', you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000020000000| instructions] on how to '''Repair broken links for multiple layers'''.
+
If your IMSMA Staging area database is called something else than '''staging''', you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find [http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000020000000| instructions] on how to '''Repair broken links for multiple layers'''. Choose the [[http://mwiki.gichd.org/IM/Staging_Area_Database#Geographical_data_in_the_IMSMA_staging_area|GIS views]] (e.g. HAZARD_POLYGON_VIEW, ACCIDENT_POINT_VIEW, etc.) as sources in the staging area.
 
{{NavBox Business Intelligence}}
 
{{NavBox Business Intelligence}}
 
[[Category:VIE]]
 
[[Category:VIE]]

Revision as of 13:04, 10 July 2015

To be able to connect to the IMSMA Staging area database from ArcGIS you need to copy the client library files to the \ArcGIS\Desktop10.1\bin folder:

  • libeay32.dll
  • libiconv-2.dll
  • libintl-8.dll
  • libpq.dll
  • ssleay32.dll

You can download these files from here or copy from C:\IMSMAng\pgsql\bin.

Staging mxd.png

There is also a special mxd-file, staging.mxd, that contains the IMSMA symbology and has Data Source set to a PostgreSQL database called staging for all layers. You find the staging-MM-DD-YY.mxd in C:\IMSMAETLTool\data.

If your IMSMA Staging area database is called something else than staging, you need to rebuild the Data Source links for each layer. On ESRI's ArcGIS Resource Center you will find instructions on how to Repair broken links for multiple layers. Choose the [views] (e.g. HAZARD_POLYGON_VIEW, ACCIDENT_POINT_VIEW, etc.) as sources in the staging area.