View In:   ArcGIS Online Map Viewer

Name: EnerGovHistoryPolygon

Display Field: casenumber

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: <DIV STYLE="text-align:Left;"><P><SPAN>The goal of EnerGov GIS History writer is to capture the shape of attached features (parcels, addresses, etc.) along with critical metadata at the time of case creation. This allows users to see all the cases that occurred on a particular plot of land without having to sift through the history of parcels as number changes occur and/or subdivisions develop. Once written to SDE, History data does not change with updates made to the underlying cases.</SPAN></P><P><SPAN>Schema:</SPAN></P><UL><LI><P><SPAN STYLE="font-weight:bold;">ModuleName</SPAN><SPAN> This describes the EnerGov module where the user created the object (CodeManagement, PermitManagement, PlanManagement).</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">CaseID</SPAN><SPAN> This is the GUID of the case in the EnerGov database. Determine the specific table relationship by looking at the MODULENAME field (i.e., PermitManagement relates to the PMPermit table; CodeManagement relates to the CMCode table; PlanManagement relates to the PLPlan table.).</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">CaseNumber</SPAN><SPAN> This is the EnerGov case number (i.e., permit number, plan number, or case number).</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">CaseType</SPAN><SPAN> This is the GUID of the case type for permit or plan objects.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">WorkClass</SPAN><SPAN> This is the GUID of the work class for permit or plan objects.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">ApplicationDate</SPAN><SPAN> This is the application date for permits and plans or the opened date for code cases.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">ProjectID</SPAN><SPAN> This is the GUID of the associated project.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">ProjectName</SPAN><SPAN> This is the name of the associated project.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">GISHistoryQueueID</SPAN><SPAN> This is the GUID of the history record in the GISHistoryQueue table.</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">SpatialType</SPAN><SPAN> This is the EnerGov spatial type of this history object (Parcel, Address, SpatialCollection, or GISFeatures).</SPAN></P></LI><LI><P><SPAN STYLE="font-weight:bold;">SpatialID</SPAN><SPAN> This is the unique key value of the spatial element.</SPAN></P></LI></UL></DIV>

Service Item Id: 6ce835dcabdc4867b0c6b23d8365a4a8

Copyright Text: City of Wilmington

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 103122  (6543)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [252, 199, 245, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• modulename ( modelName: modulename, nullable: true, editable: true, defaultValue: null, length: 50, alias: ModuleName, type: esriFieldTypeString )
• caseid ( modelName: caseid, nullable: true, editable: true, defaultValue: null, length: 36, alias: CaseID, type: esriFieldTypeString )
• casenumber ( modelName: casenumber, nullable: true, editable: true, defaultValue: null, length: 50, alias: CaseNumber, type: esriFieldTypeString )
• casetype ( modelName: casetype, nullable: true, editable: true, defaultValue: null, length: 50, alias: CaseType, type: esriFieldTypeString )
• workclass ( modelName: workclass, nullable: true, editable: true, defaultValue: null, length: 50, alias: WorkClass, type: esriFieldTypeString )
• applicationdate ( modelName: applicationdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: ApplicationDate, type: esriFieldTypeDate )
• projectid ( modelName: projectid, nullable: true, editable: true, defaultValue: null, length: 50, alias: ProjectID, type: esriFieldTypeString )
• projectname ( modelName: projectname, nullable: true, editable: true, defaultValue: null, length: 50, alias: ProjectName, type: esriFieldTypeString )
• gishistoryqueueid ( modelName: gishistoryqueueid, nullable: true, editable: true, defaultValue: null, length: 36, alias: GISHistoryQueueID, type: esriFieldTypeString )
• spatialtype ( modelName: spatialtype, nullable: true, editable: true, defaultValue: null, length: 50, alias: SpatialType, type: esriFieldTypeString )
• spatialid ( modelName: spatialid, nullable: true, editable: true, defaultValue: null, length: 50, alias: SpatialID, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: EnerGovHistoryPolygon
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata