View In:   ArcGIS Online Map Viewer

Name: Parcel Sales

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: f98558f1495e46b4b523f63a0fd1dc38

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

Extent:

XMin: 1935361.564941883
YMin: 323969.81215289235
XMax: 2211178.2560895532
YMax: 517343.2689091414
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: false
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: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• parcelnumber ( modelName: parcelnumber, nullable: true, editable: true, defaultValue: null, length: 50, alias: ParcelNumber, type: esriFieldTypeString )
• saledate ( modelName: saledate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: SaleDate, type: esriFieldTypeDate )
• acres ( modelName: acres, nullable: true, editable: true, defaultValue: null, alias: Acres, type: esriFieldTypeDouble )
• rollyear ( modelName: rollyear, nullable: true, editable: true, defaultValue: null, alias: RollYear, type: esriFieldTypeSmallInteger )
• parceltype ( modelName: parceltype, nullable: false, editable: true, defaultValue: null, length: 50, alias: ParcelType, type: esriFieldTypeString )
• dorcode ( modelName: dorcode, nullable: true, editable: true, defaultValue: null, length: 50, alias: DORCode, type: esriFieldTypeString )
• secondarycode ( modelName: secondarycode, nullable: true, editable: true, defaultValue: null, length: 50, alias: SecondaryCode, type: esriFieldTypeString )
• mapnumber ( modelName: mapnumber, nullable: true, editable: true, defaultValue: null, length: 50, alias: MapNumber, type: esriFieldTypeString )
• propertyclass ( modelName: propertyclass, nullable: true, editable: true, defaultValue: null, length: 50, alias: PropertyClass, type: esriFieldTypeString )
• district ( modelName: district, nullable: false, editable: true, defaultValue: null, length: 50, alias: District, type: esriFieldTypeString )
• neighborhood ( modelName: neighborhood, nullable: false, editable: true, defaultValue: null, length: 50, alias: Neighborhood, type: esriFieldTypeString )
• currentneighborhood ( modelName: currentneighborhood, nullable: true, editable: true, defaultValue: null, length: 50, alias: CurrentNeighborhood, type: esriFieldTypeString )
• subdivision ( modelName: subdivision, nullable: true, editable: true, defaultValue: null, length: 75, alias: Subdivision, type: esriFieldTypeString )
• housenumber ( modelName: housenumber, nullable: true, editable: true, defaultValue: null, length: 35, alias: HouseNumber, type: esriFieldTypeString )
• streetname ( modelName: streetname, nullable: true, editable: true, defaultValue: null, length: 100, alias: StreetName, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 150, alias: City, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 20, alias: Zip, type: esriFieldTypeString )
• description ( modelName: description, nullable: true, editable: true, defaultValue: null, length: 250, alias: Description, type: esriFieldTypeString )
• saleagemo ( modelName: saleagemo, nullable: true, editable: true, defaultValue: null, alias: SaleAgeMO, type: esriFieldTypeSmallInteger )
• originalsaleprice ( modelName: originalsaleprice, nullable: false, editable: true, defaultValue: null, alias: OriginalSalePrice, type: esriFieldTypeDouble )
• adjustedsaleprice ( modelName: adjustedsaleprice, nullable: true, editable: true, defaultValue: null, alias: AdjustedSalePrice, type: esriFieldTypeDouble )
• primaryimprovement ( modelName: primaryimprovement, nullable: true, editable: true, defaultValue: null, length: 50, alias: PrimaryImprovement, type: esriFieldTypeString )
• primarylandtype ( modelName: primarylandtype, nullable: true, editable: true, defaultValue: null, length: 50, alias: PrimaryLandType, type: esriFieldTypeString )
• parcels ( modelName: parcels, nullable: true, editable: true, defaultValue: null, alias: Parcels, type: esriFieldTypeInteger )
• asratio ( modelName: asratio, nullable: true, editable: true, defaultValue: null, alias: Adjusted Sales Ratio, type: esriFieldTypeDouble )
• grantor ( modelName: grantor, nullable: true, editable: true, defaultValue: null, length: 102, alias: Grantor, type: esriFieldTypeString )
• grantee ( modelName: grantee, nullable: true, editable: true, defaultValue: null, length: 102, alias: Grantee, type: esriFieldTypeString )
• deedtype ( modelName: deedtype, nullable: true, editable: true, defaultValue: null, length: 100, alias: DeedType, type: esriFieldTypeString )
• exciseaffidavit ( modelName: exciseaffidavit, nullable: true, editable: true, defaultValue: null, length: 50, alias: ExciseAffidavit, type: esriFieldTypeString )
• recordingnumber ( modelName: recordingnumber, nullable: true, editable: true, defaultValue: null, length: 50, alias: RecordingNumber, type: esriFieldTypeString )
• exciselink ( modelName: exciselink, nullable: true, editable: true, defaultValue: null, length: 100, alias: ExciseLink, type: esriFieldTypeString )
• auditorlink ( modelName: auditorlink, nullable: true, editable: true, defaultValue: null, length: 100, alias: AuditorLink, type: esriFieldTypeString )
• localqual ( modelName: localqual, nullable: false, editable: true, defaultValue: null, length: 7, alias: LocalQual, type: esriFieldTypeString )
• statequal ( modelName: statequal, nullable: true, editable: true, defaultValue: null, length: 100, alias: StateQual, type: esriFieldTypeString )
• permitssincesale ( modelName: permitssincesale, nullable: true, editable: true, defaultValue: null, alias: PermitsSinceSale, type: esriFieldTypeInteger )
• salenote ( modelName: salenote, nullable: true, editable: true, defaultValue: null, length: 250, alias: SaleNote, type: esriFieldTypeString )
• reviewnote ( modelName: reviewnote, nullable: true, editable: true, defaultValue: null, length: 250, alias: ReviewNote, type: esriFieldTypeString )
• unimprovedsale ( modelName: unimprovedsale, nullable: false, editable: true, defaultValue: null, length: 3, alias: UnimprovedSale, type: esriFieldTypeString )
• landimprratio ( modelName: landimprratio, nullable: false, editable: true, defaultValue: null, alias: LandImprRatio, type: esriFieldTypeDouble )
• landshape ( modelName: landshape, nullable: true, editable: true, defaultValue: null, length: 20, alias: LandShape, type: esriFieldTypeString )
• frontage ( modelName: frontage, nullable: true, editable: true, defaultValue: null, alias: Frontage, type: esriFieldTypeDouble )
• unittype ( modelName: unittype, nullable: true, editable: true, defaultValue: null, length: 20, alias: UnitType, type: esriFieldTypeString )
• units ( modelName: units, nullable: true, editable: true, defaultValue: null, alias: Units, type: esriFieldTypeDouble )
• currentuseacres ( modelName: currentuseacres, nullable: true, editable: true, defaultValue: null, alias: CurrentUseAcres, type: esriFieldTypeDouble )
• dflacres ( modelName: dflacres, nullable: true, editable: true, defaultValue: null, alias: DFLAcres, type: esriFieldTypeDouble )
• landacres ( modelName: landacres, nullable: true, editable: true, defaultValue: null, alias: LandAcres, type: esriFieldTypeDouble )
• imptype ( modelName: imptype, nullable: true, editable: true, defaultValue: null, length: 50, alias: ImpType, type: esriFieldTypeString )
• style ( modelName: style, nullable: true, editable: true, defaultValue: null, length: 50, alias: Style, type: esriFieldTypeString )
• yearbuilt ( modelName: yearbuilt, nullable: true, editable: true, defaultValue: null, alias: YearBuilt, type: esriFieldTypeSmallInteger )
• quality ( modelName: quality, nullable: true, editable: true, defaultValue: null, alias: Quality, type: esriFieldTypeDouble )
• condition ( modelName: condition, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeDouble )
• effectiveage ( modelName: effectiveage, nullable: true, editable: true, defaultValue: null, alias: EffectiveAge, type: esriFieldTypeSmallInteger )
• commercialstructures ( modelName: commercialstructures, nullable: true, editable: true, defaultValue: null, alias: CommercialStructures, type: esriFieldTypeInteger )
• commercialarea ( modelName: commercialarea, nullable: true, editable: true, defaultValue: null, alias: CommercialArea, type: esriFieldTypeDouble )
• residentialstructures ( modelName: residentialstructures, nullable: true, editable: true, defaultValue: null, alias: ResidentialStructures, type: esriFieldTypeInteger )
• bedrooms ( modelName: bedrooms, nullable: true, editable: true, defaultValue: null, length: 50, alias: Bedrooms, type: esriFieldTypeString )
• bathrooms ( modelName: bathrooms, nullable: true, editable: true, defaultValue: null, length: 50, alias: Bathrooms, type: esriFieldTypeString )
• residentialarea ( modelName: residentialarea, nullable: true, editable: true, defaultValue: null, alias: ResidentialArea, type: esriFieldTypeDouble )
• basementarea ( modelName: basementarea, nullable: true, editable: true, defaultValue: null, alias: BasementArea, type: esriFieldTypeInteger )
• minimalfinisharea ( modelName: minimalfinisharea, nullable: true, editable: true, defaultValue: null, alias: MinimalFinishArea, type: esriFieldTypeInteger )
• partitionfinisharea ( modelName: partitionfinisharea, nullable: true, editable: true, defaultValue: null, alias: PartitionFinishArea, type: esriFieldTypeInteger )
• garagetype ( modelName: garagetype, nullable: true, editable: true, defaultValue: null, length: 50, alias: GarageType, type: esriFieldTypeString )
• garagearea ( modelName: garagearea, nullable: true, editable: true, defaultValue: null, alias: GarageArea, type: esriFieldTypeInteger )
• carporttype ( modelName: carporttype, nullable: true, editable: true, defaultValue: null, length: 50, alias: CarportType, type: esriFieldTypeString )
• carportarea ( modelName: carportarea, nullable: true, editable: true, defaultValue: null, alias: CarportArea, type: esriFieldTypeInteger )
• landmrktvalueatsale ( modelName: landmrktvalueatsale, nullable: true, editable: true, defaultValue: null, alias: LandMrktValueAtSale, type: esriFieldTypeDouble )
• landusevalueatsale ( modelName: landusevalueatsale, nullable: true, editable: true, defaultValue: null, alias: LandUseValueAtSale, type: esriFieldTypeDouble )
• commercialvalueatsale ( modelName: commercialvalueatsale, nullable: true, editable: true, defaultValue: null, alias: CommercialValueAtSale, type: esriFieldTypeDouble )
• residentialvalueatsale ( modelName: residentialvalueatsale, nullable: true, editable: true, defaultValue: null, alias: ResidentialValueAtSale, type: esriFieldTypeDouble )
• basementvalue ( modelName: basementvalue, nullable: true, editable: true, defaultValue: null, alias: BasementValue, type: esriFieldTypeDouble )
• garagecarportvalue ( modelName: garagecarportvalue, nullable: true, editable: true, defaultValue: null, alias: GarageCarportValue, type: esriFieldTypeDouble )
• miscimplumpvalatsale ( modelName: miscimplumpvalatsale, nullable: true, editable: true, defaultValue: null, alias: MiscImpLumpValAtSale, type: esriFieldTypeDouble )
• siteimpvalueatsale ( modelName: siteimpvalueatsale, nullable: true, editable: true, defaultValue: null, alias: SiteImpValueAtSale, type: esriFieldTypeDouble )
• cropvalueatsale ( modelName: cropvalueatsale, nullable: true, editable: true, defaultValue: null, alias: CropValueAtSale, type: esriFieldTypeDouble )
• totalimpvalueatsale ( modelName: totalimpvalueatsale, nullable: true, editable: true, defaultValue: null, alias: TotalImpValueAtSale, type: esriFieldTypeDouble )
• apmrktvalue ( modelName: apmrktvalue, nullable: true, editable: true, defaultValue: null, alias: APMrktValue, type: esriFieldTypeDouble )
• previousestimate ( modelName: previousestimate, nullable: true, editable: true, defaultValue: null, alias: PreviousEstimate, type: esriFieldTypeDouble )
• apimprmrkt ( modelName: apimprmrkt, nullable: true, editable: true, defaultValue: null, alias: APImprMrkt, type: esriFieldTypeDouble )
• aplandmrkt ( modelName: aplandmrkt, nullable: true, editable: true, defaultValue: null, alias: APLandMrkt, type: esriFieldTypeDouble )
• aplanduse ( modelName: aplanduse, nullable: true, editable: true, defaultValue: null, alias: APLandUse, type: esriFieldTypeDouble )
• apcropmrkt ( modelName: apcropmrkt, nullable: true, editable: true, defaultValue: null, alias: APCropMrkt, type: esriFieldTypeDouble )
• newconstruction ( modelName: newconstruction, nullable: true, editable: true, defaultValue: null, alias: NewConstruction, type: esriFieldTypeDouble )
• districtcode ( modelName: districtcode, nullable: false, editable: true, defaultValue: null, length: 50, alias: DistrictCode, type: esriFieldTypeString )
• eventdate ( modelName: eventdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EventDate, type: esriFieldTypeDate )
• parentneighborhood ( modelName: parentneighborhood, nullable: true, editable: true, defaultValue: null, length: 50, alias: ParentNeighborhood, type: esriFieldTypeString )
• currentparentneighborhood ( modelName: currentparentneighborhood, nullable: true, editable: true, defaultValue: null, length: 50, alias: CurrentParentNeighborhood, type: esriFieldTypeString )
• physdepr ( modelName: physdepr, nullable: true, editable: true, defaultValue: null, alias: PhysDepr, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Parcel Sales
  Description:
  Prototype:
  aplandmrkt: null
  streetname: null
  grantee: null
  adjustedsaleprice: null
  localqual:
  basementvalue: null
  saledate: null
  currentneighborhood: null
  totalimpvalueatsale: null
  apimprmrkt: null
  districtcode:
  basementarea: null
  unimprovedsale:
  apmrktvalue: null
  zip: null
  parceltype:
  unittype: null
  minimalfinisharea: null
  primarylandtype: null
  landimprratio: 0
  apcropmrkt: null
  bathrooms: null
  mapnumber: null
  eventdate: null
  quality: null
  parentneighborhood: null
  bedrooms: null
  propertyclass: null
  condition: null
  partitionfinisharea: null
  siteimpvalueatsale: null
  rollyear: null
  housenumber: null
  district:
  carporttype: null
  residentialvalueatsale: null
  style: null
  acres: null
  neighborhood:
  cropvalueatsale: null
  currentuseacres: null
  parcels: null
  garagecarportvalue: null
  effectiveage: null
  currentparentneighborhood: null
  city: null
  deedtype: null
  originalsaleprice: 0
  recordingnumber: null
  salenote: null
  parcelnumber: null
  description: null
  imptype: null
  garagearea: null
  newconstruction: null
  grantor: null
  units: null
  carportarea: null
  reviewnote: null
  subdivision: null
  exciseaffidavit: null
  residentialarea: null
  secondarycode: null
  commercialstructures: null
  dflacres: null
  primaryimprovement: null
  statequal: null
  frontage: null
  physdepr: null
  landshape: null
  landmrktvalueatsale: null
  commercialarea: null
  garagetype: null
  exciselink: null
  saleagemo: null
  yearbuilt: null
  miscimplumpvalatsale: null
  permitssincesale: null
  previousestimate: null
  residentialstructures: null
  asratio: null
  commercialvalueatsale: null
  dorcode: null
  landusevalueatsale: null
  landacres: null
  aplanduse: null
  auditorlink: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata