{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Green Infrastructure Reference", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 100000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 140, 99, 63, 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": 392535.7484000027, "ymin": 126929.40349999815, "xmax": 407193.72900000215, "ymax": 147431.66640000045, "spatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "DDOT_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GREEN_INFRA_ID", "type": "esriFieldTypeGUID", "alias": "GREEN_INFRA_ID", "length": 38, "domain": null }, { "name": "DDOT_ID", "type": "esriFieldTypeString", "alias": "DDOT_ID", "length": 15, "domain": null }, { "name": "PROJECT_ADDRESS", "type": "esriFieldTypeString", "alias": "PROJECT ADDRESS", "length": 150, "domain": null }, { "name": "PROJECT_ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 5, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "WATERSHED_8DIGIT", "type": "esriFieldTypeString", "alias": "WATERSHED 8DIGIT", "length": 8, "domain": { "type": "codedValue", "name": "D_MS4Watershed8Digit", "description": "", "codedValues": [ { "name": "Anacostia River", "code": "02140205" }, { "name": "Potomac River MO County", "code": "02140202" }, { "name": "Potomac River Upper Tidal", "code": "02140201" }, { "name": "Rock Creek", "code": "02140206" }, { "name": "Oxon Creek", "code": "02140204" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEWER_SYSTEM", "type": "esriFieldTypeString", "alias": "SEWER SYSTEM", "length": 3, "domain": { "type": "codedValue", "name": "D_SewerSystem", "description": "", "codedValues": [ { "name": "MS4", "code": "MS4" }, { "name": "CSO", "code": "CSO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "WARD", "length": 1, "domain": { "type": "codedValue", "name": "D_Ward", "description": "", "codedValues": [ { "name": "Ward 1", "code": "1" }, { "name": "Ward 2", "code": "2" }, { "name": "Ward 3", "code": "3" }, { "name": "Ward 4", "code": "4" }, { "name": "Ward 5", "code": "5" }, { "name": "Ward 6", "code": "6" }, { "name": "Ward 7", "code": "7" }, { "name": "Ward 8", "code": "8" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "ANC", "length": 2, "domain": { "type": "codedValue", "name": "D_ANC", "description": "", "codedValues": [ { "name": "ANC 1A", "code": "1A" }, { "name": "ANC 1B", "code": "1B" }, { "name": "ANC 1D", "code": "1D" }, { "name": "ANC 2A", "code": "2A" }, { "name": "ANC 2B", "code": "2B" }, { "name": "ANC 2C", "code": "2C" }, { "name": "ANC 2D", "code": "2D" }, { "name": "ANC 2E", "code": "2E" }, { "name": "ANC 2F", "code": "2F" }, { "name": "ANC 3C", "code": "3C" }, { "name": "ANC 3D", "code": "3D" }, { "name": "ANC 3E", "code": "3E" }, { "name": "ANC 3F", "code": "3F" }, { "name": "ANC 3G", "code": "3G" }, { "name": "ANC 4A", "code": "4A" }, { "name": "ANC 4B", "code": "4B" }, { "name": "ANC 4C", "code": "4C" }, { "name": "ANC 4D", "code": "4D" }, { "name": "ANC 5A", "code": "5A" }, { "name": "ANC 5B", "code": "5B" }, { "name": "ANC 5C", "code": "5C" }, { "name": "ANC 5D", "code": "5D" }, { "name": "ANC 5E", "code": "5E" }, { "name": "ANC 6A", "code": "6A" }, { "name": "ANC 6B", "code": "6B" }, { "name": "ANC 6C", "code": "6C" }, { "name": "ANC 6D", "code": "6D" }, { "name": "ANC 6E", "code": "6E" }, { "name": "ANC 7B", "code": "7B" }, { "name": "ANC 7C", "code": "7C" }, { "name": "ANC 7E", "code": "7E" }, { "name": "ANC 7F", "code": "7F" }, { "name": "ANC 8A", "code": "8A" }, { "name": "ANC 8B", "code": "8B" }, { "name": "ANC 8C", "code": "8C" }, { "name": "ANC 8D", "code": "8D" }, { "name": "ANC 7D", "code": "7D" }, { "name": "ANC 8E", "code": "8E" }, { "name": "ANC 1C", "code": "1C" }, { "name": "ANC 3B", "code": "3B" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED DATE", "length": 8, "domain": null }, { "name": "LAST_EDIT_USER", "type": "esriFieldTypeString", "alias": "LAST EDIT USER", "length": 50, "domain": null }, { "name": "LAST_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "LAST EDIT DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": { "type": "codedValue", "name": "Status_ATE", "description": "ATE status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R700_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G18612GREEN_INFR", "fields": "GREEN_INFRA_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S376_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Green_Infrastructure", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GREEN_INFRA_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{F9543144-2619-4C0B-BA18-2EA468C696F8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Green Infrastructure", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 100000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 230, 213, 204, 255 ], "outline": null } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 392507.9882000014, "ymin": 126881.24439999834, "xmax": 407245.05110000074, "ymax": 147479.6484999992, "spatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "REVIEWER_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GREEN_INFRA_ID", "type": "esriFieldTypeGUID", "alias": "GREEN_INFRA_ID", "length": 38, "domain": null }, { "name": "DOEE_ID", "type": "esriFieldTypeString", "alias": "DOEE_ID", "length": 15, "domain": null }, { "name": "DDOT_ID", "type": "esriFieldTypeString", "alias": "DDOT_ID", "length": 15, "domain": null }, { "name": "MASTER_TYPE", "type": "esriFieldTypeString", "alias": "MASTER_TYPE", "length": 2, "domain": { "type": "codedValue", "name": "D_MasterType", "description": "", "codedValues": [ { "name": "Bioretention", "code": "BR" }, { "name": "Filtering Systems", "code": "FS" }, { "name": "Impervious Surface Disconnection", "code": "ID" }, { "name": "Impervious Surface Removal", "code": "IR" }, { "name": "Infiltration Systems", "code": "IS" }, { "name": "Open Channel Systems", "code": "OC" }, { "name": "Ponds", "code": "PO" }, { "name": "Permeable Pavement Practices", "code": "PP" }, { "name": "Storage Practices", "code": "ST" }, { "name": "Tree Planting", "code": "TR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESIGN_SUB", "type": "esriFieldTypeString", "alias": "DESIGN_SUB", "length": 3, "domain": { "type": "codedValue", "name": "D_DesignSubcategory", "description": "", "codedValues": [ { "name": "Alley", "code": "AL" }, { "name": "Bioretention", "code": "BR" }, { "name": "Bioswale", "code": "BS" }, { "name": "Simple Disconnection to Amended Soils", "code": "DAS" }, { "name": "Simple Disconnection to a Conservation Area", "code": "DCA" }, { "name": "Dry Pond", "code": "DP" }, { "name": "Simple Disconnection to a Pervious Area", "code": "DPA" }, { "name": "Grass Channels", "code": "GC" }, { "name": "Impervious Surface Removal", "code": "ISR" }, { "name": "Infiltration Trench", "code": "IT" }, { "name": "Parking Lane", "code": "PL" }, { "name": "Tree Planting - Structural Cell", "code": "SC" }, { "name": "Sand Filter", "code": "SF" }, { "name": "Synthetic Reinforced Turf Systems", "code": "SRT" }, { "name": "Tree Planting - Structural Soil", "code": "SS" }, { "name": "Sidewalk", "code": "SW" }, { "name": "Trail", "code": "TR" }, { "name": "Underground Detention", "code": "UD" }, { "name": "Wet Pond", "code": "WP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESIGN_SUB_MATERIAL", "type": "esriFieldTypeString", "alias": "DESIGN_SUB_MATERIAL", "length": 3, "domain": { "type": "codedValue", "name": "D_DesignSubMaterial", "description": "", "codedValues": [ { "name": "Permeable Pavers", "code": "PP" }, { "name": "Pervious Concrete", "code": "PC" }, { "name": "Plastic Grid Pavers", "code": "PGP" }, { "name": "Porous Flexible Pavement - Asphalt", "code": "PA" }, { "name": "Porous Flexible Pavement - Rubber", "code": "PR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 2, "domain": { "type": "codedValue", "name": "D_SiteStatus", "description": "", "codedValues": [ { "name": "Abandoned", "code": "AB" }, { "name": "Existing", "code": "EX" }, { "name": "Proposed", "code": "PR" }, { "name": "Proposed Abandonment", "code": "PA" }, { "name": "Removed", "code": "RE" }, { "name": "Under Construction", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PUBLIC_ROW_TYPE", "type": "esriFieldTypeString", "alias": "PUBLIC_ROW_TYPE", "length": 2, "domain": { "type": "codedValue", "name": "D_PublicRowType", "description": "", "codedValues": [ { "name": "Alley", "code": "AL" }, { "name": "Street", "code": "ST" }, { "name": "Other", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITY_PLACEMENT", "type": "esriFieldTypeString", "alias": "FACILITY_PLACEMENT", "length": 10, "domain": { "type": "codedValue", "name": "D_FacilityPlacement", "description": "", "codedValues": [ { "name": "Bumpout/Curb Extension", "code": "CURB" }, { "name": "Median", "code": "MEDIAN" }, { "name": "Other - Comment", "code": "OTHER" }, { "name": "Planter / Treespace", "code": "PLANT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UNDERDRAIN", "type": "esriFieldTypeString", "alias": "UNDERDRAIN", "length": 2, "domain": { "type": "codedValue", "name": "D_UnderdrainType", "description": "", "codedValues": [ { "name": "Enhanced w/ Underdrain", "code": "EU" }, { "name": "Enhanced w/out Underdrain", "code": "EN" }, { "name": "Standard", "code": "ST" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UNDERDRAIN_LENGTH_FT", "type": "esriFieldTypeDouble", "alias": "UNDERDRAIN_LENGTH_FT", "domain": null }, { "name": "UNDERDRAIN_CONNECTION", "type": "esriFieldTypeString", "alias": "UNDERDRAIN_CONNECTION", "length": 3, "domain": { "type": "codedValue", "name": "D_UnderdrainConnection", "description": "", "codedValues": [ { "name": "Storm Sewer Pipe", "code": "SSP" }, { "name": "Catch Basin", "code": "CB" }, { "name": "Manhole", "code": "MH" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UNDERDRAIN_CONTROL_TYPE", "type": "esriFieldTypeString", "alias": "UNDERDRAIN_CONTROL_TYPE", "length": 7, "domain": { "type": "codedValue", "name": "D_UnderdrainControlType", "description": "", "codedValues": [ { "name": "Orifice", "code": "ORIFICE" }, { "name": "Valve", "code": "VALVE" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLOW", "type": "esriFieldTypeString", "alias": "INFLOW", "length": 4, "domain": { "type": "codedValue", "name": "D_Inflow", "description": "", "codedValues": [ { "name": "Curb Cut Open", "code": "CCO" }, { "name": "Curb Cut Covered", "code": "CCC" }, { "name": "Inlet", "code": "INL" }, { "name": "Trench Drain Covered", "code": "TDC" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTFLOW", "type": "esriFieldTypeString", "alias": "OUTFLOW", "length": 4, "domain": { "type": "codedValue", "name": "D_Outflow", "description": "", "codedValues": [ { "name": "Curb Cut Open", "code": "CCO" }, { "name": "Curb Cut Covered", "code": "CCC" }, { "name": "Trench Drain", "code": "TD" }, { "name": "Trench Drain Covered", "code": "TDC" }, { "name": "Beehive Grate", "code": "BG" }, { "name": "Grate Inlet", "code": "GI" }, { "name": "Curb Inlet", "code": "CI" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VELOCITY_DISSIPATER", "type": "esriFieldTypeString", "alias": "VELOCITY_DISSIPATER", "length": 4, "domain": { "type": "codedValue", "name": "D_VelocityDissipater", "description": "", "codedValues": [ { "name": "Rock/ Gravel", "code": "ROCK" }, { "name": "Concrete", "code": "CONC" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AREA_SQFT", "type": "esriFieldTypeDouble", "alias": "AREA_SQFT", "domain": null }, { "name": "DEPTH_FT", "type": "esriFieldTypeDouble", "alias": "DEPTH_FT", "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "GEN_COMMENTS", "length": 255, "domain": null }, { "name": "LAST_INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "LAST_INSPECTION_DATE", "length": 8, "domain": null }, { "name": "LAST_INSPECTION_CONDITION", "type": "esriFieldTypeString", "alias": "LAST_INSPECTION_CONDITION", "length": 4, "domain": { "type": "codedValue", "name": "D_Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "EX" }, { "name": "Good", "code": "GO" }, { "name": "Fair", "code": "FA" }, { "name": "Poor", "code": "PO" }, { "name": "Deficient", "code": "DE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTRACT_ID", "type": "esriFieldTypeGUID", "alias": "CONTRACT_ID", "length": 38, "domain": null }, { "name": "PUBLIC_SPACE_PERMIT_ID", "type": "esriFieldTypeGUID", "alias": "PUBLIC_SPACE_PERMIT_ID", "length": 38, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "HISTORIC_BMP_ID", "type": "esriFieldTypeString", "alias": "HISTORIC_BMP_ID", "length": 50, "domain": null }, { "name": "CONDITION_NOTES", "type": "esriFieldTypeString", "alias": "CONDITION_NOTES", "length": 255, "domain": null }, { "name": "REVIEWER_NAME", "type": "esriFieldTypeString", "alias": "REVIEWER_NAME", "length": 30, "domain": null }, { "name": "INSPECTOR_NAME", "type": "esriFieldTypeString", "alias": "INSPECTOR_NAME", "length": 30, "domain": null }, { "name": "ROUTINE_MAINTENANCE_CREW", "type": "esriFieldTypeString", "alias": "ROUTINE_MAINTENANCE_CREW", "length": 30, "domain": null }, { "name": "STATUS_GI", "type": "esriFieldTypeString", "alias": "STATUS_GI", "length": 50, "domain": { "type": "codedValue", "name": "Status_ATE", "description": "ATE status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R699_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G18611PUBLIC_SPA", "fields": "PUBLIC_SPACE_PERMIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18611CONTRACT_I", "fields": "CONTRACT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18611GREEN_INFR", "fields": "GREEN_INFRA_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S375_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Green_Infra_Ref", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "GREEN_INFRA_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{F9543144-2619-4C0B-BA18-2EA468C696F8}" }, { "id": 1, "name": "Green_Infra_Activity", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GREEN_INFRA_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{319757F0-C420-46C3-8C30-37D1542E8B13}" }, { "id": 2, "name": "Public_Space_Permit", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "PUBLIC_SPACE_PERMIT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B132D698-E801-487F-A625-FE340397D139}" }, { "id": 3, "name": "DDOT_Contract", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "CONTRACT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A5370A88-6B28-48AC-9556-93EB25E02F24}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "Green Infrastructure", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AS_BUILT_STATUS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GREEN_INFRA_ID", "type": "esriFieldTypeGUID", "alias": "GREEN INFRA ID", "length": 38, "domain": null }, { "name": "AS_BUILT_STATUS", "type": "esriFieldTypeString", "alias": "AS BUILT STATUS", "length": 2, "domain": { "type": "codedValue", "name": "D_AsBuiltStatus", "description": "", "codedValues": [ { "name": "Required", "code": "RE" }, { "name": "In Progress", "code": "IP" }, { "name": "Completed", "code": "CO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 5, "domain": { "type": "codedValue", "name": "D_Owner", "description": "", "codedValues": [ { "name": "Department of Energy & Environment", "code": "DOEE" }, { "name": "District Department of Transportation", "code": "DDOT" }, { "name": "Department of General Services", "code": "DGS" }, { "name": "DC Water", "code": "DCW" }, { "name": "General Services Administration", "code": "GSA" }, { "name": "Other - Comment", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINT_ORGANIZATION", "type": "esriFieldTypeString", "alias": "MAINTENANCE ORGANIZATION", "length": 5, "domain": { "type": "codedValue", "name": "D_Owner", "description": "", "codedValues": [ { "name": "Department of Energy & Environment", "code": "DOEE" }, { "name": "District Department of Transportation", "code": "DDOT" }, { "name": "Department of General Services", "code": "DGS" }, { "name": "DC Water", "code": "DCW" }, { "name": "General Services Administration", "code": "GSA" }, { "name": "Other - Comment", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINT_AGREEMENT", "type": "esriFieldTypeString", "alias": "MAINTENANCE AGREEMENT", "length": 3, "domain": { "type": "codedValue", "name": "D_MaintenanceAgreement", "description": "", "codedValues": [ { "name": "Covenant", "code": "COV" }, { "name": "Memorandum of Agreement", "code": "MOA" }, { "name": "Memorandum of Understanding", "code": "MOU" }, { "name": "Other - Comment", "code": "OTH" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSTRUCTION_INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "CONSTRUCTION INSTALL DATE", "length": 8, "domain": null }, { "name": "PLANTING_INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "PLANTING INSTALL DATE", "length": 8, "domain": null }, { "name": "SUBSTANTIAL_COMPLETION", "type": "esriFieldTypeDate", "alias": "SUBSTANTIAL COMPLETION", "length": 8, "domain": null }, { "name": "FINAL_ACCEPTANCE", "type": "esriFieldTypeDate", "alias": "FINAL ACCEPTANCE", "length": 8, "domain": null }, { "name": "PLANT_GUARANTEE_END_DATE", "type": "esriFieldTypeDate", "alias": "PLANT GUARANTEE END DATE", "length": 8, "domain": null }, { "name": "WARRANTY_END_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY END DATE", "length": 8, "domain": null }, { "name": "DATE_REMOVED", "type": "esriFieldTypeDate", "alias": "DATE REMOVED", "length": 8, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED USER", "length": 50, "domain": null }, { "name": "LAST_EDIT_USER", "type": "esriFieldTypeString", "alias": "LAST EDIT USER", "length": 50, "domain": null }, { "name": "LAST_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "LAST EDIT DATE", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R701_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_701", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18613GREEN_INFR", "fields": "GREEN_INFRA_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Green_Infrastructure", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GREEN_INFRA_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{319757F0-C420-46C3-8C30-37D1542E8B13}" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "DDOT Contract", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJECT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CONTRACT_ID", "type": "esriFieldTypeGUID", "alias": "CONTRACT ID", "length": 38, "domain": null }, { "name": "CONTRACT_NUMBER", "type": "esriFieldTypeString", "alias": "CONTRACT NUMBER", "length": 50, "domain": null }, { "name": "PROJECT_NAME", "type": "esriFieldTypeString", "alias": "PROJECT NAME", "length": 255, "domain": null }, { "name": "PROJECT_LIMITS", "type": "esriFieldTypeString", "alias": "PROJECT LIMITS", "length": 255, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 5, "domain": { "type": "codedValue", "name": "D_Owner", "description": "", "codedValues": [ { "name": "Department of Energy & Environment", "code": "DOEE" }, { "name": "District Department of Transportation", "code": "DDOT" }, { "name": "Department of General Services", "code": "DGS" }, { "name": "DC Water", "code": "DCW" }, { "name": "General Services Administration", "code": "GSA" }, { "name": "Other - Comment", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 2, "domain": { "type": "codedValue", "name": "D_ProjectStatus", "description": "", "codedValues": [ { "name": "As Built Approved", "code": "AB" }, { "name": "Construction Complete", "code": "CC" }, { "name": "Design", "code": "DE" }, { "name": "Inactive", "code": "IA" }, { "name": "On Hold", "code": "OH" }, { "name": "Under Construction", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PLAN_DATE", "type": "esriFieldTypeDate", "alias": "PLAN DATE", "length": 8, "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R704_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_704", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18616CONTRACT_I", "fields": "CONTRACT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "FILE_ATTACH", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "CONTRACT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F371DD3D-477C-4474-B2F8-8A3959B8E78A}" }, { "id": 3, "name": "Green_Infrastructure", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "CONTRACT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A5370A88-6B28-48AC-9556-93EB25E02F24}" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "File Attachments", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FILENAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FILE_ATTACH_ID", "type": "esriFieldTypeGUID", "alias": "FILE ATTACH ID", "length": 38, "domain": null }, { "name": "CONTRACT_ID", "type": "esriFieldTypeGUID", "alias": "CONTRACT ID", "length": 38, "domain": null }, { "name": "PUBLIC_SPACE_PERMIT_ID", "type": "esriFieldTypeGUID", "alias": "PUBLIC SPACE PERMIT ID", "length": 38, "domain": null }, { "name": "FILENAME", "type": "esriFieldTypeString", "alias": "FILENAME", "length": 255, "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R703_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_703", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18615PUBLIC_SPA", "fields": "PUBLIC_SPACE_PERMIT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18615CONTRACT_I", "fields": "CONTRACT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DDOT_Contract", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "CONTRACT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F371DD3D-477C-4474-B2F8-8A3959B8E78A}" }, { "id": 6, "name": "Public_Space_Permit", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "PUBLIC_SPACE_PERMIT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{036CDB17-0243-4A83-A279-8722D2CDEDEA}" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "DDOTSGIS.PUBSPACE.FILE_ATTACH__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R702_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_702", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18614REL_GLOBAL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "Public Space Permit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJECT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PUBLIC_SPACE_PERMIT_ID", "type": "esriFieldTypeGUID", "alias": "PUBLIC SPACE PERMIT ID", "length": 38, "domain": null }, { "name": "PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "PERMIT NUMBER", "length": 7, "domain": null }, { "name": "PROJECT_NAME", "type": "esriFieldTypeString", "alias": "PROJECT NAME", "length": 255, "domain": null }, { "name": "PROJECT_LIMITS", "type": "esriFieldTypeString", "alias": "PROJECT LIMITS", "length": 255, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 5, "domain": { "type": "codedValue", "name": "D_Owner", "description": "", "codedValues": [ { "name": "Department of Energy & Environment", "code": "DOEE" }, { "name": "District Department of Transportation", "code": "DDOT" }, { "name": "Department of General Services", "code": "DGS" }, { "name": "DC Water", "code": "DCW" }, { "name": "General Services Administration", "code": "GSA" }, { "name": "Other - Comment", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 2, "domain": { "type": "codedValue", "name": "D_ProjectStatus", "description": "", "codedValues": [ { "name": "As Built Approved", "code": "AB" }, { "name": "Construction Complete", "code": "CC" }, { "name": "Design", "code": "DE" }, { "name": "Inactive", "code": "IA" }, { "name": "On Hold", "code": "OH" }, { "name": "Under Construction", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PLAN_DATE", "type": "esriFieldTypeDate", "alias": "PLAN DATE", "length": 8, "domain": null }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED DATE", "length": 8, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED USER", "length": 48, "domain": null }, { "name": "LAST_EDIT_USER", "type": "esriFieldTypeString", "alias": "LAST EDIT USER", "length": 48, "domain": null }, { "name": "LAST_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "LAST EDIT DATE", "length": 8, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R705_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_705", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18617PUBLIC_SPA", "fields": "PUBLIC_SPACE_PERMIT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "FILE_ATTACH", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "PUBLIC_SPACE_PERMIT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{036CDB17-0243-4A83-A279-8722D2CDEDEA}" }, { "id": 2, "name": "Green_Infrastructure", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PUBLIC_SPACE_PERMIT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B132D698-E801-487F-A625-FE340397D139}" } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }