Twitter | Pretraživanje | |
PostGIS
Celebrating day by making all my tables shapefile compliant… UPDATE pg_attribute SET attname = left(attname,10)
Reply Retweet Označi sa "sviđa mi se" More
Matt Travis 3. pro
Odgovor korisniku/ci @postgis @shapefile
Great descriptio
Reply Retweet Označi sa "sviđa mi se"
Stefan Keller 2. pro
Odgovor korisniku/ci @postgis @shapefile
WTH do you want to celebrate with ? Ages of data loss? My three(!) cheers go for a , December 4!
Reply Retweet Označi sa "sviđa mi se"
Rémi Bovard 3. pro
Odgovor korisniku/ci @postgis @shapefiIe
I just checked my database, there is a little work to do... SELECT attname = LEFT(attname, 10) AS is_shp_com, COUNT(1) FROM pg_catalog.pg_attribute GROUP BY 1; Thanks for this
Reply Retweet Označi sa "sviđa mi se"
murat kendir 2. pro
Odgovor korisniku/ci @postgis @shapefile
I use arabic notation (writing only voiceless consonant letters w ascii characters, for exp. Bldng for building), just because of shapefile limitation...
Reply Retweet Označi sa "sviđa mi se"
Thomas gratier 3. pro
Odgovor korisniku/ci @postgis @shapefile
I will avoid the recipe as my_very_long_prefix_1colname and my_very_long_prefix_2colname will collide after
Reply Retweet Označi sa "sviđa mi se"
Thomas gratier 3. pro
Odgovor korisniku/ci @postgis @shapefile
Instead use the table to identify issues and generate SELECT subquery to alias column directly or using view/materialized view
Reply Retweet Označi sa "sviđa mi se"
3XE 4. pro
Odgovor korisniku/ci @postgis @shapefile
Reply Retweet Označi sa "sviđa mi se"
christophev 3. pro
Odgovor korisniku/ci @postgis @RemiBovard @shapefile
Shape what's that ? It's the prehistory of GIS formats. When it was the flat data age.
Reply Retweet Označi sa "sviđa mi se"
Romain 3. pro
Odgovor korisniku/ci @ChristopheVe @postgis i 2 ostali
Et pourtant...
Reply Retweet Označi sa "sviđa mi se"