{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Sidewalk Pavement Assessment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DATE_INSPECT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DATE_INSPECT", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "Observer Name", "length": 50, "domain": { "type": "codedValue", "name": "MH_INSPECTOR", "description": "MH INSPECTOR NAME", "codedValues": [ { "name": "Other", "code": "OTHER" }, { "name": "Duarte, Arturo", "code": "DUARTE_A" }, { "name": "Kennady, Charles", "code": "KENNADY_C" }, { "name": "Fonville, Jason", "code": "FONVILLE_J" }, { "name": "Griffin, Brent", "code": "GRIFFIN_B" }, { "name": "Phillips, John", "code": "PHILLIPS_J" }, { "name": "Cates, BJ", "code": "CATES_BJ" }, { "name": "Smith, Tony", "code": "SMITH_T" }, { "name": "Concha, Miguel", "code": "CONCHA_M" }, { "name": "Spears, Melvin", "code": "SPEARS_M" }, { "name": "Holland, Tim", "code": "HOLLAND_T" }, { "name": "Helmick, Jason", "code": "Jason Helmick" }, { "name": "Bates, Ronnie", "code": "Ronnie Bates" }, { "name": "Brown, Camden", "code": "Camden Brown" }, { "name": "Memmer, Jamie", "code": "Jamie Memmer" }, { "name": "Young, Scout", "code": "Scout Young" }, { "name": "Lemmond, James", "code": "James Lemmond" }, { "name": "Richardson, Robert", "code": "Robert Richardson" }, { "name": "Guevara, Jeremiah", "code": "Jeremiah Guevara" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PAssessRating", "type": "esriFieldTypeString", "alias": "Pavement Assessment Rating", "length": 100, "domain": { "type": "codedValue", "name": "Rd_PavementAssessmentRatings", "description": "Road Pavement Assessment Ratings (Visible Distress)", "codedValues": [ { "name": "(A) Excellent", "code": "A-Excellent" }, { "name": "(B) Very Good", "code": "B-Very Good" }, { "name": "(C) Good", "code": "C-Good" }, { "name": "(D) Fair", "code": "D-Fair" }, { "name": "(E) Very Poor", "code": "E-Very Poor" }, { "name": "(F) Failed", "code": "F-Failed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SurfType", "type": "esriFieldTypeString", "alias": "Surface Pavement Type", "length": 30, "domain": { "type": "codedValue", "name": "Rd_DomainPavement", "description": "Road Type of Pavement", "codedValues": [ { "name": "Asphalt", "code": "ASPH" }, { "name": "Concrete", "code": "CONC" }, { "name": "Asphalt over Concrete", "code": "COMBO" }, { "name": "Dirt", "code": "DIRT" }, { "name": "Gravel", "code": "GRVL" }, { "name": "Grass", "code": "GRSS" }, { "name": "Sand", "code": "SAND" }, { "name": "Unknown/Not Available", "code": "N_A" }, { "name": "Rocks", "code": "ROCK" }, { "name": "Others", "code": "OTHERS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "ExternalAlleySidewalkSITEKey", "type": "esriFieldTypeString", "alias": "ExternalAlleySidewalkSITEKey", "length": 36, "domain": null }, { "name": "Rd_Width", "type": "esriFieldTypeDouble", "alias": "Rd_Width", "domain": { "type": "codedValue", "name": "Rd_Width", "description": "Width of Road (feet)", "codedValues": [ { "name": "12", "code": 12 }, { "name": "12.5", "code": 12.5 }, { "name": "13", "code": 13 }, { "name": "18", "code": 18 }, { "name": "20", "code": 20 }, { "name": "21", "code": 21 }, { "name": "22", "code": 22 }, { "name": "24", "code": 24 }, { "name": "25", "code": 25 }, { "name": "26.0", "code": 26 }, { "name": "27", "code": 27 }, { "name": "28", "code": 28 }, { "name": "30", "code": 30 }, { "name": "31", "code": 31 }, { "name": "32", "code": 32 }, { "name": "33", "code": 33 }, { "name": "33.5", "code": 33.5 }, { "name": "34", "code": 34 }, { "name": "34.5", "code": 34.5 }, { "name": "36", "code": 36 }, { "name": "37", "code": 37 }, { "name": "39", "code": 39 }, { "name": "40", "code": 40 }, { "name": "41", "code": 41 }, { "name": "42", "code": 42 }, { "name": "44", "code": 44 }, { "name": "45", "code": 45 }, { "name": "46", "code": 46 }, { "name": "47", "code": 47 }, { "name": "48", "code": 48 }, { "name": "49", "code": 49 }, { "name": "50", "code": 50 }, { "name": "55", "code": 55 }, { "name": "60", "code": 60 }, { "name": "61", "code": 61 }, { "name": "62", "code": 62 }, { "name": "70", "code": 70 }, { "name": "72", "code": 72 }, { "name": "74", "code": 74 }, { "name": "78", "code": 78 }, { "name": "90", "code": 90 }, { "name": "8", "code": 8 }, { "name": "10", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "Life Cycle Status", "length": 30, "domain": { "type": "codedValue", "name": "Rd_DomainStatus", "description": "Road Current Status", "codedValues": [ { "name": "Existing", "code": "E" }, { "name": "Proposed/Future", "code": "P" }, { "name": "Underconstruction", "code": "U" }, { "name": "Removed", "code": "R" }, { "name": "Abandoned", "code": "A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CWID", "type": "esriFieldTypeString", "alias": "CWID", "length": 40, "domain": null } ], "indexes": [ { "name": "R414_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_414", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G786CWID", "fields": "CWID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_414", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Sidewalks", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "CWID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ff0c684784ed4c7ca86db825c49c55d0" }