hydrologic information system workgroup server: software stack, deployment, operation
DESCRIPTION
Hydrologic Information System Workgroup Server: Software Stack, Deployment, Operation. Thomas Whitenack, David Valentine, Ilya Zaslavsky SDSC. WATERS Network Information System. HIS Team. WATERS Testbeds. This Presentation. Slides Deployment overview - PowerPoint PPT PresentationTRANSCRIPT
Hydrologic Hydrologic Information System Information System Workgroup Server: Workgroup Server:
Software Stack, Deployment, Software Stack, Deployment, OperationOperation
Thomas Whitenack, David Valentine, Ilya Zaslavsky SDSC
HISTeam
WATERSTestbeds
WATERS Network Information WATERS Network Information SystemSystem
This PresentationThis Presentation
►SlidesSlides Deployment overview Deployment overview Content of the server: COTS + HIS softwareContent of the server: COTS + HIS software Registering your observation networks Registering your observation networks Server administration and updatesServer administration and updates Current status, and licensingCurrent status, and licensing
►Workgroup server demonstrationWorkgroup server demonstration►Q&AQ&A
Deployment OverviewDeployment Overview►HIS Server Machines are staged at SDSCHIS Server Machines are staged at SDSC
Base software components installed Base software components installed (Microsoft, ESRI)(Microsoft, ESRI)
All HIS components installed:All HIS components installed:►ODMODM►Web Services and templatesWeb Services and templates►DASH = DASH = DData ata AAccess ccess SSystem for ystem for HHydrologyydrology►+ additional tools+ additional tools
►Servers can be accessed remotely, Servers can be accessed remotely, before shipped to testbedsbefore shipped to testbeds
Windows 2003 Server4 GB Ram500 GB DiskQuad Core CPU
SQLServer 2005IIS (Internet Information Server)
DASH ArcGIS Server
Vis
ual S
tud
io 2
00
5
WaterOneFlow Web ServicesArcGIS 9.2
GIS Data Mxd Services
OD
Data
Loader
OD
M t
ools
COTS Software
HIS Applications Data
NWIS DV
NWIS IID
Your ODM
C: 50Gb O: 230Gb P: 180Gb
System Disk
Operating System
Program Files- SQL Server- IIS- Visual Studio- ArcGIS- ArcGIS Server
Data Disk
GIS Data
SQL Data (ODM)
HIS software
-WaterOneFlow Web Services
- DASH
- ODM Data Loader
-ODM Tools
-WSTestPage
SQL Server
ODMs and catalogs. All instancesexposed as ODM (i.e. have standard ODM tables or views: Sites, Variables, SeriesCatalog, etc.)
NWIS-IID
NWIS-DV
ASOS
STORET
TCEQ
BearRiver
. . .
Spatial store
Geodatabase or collection of shapefilesor both
NWIS-IID points
NWIS-DV points
ASOS points
STORET points
TCEQ points
BearRiver points
. . .
My new ODM
My new points
More databases
More synced layers
DASH Web Application
Background layers
(can be in the same or separate spatial store)
WOF services
Web services from a common template
NWIS-IID WS
NWIS-DV WS
ASOS WS
STORET WS
TCEQ WS
BearRiver WS
. . .My new WS
More WS fromODM-WS template
USGS
NCDC
EPA
TCEQ
Web Configuration fileStores information about registered networks
MXDStores information about layers
WSDLs
, web
serv
ice U
RLs Connection
strings
Layer info,
symbology, etc.
ODMDataLoader
2
6
5
3
1
4
WORKGROUPHISSERVERORGANIZATION
STEPS FORREGISTERINGOBSERVATIO
NDATA
New network registration steps
Using the ODM DataLoader, load your data into a blank ODM instance (this will create all ODM tables, including Sites, Variables and SeriesCatalog that HIS application relies on)
Copy Web Services template to a new folder, edit the template web.config file to point to the new ODM, test to make sure the new service works as expected
Create a point layer (a feature class in GDB, or a shapefile) from the new ODM’s Sites table using the GetSitesTool.
Add the point layer to the MXD document, specify symbology, scale-dependent rendering, etc.
Add information about the new ODM, the associated web service, and the associated point layer, to HIS configuration file (see the first slide for the exact content)
Restart the HIS service6
5
4
3
2
1
Loading Observation dataLoading Observation data
►Make a copy of the ODM template Make a copy of the ODM template databasedatabase
►Data to be loaded is in an Excel Data to be loaded is in an Excel readable format (xls, txt, csv).readable format (xls, txt, csv).
►Use ODM DataLoader to load dataUse ODM DataLoader to load data
1
Structure Structure of ODM of ODM
DataLoadDataLoaderer
1
Configure WaterOneFlow Web Configure WaterOneFlow Web ServiceService
►Create copy of Web Services from template: Create copy of Web Services from template: Make a copy and renameMake a copy and rename
►Edit the web.config file using VS or notepadEdit the web.config file using VS or notepad
<appSettings> <add key="network" value=“BearRiver"/> <add key="vocabulary" value=“BearRiver"/> <add key="serviceExampleHTMLPage" value=“BearRiverSampleData.htm"/></appSettings><connectionStrings> <add name="ODDB" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=true;User instance=true;AttachDbFilename=|DataDirectory|BearRiver.mdf;Database=BearRiver" providerName="System.Data.SqlClient"/> </connectionStrings>
2
Extract Geometries from ODMExtract Geometries from ODM
► GetSites tool extracts sites using Lat / Long GetSites tool extracts sites using Lat / Long valuesvalues
► Add shapefile to service documentAdd shapefile to service document
3
Add Sites to Map Service Add Sites to Map Service DocumentDocument
► Symbolize PointsSymbolize Points► Specify Scale at which points are visisbleSpecify Scale at which points are visisble
4
Configure DASHConfigure DASH► Edit HISNetworks.xml found in the bin of the HIS Application.Edit HISNetworks.xml found in the bin of the HIS Application.► Copy/Paste existing “HISNetwork” block and edit to change:Copy/Paste existing “HISNetwork” block and edit to change:
<HISNetwork Script="GetSiteInfo" RecordSetXML="" TagName=“BearRiver" Name=“BearRiver" LayerName=“BearRiver" LayerIndex="1" WebServiceURL=“ http://water.usu.edu/BearRiver/cuahsi_1_0.asmx SiteCodeField="siteid"> <ApWebFields Desc="ParameterFields" Name="ParameterFields" TagName="ParameterFields" IsReadOnly="False" IsFixedSize="False" IsSynchronized="False" Count="2"> <ApWebField ConstValue="False" FieldOrder="0" AllowEdit="1" Desc=“siteid" FieldAlias="asosid" Name="siteid" TagName="siteid" Order="0" Type="0" Text="siteid"/> <ApWebField ConstValue="True" FieldOrder="1" AllowEdit="1" Desc="BearRiver" FieldAlias="BearRiver" Name="BearRiver" TagName="BearRiver" Order="0" Type="0" Text="BearRiver" Value="BearRiver"/> </ApWebFields> <ApWebFields Desc="DisplayFields" Name="DisplayFields" TagName="DisplayFields" IsReadOnly="False" IsFixedSize="False" IsSynchronized="False" Count="2"> <ApWebField ConstValue="False" FieldOrder="1" AllowEdit="1" Desc="sitename" FieldAlias="sitename" Name="sitename" TagName="sitename" Order="0" Type="0" Text="sitename"/> <ApWebField ConstValue="True" FieldOrder="0" AllowEdit="1" Desc="BearRiver" FieldAlias="BearRiver" Name="BearRiver" TagName="BearRiver" Order="0" Type="0" Text="BearRiver" Value="BearRiver"/> </ApWebFields></HISNetwork>
► NetworkID, NetworkCode,► NetworkName,► NetworkConnectionString ► NetworkServicesWSDL► NetworkServicesURL► NetworkServicesGetValuesURL► CreatedDate► LastUpdateDate► ResponsibleParty► Disabled► DisableDate
5
Refresh Map ServiceRefresh Map Service
► Use ArcCatalog to Stop and start the Map service Use ArcCatalog to Stop and start the Map service
6
Deployment ScheduleDeployment Schedule
►8 servers received and are currently 8 servers received and are currently being configured; 9being configured; 9thth server is expected server is expected
►This week: Remote access to at least This week: Remote access to at least one server given to a testbed (Utah)one server given to a testbed (Utah) It only depends on licensing at the momentIt only depends on licensing at the moment
►After testbeds review the machine After testbeds review the machine setup, the servers will shipsetup, the servers will ship (some testbeds may choose to keep (some testbeds may choose to keep
machine longer at SDSC so we can assist machine longer at SDSC so we can assist with ODM loading).with ODM loading).
Administration and UpdatesAdministration and Updates► Admin accounts: local + remote (for SDSC, Admin accounts: local + remote (for SDSC,
troubleshooting)troubleshooting)► Updating software:Updating software:
DASH and ODM ToolsDASH and ODM Tools► New versions on web site, with installation instructionsNew versions on web site, with installation instructions
ODM Data LoaderODM Data Loader► ClickOnce deploymentClickOnce deployment
Regular software updates and patches for COTSRegular software updates and patches for COTS► Need to first try at SDSC; post on administrators blogNeed to first try at SDSC; post on administrators blog
► Updating databases:Updating databases: Regularly updated at SDSC; available to workgroups Regularly updated at SDSC; available to workgroups
via web services and direct connection to via web services and direct connection to disrupter.sdsc.edudisrupter.sdsc.edu
► Updating web servicesUpdating web services New templates posted on web site, with instructionsNew templates posted on web site, with instructions