{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "Watersheds.SDE.ProjectInformation", "type": "Feature Layer", "description": "Watersheds.SDE.ProjectInformation", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103069, "latestWkid": 6488, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 87, 48, 155, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -120561100, "ymin": -95444400, "xmax": 1566270.000020802, "ymax": 744920.5799635649, "spatialReference": { "wkid": 103069, "latestWkid": 6488, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "WPname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 25, "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 100, "domain": null }, { "name": "WPlocation", "type": "esriFieldTypeString", "alias": "WPlocation", "length": 50, "domain": null }, { "name": "WPtype", "type": "esriFieldTypeString", "alias": "WPtype", "length": 30, "domain": null }, { "name": "WPscope", "type": "esriFieldTypeString", "alias": "WPscope", "length": 255, "domain": null }, { "name": "WPstatus", "type": "esriFieldTypeString", "alias": "WPstatus", "length": 30, "domain": null }, { "name": "WPphase", "type": "esriFieldTypeString", "alias": "WPphase", "length": 50, "domain": null }, { "name": "WPstart", "type": "esriFieldTypeDate", "alias": "WPstart", "length": 8, "domain": null }, { "name": "WPcomplete", "type": "esriFieldTypeDate", "alias": "WPcomplete", "length": 8, "domain": null }, { "name": "WPmonitor", "type": "esriFieldTypeString", "alias": "WPmonitor", "length": 255, "domain": null }, { "name": "Property", "type": "esriFieldTypeString", "alias": "Property", "length": 50, "domain": null }, { "name": "MS4Permit", "type": "esriFieldTypeString", "alias": "MS4Permit", "length": 5, "domain": null }, { "name": "WPcost", "type": "esriFieldTypeInteger", "alias": "WPcost", "domain": null }, { "name": "WPgrant", "type": "esriFieldTypeInteger", "alias": "WPgrant", "domain": null }, { "name": "Designer", "type": "esriFieldTypeString", "alias": "Designer", "length": 50, "domain": null }, { "name": "DesignPM", "type": "esriFieldTypeString", "alias": "DesignPM", "length": 15, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 50, "domain": null }, { "name": "ConInspector", "type": "esriFieldTypeString", "alias": "ConInspector", "length": 10, "domain": null }, { "name": "ConManager", "type": "esriFieldTypeString", "alias": "ConManager", "length": 50, "domain": null }, { "name": "Council", "type": "esriFieldTypeString", "alias": "Council", "length": 50, "domain": null }, { "name": "MDE12DIG", "type": "esriFieldTypeString", "alias": "MDE12DIG", "length": 15, "domain": null }, { "name": "ADC", "type": "esriFieldTypeString", "alias": "ADC", "length": 50, "domain": null }, { "name": "Watershed", "type": "esriFieldTypeString", "alias": "Watershed", "length": 50, "domain": null }, { "name": "NorthingFT", "type": "esriFieldTypeDouble", "alias": "NorthingFT", "domain": null }, { "name": "EastingFT", "type": "esriFieldTypeDouble", "alias": "EastingFT", "domain": null }, { "name": "WPlans", "type": "esriFieldTypeString", "alias": "WPlans", "length": 50, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 100, "domain": null }, { "name": "Source_id", "type": "esriFieldTypeString", "alias": "Source_id", "length": 50, "domain": null }, { "name": "Source_Priority", "type": "esriFieldTypeSmallInteger", "alias": "Source_Priority", "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "length": 255, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PrintOut", "type": "esriFieldTypeString", "alias": "PrintOut", "length": 5, "domain": null }, { "name": "LFlink", "type": "esriFieldTypeString", "alias": "LFlink", "length": 255, "domain": null }, { "name": "Temp", "type": "esriFieldTypeString", "alias": "Temp", "length": 50, "domain": null }, { "name": "DesignPM2", "type": "esriFieldTypeString", "alias": "DesignPM2", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R15_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_15", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_11_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CapitalAgreements", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{DAC88D05-5DCE-47D9-837C-0D6B0B94F10A}" }, { "id": 1, "name": "CapitalStatus", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{145E1E28-DD75-443E-99F9-47096A67E195}" }, { "id": 2, "name": "CapitalReviews", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{ED12FA1B-B0D8-4019-A584-6125DB04950B}" }, { "id": 3, "name": "CapitalExpenditures", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C54B2EB0-DBA3-42F2-91CC-915E887088EA}" }, { "id": 4, "name": "CapitalPermits", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{7BF61F5D-3FFB-471D-B1FF-967A4DA7D558}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "Watersheds.SDE.CapitalAgreements", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WPname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 255, "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 255, "domain": null }, { "name": "NOprop", "type": "esriFieldTypeDouble", "alias": "NOprop", "domain": null }, { "name": "FLOODneed", "type": "esriFieldTypeString", "alias": "FLOODneed", "length": 255, "domain": null }, { "name": "FLOODob", "type": "esriFieldTypeString", "alias": "FLOODob", "length": 255, "domain": null }, { "name": "FLOODdate", "type": "esriFieldTypeDate", "alias": "FLOODdate", "length": 8, "domain": null }, { "name": "FLOODloc", "type": "esriFieldTypeString", "alias": "FLOODloc", "length": 255, "domain": null }, { "name": "AGREEdate", "type": "esriFieldTypeDate", "alias": "AGREEdate", "length": 8, "domain": null }, { "name": "AGREEloc", "type": "esriFieldTypeString", "alias": "AGREEloc", "length": 255, "domain": null }, { "name": "AGREEnote", "type": "esriFieldTypeString", "alias": "AGREEnote", "length": 255, "domain": null }, { "name": "PLATSneed", "type": "esriFieldTypeString", "alias": "PLATSneed", "length": 255, "domain": null }, { "name": "PLATob", "type": "esriFieldTypeString", "alias": "PLATob", "length": 255, "domain": null }, { "name": "PLATSdate", "type": "esriFieldTypeDate", "alias": "PLATSdate", "length": 8, "domain": null }, { "name": "PLATSloc", "type": "esriFieldTypeString", "alias": "PLATSloc", "length": 255, "domain": null }, { "name": "AGREEneed", "type": "esriFieldTypeString", "alias": "temp1", "length": 255, "domain": null }, { "name": "AGREEob", "type": "esriFieldTypeString", "alias": "temp2", "length": 255, "domain": null } ], "indexes": [ { "name": "R20_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_18_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ProjectInformation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{DAC88D05-5DCE-47D9-837C-0D6B0B94F10A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "Watersheds.SDE.CapitalPermits", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WPname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 255, "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 255, "domain": null }, { "name": "SWM", "type": "esriFieldTypeString", "alias": "SWM", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWMdate", "type": "esriFieldTypeDate", "alias": "SWMdate", "length": 8, "domain": null }, { "name": "SWMloc", "type": "esriFieldTypeString", "alias": "SWMloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWMwaiver", "type": "esriFieldTypeString", "alias": "SWMwaiver", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatusWaiver", "description": "Status of permit waiver", "codedValues": [ { "name": "Submitted", "code": "Submitted" }, { "name": "Approved", "code": "Approved" }, { "name": "N/A", "code": "N/A" }, { "name": "Pending", "code": "Pending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWMwaiverDate", "type": "esriFieldTypeDate", "alias": "SWMwaiverDate", "length": 8, "domain": null }, { "name": "SWMwaiverLoc", "type": "esriFieldTypeString", "alias": "SWMwaiverLoc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRADE", "type": "esriFieldTypeString", "alias": "GRADE", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRADEdate", "type": "esriFieldTypeDate", "alias": "GRADEdate", "length": 8, "domain": null }, { "name": "GRADEloc", "type": "esriFieldTypeString", "alias": "GRADEloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MDE", "type": "esriFieldTypeString", "alias": "MDE", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MDEdate", "type": "esriFieldTypeString", "alias": "MDEdate", "length": 255, "domain": null }, { "name": "MDEloc", "type": "esriFieldTypeString", "alias": "MDEloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACOE", "type": "esriFieldTypeString", "alias": "ACOE", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACOEdate", "type": "esriFieldTypeDate", "alias": "ACOEdate", "length": 8, "domain": null }, { "name": "ACOEloc", "type": "esriFieldTypeString", "alias": "ACOEloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOI", "type": "esriFieldTypeString", "alias": "NOI", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOIdate", "type": "esriFieldTypeDate", "alias": "NOIdate", "length": 8, "domain": null }, { "name": "NOIloc", "type": "esriFieldTypeString", "alias": "NOIloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHA", "type": "esriFieldTypeString", "alias": "SHA", "length": 255, "domain": { "type": "codedValue", "name": "PermitStatus", "description": "Permit Status", "codedValues": [ { "name": "Final", "code": "Final" }, { "name": "Pending", "code": "Pending" }, { "name": "1st Review", "code": "1st Review" }, { "name": "2nd Review", "code": "2nd Review" }, { "name": "Expiration", "code": "Expiration" }, { "name": "Update", "code": "Update" }, { "name": "N/A", "code": "N/A" }, { "name": "Pre-app", "code": "Pre-app" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAdate", "type": "esriFieldTypeDate", "alias": "SHAdate", "length": 8, "domain": null }, { "name": "SHAloc", "type": "esriFieldTypeString", "alias": "SHAloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWMAB", "type": "esriFieldTypeString", "alias": "SWMAB", "length": 20, "domain": { "type": "codedValue", "name": "PermitStatusAB", "description": "Permit status for asbuilt submittals", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Pending", "code": "Pending" }, { "name": "1st review", "code": "1st review" }, { "name": "2nd review", "code": "2nd review" }, { "name": "Approved", "code": "Approved" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWMABdate", "type": "esriFieldTypeDate", "alias": "SWMABdate", "length": 8, "domain": null }, { "name": "SWMABloc", "type": "esriFieldTypeString", "alias": "SWMABloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRAB", "type": "esriFieldTypeString", "alias": "STRAB", "length": 50, "domain": { "type": "codedValue", "name": "PermitStatusAB", "description": "Permit status for asbuilt submittals", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Pending", "code": "Pending" }, { "name": "1st review", "code": "1st review" }, { "name": "2nd review", "code": "2nd review" }, { "name": "Approved", "code": "Approved" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRABdate", "type": "esriFieldTypeDate", "alias": "STRABdate", "length": 8, "domain": null }, { "name": "STRAABloc", "type": "esriFieldTypeString", "alias": "STRABloc", "length": 50, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "ProjectInformation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{7BF61F5D-3FFB-471D-B1FF-967A4DA7D558}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "Watersheds.SDE.CapitalReviews", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WPname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 255, "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 255, "domain": null }, { "name": "BCI", "type": "esriFieldTypeDouble", "alias": "BCITEMP", "domain": { "type": "codedValue", "name": "OtherReviewStatus", "description": "", "codedValues": [ { "name": "10%", "code": 0.1 }, { "name": "30%", "code": 0.3 }, { "name": "75%", "code": 0.75 }, { "name": "90%", "code": 0.9 }, { "name": "100%", "code": 1 }, { "name": "N/A", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BCIdate", "type": "esriFieldTypeDate", "alias": "BCIdate", "length": 8, "domain": null }, { "name": "BCIloc", "type": "esriFieldTypeString", "alias": "BCIloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WSloc", "type": "esriFieldTypeString", "alias": "WSloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PR", "type": "esriFieldTypeDouble", "alias": "PR", "domain": { "type": "codedValue", "name": "OtherReviewStatus", "description": "", "codedValues": [ { "name": "10%", "code": 0.1 }, { "name": "30%", "code": 0.3 }, { "name": "75%", "code": 0.75 }, { "name": "90%", "code": 0.9 }, { "name": "100%", "code": 1 }, { "name": "N/A", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRdate", "type": "esriFieldTypeDate", "alias": "PRdate", "length": 8, "domain": null }, { "name": "PRloc", "type": "esriFieldTypeString", "alias": "PRloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HCPSdate", "type": "esriFieldTypeDate", "alias": "HCPSdate", "length": 8, "domain": null }, { "name": "HCPSloc", "type": "esriFieldTypeString", "alias": "HCPSloc", "length": 255, "domain": { "type": "codedValue", "name": "PermitLoc", "description": "Where the permit resides", "codedValues": [ { "name": "to reviewer", "code": "to reviewer" }, { "name": "from reviewer", "code": "from reviewer" }, { "name": "to consultant", "code": "to consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WS", "type": "esriFieldTypeDouble", "alias": "WSTEMP", "domain": { "type": "codedValue", "name": "OtherReviewStatus", "description": "", "codedValues": [ { "name": "10%", "code": 0.1 }, { "name": "30%", "code": 0.3 }, { "name": "75%", "code": 0.75 }, { "name": "90%", "code": 0.9 }, { "name": "100%", "code": 1 }, { "name": "N/A", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HCPS", "type": "esriFieldTypeDouble", "alias": "HCPSTEMP", "domain": { "type": "codedValue", "name": "OtherReviewStatus", "description": "", "codedValues": [ { "name": "10%", "code": 0.1 }, { "name": "30%", "code": 0.3 }, { "name": "75%", "code": 0.75 }, { "name": "90%", "code": 0.9 }, { "name": "100%", "code": 1 }, { "name": "N/A", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WSdate", "type": "esriFieldTypeDate", "alias": "WSdate", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null } ], "indexes": [ { "name": "R21_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_19_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "ProjectInformation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{ED12FA1B-B0D8-4019-A584-6125DB04950B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 4, "name": "Watersheds.SDE.CapitalStatus", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WPname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 255, "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 255, "domain": null }, { "name": "StreamClosure", "type": "esriFieldTypeString", "alias": "StreamClosure", "length": 255, "domain": { "type": "codedValue", "name": "StreamClosure", "description": "Stream closure periods", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "I (Mar 1 to Jun 15)", "code": "I (Mar 1 to Jun 15)" }, { "name": "III (Oct 1 to Apr 30)", "code": "III (Oct 1 to Apr 30)" }, { "name": "IV (Mar 1 to May 31)", "code": "IV (Mar 1 to May 31)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BondEndDate", "type": "esriFieldTypeDate", "alias": "BondEndDate", "length": 8, "domain": null }, { "name": "BondInspec", "type": "esriFieldTypeDate", "alias": "BondInspec", "length": 8, "domain": null }, { "name": "TreeSurvey", "type": "esriFieldTypeDate", "alias": "TreeSurvey", "length": 8, "domain": null }, { "name": "CONpercent", "type": "esriFieldTypeDouble", "alias": "CONpercent", "domain": null }, { "name": "CONcomplete", "type": "esriFieldTypeDate", "alias": "CONcomplete", "length": 8, "domain": null }, { "name": "CONstart", "type": "esriFieldTypeDate", "alias": "CONstart", "length": 8, "domain": null }, { "name": "PreCon", "type": "esriFieldTypeDate", "alias": "PreCon", "length": 8, "domain": null }, { "name": "Plans_SpecPrint", "type": "esriFieldTypeString", "alias": "Plans_SpecPrint", "length": 255, "domain": { "type": "codedValue", "name": "Workflow", "description": "Workflow", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BID", "type": "esriFieldTypeDate", "alias": "BID", "length": 8, "domain": null }, { "name": "NEXTsubmit", "type": "esriFieldTypeDate", "alias": "NEXTsubmit", "length": 8, "domain": null }, { "name": "WPR", "type": "esriFieldTypeDouble", "alias": "WPR", "domain": { "type": "codedValue", "name": "StatusComplete", "description": "Status Complete for Capital Projects", "codedValues": [ { "name": "10%", "code": 0.1 }, { "name": "30%", "code": 0.3 }, { "name": "75%", "code": 0.75 }, { "name": "90%", "code": 0.9 }, { "name": "100%", "code": 1 }, { "name": "NTP", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WPRdate", "type": "esriFieldTypeDate", "alias": "WPRdate", "length": 8, "domain": null }, { "name": "WPRloc", "type": "esriFieldTypeString", "alias": "WPRloc", "length": 255, "domain": { "type": "codedValue", "name": "StatusLoc", "description": "Where the plans reside for WPR reviews", "codedValues": [ { "name": "to consultant", "code": "to consultant" }, { "name": "from consultant", "code": "from consultant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null } ], "indexes": [ { "name": "R18_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_16_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "ProjectInformation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{145E1E28-DD75-443E-99F9-47096A67E195}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "Watersheds.SDE.CapitalExpenditures", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WPid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WPid", "type": "esriFieldTypeString", "alias": "WPid", "length": 255, "domain": null }, { "name": "PhaseType", "type": "esriFieldTypeString", "alias": "PhaseType", "length": 255, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 255, "domain": null }, { "name": "TaskStart", "type": "esriFieldTypeString", "alias": "TaskStart", "length": 255, "domain": null }, { "name": "TaskComplete", "type": "esriFieldTypeString", "alias": "TaskComplete", "length": 255, "domain": null }, { "name": "BidNo", "type": "esriFieldTypeString", "alias": "BidNo", "length": 255, "domain": null }, { "name": "Account", "type": "esriFieldTypeString", "alias": "Account", "length": 255, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 255, "domain": null }, { "name": "FiscalYR", "type": "esriFieldTypeDouble", "alias": "FiscalYR", "domain": null }, { "name": "PO", "type": "esriFieldTypeString", "alias": "PO", "length": 255, "domain": null }, { "name": "PObalance", "type": "esriFieldTypeString", "alias": "PObalance", "length": 255, "domain": null }, { "name": "POoriginal", "type": "esriFieldTypeDouble", "alias": "POoriginal", "domain": null }, { "name": "POupdated", "type": "esriFieldTypeDouble", "alias": "POupdated", "domain": null }, { "name": "POactual", "type": "esriFieldTypeDouble", "alias": "POactual", "domain": null }, { "name": "POgrant", "type": "esriFieldTypeDouble", "alias": "POgrant", "domain": null }, { "name": "POother", "type": "esriFieldTypeDouble", "alias": "POother", "domain": null }, { "name": "LastInvoice", "type": "esriFieldTypeString", "alias": "LastInvoice", "length": 255, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 255, "domain": null }, { "name": "PM", "type": "esriFieldTypeString", "alias": "PM", "length": 255, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "WPname", "type": "esriFieldTypeString", "alias": "WPname", "length": 255, "domain": null } ], "indexes": [ { "name": "R23_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_428_WPid", "fields": "WPid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "ProjectInformation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WPid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C54B2EB0-DBA3-42F2-91CC-915E887088EA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 6, "name": "Watersheds.SDE.ConstructionCosts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "wpid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "wpid", "type": "esriFieldTypeString", "alias": "wpid", "length": 255, "domain": null }, { "name": "fiscalyr", "type": "esriFieldTypeDouble", "alias": "fiscalyr", "domain": null }, { "name": "PO", "type": "esriFieldTypeString", "alias": "PO", "length": 255, "domain": null }, { "name": "POactual", "type": "esriFieldTypeDouble", "alias": "POactual", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "wpid" ], "OIDFieldContainsHashValue": true }, "maxUniqueIDCount": 100000, "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3" } ] }