{ "currentVersion": 10.61, "id": 8, "name": "Online_rep.SDE.Tbl_RoadSurface", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Segment_UID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Segment_UID", "type": "esriFieldTypeString", "alias": "Street Segment Universal ID", "length": 100, "domain": null }, { "name": "ROADID", "type": "esriFieldTypeString", "alias": "Road ID", "length": 8, "domain": null }, { "name": "ROADSURFACE2014", "type": "esriFieldTypeString", "alias": "Road Surface 2014 (ESinohui)", "length": 50, "domain": null }, { "name": "RoadSurface2016", "type": "esriFieldTypeString", "alias": "Road Surface 2016 (KMoyers)", "length": 255, "domain": null }, { "name": "TREATMENT", "type": "esriFieldTypeString", "alias": "Road Treatment", "length": 255, "domain": null }, { "name": "FYE", "type": "esriFieldTypeDouble", "alias": "FYE", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Field Notes", "length": 255, "domain": null }, { "name": "TreatedMiles", "type": "esriFieldTypeDouble", "alias": "TreatedMiles", "domain": null }, { "name": "PAVEDMILES", "type": "esriFieldTypeDouble", "alias": "Paved Miles", "domain": null }, { "name": "UNPAVEDMIL", "type": "esriFieldTypeDouble", "alias": "Un-Paved Miles", "domain": null }, { "name": "GRADINGJURISDICTION", "type": "esriFieldTypeString", "alias": "Road Grading Jurisdiction", "length": 25, "domain": null }, { "name": "PAVEMENTTREATMENTDATE", "type": "esriFieldTypeDate", "alias": "Date of Roadway Treament", "length": 8, "domain": null }, { "name": "PAVEMENTTREATMENTTYPE", "type": "esriFieldTypeString", "alias": "Type of Road Treatment", "length": 50, "domain": null }, { "name": "DATELASTEDIT", "type": "esriFieldTypeDate", "alias": "Date Last Edit", "length": 8, "domain": null }, { "name": "LASTEDITBY", "type": "esriFieldTypeString", "alias": "Last Edit By", "length": 30, "domain": null }, { "name": "GISCOMMENTS", "type": "esriFieldTypeString", "alias": "GIS Comments", "length": 120, "domain": null }, { "name": "Shape_Length", "type": "esriFieldTypeDouble", "alias": "Shape_Length", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R385_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_385", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1187Segment_UID", "fields": "Segment_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_385", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Tbl_RoadSurfaceToStreets_Tbl_RoadSurface", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Segment_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }