customizing arcpad for electric field inventory at imperial ......found techidentno for tidno11...

Customizing ArcPad for Customizing ArcPad for Electric Field Inventory at Electric Field Inventory at Imperial Irrigation DistrictImperial Irrigation District

Jesus Nieblas – IID EnergyAlan Girten – Utility Data Contractors

* Trademarks provided under license from ESRI* Trademarks provided under license from ESRI

*

AbstractAbstract

Imperial Irrigation District has populated their electric GIS from the field collection of as-built facilities combined with pole inventory and inspection, customer geo-location and transformer ties, and synchronization of asset data to SAP and CCS. The key to this effort was a mobile field collection tool built on ESRI ArcPad technology. This provides an easy to use interface implementing all of the requirements necessary for building a valid electric geometric network from the substation source to the customer’s meter. The collected data includes unit asset data related to each electric feature needed to verify andmaintain records in existing asset management systems. To simplify the movement of data in and out of the GIS SDE database to ArcPad, an enhanced version of check-in and check-out was created. This includes detailed reports of all features handled, detection of corrupted records, manipulation of relatedrecords and the ability to repeat data check-ins.

IntroductionIntroduction

Why is the field survey being done?Why is the field survey being done?– Asset inventory– Supplement Enterprise GIS Implementation

Effective solution for getting it doneEffective solution for getting it done– Digital collection– Creation of efficient collection tools which can aid in

satisfying business rules

HighHigh--level Overview workflowlevel Overview workflow

CheckCheck--Out Process Out Process –– SDE to Shape FilesSDE to Shape Files

Checked Out PGDB Based on

Exent of Map

“Flattened” Shape Files

Check Out Version in

SDE

Check Out Reports

Shape File Creation

Configuration FilesAttribute Mapping& Check-out layers

ArcPad before and afterArcPad before and after

CheckCheck--Out ReportingOut ReportingWhy Reporting?Why Reporting?

ShapeCheckOutGetTables - Found tables TRANSFORMER BANK and TRANSFORMERUNITShapeCheckOutPopulateChildFlds - Moving unit data from TRANSFORMERUNIT to TRANSFORMER BANKFound 1 recordsParent OID 10741

Found 2 unit recordsUnit OID 44404

Filled OBJECTID11 => 44404Found CREATIONUSER for CREATUSR11 => dwolfingerFound DATECREATED for CREATDT11 => 12/13/2006Found LASTUSER for MODUSR11 => jafajardoFound DATEMODIFIED for MODDT11 => 11/20/2006Found PHASINGCODE for PHSCODE11 => 4Found RATEDKVA for RATEDKVA11 => 25Found STATUS for STATUS11 => INFound TECHIDENTNO for TIDNO11 => 67 AP 83Found SUBTYPECODE for STCDTU11 => 1

Unit OID 44405Filled OBJECTID12 => 44405Found CREATIONUSER for CREATUSR12 => dwolfingerFound DATECREATED for CREATDT12 => 12/13/2006Found LASTUSER for MODUSR12 => jafajardoFound DATEMODIFIED for MODDT12 => 11/20/2006Found PHASINGCODE for PHSCODE12 => 1Found RATEDKVA for RATEDKVA12 => 50Found STATUS for STATUS12 => INFound TECHIDENTNO for TIDNO12 => 69 AO 155Found SUBTYPECODE for STCDTU12 => 1

Flattening units for layer TRANSFORMER BANK

1,TRANSFORMER UNIT,TRANSFORMERUNIT,TRANSFORMERID,OBJECTID,9,3,1,CREATUSR,CREATIONUSER,1,CREATDT,DATECREATED,1,MODUSR,LASTUSER,1,MODDT,DATEMODIFIED,1,PHSCODE,PHASINGCODE,1,RATEDKVA,RATEDKVA,1,STATUS,STATUS,1,TIDNO,TECHIDENTNO,1,STCDTU,SUBTYPECODE,

ShapeCheckOutGetTables - Found tables TRANSFORMER BANK and TRANSFORMERUNIT

ShapeCheckOutDoTableStructure - Proceeding to add new columnsAdded field PHASINGCODE from table TRANSFORMERUNIT to TRANSFORMER BANK as PHSCODE11Added field PHASINGCODE from table TRANSFORMERUNIT to TRANSFORMER BANK as PHSCODE12Added field PHASINGCODE from table TRANSFORMERUNIT to TRANSFORMER BANK as PHSCODE13Added field RATEDKVA from table TRANSFORMERUNIT to TRANSFORMER BANK as RATEDKVA11Added field RATEDKVA from table TRANSFORMERUNIT to TRANSFORMER BANK as RATEDKVA12Added field RATEDKVA from table TRANSFORMERUNIT to TRANSFORMER BANK as RATEDKVA13Added field TECHIDENTNO from table TRANSFORMERUNIT to TRANSFORMER BANK as TIDNO11Added field TECHIDENTNO from table TRANSFORMERUNIT to TRANSFORMER BANK as TIDNO12Added field TECHIDENTNO from table TRANSFORMERUNIT to TRANSFORMER BANK as TIDNO13

===============================================Dataset ElectricDataset*****

134 features written to PrimaryOHLineSection.shp218 features written to SecondaryOHLineSection.shp0 features written to UndergroundStructure.shp0 features written to AbandonedConductor.shp56 features written to Light.shp

*****Dataset LANDBASE

48 features written to StreetCenterline.shpDone copying out shapefiles===============================================

CheckCheck--Out ReportingOut Reporting……

Transformer Bank and Transformer Unit Transformer Bank and Transformer Unit SDE Related Records & SDE Related Records & ““FlattenedFlattened””Transformer Shape file DBF RecordTransformer Shape file DBF Record

Data Collection with Data Collection with Customized ArcPad SoftwareCustomized ArcPad Software

What is being collected?What is being collected?

Custom Tools built in ArcPad to assist Custom Tools built in ArcPad to assist in effective field collectionin effective field collection

Custom Data validations within ArcPadCustom Data validations within ArcPad

– OH electric facilities– Transformer to Customer Tie– Customer locations (Meters) w/use

of SAP data

What is being collected?What is being collected?

Custom Tools built in ArcPad Custom Tools built in ArcPad to assist in effective field to assist in effective field collection collection ……

Customized FormsCustomized Forms

Customized Toolbars Customized Toolbars

Customized Feature PlacementCustomized Feature Placement



Customized Select Feature and EditingCustomized Select Feature and Editing



Customized Select Feature and EditingCustomized Select Feature and Editing

Customized Tool ButtonsCustomized Tool Buttons

Custom Data Validations Custom Data Validations within ArcPad within ArcPad –– ““Add RulesAdd Rules””

ValidationValidation

Business RulesBusiness Rules– Required Fields– Domain Driven Pick Lists

CheckCheck--In Process In Process –– Shape Files to SDEShape Files to SDE

CheckCheck--In FormIn Form

ArcPad to SDE before and after ArcPad to SDE before and after checkcheck--inin

Sustaining RelationshipsSustaining RelationshipsCheckCheck--in Reportingin Reporting

Accomplishments & Accomplishments & Issues OvercomeIssues Overcome

Unit Unit ““ChildChild”” recordsrecordsGeometric NetworkGeometric Network““LooseLoose”” records records –– related table for related table for 1:M relationships1:M relationshipsError trapping in checkError trapping in check--in in ““badbad””geometriesgeometries

Author Contact InformationAuthor Contact InformationJesus NieblasJesus Nieblas -- General SuperintendentIID - Energy Business Improvement Services223 S. WatermanBuilding 6-6AEl Centro, Ca 92243Office (760) [email protected]

Alan GirtenAlan Girten - Project ManagerUtility Data Contractor’s (UDC)831 N. Grand Ave – Suite 200Waukesha, WI 53186Office (262) [email protected]://udcus.com/

customizing arcpad for electric field inventory at imperial ......found techidentno for tidno11...

Documents