DNR Parcel Editing and Map Production

1
DNR Parcel Editing and Map Production

• Alaska Surveying and Mapping Conference 2005

2
Why Change?

• 8,000 ArcInfo workspaces unmanageable
• Format not open to other software
• Want to use commercial software
• Automate more of the cartographic work
• Need to make data more accessible
• Need to link map data to mainframe data

3
Why Oracle Spatial?

• Many GIS vendors supported
• Scalability
• SQL access to spatial data
• Example PL/SQL spatial function to calculate the
  area of a polygon within a PLS township

4
CREATE OR REPLACE PROCEDURE "GIS"."MTRS_ACRE"
( p_geom IN MDSYS.SDO_GEOMETRY, mo_id IN
NUMBER) AS CURSOR c_col IS SELECT
SUBSTR(a.mtr a.section_,1,12) mtrs,
ROUND(sdo_geom.sdo_area(sdo_geom.sdo_intersection
(a.geom, p_geom, 0.00000005),0.00000005,
'unitACRE'),3) acre FROM gis.pls_section
a WHERE sdo_relate(a.geom, p_geom,
'maskANYINTERACT querytypeWINDOW') 'TRUE'
AND SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(p_g
eom, 0.00000005) 'TRUE' mtrs_acre_rec
c_colROWTYPE BEGIN OPEN c_col LOOP FETCH
c_col INTO mtrs_acre_rec EXIT WHEN
c_colNOTFOUND IF mtrs_acre_rec.acre gt 0.1
THEN INSERT INTO CASE_OBJECT_LAND
(mappable_object_id, mtrs, acre) VALUES
(mo_id, mtrs_acre_rec.mtrs, mtrs_acre_rec.acre)
END IF END LOOP CLOSE c_col END
mtrs_acre
5
Data Conversion Strategy

• Use Safe FME to convert to Oracle Spatial
• Populate a generic database
• Learn ESRI Geodatabase and Oracle Spatial
• Create formal ESRI Geodatabase design
• Design and build editing and mapping systems

6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)