{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "diagrams", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "diagram_id": null, "diagram_version": null, "diagram_details": null, "diagram_name": null, "description": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "diagrams", "displayField": "diagram_name", "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": 50, "type": "esriFieldTypeString", "modelName": "diagramId", "domain": null, "name": "diagram_id", "alias": "diagramId" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "diagramVersion", "domain": null, "name": "diagram_version", "alias": "diagramVersion" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "diagram", "domain": null, "name": "diagram_details", "alias": "diagram" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "description", "domain": null, "name": "description", "alias": "description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "diagramName", "domain": null, "name": "diagram_name", "alias": "diagramName" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i311diagram_id", "isUnique": false, "description": "", "fields": "diagram_id", "isAscending": true }, { "name": "r286_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "sqlType": "sqlTypeInteger", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID", "sqlTypeCode": 4 }, { "sqlType": "sqlTypeVarchar", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID", "sqlTypeCode": 12 }, { "sqlType": "sqlTypeVarchar", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString", "sqlTypeCode": 12 }, { "sqlType": "sqlTypeInteger", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger", "sqlTypeCode": 4 }, { "sqlType": "sqlTypeVarchar", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString", "sqlTypeCode": 12 }, { "sqlType": "sqlTypeVarchar", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString", "sqlTypeCode": 12 }, { "sqlType": "sqlTypeVarchar", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString", "sqlTypeCode": 12 } ], "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobAttachments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "folder": null, "job_id": null, "alias": null, "last_modified_by": null, "last_modified": null, "attachment_uri": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": true, "name": "jobAttachments", "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "alias", "domain": null, "name": "alias", "alias": "alias" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "attachment_uri", "domain": null, "name": "attachment_uri", "alias": "attachment_uri" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "folder", "domain": null, "name": "folder", "alias": "folder" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "last_modified_by", "domain": null, "name": "last_modified_by", "alias": "last_modified_by" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_modified", "domain": null, "name": "last_modified", "alias": "last_modified" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i313job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r288_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_288", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobComments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "job_id": null, "comment": null, "last_modified_by": null, "comment_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobComments", "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "comment_id", "domain": null, "name": "comment_id", "alias": "comment_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "comment", "domain": null, "name": "comment", "alias": "comment" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "last_modified_by", "domain": null, "name": "last_modified_by", "alias": "last_modified_by" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r291_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobExtPropertyDefinitions", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "visible": 0, "property_order": null, "editable": 0, "data_type": -1, "description": null, "default_value": null, "field_length": null, "updated_date": null, "table_id": null, "required": 0, "property_name": null, "property_alias": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobExtPropertyDefinitions", "displayField": "property_name", "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": 50, "type": "esriFieldTypeString", "modelName": "table_id", "domain": null, "name": "table_id", "alias": "table_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "property_name", "domain": null, "name": "property_name", "alias": "property_name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "property_alias", "domain": null, "name": "property_alias", "alias": "property_alias" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "property_order", "domain": null, "name": "property_order", "alias": "property_order" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeBlob", "modelName": "description", "domain": null, "name": "description", "alias": "description" }, { "nullable": true, "editable": true, "defaultValue": -1, "type": "esriFieldTypeSmallInteger", "modelName": "data_type", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "DataTypesDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "FieldTypeSmallInteger" }, { "code": -1, "name": "FieldTypeUnknown" }, { "code": 3, "name": "FieldTypeGUID" }, { "code": 1, "name": "FieldTypeInteger" }, { "code": 5, "name": "FieldTypeDouble" }, { "code": 6, "name": "FieldTypeDate" }, { "code": 7, "name": "FieldTypeText" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "data_type", "alias": "data_type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "default_value", "domain": null, "name": "default_value", "alias": "default_value" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "field_length", "domain": null, "name": "field_length", "alias": "field_length" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "editable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "editable", "alias": "editable" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "required", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "required", "alias": "required" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "visible", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "visible", "alias": "visible" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "updated_date", "domain": null, "name": "updated_date", "alias": "updated_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r290_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobExtPropertyTableDefinitions", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "external_url": null, "layer_id": null, "relationship_type": 0, "item_id": null, "item_type": null, "portal_type": null, "table_id": null, "secure": null, "table_name": null, "table_alias": null, "url": null, "searchable": 1 } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobExtPropertyTableDefinitions", "displayField": "table_name", "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": 50, "type": "esriFieldTypeString", "modelName": "table_id", "domain": null, "name": "table_id", "alias": "table_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "table_name", "domain": null, "name": "table_name", "alias": "table_name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "table_alias", "domain": null, "name": "table_alias", "alias": "table_alias" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "relationship_type", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "extendedPropertiesCardinalityDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 1, "name": "One To Many" }, { "code": 0, "name": "One To One" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "relationship_type", "alias": "relationship_type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "url", "domain": null, "name": "url", "alias": "url" }, { "nullable": true, "editable": true, "defaultValue": 1, "type": "esriFieldTypeSmallInteger", "modelName": "searchable", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "searchable", "alias": "searchable" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "external_url", "domain": null, "name": "external_url", "alias": "external_url" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "secure", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "secure", "alias": "secure" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "item_id", "domain": null, "name": "item_id", "alias": "item_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "item_type", "domain": null, "name": "item_type", "alias": "itemType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "layer_id", "domain": null, "name": "layer_id", "alias": "layer_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "portal_type", "domain": null, "name": "portal_type", "alias": "portal_type" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r292_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobHistory", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "result": null, "duration": null, "end_date": null, "job_id": null, "action": null, "step_id": null, "username": null, "start_date": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobHistory", "displayField": "username", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "action", "domain": null, "name": "action", "alias": "action" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "username", "domain": null, "name": "username", "alias": "username" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "start_date", "domain": null, "name": "start_date", "alias": "start_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "end_date", "domain": null, "name": "end_date", "alias": "end_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "step_id", "domain": null, "name": "step_id", "alias": "step_id" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "duration", "domain": null, "name": "duration", "alias": "duration" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 250, "type": "esriFieldTypeString", "modelName": "result", "domain": null, "name": "result", "alias": "result" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i312job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r287_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 11, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobHolds", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "set_date": null, "job_id": " ", "set_by": null, "released_by": null, "dependent_job_id": null, "hold_id": null, "dependent_step_id": null, "step_id": " ", "released_date": null, "scheduled_release": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobHolds", "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "jobId" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "step_id", "domain": null, "name": "step_id", "alias": "stepId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "hold_id", "domain": null, "name": "hold_id", "alias": "holdId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "set_by", "domain": null, "name": "set_by", "alias": "setBy" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "set_date", "domain": null, "name": "set_date", "alias": "setDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "scheduled_release", "domain": null, "name": "scheduled_release", "alias": "scheduledRelease" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "released_by", "domain": null, "name": "released_by", "alias": "releasedBy" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "released_date", "domain": null, "name": "released_date", "alias": "releasedDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "dependent_job_id", "domain": null, "name": "dependent_job_id", "alias": "dependentJobId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "dependent_step_id", "domain": null, "name": "dependent_step_id", "alias": "dependentStepId" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i318dependent_jo", "isUnique": false, "description": "", "fields": "dependent_job_id", "isAscending": true }, { "name": "i318dependent_st", "isUnique": false, "description": "", "fields": "dependent_step_id", "isAscending": true }, { "name": "i318hold_id", "isUnique": false, "description": "", "fields": "hold_id", "isAscending": true }, { "name": "i318job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "i318step_id", "isUnique": false, "description": "", "fields": "step_id", "isAscending": true }, { "name": "r293_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 12, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobProgress", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "step_assigned_type": null, "job_id": null, "step_output": null, "step_id": null, "step_details": null, "step_assigned_to": null, "step_action": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobProgress", "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "jobId", "domain": null, "name": "job_id", "alias": "jobId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "stepId", "domain": null, "name": "step_id", "alias": "stepId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "stepAssignedTo", "domain": null, "name": "step_assigned_to", "alias": "stepAssignedTo" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "stepAssignedType", "domain": null, "name": "step_assigned_type", "alias": "stepAssignedType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "stepAction", "domain": null, "name": "step_action", "alias": "stepAction" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "stepDetails", "domain": null, "name": "step_details", "alias": "stepDetails" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "step_output", "domain": null, "name": "step_output", "alias": "stepOutput" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i319job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "i319job_id1", "isUnique": false, "description": "", "fields": "job_id,step_id", "isAscending": true }, { "name": "i319step_action", "isUnique": false, "description": "", "fields": "step_action", "isAscending": true }, { "name": "i319step_assigne", "isUnique": false, "description": "", "fields": "step_assigned_to", "isAscending": true }, { "name": "i319step_assigne_1", "isUnique": false, "description": "", "fields": "step_assigned_type", "isAscending": true }, { "name": "i319step_id", "isUnique": false, "description": "", "fields": "step_id", "isAscending": true }, { "name": "r294_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 13, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobs", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "end_date": null, "priority_rank": null, "notes": null, "parent_job": null, "due_date": null, "description": null, "owned_by": null, "parent_job_ref_id": null, "started_date": null, "created_by": null, "job_template_id": null, "percent_complete": null, "active_versions": null, "diagram": null, "job_status": null, "diagram_version": null, "job_name": null, "job_id": null, "closed": 0, "has_location": 0, "start_date": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobs", "displayField": "job_name", "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": 50, "type": "esriFieldTypeString", "modelName": "jobId", "domain": null, "name": "job_id", "alias": "jobId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "jobName", "domain": null, "name": "job_name", "alias": "jobName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "parent_job", "domain": null, "name": "parent_job", "alias": "parent_job" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "description", "domain": null, "name": "description", "alias": "description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "notes", "domain": null, "name": "notes", "alias": "notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "ownedBy", "domain": null, "name": "owned_by", "alias": "ownedBy" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "createdBy", "domain": null, "name": "created_by", "alias": "createdBy" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "start_date", "domain": null, "name": "start_date", "alias": "start_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "started_date", "domain": null, "name": "started_date", "alias": "started_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "due_date", "domain": null, "name": "due_date", "alias": "due_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "end_date", "domain": null, "name": "end_date", "alias": "end_date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "percentComplete", "domain": null, "name": "percent_complete", "alias": "percentComplete" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "priorityRank", "domain": null, "name": "priority_rank", "alias": "priorityRank" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "jobStatus", "domain": null, "name": "job_status", "alias": "jobStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "diagram", "domain": null, "name": "diagram", "alias": "diagram" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "diagramVersion", "domain": null, "name": "diagram_version", "alias": "diagramVersion" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "featureLayerSchemaId", "domain": null, "name": "job_template_id", "alias": "jobTemplateId" }, { "nullable": false, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "closed", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10000, "type": "esriFieldTypeString", "modelName": "activeVersions", "domain": null, "name": "active_versions", "alias": "active_versions" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "has_location", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_location", "alias": "hasLocation" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "parent_job_ref_id", "domain": null, "name": "parent_job_ref_id", "alias": "parentJobRefId" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g320closed", "isUnique": false, "description": "", "fields": "closed", "isAscending": true }, { "name": "g320job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "i320diagram3", "isUnique": false, "description": "", "fields": "diagram,diagram_version", "isAscending": true }, { "name": "i320job_template", "isUnique": false, "description": "", "fields": "job_template_id", "isAscending": true }, { "name": "i320parent_job_r", "isUnique": false, "description": "", "fields": "parent_job_ref_id", "isAscending": true }, { "name": "r295_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 14, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobTemplateAutomatedCreation", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "automation_id": null, "associated_id": null, "automation_type": null, "created_by": null, "automation_name": null, "job_template_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobTemplateAutomatedCreation", "displayField": "automation_name", "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": 50, "type": "esriFieldTypeString", "modelName": "automation_id", "domain": null, "name": "automation_id", "alias": "automationId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "automation_name", "domain": null, "name": "automation_name", "alias": "automationName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "automation_type", "domain": null, "name": "automation_type", "alias": "automationType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_template_id", "domain": null, "name": "job_template_id", "alias": "jobTemplateId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "associated_id", "domain": null, "name": "associated_id", "alias": "associatedId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_by", "domain": null, "name": "created_by", "alias": "createdBy" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r296_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 15, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobTemplates", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "diagram_id": null, "default_assigned_type": null, "default_priority_rank": null, "default_status": null, "default_assigned_to": null, "description": null, "default_job_name": null, "job_template_id": " ", "job_template_name": null, "default_due_date": null, "default_final_status": null, "default_start_date": null, "default_job_duration": null, "activities": null, "default_description": null, "state": null, "category": null, "job_start_date_type": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobTemplates", "displayField": "job_template_name", "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": 50, "type": "esriFieldTypeString", "modelName": "default_status", "domain": null, "name": "default_status", "alias": "defaultStatus" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_template_id", "domain": null, "name": "job_template_id", "alias": "jobTemplateId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "job_template_name", "domain": null, "name": "job_template_name", "alias": "jobTemplateName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "defaultAssignedTo", "domain": null, "name": "default_assigned_to", "alias": "defaultAssignedTo" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "defaultAssignedType", "domain": null, "name": "default_assigned_type", "alias": "defaultAssignedType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "defaultDescription", "domain": null, "name": "default_description", "alias": "defaultDescription" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "defaultDueDate", "domain": null, "name": "default_due_date", "alias": "defaultDueDate" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "defaultJobDuration", "domain": null, "name": "default_job_duration", "alias": "defaultJobDuration" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "defaultPriorityRank", "domain": null, "name": "default_priority_rank", "alias": "defaultPriorityRank" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "defaultStartDate", "domain": null, "name": "default_start_date", "alias": "defaultStartDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_start_date_type", "domain": null, "name": "job_start_date_type", "alias": "jobStartDateType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "description", "domain": null, "name": "description", "alias": "description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "category", "domain": null, "name": "category", "alias": "category" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "diagramId", "domain": null, "name": "diagram_id", "alias": "diagramId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "state", "domain": null, "name": "state", "alias": "state" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "activities", "domain": null, "name": "activities", "alias": "activities" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "default_final_status", "domain": null, "name": "default_final_status", "alias": "defaultFinalStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "default_job_name", "domain": null, "name": "default_job_name", "alias": "defaultJobName" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r297_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 16, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobTemplatesToExtPropertyTableDefXref", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "table_order": null, "table_id": null, "job_template_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobTemplatesToExtPropertyTableDefXref", "displayField": "table_id", "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": 50, "type": "esriFieldTypeString", "modelName": "table_id", "domain": null, "name": "table_id", "alias": "table_id" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "table_order", "domain": null, "name": "table_order", "alias": "table_order" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_template_id", "domain": null, "name": "job_template_id", "alias": "job_template_id" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r298_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 17, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "lookups", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "lookup_name": null, "lookup_type": null, "value": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "lookups", "displayField": "lookup_name", "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": 200, "type": "esriFieldTypeString", "modelName": "lookup_type", "domain": null, "name": "lookup_type", "alias": "lookupType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "lookup_name", "domain": null, "name": "lookup_name", "alias": "lookupName" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "value", "domain": null, "name": "value", "alias": "value" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i324lookup_type", "isUnique": false, "description": "", "fields": "lookup_type", "isAscending": true }, { "name": "i324value", "isUnique": false, "description": "", "fields": "value", "isAscending": true }, { "name": "r299_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 18, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "roleGroups", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "role_name": null, "group_name": null, "group_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "roleGroups", "displayField": "role_name", "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": 200, "type": "esriFieldTypeString", "modelName": "roleName", "domain": null, "name": "role_name", "alias": "role_name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "group_id", "domain": null, "name": "group_id", "alias": "group_id" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "groupName", "domain": null, "name": "group_name", "alias": "groupName" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i325group_id", "isUnique": false, "description": "", "fields": "group_id", "isAscending": true }, { "name": "i325role_name", "isUnique": false, "description": "", "fields": "role_name", "isAscending": true }, { "name": "r300_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 19, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "roles", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "role_name": " ", "privileges": null, "description": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "roles", "displayField": "role_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "roleName", "domain": null, "name": "role_name", "alias": "roleName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "description", "domain": null, "name": "description", "alias": "description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "privileges", "domain": null, "name": "privileges", "alias": "privileges" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r301_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 20, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "searches", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "color_ramp": null, "definition": null, "sort_index": null, "search_name": " ", "folder_name": null, "search_type": null, "search_id": " " } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "searches", "displayField": "search_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "search_id", "domain": null, "name": "search_id", "alias": "search_id" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "search_name", "domain": null, "name": "search_name", "alias": "search_name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "folder_name", "domain": null, "name": "folder_name", "alias": "folder_name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10000, "type": "esriFieldTypeString", "modelName": "definition", "domain": null, "name": "definition", "alias": "definition" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "search_type", "domain": null, "name": "search_type", "alias": "searchType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "color_ramp", "domain": null, "name": "color_ramp", "alias": "colorRamp" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "sort_index", "domain": null, "name": "sort_index", "alias": "sortIndex" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i327search_id", "isUnique": false, "description": "", "fields": "search_id", "isAscending": true }, { "name": "i327search_type", "isUnique": false, "description": "", "fields": "search_type", "isAscending": true }, { "name": "r302_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 21, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "settings", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "prop_name": null, "encrypted": null, "value": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "settings", "displayField": "prop_name", "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, "type": "esriFieldTypeSmallInteger", "modelName": "encrypted", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "encrypted", "alias": "encrypted" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "prop_name", "domain": null, "name": "prop_name", "alias": "propName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000, "type": "esriFieldTypeString", "modelName": "value", "domain": null, "name": "value", "alias": "value" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r289_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 22, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "shareRelationships", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "shared_with": null, "item": null, "type": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "shareRelationships", "displayField": "item", "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": 50, "type": "esriFieldTypeString", "modelName": "item", "domain": null, "name": "item", "alias": "item" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "shared_with", "domain": null, "name": "shared_with", "alias": "sharedWith" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "type", "domain": null, "name": "type", "alias": "type" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r303_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 23, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "templates", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "template_name": null, "template_details": null, "template_id": null, "template_type": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "templates", "displayField": "template_name", "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": 50, "type": "esriFieldTypeString", "modelName": "template_id", "domain": null, "name": "template_id", "alias": "templateId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "template_type", "domain": null, "name": "template_type", "alias": "templateType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "template_name", "domain": null, "name": "template_name", "alias": "templateName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "template_details", "domain": null, "name": "template_details", "alias": "templateDetails" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i329template_id", "isUnique": false, "description": "", "fields": "template_id", "isAscending": true }, { "name": "i329template_typ", "isUnique": false, "description": "", "fields": "template_type", "isAscending": true }, { "name": "r304_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 28, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobs", "displayField": "job_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRankComplete", "type": "esriFieldTypeSmallInteger " }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagramId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_name", "length": 200, "alias": "jobTemplateName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "has_location", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_location", "alias": "hasLocation" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 29, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobprogress_latest", "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "jobId", "domain": null, "name": "job_id", "alias": "jobId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "stepId", "domain": null, "name": "step_id", "alias": "stepId" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "stepAssignedTo", "domain": null, "name": "step_assigned_to", "alias": "stepAssignedTo" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "stepAssignedType", "domain": null, "name": "step_assigned_type", "alias": "stepAssignedType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "stepTimestamp", "domain": null, "name": "created_date", "alias": "createdDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "stepAction", "domain": null, "name": "step_action", "alias": "stepAction" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "stepDetails", "domain": null, "name": "step_details", "alias": "stepDetails" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "step_output", "domain": null, "name": "step_output", "alias": "stepOutput" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 30, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobTemplates", "displayField": "job_template_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_assigned_to", "length": 200, "alias": "defaultAssignedTo", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_assigned_type", "length": 200, "alias": "defaultAssignedType", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_description", "length": 2000, "alias": "defaultDescription", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_due_date", "length": 29, "alias": "defaultDueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_job_duration", "alias": "defaultJobDuration", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "default_priority_rank", "alias": "defaultPriorityRank", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "default_start_date", "length": 29, "alias": "defaultStartDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_start_date_type", "length": 50, "alias": "jobStartDateType", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "category", "length": 200, "alias": "category", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram_id", "length": 50, "alias": "diagramId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram_name", "length": 100, "alias": "diagramName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "state", "length": 50, "alias": "state", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_name", "length": 200, "alias": "jobTemplateName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1000000, "type": "esriFieldTypeString", "modelName": "activities", "domain": null, "name": "activities", "alias": "activities" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "default_final_status", "domain": null, "name": "default_final_status", "alias": "defaultFinalStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "default_status", "domain": null, "name": "default_status", "alias": "defaultStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "default_job_name", "domain": null, "name": "default_job_name", "alias": "defaultJobName" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 31, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_roles", "displayField": "role_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "role_name", "length": 200, "alias": "roleName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "privileges", "length": 2000, "alias": "privileges", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "group_id", "length": 200, "alias": "groupId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "group_name", "length": 200, "alias": "groupName", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 34, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "ext_yxnG2DSLQUW3JrV9CwHnlw", "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "job_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "globalid", "length": 100, "alias": "GlobalID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Job extended property table", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r335_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 36, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "ext_PNmVbGPnRY-CWXMcO39Rww", "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "job_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "approvedaddress", "alias": "Approved Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "requestor", "alias": "Requestor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "siteinfo", "alias": "Site Info Reference", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Job extended property table", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r337_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 38, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "ext_tglnMFZoTLCDPlEGmINGwQ", "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "job_id", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "requestor", "alias": "Requestor Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "requestortype", "alias": "Requestor Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "email", "alias": "Requestor Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "phone", "alias": "Requestor Phone Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "requesttype", "alias": "Request Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "walkin", "alias": "Walk in request?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "propid", "alias": "OLD Request Property ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "legal", "alias": "Request Legal Desc", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "lot", "alias": "Archive Request Lot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "block", "alias": "Request Block", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "subdivision", "alias": "Subdivision", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "addinfo", "alias": "Additional Info", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "nearstreet", "alias": "Nearest Street", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "intersection", "alias": "OLD Nearest Intersection", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 60, "name": "surveyglobalid", "alias": "Survey Globalid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "countyname", "alias": "County Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "premise_entrytype", "alias": "How customer provided the address location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "region", "alias": "Region", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "premise_desc", "alias": "More info about request", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "request_lot", "alias": "Request Lot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "premise_propertyid", "alias": "Property ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "premise_intersection", "alias": "Nearest Intersection", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Job extended property table", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r340_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "job_id_workflow_baa891aed38b4b8_ext_tglnmfzotlcdplegmingwq", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "jobPOI", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {"job_id": null} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobPOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i306job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r281_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a64_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 }, "color": [ 0, 163, 46, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryMultipoint" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "jobLOI", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": {"job_id": null} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobLOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i308job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r283_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a66_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 163, 0, 95, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "jobAOI", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {"job_id": null} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobAOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i309job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r284_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a67_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.4, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 196, 245, 218, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "jobLocations", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": {"job_id": null} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "jobLocations", "allowTrueCurvesUpdates": false, "displayField": "job_id", "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": 50, "type": "esriFieldTypeString", "modelName": "job_id", "domain": null, "name": "job_id", "alias": "job_id" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i307job_id", "isUnique": false, "description": "", "fields": "job_id", "isAscending": true }, { "name": "r282_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a65_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.4, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 210, 247, 221, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 24, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_job_search", "allowTrueCurvesUpdates": false, "displayField": "job_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRank", "type": "esriFieldTypeSmallInteger " }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "priority", "length": 200, "alias": "jobPriority", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagramId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_name", "length": 200, "alias": "jobTemplateName", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "current_step_id", "length": 50, "alias": "currentStepID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "current_step", "length": 2147483647, "alias": "currentStep", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "assigned_to", "length": 500, "alias": "assignedTo", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "assigned_type", "length": 50, "alias": "assignedType", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "has_location", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_location", "alias": "hasLocation" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeNone", "editFieldsInfo": null, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 222, 41, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 222, 41, 0, 64 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 25, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobAOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "objectid" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentJob", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRank", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagram", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": null, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 222, 41, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 222, 41, 0, 64 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 26, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobPOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "objectid" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentJob", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRank", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagram", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ {"fields": "job_id"} ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": null, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 222, 41, 0, 255 ], "width": 1 }, "color": [ 222, 41, 0, 64 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryMultipoint" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 27, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_jobLOI", "allowTrueCurvesUpdates": false, "displayField": "job_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "objectid" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentJob", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRank", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagram", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": null, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 222, 41, 0, 127 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline" }, { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.3538524994349548E8, "mTolerance": 0.001, "falseX": -2.204125862706707E7, "falseY": -3.3265068604224768E7, "falseZ": -100000 } }, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasStaticData": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "isDataArchived": false, "id": 39, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "v_job_search_ext", "allowTrueCurvesUpdates": false, "displayField": "job_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "job_id", "length": 50, "alias": "jobId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_name", "length": 200, "alias": "jobName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "parent_job", "length": 50, "alias": "parentName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "description", "length": 2000, "alias": "description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "notes", "length": 5000, "alias": "notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "owned_by", "length": 200, "alias": "ownedBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_by", "length": 200, "alias": "createdBy", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "createdDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "start_date", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "started_date", "length": 29, "alias": "startedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "due_date", "length": 29, "alias": "dueDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "end_date", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "percent_complete", "alias": "percentComplete", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "priority_rank", "alias": "priorityRank", "type": "esriFieldTypeSmallInteger " }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "priority", "length": 200, "alias": "jobPriority", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_status", "length": 50, "alias": "jobStatus", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram", "length": 200, "alias": "diagramId", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "diagram_version", "alias": "diagramVersion", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_id", "length": 50, "alias": "jobTemplateId", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": 0, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closed", "alias": "closed", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "active_versions", "length": 10000, "alias": "activeVersions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "job_template_name", "length": 200, "alias": "jobTemplateName", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "current_step_id", "length": 50, "alias": "currentStepID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "current_step", "length": 2147483647, "alias": "currentStep", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "assigned_to", "length": 500, "alias": "assignedTo", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "assigned_type", "length": 50, "alias": "assignedType", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": 0, "type": "esriFieldTypeSmallInteger", "modelName": "has_location", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YesNoDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_location", "alias": "hasLocation" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parent_job_ref_id", "length": 200, "alias": "parentJobRefId", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "eyxng2dslquw3jrv9cwhnlw_globalid", "length": 100, "alias": "request.globalid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "ebaa891aed_9f810fda2f3549aab123818fe06eff07_approvedaddress", "alias": "final.approvedaddress", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "ebaa891aed_9f810fda2f3549aab123818fe06eff07_requestor", "alias": "final.requestor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "ebaa891aed_9f810fda2f3549aab123818fe06eff07_siteinfo", "alias": "final.siteinfo", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "etglnmfzotlcdplegmingwq_premise_desc", "alias": "requestdetails.premise_desc", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "name": "etglnmfzotlcdplegmingwq_requestor", "alias": "requestdetails.requestor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "etglnmfzotlcdplegmingwq_requestortype", "alias": "requestdetails.requestortype", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_email", "alias": "requestdetails.email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "etglnmfzotlcdplegmingwq_phone", "alias": "requestdetails.phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "etglnmfzotlcdplegmingwq_request_lot", "alias": "requestdetails.request_lot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "etglnmfzotlcdplegmingwq_requesttype", "alias": "requestdetails.requesttype", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_walkin", "alias": "requestdetails.walkin", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "etglnmfzotlcdplegmingwq_premise_propertyid", "alias": "requestdetails.premise_propertyid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "name": "etglnmfzotlcdplegmingwq_propid", "alias": "requestdetails.propid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_legal", "alias": "requestdetails.legal", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "etglnmfzotlcdplegmingwq_lot", "alias": "requestdetails.lot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "name": "etglnmfzotlcdplegmingwq_block", "alias": "requestdetails.block", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_subdivision", "alias": "requestdetails.subdivision", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_addinfo", "alias": "requestdetails.addinfo", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_nearstreet", "alias": "requestdetails.nearstreet", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_intersection", "alias": "requestdetails.intersection", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 60, "name": "etglnmfzotlcdplegmingwq_surveyglobalid", "alias": "requestdetails.surveyglobalid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_countyname", "alias": "requestdetails.countyname", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_premise_entrytype", "alias": "requestdetails.premise_entrytype", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "name": "etglnmfzotlcdplegmingwq_region", "alias": "requestdetails.region", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "name": "etglnmfzotlcdplegmingwq_premise_intersection", "alias": "requestdetails.premise_intersection", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ {"fields": "job_id"} ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "editFieldsInfo": null, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "1a2f034f406f4353b59b1f19961c0b92", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 222, 41, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 222, 41, 0, 64 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" } ] }