{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Sign Location Point", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 4800, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "tSigns", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{42CDF984-51A1-4E2A-9096-80FF52E50AA2}" }, { "id": 2, "name": "tMaintenanceRecords", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{9AD8342B-3833-4E81-B77C-509133298A9D}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "hasContingentValuesDefinition": false, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 2285794.243486566, "ymin": 504089.03332686634, "xmax": 2325987.4024797287, "ymax": 548542.7169147515, "spatialReference": { "wkid": 102676, "latestWkid": 3418, "xyTolerance": 4.839338368977427E-5, "zTolerance": 2.0E-5, "mTolerance": 0.001, "falseX": -119240500, "falseY": -96507600, "xyUnits": 3.725648770439424E7, "falseZ": 0, "zUnits": 99999.99999999999, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102676, "latestWkid": 3418, "xyTolerance": 4.839338368977427E-5, "zTolerance": 2.0E-5, "mTolerance": 0.001, "falseX": -119240500, "falseY": -96507600, "xyUnits": 3.725648770439424E7, "falseZ": 0, "zUnits": 99999.99999999999, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102676, "latestWkid": 3418, "xyTolerance": 4.839338368977427E-5, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.192404999999797E8, "falseY": -9.650759999998389E7, "xyUnits": 165311.85443208498, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "d14783d441e3908e8a01afbbb541d77a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaElEQVQoka3SMUhCURTG8f9NQ0RSIYKWIqOlJWiIMoTAwcEIoq1NQYWg1qcQhik4tDaFIO4NDoJB0kMQGhK0RQUJEm1yiNKIXLyBj4i0GqKz3MMHP87h3qvnj6X/VyiltNFqrWGxPGI2F4QQr79C2e1O0WpdkcstoKpGrFbJzs6LLJdPxfLy4bdQSimo1W4IBufIZD5iQTQ6QSqlyGJRJ1ZWQqMTC4Uwqjo7QEKAywX391Cvg8ejp1Tal1JGP9b+hEbjLsnk2KCPxyEUgl4PlpY0nE6bcDo3gfOvUKcz0elo/eKidhoMYLNp8PkZnp6mR1dtt+9YX58hmwVF0bJaDS4vtd7h6GMyqaOw2Tzg+LhMPj8+mLC9/XmFW1swOfkg7PbKCBSBQEUmEjHy+SMiET3X12A2g9cLbvcj1erGj+8o/P6YPDnJ4POdEQ7P0+u90WhkubjYE5FI/0c4wIpyC6wO58P157/6DhzYfXemzgBwAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "LocationStatus", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LocationInstallDate", "type": "esriFieldTypeDate", "alias": "Location Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LocationInstallDate" }, { "name": "ZoneNumber", "type": "esriFieldTypeInteger", "alias": "Zone Number", "domain": { "type": "range", "name": "ZoneNumber", "description": "ZoneNumber", "range": [ 1, 7 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ZoneNumber" }, { "name": "SignsInAssembly", "type": "esriFieldTypeInteger", "alias": "Signs In Assembly", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignsInAssembly" }, { "name": "NumberOfSupports", "type": "esriFieldTypeInteger", "alias": "Number Of Supports", "domain": { "type": "range", "name": "NumberOfSupports", "description": "Number of supports", "range": [ 1, 9 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "NumberOfSupports" }, { "name": "OffsetDistance", "type": "esriFieldTypeInteger", "alias": "Offset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OffsetDistance" }, { "name": "SupportType", "type": "esriFieldTypeString", "alias": "Support Type", "domain": { "type": "codedValue", "name": "SupportType", "description": "Type of support the sign is on", "codedValues": [ { "name": "1 - Steel Channel", "code": "1 - Steel Channel" }, { "name": "2 - Steel Pipe", "code": "2 - Steel Pipe" }, { "name": "3 - Aluminum Channel", "code": "3 - Aluminum Channel" }, { "name": "4 - Wood Post", "code": "4 - Wood Post" }, { "name": "5 - Signal Post", "code": "5 - Signal Post" }, { "name": "6 - Utility Pole", "code": "6 - Utility Pole" }, { "name": "7 - Span Wire OH", "code": "7 - Span Wire OH" }, { "name": "8 - Mast Arm OH", "code": "8 - Mast Arm OH" }, { "name": "9 - Tubing", "code": "9 - Tubing" }, { "name": "10 - Unknown", "code": "10 - Unknown" }, { "name": "11 - Other", "code": "11 - Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SupportType" }, { "name": "PNO", "type": "esriFieldTypeInteger", "alias": "PNO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PNO" }, { "name": "LocationCardRefNum", "type": "esriFieldTypeInteger", "alias": "Location Card Ref Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LocationCardRefNum" }, { "name": "SupportInstallDate", "type": "esriFieldTypeDate", "alias": "Support Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SupportInstallDate" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R43_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G1291PNO", "isAscending": true, "isUnique": false, "description": "", "fields": "PNO" }, { "name": "I1291LocationCar", "isAscending": true, "isUnique": false, "description": "", "fields": "LocationCardRefNum" }, { "name": "S17_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "SHAPE" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Sign Location Point", "description": "", "prototype": { "attributes": { "LocationCardRefNum": null, "SupportInstallDate": null, "LocationInstallDate": null, "ZoneNumber": null, "SignsInAssembly": null, "NumberOfSupports": 1, "OffsetDistance": null, "SupportType": null, "PNO": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ed221c79fd19486fa02cf7409e9caa0a" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Signs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "SignLocationPoint", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SignLocationID", "composite": false, "catalogID": "{42CDF984-51A1-4E2A-9096-80FF52E50AA2}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "hasContingentValuesDefinition": false, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SignStatus", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SignLocationID", "type": "esriFieldTypeInteger", "alias": "SignLocationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignLocationID" }, { "name": "SignStatus", "type": "esriFieldTypeString", "alias": "SignStatus", "domain": { "type": "codedValue", "name": "SignStatus", "description": "Status of sign, Active or Inactive.", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "InActive", "code": "InActive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "Active", "modelName": "SignStatus" }, { "name": "SignInstallDate", "type": "esriFieldTypeDate", "alias": "SignInstallDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SignInstallDate" }, { "name": "SignCardNumber", "type": "esriFieldTypeString", "alias": "SignCardNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SignCardNumber" }, { "name": "LocationCardRefNum", "type": "esriFieldTypeInteger", "alias": "LocationCardRefNum", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LocationCardRefNum" }, { "name": "SignCode", "type": "esriFieldTypeString", "alias": "SignCode", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SignCode" }, { "name": "FaceType", "type": "esriFieldTypeString", "alias": "FaceType", "domain": { "type": "codedValue", "name": "FaceType", "description": "Reflectivity of the sign face", "codedValues": [ { "name": "1 - Reflective HI", "code": "1 - Reflective HI" }, { "name": "2 - Reflective EG", "code": "2 - Reflective EG" }, { "name": "3 - Reflective Other", "code": "3 - Reflective Other" }, { "name": "4 - Non-Reflective", "code": "4 - Non-Reflective" }, { "name": "5 - Other", "code": "5 - Other" }, { "name": "6 - DiamondVIP", "code": "6 - DiamondVIP" }, { "name": "7 - Reflective HIP", "code": "7 - Reflective HIP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "5 - Other", "modelName": "FaceType" }, { "name": "BackingType", "type": "esriFieldTypeString", "alias": "BackingType", "domain": { "type": "codedValue", "name": "BackingType", "description": "Material the sign is backed with", "codedValues": [ { "name": "1 - Aluminum", "code": "1 - Aluminum" }, { "name": "2 - Steel", "code": "2 - Steel" }, { "name": "3 - Plywood", "code": "3 - Plywood" }, { "name": "4 - Other", "code": "4 - Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "4 - Other", "modelName": "BackingType" }, { "name": "Height", "type": "esriFieldTypeString", "alias": "Height", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Height" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "domain": { "type": "codedValue", "name": "SignCondition", "description": "Condition of sign", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Condition" }, { "name": "Age", "type": "esriFieldTypeDouble", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Age" }, { "name": "SignDimensions", "type": "esriFieldTypeString", "alias": "SignDimensions", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SignDimensions" }, { "name": "SignDescription", "type": "esriFieldTypeString", "alias": "Sign Description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "SignDescription" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": { "type": "codedValue", "name": "SignOwner", "description": "Sign Owner", "codedValues": [ { "name": "Finance", "code": "Finance" }, { "name": "Housing", "code": "Housing" }, { "name": "Parks", "code": "Parks" }, { "name": "Public Works", "code": "Public Works" }, { "name": "School", "code": "School" }, { "name": "State", "code": "State" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Public Works", "modelName": "Owner" } ], "indexes": [ { "name": "R41_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G1288SignCode", "isAscending": true, "isUnique": false, "description": "", "fields": "SignCode" }, { "name": "G1288SignLocatio", "isAscending": true, "isUnique": false, "description": "", "fields": "SignLocationID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Signs", "description": "", "prototype": { "attributes": { "SignDescription": null, "Owner": "Public Works", "SignLocationID": null, "SignStatus": "Active", "SignInstallDate": null, "SignCardNumber": null, "LocationCardRefNum": null, "SignCode": null, "FaceType": "5 - Other", "BackingType": "4 - Other", "Height": null, "Condition": null, "Age": null, "SignDimensions": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ed221c79fd19486fa02cf7409e9caa0a" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "Sign Maintenance", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "SignLocationPoint", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SignLocationID", "composite": false, "catalogID": "{9AD8342B-3833-4E81-B77C-509133298A9D}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "hasContingentValuesDefinition": false, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ReasonForMaintenance", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SignLocationID", "type": "esriFieldTypeInteger", "alias": "SignLocationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignLocationID" }, { "name": "MaintenanceDate", "type": "esriFieldTypeDate", "alias": "MaintenanceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MaintenanceDate" }, { "name": "ReasonForMaintenance", "type": "esriFieldTypeString", "alias": "ReasonForMaintenance", "domain": { "type": "codedValue", "name": "ReasonForMaintenance", "description": "Reason a maintenance visit was made to location.", "codedValues": [ { "name": "100 - Aged", "code": "100 - Aged" }, { "name": "110 - Accident", "code": "110 - Accident" }, { "name": "130 - Missing", "code": "130 - Missing" }, { "name": "140 - Vandalism", "code": "140 - Vandalism" }, { "name": "150 - Other", "code": "150 - Other" }, { "name": "120 - Damaged", "code": "120 - Damaged" }, { "name": "160 - Work Order", "code": "160 - Work Order" }, { "name": "170 - Council", "code": "170 - Council" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ReasonForMaintenance" }, { "name": "LocationMaintenance", "type": "esriFieldTypeString", "alias": "LocationMaintenance", "domain": { "type": "codedValue", "name": "LocationMaintenance", "description": "Maintenance performed to the sign assembly as a whole.", "codedValues": [ { "name": "410 - Placed As New", "code": "410 - Placed As New" }, { "name": "400 - None", "code": "400 - None" }, { "name": "420 - Trimmed Vegetation", "code": "420 - Trimmed Vegetation" }, { "name": "430 - Relocate Assembly", "code": "430 - Relocate Assembly" }, { "name": "440 - Removed Permanently", "code": "440 - Removed Permanently" }, { "name": "450 - Other", "code": "450 - Other" }, { "name": "Temporary", "code": "Temporary" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 28, "defaultValue": "400 - None", "modelName": "LocationMaintenance" }, { "name": "SignMaintenance", "type": "esriFieldTypeString", "alias": "SignMaintenance", "domain": { "type": "codedValue", "name": "SignMaintenance", "description": "Maintenance done to sign", "codedValues": [ { "name": "210 - Cleaned", "code": "210 - Cleaned" }, { "name": "220 - General Maintenance", "code": "220 - General Maintenance" }, { "name": "230 - Replaced", "code": "230 - Replaced" }, { "name": "240 - Other", "code": "240 - Other" }, { "name": "200 - None", "code": "200 - None" }, { "name": "250 - New", "code": "250 - New" }, { "name": "400 - Removed", "code": "400 - Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 28, "defaultValue": "200 - None", "modelName": "SignMaintenance" }, { "name": "SupportMaintenance", "type": "esriFieldTypeString", "alias": "SupportMaintenance", "domain": { "type": "codedValue", "name": "SupportMaintenance", "description": "Maintenance done to support", "codedValues": [ { "name": "310 - Replaced", "code": "310 - Replaced" }, { "name": "320 - Repaired", "code": "320 - Repaired" }, { "name": "330 - Reset", "code": "330 - Reset" }, { "name": "340 - Other", "code": "340 - Other" }, { "name": "300 - None", "code": "300 - None" }, { "name": "New", "code": "350 - Placed As New" }, { "name": "Reinstalled", "code": "Reinstalled" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "300 - None", "modelName": "SupportMaintenance" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G1287SignLocatio", "isAscending": true, "isUnique": false, "description": "", "fields": "SignLocationID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Sign Maintenance", "description": "", "prototype": { "attributes": { "SupportMaintenance": "300 - None", "Comments": null, "SignLocationID": null, "MaintenanceDate": null, "ReasonForMaintenance": null, "LocationMaintenance": "400 - None", "SignMaintenance": "200 - None" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ed221c79fd19486fa02cf7409e9caa0a" } ] }