Name: OPSDB.DBO.ParcelData_2017
Display Field: ST_NAME
Type: Table
Description:
Copyright Text:
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- NEIGHBORHO (type: esriFieldTypeString, alias: NEIGHBORHO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
- HOUSE_NUM (type: esriFieldTypeString, alias: HOUSE_NUM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ST_DIR (type: esriFieldTypeString, alias: ST_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- ST_NAME (type: esriFieldTypeString, alias: ST_NAME, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- APT_NUM (type: esriFieldTypeString, alias: APT_NUM, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- ST_SUFFIX (type: esriFieldTypeString, alias: ST_SUFFIX, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
- TAXPAYER_A (type: esriFieldTypeString, alias: TAXPAYER_A, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- ZIP4 (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- TAXPAYER_C (type: esriFieldTypeString, alias: TAXPAYER_C, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- LAND_AV (type: esriFieldTypeString, alias: LAND_AV, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- TAXPAYER_Z (type: esriFieldTypeString, alias: TAXPAYER_Z, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- IMP_VALUE (type: esriFieldTypeString, alias: IMP_VALUE, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- AGE (type: esriFieldTypeString, alias: AGE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- TOTAL_VALU (type: esriFieldTypeString, alias: TOTAL_VALU, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- TYPE_RES (type: esriFieldTypeString, alias: TYPE_RES, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- NO_APT (type: esriFieldTypeString, alias: NO_APT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- USE_ (type: esriFieldTypeString, alias: USE_, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- EXT_WALL_C (type: esriFieldTypeString, alias: EXT_WALL_C, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- GARAGE_CON (type: esriFieldTypeString, alias: GARAGE_CON, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- GARAGE_SIZ (type: esriFieldTypeString, alias: GARAGE_SIZ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- NUM_BED (type: esriFieldTypeString, alias: NUM_BED, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- ROOMS (type: esriFieldTypeString, alias: ROOMS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- NUM_FULL_B (type: esriFieldTypeString, alias: NUM_FULL_B, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- BASE_TYPE (type: esriFieldTypeString, alias: BASE_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- NUM_HALF_B (type: esriFieldTypeString, alias: NUM_HALF_B, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- ATTIC_TYPE (type: esriFieldTypeString, alias: ATTIC_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- BASE_FIN (type: esriFieldTypeString, alias: BASE_FIN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- ATTIC_FIN (type: esriFieldTypeString, alias: ATTIC_FIN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CENTAL_AC (type: esriFieldTypeString, alias: CENTAL_AC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- BLDG_SQFT (type: esriFieldTypeString, alias: BLDG_SQFT, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- NUM_FIREPL (type: esriFieldTypeString, alias: NUM_FIREPL, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- IMP_CLASS (type: esriFieldTypeString, alias: IMP_CLASS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- LAND_SQFT (type: esriFieldTypeString, alias: LAND_SQFT, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- MULTI_IMP_ (type: esriFieldTypeString, alias: MULTI_IMP_, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- OVERALL_CL (type: esriFieldTypeString, alias: OVERALL_CL, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- DEPTH (type: esriFieldTypeString, alias: DEPTH, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- FRONT_FT (type: esriFieldTypeString, alias: FRONT_FT, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- TAX_CODE (type: esriFieldTypeString, alias: TAX_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- EX_AG_CODE (type: esriFieldTypeString, alias: EX_AG_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- TAXPAYER_N (type: esriFieldTypeString, alias: TAXPAYER_N, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- EXEMPT_AGE (type: esriFieldTypeString, alias: EXEMPT_AGE, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LANDMARK_B (type: esriFieldTypeString, alias: LANDMARK_B, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- PIN10 (type: esriFieldTypeString, alias: PIN10, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Templates:
Name: OPSDB.DBO.ParcelData_2017
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/4/2021 9:49:16 PM
Schema Last Edit Date: 5/4/2021 9:49:16 PM
Data Last Edit Date: 5/4/2021 9:49:16 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat