Name: BCPAFABRICPROD.dbo.BCPA_INFO

Display Field: SITUS_STREET_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e4e8960d18544b01a02a7b07c60a0caf

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 )
• GROUP_ID ( type: esriFieldTypeString, alias: GROUP_ID, length: 1 )
• USE_CODE ( type: esriFieldTypeString, alias: USE_CODE, length: 2 )
• PAIRINGCODE ( type: esriFieldTypeString, alias: PAIRINGCODE, length: 3 )
• LAND_TAG ( type: esriFieldTypeString, alias: LAND_TAG, length: 2 )
• JUST_BUILDING_VALUE ( type: esriFieldTypeInteger, alias: JUST_BUILDING_VALUE )
• BLDG_ADJ_SQ_FOOTAGE ( type: esriFieldTypeDouble, alias: BLDG_ADJ_SQ_FOOTAGE )
• B_SQFT ( type: esriFieldTypeString, alias: B_SQFT, length: 16 )
• B_SQFT_RATE ( type: esriFieldTypeString, alias: B_SQFT_RATE, length: 16 )
• BLDG_YEAR_BUILT ( type: esriFieldTypeSmallInteger, alias: BLDG_YEAR_BUILT )
• ACTUAL_YEAR_BUILT ( type: esriFieldTypeString, alias: ACTUAL_YEAR_BUILT, length: 4 )
• BLDG_USE_CODE ( type: esriFieldTypeString, alias: BLDG_USE_CODE, length: 3 )
• NEW_PROPERTY_CODE ( type: esriFieldTypeString, alias: NEW_PROPERTY_CODE, length: 4 )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 4 )
• LAND_CALC_PRC_UNIT_1 ( type: esriFieldTypeDouble, alias: LAND_CALC_PRC_UNIT_1 )
• LAND_CALC_TYPE_1 ( type: esriFieldTypeString, alias: LAND_CALC_TYPE_1, length: 2 )
• L_PRC ( type: esriFieldTypeString, alias: L_PRC, length: 16 )
• SITUS_STREET_NUMBER ( type: esriFieldTypeString, alias: SITUS_STREET_NUMBER, length: 6 )
• RES_DISTRICT ( type: esriFieldTypeSmallInteger, alias: RES_DISTRICT )
• COMM_DISTRICT ( type: esriFieldTypeSmallInteger, alias: COMM_DISTRICT )
• COMM_AB_DISTRICT ( type: esriFieldTypeString, alias: COMM_AB_DISTRICT, length: 2 )
• INSPECT_DATE ( type: esriFieldTypeDate, alias: INSPECT_DATE, length: 8 )
• CYCLE ( type: esriFieldTypeString, alias: CYCLE, length: 1 )
• BLDG_UNITS ( type: esriFieldTypeInteger, alias: BLDG_UNITS )
• TOTAL_PRC_PER_SQFT ( type: esriFieldTypeString, alias: TOTAL_PRC_PER_SQFT, length: 16 )
• LAND_GROSS ( type: esriFieldTypeString, alias: LAND_GROSS, length: 16 )
• SITUS_STREET_NUMBER_END ( type: esriFieldTypeString, alias: SITUS_STREET_NUMBER_END, 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_CITY ( type: esriFieldTypeString, alias: SITUS_CITY, length: 2 )
• SITUS_ZIP_CODE ( type: esriFieldTypeString, alias: SITUS_ZIP_CODE, length: 9 )
• SITUS_UNIT_NUMBER ( type: esriFieldTypeString, alias: SITUS_UNIT_NUMBER, length: 5 )
• UNDER_AIR_SQFT ( type: esriFieldTypeString, alias: UNDER_AIR_SQFT, length: 16 )
• TOTAL_PRC_PER_UNIT ( type: esriFieldTypeString, alias: TOTAL_PRC_PER_UNIT, length: 16 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

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

  Iteminfo   Thumbnail   Metadata