{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "CENWP_DOUGS_BASE_MASTER_TEMPLATE_int_data_trk", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 1, "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": "int_data_trk", "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": "gsr_int_name", "length": 255, "alias": "Internal Dataset Name:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_int_source", "length": 1000, "alias": "Internal Dataset Source:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_data_lvl", "type": "codedValue", "codedValues": [ { "code": "no_gis", "name": "Data will not contain location (geospatial) or (geotechnical) information. Does not require inclusion in the District's GIS." }, { "code": "1", "name": "Data contains ephemeral geospatial information. This information will not need to be accessible for use in other mapping projects in the future." }, { "code": "2", "name": "Data contains geospatial information but is only cartographic in nature. Data will NOT be queried or part of a GIS analysis." }, { "code": "3", "name": "Data contains geospatial information. Queries and modeling may be performed on the data. This will result in the creation of District GIS data set which will be managed for the enterprise." } ] }, "name": "gsr_data_lvl", "length": 255, "alias": "Internal Dataset Level:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_int_cui", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_int_cui", "length": 255, "alias": "Is data CUI?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_int_sdsfie", "length": 255, "alias": "Internal Dataset SDSFIE Classification:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_data_pub", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_data_pub", "length": 255, "alias": "Is the dataset published to a Web GIS Platform?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_data_url", "length": 255, "alias": "Rest Service URL:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_int_notes", "length": 1000, "alias": "Notes/Comments:", "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, "allowGeometryUpdates": false, "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": "r414_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_414", "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,Delete,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": 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" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "CENWP_DOUGS_BASE_MASTER_TEMPLATE_ext_data_trk", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 2, "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": "ext_data_trk", "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": "gsr_ext_name", "length": 255, "alias": "External Dataset Name:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_ext_source", "length": 1000, "alias": "External Dataset Source:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_ext_lvl", "type": "codedValue", "codedValues": [ { "code": "no_gis", "name": "Data will not contain location (geospatial) or (geotechnical) information. Does not require inclusion in the District's GIS." }, { "code": "1", "name": "Data contains ephemeral geospatial information. This information will not need to be accessible for use in other mapping projects in the future." }, { "code": "2", "name": "Data contains geospatial information but is only cartographic in nature. Data will NOT be queried or part of a GIS analysis." }, { "code": "3", "name": "Data contains geospatial information. Queries and modeling may be performed on the data. This will result in the creation of District GIS data set which will be managed for the enterprise." } ] }, "name": "gsr_ext_lvl", "length": 255, "alias": "External Dataset Level:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_ext_cui", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_ext_cui", "length": 255, "alias": "Is data CUI?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_ext_sdsfie", "length": 255, "alias": "External Dataset SDSFIE Classification:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_ext_data_pub", "length": 255, "alias": "Is the dataset published to a Web GIS Platform?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_ext_data_url", "length": 255, "alias": "Rest Service URL:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_ext_notes", "length": 1000, "alias": "Notes/Comments:", "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, "allowGeometryUpdates": false, "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": "r415_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_415", "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,Delete,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": 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" ], "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "CENWP_DOUGS_BASE_MASTER_TEMPLATE_int_data_trk", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "CENWP_DOUGS_BASE_MASTER_TEMPLATE_ext_data_trk", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "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": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "CENWP_DOUGS_BASE_MASTER_TEMPLATE", "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_4d31e23870fb443088f9ec76451c9286_cvd_gsr_type", "type": "codedValue", "codedValues": [ { "code": "no_gis", "name": "Data will not contain location (geospatial) or (geotechnical) information. Does not require inclusion in the District's GIS." }, { "code": "1", "name": "Data contains ephemeral geospatial information. This information will not need to be accessible for use in other mapping projects in the future." }, { "code": "2", "name": "Data contains geospatial information but is only cartographic in nature. Data will NOT be queried or part of a GIS analysis." }, { "code": "3", "name": "Data contains geospatial information. Queries and modeling may be performed on the data. This will result in the creation of District GIS data set which will be managed for the enterprise." } ] }, "name": "gsr_type", "length": 255, "alias": "Geospatial Data Request Type:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_wvp", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_wvp", "length": 255, "alias": "Is the request associated with the WVP?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_p2", "length": 255, "alias": "P2 Number:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_p2_int", "alias": "gsr_p2_int", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_lc", "length": 255, "alias": "ENC-TG Labor Code:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_lc_int", "alias": "gsr_lc_int", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_tl", "length": 255, "alias": "PDT Team Lead:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_desc", "length": 1000, "alias": "Brief Request Description:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_req_email", "length": 255, "alias": "Contact Email:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_wvp_app", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_wvp_app", "length": 255, "alias": "Request Approved?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_wvp_note", "length": 1000, "alias": "ENC-TG Request Notes:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_gis_tl", "type": "codedValue", "codedValues": [ { "code": "g2encstc", "name": "Sean Carroll" }, { "code": "g2echgmb", "name": "Gregg Bertrand" }, { "code": "g2echdcs", "name": "Douglas Swanson" }, { "code": "g2ectjgm", "name": "Jason Miller" }, { "code": "g2odnkja", "name": "Joel Kinunen" }, { "code": "g2encdvc", "name": "DeAnna Clum" }, { "code": "g2encmbt", "name": "Megan Thayne" } ] }, "name": "gsr_gis_tl", "length": 255, "alias": "GIS Tech Lead:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_etds_dir", "length": 1000, "alias": "ETDS Directory Path:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_etds_dir_1", "type": "codedValue", "codedValues": [ { "code": "WILLAMETTE", "name": "WILLAMETTE" }, { "code": "COASTAL", "name": "COASTAL" }, { "code": "ROGUE", "name": "ROGUE" }, { "code": "COLUMBIA", "name": "COLUMBIA" }, { "code": "MISC", "name": "MISC" }, { "code": "MT_ST_HELENS", "name": "MT_ST_HELENS" } ] }, "name": "etds_dir_1", "length": 255, "alias": "ETDS Project Folder:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_etds_dir_2", "type": "codedValue", "codedValues": [ { "code": "MCR", "name": "MCR" }, { "code": "COLUMBIA", "name": "COLUMBIA" }, { "code": "NEHALEM", "name": "NEHALEM" }, { "code": "TILLAMOOK", "name": "TILLAMOOK" }, { "code": "DEPOE_BAY", "name": "DEPOE_BAY" }, { "code": "UMPQUA", "name": "UMPQUA" }, { "code": "COOS_BAY", "name": "COOS_BAY" }, { "code": "COQUILLE", "name": "COQUILLE" }, { "code": "GOLD_BEACH", "name": "GOLD_BEACH" }, { "code": "PORT ORFORD", "name": "PORT ORFORD" }, { "code": "CHETCO", "name": "CHETCO" }, { "code": "YAQUINA", "name": "YAQUINA" }, { "code": "APPLEGATE", "name": "APPLEGATE" }, { "code": "ELK_CREEK", "name": "ELK_CREEK" }, { "code": "LOST_CREEK", "name": "LOST_CREEK" }, { "code": "ROGUE_RIVER", "name": "ROGUE_RIVER" }, { "code": "WILLOW_CREEK", "name": "WILLOW_CREEK" }, { "code": "SRS", "name": "SRS" }, { "code": "COWEEMAN", "name": "COWEEMAN" }, { "code": "SPIRIT_LAKE", "name": "SPIRIT_LAKE" }, { "code": "COWLITZ", "name": "COWLITZ" }, { "code": "TOUTLE", "name": "TOUTLE" }, { "code": "JOHN_DAY", "name": "JOHN_DAY" }, { "code": "THE_DALLES", "name": "THE_DALLES" }, { "code": "LEWIS", "name": "LEWIS" }, { "code": "BONNEVILLE", "name": "BONNEVILLE" }, { "code": "LCR", "name": "LCR" }, { "code": "SIUSLAW", "name": "SIUSLAW" }, { "code": "CLW", "name": "CLW" }, { "code": "WILLAMETTE_RIVER", "name": "WILLAMETTE_RIVER" }, { "code": "BIG_CLIFF", "name": "BIG_CLIFF" }, { "code": "DETROIT", "name": "DETROIT" }, { "code": "GREEN_PETER", "name": "GREEN_PETER" }, { "code": "FOSTER", "name": "FOSTER" }, { "code": "FERN_RIDGE", "name": "FERN_RIDGE" }, { "code": "COTTAGE_GROVE", "name": "COTTAGE_GROVE" }, { "code": "DORENA", "name": "DORENA" }, { "code": "FALL_CREEK", "name": "FALL_CREEK" }, { "code": "HILLS_CREEK", "name": "HILLS_CREEK" }, { "code": "BLUE_RIVER", "name": "BLUE_RIVER" }, { "code": "COUGAR", "name": "COUGAR" }, { "code": "LOOKOUT_POINT", "name": "LOOKOUT_POINT" }, { "code": "DEXTER", "name": "DEXTER" } ] }, "name": "etds_dir_2", "length": 255, "alias": "ETDS Project Sub-Folder:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "etds_dir_3", "length": 255, "alias": "etds_dir_3", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_pjws_dir", "length": 255, "alias": "gsr_pjws_dir", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pjws_dir_1", "length": 255, "alias": "pjws_dir_1", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pjws_dir_2", "length": 255, "alias": "pjws_dir_2", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pjws_dir_3", "length": 255, "alias": "pjws_dir_3", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_cor_zon", "length": 255, "alias": "Coordinate System and Datums:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_pref_cor_zon", "type": "codedValue", "codedValues": [ { "code": "NAD 1983 (2011) StatePlane Oregon North FIPS 3601", "name": "Oregon North (FIPS 3601)" }, { "code": "NAD 1983 (2011) StatePlane Oregon South FIPS 3602", "name": "Oregon South (FIPS 3602)" }, { "code": "NAD 1983 (2011) StatePlane Washington South FIPS 4602", "name": "Washington South (FIPS 3602)" }, { "code": "Universal Transverse Mercator (UTM)", "name": "Universal Transverse Mercator (UTM)" }, { "code": "USA Contiguous Albers Equal Area Conic USGS version", "name": "USA Contiguous Albers Equal Area Conic USGS version" }, { "code": "Geographic (Unprojected)", "name": "Geographic (Unprojected)" }, { "code": "Other", "name": "Other" } ] }, "name": "pref_cor_zon", "length": 255, "alias": "Coordinate System/Zone:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_hor_dat", "type": "codedValue", "codedValues": [ { "code": "NAD83 (2011)", "name": "NAD83 (2011) (Preferred)" }, { "code": "NAD 27", "name": "NAD 27" }, { "code": "WGS 84", "name": "WGS 84" }, { "code": "Other", "name": "Other" } ] }, "name": "gsr_hor_dat", "length": 255, "alias": "Horizontal Datum (Geodetic Reference System-GRS):", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_hor_dat", "length": 1000, "alias": "Justification for use of non-preferred horizontal datum:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_hor_msr", "type": "codedValue", "codedValues": [ { "code": "International Foot", "name": "International Foot (Preferred)" }, { "code": "US Survey Foot", "name": "US Survey Foot" }, { "code": "Meter", "name": "Meter" }, { "code": "Latitude/Longitude", "name": "Latitude/Longitude" }, { "code": "Other", "name": "Other" } ] }, "name": "gsr_hor_msr", "length": 255, "alias": "Horizontal Measure:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_hor_msr", "length": 1000, "alias": "Justification for use of non-preferred horizontal measure:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_vrt_dat", "type": "codedValue", "codedValues": [ { "code": "NAVD88/Geoid12A", "name": "NAVD88/Geoid12A (Preferred)" }, { "code": "Columbia River Datum (CRD)", "name": "Columbia River Datum (CRD)" }, { "code": "NGVD 29", "name": "NGVD 29" }, { "code": "Other", "name": "Other" } ] }, "name": "gsr_vrt_dat", "length": 255, "alias": "Vertical Datum:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_other_vrt_dat", "type": "codedValue", "codedValues": [ { "code": "as_builts", "name": "The current project relies heavily on older 'as-built' drawings referencing project datum." }, { "code": "legacy_datum", "name": "The current project relies on data or models referencing a legacy datum." }, { "code": "project_id", "name": "Project datum is part of a projects identity (i.e. levels of a dam named for their elevation)." }, { "code": "accurate_model", "name": "The relationship between the non-preferred legacy datum and NAVD88 is accurately modeled at the project location. See the district Vertical Datum Coordinator in CENWP-OD-NWH to confirm." } ] }, "name": "other_vrt_dat", "length": 255, "alias": "Justification for use of non-preferred vertical datum:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_vrt_msr", "type": "codedValue", "codedValues": [ { "code": "US Survey Foot", "name": "US Survey Foot" }, { "code": "International Foot", "name": "International Foot (Preferred)" }, { "code": "Meter", "name": "Meter" }, { "code": "Other", "name": "Other" } ] }, "name": "gsr_vrt_msr", "length": 255, "alias": "Vertical measure:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_vrt_msr", "length": 1000, "alias": "Justification for use of non-preferred vertical measure:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_egis_cnt", "type": "codedValue", "codedValues": [ { "code": "Sean Carroll", "name": "Sean Carroll" } ] }, "name": "egis_cnt", "length": 255, "alias": "Enterprise-GIS POC:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_data_asp", "length": 1000, "alias": "What is the geospatial data aspect of the project?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_adq_data", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ] }, "name": "gsr_adq_data", "length": 255, "alias": "Is adequate geospatial data already available?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gsr_data_type", "length": 255, "alias": "What types of geospatial data will the project include?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_data_type", "length": 1000, "alias": "Describe the 'Other\" type of data that will be included:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_ext_data", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "NA", "name": "Not Applicable" } ] }, "name": "gsr_ext_data", "length": 255, "alias": "Will/Does the project include external datasets?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "prj_close_date", "length": 29, "alias": "Project Closeout Date:", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_new_data", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_new_data", "length": 255, "alias": "Was new geospatial data collected for this Project?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_gis_tl_qa", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_gis_tl_qa", "length": 255, "alias": "Have you completed all elements required for the GDMP Tracker entry for this Project?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_egis_qa", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_egis_qa", "length": 255, "alias": "Have you reviewed all elements required for the GDMP Tracker entry for this Project?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4d31e23870fb443088f9ec76451c9286_cvd_gsr_sup_qa", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "gsr_sup_qa", "length": 255, "alias": "Have you reviewed all elements required for the GDMP Tracker entry for this Project?", "type": "esriFieldTypeString" }, { "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" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dougs_base_globalid_txt", "length": 255, "alias": "DOUGS_BASE_GLOBALID_TXT", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "logo_seal", "length": 255, "alias": "logo_seal", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "intro", "length": 255, "alias": "CENWP Geomatics Repository for Enterprise Geospatial Governance", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a255_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r412_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_412", "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 }, "enableZDefaults": true, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": 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": "CENWP-DOUGS-BASE-MASTER-TEMPLATE", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }