{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 6543, "zTolerance": 0.001, "wkid": 103122, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "EnerGovHistoryPoint", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "EnerGovHistoryPoint", "allowTrueCurvesUpdates": false, "displayField": "casenumber", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "modulename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modulename", "length": 50, "alias": "ModuleName", "type": "esriFieldTypeString" }, { "modelName": "caseid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "caseid", "length": 36, "alias": "CaseID", "type": "esriFieldTypeString" }, { "modelName": "casenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casenumber", "length": 50, "alias": "CaseNumber", "type": "esriFieldTypeString" }, { "modelName": "casetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casetype", "length": 50, "alias": "CaseType", "type": "esriFieldTypeString" }, { "modelName": "workclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workclass", "length": 50, "alias": "WorkClass", "type": "esriFieldTypeString" }, { "modelName": "applicationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationdate", "length": 29, "alias": "ApplicationDate", "type": "esriFieldTypeDate" }, { "modelName": "projectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "modelName": "projectname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectname", "length": 50, "alias": "ProjectName", "type": "esriFieldTypeString" }, { "modelName": "gishistoryqueueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gishistoryqueueid", "length": 36, "alias": "GISHistoryQueueID", "type": "esriFieldTypeString" }, { "modelName": "spatialtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialtype", "length": 50, "alias": "SpatialType", "type": "esriFieldTypeString" }, { "modelName": "spatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialid", "length": 50, "alias": "SpatialID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "

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>

Schema:<\/SPAN><\/P>

  • ModuleName<\/SPAN> This describes the EnerGov module where the user created the object (CodeManagement, PermitManagement, PlanManagement).<\/SPAN><\/P><\/LI>

  • CaseID<\/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>

  • CaseNumber<\/SPAN> This is the EnerGov case number (i.e., permit number, plan number, or case number).<\/SPAN><\/P><\/LI>

  • CaseType<\/SPAN> This is the GUID of the case type for permit or plan objects.<\/SPAN><\/P><\/LI>

  • WorkClass<\/SPAN> This is the GUID of the work class for permit or plan objects.<\/SPAN><\/P><\/LI>

  • ApplicationDate<\/SPAN> This is the application date for permits and plans or the opened date for code cases.<\/SPAN><\/P><\/LI>

  • ProjectID<\/SPAN> This is the GUID of the associated project.<\/SPAN><\/P><\/LI>

  • ProjectName<\/SPAN> This is the name of the associated project.<\/SPAN><\/P><\/LI>

  • GISHistoryQueueID<\/SPAN> This is the GUID of the history record in the GISHistoryQueue table.<\/SPAN><\/P><\/LI>

  • SpatialType<\/SPAN> This is the EnerGov spatial type of this history object (Parcel, Address, SpatialCollection, or GISFeatures).<\/SPAN><\/P><\/LI>

  • SpatialID<\/SPAN> This is the unique key value of the spatial element.<\/SPAN><\/P>

    <\/P><\/LI><\/UL><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r20_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a7_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "6ce835dcabdc4867b0c6b23d8365a4a8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 38, 153, 93, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "City of Wilmington", "zDefault": 0, "geometryType": "esriGeometryPoint" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 6543, "zTolerance": 0.001, "wkid": 103122, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "EnerGovHistoryLine", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "EnerGovHistoryLine", "allowTrueCurvesUpdates": false, "displayField": "casenumber", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "modulename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modulename", "length": 50, "alias": "ModuleName", "type": "esriFieldTypeString" }, { "modelName": "caseid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "caseid", "length": 36, "alias": "CaseID", "type": "esriFieldTypeString" }, { "modelName": "casenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casenumber", "length": 50, "alias": "CaseNumber", "type": "esriFieldTypeString" }, { "modelName": "casetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casetype", "length": 50, "alias": "CaseType", "type": "esriFieldTypeString" }, { "modelName": "workclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workclass", "length": 50, "alias": "WorkClass", "type": "esriFieldTypeString" }, { "modelName": "applicationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationdate", "length": 29, "alias": "ApplicationDate", "type": "esriFieldTypeDate" }, { "modelName": "projectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "modelName": "projectname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectname", "length": 50, "alias": "ProjectName", "type": "esriFieldTypeString" }, { "modelName": "gishistoryqueueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gishistoryqueueid", "length": 36, "alias": "GISHistoryQueueID", "type": "esriFieldTypeString" }, { "modelName": "spatialtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialtype", "length": 50, "alias": "SpatialType", "type": "esriFieldTypeString" }, { "modelName": "spatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialid", "length": 50, "alias": "SpatialID", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "

    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>

    Schema:<\/SPAN><\/P>

    • ModuleName<\/SPAN> This describes the EnerGov module where the user created the object (CodeManagement, PermitManagement, PlanManagement).<\/SPAN><\/P><\/LI>

    • CaseID<\/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>

    • CaseNumber<\/SPAN> This is the EnerGov case number (i.e., permit number, plan number, or case number).<\/SPAN><\/P><\/LI>

    • CaseType<\/SPAN> This is the GUID of the case type for permit or plan objects.<\/SPAN><\/P><\/LI>

    • WorkClass<\/SPAN> This is the GUID of the work class for permit or plan objects.<\/SPAN><\/P><\/LI>

    • ApplicationDate<\/SPAN> This is the application date for permits and plans or the opened date for code cases.<\/SPAN><\/P><\/LI>

    • ProjectID<\/SPAN> This is the GUID of the associated project.<\/SPAN><\/P><\/LI>

    • ProjectName<\/SPAN> This is the name of the associated project.<\/SPAN><\/P><\/LI>

    • GISHistoryQueueID<\/SPAN> This is the GUID of the history record in the GISHistoryQueue table.<\/SPAN><\/P><\/LI>

    • SpatialType<\/SPAN> This is the EnerGov spatial type of this history object (Parcel, Address, SpatialCollection, or GISFeatures).<\/SPAN><\/P><\/LI>

    • SpatialID<\/SPAN> This is the unique key value of the spatial element.<\/SPAN><\/P><\/LI><\/UL><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r21_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a8_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "6ce835dcabdc4867b0c6b23d8365a4a8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 66, 135, 98, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "City of Wilmington", "zDefault": 0, "geometryType": "esriGeometryPolyline" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 6543, "zTolerance": 0.001, "wkid": 103122, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "EnerGovHistoryPolygon", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "EnerGovHistoryPolygon", "allowTrueCurvesUpdates": false, "displayField": "casenumber", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "modulename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modulename", "length": 50, "alias": "ModuleName", "type": "esriFieldTypeString" }, { "modelName": "caseid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "caseid", "length": 36, "alias": "CaseID", "type": "esriFieldTypeString" }, { "modelName": "casenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casenumber", "length": 50, "alias": "CaseNumber", "type": "esriFieldTypeString" }, { "modelName": "casetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casetype", "length": 50, "alias": "CaseType", "type": "esriFieldTypeString" }, { "modelName": "workclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workclass", "length": 50, "alias": "WorkClass", "type": "esriFieldTypeString" }, { "modelName": "applicationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationdate", "length": 29, "alias": "ApplicationDate", "type": "esriFieldTypeDate" }, { "modelName": "projectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "modelName": "projectname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectname", "length": 50, "alias": "ProjectName", "type": "esriFieldTypeString" }, { "modelName": "gishistoryqueueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gishistoryqueueid", "length": 36, "alias": "GISHistoryQueueID", "type": "esriFieldTypeString" }, { "modelName": "spatialtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialtype", "length": 50, "alias": "SpatialType", "type": "esriFieldTypeString" }, { "modelName": "spatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialid", "length": 50, "alias": "SpatialID", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "

      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>

      Schema:<\/SPAN><\/P>

      • ModuleName<\/SPAN> This describes the EnerGov module where the user created the object (CodeManagement, PermitManagement, PlanManagement).<\/SPAN><\/P><\/LI>

      • CaseID<\/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>

      • CaseNumber<\/SPAN> This is the EnerGov case number (i.e., permit number, plan number, or case number).<\/SPAN><\/P><\/LI>

      • CaseType<\/SPAN> This is the GUID of the case type for permit or plan objects.<\/SPAN><\/P><\/LI>

      • WorkClass<\/SPAN> This is the GUID of the work class for permit or plan objects.<\/SPAN><\/P><\/LI>

      • ApplicationDate<\/SPAN> This is the application date for permits and plans or the opened date for code cases.<\/SPAN><\/P><\/LI>

      • ProjectID<\/SPAN> This is the GUID of the associated project.<\/SPAN><\/P><\/LI>

      • ProjectName<\/SPAN> This is the name of the associated project.<\/SPAN><\/P><\/LI>

      • GISHistoryQueueID<\/SPAN> This is the GUID of the history record in the GISHistoryQueue table.<\/SPAN><\/P><\/LI>

      • SpatialType<\/SPAN> This is the EnerGov spatial type of this history object (Parcel, Address, SpatialCollection, or GISFeatures).<\/SPAN><\/P><\/LI>

      • SpatialID<\/SPAN> This is the unique key value of the spatial element.<\/SPAN><\/P><\/LI><\/UL><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r22_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a9_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "6ce835dcabdc4867b0c6b23d8365a4a8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 252, 199, 245, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "City of Wilmington", "zDefault": 0, "geometryType": "esriGeometryPolygon" } ] }