{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 38, "name": "Landrec_Property", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FIRSTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 10, "domain": null }, { "name": "APN", "type": "esriFieldTypeInteger", "alias": "APN", "domain": null }, { "name": "STREETNUM", "type": "esriFieldTypeString", "alias": "STREETNUM", "length": 10, "domain": null }, { "name": "STREETDIR", "type": "esriFieldTypeString", "alias": "STREETDIR", "length": 10, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 50, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 50, "domain": null }, { "name": "SITUSZIP", "type": "esriFieldTypeString", "alias": "SITUSZIP", "length": 5, "domain": null }, { "name": "FIRSTNAME", "type": "esriFieldTypeString", "alias": "FIRSTNAME", "length": 100, "domain": null }, { "name": "LASTNAME", "type": "esriFieldTypeString", "alias": "LASTNAME", "length": 100, "domain": null }, { "name": "MAILING1", "type": "esriFieldTypeString", "alias": "MAILING1", "length": 100, "domain": null }, { "name": "MAILING2", "type": "esriFieldTypeString", "alias": "MAILING2", "length": 100, "domain": null }, { "name": "MAILCITY", "type": "esriFieldTypeString", "alias": "MAILCITY", "length": 50, "domain": null }, { "name": "MAILSTATE", "type": "esriFieldTypeString", "alias": "MAILSTATE", "length": 10, "domain": null }, { "name": "MAILZIP", "type": "esriFieldTypeString", "alias": "MAILZIP", "length": 16, "domain": null }, { "name": "LAND_USE", "type": "esriFieldTypeString", "alias": "LAND_USE", "length": 16, "domain": null }, { "name": "ZONING", "type": "esriFieldTypeString", "alias": "ZONING", "length": 50, "domain": null }, { "name": "WATER", "type": "esriFieldTypeString", "alias": "WATER", "length": 4, "domain": null }, { "name": "SEWER", "type": "esriFieldTypeString", "alias": "SEWER", "length": 4, "domain": null }, { "name": "ACREAGE", "type": "esriFieldTypeSingle", "alias": "ACREAGE", "domain": null }, { "name": "TAXDIST", "type": "esriFieldTypeString", "alias": "TAXDIST", "length": 4, "domain": null }, { "name": "BEDROOMS", "type": "esriFieldTypeInteger", "alias": "BEDROOMS", "domain": null }, { "name": "FULLBATH", "type": "esriFieldTypeInteger", "alias": "FULLBATH", "domain": null }, { "name": "THREEQBATH", "type": "esriFieldTypeInteger", "alias": "THREEQBATH", "domain": null }, { "name": "HALFBATH", "type": "esriFieldTypeInteger", "alias": "HALFBATH", "domain": null }, { "name": "BATHS", "type": "esriFieldTypeSingle", "alias": "BATHS", "domain": null }, { "name": "YEARBLT", "type": "esriFieldTypeInteger", "alias": "YEARBLT", "domain": null }, { "name": "LANDASS", "type": "esriFieldTypeInteger", "alias": "LANDASS", "domain": null }, { "name": "BUILDASS", "type": "esriFieldTypeInteger", "alias": "BUILDASS", "domain": null }, { "name": "TOTALASS", "type": "esriFieldTypeInteger", "alias": "TOTALASS", "domain": null }, { "name": "EXEMPTASS", "type": "esriFieldTypeInteger", "alias": "EXEMPTASS", "domain": null }, { "name": "LANDAPR", "type": "esriFieldTypeInteger", "alias": "LANDAPR", "domain": null }, { "name": "BUILDAPR", "type": "esriFieldTypeInteger", "alias": "BUILDAPR", "domain": null }, { "name": "TOTALAPR", "type": "esriFieldTypeInteger", "alias": "TOTALAPR", "domain": null }, { "name": "DEPRECIATION", "type": "esriFieldTypeSingle", "alias": "DEPRECIATION", "domain": null }, { "name": "SALEDATE", "type": "esriFieldTypeString", "alias": "SALEDATE", "length": 10, "domain": null }, { "name": "SALEPRICE", "type": "esriFieldTypeInteger", "alias": "SALEPRICE", "domain": null }, { "name": "OCCUPANCY", "type": "esriFieldTypeString", "alias": "OCCUPANCY", "length": 4, "domain": null }, { "name": "PROPCODE", "type": "esriFieldTypeString", "alias": "PROPCODE", "length": 20, "domain": null }, { "name": "TAXYEAR", "type": "esriFieldTypeString", "alias": "TAXYEAR", "length": 4, "domain": null }, { "name": "STORIES", "type": "esriFieldTypeString", "alias": "STORIES", "length": 50, "domain": null }, { "name": "TOWNHOUSE", "type": "esriFieldTypeString", "alias": "TOWNHOUSE", "length": 1, "domain": null }, { "name": "SQFEET", "type": "esriFieldTypeInteger", "alias": "SQFEET", "domain": null }, { "name": "UNITS", "type": "esriFieldTypeInteger", "alias": "UNITS", "domain": null }, { "name": "AVCONSYEAR", "type": "esriFieldTypeString", "alias": "AVCONSYEAR", "length": 4, "domain": null }, { "name": "PERCENTCOMP", "type": "esriFieldTypeSingle", "alias": "PERCENTCOMP", "domain": null }, { "name": "BUILDINGTYPE", "type": "esriFieldTypeString", "alias": "BUILDINGTYPE", "length": 4, "domain": null }, { "name": "ALTBUILD1", "type": "esriFieldTypeString", "alias": "ALTBUILD1", "length": 4, "domain": null }, { "name": "ALTBUILD1SQFT", "type": "esriFieldTypeSingle", "alias": "ALTBUILD1SQFT", "domain": null }, { "name": "ALTBUILD2", "type": "esriFieldTypeString", "alias": "ALTBUILD2", "length": 4, "domain": null }, { "name": "ALTBUILD2SQFT", "type": "esriFieldTypeSingle", "alias": "ALTBUILD2SQFT", "domain": null }, { "name": "ALTBUILD3", "type": "esriFieldTypeString", "alias": "ALTBUILD3", "length": 4, "domain": null }, { "name": "ALTBUILD3SQFT", "type": "esriFieldTypeSingle", "alias": "ALTBUILD3SQFT", "domain": null }, { "name": "ALTBUILD4", "type": "esriFieldTypeString", "alias": "ALTBUILD4", "length": 4, "domain": null }, { "name": "ALTBUILD4SQFT", "type": "esriFieldTypeSingle", "alias": "ALTBUILD4SQFT", "domain": null }, { "name": "LEGAL", "type": "esriFieldTypeString", "alias": "LEGAL", "length": 100, "domain": null }, { "name": "DOCNUMBER", "type": "esriFieldTypeString", "alias": "DOCNUMBER", "length": 20, "domain": null }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "length": 25, "domain": null }, { "name": "NBHD", "type": "esriFieldTypeString", "alias": "NBHD", "length": 4, "domain": null }, { "name": "SPECPROPCODE", "type": "esriFieldTypeString", "alias": "SPECPROPCODE", "length": 20, "domain": null }, { "name": "INFLU1CODE", "type": "esriFieldTypeString", "alias": "INFLU1CODE", "length": 4, "domain": null }, { "name": "INFLU1PERCENT", "type": "esriFieldTypeSmallInteger", "alias": "INFLU1PERCENT", "domain": null }, { "name": "INFLU2CODE", "type": "esriFieldTypeString", "alias": "INFLU2CODE", "length": 4, "domain": null }, { "name": "INFLU2PERCENT", "type": "esriFieldTypeSmallInteger", "alias": "INFLU2PERCENT", "domain": null }, { "name": "INFLU3CODE", "type": "esriFieldTypeString", "alias": "INFLU3CODE", "length": 4, "domain": null }, { "name": "INFLU3PERCENT", "type": "esriFieldTypeSmallInteger", "alias": "INFLU3PERCENT", "domain": null }, { "name": "QC", "type": "esriFieldTypeString", "alias": "QC", "length": 4, "domain": null }, { "name": "LAND_BASE", "type": "esriFieldTypeInteger", "alias": "LAND_BASE", "domain": null }, { "name": "NBC", "type": "esriFieldTypeString", "alias": "NBC", "length": 2, "domain": null }, { "name": "LandUnitType", "type": "esriFieldTypeString", "alias": "LandUnitType", "length": 4, "domain": null }, { "name": "TotalLandUnitTypes", "type": "esriFieldTypeInteger", "alias": "TotalLandUnitTypes", "domain": null }, { "name": "Fireplaces", "type": "esriFieldTypeSmallInteger", "alias": "Fireplaces", "domain": null }, { "name": "HeatType", "type": "esriFieldTypeString", "alias": "HeatType", "length": 50, "domain": null }, { "name": "SecHeatType", "type": "esriFieldTypeString", "alias": "SecHeatType", "length": 50, "domain": null }, { "name": "Agency", "type": "esriFieldTypeString", "alias": "Agency", "length": 64, "domain": null }, { "name": "AG_ABBR", "type": "esriFieldTypeString", "alias": "AG_ABBR", "length": 5, "domain": null }, { "name": "PropName", "type": "esriFieldTypeString", "alias": "PropName", "length": 25, "domain": null }, { "name": "str", "type": "esriFieldTypeString", "alias": "str", "length": 50, "domain": null }, { "name": "str_sfx", "type": "esriFieldTypeString", "alias": "str_sfx", "length": 10, "domain": null }, { "name": "str_sfx_dir", "type": "esriFieldTypeString", "alias": "str_sfx_dir", "length": 5, "domain": null }, { "name": "str_num_sfx", "type": "esriFieldTypeString", "alias": "str_num_sfx", "length": 5, "domain": null }, { "name": "ParcelStatus", "type": "esriFieldTypeString", "alias": "ParcelStatus", "length": 3, "domain": null }, { "name": "Permit_num", "type": "esriFieldTypeString", "alias": "Permit_num", "length": 25, "domain": null }, { "name": "Issue_dt", "type": "esriFieldTypeDate", "alias": "Issue_dt", "length": 8, "domain": null }, { "name": "Permit_dscr", "type": "esriFieldTypeString", "alias": "Permit_dscr", "length": 155, "domain": null }, { "name": "dor_cd", "type": "esriFieldTypeString", "alias": "dor_cd", "length": 16, "domain": null }, { "name": "FLATYEAR", "type": "esriFieldTypeInteger", "alias": "FLATYEAR", "domain": null }, { "name": "ABATE", "type": "esriFieldTypeDouble", "alias": "ABATE", "domain": null }, { "name": "GROSSTAX", "type": "esriFieldTypeDouble", "alias": "GROSSTAX", "domain": null }, { "name": "EXEMPT", "type": "esriFieldTypeDouble", "alias": "EXEMPT", "domain": null }, { "name": "NETTAX", "type": "esriFieldTypeDouble", "alias": "NETTAX", "domain": null }, { "name": "TAXVALUE", "type": "esriFieldTypeOID", "alias": "TAXVALUE", "domain": null }, { "name": "ASSESSEDIMPS", "type": "esriFieldTypeInteger", "alias": "ASSESSEDIMPS", "domain": null }, { "name": "ASSESSEDLAND", "type": "esriFieldTypeInteger", "alias": "ASSESSEDLAND", "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "COUNTRY", "length": 50, "domain": null }, { "name": "EXEMPTION", "type": "esriFieldTypeInteger", "alias": "EXEMPTION", "domain": null }, { "name": "OWNER1", "type": "esriFieldTypeString", "alias": "OWNER1", "length": 100, "domain": null }, { "name": "OWNER2", "type": "esriFieldTypeString", "alias": "OWNER2", "length": 100, "domain": null }, { "name": "OWNER3", "type": "esriFieldTypeString", "alias": "OWNER3", "length": 100, "domain": null }, { "name": "TOWNSHIP", "type": "esriFieldTypeString", "alias": "TOWNSHIP", "length": 15, "domain": null }, { "name": "RANGE", "type": "esriFieldTypeString", "alias": "RANGE", "length": 15, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "SECTION", "length": 50, "domain": null }, { "name": "FULLADDRESS", "type": "esriFieldTypeString", "alias": "FULLADDRESS", "length": 80, "domain": null }, { "name": "SITUSZIPCITY", "type": "esriFieldTypeString", "alias": "SITUSZIPCITY", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 20, "domain": null }, { "name": "SUBDIVISION", "type": "esriFieldTypeString", "alias": "SUBDIVISION", "length": 255, "domain": null }, { "name": "SUBMAP", "type": "esriFieldTypeString", "alias": "SUBMAP", "length": 100, "domain": null }, { "name": "PARCELMAP", "type": "esriFieldTypeString", "alias": "PARCELMAP", "length": 100, "domain": null }, { "name": "RSMAP", "type": "esriFieldTypeString", "alias": "RSMAP", "length": 100, "domain": null }, { "name": "BLOCK", "type": "esriFieldTypeString", "alias": "BLOCK", "length": 50, "domain": null }, { "name": "WATER_QI", "type": "esriFieldTypeString", "alias": "WATER_QI", "length": 50, "domain": null }, { "name": "SEWER_QI", "type": "esriFieldTypeString", "alias": "SEWER_QI", "length": 50, "domain": null }, { "name": "GSA_ID", "type": "esriFieldTypeInteger", "alias": "GSA_ID", "domain": null }, { "name": "CONF_FLG", "type": "esriFieldTypeSmallInteger", "alias": "CONF_FLG", "domain": null }, { "name": "STRAP", "type": "esriFieldTypeString", "alias": "STRAP", "length": 8, "domain": null }, { "name": "ZoningWithDetail", "type": "esriFieldTypeString", "alias": "ZoningWithDetail", "length": 100, "domain": null } ], "indexes": [ { "name": "ix_landrec_property_GSA_parcelId", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ix_landrec_property_GSA_gisapn", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_TAXVALUE", "fields": "TAXVALUE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "TAXVALUE" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000 }