Tables:

Table: ParcelsFacts (0)

Name: ParcelsFacts

Display Field: SitusName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: de93197912ea4abd98b15a3f05cd6d8c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Account ( type: esriFieldTypeString, alias: Account, length: 20 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 200 )
• SitusNumber ( type: esriFieldTypeInteger, alias: SitusNumber )
• SitusName ( type: esriFieldTypeString, alias: SitusName, length: 120 )
• Street ( type: esriFieldTypeString, alias: Street, length: 160 )
• SitusZIP ( type: esriFieldTypeString, alias: SitusZIP, length: 10 )
• CityCode ( type: esriFieldTypeString, alias: CityCode, length: 8 )
• CityName ( type: esriFieldTypeString, alias: CityName, length: 120 )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, length: 10 )
• Parcel ( type: esriFieldTypeString, alias: Parcel, length: 40 )
• NbhdCode ( type: esriFieldTypeString, alias: NbhdCode, length: 20 )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, length: 200 )
• PropType ( type: esriFieldTypeString, alias: PropType, length: 10 )
• PropTypeName ( type: esriFieldTypeString, alias: PropTypeName, length: 120 )
• Style ( type: esriFieldTypeString, alias: Style, length: 80 )
• OccDesc ( type: esriFieldTypeString, alias: OccDesc, length: 160 )
• Bedrooms ( type: esriFieldTypeSmallInteger, alias: Bedrooms )
• Bathrooms ( type: esriFieldTypeSmallInteger, alias: Bathrooms )
• HalfBathrooms ( type: esriFieldTypeSmallInteger, alias: HalfBathrooms )
• TotalRooms ( type: esriFieldTypeSmallInteger, alias: TotalRooms )
• TotalArea ( type: esriFieldTypeInteger, alias: TotalArea )
• BaseArea ( type: esriFieldTypeInteger, alias: BaseArea )
• BasementArea ( type: esriFieldTypeInteger, alias: BasementArea )
• BasementFinishedArea ( type: esriFieldTypeInteger, alias: BasementFinishedArea )
• GarageArea ( type: esriFieldTypeInteger, alias: GarageArea )
• QualCode ( type: esriFieldTypeString, alias: QualCode, length: 10 )
• QualityDesc ( type: esriFieldTypeString, alias: QualityDesc, length: 120 )
• SalePrice1 ( type: esriFieldTypeDouble, alias: SalePrice1 )
• SaleAdjPrice1 ( type: esriFieldTypeDouble, alias: SaleAdjPrice1 )
• SaleDate1 ( type: esriFieldTypeDateOnly, alias: SaleDate1 )
• SaleREACD1 ( type: esriFieldTypeString, alias: SaleREACD1, length: 4 )
• SaleREACD2 ( type: esriFieldTypeString, alias: SaleREACD2, length: 4 )
• SaleREACD3 ( type: esriFieldTypeString, alias: SaleREACD3, length: 4 )
• SaleREACD4 ( type: esriFieldTypeString, alias: SaleREACD4, length: 4 )
• SaleQualifiedAny ( type: esriFieldTypeString, alias: SaleQualifiedAny, length: 1 )
• LastRefreshedAt ( type: esriFieldTypeDate, alias: LastRefreshedAt, length: 8, precision: 1 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Account_Norm ( type: esriFieldTypeString, alias: Account_Norm, length: 20 )
• YearBuilt ( type: esriFieldTypeInteger, alias: YearBuilt )
• LotSize ( type: esriFieldTypeDouble, alias: LotSize )
• TotalMarket ( type: esriFieldTypeDouble, alias: TotalMarket )
• LandMarketValue ( type: esriFieldTypeDouble, alias: LandMarketValue )
• OccCode ( type: esriFieldTypeString, alias: OccCode, length: 10 )
• SchoolDistrictCode ( type: esriFieldTypeString, alias: SchoolDistrictCode, length: 2 )
• SchoolDistrictName ( type: esriFieldTypeString, alias: SchoolDistrictName, length: 80 )
• MailAdd1 ( type: esriFieldTypeString, alias: MailAdd1, length: 120 )
• MailAdd2 ( type: esriFieldTypeString, alias: MailAdd2, length: 120 )
• MailAdd3 ( type: esriFieldTypeString, alias: MailAdd3, length: 120 )
• Fireplaces ( type: esriFieldTypeSmallInteger, alias: Fireplaces )
• ExteriorWallPercentage ( type: esriFieldTypeSingle, alias: ExteriorWallPercentage )

Relationships:

• Parcels have sketches (2) -- Related To: BuildingLegend (3)
• Parcels have assessed value history (1) -- Related To: AssessedValueHistory (1)

Table: AssessedValueHistory (1)

Name: AssessedValueHistory

Display Field: Account

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: de93197912ea4abd98b15a3f05cd6d8c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Account ( type: esriFieldTypeString, alias: Account, length: 20 )
• TaxYear ( type: esriFieldTypeInteger, alias: TaxYear )
• Asd_Val ( type: esriFieldTypeDouble, alias: Asd_Val )
• Asd2_Val ( type: esriFieldTypeDouble, alias: Asd2_Val )
• LastRefreshedAt ( type: esriFieldTypeDate, alias: LastRefreshedAt, length: 8, precision: 1 )
• ParentGlobalID ( type: esriFieldTypeGUID, alias: ParentGlobalID, length: 38 )
• Account_Norm ( type: esriFieldTypeString, alias: Account_Norm, length: 20 )
• PF_GLOBALID ( type: esriFieldTypeGUID, alias: PF_GLOBALID, length: 38 )

Relationships:

• Assessed value history belongs to parcel (1) -- Related To: ParcelsFacts (0)

Table: BuildingSketches (2)

Name: BuildingSketches

Display Field: Account

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: de93197912ea4abd98b15a3f05cd6d8c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Account ( type: esriFieldTypeString, alias: Account, length: 20 )
• STRAP ( type: esriFieldTypeString, alias: STRAP, length: 20 )
• BLD_NUM ( type: esriFieldTypeSmallInteger, alias: BLD_NUM )
• SEC_NUM ( type: esriFieldTypeSmallInteger, alias: SEC_NUM )
• TRAV ( type: esriFieldTypeString, alias: TRAV, length: 1073741822 )
• LEGEND_TEXT ( type: esriFieldTypeString, alias: LEGEND_TEXT, length: 1073741822 )
• TRAV_HASH ( type: esriFieldTypeString, alias: TRAV_HASH, length: 64 )
• LAST_TOD ( type: esriFieldTypeDate, alias: LAST_TOD, length: 8, precision: 1 )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE )
• STRAP_NORM ( type: esriFieldTypeString, alias: STRAP_NORM, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Account_Norm ( type: esriFieldTypeString, alias: Account_Norm, length: 20 )
• PF_GLOBALID ( type: esriFieldTypeGUID, alias: PF_GLOBALID, length: 38 )

Table: BuildingLegend (3)

Name: BuildingLegend

Display Field: Account

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: de93197912ea4abd98b15a3f05cd6d8c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Account ( type: esriFieldTypeString, alias: Account, length: 20 )
• STRAP ( type: esriFieldTypeString, alias: STRAP, length: 20 )
• BLD_NUM ( type: esriFieldTypeSmallInteger, alias: BLD_NUM )
• SEC_NUM ( type: esriFieldTypeSmallInteger, alias: SEC_NUM )
• TRAV ( type: esriFieldTypeString, alias: TRAV, length: 1073741822 )
• LEGEND_TEXT ( type: esriFieldTypeString, alias: LEGEND_TEXT, length: 1073741822 )
• TRAV_HASH ( type: esriFieldTypeString, alias: TRAV_HASH, length: 64 )
• LAST_TOD ( type: esriFieldTypeDate, alias: LAST_TOD, length: 8, precision: 1 )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE )
• STRAP_NORM ( type: esriFieldTypeString, alias: STRAP_NORM, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Account_Norm ( type: esriFieldTypeString, alias: Account_Norm, length: 20 )
• PF_GLOBALID ( type: esriFieldTypeGUID, alias: PF_GLOBALID, length: 38 )

Relationships:

• Sketches belong to parcel (2) -- Related To: ParcelsFacts (0)