Proposed import: Middlebury College trees

Hello folks, I’m planning an import of trees on the Middlebury College campus as documented in the here:

The Middlebury College arborist maintains a GIS database of campus trees with a wealth of data including species, diameter, height, spread, among other information. A public view of this data is available at: https://sites.middlebury.edu/middland/campus-tree-map/

I’ve completed other larger imports and am familiar with the process, but I’d particularly like feedback on the proposed tagging of the species/taxon details as there are two overlapping tagging schemes in somewhat wide use.

Thanks in advance for any feedback you can provide.

1 Like

Hi Adam,

Glad to see the List of species table I created it’s useful :smiley:
Some comments based on the Tagging Plans table:

  • species:en and taxon:en values are the same. In such cases I would omit taxon:en, since is just duplicated info.
  • I would omit taxon:family as well. I would tag it only if more specific taxa data (genus and/or species) is missing (are there any cases like this?).
  • I would omit taxon:genus (only 7.596 uses). It’s just a duplicate of genus (1.627.616).
  • height=48', why not converting it to meters (the standard unit as wiki) before importing it? :eyes:
2 Likes

Thanks for the feedback! The taxon* schema seems a bit more fleshed out than species=* and genus=*, but I see your point about duplication.

I’m planning to leave the dimensions in feet & inches as those are the measurements used in practice in forestry in the US and are how the units recorded. While I could convert to meters the question then becomes one of what decimal place to round to and the values become more difficult for mappers to validate or adjust over time since no one in our region uses meters in practice.

See RFC: Documenting feet as an an optional elevation unit for much similar reasoning for recording the units actually used in local practice. As noted in Map features/Units - OpenStreetMap Wiki , explicit specification is allowed with proper unit formatting.

3 Likes

Would it make sense to tag check_date=* or some variant thereof? I’m guessing the campus trees are mostly mature, but if there are any younger trees in the dataset, the height=* and diameter=* tags could get out of date faster. Maybe it isn’t a big deal because this is all micromapping anyways?

I certainly could add that. The dataset has a record of the dates that the arborist last visited and evaluated the tree.

1 Like

+1 on the import overall!

A couple comments:

  • I realize it may not be a stable reference number, but have you at least considered whether to encode the OBJECTID (or if any other unique ref exists) as a stable reference to that specific tree, to aid updating and cross-reference against the campus tree database?

  • There appears to be a field PlantTypeText as part of the species data; have you considered deriving leaf_cycle and/or leaf_type from this instead of (or additional to) relying on a lookup table?

  • There are a bunch of typos/errors in the value example for the inscription=* tag:

    European Beech Fagus sylvatica Scott Danforth Sandbloom '82 1960-1995 One of his greatest joys was building sand castles, wiith scores of giggling kids climbing on his back,helping, hampering,reveling in his attention.

    Are these present in the source? Or how were they introduced?

Indeed; given it is already present in the dataset, seems like it would have considerable value to include at trivial cost, especially considering many trees seem to have multiple visits over the years. And in case anyone was suitably motivated to survey the trees themselves, this could help avoid overwriting their changes when resyncing the dataset unless the latest arborist visit was more recent.

Given these data are unlikely to be touched by regular users and will be kept updated from this data source, I don’t see any meaningful harm here in including both, given it is effectively zero actual cost.

For the record, this is not true; SI is widely used in the sciences, is the official standard in many areas of military and defense, sees considerable use alongside US customary units in various engineering, R&D and similar disciplines (including GIS), and sees use in other sectors, as well as is preferred for daily life by a small but not-insubstantial fraction of the native population (including myself), particularly among those most likely to be OSM contributors, alongside the large number of immigrants from the rest of the world that grew up with it.

That being said, though, I fully agree with the rationale:

that measurements should be recorded as specified in the source rather than mandating a lossy and inexact conversion (against what is recommended on the relevant wiki page), instead allowing the data consumer to whichever units they need. This follows from the fundamental principle of OSM, map what’s on the ground–i.e. as signposted, measured or mandated. Therefore, US height limits and speed limits are mapped in USC units (aside from the handful of very rare corner cases where they are actually specified as metric), whereas for measured quantities it matches what was actually measured/recorded.

For example, in one particular area I map, building heights from a local LIDAR data collection project are mapped in meters, as was recorded by such, as are most distances measured by mappers on the ground or from aerial imagery (unless the actual on the ground object is clearly and unambiguously built to an exact number of USC units in size); whereas measurements originally performed and recorded in USC are recorded as such, as are speed and height limits as these are the actual signposted and mandated limits (with a few rare exceptions).

Only do this if another more intentional numbering system is provided. ArcGIS automatically adds the OBJECTID field to every layer. There’s no guarantee that this field is stable. If they publish another dataset, the IDs are almost guaranteed to differ. Every case of preserving OBJECTID in a previous import has turned out to be cruft. If there isn’t a real identifier scheme and you need to cross-reference the original dataset, then you need to perform a spatial query.

I think there’s broad agreement among the U.S. community that the priority is to avoid dataloss. This requires us to faithfully reproduce the source’s choice of units and significant figures, even at the expense of consistency from feature type to feature type or even from feature to feature.

Let’s assume this import does express the heights in feet and inches. If someone comes along later to update the height based on an on-site measurement, they should be free to use either feet and inches or meters depending on personal convenience. On the other hand, if someone later updates the height based on a published source such as a news report, we should use whatever units are in that source.

I think this flexibility is especially important for tree dimensions. Tree dimensions are rarely documented and even more rarely signposted. And a planimetric dataset such as the one proposed here is more likely than most to go away than most public datasets, leaving OSM as the “source of truth”, so to speak.

2 Likes

Thanks for the feedback!

As Min notes, these identifiers are not necessarily stable and are not particularly valuable. JOSM’s Conflation plugin does a good job matching spatially, which will need to be done for updates anyway.

That might work for leaf_cycle, but not leaf type. I’ll cross reference this with the lookup from the wiki and additional data sources.

It seems that the maintainer of the wiki tree species table exclusively wants the most recent species-level (not cultivar or hybrid) entries, so I’ll add my own hard-coded lookup table for hybrids and cultivars. Additionally, I’m working with the arborist to fix some spellings and renamings in the source data.

Yes, these are in the data source. I’ll pass off some of the corrections and apply some obvious fixes programmatically. Fix spellings in description · Issue #1 · adamfranco/middlebury_tree_import · GitHub

Will do! Add “Last Inspection” date as “check_date” #5

:+1: I’ll keep them.

1 Like

Ah, thanks for confirming. I figured there was a good chance that was the case–just didn’t see it mentioned in the import proposal one way or another, and it’s been too many years since I’ve really used Arc to remember if there was any value to it as a stable ID or not, so I figured I’d ask.

Excellent, glad we’re all in agreement then! Considerations like

and

could potentially be factors in a mapper’s individual decision of in what units to perform a particular measurement, but once already measured (as is the case here) the units should be recorded faithfully in OSM. Of course, when it comes to future updated measurements, mappers are free to measure in whatever supported units they see fit that they are most comfortable with.

2 Likes