View In:   ArcGIS Online Map Viewer

Name: Parcel Sales

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: fa24a861cab543188887f39542e740c0

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1935361.564941883
YMin: 323969.81215289235
XMax: 2211178.2560895532
YMax: 516642.69189822674
Spatial Reference: 2927  (2927)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSForwardDiagonal
Color: [255, 190, 190, 255]
Outline:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 2
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ParcelNumber ( type: esriFieldTypeString, alias: ParcelNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParcelNumber )
• SaleDate ( type: esriFieldTypeDate, alias: SaleDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SaleDate )
• Acres ( type: esriFieldTypeDouble, alias: Acres, editable: true, nullable: true, defaultValue: null, modelName: Acres )
• RollYear ( type: esriFieldTypeSmallInteger, alias: RollYear, editable: true, nullable: true, defaultValue: null, modelName: RollYear )
• ParcelType ( type: esriFieldTypeString, alias: ParcelType, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ParcelType )
• DORCode ( type: esriFieldTypeString, alias: DORCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DORCode )
• SecondaryCode ( type: esriFieldTypeString, alias: SecondaryCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SecondaryCode )
• MapNumber ( type: esriFieldTypeString, alias: MapNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MapNumber )
• PropertyClass ( type: esriFieldTypeString, alias: PropertyClass, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PropertyClass )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: false, length: 50, defaultValue: null, modelName: District )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Neighborhood )
• CurrentNeighborhood ( type: esriFieldTypeString, alias: CurrentNeighborhood, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CurrentNeighborhood )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Subdivision )
• HouseNumber ( type: esriFieldTypeString, alias: HouseNumber, editable: true, nullable: true, length: 35, defaultValue: null, modelName: HouseNumber )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StreetName )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 150, defaultValue: null, modelName: City )
• Zip ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Zip )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Description )
• SaleAgeMO ( type: esriFieldTypeSmallInteger, alias: SaleAgeMO, editable: true, nullable: true, defaultValue: null, modelName: SaleAgeMO )
• OriginalSalePrice ( type: esriFieldTypeDouble, alias: OriginalSalePrice, editable: true, nullable: false, defaultValue: null, modelName: OriginalSalePrice )
• AdjustedSalePrice ( type: esriFieldTypeDouble, alias: AdjustedSalePrice, editable: true, nullable: true, defaultValue: null, modelName: AdjustedSalePrice )
• PrimaryImprovement ( type: esriFieldTypeString, alias: PrimaryImprovement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimaryImprovement )
• PrimaryLandType ( type: esriFieldTypeString, alias: PrimaryLandType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimaryLandType )
• Parcels ( type: esriFieldTypeInteger, alias: Parcels, editable: true, nullable: true, defaultValue: null, modelName: Parcels )
• ASRatio ( type: esriFieldTypeDouble, alias: Adjusted Sales Ratio, editable: true, nullable: true, defaultValue: null, modelName: ASRatio )
• Grantor ( type: esriFieldTypeString, alias: Grantor, editable: true, nullable: true, length: 102, defaultValue: null, modelName: Grantor )
• Grantee ( type: esriFieldTypeString, alias: Grantee, editable: true, nullable: true, length: 102, defaultValue: null, modelName: Grantee )
• DeedType ( type: esriFieldTypeString, alias: DeedType, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DeedType )
• ExciseAffidavit ( type: esriFieldTypeString, alias: ExciseAffidavit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExciseAffidavit )
• RecordingNumber ( type: esriFieldTypeString, alias: RecordingNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RecordingNumber )
• ExciseLink ( type: esriFieldTypeString, alias: ExciseLink, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ExciseLink )
• AuditorLink ( type: esriFieldTypeString, alias: AuditorLink, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AuditorLink )
• LocalQual ( type: esriFieldTypeString, alias: LocalQual, editable: true, nullable: false, length: 7, defaultValue: null, modelName: LocalQual )
• StateQual ( type: esriFieldTypeString, alias: StateQual, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StateQual )
• PermitsSinceSale ( type: esriFieldTypeInteger, alias: PermitsSinceSale, editable: true, nullable: true, defaultValue: null, modelName: PermitsSinceSale )
• SaleNote ( type: esriFieldTypeString, alias: SaleNote, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SaleNote )
• ReviewNote ( type: esriFieldTypeString, alias: ReviewNote, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ReviewNote )
• UnimprovedSale ( type: esriFieldTypeString, alias: UnimprovedSale, editable: true, nullable: false, length: 3, defaultValue: null, modelName: UnimprovedSale )
• LandImprRatio ( type: esriFieldTypeDouble, alias: LandImprRatio, editable: true, nullable: false, defaultValue: null, modelName: LandImprRatio )
• LandShape ( type: esriFieldTypeString, alias: LandShape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LandShape )
• Frontage ( type: esriFieldTypeDouble, alias: Frontage, editable: true, nullable: true, defaultValue: null, modelName: Frontage )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UnitType )
• Units ( type: esriFieldTypeDouble, alias: Units, editable: true, nullable: true, defaultValue: null, modelName: Units )
• CurrentUseAcres ( type: esriFieldTypeDouble, alias: CurrentUseAcres, editable: true, nullable: true, defaultValue: null, modelName: CurrentUseAcres )
• DFLAcres ( type: esriFieldTypeDouble, alias: DFLAcres, editable: true, nullable: true, defaultValue: null, modelName: DFLAcres )
• LandAcres ( type: esriFieldTypeDouble, alias: LandAcres, editable: true, nullable: true, defaultValue: null, modelName: LandAcres )
• ImpType ( type: esriFieldTypeString, alias: ImpType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ImpType )
• Style ( type: esriFieldTypeString, alias: Style, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Style )
• YearBuilt ( type: esriFieldTypeSmallInteger, alias: YearBuilt, editable: true, nullable: true, defaultValue: null, modelName: YearBuilt )
• Quality ( type: esriFieldTypeSingle, alias: Quality, editable: true, nullable: true, defaultValue: null, modelName: Quality )
• Condition ( type: esriFieldTypeSingle, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition )
• EffectiveAge ( type: esriFieldTypeSmallInteger, alias: EffectiveAge, editable: true, nullable: true, defaultValue: null, modelName: EffectiveAge )
• CommercialStructures ( type: esriFieldTypeInteger, alias: CommercialStructures, editable: true, nullable: true, defaultValue: null, modelName: CommercialStructures )
• CommercialArea ( type: esriFieldTypeDouble, alias: CommercialArea, editable: true, nullable: true, defaultValue: null, modelName: CommercialArea )
• ResidentialStructures ( type: esriFieldTypeInteger, alias: ResidentialStructures, editable: true, nullable: true, defaultValue: null, modelName: ResidentialStructures )
• Bedrooms ( type: esriFieldTypeString, alias: Bedrooms, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Bedrooms )
• Bathrooms ( type: esriFieldTypeString, alias: Bathrooms, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Bathrooms )
• ResidentialArea ( type: esriFieldTypeDouble, alias: ResidentialArea, editable: true, nullable: true, defaultValue: null, modelName: ResidentialArea )
• BasementArea ( type: esriFieldTypeInteger, alias: BasementArea, editable: true, nullable: true, defaultValue: null, modelName: BasementArea )
• MinimalFinishArea ( type: esriFieldTypeInteger, alias: MinimalFinishArea, editable: true, nullable: true, defaultValue: null, modelName: MinimalFinishArea )
• PartitionFinishArea ( type: esriFieldTypeInteger, alias: PartitionFinishArea, editable: true, nullable: true, defaultValue: null, modelName: PartitionFinishArea )
• GarageType ( type: esriFieldTypeString, alias: GarageType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GarageType )
• GarageArea ( type: esriFieldTypeInteger, alias: GarageArea, editable: true, nullable: true, defaultValue: null, modelName: GarageArea )
• CarportType ( type: esriFieldTypeString, alias: CarportType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CarportType )
• CarportArea ( type: esriFieldTypeInteger, alias: CarportArea, editable: true, nullable: true, defaultValue: null, modelName: CarportArea )
• LandMrktValueAtSale ( type: esriFieldTypeDouble, alias: LandMrktValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: LandMrktValueAtSale )
• LandUseValueAtSale ( type: esriFieldTypeDouble, alias: LandUseValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: LandUseValueAtSale )
• CommercialValueAtSale ( type: esriFieldTypeDouble, alias: CommercialValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: CommercialValueAtSale )
• ResidentialValueAtSale ( type: esriFieldTypeDouble, alias: ResidentialValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: ResidentialValueAtSale )
• BasementValue ( type: esriFieldTypeDouble, alias: BasementValue, editable: true, nullable: true, defaultValue: null, modelName: BasementValue )
• GarageCarportValue ( type: esriFieldTypeDouble, alias: GarageCarportValue, editable: true, nullable: true, defaultValue: null, modelName: GarageCarportValue )
• MiscImpLumpValAtSale ( type: esriFieldTypeDouble, alias: MiscImpLumpValAtSale, editable: true, nullable: true, defaultValue: null, modelName: MiscImpLumpValAtSale )
• SiteImpValueAtSale ( type: esriFieldTypeDouble, alias: SiteImpValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: SiteImpValueAtSale )
• CropValueAtSale ( type: esriFieldTypeDouble, alias: CropValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: CropValueAtSale )
• TotalImpValueAtSale ( type: esriFieldTypeDouble, alias: TotalImpValueAtSale, editable: true, nullable: true, defaultValue: null, modelName: TotalImpValueAtSale )
• APMrktValue ( type: esriFieldTypeDouble, alias: APMrktValue, editable: true, nullable: true, defaultValue: null, modelName: APMrktValue )
• PreviousEstimate ( type: esriFieldTypeDouble, alias: PreviousEstimate, editable: true, nullable: true, defaultValue: null, modelName: PreviousEstimate )
• APImprMrkt ( type: esriFieldTypeDouble, alias: APImprMrkt, editable: true, nullable: true, defaultValue: null, modelName: APImprMrkt )
• APLandMrkt ( type: esriFieldTypeDouble, alias: APLandMrkt, editable: true, nullable: true, defaultValue: null, modelName: APLandMrkt )
• APLandUse ( type: esriFieldTypeDouble, alias: APLandUse, editable: true, nullable: true, defaultValue: null, modelName: APLandUse )
• APCropMrkt ( type: esriFieldTypeDouble, alias: APCropMrkt, editable: true, nullable: true, defaultValue: null, modelName: APCropMrkt )
• NewConstruction ( type: esriFieldTypeDouble, alias: NewConstruction, editable: true, nullable: true, defaultValue: null, modelName: NewConstruction )
• DistrictCode ( type: esriFieldTypeString, alias: DistrictCode, editable: true, nullable: false, length: 50, defaultValue: null, modelName: DistrictCode )
• EventDate ( type: esriFieldTypeDate, alias: EventDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventDate )
• ParentNeighborhood ( type: esriFieldTypeString, alias: ParentNeighborhood, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentNeighborhood )
• CurrentParentNeighborhood ( type: esriFieldTypeString, alias: CurrentParentNeighborhood, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CurrentParentNeighborhood )
• PhysDepr ( type: esriFieldTypeDouble, alias: PhysDepr, editable: true, nullable: true, defaultValue: null, modelName: PhysDepr )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Templates:

• Name: Parcel Sales
  Description:
  Prototype:
  PhysDepr: null
  CurrentParentNeighborhood: null
  ParcelNumber: null
  SaleDate: null
  Acres: null
  RollYear: null
  ParcelType:
  DORCode: null
  SecondaryCode: null
  MapNumber: null
  PropertyClass: null
  District:
  Neighborhood:
  CurrentNeighborhood: null
  Subdivision: null
  HouseNumber: null
  StreetName: null
  City: null
  Zip: null
  Description: null
  SaleAgeMO: null
  OriginalSalePrice: 0
  AdjustedSalePrice: null
  PrimaryImprovement: null
  PrimaryLandType: null
  Parcels: null
  ASRatio: null
  Grantor: null
  Grantee: null
  DeedType: null
  ExciseAffidavit: null
  RecordingNumber: null
  ExciseLink: null
  AuditorLink: null
  LocalQual:
  StateQual: null
  PermitsSinceSale: null
  SaleNote: null
  ReviewNote: null
  UnimprovedSale:
  LandImprRatio: 0
  LandShape: null
  Frontage: null
  UnitType: null
  Units: null
  CurrentUseAcres: null
  DFLAcres: null
  LandAcres: null
  ImpType: null
  Style: null
  YearBuilt: null
  Quality: null
  Condition: null
  EffectiveAge: null
  CommercialStructures: null
  CommercialArea: null
  ResidentialStructures: null
  Bedrooms: null
  Bathrooms: null
  ResidentialArea: null
  BasementArea: null
  MinimalFinishArea: null
  PartitionFinishArea: null
  GarageType: null
  GarageArea: null
  CarportType: null
  CarportArea: null
  LandMrktValueAtSale: null
  LandUseValueAtSale: null
  CommercialValueAtSale: null
  ResidentialValueAtSale: null
  BasementValue: null
  GarageCarportValue: null
  MiscImpLumpValAtSale: null
  SiteImpValueAtSale: null
  CropValueAtSale: null
  TotalImpValueAtSale: null
  APMrktValue: null
  PreviousEstimate: null
  APImprMrkt: null
  APLandMrkt: null
  APLandUse: null
  APCropMrkt: null
  NewConstruction: null
  DistrictCode:
  EventDate: null
  ParentNeighborhood: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata