{
"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
}
}
]
}