SGID: 2009 Restructuring Plans for ArcSDE 9.3

Written by Bert Granberg,

AGRC plans to have a new ArcSDE 9.3 database server available by the end of January, 2009. From the time it goes into production mode, this server will contain the most current version of all vector GIS data in the public portion of the State Geographic Information Database.  

Several big changes are planned that will affect all users of SGID data layers through an ArcSDE database connection. In addition, the restructuring of the SGID will have an impact on how the file-based vector data on the ftp download site is organized.

First, AGRC will be removing the feature datasets that have been used primarily for data layer categorization.

Second, the user names that were used to designate source scale (U024, U100, etc) will be removed. In general, we plan to archive some of the older, coarse scale data but when it's still relevant the coarser scale data will carry a scale designation in the feature class name.

Third, AGRC is seriously considering adopting the 19 topic categories defined by the ISO 19111 geographic information standard (see summary list below). This will mean that all vector data in the SGID will be organized according tothese topic categories. Where appropriate, prefixes will be added to names to group similar datasets together when listed alphabetically.

Just a few examples:

  • OLD: SGID.U024.Administration.Municipalities --> NEW: SGID.Boundaries.Municipalities
  • OLD: SGID.U024.Administration.LandOwnership --> NEW: SGID.PlanningCadastre.LandOwnership
  • OLD: SGID.U024.Administration.ZipCodes --> NEW: SGID.Location.Postal_ZipCodes
  • OLD: SGID.U024.Administration.SalesTaxAreas --> NEW: SGID.Economy.Revenue_SalesTaxArea
  • OLD: SGID.U024.Energy.DNROilGasWells --> NEW: SGID.Economy.Energy_DOGMOilGasWells
  • OLD: SGID.U024.Geology.Faultlines --> NEW: SGID.Geoscientific.FaultLines
  • OLD: SGID.U024.Hydrology.StreamsNHDHighRes --> NEW: SGID.InlandWaters.StreamsNHDHighRes
  • OLD: SGID.U024.Reference.PLSSSections_GCDB --> NEW: SGID.PlanningCasdastre.PLSS_SectionsGCDB
  • OLD: SGID.U024.Transportation.StatewideStreets --> NEW: SGID.Transportation.Roads_StatewideStreets
  • OLD: SGID.U024.Wilderness.BLM98WildernessReinventory --> NEW: SGID.Environment.Wilderness_BLM98Reinventory

These look like big changes and they are. The reasoning is as follows:

  1. the pesky feature datasets need to go as they severly hinder AGRC's ability to keep data updated
  2. everyone is going to have to repoint their existing layers due to the feature dataset removal anyway, so we might as well try to make any structural changes on the horizon so we only have to do this once
  3. adopting the ISO standard will make the SGID organizational structure more compliant and usable to a wider audience.
Like any big change, this will take some time for familiarization. As the plan for the ArcGIS 9.3 conversion matures, AGRC will publish details on the Utah GIS Portal. In addition, resources such as a conversion reference table and possibly a VBA script to automate the repointing of ArcMap layers to the new 9.3 feature classes, will be made available. AGRC is planning to keep the existing 9.2 server in production, using its existing structure, for approximately 6 months after the 9.3 server comes online.

If you have feedback or suggestions regarding the upcoming ArcSDE 9.3 server upgrade and the restructuring and renaming of existing feature classes, please email This e-mail address is being protected from spam bots, you need JavaScript enabled to view it

ISO 19111 Topic Category Summary

Name Code Description
farming 001 rearing of animals and/or cultivation of plants
Examples: agriculture, irrigation, aquaculture, plantations, herding, pests and diseases affecting crops and livestock
biota 002 flora and/or fauna in natural environment
Examples: wildlife, vegetation, biological sciences, ecology, wilderness, sea life, wetlands, habitat, biological resources
boundaries 003 legal land descriptions
Examples: political and administrative boundaries, governmental units, marine boundaries, voting districts, school districts, international boundaries
climatologyMeteorologyAtmosphere 004 processes and phenomena of the atmosphere
Examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation
economy 005 economic activities, conditions, and employment
Examples: production, labor, revenue, business, commerce, industry, tourism and ecotourism, forestry, fisheries, commercial or subsistence hunting, exploration and exploitation of resources such as minerals, oil and gas
elevation 006 height above or below seal level
Examples: altitude, bathymetry, digital elevation models, slope, derived products, DEMs, TINs
environment 007 environmental resources, protection and conservation
Examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape, water quality, air quality, environmental modeling
geoscientificInformation 008 information pertaining to earth sciences
Examples: geophysical features and processes, geology, minerals, sciences dealing with the composition, structure and origin of the earth?s rocks, risks of earthquakes, volcanic activity, landslides, gravity information, soils, permafrost, hydrogeology, groundwater, erosion
health 009 health, health services, human ecology, and safety
Examples: disease and illness, factors affecting health, hygiene, substance abuse, mental and physical health, health services, health care providers, public health
imageryBaseMapsEarthCover 010 base maps
Examples: land/earth cover, topographic maps, imagery, unclassified images, annotations, digital ortho imagery
intelligenceMilitary 011 military bases, structures, activities
Examples: barracks, training grounds, military transportation, information collection
inlandWaters 012 inland water features, drainage systems and characteristics
Examples: rivers and glaciers, slat lakes, water utilization plans, dams, currents, floods and flood hazards, water quality, hydrographic charts, watersheds, wetlands, hydrography
location 013 positional information and services
Examples: addresses, geodetic networks, geodetic control points, postal zones and services, place names, geographic names
oceans 014 features and characteristics of salt water bodies (excluding inland waters)
Examples: tides, tidal waves, coastal information, reefs, maritime, outer continental shelf submerged lands, shoreline
planningCadastre 015 information used for appropriate actions for future use of the land
Examples: land use maps, zoning maps, cadastral surveys, land ownership, parcels, easements, tax maps, federal land ownership status, public land conveyance records
society 016 characteristics of society and culture
Examples: settlements, housing, anthropology, archaeology, education, traditional beliefs, manners and customs, demographic data, tourism, recreational areas and activities, parks, recreational trails, historical sites, cultural resources, social impact assessments, crime and justice, law enforcement, census information, immigration, ethnicity
structure 017 man-made construction
Examples: buildings, museums, churches, factories, housing, monuments, shops, towers, building footprints, architectural and structural plans
transportation 018 means and aids for conveying persons and/or goods
Examples: roads, airports/airstrips, shipping routes, tunnels nautical charts, vehicle or vessel location, aeronautical charts, railways
utilitiesCommunication 019 energy, water and waste systems and communications infrastructure and services
Examples: hydroelectricity, geothermal, solar and nuclear sources of energy, water purification and distribution, sewage collection and disposal, electricity and gas distribution, data communication, telecommunication, radio, communication networks

Users' Comments  
 

No comment posted

Add your comment

06, Nov. 2008
Last Updated ( 11, Dec. 2008 )