Skip to content

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

Open
@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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions