{ "currentVersion": 10.81, "id": 48, "name": "Huntington.dbo.W2_HB", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "APN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 255, "domain": null }, { "name": "MAILADDRESS", "type": "esriFieldTypeString", "alias": "Mail Address", "length": 255, "domain": null }, { "name": "MAILCITY", "type": "esriFieldTypeString", "alias": "Mail City", "length": 255, "domain": null }, { "name": "CENSUSTRACT", "type": "esriFieldTypeString", "alias": "Census Tract", "length": 255, "domain": null }, { "name": "LEGALDESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 255, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "DATE", "type": "esriFieldTypeString", "alias": "Date", "length": 255, "domain": null }, { "name": "FIPSCODE", "type": "esriFieldTypeString", "alias": "FIPSCODE", "length": 255, "domain": null }, { "name": "ALTERNATETAXAPN", "type": "esriFieldTypeString", "alias": "ALTERNATETAXAPN", "length": 255, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "SITEADDRESS", "length": 255, "domain": null }, { "name": "SITECITY", "type": "esriFieldTypeString", "alias": "SITECITY", "length": 255, "domain": null }, { "name": "SITESTATE", "type": "esriFieldTypeString", "alias": "SITESTATE", "length": 255, "domain": null }, { "name": "SITEZIP", "type": "esriFieldTypeString", "alias": "SITEZIP", "length": 255, "domain": null }, { "name": "SITEPLUS4", "type": "esriFieldTypeString", "alias": "SITEPLUS4", "length": 255, "domain": null }, { "name": "SITEZIPPLUS4", "type": "esriFieldTypeString", "alias": "SITEZIPPLUS4", "length": 255, "domain": null }, { "name": "XCOORD", "type": "esriFieldTypeDouble", "alias": "XCOORD", "domain": null }, { "name": "YCOORD", "type": "esriFieldTypeDouble", "alias": "YCOORD", "domain": null }, { "name": "GEOMETRYSOURCE", "type": "esriFieldTypeString", "alias": "GEOMETRYSOURCE", "length": 255, "domain": null }, { "name": "ADDRSCORE", "type": "esriFieldTypeDouble", "alias": "ADDRSCORE", "domain": null }, { "name": "BLOCKNUMBER", "type": "esriFieldTypeString", "alias": "BLOCKNUMBER", "length": 255, "domain": null }, { "name": "OWNERNAME1", "type": "esriFieldTypeString", "alias": "OWNERNAME1", "length": 255, "domain": null }, { "name": "OWNERNAME2", "type": "esriFieldTypeString", "alias": "OWNERNAME2", "length": 255, "domain": null }, { "name": "MAILSTATE", "type": "esriFieldTypeString", "alias": "MAILSTATE", "length": 255, "domain": null }, { "name": "MAILZIP", "type": "esriFieldTypeString", "alias": "MAILZIP", "length": 255, "domain": null }, { "name": "MAILPLUS4", "type": "esriFieldTypeString", "alias": "MAILPLUS4", "length": 255, "domain": null }, { "name": "MAILZIPPLUS4", "type": "esriFieldTypeString", "alias": "MAILZIPPLUS4", "length": 255, "domain": null }, { "name": "OWNEROCCUPIED", "type": "esriFieldTypeString", "alias": "OWNEROCCUPIED", "length": 255, "domain": null }, { "name": "USECODESTDDESCLPS", "type": "esriFieldTypeString", "alias": "USECODESTDDESCLPS", "length": 255, "domain": null }, { "name": "ASSESSEEOWNERVESTINGCODEDESC", "type": "esriFieldTypeString", "alias": "ASSESSEEOWNERVESTINGCODEDESC", "length": 255, "domain": null }, { "name": "ASMTYEAR", "type": "esriFieldTypeDouble", "alias": "ASMTYEAR", "domain": null }, { "name": "CAHOMEOWNERSEXEMPT", "type": "esriFieldTypeString", "alias": "CAHOMEOWNERSEXEMPT", "length": 255, "domain": null }, { "name": "TAXRATECODEAREA", "type": "esriFieldTypeString", "alias": "TAXRATECODEAREA", "length": 255, "domain": null }, { "name": "TAXAMOUNT", "type": "esriFieldTypeDouble", "alias": "TAXAMOUNT", "domain": null }, { "name": "LOTNUMBER", "type": "esriFieldTypeString", "alias": "LOTNUMBER", "length": 255, "domain": null }, { "name": "TRACTNUMBER", "type": "esriFieldTypeString", "alias": "TRACTNUMBER", "length": 255, "domain": null }, { "name": "LOTSIZEAREA", "type": "esriFieldTypeDouble", "alias": "LOTSIZEAREA", "domain": null }, { "name": "YRBLT", "type": "esriFieldTypeDouble", "alias": "YRBLT", "domain": null }, { "name": "BUILDINGSQFT", "type": "esriFieldTypeDouble", "alias": "BUILDINGSQFT", "domain": null }, { "name": "STORIESNUMBER", "type": "esriFieldTypeDouble", "alias": "STORIESNUMBER", "domain": null }, { "name": "TOTALROOMS", "type": "esriFieldTypeString", "alias": "TOTALROOMS", "length": 255, "domain": null }, { "name": "UNITSNUMBER", "type": "esriFieldTypeString", "alias": "UNITSNUMBER", "length": 255, "domain": null }, { "name": "TOTALBATHS", "type": "esriFieldTypeDouble", "alias": "TOTALBATHS", "domain": null }, { "name": "GARAGECODEDESC", "type": "esriFieldTypeString", "alias": "GARAGECODEDESC", "length": 255, "domain": null }, { "name": "PARKINGSPACES", "type": "esriFieldTypeDouble", "alias": "PARKINGSPACES", "domain": null }, { "name": "POOLINDICATORDESC", "type": "esriFieldTypeString", "alias": "POOLINDICATORDESC", "length": 255, "domain": null }, { "name": "VALMRKTLAND", "type": "esriFieldTypeString", "alias": "VALMRKTLAND", "length": 255, "domain": null }, { "name": "VALMRKTIMPRV", "type": "esriFieldTypeString", "alias": "VALMRKTIMPRV", "length": 255, "domain": null }, { "name": "CONSTRUCTIONCODEDESC", "type": "esriFieldTypeString", "alias": "CONSTRUCTIONCODEDESC", "length": 255, "domain": null }, { "name": "IMPRVPCT", "type": "esriFieldTypeDouble", "alias": "IMPRVPCT", "domain": null }, { "name": "LASTMARKETSALEDATETRANSFER", "type": "esriFieldTypeString", "alias": "LASTMARKETSALEDATETRANSFER", "length": 255, "domain": null }, { "name": "LASTSALEDATETRANSFER", "type": "esriFieldTypeString", "alias": "LASTSALEDATETRANSFER", "length": 255, "domain": null }, { "name": "LASTSALEDOCNUMBER", "type": "esriFieldTypeString", "alias": "LASTSALEDOCNUMBER", "length": 255, "domain": null }, { "name": "LASTSALEDOCTYPEDESC", "type": "esriFieldTypeString", "alias": "LASTSALEDOCTYPEDESC", "length": 255, "domain": null }, { "name": "LASTSALESELLERNAME", "type": "esriFieldTypeString", "alias": "LASTSALESELLERNAME", "length": 255, "domain": null }, { "name": "OWNERSHIPSTATUSDESC", "type": "esriFieldTypeString", "alias": "OWNERSHIPSTATUSDESC", "length": 255, "domain": null }, { "name": "LASTSALEVALTRANSFER", "type": "esriFieldTypeDouble", "alias": "LASTSALEVALTRANSFER", "domain": null }, { "name": "TITLECOMPANYNAME", "type": "esriFieldTypeString", "alias": "TITLECOMPANYNAME", "length": 255, "domain": null }, { "name": "LNDRFIRSTNAME1", "type": "esriFieldTypeString", "alias": "LNDRFIRSTNAME1", "length": 255, "domain": null }, { "name": "PRIORSALEDATETRANSFER", "type": "esriFieldTypeString", "alias": "PRIORSALEDATETRANSFER", "length": 255, "domain": null }, { "name": "PRIORSALEDOCTYPEDESC", "type": "esriFieldTypeString", "alias": "PRIORSALEDOCTYPEDESC", "length": 255, "domain": null }, { "name": "PRIORSALEDOCNUMBER", "type": "esriFieldTypeString", "alias": "PRIORSALEDOCNUMBER", "length": 255, "domain": null }, { "name": "PRIORSALEVALTRANSFER", "type": "esriFieldTypeDouble", "alias": "PRIORSALEVALTRANSFER", "domain": null }, { "name": "CENSUSBLOCK", "type": "esriFieldTypeDouble", "alias": "CENSUSBLOCK", "domain": null }, { "name": "CALSQFT", "type": "esriFieldTypeDouble", "alias": "CALSQFT", "domain": null } ], "indexes": [ { "name": "APN_Index", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R2637_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "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 } }