ArcSDE Admin Tools - Esri Support Info PDF
Preview ArcSDE Admin Tools - Esri Support Info
ArcSDE Admin Tools Jim Jarvis – ArcSDE Specialist Intro to Generic Tools [email protected] Alan Jackson – Software Product Management Special Topics [email protected] Agenda: (cid:127) ArcSDE Fundamentals (cid:127) Database Design (cid:127) Overview of ArcSDE administration tools FFFuuunnndddaaammmeeennntttaaalllsss - Loading Parameters --XXYY ooffffsseett,, SSccaallee --CCoommmmiitt iinntteerrvvaall --DDbbttuunnee --GGrriidd SSiizziinngg XXYY ooffffsseett,, SSccaallee shp2sde -o create [-x <xoffset,yoffset,xyscale>] XY Coordinate Offset (cid:127) Goals: – All data in positive coordinate space – Provide equal room to grow on all sides (cid:127) Solution: – Find distance between data and integer system centers – Offset coordinates by this distance Scale ° ° 72 73 ................. 41° . . ................. ................. ................. ................. ................. ................. ................. . . ................. ................. ° 40 ................. Andizhan, Uzbekistan Integer - no scale Integer - scale of 10 72.36° 40.81° 72° 41° 72.4° 40.8° (cid:127) ArcSDE stores geometry in integer format – Coordinates snap to nearest integer location (cid:127) Applying scale avoids loss of data – Larger scales allow higher resolution Characteristics of integer coordinates 2147483647 2147483647 .... . .. .. ... . . . .. . . . .. .. .. . . . . .. . . . .. .. .. . . .. 2147483647 .. . . . .. .. . . . . .. 2147483647 .. . . . .. .. .. . . .. .. . . . .. .. . . . . .. .. ... .. .. . .. . .. .. . .. .. .. . . . . .. .. ... .. .. . .. . .. .. . .. .. .. . . . . .. .. ... .. .. . .. . .. .. . .. .. .. . . . . .. .. ... .. .. . .. . .. .. . .. .. .. . . . . .. Small Large ... .. ... . . ... .. ... .. .. . .. . .. .. ... .. ... . . ... .. ... .. .. . .. . .. .. ... .. ... . . ... .. scale ... .. .. . .. . .. .. scale ... .. ... . . ... .. ... .. .. . .. . .. .. . .. ... . . . .. .. .. .. . ... . . ... .. .. . .. ... . . . .. .. .. .. . ... . . ... .. .. 0 0 0 0 (cid:127) Finite number of possible coordinates (cid:127) Larger scale factor consumes more coordinate / storage space (cid:127) Choose smallest scale that supports data's resolution – Cannot alter after layer creation – Allow for update with higher resolution data CCoommmmiitt IInntteerrvvaall shp2sde -o create [-c <commit_interval>] Populating the layer (cid:127) RDBMS stores uncomitted work in temporary space (cid:127) Comitting transaction frees temporary space (cid:127) Committing transaction takes time (cid:127) Delay commit as long as possible without exhausting temporary space (cid:127) Full temporary space causes the database to rollback the transaction (i.e., load fails). DDBBTTuunnee shp2sde -o create [-k <config_keyword>]
Description:The list of books you might like
