Socrata

Close
Author
Engelking, Derek (CI-StPaul)
Description
<p><strong>Attributes (Fields) Defined:</strong><br><br><strong>Parcel - ID:</strong> This is the unique identifier for each parcel in Ramsey County. We work to update the &quot;Parcel - ID&quot; fields (and associated map geometry) as needed to reflect new parcels created by lot splits, lot combinations and other processes that redefine parcels, and audit changes at least annually.<br><br><strong>Parcel - Name:&nbsp;</strong>Every parcel currently owned by the HRA is given a plain-language unique name, unique to that &quot;Parcel - ID&quot;. Often the parcel name is comprised simply of the parcel&#39;s address. But often a parcel is named something else to tie it to a landmark or particular street corner. Each parcel is part of a site. Sites are an assemblage of one or more parcels that generally share geographic proximity and are marketed together as a unit. Many sites are just one parcel, but when they are more than one parcel, the parcel name reflects this. Parcels within a site will share the same basic name, but be differentiated by a &quot;#1&quot;, &quot;#2&quot;, &quot;#3&quot;, etc. appended to the end of the name. Sites are generally numbered from northwest to southeast. Additional parcels may be added to a site, but the naming of existing parcels should not ever change - a parcel name should remain unique over time. Further, in some cases parcels are combined or split through a subdivision-level change. In these cases, parcels will generally be given a new site name, and/or new parcel numbers (higher than the ones previously assigned), as it is deemed appropriate. In certain cases, such as when land is taken or given back for public right-of way but the parcel boundary remains fundamentally unchanged, the word &quot;Updated&quot; may be inserted in the name of the parcel before the # at the end. It is important that the last item in a parcel name be the number because of how some internal map dashboard queries are structured. And again, in no case should a parcel name be repeated and used on a parcel with a different Parcel - ID.<br><br><strong>Parcel - Address:&nbsp;</strong>The street address of a parcel, as found in the Ramsey County Parcel Service. Properties without a structure will generally have an address of &quot;0&quot;&#39;; the parcel name field is designed to help in these cases locate the parcel in space without need for mapping.<br><br><strong>Parcel - Land Use Code Description:&nbsp;</strong>This comes directly from the Ramsey County Parcel Service classification for this parcel. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Parcel - Zoning:</strong> The code for the the zoning designation assigned to this parcel derived directly from the Principal Zoning GIS layer. This is updated several times per year in order to stay reasonably current with any data updates. CHOICES: RL &bull; R1 &bull; R2 &bull; R3 &bull; R4 &bull; RT1 &bull; RT2 &bull; RM1 &bull; RM2 &bull; RM3 &bull; T1 &bull; T2 &bull; T3 &bull; T3M &bull; T4 &bull; T4M &bull; OS &bull; B1 &bull; B2 &bull; B3 &bull; B4 &bull; B5 &bull; IT &bull; ITM &bull; I1 &bull; I2 &bull; I3 &bull; F1 &bull; F2 &bull; F3 &bull; F4 &bull; F5 &bull; F6 &bull; VP &bull; PD &bull; CA.<br><br><strong>Parcel - Ownership:</strong> A simplified version of which public entity owns a parcel. Occassionally it is helpful to pull properties from related governments into our database because they are likely candidates to market alongside HRA-owned properties. CHOICES: City of Saint Paul &bull; Ramsey County &bull; Saint Paul HRA &bull; Saint Paul Port Authority &bull; Saint Paul Public Schools &bull; State of Minnesota.<br><br><strong>Parcel - Inspiring Communities:&nbsp;</strong>If a parcel was aquired to be part of the City&#39;s Inspiring Communities program, that is denoted here. This is important because the Inspiring Communities program used a mix of funding sources that have specific requirements for resale, and are dealt with on their own track, somewhat separate from the way other properties are marketed and resold. CHOICES: No &bull; Yes<br><br><strong>Parcel - Acres (as shown on deed):&nbsp;</strong>This is the number of acres in the parcel, as shown on the parcel deed (as opposed to the number of acres found by measuring the parcel area in GIS, which is sometimes a slightly different number). This number comes directly from the Ramsey County Parcel Service.<br><strong><br>Parcel - EMV Land: </strong>The Estimated Market Value (EMV) of the parcel&#39;s land, as determined by the Ramsey County Assessor&#39;s office, and derived from the Ramsey County Parcel Service. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Parcel - EMV Building:&nbsp;</strong>The Estimated Market Value (EMV) of the parcel&#39;s built structure(s), as determined by the Ramsey County Assessor&#39;s office, and derived from the Ramsey County Parcel Service. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Parcel - EMV Total:</strong> The Estimated Market Value (EMV) of the parcel&#39;s land and built structure(s), added together, as determined by the Ramsey County Assessor&#39;s office and derived from the Ramsey County Parcel Service. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Site - Name:</strong> A name for the site. Each parcel is part of a site. Sites are an assemblage of one or more parcels that generally share geographic proximity and are marketed together as a unit. Many sites are just one parcel, but when they are more than one parcel, the parcel name (above) reflects this. Parcels within a site will share the same basic name, but be differentiated by a &quot;#1&quot;, &quot;#2&quot;, &quot;#3&quot;, etc. appended to the end of the parcel name. The site name is the parcel name without the numbering at the end. In this way, in ArcGIS, a dissolve on the site name field can be run to produce an analysis by site, instead of by parcel.<br><br><strong>Site - Address:&nbsp;</strong>An address for a site shared by all parcels that comprise a site. This is derived from one of the parcel addresses for parcels that comprise the site, or if all parcel addresses have a street number of &quot;0&quot; because they are vacant, it includes a rough description of where the site is located in the city.<br><br><strong>Site - Ward:</strong> The Ward in which the site is located. This field is updated every ten years to reflect changes to Ward boundaries due to redistricting. CHOICES: 1 &bull; 2 &bull; 3 &bull; 4 &bull; 5 &bull; 6 &bull; 7<br><br><strong>Site - Planning District:&nbsp;</strong>The number of the Planning District in which the Site is located. The City is divided into seventeen planning districts, each served by a city-funded and city-recognized District Council. CHOICES: 1 &bull; 2 &bull; 3 &bull; 4 &bull; 5 &bull; 6 &bull; 7 &bull; 8 &bull; 9 &bull; 10 &bull; 11 &bull; 12 &bull; 13 &bull; 14 &bull; 15 &bull; 16 &bull; 17<br><br><strong>Site - Classification:&nbsp;</strong>This is the core means of classifying HRA-owned properties, the way the sites are marketed or not marketed, and the HRA&#39;s intended destiny for the parcels. This is updated immediately upon a change of status in the site. CHOICES:</p> <ul> <li><strong>Commercial - Vacant Land:&nbsp;</strong>Properties that are generally zoned to allow a range of commerical uses, and have no known building or other structure.</li> <li><strong>Commercial - with Building(s):&nbsp;</strong>Properties that are generally zoned to allow a range of commercial uses, and contain a building or other structure.</li> <li><strong>Residential - Vacant Land:&nbsp;</strong>Properties that are generally zoned to allow mainly residential uses, and have no known building or other structure.</li> <li><strong>Residential - With Building(s):&nbsp;</strong>Properties that are generally zoned to allow mainly residential uses, and contain a building or other structure.</li> </ul> <p><strong>Site - Available on Open Market:&nbsp;</strong>This field conveys whether the site is actively available for sale on the open real-estate market. This is updated immediately upon a change of status in the site. &nbsp;CHOICES:</p> <ul> <li><strong>Yes, Subject to Disposition Policy: </strong>the site is actively available for sale on the open market; any HRA sale is subject to the <a href="https://www.stpaul.gov/departments/planning-economic-development/housing-and-redevelopment-authority-hra/policy-and">HRA Disposition Policy</a>.</li> </ul> <p><strong>Site - HRA-Managed Parking?:</strong> Is the site used as a site for HRA-Managed Parking? CHOICES: Yes &bull; No<br><br><strong>Site - Acres:&nbsp;</strong>This is the sum of the &quot;Parcel Acres (as Shown on Deed)&quot; field for the parcels that comprise a site. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Site - EMV Land:&nbsp;</strong>The Estimated Market Value (EMV) of the site&#39;s land, as determined by the Ramsey County Assessor&#39;s office, and derived from the Ramsey County Parcel Service. The Site EMV Land is obtained by adding together the individual EMV Land values for each parcel within the site. As a result, this number should be the same for each parcel within a larger site. This is updated several times per year in order to stay reasonably current with any data updates.<br><br><strong>Site - EMV Building:&nbsp;</strong>The Estimated Market Value (EMV) of the site&#39;s built structure(s), as determined by the Ramsey County Assessor&#39;s office, and derived from the Ramsey County Parcel Service. The Site EMV Building is obtained by adding together the individual EMV Building values for each parcel within the site. As a result, this number should be the same for each parcel within a larger site. This is updated roughly once per year in order to stay reasonably current.<br><br><strong>Site - EMV Total:</strong> The Estimated Market Value (EMV) of the site&#39;s land and built structure(s), added together, as determined by the Ramsey County Assessor&#39;s office and derived from the Ramsey County Parcel Service. The Site EMV Total is obtained by adding together the individual EMV Total values for each parcel within the site. As a result, this number should be the same for each parcel within a larger site. This is updated several times per year in order to stay reasonably current with any data updates.</p>
Rating
Current value: 0 out of 5
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

the_geom
the_geom
OBJECTID
objectid
Parcel - ID
parcel_id
Parcel - Name
parcel_name
Parcel - Address
parcel_address
Parcel - Land Use Code Description
parcel_landusecodedescription
Parcel - Zoning
parcel_zoning
Parcel - Ownership
parcel_ownership
Parcel - Inspiring Communities
parcel_inspiringcommunities
Parcel - Acres (as Shown on Deed)
parcel_acresasshownondeed
Parcel - EMV Land
parcel_emvland
Parcel - EMV Building
parcel_emvbuilding
Parcel - EMV Total
parcel_emvtotal
Site - Name
site_name
Site - Address
site_address
Site - Ward
site_ward
Site - Planning District
site_planningdistrict
Site - Classification
site_classification
Site - Available on Open Market
site_availableonopenmarket
Site - HRA-Managed Parking
site_hramanagedparking
Site - Acres
site_acres
Site - EMV Land
site_emvland
Site - EMV Building
site_emvbuilding
Site - EMV Total
site_emvtotal

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.