{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [ { "keyField": "permit_guid", "role": "esriRelRoleDestination", "composite": true, "name": "permits", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Owners", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": {"primary_poc": null} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": true, "name": "Owners", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "owner_name", "domain": null, "name": "owner_name", "alias": "Owner Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "owner_addr", "domain": null, "name": "owner_addr", "alias": "Owner Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 32, "type": "esriFieldTypeString", "modelName": "owner_phone", "domain": null, "name": "owner_phone", "alias": "Phone Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "owner_email", "domain": null, "name": "owner_email", "alias": "Email Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "permit_guid", "domain": null, "name": "permit_guid", "alias": "Permit GUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "Owners_primary_poc_bec9bb6c-c432-4c2d-8a53-c69cde74b48f", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ] }, "name": "primary_poc", "length": 1, "alias": "Primary Point of Contact", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g7716permit_guid", "isUnique": false, "description": "", "fields": "permit_guid", "isAscending": true }, { "name": "r1877_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1877", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9c3b2016f6c04ac88e76f64d40f08adb", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "permit_guid", "role": "esriRelRoleDestination", "composite": true, "name": "permits", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Contractors", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Contractors", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "contractor_name", "domain": null, "name": "contractor_name", "alias": "Contractor Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "contractor_addr", "domain": null, "name": "contractor_addr", "alias": "Contractor Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 32, "type": "esriFieldTypeString", "modelName": "contractor_phone", "domain": null, "name": "contractor_phone", "alias": "Phone Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "contractor_email", "domain": null, "name": "contractor_email", "alias": "Email Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "contractor_license", "domain": null, "name": "contractor_license", "alias": "License" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "contractor_type", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Contractor Type", "description": "Type of contractor", "type": "codedValue", "codedValues": [ { "code": "GEN", "name": "General" }, { "code": "ELEC", "name": "Electric" }, { "code": "ROOF", "name": "Roofing" }, { "code": "PLUM", "name": "Plumbing" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "contractor_type", "alias": "Contractor Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "permit_guid", "domain": null, "name": "permit_guid", "alias": "Permit GUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g7717permit_guid", "isUnique": false, "description": "", "fields": "permit_guid", "isAscending": true }, { "name": "r1878_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1878", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9c3b2016f6c04ac88e76f64d40f08adb", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "permit_guid", "role": "esriRelRoleDestination", "composite": true, "name": "permits", "relatedTableId": 1, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Remarks", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Remarks", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "remark_date", "domain": null, "name": "remark_date", "alias": "Interaction Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "notes", "domain": null, "name": "notes", "alias": "Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "time_spent", "domain": null, "name": "time_spent", "alias": "Time Spent" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "permit_guid", "domain": null, "name": "permit_guid", "alias": "Permit GUID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g7718permit_guid", "isUnique": false, "description": "", "fields": "permit_guid", "isAscending": true }, { "name": "r1879_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1879", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9c3b2016f6c04ac88e76f64d40f08adb", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 1822504.9780496582, "xmin": 965720.8971180804, "ymax": 1822504.9780496582, "xmax": 965720.8971180804, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3435, "zTolerance": 0.001, "wkid": 102671, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "contractors", "relatedTableId": 4, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "inspections", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "owners", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "remarks", "relatedTableId": 2, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": true, "name": "Permits", "allowTrueCurvesUpdates": false, "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "permit_number", "domain": null, "name": "permit_number", "alias": "Permit Number" }, { "nullable": true, "editable": true, "defaultValue": "SUB", "length": 4, "type": "esriFieldTypeString", "modelName": "status", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Permit Status", "description": "Status of a building permit", "type": "codedValue", "codedValues": [ { "code": "SUB", "name": "Submitted" }, { "code": "DENY", "name": "Denied" }, { "code": "HOLD", "name": "Hold" }, { "code": "APPR", "name": "Approved" }, { "code": "REV", "name": "Revoked" }, { "code": "EXP", "name": "Expired" }, { "code": "COMP", "name": "Completed" }, { "code": "PEND", "name": "Pending Approval" }, { "code": "VOID", "name": "Void" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "date_submitted", "domain": null, "name": "date_submitted", "alias": "Submission Date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "permit_year", "domain": null, "name": "permit_year", "alias": "Permit Year" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "construction_type", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Construction Type", "description": "What kind of construction is being permitted", "type": "codedValue", "codedValues": [ { "code": "HOUSE", "name": "House" }, { "code": "GAR", "name": "Garage" }, { "code": "ACC", "name": "Accessory Building" }, { "code": "ADD", "name": "Addition" }, { "code": "REMOD", "name": "Remodeling" }, { "code": "COM_B", "name": "Commercial Building (B)" }, { "code": "COM_M", "name": "Commercial Building (M)" }, { "code": "FARM", "name": "Farm Building" }, { "code": "SIGN", "name": "Sign" }, { "code": "POOL", "name": "Pool" }, { "code": "DECK", "name": "Deck" }, { "code": "DEMO", "name": "Demolition" }, { "code": "ELEC", "name": "Electrical Only" }, { "code": "COMMS", "name": "Communication Tower" }, { "code": "CIO", "name": "Change in Occupancy" }, { "code": "DRIVE", "name": "Driveway" }, { "code": "FIRE", "name": "Fire Restoration" }, { "code": "PATIO", "name": "Patio" }, { "code": "TURB", "name": "Wind Turbine" }, { "code": "FLOOD", "name": "Flood Damage" }, { "code": "GENER", "name": "Generator" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "construction_type", "alias": "Construction Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "pin", "domain": null, "name": "pin", "alias": "PIN" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "site_addr", "domain": null, "name": "site_addr", "alias": "Site Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "site_city", "domain": null, "name": "site_city", "alias": "Postal City" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "site_csz", "domain": null, "name": "site_csz", "alias": "Site City, State, ZIP" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 64, "type": "esriFieldTypeString", "modelName": "high_school_district", "domain": null, "name": "high_school_district", "alias": "High School District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 64, "type": "esriFieldTypeString", "modelName": "fire_district", "domain": null, "name": "fire_district", "alias": "Fire District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 64, "type": "esriFieldTypeString", "modelName": "grade_school_district", "domain": null, "name": "grade_school_district", "alias": "Grade School District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "sign_illuminated", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sign_illuminated", "alias": "Sign Illuminated?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "pool_type", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Pool Type", "description": "What kind of pool", "type": "codedValue", "codedValues": [ { "code": "IG", "name": "In Ground" }, { "code": "AG", "name": "Above Ground" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pool_type", "alias": "Pool Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "building_use", "domain": null, "name": "building_use", "alias": "Intended Use" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "simple_sqft", "domain": null, "name": "simple_sqft", "alias": "Square Feet of Construction" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_flr1", "domain": null, "name": "home_sqft_flr1", "alias": "First Floor Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_flr2", "domain": null, "name": "home_sqft_flr2", "alias": "Second Floor Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_bsmt", "domain": null, "name": "home_sqft_bsmt", "alias": "Basement Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_gar", "domain": null, "name": "home_sqft_gar", "alias": "Garage Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_por", "domain": null, "name": "home_sqft_por", "alias": "Porch Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_sqft_tot", "domain": null, "name": "home_sqft_tot", "alias": "Total Square Feet" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_beds", "domain": null, "name": "home_beds", "alias": "Number of Bedrooms" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "home_baths", "domain": null, "name": "home_baths", "alias": "Number of Bathrooms" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "building_height", "domain": null, "name": "building_height", "alias": "Height of Building" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "est_cost", "domain": null, "name": "est_cost", "alias": "Estimated Cost of Construction" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "review_time", "domain": null, "name": "review_time", "alias": "Time Spent on Review" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "review_remarks", "domain": null, "name": "review_remarks", "alias": "Internal Remarks" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "review_date", "domain": null, "name": "review_date", "alias": "Review Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "paper_required", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "paper_required", "alias": "Paper Plans Required?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "all_info", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "all_info", "alias": "Has Owner Provided All Info?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "name_match", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "name_match", "alias": "Does Owner Name Match Devnet?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "paper_submitted", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "paper_submitted", "alias": "Paper Copy Submitted?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "begin_construction", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "begin_construction", "alias": "Begin Construction?" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "extension", "domain": null, "name": "extension", "alias": "Extend Deadline?" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspections_needed", "domain": null, "name": "inspections_needed", "alias": "Inspections Required" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "inspections_status", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Scheduling Status", "description": "Whether or not scheduling has been completed.", "type": "codedValue", "codedValues": [ { "code": "NONE", "name": "Not scheduled" }, { "code": "SCHED", "name": "Scheduled" }, { "code": "DONE", "name": "Inspections Complete" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inspections_status", "alias": "Inspections Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "zoning", "domain": null, "name": "zoning", "alias": "Zoning" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "flood_zone", "domain": null, "name": "flood_zone", "alias": "Flood Zone" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 32, "type": "esriFieldTypeString", "modelName": "firm_panel", "domain": null, "name": "firm_panel", "alias": "FEMA Firm Panel" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "tax_code", "domain": null, "name": "tax_code", "alias": "Tax Code" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_plan_review", "domain": null, "name": "fee_plan_review", "alias": "Plan Review" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_site_inspection", "domain": null, "name": "fee_site_inspection", "alias": "Site Inspection" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_footing", "domain": null, "name": "fee_footing", "alias": "Footing" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_foundation_wall", "domain": null, "name": "fee_foundation_wall", "alias": "Foundation Wall" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_backfill", "domain": null, "name": "fee_backfill", "alias": "Backfill" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_slab1", "domain": null, "name": "fee_slab1", "alias": "Slab (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_slab2", "domain": null, "name": "fee_slab2", "alias": "Slab (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_meter_socket", "domain": null, "name": "fee_meter_socket", "alias": "Meter Socket" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_insulation", "domain": null, "name": "fee_insulation", "alias": "Insulation" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_final_permit", "domain": null, "name": "fee_final_permit", "alias": "Final" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_occupancy", "domain": null, "name": "fee_occupancy", "alias": "Occupancy" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_sfd", "domain": null, "name": "fee_sfd", "alias": "Single Family Dwelling" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_under_floor", "domain": null, "name": "fee_under_floor", "alias": "Under Floor" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_rough", "domain": null, "name": "fee_rough", "alias": "Rough Rough" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_final_plumbing", "domain": null, "name": "fee_final_plumbing", "alias": "Final" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_zoning_cert", "domain": null, "name": "fee_zoning_cert", "alias": "Zoning Cert" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_address", "domain": null, "name": "fee_address", "alias": "Address" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee1_total", "domain": null, "name": "fee1_total", "alias": "Total Due (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "fee1_paid", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee1_paid", "alias": "Paid (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "fee1_method", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Payment Method_2", "description": "How a fee was paid for", "type": "codedValue", "codedValues": [ { "code": "CA", "name": "Cash" }, { "code": "CK", "name": "Check" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee1_method", "alias": "Payment Method (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "fee1_notes", "domain": null, "name": "fee1_notes", "alias": "Check # / Receipt (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "fee1_date", "domain": null, "name": "fee1_date", "alias": "Date Paid (1)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_school", "domain": null, "name": "fee_school", "alias": "School" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_parks_fp", "domain": null, "name": "fee_parks_fp", "alias": "Parks / Forest Preserve" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee2_total", "domain": null, "name": "fee2_total", "alias": "Total Due (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "fee2_paid", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee2_paid", "alias": "Paid (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "fee2_method", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Payment Method_2", "description": "How a fee was paid for", "type": "codedValue", "codedValues": [ { "code": "CA", "name": "Cash" }, { "code": "CK", "name": "Check" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee2_method", "alias": "Payment Method (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "fee2_date", "domain": null, "name": "fee2_date", "alias": "Date Paid (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "fee2_check", "domain": null, "name": "fee2_check", "alias": "Check # / Receipt (2)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "fee_roadway", "domain": null, "name": "fee_roadway", "alias": "Fee" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "fee3_paid", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes or No", "description": "Boolean, but with Y/N", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee3_paid", "alias": "Paid (3)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "fee3_method", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Payment Method_2", "description": "How a fee was paid for", "type": "codedValue", "codedValues": [ { "code": "CA", "name": "Cash" }, { "code": "CK", "name": "Check" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fee3_method", "alias": "Payment Method (3)" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "fee3_date", "domain": null, "name": "fee3_date", "alias": "Date Paid (3)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "fee3_check", "domain": null, "name": "fee3_check", "alias": "Check # / Receipt (3)" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "r1875_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1875", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1247_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9c3b2016f6c04ac88e76f64d40f08adb", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Approved", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "APPR"} } } ], "name": "Approved", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "APPR" }, { "templates": [ { "name": "Completed", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "COMP"} } } ], "name": "Completed", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "COMP" }, { "templates": [ { "name": "Denied", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "DENY"} } } ], "name": "Denied", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "DENY" }, { "templates": [ { "name": "Expired", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "EXP"} } } ], "name": "Expired", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "EXP" }, { "templates": [ { "name": "Hold", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "HOLD"} } } ], "name": "Hold", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "HOLD" }, { "templates": [ { "name": "Pending Approval", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "PEND"} } } ], "name": "Pending Approval", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "PEND" }, { "templates": [ { "name": "Revoked", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "REV"} } } ], "name": "Revoked", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "REV" }, { "templates": [ { "name": "Submitted", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "SUB"} } } ], "name": "Submitted", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "SUB" }, { "templates": [ { "name": "Void", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"status": "VOID"} } } ], "name": "Void", "domains": { "all_info": {"type": "inherited"}, "begin_construction": {"type": "inherited"}, "inspections_status": {"type": "inherited"}, "sign_illuminated": {"type": "inherited"}, "name_match": {"type": "inherited"}, "fee2_paid": {"type": "inherited"}, "construction_type": {"type": "inherited"}, "fee3_paid": {"type": "inherited"}, "paper_required": {"type": "inherited"}, "paper_submitted": {"type": "inherited"}, "fee3_method": {"type": "inherited"}, "fee1_paid": {"type": "inherited"}, "fee1_method": {"type": "inherited"}, "fee2_method": {"type": "inherited"}, "pool_type": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "VOID" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "status", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "field1": "status", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 249, 252, 182, 255 ], "fromColor": [ 249, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 238, 179, 252, 255 ], "fromColor": [ 238, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 229, 252, 255 ], "fromColor": [ 182, 229, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 179, 255 ], "fromColor": [ 252, 182, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 252, 222, 255 ], "fromColor": [ 189, 252, 222, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 234, 212, 255 ], "fromColor": [ 252, 234, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 212, 241, 255 ], "fromColor": [ 252, 212, 241, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 195, 252, 182, 255 ], "fromColor": [ 195, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 183, 252, 255 ], "fromColor": [ 182, 183, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 212, 252, 250, 255 ], "fromColor": [ 212, 252, 250, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 240, 252, 212, 255 ], "fromColor": [ 240, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 205, 252, 255 ], "fromColor": [ 179, 205, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 179, 210, 255 ], "fromColor": [ 252, 179, 210, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 130, 130, 130, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 204, 252, 189, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Approved", "value": "APPR" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 230, 179, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Completed", "value": "COMP" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 191, 179, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Denied", "value": "DENY" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 189, 241, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Expired", "value": "EXP" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 202, 210, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Hold", "value": "HOLD" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 239, 202, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Pending Approval", "value": "PEND" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 194, 225, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Revoked", "value": "REV" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 194, 252, 222, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Submitted", "value": "SUB" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 186, 182, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Void", "value": "VOID" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 1822682.1466585696, "xmin": 965697.234107662, "ymax": 1822682.1466585696, "xmax": 965697.234107662, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3435, "zTolerance": 0.001, "wkid": 102671, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [ { "keyField": "permit_guid", "role": "esriRelRoleDestination", "composite": true, "name": "permits", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.0.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": true, "name": "Inspections", "allowTrueCurvesUpdates": false, "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "inspection_type", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Inspection Type", "description": "What kind of inspection is being conducted?", "type": "codedValue", "codedValues": [ { "code": "footing", "name": "Footing" }, { "code": "backfill", "name": "Backfill" }, { "code": "foundation_wall", "name": "Foundation Wall" }, { "code": "frame__wire", "name": "Frame / Wire" }, { "code": "plumbing_floor", "name": "Under Floor Plumbing" }, { "code": "plumbing_rough", "name": "Rough Plumbing" }, { "code": "plumbing_final", "name": "Final Plumbing" }, { "code": "slab_1", "name": "Slab (1)" }, { "code": "slab_2", "name": "Slab (2)" }, { "code": "electric", "name": "Electric Service" }, { "code": "insuation", "name": "Insulation" }, { "code": "final__occupancy", "name": "Final / Occupancy" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inspection_type", "alias": "Inspection Type" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "date_entered", "domain": null, "name": "date_entered", "alias": "date_entered" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "date_scheduled", "domain": null, "name": "date_scheduled", "alias": "Scheduled Inspection Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "am_pm", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AM / PM", "description": "Morning or Afternoon", "type": "codedValue", "codedValues": [ { "code": "am", "name": "AM" }, { "code": "pm", "name": "PM" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "am_pm", "alias": "AM or PM" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "date_inspected", "domain": null, "name": "date_inspected", "alias": "Date Inspected" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 64, "type": "esriFieldTypeString", "modelName": "inspector", "domain": null, "name": "inspector", "alias": "Inspected By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "notes_internal", "domain": null, "name": "notes_internal", "alias": "Internal Remarks" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "notes_public", "domain": null, "name": "notes_public", "alias": "Public Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "pass_fail", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Pass / Fail", "description": "Pass or fail", "type": "codedValue", "codedValues": [ { "code": "P", "name": "Pass" }, { "code": "F", "name": "Fail" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pass_fail", "alias": "Pass or Fail" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "driving_time", "domain": null, "name": "driving_time", "alias": "Time Spent Driving" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "inspection_time", "domain": null, "name": "inspection_time", "alias": "Time Spent on Inspection" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspection_device", "domain": null, "name": "inspection_device", "alias": "inspection_device" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "permit_guid", "domain": null, "name": "permit_guid", "alias": "Permit GUID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "g7715permit_guid", "isUnique": false, "description": "", "fields": "permit_guid", "isAscending": true }, { "name": "r1876_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1876", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1248_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9c3b2016f6c04ac88e76f64d40f08adb", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Backfill", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "backfill"} } } ], "name": "Backfill", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "backfill" }, { "templates": [ { "name": "Electric Service", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "electric"} } } ], "name": "Electric Service", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "electric" }, { "templates": [ { "name": "Final / Occupancy", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "final__occupancy"} } } ], "name": "Final / Occupancy", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "final__occupancy" }, { "templates": [ { "name": "Footing", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "footing"} } } ], "name": "Footing", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "footing" }, { "templates": [ { "name": "Foundation Wall", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "foundation_wall"} } } ], "name": "Foundation Wall", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "foundation_wall" }, { "templates": [ { "name": "Frame / Wire", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "frame__wire"} } } ], "name": "Frame / Wire", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "frame__wire" }, { "templates": [ { "name": "Insulation", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "insuation"} } } ], "name": "Insulation", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "insuation" }, { "templates": [ { "name": "Final Plumbing", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "plumbing_final"} } } ], "name": "Final Plumbing", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "plumbing_final" }, { "templates": [ { "name": "Under Floor Plumbing", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "plumbing_floor"} } } ], "name": "Under Floor Plumbing", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "plumbing_floor" }, { "templates": [ { "name": "Rough Plumbing", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "plumbing_rough"} } } ], "name": "Rough Plumbing", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "plumbing_rough" }, { "templates": [ { "name": "Slab (1)", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "slab_1"} } } ], "name": "Slab (1)", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "slab_1" }, { "templates": [ { "name": "Slab (2)", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"inspection_type": "slab_2"} } } ], "name": "Slab (2)", "domains": { "am_pm": {"type": "inherited"}, "pass_fail": {"type": "inherited"}, "inspection_type": {"type": "inherited"} }, "id": "slab_2" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "inspection_type", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "field1": "inspection_type", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 249, 252, 182, 255 ], "fromColor": [ 249, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 238, 179, 252, 255 ], "fromColor": [ 238, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 229, 252, 255 ], "fromColor": [ 182, 229, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 179, 255 ], "fromColor": [ 252, 182, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 252, 222, 255 ], "fromColor": [ 189, 252, 222, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 234, 212, 255 ], "fromColor": [ 252, 234, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 212, 241, 255 ], "fromColor": [ 252, 212, 241, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 195, 252, 182, 255 ], "fromColor": [ 195, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 183, 252, 255 ], "fromColor": [ 182, 183, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 212, 252, 250, 255 ], "fromColor": [ 212, 252, 250, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 240, 252, 212, 255 ], "fromColor": [ 240, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 205, 252, 255 ], "fromColor": [ 179, 205, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 179, 210, 255 ], "fromColor": [ 252, 179, 210, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 130, 130, 130, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 214, 207, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Backfill", "value": "backfill" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 189, 252, 179, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Electric Service", "value": "electric" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 220, 189, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Final / Occupancy", "value": "final__occupancy" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 184, 252, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Footing", "value": "footing" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 182, 198, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Foundation Wall", "value": "foundation_wall" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 182, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Frame / Wire", "value": "frame__wire" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 248, 252, 184, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Insulation", "value": "insuation" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 222, 252, 215, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Final Plumbing", "value": "plumbing_final" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 215, 237, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Under Floor Plumbing", "value": "plumbing_floor" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 201, 179, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Rough Plumbing", "value": "plumbing_rough" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 189, 224, 252, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Slab (1)", "value": "slab_1" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 252, 210, 204, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Slab (2)", "value": "slab_2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }