{ "currentVersion": 10.71, "id": 1, "name": "TSI.dbo.Locations", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "County", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LocationId", "type": "esriFieldTypeOID", "alias": "LocationId", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "length": 2147483647, "domain": null }, { "name": "Municipality", "type": "esriFieldTypeString", "alias": "Municipality", "length": 2147483647, "domain": null }, { "name": "MaintainingAgency", "type": "esriFieldTypeString", "alias": "MaintainingAgency", "length": 250, "domain": null }, { "name": "PartOfSystem", "type": "esriFieldTypeSmallInteger", "alias": "PartOfSystem", "domain": null }, { "name": "Route_IdRoute", "type": "esriFieldTypeInteger", "alias": "Route_IdRoute", "domain": null }, { "name": "LocationNotes", "type": "esriFieldTypeString", "alias": "LocationNotes", "length": 1000, "domain": null }, { "name": "TimeStamp", "type": "esriFieldTypeDate", "alias": "TimeStamp", "length": 8, "domain": null }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "UserName", "length": 2147483647, "domain": null }, { "name": "Region", "type": "esriFieldTypeString", "alias": "Region", "length": 2147483647, "domain": null }, { "name": "Area", "type": "esriFieldTypeString", "alias": "Area", "length": 2147483647, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null } ], "indexes": [ { "name": "PK_dbo.Locations", "fields": "LocationId", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_Route_IdRoute", "fields": "Route_IdRoute", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }