{ "currentVersion": 10.81, "id": 42, "name": "Assessor Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SITUSSTREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 13, "domain": null }, { "name": "APN_ACA", "type": "esriFieldTypeString", "alias": "APN_ACA", "length": 15, "domain": null }, { "name": "APN_GIS", "type": "esriFieldTypeString", "alias": "APN_GIS", "length": 13, "domain": null }, { "name": "APN_PQ", "type": "esriFieldTypeString", "alias": "APN_PQ", "length": 16, "domain": null }, { "name": "SITUSADDRESS", "type": "esriFieldTypeString", "alias": "SITUSADDRESS", "length": 70, "domain": null }, { "name": "SITUSUNITNUMBER", "type": "esriFieldTypeString", "alias": "SITUSUNITNUMBER", "length": 10, "domain": null }, { "name": "SITUSCITY", "type": "esriFieldTypeString", "alias": "SITUSCITY", "length": 30, "domain": null }, { "name": "SITUSSTATE", "type": "esriFieldTypeString", "alias": "SITUSSTATE", "length": 2, "domain": null }, { "name": "SITUSZIPCODE", "type": "esriFieldTypeString", "alias": "SITUSZIPCODE", "length": 5, "domain": null }, { "name": "SITUSSTREETNUMBER", "type": "esriFieldTypeString", "alias": "SITUSSTREETNUMBER", "length": 10, "domain": null }, { "name": "SITUSSTREETPREFIX", "type": "esriFieldTypeString", "alias": "SITUSSTREETPREFIX", "length": 1, "domain": null }, { "name": "SITUSSTREETNAME", "type": "esriFieldTypeString", "alias": "SITUSSTREETNAME", "length": 50, "domain": null }, { "name": "SITUSSTREETEXT", "type": "esriFieldTypeString", "alias": "SITUSSTREETEXT", "length": 4, "domain": null }, { "name": "SITUSZIP4", "type": "esriFieldTypeString", "alias": "SITUSZIP4", "length": 4, "domain": null }, { "name": "OWNERFIRSTNAME", "type": "esriFieldTypeString", "alias": "OWNERFIRSTNAME", "length": 50, "domain": null }, { "name": "OWNERLASTNAME", "type": "esriFieldTypeString", "alias": "OWNERLASTNAME", "length": 50, "domain": null }, { "name": "OWNERNAME", "type": "esriFieldTypeString", "alias": "OWNERNAME", "length": 50, "domain": null }, { "name": "OWNERNAMECENSORED", "type": "esriFieldTypeString", "alias": "OWNERNAMECENSORED", "length": 50, "domain": null }, { "name": "MAILCAREOFNAME", "type": "esriFieldTypeString", "alias": "MAILCAREOFNAME", "length": 50, "domain": null }, { "name": "MAILATTENTIONNAME", "type": "esriFieldTypeString", "alias": "MAILATTENTIONNAME", "length": 50, "domain": null }, { "name": "MAILSTREETADDRESS", "type": "esriFieldTypeString", "alias": "MAILSTREETADDRESS", "length": 75, "domain": null }, { "name": "MAILUNITNUMBER", "type": "esriFieldTypeString", "alias": "MAILUNITNUMBER", "length": 10, "domain": null }, { "name": "MAILCITY", "type": "esriFieldTypeString", "alias": "MAILCITY", "length": 30, "domain": null }, { "name": "MAILSTATE", "type": "esriFieldTypeString", "alias": "MAILSTATE", "length": 10, "domain": null }, { "name": "MAILZIPCODE", "type": "esriFieldTypeString", "alias": "MAILZIPCODE", "length": 5, "domain": null }, { "name": "MAILZIPCODE4", "type": "esriFieldTypeString", "alias": "MAILZIPCODE4", "length": 4, "domain": null }, { "name": "MAILBARCODEWALKSEQUENCE", "type": "esriFieldTypeString", "alias": "MAILBARCODEWALKSEQUENCE", "length": 2, "domain": null }, { "name": "MAILBARCODECHECKDIGIT", "type": "esriFieldTypeString", "alias": "MAILBARCODECHECKDIGIT", "length": 1, "domain": null }, { "name": "MAILEFFECTIVEDATE", "type": "esriFieldTypeString", "alias": "MAILEFFECTIVEDATE", "length": 8, "domain": null }, { "name": "MAILSOURCECODE", "type": "esriFieldTypeString", "alias": "MAILSOURCECODE", "length": 1, "domain": null }, { "name": "PRIMARYTRA", "type": "esriFieldTypeSmallInteger", "alias": "PRIMARYTRA", "domain": null }, { "name": "SECONDARYTRA", "type": "esriFieldTypeSmallInteger", "alias": "SECONDARYTRA", "domain": null }, { "name": "TAXRATEAREA", "type": "esriFieldTypeInteger", "alias": "TAXRATEAREA", "domain": null }, { "name": "LANDVALUE", "type": "esriFieldTypeDouble", "alias": "LANDVALUE", "domain": null }, { "name": "IMPROVEMENTVALUE", "type": "esriFieldTypeDouble", "alias": "IMPROVEMENTVALUE", "domain": null }, { "name": "LANDIMPROVRATIO", "type": "esriFieldTypeInteger", "alias": "LANDIMPROVRATIO", "domain": null }, { "name": "CLCALANDVALUE", "type": "esriFieldTypeDouble", "alias": "CLCALANDVALUE", "domain": null }, { "name": "CLCAIMPROVEMENTVALUE", "type": "esriFieldTypeDouble", "alias": "CLCAIMPROVEMENTVALUE", "domain": null }, { "name": "FIXTURESVALUE", "type": "esriFieldTypeDouble", "alias": "FIXTURESVALUE", "domain": null }, { "name": "PERSONALPROPERTYVALUE", "type": "esriFieldTypeDouble", "alias": "PERSONALPROPERTYVALUE", "domain": null }, { "name": "HOUSEHOLDPERSONALPROPERTYVALUE", "type": "esriFieldTypeDouble", "alias": "HOUSEHOLDPERSONALPROPERTYVALUE", "domain": null }, { "name": "HOMEOWNERSEXEMPTIONVALUE", "type": "esriFieldTypeDouble", "alias": "HOMEOWNERSEXEMPTIONVALUE", "domain": null }, { "name": "OTHEREXEMPTIONVALUE", "type": "esriFieldTypeDouble", "alias": "OTHEREXEMPTIONVALUE", "domain": null }, { "name": "NETTOTALVALUE", "type": "esriFieldTypeDouble", "alias": "NETTOTALVALUE", "domain": null }, { "name": "LASTDOCUMENTPREFIX", "type": "esriFieldTypeString", "alias": "LASTDOCUMENTPREFIX", "length": 4, "domain": null }, { "name": "LASTDOCUMENTSERIES", "type": "esriFieldTypeInteger", "alias": "LASTDOCUMENTSERIES", "domain": null }, { "name": "LASTDOCUMENTDATE", "type": "esriFieldTypeInteger", "alias": "LASTDOCUMENTDATE", "domain": null }, { "name": "LASTDOCUMENTINPUTDATE", "type": "esriFieldTypeInteger", "alias": "LASTDOCUMENTINPUTDATE", "domain": null }, { "name": "USECODE", "type": "esriFieldTypeInteger", "alias": "USECODE", "domain": null }, { "name": "USEDESCRIPTION", "type": "esriFieldTypeString", "alias": "USEDESCRIPTION", "length": 81, "domain": null }, { "name": "PROPERTYCHARACTERCHANGEDATE", "type": "esriFieldTypeInteger", "alias": "PROPERTYCHARACTERCHANGEDATE", "domain": null }, { "name": "NUMBERUNITS", "type": "esriFieldTypeInteger", "alias": "NUMBERUNITS", "domain": null }, { "name": "BUILDINGCLASS", "type": "esriFieldTypeString", "alias": "BUILDINGCLASS", "length": 4, "domain": null }, { "name": "BUILDINGEFFECTIVEYEAR", "type": "esriFieldTypeString", "alias": "BUILDINGEFFECTIVEYEAR", "length": 4, "domain": null }, { "name": "BUILDINGAREA", "type": "esriFieldTypeDouble", "alias": "BUILDINGAREA", "domain": null }, { "name": "LOTSIZE", "type": "esriFieldTypeDouble", "alias": "LOTSIZE", "domain": null }, { "name": "ACRECODE", "type": "esriFieldTypeString", "alias": "ACRECODE", "length": 1, "domain": null }, { "name": "NUMBEROFBUILDINGS", "type": "esriFieldTypeInteger", "alias": "NUMBEROFBUILDINGS", "domain": null }, { "name": "NUMBEROFSTORIES", "type": "esriFieldTypeSingle", "alias": "NUMBEROFSTORIES", "domain": null }, { "name": "NUMBEROFROOMS", "type": "esriFieldTypeSmallInteger", "alias": "NUMBEROFROOMS", "domain": null }, { "name": "NUMBEROFBEDROOMS", "type": "esriFieldTypeSmallInteger", "alias": "NUMBEROFBEDROOMS", "domain": null }, { "name": "NUMBEROFBATH", "type": "esriFieldTypeSingle", "alias": "NUMBEROFBATH", "domain": null }, { "name": "PERCENTOFFICE", "type": "esriFieldTypeInteger", "alias": "PERCENTOFFICE", "domain": null }, { "name": "LANDFLAG", "type": "esriFieldTypeString", "alias": "LANDFLAG", "length": 1, "domain": null }, { "name": "CONFORMITYFLAG", "type": "esriFieldTypeString", "alias": "CONFORMITYFLAG", "length": 1, "domain": null }, { "name": "ADDITIONAREA", "type": "esriFieldTypeInteger", "alias": "ADDITIONAREA", "domain": null }, { "name": "MISCAREA", "type": "esriFieldTypeInteger", "alias": "MISCAREA", "domain": null }, { "name": "RENTABLESPACE", "type": "esriFieldTypeInteger", "alias": "RENTABLESPACE", "domain": null }, { "name": "YEARBUILT", "type": "esriFieldTypeString", "alias": "YEARBUILT", "length": 4, "domain": null }, { "name": "CONDOTYPE", "type": "esriFieldTypeString", "alias": "CONDOTYPE", "length": 1, "domain": null }, { "name": "ELEVATORFLAG", "type": "esriFieldTypeString", "alias": "ELEVATORFLAG", "length": 1, "domain": null }, { "name": "SWIMMINGPOOLCODE", "type": "esriFieldTypeString", "alias": "SWIMMINGPOOLCODE", "length": 1, "domain": null }, { "name": "SWIMMINGPOOLBUILT", "type": "esriFieldTypeString", "alias": "SWIMMINGPOOLBUILT", "length": 4, "domain": null }, { "name": "REMODELCODE", "type": "esriFieldTypeString", "alias": "REMODELCODE", "length": 3, "domain": null }, { "name": "CONDITIONCODE", "type": "esriFieldTypeString", "alias": "CONDITIONCODE", "length": 3, "domain": null }, { "name": "PARKINGCODE", "type": "esriFieldTypeString", "alias": "PARKINGCODE", "length": 4, "domain": null }, { "name": "PARKINGTYPE", "type": "esriFieldTypeString", "alias": "PARKINGTYPE", "length": 10, "domain": null }, { "name": "AMENITIESCODE", "type": "esriFieldTypeString", "alias": "AMENITIESCODE", "length": 4, "domain": null }, { "name": "UNITFLOOR", "type": "esriFieldTypeSmallInteger", "alias": "UNITFLOOR", "domain": null }, { "name": "WALLHEIGHT", "type": "esriFieldTypeSingle", "alias": "WALLHEIGHT", "domain": null }, { "name": "VIEWCODE", "type": "esriFieldTypeString", "alias": "VIEWCODE", "length": 1, "domain": null }, { "name": "SLOPECODE", "type": "esriFieldTypeString", "alias": "SLOPECODE", "length": 1, "domain": null }, { "name": "TOPOGRAPHYCODE", "type": "esriFieldTypeString", "alias": "TOPOGRAPHYCODE", "length": 1, "domain": null }, { "name": "HAZARDCODE", "type": "esriFieldTypeString", "alias": "HAZARDCODE", "length": 2, "domain": null }, { "name": "ECONOMICUNITFLAG", "type": "esriFieldTypeString", "alias": "ECONOMICUNITFLAG", "length": 1, "domain": null }, { "name": "ENDDATE", "type": "esriFieldTypeString", "alias": "ENDDATE", "length": 8, "domain": null }, { "name": "FileDate", "type": "esriFieldTypeInteger", "alias": "FileDate", "domain": null }, { "name": "UpdateDate", "type": "esriFieldTypeDate", "alias": "UpdateDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R629_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "NonClusteredIndex-20161110-APN_GIS", "fields": "APN_GIS", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "publication.SDE.HaywardParcels", "relatedTableId": 43, "role": "esriRelRoleDestination", "keyField": "APN_GIS", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "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 }