{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Speed Limits", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PubWorks.DBO.SpeedData", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Segment", "composite": false, "catalogID": "{FA946B9D-1779-4325-88B1-ACEE5CA1559D}" } ], "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, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 6620599.999410808, "ymin": 1958115.5942570567, "xmax": 6654380.43545872, "ymax": 1971506.001203224, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SpeedLimit", "uniqueValueGroups": [ { "heading": "Posted Speed", "classes": [ { "label": "25", "description": "25", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 52, 17, 255 ], "width": 2 }, "values": [ [ "25" ] ] }, { "label": "30", "description": "30", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 34, 139, 34, 255 ], "width": 2 }, "values": [ [ "30" ] ] }, { "label": "35", "description": "35", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 197, 255, 255 ], "width": 2 }, "values": [ [ "35" ] ] }, { "label": "40", "description": "40", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "values": [ [ "40" ] ] }, { "label": "45", "description": "45", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "values": [ [ "45" ] ] }, { "label": "50", "description": "50", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "values": [ [ "50" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 52, 17, 255 ], "width": 2 }, "value": "25", "label": "25" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 34, 139, 34, 255 ], "width": 2 }, "value": "30", "label": "30" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 197, 255, 255 ], "width": 2 }, "value": "35", "label": "35" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "value": "40", "label": "40" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "value": "45", "label": "45" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "value": "50", "label": "50" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 226, 252, 212, 255 ], "toColor": [ 226, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 251, 255 ], "toColor": [ 252, 179, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 219, 252, 255 ], "toColor": [ 182, 219, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 200, 197, 255 ], "toColor": [ 252, 200, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 249, 255 ], "toColor": [ 184, 252, 249, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 179, 252, 255 ], "toColor": [ 184, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 215, 252, 255 ], "toColor": [ 241, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 184, 255 ], "toColor": [ 179, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 229, 210, 255 ], "toColor": [ 252, 229, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 189, 221, 255 ], "toColor": [ 252, 189, 221, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 217, 255 ], "toColor": [ 184, 252, 217, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 201, 252, 255 ], "toColor": [ 182, 201, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 25, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.Segment"}, "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "straight", "deconflictionStrategy": "dynamic", "allowOverrun": true, "repeatLabel": false, "lineConnection": "minimizeLabels", "useClippedGeometry": true, "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 25000, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 1, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PDF", "typeIdField": "SpeedLimit", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Segment", "type": "esriFieldTypeDouble", "alias": "Segment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "SpeedLimit", "type": "esriFieldTypeSmallInteger", "alias": "Posted Speed Limit", "domain": { "type": "codedValue", "name": "Speed", "description": "Posted Speed Limit", "codedValues": [ { "name": "25 MPH", "code": 25 }, { "name": "30 MPH", "code": 30 }, { "name": "35 MPH", "code": 35 }, { "name": "40 MPH", "code": 40 }, { "name": "45 MPH", "code": 45 }, { "name": "50 MPH", "code": 50 }, { "name": "55 MPH", "code": 55 }, { "name": "60 MPH", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpeedLimit" }, { "name": "Cert_Type", "type": "esriFieldTypeSmallInteger", "alias": "Certification Type", "domain": { "type": "codedValue", "name": "Cert_Type", "description": "CertificationType", "codedValues": [ { "name": "Standard", "code": 1 }, { "name": "By Ordinance", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Cert_Type" }, { "name": "expiry_date", "type": "esriFieldTypeDate", "alias": "Expiry Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "expiry_date" }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "SegmentLength", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length" }, { "name": "Width", "type": "esriFieldTypeDouble", "alias": "SegmentWidth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Width" }, { "name": "Shoulder", "type": "esriFieldTypeDouble", "alias": "ShoulderWidth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shoulder" }, { "name": "CountStation", "type": "esriFieldTypeDouble", "alias": "CountStation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CountStation" }, { "name": "Classification", "type": "esriFieldTypeString", "alias": "Classification", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Classification" }, { "name": "Calc_Length", "type": "esriFieldTypeDouble", "alias": "Calc_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Calc_Length" }, { "name": "Resurvey_Schedule", "type": "esriFieldTypeString", "alias": "Resurvey_Schedule", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Resurvey_Schedule" }, { "name": "PSvsCS", "type": "esriFieldTypeSmallInteger", "alias": "Difference bewtween Posted and Critical Speeds", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PSvsCS" }, { "name": "SpecialConditionUtilized", "type": "esriFieldTypeSmallInteger", "alias": "Special Condition Utilized?", "domain": { "type": "codedValue", "name": "Specialcondition", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Special Condition", "code": 1 }, { "name": "MUTCD Provision", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpecialConditionUtilized" }, { "name": "PDF", "type": "esriFieldTypeString", "alias": "PDF Report", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Link_to_PDF" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R344_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4076_Segment", "fields": "Segment", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_344", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_344", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S279_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": 25, "name": "25", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "25", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 25, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": 30, "name": "30", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "30", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 30, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": 35, "name": "35", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "35", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 35, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": 40, "name": "40", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "40", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 40, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": 45, "name": "45", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "45", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 45, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": 50, "name": "50", "domains": { "SpeedLimit": {"type": "inherited"}, "Cert_Type": {"type": "inherited"}, "SpecialConditionUtilized": {"type": "inherited"} }, "templates": [ { "name": "50", "description": "", "prototype": { "attributes": { "Location": null, "PDF": null, "Segment": null, "SpeedLimit": 50, "Cert_Type": null, "expiry_date": null, "Length": null, "Width": null, "Shoulder": null, "CountStation": null, "Classification": null, "Calc_Length": null, "Resurvey_Schedule": null, "PSvsCS": null, "SpecialConditionUtilized": null } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,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": true }, { "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": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "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 } ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "d68f15740ddd4ee18341960b3d79689f" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "SpeedData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PubWorks.DBO.ETSStreets", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Segment", "composite": false, "catalogID": "{FA946B9D-1779-4325-88B1-ACEE5CA1559D}" } ], "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Survey_Type", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Segment", "type": "esriFieldTypeDouble", "alias": "Segment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment" }, { "name": "Survey_Type", "type": "esriFieldTypeString", "alias": "Survey_Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Survey_Type" }, { "name": "Road_Width", "type": "esriFieldTypeString", "alias": "Road_Width", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Road_Width" }, { "name": "Shoulder_Width", "type": "esriFieldTypeString", "alias": "Shoulder_Width", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Shoulder_Width" }, { "name": "Dry", "type": "esriFieldTypeSmallInteger", "alias": "Dry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Dry" }, { "name": "Wet", "type": "esriFieldTypeSmallInteger", "alias": "Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Wet" }, { "name": "Smooth", "type": "esriFieldTypeSmallInteger", "alias": "Smooth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Smooth" }, { "name": "Bumpy", "type": "esriFieldTypeSmallInteger", "alias": "Bumpy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bumpy" }, { "name": "Holes", "type": "esriFieldTypeSmallInteger", "alias": "Holes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Holes" }, { "name": "Levels", "type": "esriFieldTypeSmallInteger", "alias": "Level_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Level_" }, { "name": "Grade", "type": "esriFieldTypeSmallInteger", "alias": "Grade", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grade" }, { "name": "Posted_Speed", "type": "esriFieldTypeDouble", "alias": "Posted_Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Posted_Speed" }, { "name": "Direction", "type": "esriFieldTypeString", "alias": "Direction", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Direction" }, { "name": "Time", "type": "esriFieldTypeDate", "alias": "Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Time" }, { "name": "to_Time", "type": "esriFieldTypeDate", "alias": "to_Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "to_Time" }, { "name": "Field_Date", "type": "esriFieldTypeDate", "alias": "Field_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Field_Date" }, { "name": "Observer", "type": "esriFieldTypeString", "alias": "Observer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Observer" }, { "name": "Calculated_by", "type": "esriFieldTypeString", "alias": "Calculated_by", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Calculated_by" }, { "name": "Total_Vehicles", "type": "esriFieldTypeDouble", "alias": "Total_Vehicles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Vehicles" }, { "name": "Pace_Low", "type": "esriFieldTypeDouble", "alias": "Pace_Low", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pace_Low" }, { "name": "Pace_High", "type": "esriFieldTypeDouble", "alias": "Pace_High", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pace_High" }, { "name": "Percent_Pace", "type": "esriFieldTypeDouble", "alias": "Percent_Pace", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent_Pace" }, { "name": "Average_Speed", "type": "esriFieldTypeDouble", "alias": "Average_Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Average_Speed" }, { "name": "Critical_Speed", "type": "esriFieldTypeDouble", "alias": "Critical_Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Critical_Speed" }, { "name": "Approved_SPAC", "type": "esriFieldTypeDate", "alias": "Approved_SPAC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Approved_SPAC" }, { "name": "CC_Action", "type": "esriFieldTypeString", "alias": "CC_Action", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CC_Action" }, { "name": "CC_Resolution_Date", "type": "esriFieldTypeDate", "alias": "CC_Resolution_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CC_Resolution_Date" }, { "name": "CC_Resolution", "type": "esriFieldTypeString", "alias": "CC_Resolution__", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CC_Resolution__" }, { "name": "Collision_Rate", "type": "esriFieldTypeString", "alias": "Collision_Rate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Collision_Rate" }, { "name": "Recommendation", "type": "esriFieldTypeString", "alias": "Recommendation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Recommendation" }, { "name": "Recommendation_By", "type": "esriFieldTypeString", "alias": "Recommendation_By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Recommendation_By" }, { "name": "Speed_Change", "type": "esriFieldTypeSmallInteger", "alias": "Speed_Change", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed_Change" }, { "name": "Number_of_Accidents__latest_2_y", "type": "esriFieldTypeDouble", "alias": "Number_of_Accidents__latest_2_y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Number_of_Accidents__latest_2_y" }, { "name": "Segment_Length__feet_", "type": "esriFieldTypeDouble", "alias": "Segment_Length__feet_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment_Length__feet_" }, { "name": "ADT", "type": "esriFieldTypeDouble", "alias": "ADT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADT" }, { "name": "PDF_Report", "type": "esriFieldTypeString", "alias": "PDF_Report", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PDF_Report" }, { "name": "Compliance", "type": "esriFieldTypeSmallInteger", "alias": "Compliance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Compliance" }, { "name": "Tally_Sheet", "type": "esriFieldTypeString", "alias": "Tally_Sheet", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tally_Sheet" }, { "name": "OnSystem", "type": "esriFieldTypeSmallInteger", "alias": "On CRS System?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OnSystem" }, { "name": "Field", "type": "esriFieldTypeInteger", "alias": "Field", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Field" }, { "name": "Special_Conditions", "type": "esriFieldTypeString", "alias": "Special Conditions", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Special_Conditions" }, { "name": "CollisionRate", "type": "esriFieldTypeDouble", "alias": "Collision Rate Calculated", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CollisionRate" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GLOBALID" } ], "indexes": [ { "name": "R346_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4079_Segment", "fields": "Segment", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_346", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_346", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SpeedData", "description": "", "prototype": { "attributes": { "Location": null, "REL_GLOBALID": null, "Segment": null, "Survey_Type": null, "Road_Width": null, "Shoulder_Width": null, "Dry": null, "Wet": null, "Smooth": null, "Bumpy": null, "Holes": null, "Levels": null, "Grade": null, "Posted_Speed": null, "Direction": null, "Time": null, "to_Time": null, "Field_Date": null, "Observer": null, "Calculated_by": null, "Total_Vehicles": null, "Pace_Low": null, "Pace_High": null, "Percent_Pace": null, "Average_Speed": null, "Critical_Speed": null, "Approved_SPAC": null, "CC_Action": null, "CC_Resolution_Date": null, "CC_Resolution": null, "Collision_Rate": null, "Recommendation": null, "Recommendation_By": null, "Speed_Change": null, "Number_of_Accidents__latest_2_y": null, "Segment_Length__feet_": null, "ADT": null, "PDF_Report": null, "Compliance": null, "Tally_Sheet": null, "OnSystem": null, "Field": null, "Special_Conditions": null, "CollisionRate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "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 } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d68f15740ddd4ee18341960b3d79689f" } ] }