{ "currentVersion": 10.71, "id": 1, "name": "TSI.dbo.LocationTableView", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "County", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LocationId", "type": "esriFieldTypeInteger", "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": "DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "Region", "type": "esriFieldTypeString", "alias": "Region", "length": 2147483647, "domain": null }, { "name": "Area", "type": "esriFieldTypeString", "alias": "Area", "length": 2147483647, "domain": null }, { "name": "PreemptionId", "type": "esriFieldTypeInteger", "alias": "PreemptionId", "domain": null }, { "name": "LocalControllerId", "type": "esriFieldTypeInteger", "alias": "LocalControllerId", "domain": null }, { "name": "LocalManufacturer", "type": "esriFieldTypeString", "alias": "LocalManufacturer", "length": 2147483647, "domain": null }, { "name": "LocalModel", "type": "esriFieldTypeString", "alias": "LocalModel", "length": 2147483647, "domain": null }, { "name": "LocalSerialNumber", "type": "esriFieldTypeString", "alias": "LocalSerialNumber", "length": 2147483647, "domain": null }, { "name": "LocalInstallDate", "type": "esriFieldTypeDate", "alias": "LocalInstallDate", "length": 8, "domain": null }, { "name": "LocalOther", "type": "esriFieldTypeString", "alias": "LocalOther", "length": 2147483647, "domain": null }, { "name": "LocalNotes", "type": "esriFieldTypeString", "alias": "LocalNotes", "length": 2147483647, "domain": null }, { "name": "MasterControllerId", "type": "esriFieldTypeInteger", "alias": "MasterControllerId", "domain": null }, { "name": "MasterManufacturer", "type": "esriFieldTypeString", "alias": "MasterManufacturer", "length": 2147483647, "domain": null }, { "name": "MasterModel", "type": "esriFieldTypeString", "alias": "MasterModel", "length": 2147483647, "domain": null }, { "name": "MasterSerialNumber", "type": "esriFieldTypeString", "alias": "MasterSerialNumber", "length": 2147483647, "domain": null }, { "name": "MasterInputs", "type": "esriFieldTypeString", "alias": "MasterInputs", "length": 2147483647, "domain": null }, { "name": "MasterrInstallDate", "type": "esriFieldTypeDate", "alias": "MasterrInstallDate", "length": 8, "domain": null }, { "name": "MasterIsLocal", "type": "esriFieldTypeSmallInteger", "alias": "MasterIsLocal", "domain": null }, { "name": "MasterNotes", "type": "esriFieldTypeString", "alias": "MasterNotes", "length": 2147483647, "domain": null }, { "name": "Routes", "type": "esriFieldTypeString", "alias": "Routes", "length": 2147483647, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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 }