Closed nickdos closed 5 years ago
spatial.ala.org.au psql layersdb “927” table export “927” usingg pgsql2shp https://necetar-spatial-staging.ala.org.au/ws/object/5388516 edit objects table
https://spatial-beta.ala.org.au/ws/object/5388516 https://spatial.ala.org.au/ws/object/5388516 sampling.ala.org.au:/data/ala/data/layers/ready/shape/cw_state_poly.shp spatial.ala.org.au:/data/ala/data/layers/ready/shape/cw_state_poly.shp spatial-beta.ala.org.au:/data/spatial-data/layer/cw_state_poly.shp nectar-spatial-staging.ala.org.au:/data/spatial-data/layer/cw_state_poly.shp
update objects set id = 'Australian Capital Territory', name='Australian Capital Territory' where pid = '5388516';
[SHP updated, Table objects updated] https://spatial.ala.org.au/ws/object/5388516 [SHP updated] sampling.ala.org.au:/data/ala/data/layers/ready/shape/cw_state_poly.shp [SHP updated, Table objects updated] spatial-beta.ala.org.au:/data/spatial-data/layer/cw_state_poly.shp [SHP updated, Table objects updated] nectar-spatial-staging.ala.org.au:/data/spatial-data/layer/cw_state_poly.shp
Requires biocache re-index before I can test on AVH/ALA. Not yet seeing correction in biocache.
To test: https://biocache.ala.org.au/occurrences/search?taxa=acacia#tab_mapView
turn ON facet "Location" for "States including coastal waters" and check for "Australian Captial Territory" in facets list:
Reported by Anna M, the ACT layer comes through as
Australian "Captial" Territory
. This appears to be a known issue as there are numerous REs in the code to correct this on the fly.Can someone get into the layer data and manually fix this typo? Or better still, get an update from the original source with the fix already applied?
EDIT: update layer seems like the best option as layer is dated 2011.
https://sampling.ala.org.au/sampling-service/layers/view/more/cl927