{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "TIP_Survey_crash_reports", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "crash_reports", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "crash_date", "length": 29, "alias": "Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crash_time", "length": 255, "alias": "Time of Day", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crash_location", "length": 255, "alias": "Location (i.e., street name, cross street, intersection)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_crash_collission_type", "type": "codedValue", "codedValues": [ { "code": "animal", "name": "Animal" }, { "code": "bicycle", "name": "Bicycle" }, { "code": "fixed_object", "name": "Fixed Object" }, { "code": "motor_vehicle", "name": "Motor Vehicle in Transport" }, { "code": "parked_motor_vehicle", "name": "Parked Motor Vehicle" }, { "code": "pedestrian", "name": "Pedestrian" }, { "code": "other", "name": "Other" } ] }, "name": "crash_collission_type", "length": 255, "alias": "Collision Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crash_collission_type_other", "length": 255, "alias": "Specify other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_crash_severity", "type": "codedValue", "codedValues": [ { "code": "fatal", "name": "Fatal" }, { "code": "serious injury", "name": "Serious Injury" }, { "code": "minor injury", "name": "Minor Injury" }, { "code": "PDO", "name": "PDO" } ] }, "name": "crash_severity", "length": 255, "alias": "Severity", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_crash_road_conditions", "type": "codedValue", "codedValues": [ { "code": "dry", "name": "Dry" }, { "code": "wet", "name": "Wet" }, { "code": "other", "name": "Other" } ] }, "name": "crash_road_conditions", "length": 255, "alias": "Road Conditions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crash_road_conditions_other", "length": 255, "alias": "Specify other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_crash_light_conditions", "type": "codedValue", "codedValues": [ { "code": "daylight", "name": "Daylight" }, { "code": "dark_lighted", "name": "Dark-Lighted" }, { "code": "dark_unlighted", "name": "Dark-Unlighted" }, { "code": "other", "name": "Other" } ] }, "name": "crash_light_conditions", "length": 255, "alias": "Light Conditions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crash_light_conditions_other", "length": 255, "alias": "Specify other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "r246_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_246", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "TIP_Survey_countermeasures", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "countermeasures", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "countermeasures_name", "length": 255, "alias": "Countermeasure Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cmf", "length": 255, "alias": "Crash Modification Factor (CMF)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cmf_id", "length": 255, "alias": "CMF ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "r247_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_247", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "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": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "TIP_Survey_crash_reports", "relatedTableId": 4, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "TIP_Survey_countermeasures", "relatedTableId": 5, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "TIP_Survey_point_location", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "TIP_Survey_line_location", "relatedTableId": 2, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "TIP_Survey_polygon_location", "relatedTableId": 3, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "TIP_Survey", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_agreement", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "I have read and understand the application guidelines." } ] }, "name": "agreement", "length": 255, "alias": "Do you agree to the Application Guidelines?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_name", "length": 255, "alias": "Project Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_number", "length": 255, "alias": "Project Number (RBXX-0XX)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_limits", "length": 255, "alias": "Project Limits", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_length", "alias": "Project Length", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_functional_class", "length": 255, "alias": "Federal Functional Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_functional_class_other", "length": 255, "alias": "Specify other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fed_class_other", "length": 255, "alias": "Please explain.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "useful_life_years", "alias": "Anticipated useful life of the proposed improvements in years", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "estimated_completion", "length": 29, "alias": "Estimated Date of Completion", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adt_existing", "alias": "ADT: Existing", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adt_construction_year", "alias": "ADT: Construction Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adt_future_projected", "alias": "ADT: Future/Projected", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "existing_conditions", "length": 1000, "alias": "Existing Conditions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_improvements", "length": 1000, "alias": "Proposed roadway improvements", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traffic_improvements", "length": 1000, "alias": "Proposed traffic flow improvements", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safety_improvements", "length": 1000, "alias": "Proposed safety improvements", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bike_pedestrian_improvements", "length": 1000, "alias": "Proposed bicycle/pedestrian improvements", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ggl_improvements", "length": 1000, "alias": "Proposed Gateway Green Light (GGL) improvements", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_ggl_coordination", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" }, { "code": "n/a", "name": "N/A" } ] }, "name": "ggl_coordination", "length": 255, "alias": "Have the above GGL improvements been coordinated with Roads & Traffic department?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "utility_impacts", "length": 1000, "alias": "Utility Impacts", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_sponsoring_agency", "type": "codedValue", "codedValues": [ { "code": "CH", "name": "County Highway" }, { "code": "DP", "name": "Dardenne Prairie" }, { "code": "LSL", "name": "Lake Saint Louis" }, { "code": "OF", "name": "O'Fallon" }, { "code": "SC", "name": "Saint Charles" }, { "code": "SP", "name": "Saint Peters" }, { "code": "WZ", "name": "Wentzville" }, { "code": "other", "name": "Other" } ] }, "name": "sponsoring_agency", "length": 255, "alias": "Sponsoring Agency", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sponsoring_agency_other", "length": 255, "alias": "Specify other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cp_name", "length": 255, "alias": "Contact Person: Full Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cp_title", "length": 255, "alias": "Contact Person: Job Title", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cp_phone", "length": 255, "alias": "Contact Person: Phone Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cp_email", "length": 255, "alias": "Contact Person: E-mail Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_project_type", "type": "codedValue", "codedValues": [ { "code": "new_road", "name": "New Road" }, { "code": "condition", "name": "Condition" }, { "code": "bridge", "name": "Bridge" }, { "code": "traffic_flow", "name": "Traffic Flow" }, { "code": "safety", "name": "Safety" }, { "code": "bike_pedestrian", "name": "Bicycle/Pedestrian" } ] }, "name": "project_type", "length": 255, "alias": "What type of project is this application for?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_bike_ped_inclusion", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "bike_ped_inclusion", "length": 255, "alias": "Does the project include proposed bicycle and/or pedestrian improvements?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_condition_rating", "alias": "General Condition Ratings (0-9)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_bridge_federal_funding", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "bridge_federal_funding", "length": 255, "alias": "Is bridge replacement eligible for federal funding?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_bridge_funding_status", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "pending", "name": "Pending" } ] }, "name": "bridge_funding_status", "length": 255, "alias": "Has federal funding been approved?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_ineligible", "length": 1000, "alias": "Please explain why the project is not eligible for federal funding?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_bridge_detour", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "bridge_detour", "length": 255, "alias": "Will a detour be necessary for the bridge closure?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_detour_impact", "length": 1000, "alias": "Has the Agency considered a detour that is less impactful to emergency services? Please explain.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pavement_condition_index", "alias": "Pavement Condition Index (0-100)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_meet_roadway_repurposing", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "meet_roadway_repurposing", "length": 255, "alias": "Has the proposed typical section been approved by the Roads & Traffic department to determine if roadway repurposing is possible?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "explain_repurposing", "length": 1000, "alias": "Explain the proposed roadway repurposing or why it is not possible.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_design_speed", "alias": "Design Speed (mph)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_posted_speed", "alias": "Posted Speed Limit (mph)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_condition_speed_reduced", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "condition_speed_reduced", "length": 255, "alias": "Can the Design Speed/Posted Speed Limit be reduced?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_explain_reduced", "length": 1000, "alias": "Please Explain.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_road_thoroughfare_plan", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "road_thoroughfare_plan", "length": 255, "alias": "Is the proposed road on the County's or the City's thoroughfare plan?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "explain_thoroughfare_plan", "length": 1000, "alias": "Explain why the proposed road is not part of a thoroughfare plan.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "road_design_speed", "alias": "Design Speed (mph)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "road_posted_speed", "alias": "Posted Speed Limit (mph)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_road_meet_criteria", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "road_meet_criteria", "length": 255, "alias": "Has the proposed typical section been approved by the Roads & Traffic department?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traffic_flow_explanation", "length": 1000, "alias": "If a traffic study is not available, please explain why.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_traffic_flow_type", "type": "codedValue", "codedValues": [ { "code": "road_segment", "name": "Road Segment" }, { "code": "intersection", "name": "Intersection" } ] }, "name": "traffic_flow_type", "length": 255, "alias": "What type of Traffic Flow project is proposed?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_traffic_flow_section", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "traffic_flow_section", "length": 255, "alias": "Has the proposed typical section been approved by the Roads & Traffic department?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_bike_ped_fac", "type": "codedValue", "codedValues": [ { "code": "both", "name": "Both Bicycle and Pedestrian" }, { "code": "on_street_bicycle", "name": "On-street Bicycle Only" }, { "code": "pedestrian_only", "name": "Pedestrian Only" } ] }, "name": "bike_ped_fac", "length": 255, "alias": "What type of facility does this project provide for?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ped_network", "length": 1000, "alias": "Briefly discuss how the proposed pedestrian improvement will establish a connection in the development of the pedestrian network.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bike_pedestrian_project", "length": 1000, "alias": "Briefly discuss how the proposed bicycle and/or pedestrian improvement will establish a connection to assist in St. Charles County's overall vision to develop a low-stress bicycle and pedestrian network.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_gateway_bike_plan", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" }, { "code": "part", "name": "No, but is part of another adopted plan." } ] }, "name": "gateway_bike_plan", "length": 255, "alias": "Is the proposed project identified in the adopted St. Charles County Gateway Bike Plan?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gateway_bike_explain", "length": 1000, "alias": "Please Explain.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_gateway_bike_fac", "type": "codedValue", "codedValues": [ { "code": "shared_use", "name": "Shared Use Path" }, { "code": "sidepath", "name": "Sidepath" }, { "code": "seperated_bike", "name": "Separated Bike Lane" }, { "code": "buffered_bike", "name": "Buffered Bike Lane" }, { "code": "bike_lane", "name": "Bike Lane" }, { "code": "paved_shoulder", "name": "Paved Shoulder" }, { "code": "calm_street", "name": "Calm Street" }, { "code": "marked_signaled_roadway", "name": "Marked and/or Signed Shared Roadway" } ] }, "name": "gateway_bike_fac", "length": 255, "alias": "Per the St. Charles County Gateway Bike Plan, what is the recommended facility type?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_recommended_fac_type", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "recommended_fac_type", "length": 255, "alias": "Does the proposed project follow the recommended facility type?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "not_fac_type", "length": 1000, "alias": "Please explain why the proposed project does not match the recommended facility type.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name_adopted_plan", "length": 255, "alias": "Please provide name of adopted plan.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_safety_typical_section", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "safety_typical_section", "length": 255, "alias": "Has the proposed typical section been approved by the Roads & Traffic department?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_crash_presence", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "crash_presence", "length": 255, "alias": "Were there any crashes within the proposed project limts in the last 3 years?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_safety_issues", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "safety_issues", "length": 255, "alias": "Are there any documented or undocumented safety issue(s)?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_crash_prevention", "length": 1000, "alias": "Please describe how the proposed roadway improvements/countermeasure(s) will address safety to reduce crashes. If addressing an undocumented safety issue(s) and explain how the preventive safety countermeasure(s) will address the issue.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_safety_study", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "safety_study", "length": 255, "alias": "Is the proposed improvement(s) identified in any safety study or plan such as in a Road Safety Audit (RSA) or the St. Charles County Strategic Highway Safety Plan?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "safety_study_explain", "length": 1000, "alias": "Please Explain.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_study_name", "type": "codedValue", "codedValues": [ { "code": "highway_safety", "name": "St. Charles County Strategic Highway Safety Plan" }, { "code": "other", "name": "Other" } ] }, "name": "study_name", "length": 255, "alias": "Please identify the study or plan", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "study_name_other", "length": 255, "alias": "Specify Other.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_fund_type", "type": "codedValue", "codedValues": [ { "code": "design", "name": "Design Only" }, { "code": "design_rw", "name": "Design & R/W Only" }, { "code": "rw", "name": "R/W Only" }, { "code": "design_construct", "name": "Design & Construction Only" }, { "code": "rw_construct", "name": "R/W & Construction Only" }, { "code": "construction", "name": "Construction Only" }, { "code": "design_rw_construct", "name": "Design, R/W & Construction" } ] }, "name": "fund_type", "length": 255, "alias": "Please indicate what type of County Road Board funds sponsoring agency is requesting.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_5e29bb6d1b094ece8da314e3fa82727c_cvd_additional_funds", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "additional_funds", "length": 255, "alias": "Does sponsoring agency anticipate requesting additional funds in subsequent years for project?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fund_amount", "length": 255, "alias": "Please provide estimated additional amount to be requested.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "anticpated_approval", "length": 29, "alias": "Anticipated Preliminary Plan Approval", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "a_date_approval", "length": 29, "alias": "Anticipated A-Date Approval", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "pse_approval", "length": 29, "alias": "Anticipated PS&E Approval", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "construciton_completion", "length": 29, "alias": "Anticipated Construction Completion", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a176_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r241_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_241", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "TIP Application", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "TIP_Survey_point_location", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "point_location", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a177_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r243_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_243", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "TIP Application", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "TIP_Survey_line_location", "relatedTableId": 0, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "line_location", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a178_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r244_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_244", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 178, 255, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "TIP Application", "type": "simple" }, "transparency": 0 }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "TIP_Survey_polygon_location", "relatedTableId": 0, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "polygon_location", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "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" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a179_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r245_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_245", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 178, 255, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 0, 178, 255, 48 ], "style": "esriSFSSolid", "type": "esriSFS" }, "label": "TIP Application", "type": "simple" }, "transparency": 0 }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }