Name: BCPA_PROD.REAL_ALL_VIEW

Display Field: NAME_LINE_1

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 96ebb4a94d4b4795ba64a5c83d4ed934

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• FOLIO_NUMBER ( type: esriFieldTypeString, alias: FOLIO_NUMBER, length: 12 )
• NAME_LINE_1 ( type: esriFieldTypeString, alias: NAME_LINE_1, length: 70 )
• NAME_LINE_2 ( type: esriFieldTypeString, alias: NAME_LINE_2, length: 70 )
• ADDRESS_LINE_1 ( type: esriFieldTypeString, alias: ADDRESS_LINE_1, length: 32 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 25 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 2 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 5 )
• ZIP4 ( type: esriFieldTypeString, alias: ZIP4, length: 4 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 49 )
• SEARCH_ADDRESS ( type: esriFieldTypeString, alias: SEARCH_ADDRESS, length: 105 )
• SITUS_STREET_NUMBER ( type: esriFieldTypeString, alias: SITUS_STREET_NUMBER, length: 6 )
• SITUS_STREET_DIRECTION ( type: esriFieldTypeString, alias: SITUS_STREET_DIRECTION, length: 2 )
• SITUS_STREET_NAME ( type: esriFieldTypeString, alias: SITUS_STREET_NAME, length: 25 )
• SITUS_STREET_TYPE ( type: esriFieldTypeString, alias: SITUS_STREET_TYPE, length: 4 )
• SITUS_STREET_POST_DIR ( type: esriFieldTypeString, alias: SITUS_STREET_POST_DIR, length: 2 )
• SITUS_UNIT_NUMBER ( type: esriFieldTypeString, alias: SITUS_UNIT_NUMBER, length: 5 )
• STRATA_ID ( type: esriFieldTypeSmallInteger, alias: STRATA_ID )
• SUBSTRATA_ID ( type: esriFieldTypeSmallInteger, alias: SUBSTRATA_ID )
• LY_STRATA_ID ( type: esriFieldTypeSmallInteger, alias: LY_STRATA_ID )
• GROUP_ID ( type: esriFieldTypeString, alias: GROUP_ID, length: 1 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 5 )
• DISTRICT ( type: esriFieldTypeDouble, alias: DISTRICT )
• RES_DISTRICT ( type: esriFieldTypeSmallInteger, alias: RES_DISTRICT )
• COMM_DISTRICT ( type: esriFieldTypeSmallInteger, alias: COMM_DISTRICT )
• AB_DISTRICT ( type: esriFieldTypeString, alias: AB_DISTRICT, length: 2 )
• AG_DISTRICT ( type: esriFieldTypeSmallInteger, alias: AG_DISTRICT )
• AERIAL ( type: esriFieldTypeString, alias: AERIAL, length: 1 )
• NEW_PROPERTY_CODE ( type: esriFieldTypeString, alias: NEW_PROPERTY_CODE, length: 4 )
• CYCLE ( type: esriFieldTypeSmallInteger, alias: CYCLE )
• USE_CODE ( type: esriFieldTypeString, alias: USE_CODE, length: 2 )
• USE_TYPE ( type: esriFieldTypeString, alias: USE_TYPE, length: 2 )
• BLDG_USE_CODE ( type: esriFieldTypeString, alias: BLDG_USE_CODE, length: 3 )
• MARKET_AREA ( type: esriFieldTypeString, alias: MARKET_AREA, length: 2 )
• SUBMARKET ( type: esriFieldTypeString, alias: SUBMARKET, length: 25 )
• PAIRING_CODE ( type: esriFieldTypeString, alias: PAIRING_CODE, length: 3 )
• MILLAGE_CODE ( type: esriFieldTypeString, alias: MILLAGE_CODE, length: 4 )
• SITUS_CITY ( type: esriFieldTypeString, alias: SITUS_CITY, length: 2 )
• SITUS_CITY_NAME ( type: esriFieldTypeString, alias: SITUS_CITY_NAME, length: 50 )
• SITUS_ZIP_CODE ( type: esriFieldTypeString, alias: SITUS_ZIP_CODE, length: 5 )
• CONTACT_NUMBER ( type: esriFieldTypeString, alias: CONTACT_NUMBER, length: 25 )
• AG_RENEWAL_CARD ( type: esriFieldTypeString, alias: AG_RENEWAL_CARD, length: 1 )
• AG_RENEWAL ( type: esriFieldTypeSmallInteger, alias: AG_RENEWAL )
• AG_GRANTED ( type: esriFieldTypeString, alias: AG_GRANTED, length: 50 )
• AG_DENIED ( type: esriFieldTypeString, alias: AG_DENIED, length: 50 )
• AG_DENIED_REASON ( type: esriFieldTypeString, alias: AG_DENIED_REASON, length: 200 )
• AG_RENEWAL_VAB ( type: esriFieldTypeSmallInteger, alias: AG_RENEWAL_VAB )
• AG_GRANTED_VAB ( type: esriFieldTypeString, alias: AG_GRANTED_VAB, length: 50 )
• AG_DENIED_VAB ( type: esriFieldTypeString, alias: AG_DENIED_VAB, length: 50 )
• AG_RENEWAL_LY ( type: esriFieldTypeSmallInteger, alias: AG_RENEWAL_LY )
• AG_GRANTED_LY ( type: esriFieldTypeString, alias: AG_GRANTED_LY, length: 50 )
• AG_DENIED_LY ( type: esriFieldTypeString, alias: AG_DENIED_LY, length: 50 )
• AG_DENIED_REASON_LY ( type: esriFieldTypeString, alias: AG_DENIED_REASON_LY, length: 200 )
• AG_RENEWAL_LY_VAB ( type: esriFieldTypeSmallInteger, alias: AG_RENEWAL_LY_VAB )
• AG_GRANTED_LY_VAB ( type: esriFieldTypeString, alias: AG_GRANTED_LY_VAB, length: 50 )
• AG_DENIED_LY_VAB ( type: esriFieldTypeString, alias: AG_DENIED_LY_VAB, length: 50 )
• AG_GRANTED_VAB_YEAR ( type: esriFieldTypeString, alias: AG_GRANTED_VAB_YEAR, length: 4 )
• JUST_BUILDING_VALUE ( type: esriFieldTypeInteger, alias: JUST_BUILDING_VALUE )
• JUST_LAND_VALUE ( type: esriFieldTypeInteger, alias: JUST_LAND_VALUE )
• JUST_OTHER_VALUE ( type: esriFieldTypeInteger, alias: JUST_OTHER_VALUE )
• JUST_VALUE ( type: esriFieldTypeInteger, alias: JUST_VALUE )
• LY_JUST_VALUE ( type: esriFieldTypeInteger, alias: LY_JUST_VALUE )
• BLDG_ADJ_SQ_FOOTAGE ( type: esriFieldTypeBigInteger, alias: BLDG_ADJ_SQ_FOOTAGE )
• BLDG_UNITS ( type: esriFieldTypeInteger, alias: BLDG_UNITS )
• GIS_SQUARE_FOOT ( type: esriFieldTypeInteger, alias: GIS_SQUARE_FOOT )
• FLAT_RATE_FLAG ( type: esriFieldTypeString, alias: FLAT_RATE_FLAG, length: 1 )
• ADD_VALUE ( type: esriFieldTypeInteger, alias: ADD_VALUE )
• DEL_VALUE ( type: esriFieldTypeInteger, alias: DEL_VALUE )
• LAND_TAG ( type: esriFieldTypeString, alias: LAND_TAG, length: 2 )
• PRC_1 ( type: esriFieldTypeDouble, alias: PRC_1 )
• FACT_1 ( type: esriFieldTypeDouble, alias: FACT_1 )
• TYPE_1 ( type: esriFieldTypeString, alias: TYPE_1, length: 2 )
• PRC_2 ( type: esriFieldTypeDouble, alias: PRC_2 )
• FACT_2 ( type: esriFieldTypeDouble, alias: FACT_2 )
• TYPE_2 ( type: esriFieldTypeString, alias: TYPE_2, length: 2 )
• PRC_3 ( type: esriFieldTypeDouble, alias: PRC_3 )
• FACT_3 ( type: esriFieldTypeDouble, alias: FACT_3 )
• TYPE_3 ( type: esriFieldTypeString, alias: TYPE_3, length: 2 )
• PRC_4 ( type: esriFieldTypeDouble, alias: PRC_4 )
• FACT_4 ( type: esriFieldTypeDouble, alias: FACT_4 )
• TYPE_4 ( type: esriFieldTypeString, alias: TYPE_4, length: 2 )
• COUNTY_LAND_USE_CODE ( type: esriFieldTypeSmallInteger, alias: COUNTY_LAND_USE_CODE )
• CITY_ZONING_CODE ( type: esriFieldTypeString, alias: CITY_ZONING_CODE, length: 20 )
• SEND_TO ( type: esriFieldTypeSmallInteger, alias: SEND_TO )
• VIEW_USER ( type: esriFieldTypeString, alias: VIEW_USER, length: 25 )
• VIEW_DATE ( type: esriFieldTypeDate, alias: VIEW_DATE, length: 8, precision: 1 )
• ASSIGN_USER ( type: esriFieldTypeString, alias: ASSIGN_USER, length: 25 )
• ASSIGN_DATE ( type: esriFieldTypeDate, alias: ASSIGN_DATE, length: 8, precision: 1 )
• INSPECT_USER ( type: esriFieldTypeString, alias: INSPECT_USER, length: 25 )
• INSPECT_DATE ( type: esriFieldTypeDate, alias: INSPECT_DATE, length: 8, precision: 1 )
• PERMIT_INSPECT_USER ( type: esriFieldTypeString, alias: PERMIT_INSPECT_USER, length: 25 )
• PERMIT_INSPECT_DATE ( type: esriFieldTypeDate, alias: PERMIT_INSPECT_DATE, length: 8, precision: 1 )
• STATUS_DATE ( type: esriFieldTypeDate, alias: STATUS_DATE, length: 8, precision: 1 )
• COMPLETE_DATE ( type: esriFieldTypeDate, alias: COMPLETE_DATE, length: 8, precision: 1 )
• PERMIT_COMPLETE_DATE ( type: esriFieldTypeDate, alias: PERMIT_COMPLETE_DATE, length: 8, precision: 1 )
• LAST_INSPECT_USER ( type: esriFieldTypeString, alias: LAST_INSPECT_USER, length: 25 )
• LAST_INSPECT_DATE ( type: esriFieldTypeDate, alias: LAST_INSPECT_DATE, length: 8, precision: 1 )
• INSPECT_TYPE ( type: esriFieldTypeSmallInteger, alias: INSPECT_TYPE )
• INSPECT_TYPE_DESC ( type: esriFieldTypeString, alias: INSPECT_TYPE_DESC, length: 14 )
• STATUS ( type: esriFieldTypeSmallInteger, alias: STATUS )
• STATUS_DESC ( type: esriFieldTypeString, alias: STATUS_DESC, length: 25 )
• CYCLE_DUE ( type: esriFieldTypeString, alias: CYCLE_DUE, length: 1 )
• AERIAL_DUE ( type: esriFieldTypeString, alias: AERIAL_DUE, length: 1 )
• ACTUAL_YEAR_BUILT ( type: esriFieldTypeString, alias: ACTUAL_YEAR_BUILT, length: 4 )
• BEDS ( type: esriFieldTypeSingle, alias: BEDS )
• BATHS ( type: esriFieldTypeSingle, alias: BATHS )
• DAMAGE_TYPE ( type: esriFieldTypeString, alias: DAMAGE_TYPE, length: 5 )
• PHOTO_ORDER ( type: esriFieldTypeString, alias: PHOTO_ORDER, length: 1 )
• NOTE ( type: esriFieldTypeString, alias: NOTE, length: 2000 )
• NOTE_USER ( type: esriFieldTypeString, alias: NOTE_USER, length: 25 )
• PERMIT_COUNT ( type: esriFieldTypeDouble, alias: PERMIT_COUNT )
• PERMIT_COST ( type: esriFieldTypeDouble, alias: PERMIT_COST )
• CO_COUNT ( type: esriFieldTypeDouble, alias: CO_COUNT )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, length: 50 )
• SKETCH ( type: esriFieldTypeString, alias: SKETCH, length: 1 )
• PLANS ( type: esriFieldTypeString, alias: PLANS, length: 1 )
• BLDG_STATUS ( type: esriFieldTypeString, alias: BLDG_STATUS, length: 4 )
• BLDG_STATUS_NY ( type: esriFieldTypeString, alias: BLDG_STATUS_NY, length: 4 )
• CONTACT_ADDR ( type: esriFieldTypeString, alias: CONTACT_ADDR, length: 75 )
• PUBLIC_PHOTO_DATE ( type: esriFieldTypeDate, alias: PUBLIC_PHOTO_DATE, length: 8, precision: 1 )
• NO_PUBLIC_PHOTO_REASON ( type: esriFieldTypeSmallInteger, alias: NO_PUBLIC_PHOTO_REASON )
• DOOR_HANGER_DATE ( type: esriFieldTypeDate, alias: DOOR_HANGER_DATE, length: 8, precision: 1 )
• NO_DOOR_HANGER_REASON ( type: esriFieldTypeSmallInteger, alias: NO_DOOR_HANGER_REASON )
• REMODEL_YEAR ( type: esriFieldTypeString, alias: REMODEL_YEAR, length: 4 )
• FLOOR_PLAN ( type: esriFieldTypeString, alias: FLOOR_PLAN, length: 10 )
• DAMAGE_YEAR ( type: esriFieldTypeString, alias: DAMAGE_YEAR, length: 4 )
• DAMAGE_YEAR_TYPE ( type: esriFieldTypeString, alias: DAMAGE_YEAR_TYPE, length: 5 )
• LEGAL_CASE ( type: esriFieldTypeString, alias: LEGAL_CASE, length: 1 )
• RNUM ( type: esriFieldTypeDouble, alias: RNUM )
• BLDG_CARD_DATE ( type: esriFieldTypeDate, alias: BLDG_CARD_DATE, length: 8, precision: 1 )
• BLDG_CARD_YEAR ( type: esriFieldTypeString, alias: BLDG_CARD_YEAR, length: 4 )
• BLDG_PERCENT ( type: esriFieldTypeString, alias: BLDG_PERCENT, length: 3 )
• BLDG_ADD ( type: esriFieldTypeInteger, alias: BLDG_ADD )
• BLDG_CARD_USER ( type: esriFieldTypeString, alias: BLDG_CARD_USER, length: 50 )
• SALE_NUM ( type: esriFieldTypeSmallInteger, alias: SALE_NUM )
• SALE_DATE ( type: esriFieldTypeDate, alias: SALE_DATE, length: 8, precision: 1 )
• SALE_AMOUNT ( type: esriFieldTypeInteger, alias: SALE_AMOUNT )
• DEED_TYPE ( type: esriFieldTypeString, alias: DEED_TYPE, length: 3 )
• SALE_VER ( type: esriFieldTypeString, alias: SALE_VER, length: 4 )
• INFO_LINK ( type: esriFieldTypeString, alias: INFO_LINK, length: 54 )
• MAP_LINK ( type: esriFieldTypeString, alias: MAP_LINK, length: 53 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, length: 8 )

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

  Iteminfo   Thumbnail   Metadata