Name: dbo.tsbv_DataExtract

Display Field: PIN

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

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: LRSN

Unique ID Field:

Name : LRSN

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• LRSN (type: esriFieldTypeOID, alias: LRSN, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
• AltPIN (type: esriFieldTypeString, alias: AltPIN, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
• Acres (type: esriFieldTypeDouble, alias: Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PropCls (type: esriFieldTypeInteger, alias: PropCls, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExtCnt (type: esriFieldTypeInteger, alias: ExtCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YrBlt (type: esriFieldTypeInteger, alias: YrBlt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EffcYrBlt (type: esriFieldTypeInteger, alias: EffcYrBlt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImpvCnt (type: esriFieldTypeInteger, alias: ImpvCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlrCnt (type: esriFieldTypeInteger, alias: FlrCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BsmntCnt (type: esriFieldTypeInteger, alias: BsmntCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LivRmCnt (type: esriFieldTypeInteger, alias: LivRmCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DinRmCnt (type: esriFieldTypeInteger, alias: DinRmCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GrtRmCnt (type: esriFieldTypeInteger, alias: GrtRmCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KitCnt (type: esriFieldTypeInteger, alias: KitCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DenCnt (type: esriFieldTypeInteger, alias: DenCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExtCode1 (type: esriFieldTypeString, alias: ExtCode1, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ExtCode2 (type: esriFieldTypeString, alias: ExtCode2, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FndFootCode (type: esriFieldTypeString, alias: FndFootCode, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FndWallsCode (type: esriFieldTypeString, alias: FndWallsCode, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• RoofCover (type: esriFieldTypeString, alias: RoofCover, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Heating (type: esriFieldTypeString, alias: Heating, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AirCond (type: esriFieldTypeString, alias: AirCond, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DwellYN (type: esriFieldTypeString, alias: DwellYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MHomeYN (type: esriFieldTypeString, alias: MHomeYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PoolYN (type: esriFieldTypeString, alias: PoolYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AttGarageYN (type: esriFieldTypeString, alias: AttGarageYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DetGarageYN (type: esriFieldTypeString, alias: DetGarageYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CarPortYN (type: esriFieldTypeString, alias: CarPortYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CabinYN (type: esriFieldTypeString, alias: CabinYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BasementYN (type: esriFieldTypeString, alias: BasementYN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Bed_Rm_Cnt (type: esriFieldTypeInteger, alias: Bed_Rm_Cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Base_Area (type: esriFieldTypeInteger, alias: Base_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fin_Liv_Area (type: esriFieldTypeInteger, alias: Fin_Liv_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FireplaceAdj (type: esriFieldTypeInteger, alias: FireplaceAdj, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImprvValue (type: esriFieldTypeInteger, alias: ImprvValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LandValue (type: esriFieldTypeInteger, alias: LandValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• OwnStr (type: esriFieldTypeString, alias: OwnStr, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• OwnCity (type: esriFieldTypeString, alias: OwnCity, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• OwnSt (type: esriFieldTypeString, alias: OwnSt, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• OwnZip (type: esriFieldTypeString, alias: OwnZip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PropStr (type: esriFieldTypeString, alias: PropStr, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• PropCity (type: esriFieldTypeString, alias: PropCity, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PropSt (type: esriFieldTypeString, alias: PropSt, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PropZip (type: esriFieldTypeString, alias: PropZip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Situs (type: esriFieldTypeString, alias: Situs, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDesc (type: esriFieldTypeString, alias: LegalDesc, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ExtCov1Descr (type: esriFieldTypeString, alias: ExtCov1Descr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ExtCov2Descr (type: esriFieldTypeString, alias: ExtCov2Descr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FndFootDescr (type: esriFieldTypeString, alias: FndFootDescr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FndWallDescr (type: esriFieldTypeString, alias: FndWallDescr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RoofMatDescr (type: esriFieldTypeString, alias: RoofMatDescr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• HeatingDescr (type: esriFieldTypeString, alias: HeatingDescr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CoolingDescr (type: esriFieldTypeString, alias: CoolingDescr, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)

Templates:

Name: dbo.tsbv_DataExtract
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2026 2:27:54 AM

Schema Last Edit Date: 9/21/2026 2:24:06 AM

Data Last Edit Date: 9/21/2026 2:23:44 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat