Name: resbldg_extr

Display Field: STREETNAME

Type: Table

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

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MAJOR (type: esriFieldTypeString, alias: Major, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• MINOR (type: esriFieldTypeString, alias: Minor, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• PIN (type: esriFieldTypeString, alias: Pin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BLDGNBR (type: esriFieldTypeSmallInteger, alias: Building number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NBRLIVINGUNITS (type: esriFieldTypeSmallInteger, alias: Number of living units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITUSADDRESS (type: esriFieldTypeString, alias: Situs address, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STORIES (type: esriFieldTypeSmallInteger, alias: Stories, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDGGRADE (type: esriFieldTypeSmallInteger, alias: Building grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDGGRADEVAR (type: esriFieldTypeSmallInteger, alias: Building grade variation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFT1STFLOOR (type: esriFieldTypeInteger, alias: Square feet: 1st floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTHALFFLOOR (type: esriFieldTypeInteger, alias: Square feet: Half floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFT2NDFLOOR (type: esriFieldTypeInteger, alias: Square feet: 2nd floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTUPPERFLOOR (type: esriFieldTypeInteger, alias: Square feet: Upper floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTUNFINFULL (type: esriFieldTypeInteger, alias: Square feet: Unfinished full, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTUNFINHALF (type: esriFieldTypeInteger, alias: Square feet: Unfinished half, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTTOTLIVING (type: esriFieldTypeInteger, alias: Square feet: Total living, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTTOTBASEMENT (type: esriFieldTypeInteger, alias: Square feet: Total basement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTFINBASEMENT (type: esriFieldTypeInteger, alias: Square feet: Finished basement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FINBASEMENTGRADE (type: esriFieldTypeSmallInteger, alias: Finished basement grade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTGARBSMT (type: esriFieldTypeInteger, alias: Square feet: Garage basement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTGARATCH (type: esriFieldTypeInteger, alias: Square feet: Garage attached, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DAYLIGHTBASEMENT (type: esriFieldTypeString, alias: Daylight basement, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SQFTOPENPORCH (type: esriFieldTypeInteger, alias: Square feet: Open porch, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTENCLOSEDPORCH (type: esriFieldTypeInteger, alias: Square feet: Enclosed porch, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTDECK (type: esriFieldTypeInteger, alias: Square feet: Feck, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEATSYSTEM (type: esriFieldTypeSmallInteger, alias: Heat system, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEATSOURCE (type: esriFieldTypeSmallInteger, alias: Heat source, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BRICKSTONE (type: esriFieldTypeSmallInteger, alias: Percent brick stone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIEWUTILIZATION (type: esriFieldTypeString, alias: View utilization, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BEDROOMS (type: esriFieldTypeSmallInteger, alias: Bedrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BATHHALFCOUNT (type: esriFieldTypeSmallInteger, alias: Bath: Half count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BATH3QTRCOUNT (type: esriFieldTypeSmallInteger, alias: Bath: 3qtr count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BATHFULLCOUNT (type: esriFieldTypeSmallInteger, alias: Bath: Full count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FPSINGLESTORY (type: esriFieldTypeSmallInteger, alias: Fireplace: Single story, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FPMULTISTORY (type: esriFieldTypeSmallInteger, alias: Fireplace: Multiple story, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FPFREESTANDING (type: esriFieldTypeSmallInteger, alias: Fireplace: Freestanding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FPADDITIONAL (type: esriFieldTypeSmallInteger, alias: Fireplace: Additional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YRBUILT (type: esriFieldTypeSmallInteger, alias: Year built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YRRENOVATED (type: esriFieldTypeSmallInteger, alias: Year renovated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCNTCOMPLETE (type: esriFieldTypeSmallInteger, alias: Percent complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBSOLESCENCE (type: esriFieldTypeSmallInteger, alias: Obsolescence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCNTNETCONDITION (type: esriFieldTypeSmallInteger, alias: Percent net condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDGCONDITION (type: esriFieldTypeSmallInteger, alias: Building condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDNLCOST (type: esriFieldTypeDouble, alias: Additional cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUILDINGNUMBER (type: esriFieldTypeString, alias: Building number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FRACTION (type: esriFieldTypeString, alias: Fraction, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• DIRECTIONPREFIX (type: esriFieldTypeString, alias: Direction prefix, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: Street name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• STREETTYPE (type: esriFieldTypeString, alias: Street type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• DIRECTIONSUFFIX (type: esriFieldTypeString, alias: Direction suffix, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: resbldg_extr
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/3/2019 6:02:14 PM

Schema Last Edit Date: 7/3/2019 6:02:14 PM

Data Last Edit Date: 7/3/2019 6:02:14 PM

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