Name: dbo.vw_MD_Current_Assessments

Display Field: ownername

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7d2002b42b4e4a0f9a80994ab62bd071

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: false
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• id ( type: esriFieldTypeDouble, alias: ID, editable: true, nullable: true, defaultValue: null, modelName: id )
• municipalityid ( type: esriFieldTypeDouble, alias: MunicipalityID, editable: true, nullable: true, defaultValue: null, modelName: municipalityid )
• parceltaxkey ( type: esriFieldTypeString, alias: ParcelTaxKey, editable: true, nullable: true, length: 40, defaultValue: null, modelName: parceltaxkey )
• streetnumber ( type: esriFieldTypeString, alias: StreetNumber, editable: true, nullable: true, length: 15, defaultValue: null, modelName: streetnumber )
• legalacres ( type: esriFieldTypeDouble, alias: LegalAcres, editable: true, nullable: true, defaultValue: null, modelName: legalacres )
• owneraddress1 ( type: esriFieldTypeString, alias: OwnerAddress1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: owneraddress1 )
• owneraddress2 ( type: esriFieldTypeString, alias: OwnerAddress2, editable: true, nullable: true, length: 30, defaultValue: null, modelName: owneraddress2 )
• ownerzip ( type: esriFieldTypeString, alias: OwnerZip, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ownerzip )
• traffic ( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 20, defaultValue: null, modelName: traffic )
• water ( type: esriFieldTypeString, alias: Water, editable: true, nullable: true, length: 20, defaultValue: null, modelName: water )
• sanitary ( type: esriFieldTypeString, alias: Sanitary, editable: true, nullable: true, length: 20, defaultValue: null, modelName: sanitary )
• ordertovisit ( type: esriFieldTypeInteger, alias: OrderToVisit, editable: true, nullable: true, defaultValue: null, modelName: ordertovisit )
• inspectedby ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: inspectedby )
• inspecteddate ( type: esriFieldTypeDate, alias: InspectedDate, editable: true, nullable: true, length: 29, defaultValue: null, modelName: inspecteddate )
• neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 30, defaultValue: null, modelName: neighborhood )
• neighborhoodgroup ( type: esriFieldTypeString, alias: NeighborhoodGroup, editable: true, nullable: true, length: 30, defaultValue: null, modelName: neighborhoodgroup )
• assessmentyear ( type: esriFieldTypeString, alias: AssessmentYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: assessmentyear )
• totalmarketvalueland ( type: esriFieldTypeInteger, alias: TotalMarketValueLand, editable: true, nullable: true, defaultValue: null, modelName: totalmarketvalueland )
• totalmarketvalueimprovements ( type: esriFieldTypeInteger, alias: TotalMarketValueImprovements, editable: true, nullable: true, defaultValue: null, modelName: totalmarketvalueimprovements )
• totalmarketvalue ( type: esriFieldTypeInteger, alias: TotalMarketValue, editable: true, nullable: true, defaultValue: null, modelName: totalmarketvalue )
• totalassessedvalueland ( type: esriFieldTypeInteger, alias: TotalAssessedValueLand, editable: true, nullable: true, defaultValue: null, modelName: totalassessedvalueland )
• totalassessedvalueimprovements ( type: esriFieldTypeInteger, alias: TotalAssessedValueImprovements, editable: true, nullable: true, defaultValue: null, modelName: totalassessedvalueimprovements )
• totalassessedvalue ( type: esriFieldTypeInteger, alias: TotalAssessedValue, editable: true, nullable: true, defaultValue: null, modelName: totalassessedvalue )
• totalimprovements ( type: esriFieldTypeSmallInteger, alias: TotalImprovements, editable: true, nullable: true, defaultValue: null, modelName: totalimprovements )
• unitnumber ( type: esriFieldTypeString, alias: UnitNumber, editable: true, nullable: true, length: 5, defaultValue: null, modelName: unitnumber )
• propertyaddress ( type: esriFieldTypeString, alias: PropertyAddress, editable: true, nullable: true, length: 50, defaultValue: null, modelName: propertyaddress )
• propertyaddresssortkey ( type: esriFieldTypeString, alias: PropertyAddressSortKey, editable: true, nullable: true, length: 42, defaultValue: null, modelName: propertyaddresssortkey )
• floodplain ( type: esriFieldTypeString, alias: FloodPlain, editable: true, nullable: true, length: 3, defaultValue: null, modelName: floodplain )
• hasland ( type: esriFieldTypeSmallInteger, alias: HasLand, editable: true, nullable: true, defaultValue: null, modelName: hasland )
• hasresidential ( type: esriFieldTypeSmallInteger, alias: HasResidential, editable: true, nullable: true, defaultValue: null, modelName: hasresidential )
• hasmobile ( type: esriFieldTypeSmallInteger, alias: HasMobile, editable: true, nullable: true, defaultValue: null, modelName: hasmobile )
• hascommercial ( type: esriFieldTypeSmallInteger, alias: HasCommercial, editable: true, nullable: true, defaultValue: null, modelName: hascommercial )
• hasincome ( type: esriFieldTypeSmallInteger, alias: HasIncome, editable: true, nullable: true, defaultValue: null, modelName: hasincome )
• hasobi ( type: esriFieldTypeSmallInteger, alias: HasOBI, editable: true, nullable: true, defaultValue: null, modelName: hasobi )
• hasmanual ( type: esriFieldTypeSmallInteger, alias: HasManual, editable: true, nullable: true, defaultValue: null, modelName: hasmanual )
• ownersortkey ( type: esriFieldTypeString, alias: OwnerSortKey, editable: true, nullable: true, length: 55, defaultValue: null, modelName: ownersortkey )
• ownername ( type: esriFieldTypeString, alias: OwnerName, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ownername )
• secondaryownername ( type: esriFieldTypeString, alias: SecondaryOwnerName, editable: true, nullable: true, length: 60, defaultValue: null, modelName: secondaryownername )
• ownercountry ( type: esriFieldTypeString, alias: OwnerCountry, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ownercountry )
• zoning ( type: esriFieldTypeString, alias: Zoning, editable: true, nullable: true, length: 20, defaultValue: null, modelName: zoning )
• ownercitystate ( type: esriFieldTypeString, alias: OwnerCityState, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ownercitystate )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: status )
• ownerdba ( type: esriFieldTypeString, alias: OwnerDBA, editable: true, nullable: true, length: 55, defaultValue: null, modelName: ownerdba )
• county ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 15, defaultValue: null, modelName: county )
• streetnumbersort ( type: esriFieldTypeString, alias: StreetNumberSort, editable: true, nullable: true, length: 22, defaultValue: null, modelName: streetnumbersort )
• lastbuildingpermitdate ( type: esriFieldTypeDate, alias: LastBuildingPermitDate, editable: true, nullable: true, length: 29, defaultValue: null, modelName: lastbuildingpermitdate )
• lastsaledate ( type: esriFieldTypeDate, alias: LastSaleDate, editable: true, nullable: true, length: 29, defaultValue: null, modelName: lastsaledate )
• obicount ( type: esriFieldTypeSmallInteger, alias: OBICount, editable: true, nullable: true, defaultValue: null, modelName: obicount )
• town ( type: esriFieldTypeString, alias: Town, editable: true, nullable: true, length: 3, defaultValue: null, modelName: town )
• range ( type: esriFieldTypeString, alias: Range, editable: true, nullable: true, length: 3, defaultValue: null, modelName: range )
• block ( type: esriFieldTypeSmallInteger, alias: Block, editable: true, nullable: true, defaultValue: null, modelName: block )
• lot ( type: esriFieldTypeSmallInteger, alias: Lot, editable: true, nullable: true, defaultValue: null, modelName: lot )
• section ( type: esriFieldTypeSmallInteger, alias: Section, editable: true, nullable: true, defaultValue: null, modelName: section )
• qsection ( type: esriFieldTypeString, alias: QSection, editable: true, nullable: true, length: 2, defaultValue: null, modelName: qsection )
• qqsection ( type: esriFieldTypeString, alias: QQSection, editable: true, nullable: true, length: 2, defaultValue: null, modelName: qqsection )
• esriuniqueid ( type: esriFieldTypeInteger, alias: ESRIUniqueID, editable: true, nullable: true, defaultValue: null, modelName: esriuniqueid )
• assignedto ( type: esriFieldTypeString, alias: AssignedTo, editable: true, nullable: true, length: 30, defaultValue: null, modelName: assignedto )
• predominanttaxclass ( type: esriFieldTypeString, alias: PredominantTaxClass, editable: true, nullable: true, length: 20, defaultValue: null, modelName: predominanttaxclass )
• plattedsubdivision ( type: esriFieldTypeString, alias: PlattedSubdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: plattedsubdivision )
• floodplaintype ( type: esriFieldTypeString, alias: FloodPlainType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: floodplaintype )
• streetname ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 25, defaultValue: null, modelName: streetname )
• legaldescription ( type: esriFieldTypeString, alias: LegalDescription, editable: true, nullable: true, length: 2147483647, defaultValue: null, modelName: legaldescription )
• ownersmailinglabel ( type: esriFieldTypeString, alias: OwnersMailingLabel, editable: true, nullable: true, length: 2147483647, defaultValue: null, modelName: ownersmailinglabel )
• propertytype ( type: esriFieldTypeString, alias: PropertyType, editable: true, nullable: true, length: 40, defaultValue: null, modelName: propertytype )
• propertytypenumber ( type: esriFieldTypeSmallInteger, alias: PropertyTypeNumber, editable: true, nullable: true, defaultValue: null, modelName: propertytypenumber )
• taxkeynumber ( type: esriFieldTypeString, alias: TaxKeyNumber, editable: true, nullable: true, length: 40, defaultValue: null, modelName: taxkeynumber )
• compressedtaxkeynumber ( type: esriFieldTypeString, alias: CompressedTaxKeyNumber, editable: true, nullable: true, length: 40, defaultValue: null, modelName: compressedtaxkeynumber )
• maplink ( type: esriFieldTypeString, alias: MapLink, editable: true, nullable: true, length: 130, defaultValue: null, modelName: maplink )
• esri_oid ( type: esriFieldTypeOID, alias: ESRI_OID, nullable: false, defaultValue: null, modelName: esri_oid, editable: false )

Templates:

• Name: dbo.vw_MD_Current_Assessments
  Description:
  Prototype:
  maplink: null
  id: null
  municipalityid: null
  parceltaxkey: null
  streetnumber: null
  legalacres: null
  owneraddress1: null
  owneraddress2: null
  ownerzip: null
  traffic: null
  water: null
  sanitary: null
  ordertovisit: null
  inspectedby: null
  inspecteddate: null
  neighborhood: null
  neighborhoodgroup: null
  assessmentyear: null
  totalmarketvalueland: null
  totalmarketvalueimprovements: null
  totalmarketvalue: null
  totalassessedvalueland: null
  totalassessedvalueimprovements: null
  totalassessedvalue: null
  totalimprovements: null
  unitnumber: null
  propertyaddress: null
  propertyaddresssortkey: null
  floodplain: null
  hasland: null
  hasresidential: null
  hasmobile: null
  hascommercial: null
  hasincome: null
  hasobi: null
  hasmanual: null
  ownersortkey: null
  ownername: null
  secondaryownername: null
  ownercountry: null
  zoning: null
  ownercitystate: null
  status: null
  ownerdba: null
  county: null
  streetnumbersort: null
  lastbuildingpermitdate: null
  lastsaledate: null
  obicount: null
  town: null
  range: null
  block: null
  lot: null
  section: null
  qsection: null
  qqsection: null
  esriuniqueid: null
  assignedto: null
  predominanttaxclass: null
  plattedsubdivision: null
  floodplaintype: null
  streetname: null
  legaldescription: null
  ownersmailinglabel: null
  propertytype: null
  propertytypenumber: null
  taxkeynumber: null
  compressedtaxkeynumber: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata