Description: <DIV STYLE="text-align:Left;"><DIV><DIV><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><P><SPAN /></P></LI></UL></DIV></DIV></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)
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><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></DIV></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)
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)