{ "currentVersion": 10.61, "id": 4, "name": "Campbell_Web.dbo.saddress_TBL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StrtName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LRSN", "type": "esriFieldTypeInteger", "alias": "LRSN", "domain": null }, { "name": "TranType", "type": "esriFieldTypeInteger", "alias": "TranType", "domain": null }, { "name": "AddrSeq", "type": "esriFieldTypeInteger", "alias": "AddrSeq", "domain": null }, { "name": "EffDate", "type": "esriFieldTypeDate", "alias": "EffDate", "length": 8, "domain": null }, { "name": "StrtDir", "type": "esriFieldTypeString", "alias": "StrtDir", "length": 2, "domain": null }, { "name": "StrtName", "type": "esriFieldTypeString", "alias": "StrtName", "length": 30, "domain": null }, { "name": "StrtType", "type": "esriFieldTypeString", "alias": "StrtType", "length": 4, "domain": null }, { "name": "StrtSufx", "type": "esriFieldTypeString", "alias": "StrtSufx", "length": 2, "domain": null }, { "name": "StrtNum", "type": "esriFieldTypeInteger", "alias": "StrtNum", "domain": null }, { "name": "SNumSufx", "type": "esriFieldTypeString", "alias": "SNumSufx", "length": 4, "domain": null }, { "name": "UnitNum", "type": "esriFieldTypeString", "alias": "UnitNum", "length": 8, "domain": null }, { "name": "StrtSide", "type": "esriFieldTypeString", "alias": "StrtSide", "length": 4, "domain": null }, { "name": "StrtCity", "type": "esriFieldTypeString", "alias": "StrtCity", "length": 32, "domain": null }, { "name": "StrtZip", "type": "esriFieldTypeString", "alias": "StrtZip", "length": 16, "domain": null }, { "name": "StrtCode", "type": "esriFieldTypeString", "alias": "StrtCode", "length": 8, "domain": null }, { "name": "GPSx", "type": "esriFieldTypeInteger", "alias": "GPSx", "domain": null }, { "name": "GPSy", "type": "esriFieldTypeInteger", "alias": "GPSy", "domain": null }, { "name": "GPSz", "type": "esriFieldTypeInteger", "alias": "GPSz", "domain": null }, { "name": "StrtSeq", "type": "esriFieldTypeString", "alias": "StrtSeq", "length": 6, "domain": null }, { "name": "ImprCode", "type": "esriFieldTypeString", "alias": "ImprCode", "length": 6, "domain": null }, { "name": "LandSeq", "type": "esriFieldTypeString", "alias": "LandSeq", "length": 6, "domain": null }, { "name": "CensusTract", "type": "esriFieldTypeString", "alias": "CensusTract", "length": 8, "domain": null }, { "name": "CensusBlock", "type": "esriFieldTypeString", "alias": "CensusBlock", "length": 8, "domain": null }, { "name": "PlanDist", "type": "esriFieldTypeString", "alias": "PlanDist", "length": 6, "domain": null }, { "name": "FloodPl", "type": "esriFieldTypeString", "alias": "FloodPl", "length": 6, "domain": null }, { "name": "FreeFormAddr", "type": "esriFieldTypeString", "alias": "FreeFormAddr", "length": 64, "domain": null }, { "name": "Code911", "type": "esriFieldTypeString", "alias": "Code911", "length": 10, "domain": null }, { "name": "ZonCode", "type": "esriFieldTypeString", "alias": "ZonCode", "length": 8, "domain": null }, { "name": "ZonDesc", "type": "esriFieldTypeString", "alias": "ZonDesc", "length": 20, "domain": null }, { "name": "int1", "type": "esriFieldTypeInteger", "alias": "int1", "domain": null }, { "name": "int2", "type": "esriFieldTypeInteger", "alias": "int2", "domain": null }, { "name": "int3", "type": "esriFieldTypeInteger", "alias": "int3", "domain": null }, { "name": "LastUpd", "type": "esriFieldTypeDate", "alias": "LastUpd", "length": 8, "domain": null }, { "name": "UserID", "type": "esriFieldTypeString", "alias": "UserID", "length": 12, "domain": null }, { "name": "char2a", "type": "esriFieldTypeString", "alias": "char2a", "length": 2, "domain": null }, { "name": "char10a", "type": "esriFieldTypeString", "alias": "char10a", "length": 10, "domain": null }, { "name": "DistNum", "type": "esriFieldTypeString", "alias": "DistNum", "length": 6, "domain": null }, { "name": "EffEnd", "type": "esriFieldTypeDate", "alias": "EffEnd", "length": 8, "domain": null }, { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }