Name: Real Estate Data no Duplicates

Display Field: Street_Name

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
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:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• PIN ( type: esriFieldTypeString , alias: PIN , editable: true , nullable: true , length: 26 )
• CAD_1 ( type: esriFieldTypeString , alias: CAD_1 , editable: true , nullable: true , length: 6 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• Street_Address_List ( type: esriFieldTypeString , alias: Street_Address_List , editable: true , nullable: true , length: 6 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• DiscrpAgID ( type: esriFieldTypeString , alias: DiscrpAgID , editable: true , nullable: true , length: 20 )
• UID ( type: esriFieldTypeString , alias: UID , editable: true , nullable: true , length: 12 )
• UID_NUM ( type: esriFieldTypeInteger , alias: UID_NUM , editable: true , nullable: true )
• ID_Type ( type: esriFieldTypeString , alias: ID_Type , editable: true , nullable: true , length: 35 , Coded Values: [Address Only: Address Only] , [Created for CAD: Created for CAD] , [Parcel - GIS Only: Parcel - GIS Only] , ...3 more... )
• ID_Description ( type: esriFieldTypeString , alias: ID_Description , editable: true , nullable: true , length: 75 , Coded Values: [Apartment CA: Apartment CA] , [Apartment Numbers: Apartment Numbers] , [Assisted Living: Assisted Living] , ...37 more... )
• MultiPartPolygon ( type: esriFieldTypeString , alias: MultiPartPolygon , editable: true , nullable: true , length: 12 , Coded Values: [No: No] , [Yes - Parent: Yes - Parent] , [Yes - Child: Yes - Child] )
• Date_Mapped ( type: esriFieldTypeDate , alias: Date_Mapped , editable: true , nullable: true , length: 8 )
• GIS_Comments ( type: esriFieldTypeString , alias: GIS_Comments , editable: true , nullable: true , length: 175 )
• Plat ( type: esriFieldTypeString , alias: Plat , editable: true , nullable: true , length: 20 )
• PIN_1 ( type: esriFieldTypeString , alias: PIN , editable: true , nullable: true , length: 26 )
• REA_LABEL ( type: esriFieldTypeString , alias: REA_LABEL , editable: true , nullable: true , length: 8 )
• ADDR ( type: esriFieldTypeString , alias: ADDR , editable: true , nullable: true , length: 15 )
• ADDR_SUF ( type: esriFieldTypeString , alias: ADDR_SUF , editable: true , nullable: true , length: 6 )
• ADDR_NUM ( type: esriFieldTypeString , alias: ADDR_NUM , editable: true , nullable: true , length: 8 )
• ADDR_LABEL ( type: esriFieldTypeString , alias: ADDR_LABEL , editable: true , nullable: true , length: 12 )
• ADDR_TYPE ( type: esriFieldTypeString , alias: ADDR_TYPE , editable: true , nullable: true , length: 30 , Coded Values: [Address: Address] , [Address with Apt: Address with Apt] , [Address with Unit: Address with Unit] , ...3 more... )
• PRE_DIR ( type: esriFieldTypeString , alias: PRE_DIR , editable: true , nullable: true , length: 6 , Coded Values: [W: West] , [E: East] , [S: South] , ...1 more... )
• PLAINST ( type: esriFieldTypeString , alias: PLAINST , editable: true , nullable: true , length: 50 )
• STREETTYPE ( type: esriFieldTypeString , alias: STREETTYPE , editable: true , nullable: true , length: 15 , Coded Values: [ALY: Alley] , [ANX: Annex] , [ARC: Arcade] , ...199 more... )
• SUF_DIR ( type: esriFieldTypeString , alias: SUF_DIR , editable: true , nullable: true , length: 6 , Coded Values: [W: West] , [E: East] , [S: South] , ...1 more... )
• APT ( type: esriFieldTypeString , alias: APT , editable: true , nullable: true , length: 6 )
• APT_911 ( type: esriFieldTypeString , alias: APT_911 , editable: true , nullable: true , length: 8 )
• NG_911 ( type: esriFieldTypeString , alias: NG_911 , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• Street_Name ( type: esriFieldTypeString , alias: Street_Name , editable: true , nullable: true , length: 75 )
• Full_Address ( type: esriFieldTypeString , alias: Full_Address , editable: true , nullable: true , length: 100 )
• City ( type: esriFieldTypeString , alias: City , editable: true , nullable: true , length: 20 , Coded Values: [Williamsburg: Williamsburg] , [Toano: Toano] , [Lanexa: Lanexa] , ...14 more... )
• State ( type: esriFieldTypeString , alias: State , editable: true , nullable: true , length: 5 )
• Zip_Code ( type: esriFieldTypeString , alias: Zip_Code , editable: true , nullable: true , length: 10 , Coded Values: [23185: 23185] , [23188: 23188] , [23168: 23168] , ...22 more... )
• Country ( type: esriFieldTypeString , alias: Country , editable: true , nullable: true , length: 5 )
• Locality ( type: esriFieldTypeString , alias: Locality , editable: true , nullable: true , length: 10 , Coded Values: [BHM: Barhamsville] , [CHAR: Charles City] , [JAMC: James City] , ...9 more... )
• CITYL ( type: esriFieldTypeString , alias: CITYL , editable: true , nullable: true , length: 10 , Coded Values: [BHM: Barhamsville] , [CHAR: Charles City] , [JAMC: James City] , ...9 more... )
• SUBNAME ( type: esriFieldTypeString , alias: SUBNAME , editable: true , nullable: true , length: 40 , Coded Values: [2 Rivers Apt Homes: 2 Rivers Apt Homes] , [5 Lots on Chickahominy Rd: 5 Lots on Chickahominy Rd] , [Acreage Lots Berkeley: Acreage Lots Berkeley] , ...438 more... )
• BUSNAME ( type: esriFieldTypeString , alias: BUSNAME , editable: true , nullable: true , length: 40 )
• Fire_MapBook ( type: esriFieldTypeString , alias: Fire_MapBook , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• Recycle_Day ( type: esriFieldTypeString , alias: Recycle_Day , editable: true , nullable: true , length: 20 )
• Recycle_Week ( type: esriFieldTypeString , alias: Recycle_Week , editable: true , nullable: true , length: 5 )
• Recycle_Route ( type: esriFieldTypeInteger , alias: Recycle_Route , editable: true , nullable: true )
• Code ( type: esriFieldTypeString , alias: Code , editable: true , nullable: true , length: 35 )
• NameWithheld ( type: esriFieldTypeString , alias: NameWithheld , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• Zoning ( type: esriFieldTypeString , alias: Zoning , editable: true , nullable: true , length: 75 , Coded Values: [A1 General Agriculture: A1 General Agriculture] , [A1SR General Agriculture Scenic Road: A1SR Limited General Agriculture Scenic Road] , [B1 General Business: B1 General Business] , ...22 more... )
• Primary_Zone ( type: esriFieldTypeString , alias: Primary_Zone , editable: true , nullable: true , length: 8 , Coded Values: [A1: A1] , [A1SR: A1SR] , [B1: B1] , ...22 more... )
• Zoning_2 ( type: esriFieldTypeString , alias: Zoning_2 , editable: true , nullable: true , length: 35 , Coded Values: [A1: A1] , [A1SR: A1SR] , [B1: B1] , ...22 more... )
• Air_Approach ( type: esriFieldTypeString , alias: Air_Approach , editable: true , nullable: true , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• ELEMENTARY ( type: esriFieldTypeString , alias: ELEMENTARY , editable: true , nullable: true , length: 20 )
• MIDDLE ( type: esriFieldTypeString , alias: MIDDLE , editable: true , nullable: true , length: 20 )
• HIGH ( type: esriFieldTypeString , alias: HIGH , editable: true , nullable: true , length: 25 )
• ELEC_DIST ( type: esriFieldTypeString , alias: ELEC_DIST , editable: true , nullable: true , length: 25 , Coded Values: [Berkeley: Berkeley] , [Jamestown: Jamestown] , [Powhatan: Powhatan] , ...2 more... )
• PRECINCT ( type: esriFieldTypeString , alias: PRECINCT , editable: true , nullable: true , length: 25 , Coded Values: [Berkeley A: Berkeley A] , [Berkeley B: Berkeley B] , [Berkeley C: Berkeley C] , ...16 more... )
• POLL ( type: esriFieldTypeString , alias: POLL , editable: true , nullable: true , length: 40 , Coded Values: [Jamestown High School: Jamestown High School] , [Clara Byrd Baker Elementary School: Clara Byrd Baker Elementary School] , [Matoaka Elementary School: Matoaka Elementary School] , ...15 more... )
• Census_Tr ( type: esriFieldTypeString , alias: Census_Tr , editable: true , nullable: true , length: 10 )
• State_Senate ( type: esriFieldTypeString , alias: State_Senate , editable: true , nullable: true , length: 5 )
• State_House ( type: esriFieldTypeString , alias: State_House , editable: true , nullable: true , length: 5 )
• Congress ( type: esriFieldTypeString , alias: Congress , editable: true , nullable: true , length: 5 )
• DamageZones ( type: esriFieldTypeSmallInteger , alias: DamageZones , editable: true , nullable: true )
• PSA ( type: esriFieldTypeString , alias: PSA , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Y/N: Y/N] )
• Rain_Gauge ( type: esriFieldTypeString , alias: JCSA Rain Gauge Zones , editable: true , nullable: true , length: 12 )
• PAZ ( type: esriFieldTypeString , alias: PAZ , editable: true , nullable: true , length: 25 )
• POINT_X ( type: esriFieldTypeDouble , alias: POINT_X , editable: true , nullable: true )
• POINT_Y ( type: esriFieldTypeDouble , alias: POINT_Y , editable: true , nullable: true )
• Creator ( type: esriFieldTypeString , alias: Creator , editable: true , nullable: true , length: 15 )
• Creator_Date ( type: esriFieldTypeDate , alias: Creator_Date , editable: true , nullable: true , length: 8 )
• Editor ( type: esriFieldTypeString , alias: Editor , editable: true , nullable: true , length: 15 )
• Editor_Date ( type: esriFieldTypeDate , alias: Editor_Date , editable: true , nullable: true , length: 8 )
• UID_NG911 ( type: esriFieldTypeString , alias: UID_NG911 , editable: true , nullable: true , length: 75 )
• Comp_Plan ( type: esriFieldTypeString , alias: Comp_Plan , editable: true , nullable: true , length: 120 , Coded Values: [Reservoir: Reservoir] , [Rural Lands: Rural Lands] , [Low Density Residential: Low Density Residential] , ...11 more... )
• rownumber ( type: esriFieldTypeDouble , alias: rownumber , editable: true , nullable: true )
• ObjectId_1 ( type: esriFieldTypeInteger , alias: ObjectId , editable: true , nullable: true )
• PIN_12 ( type: esriFieldTypeString , alias: PIN , editable: true , nullable: true , length: 26 )
• lrsn ( type: esriFieldTypeInteger , alias: lrsn , editable: true , nullable: true )
• LRSNum ( type: esriFieldTypeString , alias: LRSNum , editable: true , nullable: true , length: 10 )
• PropExt ( type: esriFieldTypeString , alias: PropExt , editable: true , nullable: true , length: 3 )
• DistNum ( type: esriFieldTypeString , alias: DistNum , editable: true , nullable: true , length: 6 )
• Public_NeiNum ( type: esriFieldTypeInteger , alias: Public_NeiNum , editable: true , nullable: true )
• NeiNum_name ( type: esriFieldTypeString , alias: NeiNum_name , editable: true , nullable: true , length: 75 )
• AZ ( type: esriFieldTypeString , alias: AZ , editable: true , nullable: true , length: 5 )
• PropClas ( type: esriFieldTypeInteger , alias: PropClas , editable: true , nullable: true )
• PCDesc ( type: esriFieldTypeString , alias: PCDesc , editable: true , nullable: true , length: 30 )
• LocAddr ( type: esriFieldTypeString , alias: LocAddr , editable: true , nullable: true , length: 64 )
• LocCity ( type: esriFieldTypeString , alias: LocCity , editable: true , nullable: true , length: 32 )
• LocState ( type: esriFieldTypeString , alias: LocState , editable: true , nullable: true , length: 2 )
• LocZip ( type: esriFieldTypeString , alias: LocZip , editable: true , nullable: true , length: 16 )
• Owner1 ( type: esriFieldTypeString , alias: Owner1 , editable: true , nullable: true , length: 64 )
• Owner2 ( type: esriFieldTypeString , alias: Owner2 , editable: true , nullable: true , length: 64 )
• MailAddr ( type: esriFieldTypeString , alias: MailAddr , editable: true , nullable: true , length: 64 )
• MailCity ( type: esriFieldTypeString , alias: MailCity , editable: true , nullable: true , length: 64 )
• MailStat ( type: esriFieldTypeString , alias: MailStat , editable: true , nullable: true , length: 4 )
• MailZip ( type: esriFieldTypeString , alias: MailZip , editable: true , nullable: true , length: 16 )
• TaxAcct ( type: esriFieldTypeString , alias: TaxAcct , editable: true , nullable: true , length: 8 )
• Legal1 ( type: esriFieldTypeString , alias: Legal1 , editable: true , nullable: true , length: 75 )
• Sale1D ( type: esriFieldTypeDate , alias: Sale1D , editable: true , nullable: true , length: 8 )
• Sale1Amt ( type: esriFieldTypeInteger , alias: Sale1Amt , editable: true , nullable: true )
• Doc1Num ( type: esriFieldTypeString , alias: Doc1Num , editable: true , nullable: true , length: 15 )
• Grantor1 ( type: esriFieldTypeString , alias: Grantor1 , editable: true , nullable: true , length: 40 )
• Sale2D ( type: esriFieldTypeDate , alias: Sale2D , editable: true , nullable: true , length: 8 )
• Sale2Amt ( type: esriFieldTypeInteger , alias: Sale2Amt , editable: true , nullable: true )
• Doc2Num ( type: esriFieldTypeString , alias: Doc2Num , editable: true , nullable: true , length: 15 )
• Grantor2 ( type: esriFieldTypeString , alias: Grantor2 , editable: true , nullable: true , length: 40 )
• Sale3D ( type: esriFieldTypeDate , alias: Sale3D , editable: true , nullable: true , length: 8 )
• Sale3Amt ( type: esriFieldTypeInteger , alias: Sale3Amt , editable: true , nullable: true )
• Doc3Num ( type: esriFieldTypeString , alias: Doc3Num , editable: true , nullable: true , length: 15 )
• Grantor3 ( type: esriFieldTypeString , alias: Grantor3 , editable: true , nullable: true , length: 40 )
• LandDesc1 ( type: esriFieldTypeString , alias: LandDesc1 , editable: true , nullable: true , length: 30 )
• Prev2Land ( type: esriFieldTypeInteger , alias: Prev2Land , editable: true , nullable: true )
• Prev2Imp ( type: esriFieldTypeInteger , alias: Prev2Imp , editable: true , nullable: true )
• Prev2Tot ( type: esriFieldTypeInteger , alias: Prev2Tot , editable: true , nullable: true )
• PrevLand ( type: esriFieldTypeInteger , alias: PrevLand , editable: true , nullable: true )
• PrevImp ( type: esriFieldTypeInteger , alias: PrevImp , editable: true , nullable: true )
• PrevTot ( type: esriFieldTypeInteger , alias: PrevTot , editable: true , nullable: true )
• CurLand ( type: esriFieldTypeInteger , alias: CurLand , editable: true , nullable: true )
• CurImp ( type: esriFieldTypeInteger , alias: CurImp , editable: true , nullable: true )
• CurTot ( type: esriFieldTypeInteger , alias: CurTot , editable: true , nullable: true )
• sdz ( type: esriFieldTypeString , alias: sdz , editable: true , nullable: true , length: 36 )
• PricePerAcre ( type: esriFieldTypeInteger , alias: PricePerAcre , editable: true , nullable: true )
• LegalAc ( type: esriFieldTypeDouble , alias: LegalAc , editable: true , nullable: true )
• OBJECTID_12 ( type: esriFieldTypeInteger , alias: OBJECTID , editable: true , nullable: true )
• PIN_12_13 ( type: esriFieldTypeString , alias: PIN , editable: true , nullable: true , length: 255 )
• PL_SubName ( type: esriFieldTypeString , alias: PL_SubName , editable: true , nullable: true , length: 255 )
• Ex_land_Us ( type: esriFieldTypeString , alias: Ex_land_Us , editable: true , nullable: true , length: 255 )
• Unit_Cap ( type: esriFieldTypeDouble , alias: Unit_Cap , editable: true , nullable: true )
• Improved ( type: esriFieldTypeString , alias: Improved , editable: true , nullable: true , length: 255 )
• Res_Units ( type: esriFieldTypeDouble , alias: Res_Units , editable: true , nullable: true )
• Housing_Ty ( type: esriFieldTypeString , alias: Housing_Ty , editable: true , nullable: true , length: 255 )
• Proffers ( type: esriFieldTypeString , alias: Proffers , editable: true , nullable: true , length: 255 )
• Shape_STArea__ ( type: esriFieldTypeDouble , alias: Shape_STArea__ , editable: true , nullable: false )
• Shape_STLength__ ( type: esriFieldTypeDouble , alias: Shape_STLength__ , editable: true , nullable: false )

Templates:

• Name: Real Estate Data no Duplicates
  Description:
  Prototype:
  Shape_STArea__: 0
  Shape_STLength__: 0
  PIN: null
  CAD_1: null
  Street_Address_List: null
  DiscrpAgID: null
  UID: null
  UID_NUM: null
  ID_Type: null
  ID_Description: null
  MultiPartPolygon: null
  Date_Mapped: null
  GIS_Comments: null
  Plat: null
  PIN_1: null
  REA_LABEL: null
  ADDR: null
  ADDR_SUF: null
  ADDR_NUM: null
  ADDR_LABEL: null
  ADDR_TYPE: null
  PRE_DIR: null
  PLAINST: null
  STREETTYPE: null
  SUF_DIR: null
  APT: null
  APT_911: null
  NG_911: null
  Street_Name: null
  Full_Address: null
  City: null
  State: null
  Zip_Code: null
  Country: null
  Locality: null
  CITYL: null
  SUBNAME: null
  BUSNAME: null
  Fire_MapBook: null
  Recycle_Day: null
  Recycle_Week: null
  Recycle_Route: null
  Code: null
  NameWithheld: null
  Zoning: null
  Primary_Zone: null
  Zoning_2: null
  Air_Approach: null
  ELEMENTARY: null
  MIDDLE: null
  HIGH: null
  ELEC_DIST: null
  PRECINCT: null
  POLL: null
  Census_Tr: null
  State_Senate: null
  State_House: null
  Congress: null
  DamageZones: null
  PSA: null
  Rain_Gauge: null
  PAZ: null
  POINT_X: null
  POINT_Y: null
  Creator: null
  Creator_Date: null
  Editor: null
  Editor_Date: null
  UID_NG911: null
  Comp_Plan: null
  rownumber: null
  ObjectId_1: null
  PIN_12: null
  lrsn: null
  LRSNum: null
  PropExt: null
  DistNum: null
  Public_NeiNum: null
  NeiNum_name: null
  AZ: null
  PropClas: null
  PCDesc: null
  LocAddr: null
  LocCity: null
  LocState: null
  LocZip: null
  Owner1: null
  Owner2: null
  MailAddr: null
  MailCity: null
  MailStat: null
  MailZip: null
  TaxAcct: null
  Proffers: null
  Housing_Ty: null
  Res_Units: null
  Improved: null
  Unit_Cap: null
  Ex_land_Us: null
  PL_SubName: null
  PIN_12_13: null
  OBJECTID_12: null
  LegalAc: null
  PricePerAcre: null
  sdz: null
  CurTot: null
  CurImp: null
  CurLand: null
  PrevTot: null
  PrevImp: null
  PrevLand: null
  Prev2Tot: null
  Prev2Imp: null
  Prev2Land: null
  LandDesc1: null
  Grantor3: null
  Doc3Num: null
  Sale3Amt: null
  Sale3D: null
  Grantor2: null
  Legal1: null
  Sale1D: null
  Sale1Amt: null
  Doc1Num: null
  Grantor1: null
  Sale2D: null
  Sale2Amt: null
  Doc2Num: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Extract,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: false

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