Description

more
This dataset contains the address points within Scott County, in MetroGIS format. The attributes of the data allow for accurate geocoding.

Dataset Attributes

  • OBJECTID
    Number
  • Address Unique Identifier
    Text
  • ADD_ID_LOC
    Text
    {"value"=>"CB521B07-F570-4DA0-A610-909F033B395C", "count"=>1} (), {"value"=>"0F46EDE0-8D4C-48FC-8166-AFE06B22B5EA", "count"=>1} (), {"value"=>"7635A971-1A37-4AB0-8BD7-F2D21E0F3E2F", "count"=>1} (), {"value"=>"66B49163-4C96-4130-95EE-051A0B38BD6A", "count"=>1} (), {"value"=>"7A976DDA-B98D-4F5B-8DE8-D5E5AE405C25", "count"=>1} (), {"value"=>"7A1792D2-5ACD-4761-9D99-061389968ED0", "count"=>1} (), {"value"=>"311A811B-0FCB-48AD-AFC7-25E8C04BFFFF", "count"=>1} (), {"value"=>"2A5E2C18-0EC9-460E-A5C3-37A2F2ECC29B", "count"=>1} (), {"value"=>"B6E5C73F-A533-4BF6-BB91-F6D2D320F47E", "count"=>1} (), {"value"=>"58EE3423-D748-41A0-88D1-0C6E6486EDF9", "count"=>1} ()
  • ANUMBERPRE
    Text
  • ANUMBER
    Number
    0 to 27995
  • ANUMBERSUF
    Text
    {"value"=>"1/2", "count"=>24} (), {"value"=>"B", "count"=>2} (), {"value"=>"A", "count"=>2} (), {"value"=>"C", "count"=>1} ()
  • ST_PRE_MOD
    Text
  • ST_PRE_DIR
    Text
  • ST_PRE_TYP
    Text
  • Street Name Pre Separator
    Text
  • ST_NAME
    Text
    {"value"=>"1st", "count"=>567} (), {"value"=>"Louisiana", "count"=>370} (), {"value"=>"Natchez", "count"=>321} (), {"value"=>"3rd", "count"=>314} (), {"value"=>"Wilds", "count"=>300} (), {"value"=>"Valley Green", "count"=>291} (), {"value"=>"250th", "count"=>267} (), {"value"=>"Heritage", "count"=>258} (), {"value"=>"Virginia", "count"=>240} (), {"value"=>"6th", "count"=>231} ()
  • ST_POS_TYP
    Text
    {"value"=>"Street", "count"=>14548, "code"=>"Street"} (), {"value"=>"Avenue", "count"=>12516, "code"=>"Avenue"} (), {"value"=>"Drive", "count"=>7488, "code"=>"Drive"} (), {"value"=>"Lane", "count"=>5119, "code"=>"Lane"} (), {"value"=>"Circle", "count"=>3658, "code"=>"Circle"} (), {"value"=>"Court", "count"=>3629, "code"=>"Court"} (), {"value"=>"Trail", "count"=>3303, "code"=>"Trail"} (), {"value"=>"Road", "count"=>2782, "code"=>"Road"} (), {"value"=>"Boulevard", "count"=>1421, "code"=>"Boulevard"} (), {"value"=>"Way", "count"=>1152, "code"=>"Way"} ()
  • ST_POS_DIR
    Text
    {"value"=>"South", "count"=>6069, "code"=>"South"} (), {"value"=>"West", "count"=>5259, "code"=>"West"} (), {"value"=>"Southeast", "count"=>5254, "code"=>"Southeast"} (), {"value"=>"East", "count"=>4276, "code"=>"East"} (), {"value"=>"Northwest", "count"=>3470, "code"=>"Northwest"} (), {"value"=>"Northeast", "count"=>3064, "code"=>"Northeast"} (), {"value"=>"Southwest", "count"=>1323, "code"=>"Southwest"} (), {"value"=>"North", "count"=>834, "code"=>"North"} ()
  • ST_POS_MOD
    Text
  • SUB_TYPE1
    Text
    {"value"=>"Apartment", "count"=>555, "code"=>"Apartment"} (), {"value"=>"Lot", "count"=>515, "code"=>"Lot"} (), {"value"=>"Unit", "count"=>472, "code"=>"Unit"} (), {"value"=>"Suite", "count"=>195, "code"=>"Suite"} (), {"value"=>"Building", "count"=>96, "code"=>"Building"} ()
  • SUB_ID1
    Text
    {"value"=>"C", "count"=>29} (), {"value"=>"100", "count"=>29} (), {"value"=>"A", "count"=>29} (), {"value"=>"B", "count"=>27} (), {"value"=>"D", "count"=>25} (), {"value"=>"E", "count"=>24} (), {"value"=>"1", "count"=>21} (), {"value"=>"200", "count"=>21} (), {"value"=>"2", "count"=>21} (), {"value"=>"4", "count"=>17} ()
  • SUB_TYPE2
    Text
  • SUB_ID2
    Text
  • ZIP
    Text
    {"value"=>"55379", "count"=>15933} (), {"value"=>"55372", "count"=>14411} (), {"value"=>"55378", "count"=>11510} (), {"value"=>"55352", "count"=>4507} (), {"value"=>"56071", "count"=>4351} (), {"value"=>"56011", "count"=>3693} (), {"value"=>"55020", "count"=>1852} (), {"value"=>"55044", "count"=>1697} (), {"value"=>"55054", "count"=>810} (), {"value"=>"55088", "count"=>436} ()
  • ZIP4
    Text
    {"value"=>"3959", "count"=>108} (), {"value"=>"3977", "count"=>68} (), {"value"=>"4700", "count"=>67} (), {"value"=>"4523", "count"=>59} (), {"value"=>"9367", "count"=>58} (), {"value"=>"3123", "count"=>51} (), {"value"=>"1948", "count"=>49} (), {"value"=>"4545", "count"=>45} (), {"value"=>"5618", "count"=>44} (), {"value"=>"4703", "count"=>44} ()
  • CTU Name
    Text
    {"value"=>"Shakopee", "count"=>14156, "code"=>"Shakopee"} (), {"value"=>"Savage", "count"=>11705, "code"=>"Savage"} (), {"value"=>"Prior Lake", "count"=>10807, "code"=>"Prior Lake"} (), {"value"=>"New Prague", "count"=>3054, "code"=>"New Prague"} (), {"value"=>"Belle Plaine", "count"=>2751, "code"=>"Belle Plaine"} (), {"value"=>"Jordan", "count"=>2370, "code"=>"Jordan"} (), {"value"=>"Credit River Township", "count"=>2366, "code"=>"Credit River Township"} (), {"value"=>"New Market Township", "count"=>2021, "code"=>"New Market Township"} (), {"value"=>"Spring Lake Township", "count"=>1993, "code"=>"Spring Lake Township"} (), {"value"=>"Cedar Lake Township", "count"=>1744, "code"=>"Cedar Lake Township"} ()
  • CTU Code
    Text
    {"value"=>"Shakopee", "count"=>14156, "code"=>"02395854"} (), {"value"=>"Savage", "count"=>11705, "code"=>"02396543"} (), {"value"=>"Prior Lake", "count"=>10807, "code"=>"02396284"} (), {"value"=>"New Prague", "count"=>3054, "code"=>"02395211"} (), {"value"=>"Belle Plaine", "count"=>2739, "code"=>"02394113"} (), {"value"=>"Jordan", "count"=>2370, "code"=>"02395483"} (), {"value"=>"Credit River Township", "count"=>2366, "code"=>"00663886"} (), {"value"=>"New Market Township", "count"=>2021, "code"=>"00665104"} (), {"value"=>"Spring Lake Township", "count"=>1993, "code"=>"00665676"} (), {"value"=>"Cedar Lake Township", "count"=>1744, "code"=>"00663767"} ()
  • CO_CODE
    Text
    {"value"=>"Scott", "count"=>57994, "code"=>"27139"} (), {"value"=>"Le Sueur", "count"=>1230, "code"=>"27079"} (), {"value"=>"27037", "count"=>4, "code"=>"27037"} ()
  • CO_NAME
    Text
    {"value"=>"Scott", "count"=>57994, "code"=>"Scott"} (), {"value"=>"Le Sueur", "count"=>1230, "code"=>"Le Sueur"} (), {"value"=>"Dakota", "count"=>4, "code"=>"Dakota"} ()
  • STATE_CODE
    Text
    {"value"=>"Minnesota", "count"=>59228, "code"=>"MN"} ()
  • LOC_DESC
    Text
    {"value"=>"BRIDGE 70J05", "count"=>1} (), {"value"=>"BRIDGE SA6-", "count"=>1} (), {"value"=>"BRIDGE 70J36", "count"=>1} (), {"value"=>"BRIDGE SA3-", "count"=>1} (), {"value"=>"BRIDGE 70534", "count"=>1} (), {"value"=>"BRIDGE 70553", "count"=>1} (), {"value"=>"BRIDGE 709J48", "count"=>1} (), {"value"=>"BRIDGE 5830A", "count"=>1} (), {"value"=>"BRIDGE 70541", "count"=>1} (), {"value"=>"BRIDGE SA5-", "count"=>1} ()
  • LANDMARK
    Text
  • RESIDENCE
    Text
  • MAILABLE
    Text
    {"value"=>"Yes", "count"=>57934, "code"=>"Yes"} (), {"value"=>"No", "count"=>967, "code"=>"No"} ()
  • Parcel Unique Identifier
    Text
    {"value"=>"27139-264450010", "count"=>67} (), {"value"=>"27139-069150400", "count"=>6} (), {"value"=>"27139-264030042", "count"=>5} (), {"value"=>"27139-089130013", "count"=>4} (), {"value"=>"27139-271100010", "count"=>4} (), {"value"=>"27139-272920070", "count"=>4} (), {"value"=>"27139-089110180", "count"=>4} (), {"value"=>"27139-109250070", "count"=>4} (), {"value"=>"27139-264030041", "count"=>3} (), {"value"=>"27139-039250062", "count"=>3} ()
  • Placement Location
    Text
    {"value"=>"Placed on correct building, but not necessarily on doorstop", "count"=>53181, "code"=>"3"} (), {"value"=>"Driveway entrance from road", "count"=>3129, "code"=>"5"} (), {"value"=>"Centroid or random placement within parcel polygon", "count"=>2060, "code"=>"1"} (), {"value"=>"Placed over portion of building in which the unit exists", "count"=>238, "code"=>"4"} (), {"value"=>"6", "count"=>28, "code"=>"6"} (), {"value"=>"Other", "count"=>25, "code"=>"99"} (), {"value"=>"7", "count"=>15, "code"=>"7"} (), {"value"=>"Unknown", "count"=>9, "code"=>"0"} (), {"value"=>"Aligned to doorstop", "count"=>2, "code"=>"2"} ()
  • Centerline Geocodable
    Text
    {"value"=>"Unknown", "count"=>59228, "code"=>"Unknown"} ()
  • Unique Without Subaddresses
    Text
    {"value"=>"No", "count"=>1648, "code"=>"No"} (), {"value"=>"Yes", "count"=>749, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>10, "code"=>"Unknown"} ()
  • LONGITUDE
    Number
    -93.89057921 to -93.27840089
  • LATITUDE
    Number
    44.53007436 to 44.80389684
  • US National Grid Code
    Text
  • 911 GIS Point-of-Contact
    Text
    {"value"=>"Scott", "count"=>57998, "code"=>"Scott"} (), {"value"=>"Le Sueur", "count"=>1230, "code"=>"Le Sueur"} ()
  • Emergency Service Number
    Text
    {"value"=>"219", "count"=>13947} (), {"value"=>"220", "count"=>11711} (), {"value"=>"112", "count"=>10635} (), {"value"=>"113", "count"=>4358} (), {"value"=>"110", "count"=>2751} (), {"value"=>"109", "count"=>2370} (), {"value"=>"214", "count"=>2090} (), {"value"=>"9", "count"=>2075} (), {"value"=>"213", "count"=>1816} (), {"value"=>"325", "count"=>1586} ()
  • PSAP Code
    Text
    {"value"=>"Scott County", "count"=>57998, "code"=>"SCOT"} (), {"value"=>"LeSueur County", "count"=>1230, "code"=>"LESR"} ()
  • MSAG Community Name
    Text
    {"value"=>"SHAKOPEE", "count"=>15927, "code"=>"SHAKOPEE"} (), {"value"=>"PRIOR LAKE", "count"=>14418, "code"=>"PRIOR LAKE"} (), {"value"=>"SAVAGE", "count"=>11511, "code"=>"SAVAGE"} (), {"value"=>"JORDAN", "count"=>4506, "code"=>"JORDAN"} (), {"value"=>"NEW PRAGUE", "count"=>4350, "code"=>"NEW PRAGUE"} (), {"value"=>"BELLE PLAINE", "count"=>3697, "code"=>"BELLE PLAINE"} (), {"value"=>"ELKO NEW MARKET", "count"=>2663, "code"=>"ELKO NEW MARKET"} (), {"value"=>"LAKEVILLE", "count"=>1693, "code"=>"LAKEVILLE"} (), {"value"=>"WEBSTER", "count"=>438, "code"=>"WEBSTER"} (), {"value"=>"HENDERSON", "count"=>18, "code"=>"HENDERSON"} ()
  • 911 Validation Error
    Text
  • STATUS
    Text
    {"value"=>"Active", "count"=>58069, "code"=>"Active"} (), {"value"=>"Proposed", "count"=>1095, "code"=>"Proposed"} (), {"value"=>"Retired", "count"=>64, "code"=>"Retired"} ()
  • Effective Date
    Date
    1432645805000 to 1548262489000
  • Retired Date
    Date
  • Source
    Text
    {"value"=>"13", "count"=>57716} ()
  • AAUTHORITY
    Text
    {"value"=>"Shakopee", "count"=>13903} (), {"value"=>"ScottCounty", "count"=>12685} (), {"value"=>"Savage", "count"=>11721} (), {"value"=>"PriorLake", "count"=>10682} (), {"value"=>"NewPrague", "count"=>3032} (), {"value"=>"BellePlaine", "count"=>2750} (), {"value"=>"Jordan", "count"=>2363} (), {"value"=>"ElkoNewMarket", "count"=>1633} (), {"value"=>"SMSC", "count"=>273} (), {"value"=>"SCMaster", "count"=>173} ()
  • EDIT_ORG
    Text
    {"value"=>"Shakopee", "count"=>13652} (), {"value"=>"ScottCounty", "count"=>12237} (), {"value"=>"Savage", "count"=>11200} (), {"value"=>"PriorLake", "count"=>10313} (), {"value"=>"NewPrague", "count"=>2974} (), {"value"=>"BellePlaine", "count"=>2688} (), {"value"=>"Jordan", "count"=>2269} (), {"value"=>"SCMaster", "count"=>2144} (), {"value"=>"ElkoNewMarket", "count"=>1547} (), {"value"=>"SMSC", "count"=>191} ()
  • Edited Date
    Date
    1432645805000 to 1548264077000
  • COMMENTS
    Text
    {"value"=>"ERROR- USPS Address: Address Number is 0", "count"=>463} (), {"value"=>"Trailer Park, Lyn provided layout with lot numbers for this park. City states that the address for all lots in this trailer park are XXX Valley Green Park.", "count"=>73} (), {"value"=>"Structure with no address, ", "count"=>50} (), {"value"=>"Got addresses from Pat Krings at Belle Plaine. Made changes on app and SS", "count"=>43} (), {"value"=>"Address to outlot. \n", "count"=>37} (), {"value"=>"ERROR- USPS Address Mismatch: 3186 130TH ST W SHAKOPEE 55379-9274", "count"=>21} (), {"value"=>"ERROR- USPS Address Mismatch: 551 DAKOTA ST S SHAKOPEE 55379-2516", "count"=>20} (), {"value"=>"ERROR- USPS Address Mismatch: 3005 4TH AVE E SHAKOPEE 55379-1768", "count"=>17} (), {"value"=>"ERROR- USPS Address Mismatch: 1200 4TH AVE W SHAKOPEE 55379-1021", "count"=>17} (), {"value"=>"ERROR- USPS Address Mismatch: 203 1ST AVE E SHAKOPEE 55379-", "count"=>14} ()
  • AC_MAILABLE_COMMENTS
    Text
    {"value"=>"AC OVERRIDE-DIRECTIONAL", "count"=>8623} (), {"value"=>"AC OVERRIDE- SPELLING AND DIRECTIONAL", "count"=>771} (), {"value"=>"AC OVERRIDE-SPELLING", "count"=>624} (), {"value"=>"AC OVERRIDE-SUBTYPE", "count"=>502} (), {"value"=>"USPS - ADD ADDRESS", "count"=>236} (), {"value"=>"NOT MAILABLE - EMPTY PARCEL", "count"=>120} (), {"value"=>"AC OVERRIDE- POST TYPE", "count"=>97} (), {"value"=>"NOT MAILABLE - DRIVEWAY ENTRANCE", "count"=>96} (), {"value"=>"AC OVERRIDE-SPELLING AND POST TYPE", "count"=>80} (), {"value"=>"AC OVERRIDE-DIRECTIONAL AND SUBTYPE", "count"=>76} ()
  • last_edited_user
    Text
    {"value"=>"SPSQLGISXXSDE", "count"=>59228} ()
  • last_edited_date
    Date
    1550177074000 to 1550177074000

Related Datasets