Skip to content

utah-plss-point-gcdb: _700 columns labeled _100 #347

@jidanni

Description

@jidanni

The western edge of a PLSS township has PLSS point IDs _100,
and the eastern edge are _700.

Thus https://opendata.gis.utah.gov/datasets/utah-plss-point-gcdb/explore data has a big bug. The 7 loops back around to 1 just a little too fast.

ogr2ogr bad.csv -dialect SQLITE -sql \
   'SELECT XCOORD,POINTID FROM PLSSPoint_GCDB
   WHERE POINTID LIKE "UT260060S0020E0__00400"
   ORDER BY XCOORD' UtahPLSSGCDBPoints_7983.gdb.zip
cat bad.csv
XCOORD,POINTID
-111.75200536,UT260060S0020E0_200400
-111.73299682,UT260060S0020E0_300400
-111.67550572,UT260060S0020E0_600400
-111.65744916,UT260060S0020E0_100400 #Wrong.

That last line should be

-111.65744916,UT260060S0020E0_700400

which is often, but not always, the same as

-111.65744916,UT260060S0030E0_100400

And that's only checking one of the four sides of one township. I.e., I fear it is only the tip of the iceberg.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions