Migration to Geodatabase

1
Migration to Geodatabase

• Details on Phase 2

2
Breakdown of Tasks

• Determine Which Coverages to Migrate
• Develop Editing Procedures
• Determine Publishing Mechanism
• Develop Migration Procedures
• Develop Publishing Procedures

3
Which Coverages to Migrate
Actively Edited Point Files

• GolfHole_PT
• School_PT
• CntyFuel_PT
• CntyOffice_PT
• FireStation_PT
• GovtOffice_PT
• Hospital _PT
• Hotel_PT
• Library_PT
• MedActStation_PT

• NursingHome_PT
• PoliceStation_PT
• PostOffice_PT
• Shelter_PT
• Siren_PT
• ATM_PT
• ConvenienceStore_PT
• Restaurant_PT
• Towers_PT

4
Which Coverages to Migrate

• Other Actively Edited Files Without Annotation
• Cerizip_PL
• FireDist_PL
• SherDist_PL
• SubParcZoning_PL
• Zip_PL
• Watershed_PL
• GolfFairway_PL
• ElectricServiceArea_PL
• GasServiceArea_PL
• NpmsPipe_LN
• WaterDist_PL
• WilliamsPipe_LN
• CentCorpBnd_PL
• Cemetery_PL
• Apartment_PL

5
Which Coverages to Migrate

• Actively Edited Files With Annotation
• Lake_PL
• Water_LN
• Stream_LN
• Golf_PL
• SchoolDist_PL
• SchoolPrivate_PT
• ShopCenter_PL
• Museum_PT

6
Which Coverages to Migrate
Semi-Static Files

• Sunflower_PL
• CntyBnd_PL
• PLSS_PL
• PLSSQuarter_PL
• FloodZone_PL
• River_PL
• FemaQ3_PL
• Soil_PL

• Plat_PL
• Park_PL
• SchoolAttendBnd_PL
• AirCenter_PL
• AirExec_PL
• Rail_LN
• FlightCorridor_PL

7
Editing in ArcMap

• Use of Editor Listeners
• New Fields in the Data
• AIMSFID (UNIQ in Centerline)
• Double with a precision of 15
• Will go into every editing feature class except
  annotation
• Format Year, Julian Day, Time, Random 10-99
• 200432419270615
• DATEADDED (LAST_UPDATED in Plani)
• DATEMOD (LAST_UPDATED in Plani)
• LASTUSER 20 Characters, Login Username (LAST_USER
  in Plani)
• XCOORD (If point file) Double
• YCOORD (If point file) Double
• SECTID (in Plani)
• (Demo)

8
Publishing Process

• AIMSDataMaint Table
• Data Maintenance
• Primary Format Field
• Publishing Website
• Publish Coverages

9
Conversion Process

• DataConverter
• Command Line
• \\Admsaimdsv01\mapping\app\ArcTools\Arc8\bin\DataC
  onverter\dataconverter.exe sde,admsdbwin02,aims_sd
  e,jocogeogdev,dl,jocoaims,FireStation_PT,sde,admsa
  imsde01,aims_sde,jocogeogarchive,dl,jocoaims,,Fire
  Station_PT,4300,JOCOGeogArchive_fill100,\\admsaimd
  sv01\mapping\app\datasync\errorlog\datasyncerrors.
  txt
• INI
• \\Admsaimdsv01\mapping\app\ArcTools\Arc8\bin\DataC
  onverter\dataconverter.exe ini,d\code\vb\data
  converter\dc.ini

10
(No Transcript)
11
Conversion Process

• DCProperties Table
• Table
• \\Admsaimdsv01\mapping\app\ArcTools\Arc8\bin\DataC
  onverter\dataconverter.exe table,23,27

12
(No Transcript)
13
Archiving Process

• Datasync
• JocoGeogDev to JocoGeog
• JocoGeogDev to Coverage
• JocoGeogDev to Shapefile
• JocoGeogDev to JocoGeogDevArchive