Name: Address APN Table

Display Field: fullname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 27000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• addressptid ( type: esriFieldTypeString, alias: Address Point ID, length: 20 )
• preaddrnum ( type: esriFieldTypeString, alias: Address Number Prefix, length: 5 )
• addrnum ( type: esriFieldTypeString, alias: Address Number, length: 20 )
• addrnumsuf ( type: esriFieldTypeString, alias: Address Number Suffix, length: 5 )
• addrrange ( type: esriFieldTypeString, alias: Address Range, length: 50 )
• unittype ( type: esriFieldTypeString, alias: Address Unit Type, length: 10 )
• unitid ( type: esriFieldTypeString, alias: Address Unit Number, length: 10 )
• altunittype ( type: esriFieldTypeString, alias: Alternate Address Unit Type, length: 10 )
• altunitid ( type: esriFieldTypeString, alias: Alternate Address Unit Number, length: 10 )
• fullname ( type: esriFieldTypeString, alias: Full Road Name, length: 300 )
• fulladdr ( type: esriFieldTypeString, alias: Full Address, length: 500 )
• placename ( type: esriFieldTypeString, alias: Place Name, length: 250 )
• country ( type: esriFieldTypeString, alias: Country Abbreviation, length: 2 )
• stateabbreviation ( type: esriFieldTypeString, alias: State Abbreviation, length: 2 )
• municipality ( type: esriFieldTypeString, alias: Municipality Name, length: 100 )
• addrclass ( type: esriFieldTypeInteger, alias: Description )
• pointtype ( type: esriFieldTypeString, alias: Location, length: 30 )
• status ( type: esriFieldTypeString, alias: Status, length: 30 )
• APN ( type: esriFieldTypeString, alias: APN, length: 255 )
• parcel_das ( type: esriFieldTypeString, alias: APN (Formatted), length: 255 )
• LotNumber ( type: esriFieldTypeString, alias: Lot Number, length: 255 )
• P_OWNER_NM ( type: esriFieldTypeString, alias: Primary Owner, length: 255 )
• OWN_NM_2ND ( type: esriFieldTypeString, alias: Secondary Owner, length: 255 )
• Address_2 ( type: esriFieldTypeString, alias: Mailing Address, length: 255 )
• City_2 ( type: esriFieldTypeString, alias: Mailing City, length: 255 )
• USE_CODE ( type: esriFieldTypeString, alias: Use Code, length: 2 )
• DESC_ ( type: esriFieldTypeString, alias: Legal Description, length: 255 )
• TRA ( type: esriFieldTypeString, alias: Tract, length: 255 )
• VACANT_LOT ( type: esriFieldTypeString, alias: Vacant_Lot?, length: 255 )
• N_STR_NBR ( type: esriFieldTypeString, alias: Mailing Street Number, length: 255 )
• N_FRAC ( type: esriFieldTypeString, alias: Mailing Range, length: 255 )
• N_STR_NM ( type: esriFieldTypeString, alias: Mailing Street Name, length: 255 )
• N_STR_SUF ( type: esriFieldTypeString, alias: Mailing Street Suffix, length: 255 )
• N_APT_NBR ( type: esriFieldTypeString, alias: Mailing Apt. No., length: 255 )
• N_CTY_ST ( type: esriFieldTypeString, alias: Mailing City & State, length: 255 )
• N_ZIP ( type: esriFieldTypeString, alias: Mailing Zip, length: 255 )
• N_ZIP_EXT ( type: esriFieldTypeString, alias: Mailing Zip Ext., length: 255 )
• AlternativeName ( type: esriFieldTypeString, alias: Alt. House Name., length: 255 )
• addZip ( type: esriFieldTypeString, alias: Address ZIP, length: 255 )
• addZipExt ( type: esriFieldTypeString, alias: Address Zip Ext., length: 255 )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 255 )
• StreetSuffix ( type: esriFieldTypeString, alias: Street Suffix, length: 255 )
• LeftRight ( type: esriFieldTypeString, alias: Left or Right, length: 255 )
• Parity ( type: esriFieldTypeString, alias: Parity, length: 255 )
• PrefixDirectional ( type: esriFieldTypeString, alias: Street Prefix, length: 255 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 255 )
• Address ( type: esriFieldTypeString, alias: Situs Address, length: 255 )
• City_1 ( type: esriFieldTypeString, alias: Situs City, length: 255 )
• N_TAX_CODE ( type: esriFieldTypeString, alias: Taxability Code, length: 2 )
• RJCT_CODE ( type: esriFieldTypeString, alias: Reject Code, length: 1 )
• OS_CODE ( type: esriFieldTypeString, alias: Type of Ownership, length: 1 )
• XMP_CODE1 ( type: esriFieldTypeString, alias: Exemption Code 1, length: 2 )
• Transfer_Date_Num ( type: esriFieldTypeInteger, alias: Last Transfer Date )
• LAND_VALUE ( type: esriFieldTypeInteger, alias: Land Value ($) )
• LIEN_YEAR ( type: esriFieldTypeInteger, alias: Lien Year )
• ParcelMapLink ( type: esriFieldTypeString, alias: Parcel Map URL, length: 255 )
• OS_PRCNT ( type: esriFieldTypeDouble, alias: OS_PRCNT )
• OWN_ID_2ND ( type: esriFieldTypeString, alias: Second Owner Code, length: 1 )
• SR_PST_FLG ( type: esriFieldTypeString, alias: SR_PST_FLG, length: 1 )
• APNCHECK ( type: esriFieldTypeString, alias: Tax Check Digit, length: 1 )
• RETRED_FLG ( type: esriFieldTypeString, alias: RETRED_FLG, length: 1 )
• TRA_CH_YR ( type: esriFieldTypeString, alias: TRA_CH_YR, length: 4 )
• N_ODD_EVN ( type: esriFieldTypeString, alias: N_ODD_EVN, length: 1 )
• VIEW_ ( type: esriFieldTypeString, alias: VIEW_, length: 1 )
• ACREAGE ( type: esriFieldTypeDouble, alias: ACREAGE )
• S_STR_NM ( type: esriFieldTypeString, alias: S_STR_NM, length: 30 )
• S_STR_SUF ( type: esriFieldTypeString, alias: S_STR_SUF, length: 4 )
• S_ODD_EVN ( type: esriFieldTypeString, alias: S_ODD_EVN, length: 1 )
• S_STR_NBR ( type: esriFieldTypeString, alias: S_STR_NBR, length: 5 )
• S_FRAC ( type: esriFieldTypeString, alias: S_FRAC, length: 4 )
• S_APT_NBR ( type: esriFieldTypeString, alias: S_APT_NBR, length: 9 )
• S_CTY_ABBR ( type: esriFieldTypeString, alias: S_CTY_ABBR, length: 5 )
• s_city ( type: esriFieldTypeString, alias: s_city, length: 30 )
• S_ZIP ( type: esriFieldTypeInteger, alias: S_ZIP )
• S_ZIP_EXT ( type: esriFieldTypeString, alias: S_ZIP_EXT, length: 4 )
• C_DED_NBR ( type: esriFieldTypeString, alias: C_DED_NBR, length: 8 )
• C_DED_DT ( type: esriFieldTypeString, alias: C_DED_DT, length: 8 )
• P_DED_NBR ( type: esriFieldTypeString, alias: P_DED_NBR, length: 8 )
• P_DED_DT ( type: esriFieldTypeString, alias: Previous Sale 2, length: 8 )
• P_DED_NBR2 ( type: esriFieldTypeString, alias: P_DED_NBR2, length: 8 )
• P_DED_DT2 ( type: esriFieldTypeString, alias: Previous Sale 3, length: 8 )
• FRM_PRCL ( type: esriFieldTypeString, alias: FRM_PRCL, length: 11 )
• TO_PRCL ( type: esriFieldTypeString, alias: TO_PRCL, length: 11 )
• RESP_CODE ( type: esriFieldTypeInteger, alias: RESP_CODE )
• XMP_AMT1 ( type: esriFieldTypeInteger, alias: XMP_AMT1 )
• AR_SWP_DT ( type: esriFieldTypeInteger, alias: AR_SWP_DT )
• TRACT ( type: esriFieldTypeString, alias: TRACT, length: 8 )
• VAL_CH_CD ( type: esriFieldTypeString, alias: VAL_CH_CD, length: 4 )
• TYPE_1 ( type: esriFieldTypeString, alias: TYPE_1, length: 1 )
• BLDNG_NBR ( type: esriFieldTypeInteger, alias: BLDNG_NBR )
• NBR_BLDNGS ( type: esriFieldTypeInteger, alias: NBR_BLDNGS )
• BEDS ( type: esriFieldTypeString, alias: BEDS, length: 3 )
• BATHS ( type: esriFieldTypeInteger, alias: BATHS )
• TOT_ROOMS ( type: esriFieldTypeString, alias: TOT_ROOMS, length: 3 )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 10 )
• CARPORT ( type: esriFieldTypeString, alias: CARPORT, length: 1 )
• GARAGE ( type: esriFieldTypeString, alias: GARAGE, length: 1 )
• STALLS ( type: esriFieldTypeString, alias: STALLS, length: 3 )
• ADDITION ( type: esriFieldTypeString, alias: ADDITION, length: 10 )
• REMODEL ( type: esriFieldTypeString, alias: REMODEL, length: 10 )
• CENTRL_A_H ( type: esriFieldTypeString, alias: CENTRL_A_H, length: 10 )
• GRG_CONV ( type: esriFieldTypeString, alias: GRG_CONV, length: 10 )
• YR_HS_BLT ( type: esriFieldTypeString, alias: Year House Built, length: 4 )
• LND_PROB ( type: esriFieldTypeString, alias: LND_PROB, length: 10 )
• TOPO ( type: esriFieldTypeString, alias: TOPO, length: 10 )
• NUISANCE ( type: esriFieldTypeString, alias: NUISANCE, length: 10 )
• MOD_STR ( type: esriFieldTypeString, alias: MOD_STR, length: 10 )
• SETTING ( type: esriFieldTypeString, alias: SETTING, length: 10 )
• BLD_EFFYR ( type: esriFieldTypeString, alias: BLD_EFFYR, length: 4 )
• TOT_AREA ( type: esriFieldTypeInteger, alias: TOT_AREA )
• YR_PL_BLT ( type: esriFieldTypeString, alias: YR_PL_BLT, length: 4 )
• POOL_SQ_FT ( type: esriFieldTypeString, alias: POOL_SQ_FT, length: 6 )
• POOL ( type: esriFieldTypeString, alias: POOL, length: 1 )
• MISC_BLDG ( type: esriFieldTypeString, alias: MISC_BLDG, length: 1 )
• YR_BLT_MSC ( type: esriFieldTypeString, alias: YR_BLT_MSC, length: 4 )
• USE_DESC ( type: esriFieldTypeString, alias: USE_DESC, length: 50 )
• STORIES ( type: esriFieldTypeInteger, alias: STORIES )
• UNITS ( type: esriFieldTypeInteger, alias: UNITS )
• SQFT_PR_UT ( type: esriFieldTypeString, alias: SQFT_PR_UT, length: 10 )
• YR_BUILT ( type: esriFieldTypeString, alias: YR_BUILT, length: 4 )
• GISPerimeter ( type: esriFieldTypeDouble, alias: GIS Perimeter )
• GISArea ( type: esriFieldTypeDouble, alias: GIS Area (Ft) )
• LastRecordedDate ( type: esriFieldTypeDate, alias: LastRecordedDate, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata