{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Agents", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "zip": null, "editor": null, "creator": null, "firstname": null, "creationdate": null, "address": null, "permitid": null, "address2": null, "city": null, "altphone": null, "contactid": null, "busiaddress": null, "lastname": null, "phone": null, "businessname": null, "state": null, "editdate": null, "connectid": null, "email": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Agents", "displayField": "firstname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "FirstName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 20, "alias": "First Name", "type": "esriFieldTypeString" }, { "modelName": "LastName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 30, "alias": "Last Name", "type": "esriFieldTypeString" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 40, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "Address2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address2", "length": 40, "alias": "Address 2", "type": "esriFieldTypeString" }, { "modelName": "City", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 50, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "Zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 10, "alias": "Zip", "type": "esriFieldTypeString" }, { "modelName": "Phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 13, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "Email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 50, "alias": "Email Address", "type": "esriFieldTypeString" }, { "modelName": "AltPhone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altphone", "length": 25, "alias": "Alternate Phone Number", "type": "esriFieldTypeString" }, { "modelName": "BusinessName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 100, "alias": "Business Name", "type": "esriFieldTypeString" }, { "modelName": "contactId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contactid", "length": 100, "alias": "Contact ID", "type": "esriFieldTypeString" }, { "modelName": "permitId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 38, "alias": "permitId", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Connect ID", "type": "esriFieldTypeInteger" }, { "modelName": "BusiAddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "busiaddress", "length": 50, "alias": "Business Address", "type": "esriFieldTypeString" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r16_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_16", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Contractors", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "zip": null, "editor": null, "licensenumber": null, "firstname": null, "creationdate": null, "creator": null, "address": null, "permitid": null, "address2": null, "city": null, "altphone": null, "contactid": null, "altname": null, "altnamenotlisted": null, "lastname": null, "altagent": null, "phone": null, "altaddress": null, "businessname": null, "state": null, "editdate": null, "connectid": null, "email": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Contractors", "displayField": "firstname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "FirstName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 20, "alias": "First Name", "type": "esriFieldTypeString" }, { "modelName": "LastName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 30, "alias": "Last Name", "type": "esriFieldTypeString" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 40, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "Address2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address2", "length": 40, "alias": "Address 2", "type": "esriFieldTypeString" }, { "modelName": "City", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 50, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "Zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 10, "alias": "Zip", "type": "esriFieldTypeString" }, { "modelName": "Phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 13, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "Email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 50, "alias": "Email Address", "type": "esriFieldTypeString" }, { "modelName": "AltAgent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altagent", "length": 40, "alias": "Agent Business Name", "type": "esriFieldTypeString" }, { "modelName": "AltName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altname", "length": 150, "alias": "Legal Owners from Tax Statement", "type": "esriFieldTypeString" }, { "modelName": "AltAddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altaddress", "length": 50, "alias": "Alternate Address", "type": "esriFieldTypeString" }, { "modelName": "AltPhone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altphone", "length": 25, "alias": "Alternate Phone Number", "type": "esriFieldTypeString" }, { "modelName": "AltNameNotListed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altnamenotlisted", "length": 150, "alias": "Additional Legal Owners Not Listed", "type": "esriFieldTypeString" }, { "modelName": "BusinessName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 100, "alias": "Business Name", "type": "esriFieldTypeString" }, { "modelName": "contactId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contactid", "length": 100, "alias": "Contact ID", "type": "esriFieldTypeString" }, { "modelName": "permitId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 38, "alias": "permitId", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Connect ID", "type": "esriFieldTypeInteger" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "modelName": "LicenseNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensenumber", "length": 256, "alias": "License Number", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r19_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_19", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Fees", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "relguid": null, "editor": null, "creator": null, "creationdate": null, "feeamount": null, "refundamount": null, "feetype": null, "amountpaid": null, "editdate": null, "datepaid": null, "paymentmethod": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Fees", "displayField": "refundamount", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "RefundAmount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refundamount", "alias": "Refunded amount", "type": "esriFieldTypeDouble" }, { "modelName": "RelGUID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relguid", "length": 38, "alias": "RelGUID", "type": "esriFieldTypeGUID" }, { "modelName": "FeeType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetype", "length": 20, "alias": "Fee Type", "type": "esriFieldTypeString" }, { "modelName": "FeeAmount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeamount", "alias": "Fee Amount", "type": "esriFieldTypeDouble" }, { "modelName": "DatePaid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datepaid", "length": 29, "alias": "Date Paid", "type": "esriFieldTypeDate" }, { "modelName": "PaymentMethod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paymentmethod", "length": 50, "alias": "Payment Method", "type": "esriFieldTypeString" }, { "modelName": "AmountPaid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "amountpaid", "alias": "Amount Paid", "type": "esriFieldTypeDouble" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r22_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_22", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Owners", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "zip": null, "editor": null, "creator": null, "firstname": null, "creationdate": null, "address": null, "permitid": null, "address2": null, "city": null, "altphone": null, "contactid": null, "altname": null, "altnamenotlisted": null, "lastname": null, "altagent": null, "phone": null, "altaddress": null, "businessname": null, "state": null, "editdate": null, "connectid": null, "email": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Owners", "displayField": "firstname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "FirstName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 150, "alias": "First Name", "type": "esriFieldTypeString" }, { "modelName": "LastName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 150, "alias": "Last Name", "type": "esriFieldTypeString" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 150, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "Address2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address2", "length": 150, "alias": "Address 2", "type": "esriFieldTypeString" }, { "modelName": "City", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 50, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "Zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 10, "alias": "Zip", "type": "esriFieldTypeString" }, { "modelName": "Phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 13, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "Email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 50, "alias": "Email Address", "type": "esriFieldTypeString" }, { "modelName": "AltAgent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altagent", "length": 150, "alias": "Agent Business Name", "type": "esriFieldTypeString" }, { "modelName": "AltName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altname", "length": 150, "alias": "Legal Owners from Tax Statement", "type": "esriFieldTypeString" }, { "modelName": "AltAddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altaddress", "length": 150, "alias": "Alternate Address", "type": "esriFieldTypeString" }, { "modelName": "AltPhone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altphone", "length": 25, "alias": "Alternate Phone Number", "type": "esriFieldTypeString" }, { "modelName": "AltNameNotListed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "altnamenotlisted", "length": 150, "alias": "Additional Legal Owners Not Listed", "type": "esriFieldTypeString" }, { "modelName": "BusinessName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 100, "alias": "Business Name", "type": "esriFieldTypeString" }, { "modelName": "contactId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contactid", "length": 100, "alias": "Contact ID", "type": "esriFieldTypeString" }, { "modelName": "permitId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 38, "alias": "permitId", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Connect ID", "type": "esriFieldTypeInteger" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r17_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_17", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "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" } ], "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Permits", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "affidavitrequired": null, "afterfact": null, "mitigationrequired": null, "commonowner": null, "creationdate": null, "varianceboa": null, "affidavitattached": null, "deadlinedate": null, "mitigationattached": null, "section": null, "permitstatus": null, "lakesclass": null, "inspectiondate": null, "userid": null, "parcelid": null, "sanitarydate": null, "pin": null, "zoning": null, "block": null, "state": null, "dateapproved": null, "previousboapermitnumber": null, "deadlinedate2": null, "relguid": null, "agentid": null, "ownername": null, "contractorid": null, "ownerfirstname": null, "approvedby": null, "datedenied": null, "commonownercomments": null, "refunddate": null, "ownerid": null, "classification": null, "towninputdate": null, "str": null, "volume": null, "bedrooms": null, "deedofrecord": null, "constructioncost": null, "specialpermitnumber": null, "deededacres2": null, "page": null, "conditions": null, "editdate": null, "surveycomments": null, "inspectedby": null, "propertyaddress": null, "signpermitnumber": null, "substandard": null, "issuancedate": null, "city": null, "inspectiondate2": null, "citationdate": null, "conditionalpermitnumber": null, "range": null, "dateapproved2": null, "quarterquarter": null, "lot": null, "overlaydistrict": null, "previousboa": null, "legallycreated": null, "additionallegal": null, "deededacres": null, "statepermit": null, "conversion": null, "revokereason": null, "permittype": null, "dateinspected2": null, "editor": null, "sitecitystate": null, "creator": null, "comments": null, "citation": null, "constcost": null, "conditionsattached": null, "apptype": null, "fordescription": null, "govlots": null, "surveyed": null, "dateinspected": null, "nonconform": null, "permitnumber": null, "septicpermit": null, "boapermitnumber": null, "appdate": null, "connectid": null, "csm": null, "subdcondo": null, "sanitarypermitnumber": null, "ownerlastname": null, "township": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Permits", "displayField": "ownername", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "PermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitnumber", "length": 50, "alias": "Permit number", "type": "esriFieldTypeString" }, { "modelName": "AppType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apptype", "length": 25, "alias": "Application Type", "type": "esriFieldTypeString" }, { "modelName": "PermitType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permittype", "length": 50, "alias": "Permit Type", "type": "esriFieldTypeString" }, { "modelName": "PermitStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitstatus", "length": 50, "alias": "Permit status", "type": "esriFieldTypeString" }, { "modelName": "AppDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "appdate", "length": 29, "alias": "Application Date", "type": "esriFieldTypeDate" }, { "modelName": "InspectionDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "inspectiondate", "length": 29, "alias": "Inspection Date", "type": "esriFieldTypeDate" }, { "modelName": "InspectionDate2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "inspectiondate2", "length": 29, "alias": "Second Inspection Date", "type": "esriFieldTypeDate" }, { "modelName": "DateInspected", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateinspected", "length": 29, "alias": "Date of the Inspection", "type": "esriFieldTypeDate" }, { "modelName": "DateInspected2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateinspected2", "length": 29, "alias": "Second Inspection Date", "type": "esriFieldTypeDate" }, { "modelName": "InspectedBy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectedby", "length": 50, "alias": "Inspected By", "type": "esriFieldTypeString" }, { "modelName": "DateApproved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateapproved", "length": 29, "alias": "Date Approved", "type": "esriFieldTypeDate" }, { "modelName": "DateApproved2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateapproved2", "length": 29, "alias": "Second Date Approved", "type": "esriFieldTypeDate" }, { "modelName": "ApprovedBy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "approvedby", "length": 50, "alias": "Approved By", "type": "esriFieldTypeString" }, { "modelName": "DateDenied", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datedenied", "length": 29, "alias": "Date Denied", "type": "esriFieldTypeDate" }, { "modelName": "IssuanceDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "issuancedate", "length": 29, "alias": "Date the permit was issued", "type": "esriFieldTypeDate" }, { "modelName": "RefundDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "refunddate", "length": 29, "alias": "Permit Refund Date", "type": "esriFieldTypeDate" }, { "modelName": "DeadlineDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "deadlinedate", "length": 29, "alias": "Deadline Date", "type": "esriFieldTypeDate" }, { "modelName": "DeadlineDate2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "deadlinedate2", "length": 29, "alias": "Second Deadline Date", "type": "esriFieldTypeDate" }, { "modelName": "Citation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "citation", "length": 10, "alias": "Citation", "type": "esriFieldTypeString" }, { "modelName": "CitationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "citationdate", "length": 29, "alias": "Date of cititation", "type": "esriFieldTypeDate" }, { "modelName": "TownInputDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "towninputdate", "length": 29, "alias": "Town input date", "type": "esriFieldTypeDate" }, { "modelName": "StatePermit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statepermit", "length": 15, "alias": "State permit number", "type": "esriFieldTypeString" }, { "modelName": "Conditions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditions", "length": 255, "alias": "Conditions", "type": "esriFieldTypeString" }, { "modelName": "ForDescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fordescription", "length": 255, "alias": "ForDescription", "type": "esriFieldTypeString" }, { "modelName": "UserId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "userid", "length": 25, "alias": "User ID", "type": "esriFieldTypeString" }, { "modelName": "OwnerName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownername", "length": 255, "alias": "Owners Name", "type": "esriFieldTypeString" }, { "modelName": "PropertyAddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "propertyaddress", "length": 250, "alias": "Property Address", "type": "esriFieldTypeString" }, { "modelName": "RelGUID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relguid", "length": 38, "alias": "RelGUID", "type": "esriFieldTypeGUID" }, { "modelName": "agentId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "agentid", "length": 38, "alias": "agentId", "type": "esriFieldTypeGUID" }, { "modelName": "ownerId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerid", "length": 38, "alias": "ownerId", "type": "esriFieldTypeGUID" }, { "modelName": "contractorId", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractorid", "length": 38, "alias": "contractorId", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Temp Connect ID", "type": "esriFieldTypeInteger" }, { "modelName": "ConstCost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "constcost", "alias": "Construction Cost", "type": "esriFieldTypeDouble" }, { "modelName": "conversion", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conversion", "length": 5, "alias": "Conversion of of non-residential to residential", "type": "esriFieldTypeString" }, { "modelName": "CSM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "csm", "length": 25, "alias": "CSM Number", "type": "esriFieldTypeString" }, { "modelName": "SiteCityState", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sitecitystate", "length": 100, "alias": "Site City State Zip", "type": "esriFieldTypeString" }, { "modelName": "DeededAcres", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deededacres", "alias": "Deeded Acres", "type": "esriFieldTypeInteger" }, { "modelName": "STR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "str", "length": 15, "alias": "Section Townhip Range", "type": "esriFieldTypeString" }, { "modelName": "SanitaryPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanitarypermitnumber", "length": 25, "alias": "Sanitary Permit Number", "type": "esriFieldTypeString" }, { "modelName": "SignPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "signpermitnumber", "length": 25, "alias": "Sign Permit Number", "type": "esriFieldTypeString" }, { "modelName": "SpecialPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "specialpermitnumber", "length": 25, "alias": "Special Permit Number", "type": "esriFieldTypeString" }, { "modelName": "ConditionalPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditionalpermitnumber", "length": 25, "alias": "Conditional Permit Number", "type": "esriFieldTypeString" }, { "modelName": "BOAPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "boapermitnumber", "length": 25, "alias": "BOA Permit Number", "type": "esriFieldTypeString" }, { "modelName": "RevokeReason", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "revokereason", "length": 255, "alias": "Reason for revocation", "type": "esriFieldTypeString" }, { "modelName": "Pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 100, "alias": "PIN", "type": "esriFieldTypeString" }, { "modelName": "Volume", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "volume", "length": 50, "alias": "Volume", "type": "esriFieldTypeString" }, { "modelName": "Page", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "page", "length": 50, "alias": "Page(s)", "type": "esriFieldTypeString" }, { "modelName": "govLots", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "govlots", "length": 100, "alias": "Govt. Lots", "type": "esriFieldTypeString" }, { "modelName": "Lot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "length": 50, "alias": "Lot(s)", "type": "esriFieldTypeString" }, { "modelName": "Block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 50, "alias": "Block", "type": "esriFieldTypeString" }, { "modelName": "SubdCondo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subdcondo", "length": 255, "alias": "Subdivision", "type": "esriFieldTypeString" }, { "modelName": "quarterQuarter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quarterquarter", "length": 255, "alias": "1/4, 1/4", "type": "esriFieldTypeString" }, { "modelName": "SanitaryDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "sanitarydate", "length": 29, "alias": "Sanitary Date", "type": "esriFieldTypeDate" }, { "modelName": "MitigationRequired", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mitigationrequired", "length": 5, "alias": "Mitigation Required", "type": "esriFieldTypeString" }, { "modelName": "MitigationAttached", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mitigationattached", "length": 5, "alias": "Mitigation Attached", "type": "esriFieldTypeString" }, { "modelName": "SubStandard", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "substandard", "length": 5, "alias": "Sub-Standard Lot", "type": "esriFieldTypeString" }, { "modelName": "CommonOwner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "commonowner", "length": 5, "alias": "Common Ownership", "type": "esriFieldTypeString" }, { "modelName": "NonConform", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nonconform", "length": 5, "alias": "Non-Conforming", "type": "esriFieldTypeString" }, { "modelName": "AffidavitRequired", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "affidavitrequired", "length": 5, "alias": "Affidavit Required", "type": "esriFieldTypeString" }, { "modelName": "AffidavitAttached", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "affidavitattached", "length": 5, "alias": "Affidavit Attached", "type": "esriFieldTypeString" }, { "modelName": "VarianceBOA", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "varianceboa", "length": 5, "alias": "Granted by Variance (BOA)", "type": "esriFieldTypeString" }, { "modelName": "PreviousBOA", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "previousboa", "length": 5, "alias": "Previously Granted by Variance (BOA)", "type": "esriFieldTypeString" }, { "modelName": "LegallyCreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legallycreated", "length": 5, "alias": "Parcel Legally Created", "type": "esriFieldTypeString" }, { "modelName": "Surveyed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surveyed", "length": 5, "alias": "Property Surveyed", "type": "esriFieldTypeString" }, { "modelName": "ConditionsAttached", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditionsattached", "length": 5, "alias": "Conditions Attached", "type": "esriFieldTypeString" }, { "modelName": "Bedrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bedrooms", "length": 2, "alias": "Bedrooms", "type": "esriFieldTypeString" }, { "modelName": "DeedOfRecord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deedofrecord", "length": 25, "alias": "Deed of Record", "type": "esriFieldTypeString" }, { "modelName": "LakesClass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lakesclass", "length": 5, "alias": "Lakes Classification", "type": "esriFieldTypeString" }, { "modelName": "PreviousBOAPermitNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "previousboapermitnumber", "length": 25, "alias": "Previous BOA Permit Number", "type": "esriFieldTypeString" }, { "modelName": "CommonOwnerComments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "commonownercomments", "length": 255, "alias": "Common Ownership Comments", "type": "esriFieldTypeString" }, { "modelName": "SurveyComments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surveycomments", "length": 255, "alias": "Survey Comments", "type": "esriFieldTypeString" }, { "modelName": "OwnerLastName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerlastname", "length": 40, "alias": "Owner's Last Name", "type": "esriFieldTypeString" }, { "modelName": "OwnerFirstName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerfirstname", "length": 40, "alias": "Owner's First Name", "type": "esriFieldTypeString" }, { "modelName": "City", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 50, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "State", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 50, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "Township", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "township", "length": 5, "alias": "Township", "type": "esriFieldTypeString" }, { "modelName": "Range", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "range", "length": 5, "alias": "Range", "type": "esriFieldTypeString" }, { "modelName": "Section", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "section", "length": 5, "alias": "Section", "type": "esriFieldTypeString" }, { "modelName": "ConstructionCost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "constructioncost", "alias": "ConstructionCost", "type": "esriFieldTypeDouble" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 1500, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "modelName": "ParcelID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcelid", "length": 100, "alias": "Parcel ID", "type": "esriFieldTypeString" }, { "modelName": "OverlayDistrict", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "overlaydistrict", "length": 256, "alias": "OverlayDistrict", "type": "esriFieldTypeString" }, { "modelName": "Classification", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "classification", "length": 256, "alias": "Classification", "type": "esriFieldTypeString" }, { "modelName": "Zoning", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zoning", "length": 256, "alias": "Zoning", "type": "esriFieldTypeString" }, { "modelName": "AfterFact", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "afterfact", "length": 5, "alias": "After Fact", "type": "esriFieldTypeString" }, { "modelName": "SepticPermit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "septicpermit", "length": 5, "alias": "Septic Permit", "type": "esriFieldTypeString" }, { "modelName": "AdditionalLegal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "additionallegal", "length": 1000, "alias": "Legal Description", "type": "esriFieldTypeString" }, { "modelName": "DeededAcres2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deededacres2", "alias": "DeededAcres2", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r20_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_20", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Setbacks", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "relguid": null, "editor": null, "creator": null, "creationdate": null, "comments": null, "finalmeasurement": null, "compliance": null, "editdate": null, "type": null, "connectid": null, "initialmeasurement": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Setbacks", "displayField": "type", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "Type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "type", "length": 50, "alias": "Setback Type", "type": "esriFieldTypeString" }, { "modelName": "InitialMeasurement", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "initialmeasurement", "alias": "Initial Measurement", "type": "esriFieldTypeDouble" }, { "modelName": "FinalMeasurement", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "finalmeasurement", "alias": "Final Measurement", "type": "esriFieldTypeDouble" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "Compliance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "compliance", "length": 5, "alias": "Compliance", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "RelGUID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relguid", "length": 38, "alias": "RelGUID", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Temp Connect ID", "type": "esriFieldTypeInteger" }, { "modelName": "CreationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r18_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_18", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "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": false, "supportsLod": 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": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Structures", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "outsideparcelexpl": null, "project": null, "description": null, "additionalfloorarea": null, "sanitarytypedesp": null, "bunksanitary": null, "bunkplumbing": null, "parcelid": null, "typeofconstruction": null, "duration": null, "propusecategory": null, "structuredesp": null, "manufacture_date": null, "firstfloorarea": null, "firststructure": null, "heating": null, "comments2": null, "basementarea": null, "height": null, "expectedstakedate": null, "watersource": null, "comments": null, "stories": null, "length": null, "bunkcooking": null, "heatingexplanation": null, "inspectionstatus": null, "sanitary": null, "structure": null, "bunksleeping": null, "bedrooms": null, "storiesdesp": null, "squarefootage": null, "propusecategoryexpl": null, "projectdesp": null, "sanitarytype": null, "waterdesp": null, "width": null, "connectid": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Structures", "allowTrueCurvesUpdates": false, "displayField": "parcelid", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "ParcelID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcelid", "length": 10, "alias": "Parcel ID", "type": "esriFieldTypeString" }, { "modelName": "Length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length", "alias": "Length", "type": "esriFieldTypeDouble" }, { "modelName": "Width", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "width", "alias": "Width", "type": "esriFieldTypeDouble" }, { "modelName": "SquareFootage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "squarefootage", "alias": "Square Footage", "type": "esriFieldTypeDouble" }, { "modelName": "Height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "Height", "type": "esriFieldTypeDouble" }, { "modelName": "ExpectedStakeDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "expectedstakedate", "length": 29, "alias": "Expected stake date", "type": "esriFieldTypeDate" }, { "modelName": "Bedrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bedrooms", "alias": "Number of bedrooms", "type": "esriFieldTypeInteger" }, { "modelName": "InspectionStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectionstatus", "length": 50, "alias": "Inspection Status", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 700, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Connection ID", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "Project", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project", "length": 50, "alias": "Project Type", "type": "esriFieldTypeString" }, { "modelName": "ProjectDesp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectdesp", "length": 255, "alias": "Project Description", "type": "esriFieldTypeString" }, { "modelName": "Stories", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stories", "length": 10, "alias": "Stories", "type": "esriFieldTypeString" }, { "modelName": "StoriesDesp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "storiesdesp", "length": 255, "alias": "Stories Description", "type": "esriFieldTypeString" }, { "modelName": "Structure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure", "length": 50, "alias": "Structure Placed On", "type": "esriFieldTypeString" }, { "modelName": "StructureDesp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structuredesp", "length": 255, "alias": "Structure Placed On Description", "type": "esriFieldTypeString" }, { "modelName": "Duration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "duration", "length": 25, "alias": "Duration", "type": "esriFieldTypeString" }, { "modelName": "Sanitary", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanitary", "length": 10, "alias": "Sanitary on Property", "type": "esriFieldTypeString" }, { "modelName": "SanitaryType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanitarytype", "length": 50, "alias": "Sanitary Type", "type": "esriFieldTypeString" }, { "modelName": "SanitaryTypeDesp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanitarytypedesp", "length": 255, "alias": "Sanitary Type Description", "type": "esriFieldTypeString" }, { "modelName": "WaterSource", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "watersource", "length": 50, "alias": "Water Source", "type": "esriFieldTypeString" }, { "modelName": "WaterDesp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterdesp", "length": 255, "alias": "Water Source Description", "type": "esriFieldTypeString" }, { "modelName": "FirstStructure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firststructure", "length": 10, "alias": "First Structure", "type": "esriFieldTypeString" }, { "modelName": "PropUseCategory", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "propusecategory", "length": 50, "alias": "Use Category", "type": "esriFieldTypeString" }, { "modelName": "Description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 50, "alias": "Description", "type": "esriFieldTypeString" }, { "modelName": "Comments2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments2", "length": 255, "alias": "Additional Comments", "type": "esriFieldTypeString" }, { "modelName": "BunkCooking", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bunkcooking", "length": 10, "alias": "Bunk House Cooking", "type": "esriFieldTypeString" }, { "modelName": "BunkSleeping", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bunksleeping", "length": 10, "alias": "Bunk House Sleeping", "type": "esriFieldTypeString" }, { "modelName": "BunkSanitary", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bunksanitary", "length": 10, "alias": "Bunk House Sanitary", "type": "esriFieldTypeString" }, { "modelName": "Manufacture_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "manufacture_date", "length": 29, "alias": "Mobile Home Manufacture Date", "type": "esriFieldTypeDate" }, { "modelName": "OutsideParcelExpl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outsideparcelexpl", "length": 255, "alias": "Outside Parcel Explanation", "type": "esriFieldTypeString" }, { "modelName": "BunkPlumbing", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bunkplumbing", "length": 10, "alias": "BunkPlumbing", "type": "esriFieldTypeString" }, { "modelName": "CreationDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "modelName": "BasementArea", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basementarea", "length": 256, "alias": "Basement Area", "type": "esriFieldTypeString" }, { "modelName": "FirstFloorArea", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstfloorarea", "length": 256, "alias": "First Floor Area", "type": "esriFieldTypeString" }, { "modelName": "AdditionalFloorArea", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "additionalfloorarea", "length": 256, "alias": "Additional Floor Area", "type": "esriFieldTypeString" }, { "modelName": "TypeOfConstruction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typeofconstruction", "length": 256, "alias": "Type Of Construction", "type": "esriFieldTypeString" }, { "modelName": "Heating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "heating", "length": 256, "alias": "Heating", "type": "esriFieldTypeString" }, { "modelName": "HeatingExplanation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "heatingexplanation", "length": 256, "alias": "Heating Explanation", "type": "esriFieldTypeString" }, { "modelName": "PropUseCategoryExpl", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "propusecategoryexpl", "length": 1000, "alias": "Proposed Use Explanation", "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": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r24_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_24", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a4_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "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": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 239, 191, 252, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Components", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "relguid": null, "squarefootage": null, "comments": null, "name": null, "length": null, "width": null, "connectid": null, "height": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Components", "allowTrueCurvesUpdates": false, "displayField": "name", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "Length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length", "alias": "Length", "type": "esriFieldTypeInteger" }, { "modelName": "Width", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "width", "alias": "Width", "type": "esriFieldTypeInteger" }, { "modelName": "SquareFootage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "squarefootage", "alias": "Square Footage", "type": "esriFieldTypeInteger" }, { "modelName": "Height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height", "alias": "Height", "type": "esriFieldTypeInteger" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "RelGUID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relguid", "length": 38, "alias": "RelGUID", "type": "esriFieldTypeGUID" }, { "modelName": "ConnectID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connectid", "alias": "Connect ID", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 20, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "CreationDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "Creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "EditDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "Editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 128, "alias": "Editor", "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": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r23_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_23", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a3_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "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": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "8aedbd424a044409acc7a78f10200f0b", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.7, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 199, 222, 252, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }