{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Soil Profile", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "new_address": null, "cama_zip": null, "reason": null, "dig_phone": null, "cama_owner": null, "cama_city": null, "analysis_by": null, "cama_address": null, "req_system": null, "soilprofile_info": null, "testhole_dig": null, "dig_date_time": null, "cama_state": null, "num_bedrooms": null, "uniqueid": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Soil Profile", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "modelName": "cama_owner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_owner", "length": 255, "alias": "Landowner", "type": "esriFieldTypeString" }, { "modelName": "cama_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_address", "length": 255, "alias": "Mailing Address", "type": "esriFieldTypeString" }, { "modelName": "cama_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_city", "length": 255, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "cama_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "cama_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_zip", "length": 255, "alias": "cama_zip", "type": "esriFieldTypeString" }, { "modelName": "req_system", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "req_system", "length": 255, "alias": "Requested System", "type": "esriFieldTypeString" }, { "modelName": "reason", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reason", "length": 255, "alias": "Reason for Profile", "type": "esriFieldTypeString" }, { "modelName": "testhole_dig", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "testhole_dig", "length": 255, "alias": "Who will dig the test hole?", "type": "esriFieldTypeString" }, { "modelName": "dig_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dig_phone", "length": 255, "alias": "Phone Number", "type": "esriFieldTypeString" }, { "modelName": "dig_date_time", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dig_date_time", "length": 29, "alias": "dig_date_time", "type": "esriFieldTypeDate" }, { "modelName": "num_bedrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_bedrooms", "alias": "num_bedrooms", "type": "esriFieldTypeInteger" }, { "modelName": "soilprofile_info", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "soilprofile_info", "length": 255, "alias": "soilprofile_info", "type": "esriFieldTypeString" }, { "modelName": "new_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "new_address", "length": 255, "alias": "New Address", "type": "esriFieldTypeString" }, { "modelName": "analysis_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "analysis_by", "length": 255, "alias": "Analysis by", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2621uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r476_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_476", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Building Site Only Permit", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "proposed_use": null, "approved_by": null, "dim_height": null, "improvement_type": null, "work_desc": null, "dim_width": null, "begin_date": null, "improvement_other": null, "approved_date": null, "dim_length": null, "uniqueid": null, "landowner": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Building Site Only Permit", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "proposed_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_use", "length": 255, "alias": "Proposed Use", "type": "esriFieldTypeString" }, { "modelName": "improvement_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "improvement_type", "length": 255, "alias": "Type of Improvement", "type": "esriFieldTypeString" }, { "modelName": "improvement_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "improvement_other", "length": 255, "alias": "Other", "type": "esriFieldTypeString" }, { "modelName": "work_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_desc", "length": 1000, "alias": "Work Description", "type": "esriFieldTypeString" }, { "modelName": "dim_length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_length", "alias": "Length", "type": "esriFieldTypeDouble" }, { "modelName": "dim_width", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_width", "alias": "Width", "type": "esriFieldTypeDouble" }, { "modelName": "dim_height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_height", "alias": "Height", "type": "esriFieldTypeDouble" }, { "modelName": "begin_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "begin_date", "length": 29, "alias": "begin_date", "type": "esriFieldTypeDate" }, { "modelName": "approved_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "approved_by", "length": 255, "alias": "Approved By", "type": "esriFieldTypeString" }, { "modelName": "approved_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "approved_date", "length": 29, "alias": "approved_date", "type": "esriFieldTypeDate" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "uniqueid", "type": "esriFieldTypeGUID" }, { "modelName": "landowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landowner", "length": 255, "alias": "Landowner", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2623uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r478_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_478", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Building Permit", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "hvac": null, "proposed_use": null, "electrician_self": null, "jobsite_city": null, "electrician": null, "general_self": null, "begin_date": null, "work_desc": null, "permit_fee": null, "jobsite_address": null, "general_contractor": null, "hvac_self": null, "electrician_phone": null, "issued_date": null, "improvement_type": null, "foundation_self": null, "total_fee": null, "finaled_by": null, "mail_address": null, "dim_length": null, "uniqueid": null, "mail_state": null, "other_contractor": null, "issued_by": null, "foundation_contractor": null, "general_phone": null, "plumbing_self": null, "plumbing_phone": null, "contractor_types": null, "mail_city": null, "hvac_phone": null, "finaled_date": null, "other_phone": null, "plumbing": null, "mail_zip": null, "contractor_data": null, "dim_height": null, "dim_width": null, "foundation_phone": null, "project_value": null, "landowner": null, "other_self_contractor": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Building Permit", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "project_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_value", "alias": "Value of Project", "type": "esriFieldTypeDouble" }, { "modelName": "landowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landowner", "length": 255, "alias": "Landowner", "type": "esriFieldTypeString" }, { "modelName": "jobsite_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_address", "length": 255, "alias": "Jobsite Address", "type": "esriFieldTypeString" }, { "modelName": "jobsite_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_city", "length": 255, "alias": "Jobsite City", "type": "esriFieldTypeString" }, { "modelName": "mail_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_address", "length": 255, "alias": "Permit Mailing Address", "type": "esriFieldTypeString" }, { "modelName": "mail_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_city", "length": 255, "alias": "Mailing City", "type": "esriFieldTypeString" }, { "modelName": "mail_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_state", "length": 255, "alias": "Mailing State", "type": "esriFieldTypeString" }, { "modelName": "mail_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_zip", "length": 255, "alias": "Mailing Zip Code", "type": "esriFieldTypeString" }, { "modelName": "general_contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "general_contractor", "length": 255, "alias": "General Contractor", "type": "esriFieldTypeString" }, { "modelName": "general_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "general_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "foundation_contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "foundation_contractor", "length": 255, "alias": "Foundation", "type": "esriFieldTypeString" }, { "modelName": "foundation_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "foundation_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "electrician", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician", "length": 255, "alias": "Electrician", "type": "esriFieldTypeString" }, { "modelName": "electrician_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "hvac", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hvac", "length": 255, "alias": "HVAC", "type": "esriFieldTypeString" }, { "modelName": "hvac_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hvac_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "other_contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_contractor", "length": 255, "alias": "Other", "type": "esriFieldTypeString" }, { "modelName": "other_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "proposed_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_use", "length": 255, "alias": "Proposed Use", "type": "esriFieldTypeString" }, { "modelName": "improvement_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "improvement_type", "length": 255, "alias": "Type of Improvement", "type": "esriFieldTypeString" }, { "modelName": "begin_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "begin_date", "length": 29, "alias": "begin_date", "type": "esriFieldTypeDate" }, { "modelName": "work_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_desc", "length": 1000, "alias": "Work Description", "type": "esriFieldTypeString" }, { "modelName": "issued_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issued_by", "length": 255, "alias": "Issued By", "type": "esriFieldTypeString" }, { "modelName": "issued_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "issued_date", "length": 29, "alias": "issued_date", "type": "esriFieldTypeDate" }, { "modelName": "finaled_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "finaled_by", "length": 255, "alias": "finaled_by", "type": "esriFieldTypeString" }, { "modelName": "finaled_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "finaled_date", "length": 29, "alias": "finaled_date", "type": "esriFieldTypeDate" }, { "modelName": "dim_length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_length", "alias": "Length", "type": "esriFieldTypeDouble" }, { "modelName": "dim_width", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_width", "alias": "Width", "type": "esriFieldTypeDouble" }, { "modelName": "dim_height", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dim_height", "alias": "Height", "type": "esriFieldTypeDouble" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "modelName": "contractor_data", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_data", "length": 255, "alias": "contractor_data", "type": "esriFieldTypeString" }, { "modelName": "contractor_types", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_types", "length": 255, "alias": "contractor_types", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "general_self", "length": 256, "alias": "General Self Contracting", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "foundation_self", "length": 256, "alias": "Foundation Self Contracting", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "electrician_self", "length": 256, "alias": "Electrician Self Contractor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hvac_self", "length": 256, "alias": "HVAC Self Contracting", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "other_self_contractor", "length": 256, "alias": "Self Contracting", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "permit_fee", "alias": "Permit Fee", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "total_fee", "alias": "Total Permit Fee", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "plumbing", "length": 256, "alias": "Plumbing", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "plumbing_phone", "length": 256, "alias": "Plumbing Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "plumbing_self", "length": 256, "alias": "Plumbing Self Contracting", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2625uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r480_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_480", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Solar Permit", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "proposed_use": null, "jobsite_city": null, "electrician": null, "other": null, "begin_date": null, "work_desc": null, "jobsite_address": null, "general_contractor": null, "electrician_phone": null, "issued_date": null, "finaled_by": null, "mail_address": null, "disclaimer": null, "uniqueid": null, "mail_state": null, "issued_by": null, "proposed_use_other": null, "general_phone": null, "contractor_types": null, "mail_city": null, "finaled_date": null, "other_phone": null, "mail_zip": null, "contractor_data": null, "project_value": null, "landowner": null, "disclaimer_agreement": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Solar Permit", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "project_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_value", "alias": "Value of Project", "type": "esriFieldTypeDouble" }, { "modelName": "landowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landowner", "length": 255, "alias": "Landowner", "type": "esriFieldTypeString" }, { "modelName": "jobsite_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_address", "length": 255, "alias": "Jobsite Address", "type": "esriFieldTypeString" }, { "modelName": "jobsite_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_city", "length": 255, "alias": "Jobsite City", "type": "esriFieldTypeString" }, { "modelName": "mail_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_address", "length": 255, "alias": "Mailing Address", "type": "esriFieldTypeString" }, { "modelName": "mail_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_city", "length": 255, "alias": "Mailing City", "type": "esriFieldTypeString" }, { "modelName": "mail_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_state", "length": 255, "alias": "Mailing State", "type": "esriFieldTypeString" }, { "modelName": "mail_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_zip", "length": 255, "alias": "Mailing Zip Code", "type": "esriFieldTypeString" }, { "modelName": "general_contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "general_contractor", "length": 255, "alias": "General Contractor", "type": "esriFieldTypeString" }, { "modelName": "general_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "general_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "electrician", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician", "length": 255, "alias": "Electrician", "type": "esriFieldTypeString" }, { "modelName": "electrician_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other", "length": 255, "alias": "Other", "type": "esriFieldTypeString" }, { "modelName": "other_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "proposed_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_use", "length": 255, "alias": "Proposed Use", "type": "esriFieldTypeString" }, { "modelName": "disclaimer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "disclaimer", "length": 255, "alias": "Disclaimer", "type": "esriFieldTypeString" }, { "modelName": "disclaimer_agreement", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "disclaimer_agreement", "length": 255, "alias": "Disclaimer Agreement", "type": "esriFieldTypeString" }, { "modelName": "begin_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "begin_date", "length": 29, "alias": "Estimated begin date", "type": "esriFieldTypeDate" }, { "modelName": "work_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_desc", "length": 1000, "alias": "Work Description", "type": "esriFieldTypeString" }, { "modelName": "issued_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issued_by", "length": 255, "alias": "Issued By", "type": "esriFieldTypeString" }, { "modelName": "issued_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "issued_date", "length": 29, "alias": "Issued Date", "type": "esriFieldTypeDate" }, { "modelName": "finaled_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "finaled_by", "length": 255, "alias": "Finaled By", "type": "esriFieldTypeString" }, { "modelName": "finaled_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "finaled_date", "length": 29, "alias": "Finaled Date", "type": "esriFieldTypeDate" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "modelName": "contractor_data", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_data", "length": 255, "alias": "contractor_data", "type": "esriFieldTypeString" }, { "modelName": "contractor_types", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_types", "length": 255, "alias": "contractor_types", "type": "esriFieldTypeString" }, { "modelName": "proposed_use_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_use_other", "length": 255, "alias": "proposed_use_other", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2626uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r481_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_481", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Well or Sewer Permit", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "contractor": null, "contractor_phone": null, "issued_by": null, "jobsite_city": null, "electrician": null, "stake_date": null, "num_beds": null, "mail_city": null, "jobsite_address": null, "finaled_date": null, "mail_zip": null, "installer_grading": null, "electrician_phone": null, "owner_grading": null, "contractor_data": null, "issued_date": null, "partial_rework": null, "finaled_by": null, "new_installation": null, "mail_address": null, "landowner": null, "uniqueid": null, "mail_state": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Well or Sewer Permit", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "landowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landowner", "length": 255, "alias": "Landowner", "type": "esriFieldTypeString" }, { "modelName": "jobsite_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_address", "length": 255, "alias": "Jobsite Address", "type": "esriFieldTypeString" }, { "modelName": "jobsite_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "jobsite_city", "length": 255, "alias": "Jobsite City", "type": "esriFieldTypeString" }, { "modelName": "mail_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_address", "length": 255, "alias": "Mailing Address", "type": "esriFieldTypeString" }, { "modelName": "mail_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_city", "length": 255, "alias": "Mailing City", "type": "esriFieldTypeString" }, { "modelName": "mail_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_state", "length": 255, "alias": "Mailing State", "type": "esriFieldTypeString" }, { "modelName": "mail_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mail_zip", "length": 255, "alias": "Mailing Zip Code", "type": "esriFieldTypeString" }, { "modelName": "contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor", "length": 255, "alias": "Contractor", "type": "esriFieldTypeString" }, { "modelName": "contractor_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "electrician", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician", "length": 255, "alias": "Electrician", "type": "esriFieldTypeString" }, { "modelName": "electrician_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electrician_phone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "stake_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "stake_date", "length": 29, "alias": "Date Lagoon/Septic/Well will be staked out", "type": "esriFieldTypeDate" }, { "modelName": "issued_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issued_by", "length": 255, "alias": "Issued By", "type": "esriFieldTypeString" }, { "modelName": "issued_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "issued_date", "length": 29, "alias": "issued_date", "type": "esriFieldTypeDate" }, { "modelName": "finaled_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "finaled_by", "length": 255, "alias": "Finaled By", "type": "esriFieldTypeString" }, { "modelName": "finaled_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "finaled_date", "length": 29, "alias": "Finaled Date", "type": "esriFieldTypeDate" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "modelName": "new_installation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "new_installation", "length": 255, "alias": "new_installation", "type": "esriFieldTypeString" }, { "modelName": "partial_rework", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "partial_rework", "length": 255, "alias": "partial_rework", "type": "esriFieldTypeString" }, { "modelName": "owner_grading", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_grading", "length": 255, "alias": "owner_grading", "type": "esriFieldTypeString" }, { "modelName": "installer_grading", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installer_grading", "length": 255, "alias": "installer_grading", "type": "esriFieldTypeString" }, { "modelName": "num_beds", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "num_beds", "alias": "num_beds", "type": "esriFieldTypeInteger" }, { "modelName": "contractor_data", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_data", "length": 255, "alias": "contractor_data", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2624uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r479_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_479", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Inspection Request", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "contractor": null, "contractor_phone": null, "request_status": null, "firstname": " ", "inspection_date": -2209161600000, "scheduled_date": null, "assignedto": null, "lastname": " ", "contractor_data": null, "am_pm": " ", "phone_number": " ", "inspection_type": null, "landowner": null, "uniqueid": null, "email": " " } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Inspection Request", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "modelName": "firstname", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 255, "alias": "First Name", "type": "esriFieldTypeString" }, { "modelName": "lastname", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 255, "alias": "Last Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspection_type", "domain": { "name": "Inspection Request_inspection_type_938df181-5b49-4ca0-89ee-0d82801a77a5", "type": "codedValue", "codedValues": [ { "code": "site_check", "name": "Site-Check" }, { "code": "footing", "name": "Footing" }, { "code": "ufer_ground", "name": "UFER Ground" }, { "code": "under_slab_plumbing", "name": "Under Slab Plumbing" }, { "code": "under_slab_electric", "name": "Under Slab Electric" }, { "code": "foundation_wall", "name": "Foundation Wall" }, { "code": "piers_interior_exterior", "name": "Piers Interior/Exterior" }, { "code": "post_holes", "name": "Post Holes" }, { "code": "construction_meter", "name": "Construction Meter" }, { "code": "sub_floor_framing", "name": "Sub-Floor Framing" }, { "code": "framing", "name": "Framing" }, { "code": "fire_resistant_penetrations", "name": "Fire-Resistant Penetrations" }, { "code": "fireplace", "name": "Fireplace - First Floor/Other Floor" }, { "code": "Deck Framing", "name": "deck_framing" }, { "code": "under_ground_electric", "name": "Under Ground Electrical Conduit" }, { "code": "rough_in_electric", "name": "Rough-In Electric" }, { "code": "rough_in_water", "name": "Rough-In Water" }, { "code": "rough_in_waste", "name": "Rough-In Waste Drain Vents" }, { "code": "rough_in_gas", "name": "Rough-In Gas" }, { "code": "rough_in_mechanical", "name": "Rough-In Mechanical" }, { "code": "exhaust_fans", "name": "Exhaust Fans - to the outside" }, { "code": "under_ground_sewer", "name": "Under Ground Sewer Line" }, { "code": "meter_release", "name": "Meter Release" }, { "code": "roof", "name": "Roof" }, { "code": "siding", "name": "Siding" } ] }, "name": "inspection_type", "alias": "Inspection Type" }, { "modelName": "inspection_date", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "inspection_date", "length": 29, "alias": "Inspection Date", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "am_pm", "domain": { "name": "Inspection Request_am_pm_7ad68dd8-9309-4e81-8617-a75f46a18727", "type": "codedValue", "codedValues": [ { "code": "am", "name": "AM" }, { "code": "pm", "name": "PM" } ] }, "name": "am_pm", "alias": "AM or PM" }, { "modelName": "phone_number", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "phone_number", "length": 255, "alias": "Phone Number", "type": "esriFieldTypeString" }, { "modelName": "email", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 255, "alias": "Email Address", "type": "esriFieldTypeString" }, { "modelName": "contractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor", "length": 255, "alias": "Contractor", "type": "esriFieldTypeString" }, { "modelName": "contractor_phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_phone", "length": 255, "alias": "Contractor Phone", "type": "esriFieldTypeString" }, { "modelName": "landowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landowner", "length": 255, "alias": "Landowner", "type": "esriFieldTypeString" }, { "modelName": "contractor_data", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_data", "length": 255, "alias": "contractor_data", "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": 255, "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": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "scheduled_date", "length": 29, "alias": "Scheduled Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "description": "{\"fieldValueType\":\"typeOrCategory\",\"value\":\"\"}", "type": "esriFieldTypeString", "domain": { "name": "Inspection Request_request_status_6179aa70-3fff-480a-8256-0a5924f74cd2", "type": "codedValue", "codedValues": [ { "code": "Scheduled", "name": "Scheduled" }, { "code": "Complete", "name": "Complete" } ] }, "name": "request_status", "alias": "Request Status" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "Inspection Request_assignedto_9a259c5b-6a71-42d2-822c-7244c4a304f9", "type": "codedValue", "codedValues": [ { "code": "Tim Moore", "name": "Tim Moore" }, { "code": "Eli Flower", "name": "Eli Flower" } ] }, "name": "assignedto", "length": 256, "alias": "Assigned To", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2627uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r482_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_482", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": [ { "keyField": "uniqueid", "role": "esriRelRoleDestination", "composite": false, "name": "Permits", "relatedTableId": 3, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Inspections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "inspection_notes": null, "inspection_type": null, "uniqueid": null, "inspection_status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Inspections", "displayField": "inspection_type", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspection_type", "domain": { "name": "Inspections_inspection_type_bd7abec3-f728-4f85-8a68-8c20dc5666e2", "type": "codedValue", "codedValues": [ { "code": "Site-Check", "name": "Site-Check" }, { "code": "Footing", "name": "Footing" }, { "code": "UFER Ground", "name": "UFER Ground" }, { "code": "Under Slab Electric", "name": "Under Slab Electric" }, { "code": "Foundation Wall", "name": "Foundation Wall" }, { "code": "Piers", "name": "Piers" }, { "code": "Post Holes", "name": "Post Holes" }, { "code": "Construction Meter", "name": "Construction Meter" }, { "code": "Sub-Floor Framing", "name": "Sub-Floor Framing" }, { "code": "Fire-Resistant Penetrations", "name": "Fire-Resistant Penetrations" }, { "code": "Fireplace", "name": "Fireplace" }, { "code": "Deck Framing", "name": "Deck Framing" }, { "code": "Under Ground Electrical Conduit", "name": "Under Ground Electrical Conduit" }, { "code": "Rough-In Electric", "name": "Rough-In Electric" }, { "code": "Rough-In Water", "name": "Rough-In Water" }, { "code": "Rough-In Waste Drain Vents", "name": "Rough-In Waste Drain Vents" }, { "code": "Rough-In Gas", "name": "Rough-In Gas" }, { "code": "Rough-In Mechanical", "name": "Rough-In Mechanical" }, { "code": "Exhaust Fans", "name": "Exhaust Fans" }, { "code": "Under Ground Sewer Line", "name": "Under Ground Sewer Line" }, { "code": "Meter Release", "name": "Meter Release" }, { "code": "Roof", "name": "Roof" }, { "code": "Siding", "name": "Siding" }, { "code": "Final Lagoon/Septic/Alternative", "name": "Final Lagoon/Septic/Alternative" }, { "code": "Final", "name": "Final" } ] }, "name": "inspection_type", "alias": "Inspection Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspection_status", "domain": { "name": "Inspections_inspection_status_4c6469da-e544-4e36-8787-925d78534435", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "inspection_status", "alias": "Inspection Status" }, { "modelName": "inspection_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspection_notes", "length": 1000, "alias": "Inspection Notes", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "uniqueid", "type": "esriFieldTypeGUID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g2622uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r477_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_477", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": 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": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniqueid", "role": "esriRelRoleOrigin", "composite": false, "name": "buildingpermit", "relatedTableId": 6, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniqueid", "role": "esriRelRoleOrigin", "composite": false, "name": "buildingsiteonly", "relatedTableId": 5, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "SoilProfile", "relatedTableId": 4, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "inspections", "relatedTableId": 10, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniqueid", "role": "esriRelRoleOrigin", "composite": false, "name": "solarpermit", "relatedTableId": 7, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniqueid", "role": "esriRelRoleOrigin", "composite": false, "name": "inspection_request", "relatedTableId": 9, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniqueid", "role": "esriRelRoleOrigin", "composite": false, "name": "well_sewer", "relatedTableId": 8, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Permits", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "cama_zip": null, "firstname": null, "buildingsiteonlypermit": "No", "cama_owner": null, "inspections": "No", "open_closed": "Open", "cama_address": null, "floodplain": null, "zoning": null, "parcel_data": null, "cama": null, "cama_state": null, "uniqueid": null, "payment_recieved": "No", "crossroadeast": null, "environmental": "No", "permitid": null, "buildingpermit": "No", "cama_city": null, "emailaddress": null, "floodplainurl": null, "lastname": null, "finaled": null, "solarpermit": "No", "phone": null, "crossroadnorth": null, "soilprofile": null, "zoningurl": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Permits", "allowTrueCurvesUpdates": false, "displayField": "firstname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "permitid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 255, "alias": "Permit Number", "type": "esriFieldTypeString" }, { "modelName": "firstname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 255, "alias": "First Name", "type": "esriFieldTypeString" }, { "modelName": "lastname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 255, "alias": "Last Name", "type": "esriFieldTypeString" }, { "modelName": "emailaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "emailaddress", "length": 255, "alias": "Email Address", "type": "esriFieldTypeString" }, { "modelName": "phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 255, "alias": "Phone Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "finaled", "domain": { "name": "Permits_finaled_d6255abf-33eb-457a-8708-cf65da85557c", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "finaled", "alias": "Finaled" }, { "modelName": "crossroadnorth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crossroadnorth", "length": 255, "alias": "Crossroad (North-South)", "type": "esriFieldTypeString" }, { "modelName": "crossroadeast", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crossroadeast", "length": 255, "alias": "Crossroad (East-West)", "type": "esriFieldTypeString" }, { "modelName": "cama", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama", "length": 255, "alias": "CAMA #", "type": "esriFieldTypeString" }, { "modelName": "cama_owner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_owner", "length": 255, "alias": "CAMA Landowner", "type": "esriFieldTypeString" }, { "modelName": "cama_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_address", "length": 255, "alias": "CAMA Mailing Address", "type": "esriFieldTypeString" }, { "modelName": "cama_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_city", "length": 255, "alias": "CAMA City", "type": "esriFieldTypeString" }, { "modelName": "cama_state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_state", "length": 255, "alias": "CAMA State", "type": "esriFieldTypeString" }, { "modelName": "cama_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cama_zip", "length": 255, "alias": "CAMA Zip", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "soilprofile", "domain": { "name": "Permits_soilprofile_cbe86575-68ba-499e-82c1-e62353584f12_1_1", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "soilprofile", "alias": "Soil Profile Complete" }, { "nullable": true, "editable": true, "defaultValue": "No", "length": 255, "type": "esriFieldTypeString", "modelName": "environmental", "domain": { "name": "yes_no_2_1", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "environmental", "alias": "Environmental Permit Complete" }, { "nullable": true, "editable": true, "defaultValue": "No", "length": 255, "type": "esriFieldTypeString", "modelName": "buildingpermit", "domain": { "name": "yes_no_3_1", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "buildingpermit", "alias": "Building Permit Complete" }, { "nullable": true, "editable": true, "defaultValue": "No", "length": 255, "type": "esriFieldTypeString", "modelName": "buildingsiteonlypermit", "domain": { "name": "yes_no_4_1", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "buildingsiteonlypermit", "alias": "Building Site Only Permit Complete" }, { "nullable": true, "editable": true, "defaultValue": "No", "length": 255, "type": "esriFieldTypeString", "modelName": "solarpermit", "domain": { "name": "yes_no_1_1", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "solarpermit", "alias": "Solar Permit Complete" }, { "nullable": true, "editable": true, "defaultValue": "No", "length": 255, "type": "esriFieldTypeString", "modelName": "inspections", "domain": { "name": "yes_no_5", "type": "codedValue", "codedValues": [ { "code": "Complete", "name": "Complete" }, { "code": "Incomplete", "name": "Incomplete" } ] }, "name": "inspections", "alias": "Inspections Complete" }, { "modelName": "payment_recieved", "nullable": true, "editable": true, "defaultValue": "No", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "yes_no", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "payment_recieved", "length": 255, "alias": "Payment Received", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "Open", "length": 255, "type": "esriFieldTypeString", "modelName": "open_closed", "domain": { "name": "open_closed_1_1_1", "type": "codedValue", "codedValues": [ { "code": "Submitted", "name": "Submitted" }, { "code": "In Review", "name": "In Review" }, { "code": "In Review/Requested Info", "name": "In Review/Requested Info" }, { "code": "Inspector Review", "name": "Inspector Review" }, { "code": "Issued", "name": "Issued" }, { "code": "Completed (Cert. of Occupancy)", "name": "Completed (Cert. of Occupancy)" }, { "code": "Completed (Cert. of Completion)", "name": "Completed (Cert. of Completion)" }, { "code": "Closed", "name": "Closed" } ] }, "name": "open_closed", "alias": "Open/Closed" }, { "modelName": "uniqueid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 38, "alias": "UniqueID", "type": "esriFieldTypeGUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "parcel_data", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcel_data", "length": 255, "alias": "URL for Parcel_Data", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "creationdate", "domain": null, "name": "creationdate", "alias": "creationdate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "creator", "domain": null, "name": "creator", "alias": "creator" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "editdate", "domain": null, "name": "editdate", "alias": "editdate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "editor", "domain": null, "name": "editor", "alias": "editor" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "floodplain", "length": 256, "alias": "Flood Plain", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "zoning", "length": 256, "alias": "Zoning", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "floodplainurl", "length": 256, "alias": "Floodplain URL", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "zoningurl", "length": 256, "alias": "Zoning URL", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "g2620uniqueid", "isUnique": false, "description": "", "fields": "uniqueid", "isAscending": true }, { "name": "r475_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_475", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a336_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "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, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "798910ae03da46c9bf5e64e203c7cfac", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "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": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 74, 173, 151, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }