Name: Sales

Display Field: LSN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1513977.102273941
YMin: 567287.3413403481
XMax: 1645498.6607526094
YMax: 677203.7238693535
Spatial Reference: 3754  (3754)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PARID ( type: esriFieldTypeString, alias: PARCEL ID, length: 18 )
• SQ_FT ( type: esriFieldTypeInteger, alias: SQ FT )
• RMTOT ( type: esriFieldTypeSmallInteger, alias: ROOM TOTALS )
• RMBED ( type: esriFieldTypeSmallInteger, alias: BEDROOMS )
• RMFAM ( type: esriFieldTypeSmallInteger, alias: FAMILY ROOMS )
• FIXBATH ( type: esriFieldTypeSmallInteger, alias: FULL BATHS )
• FIXHALF ( type: esriFieldTypeSmallInteger, alias: HALF BATHS )
• FIREPLCE ( type: esriFieldTypeSmallInteger, alias: FIREPLACES )
• YRBLT ( type: esriFieldTypeSmallInteger, alias: YEAR BUILT )
• STYLE ( type: esriFieldTypeString, alias: STYLE, length: 20 )
• CONSTR ( type: esriFieldTypeString, alias: CONSTRUCTION, length: 20 )
• BASEMENT ( type: esriFieldTypeString, alias: BASEMENT, length: 20 )
• HEATING ( type: esriFieldTypeString, alias: HEATING, length: 25 )
• HEATFUEL ( type: esriFieldTypeString, alias: HEAT FUEL, length: 10 )
• CDU ( type: esriFieldTypeString, alias: CDU, length: 15 )
• CDPCT ( type: esriFieldTypeSmallInteger, alias: CD PCT )
• GRADE ( type: esriFieldTypeString, alias: GRADE, length: 2 )
• GRDFACT ( type: esriFieldTypeDouble, alias: GRADE FACTORS )
• MKTADJ ( type: esriFieldTypeSmallInteger, alias: MARKET ADJUSTMENT )
• FINBSMTAREA ( type: esriFieldTypeInteger, alias: FINISHED BASEMENT AREA )
• STORIES ( type: esriFieldTypeDouble, alias: STORIES )
• ADRNO ( type: esriFieldTypeString, alias: ADDRESS NUMBER, length: 10 )
• ADRADD ( type: esriFieldTypeString, alias: ADDITIONAL ADDRESS, length: 10 )
• ADRDIR ( type: esriFieldTypeString, alias: ADDRESS DIRECTION, length: 2 )
• ADRSTR ( type: esriFieldTypeString, alias: ADDRESS STREET, length: 50 )
• OWN1 ( type: esriFieldTypeString, alias: OWNER NAME, length: 30 )
• OWN2 ( type: esriFieldTypeString, alias: ADDITIONAL OWNER, length: 30 )
• OWNNUM ( type: esriFieldTypeString, alias: OWNER NUMBER, length: 6 )
• MAIL1 ( type: esriFieldTypeString, alias: MAIL 1, length: 30 )
• MAIL2 ( type: esriFieldTypeString, alias: MAIL 2, length: 30 )
• MADDR1 ( type: esriFieldTypeString, alias: TAX MAILING ADDRESS, length: 30 )
• MADDR3 ( type: esriFieldTypeString, alias: TAX MAILING ADDRESS CONT., length: 30 )
• LEGAL1 ( type: esriFieldTypeString, alias: LEGAL DESCRIPTION 1, length: 60 )
• LEGAL2 ( type: esriFieldTypeString, alias: LEGAL DESCRIPTION 2, length: 60 )
• LEGAL3 ( type: esriFieldTypeString, alias: LEGAL DESCRIPTION 3, length: 60 )
• ACRES ( type: esriFieldTypeDouble, alias: ACRES )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• APRLAND ( type: esriFieldTypeDouble, alias: APPRAISED LAND )
• APRBLDG ( type: esriFieldTypeDouble, alias: APPRAISED BUILDING )
• APRTOT ( type: esriFieldTypeDouble, alias: APPRAISED TOTAL )
• ASDLAND ( type: esriFieldTypeDouble, alias: ASSESED LAND )
• ASDBLDG ( type: esriFieldTypeDouble, alias: ASSESED BUILDING )
• ASDTOT ( type: esriFieldTypeDouble, alias: ASSESED TOTAL )
• TAXES ( type: esriFieldTypeDouble, alias: TAXES )
• TAXES_DUE ( type: esriFieldTypeDouble, alias: TAXES DUE )
• SALETYPE ( type: esriFieldTypeString, alias: SALE TYPE, length: 20 )
• SALEPRCE ( type: esriFieldTypeDouble, alias: SALE PRICE )
• SALEDATE ( type: esriFieldTypeDate, alias: SALE DATE, length: 8 )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 20 )
• LAND_USE ( type: esriFieldTypeString, alias: LAND USE, length: 4 )
• ADRSUF ( type: esriFieldTypeString, alias: ADRESS SUFFIX, length: 8 )
• NBHD ( type: esriFieldTypeString, alias: NEIGHBORHOOD CODE, length: 8 )
• ADDRESS_FULL ( type: esriFieldTypeString, alias: PROPERTY ADDRESS, length: 82 )
• LSN ( type: esriFieldTypeString, alias: FULL STREET ADDRESS, length: 125 )
• ALSN ( type: esriFieldTypeString, alias: ALTERNATE FULL ADDRESS, length: 125 )
• LHN ( type: esriFieldTypeString, alias: HOUSE NUMBER WITH UNIT, length: 16 )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, length: 10 , Coded Values: [43128: 43128] , [43153: 43153] , [45068: 45068] , ...23 more... )
• USPS_CITY ( type: esriFieldTypeString, alias: USPS CITY, length: 50 , Coded Values: [ALPHA: ALPHA] , [BELLBROOK: BELLBROOK] , [BOWERSVILLE: BOWERSVILLE] , ...16 more... )
• COMM ( type: esriFieldTypeString, alias: COMMUNITY, length: 50 , Coded Values: [BATH TWP: BATH TWP] , [BEAVERCREEK: BEAVERCREEK] , [BEAVERCREEK TWP: BEAVERCREEK TWP] , ...26 more... )
• BOR_taxyr ( type: esriFieldTypeSmallInteger, alias: TAX YEAR )
• BOR_parid ( type: esriFieldTypeString, alias: PARCEL ID, length: 18 )
• BOR_bornum ( type: esriFieldTypeString, alias: BOR NUMBER, length: 15 )
• BOR_seq ( type: esriFieldTypeSmallInteger, alias: SEQUENCE )
• BOR_cname ( type: esriFieldTypeString, alias: COMPLAINTANT, length: 60 )
• BOR_cmaddr1 ( type: esriFieldTypeString, alias: COMPLAINTANT ADDRESS 1, length: 40 )
• BOR_cmaddr2 ( type: esriFieldTypeString, alias: COMPLAINTANT ADDRESS 2, length: 40 )
• BOR_cmcity ( type: esriFieldTypeString, alias: COMPLAINTANT CITY, length: 30 )
• BOR_cmstate ( type: esriFieldTypeString, alias: COMPLAINTANT STATE, length: 2 )
• BOR_cmzip ( type: esriFieldTypeString, alias: COMPLAINTANT ZIPCODE, length: 10 )
• BOR_aname ( type: esriFieldTypeString, alias: ATTORNEY, length: 60 )
• BOR_amaddr1 ( type: esriFieldTypeString, alias: ATTORNEY ADDRESS 1, length: 40 )
• BOR_amaddr2 ( type: esriFieldTypeString, alias: ATTORNEY ADDRESS 2, length: 40 )
• BOR_amcity ( type: esriFieldTypeString, alias: ATTORNEY CITY, length: 30 )
• BOR_amstate ( type: esriFieldTypeString, alias: ATTORNEY STATE, length: 2 )
• BOR_amzip ( type: esriFieldTypeString, alias: ATTORNEY ZIPCODE, length: 10 )
• BOR_cvalue ( type: esriFieldTypeDouble, alias: COMPLAINTANT VALUE )
• BOR_audland ( type: esriFieldTypeDouble, alias: AUDITOR LAND )
• BOR_audbldg ( type: esriFieldTypeDouble, alias: AUDITOR BUILDING )
• BOR_preland ( type: esriFieldTypeDouble, alias: PREVALUE LAND )
• BOR_prebldg ( type: esriFieldTypeDouble, alias: PREVALUE BUILDING )
• BOR_prereason ( type: esriFieldTypeString, alias: PREVALUE REASON, length: 100 )
• BOR_preresult ( type: esriFieldTypeString, alias: PREVALUE RESULT, length: 10 )
• BOR_hearingtime ( type: esriFieldTypeDate, alias: HEARING TIME, length: 8 )
• BOR_borland ( type: esriFieldTypeDouble, alias: BOR LAND )
• BOR_borbldg ( type: esriFieldTypeDouble, alias: BOR BUILDING )
• BOR_borreason ( type: esriFieldTypeString, alias: BOR REASON, length: 100 )
• BOR_borstatus ( type: esriFieldTypeString, alias: BOR STATUS, length: 25 )
• BOR_notes ( type: esriFieldTypeString, alias: NOTES, length: 1000 )
• BOR_orgchg ( type: esriFieldTypeDouble, alias: ORIGINAL CHARGE )
• BOR_redchg ( type: esriFieldTypeDouble, alias: REDUCTION CHANGE )
• BOR_adjchg ( type: esriFieldTypeDouble, alias: ADJUSTMENT CHANGE )
• BOR_rlbchg ( type: esriFieldTypeDouble, alias: RESULT BUILDING CHANGE )
• BOR_hrbchg ( type: esriFieldTypeDouble, alias: HRB CHANGE )
• BOR_oname ( type: esriFieldTypeString, alias: OWNER NAME, length: 60 )
• BOR_omaddr1 ( type: esriFieldTypeString, alias: OWNER MAILING ADDRESS 1, length: 40 )
• BOR_omaddr2 ( type: esriFieldTypeString, alias: OWNER MAILING ADDRESS 2, length: 40 )
• BOR_omcity ( type: esriFieldTypeString, alias: OWNER CITY, length: 30 )
• BOR_omstate ( type: esriFieldTypeString, alias: OWNER STATE, length: 2 )
• BOR_omzip ( type: esriFieldTypeString, alias: OWNER ZIPCODE, length: 10 )
• BOR_appicn ( type: esriFieldTypeInteger, alias: APPLICATION ICN )
• BOR_APPLNOTES ( type: esriFieldTypeString, alias: APPLICATION NOTES, length: 2000 )
• BOR_CRELATIONSHIP ( type: esriFieldTypeString, alias: CRELATIONSHIP, length: 40 )
• BOR_PROPERTYUSE ( type: esriFieldTypeString, alias: PROPERTY USE, length: 100 )
• BOR_SOLD ( type: esriFieldTypeString, alias: SOLD, length: 1 )
• BOR_SALEPRICE ( type: esriFieldTypeDouble, alias: SALE PRICE )
• BOR_IMPRCOST ( type: esriFieldTypeDouble, alias: IMPROVEMENT COST )
• BOR_APPRAISER ( type: esriFieldTypeString, alias: APPRAISER, length: 1 )
• BOR_ARMSLENGTH ( type: esriFieldTypeString, alias: ARMS LENGTH, length: 1 )
• BOR_LOSTVALUE ( type: esriFieldTypeString, alias: LOST VALUE, length: 1 )
• BOR_IMPROVEMENT ( type: esriFieldTypeString, alias: IMPROVEMENT, length: 1 )
• BOR_OCCUPANCY ( type: esriFieldTypeString, alias: OCCUPANCY, length: 1 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• BOR_ccaemail ( type: esriFieldTypeString, alias: ATTORNEY EMAIL CC, length: 40 )
• ROADTYPE ( type: esriFieldTypeString, alias: ROADTYPE, length: 4 , Coded Values: [B: BIKE PATH] , [C: COUNTY] , [D: WPAFB] , ...8 more... )
• ROADNUMBER ( type: esriFieldTypeString, alias: ROADNUMBER, length: 20 )
• HOUSENUM ( type: esriFieldTypeDouble, alias: HOUSENUM )
• UNITNUM ( type: esriFieldTypeString, alias: UNITNUM, length: 12 )
• HNRANGE ( type: esriFieldTypeString, alias: HNRANGE, length: 32 )
• UNITEXTRA ( type: esriFieldTypeString, alias: UNITEXTRA, length: 64 )
• BUILDING ( type: esriFieldTypeString, alias: BUILDING, length: 16 )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, length: 8 )
• ST_PREFIX ( type: esriFieldTypeString, alias: ST_PREFIX, length: 4 , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, length: 75 )
• ST_TYPE ( type: esriFieldTypeString, alias: ST_TYPE, length: 16 , Coded Values: [ALY: ALY] , [AVE: AVE] , [BLVD: BLVD] , ...26 more... )
• ST_SUFFIX ( type: esriFieldTypeString, alias: ST_SUFFIX, length: 4 , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ST_SUFFIX2 ( type: esriFieldTypeString, alias: ST_SUFFIX2, length: 10 )
• MUNI ( type: esriFieldTypeString, alias: MUNI, length: 50 , Coded Values: [BEAVERCREEK: BEAVERCREEK] , [BELLBROOK: BELLBROOK] , [BOWERSVILLE: BOWERSVILLE] , ...11 more... )
• ALTPREFIX ( type: esriFieldTypeString, alias: ALTPREFIX, length: 10 , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ALTNAME ( type: esriFieldTypeString, alias: ALTNAME, length: 75 )
• ALTTYPE ( type: esriFieldTypeString, alias: ALTTYPE, length: 20 , Coded Values: [ALY: ALY] , [AVE: AVE] , [BLVD: BLVD] , ...24 more... )
• ALTSUFFIX ( type: esriFieldTypeString, alias: ALTSUFFIX, length: 10 , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• ALTSUFFIX2 ( type: esriFieldTypeString, alias: ALTSUFFIX2, length: 10 )
• SUBDIV ( type: esriFieldTypeString, alias: SUBDIV, length: 50 )
• VILLAGE ( type: esriFieldTypeString, alias: VILLAGE, length: 50 )
• SIDE ( type: esriFieldTypeDouble, alias: SIDE , Coded Values: [0: LEFT] , [1: RIGHT] )
• ABSSIDE ( type: esriFieldTypeString, alias: ABSSIDE, length: 2 , Coded Values: [E: EAST] , [N: NORTH] , [S: SOUTH] , ...1 more... )
• STRUC_TYPE ( type: esriFieldTypeDouble, alias: STRUC_TYPE , Coded Values: [1: HOUSE] , [2: DUPLEX] , [3: TRAILER] , ...8 more... )
• SOURCE ( type: esriFieldTypeDouble, alias: SOURCE , Coded Values: [0: FIELD VERIFIED] , [1: NOT FIELD VERIFIED] , [2: BEAVERCREEK] , ...5 more... )
• INVERSE ( type: esriFieldTypeString, alias: INVERSE, length: 6 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 60 )
• COORDINATE ( type: esriFieldTypeDouble, alias: COORDINATE )
• DGPSX ( type: esriFieldTypeDouble, alias: DGPSX )
• DGPSY ( type: esriFieldTypeDouble, alias: DGPSY )
• DGPSZ ( type: esriFieldTypeDouble, alias: DGPSZ )
• DGPSQUALIT ( type: esriFieldTypeDouble, alias: DGPSQUALIT )
• FIELDNOTE ( type: esriFieldTypeString, alias: FIELDNOTE, length: 100 )
• GPSSECOND ( type: esriFieldTypeDouble, alias: GPSSECOND )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 2 , Coded Values: [OH: OH] )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 24 , Coded Values: [CLA: CLA] , [GRE: GRE] , [MOT: MOT] )
• QCFLAG ( type: esriFieldTypeDouble, alias: QCFLAG , Coded Values: [0: NO ERROR] , [1: ERROR] , [2: ERROR RANGE] )
• HOUSESUF ( type: esriFieldTypeString, alias: HOUSESUF, length: 12 )
• SALES_PARID ( type: esriFieldTypeString, alias: SALES_PARID, length: 30 )
• SALES_PRICE ( type: esriFieldTypeDouble, alias: SALES_PRICE )
• SALES_SALEKEY ( type: esriFieldTypeInteger, alias: SALES_SALEKEY )
• SALES_SOURCE ( type: esriFieldTypeString, alias: SALES_SOURCE, length: 1 )
• SALES_SALETYPE ( type: esriFieldTypeString, alias: SALES_SALETYPE, length: 1 )
• SALES_SALEVAL ( type: esriFieldTypeString, alias: SALES_SALEVAL, length: 2 )
• SALES_TRANSNO ( type: esriFieldTypeString, alias: SALES_TRANSNO, length: 20 )
• SALES_NEWYR ( type: esriFieldTypeSmallInteger, alias: SALES_NEWYR )
• BOR_icn ( type: esriFieldTypeInteger, alias: BOR_icn )
• FORECLOSURES_ICN ( type: esriFieldTypeInteger, alias: FORECLOSURES_ICN )
• FORECLOSURES_POST_TYPE ( type: esriFieldTypeString, alias: FORECLOSURES_POST_TYPE, length: 1 )
• FORECLOSURES_SALE_DATE ( type: esriFieldTypeDate, alias: FORECLOSURES_SALE_DATE, length: 8 )
• FORECLOSURES_CASE_NO ( type: esriFieldTypeString, alias: FORECLOSURES_CASE_NO, length: 15 )
• FORECLOSURES_ADDRESS ( type: esriFieldTypeString, alias: FORECLOSURES_ADDRESS, length: 50 )
• FORECLOSURES_CITY ( type: esriFieldTypeString, alias: FORECLOSURES_CITY, length: 50 )
• FORECLOSURES_PARCEL_NO ( type: esriFieldTypeString, alias: FORECLOSURES_PARCEL_NO, length: 18 )
• FORECLOSURES_APPRAISAL ( type: esriFieldTypeDouble, alias: FORECLOSURES_APPRAISAL )
• FORECLOSURES_JUDGEMENT ( type: esriFieldTypeDouble, alias: FORECLOSURES_JUDGEMENT )
• FORECLOSURES_ATTORNEY ( type: esriFieldTypeString, alias: FORECLOSURES_ATTORNEY, length: 50 )
• FORECLOSURES_ATTORNEY_PHONE ( type: esriFieldTypeString, alias: FORECLOSURES_ATTORNEY_PHONE, length: 12 )
• FORECLOSURES_STATUS ( type: esriFieldTypeString, alias: FORECLOSURES_STATUS, length: 1 )
• FORECLOSURES_SALE_PRICE ( type: esriFieldTypeDouble, alias: FORECLOSURES_SALE_PRICE )
• FORECLOSURES_PURCHASER ( type: esriFieldTypeString, alias: FORECLOSURES_PURCHASER, length: 50 )
• FORECLOSURES_NOTES ( type: esriFieldTypeString, alias: FORECLOSURES_NOTES, length: 200 )
• FORECLOSURES_SALE_DATE2 ( type: esriFieldTypeDate, alias: FORECLOSURES_SALE_DATE2, length: 8 )
• FORECLOSURES_STATUS2 ( type: esriFieldTypeString, alias: FORECLOSURES_STATUS2, length: 1 )
• FORECLOSURES_DEPOSIT ( type: esriFieldTypeDouble, alias: FORECLOSURES_DEPOSIT )
• FORECLOSURES_OPENINGBID ( type: esriFieldTypeDouble, alias: FORECLOSURES_OPENINGBID )
• FORECLOSURES_SALETYPE ( type: esriFieldTypeString, alias: FORECLOSURES_SALETYPE, length: 40 )
• FORECLOSURES_FCTYPE ( type: esriFieldTypeString, alias: FORECLOSURES_FCTYPE, length: 40 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata