ProudGIS

SELECT nspname AS schema_name,SUM(pg_total_relation_size(quote_ident(nspname) || ‘.’ || quote_ident(relname))) AS total_size_bytes,pg_size_pretty(SUM(pg_total_relation_size(quote_ident(nspname) || ‘.’ || quote_ident(relname)))) AS total_sizeFROM pg_classJOIN pg_namespace ON relnamespace = pg_namespace.oidGROUP BY nspnameORDER BY total_size_bytes DESCLIMIT 20;

Using Google SDK Ensure gcloud project is set correctly gcloud config set project myProject Copy out JSON (sed to remove empty quotes) psql -h servername -U username -c \ 2 “\COPY (SELECT json_build_object(‘toid’, toid, ‘theme’, theme, ‘descriptivegroup’, descriptivegroup, ‘descriptiveterm’, descriptiveterm, 3 ‘featurecode’, featurecode, ‘geog’, ST_AsGeoJSON(ST_Transform(geom, 4326)::geography, 8, 0)) AS geog 4 FROM (SELECT featurecode, descriptiveterm, … More Big Query Loading

Referenced from another site but copied for personal reference: core.autocrlf If you’re programming on Windows and working with people who are not (or vice-versa), you’ll probably run into line-ending issues at some point. This is because Windows uses both a carriage-return character and a linefeed character for newlines in its files, whereas macOS and Linux … More GIT and line endings!

1.list attached disks sudo lsblk 2.Format the disk using the mkfs tool sudo mkfs.ext4 -m 0 -E lazy_itable_init=0,lazy_journal_init=0,discard /dev/[DEVICE_ID] (This command deletes all data from the specified disk, so make sure that you specify the disk device correctly. To maximize disk performance, use the recommended formatting options in the -E flag. It is not necessary … More Formatting and mounting a zonal persistent disk

locate pg_hba.conf   sudo vi /etc/postgresql/9.6/main/pg_hba.conf if need to add remote host go to remote server and try and psql to gcp box. i.e ssh to remote host and run psql -h **.***.***.** -U user database this will fail with the below error “error: could not connect to server: FATAL: no pg_hba.conf entry for host … More pg_hba.conf

git reference – https://git-scm.com/book/en/v2     git status – Compare your local repository against the origin. This will show you what needs pushing/cloning.   gitk – Running the UI for git     gitk –all & – Running the UI for git in background   git clone <gitrepository> – clones repository from origin to local   … More GIT – Getting Started

for tbl in $(ogrinfo geodatabase.gdb| cut -d “:” -f2 | cut -d “(” -f1); do ogr2ogr -f “PostgreSQL” PG:”host=localhost port=5432 dbname=osni_fusion user=username password=pwd”  geodatabase.gdb -nln data.$tbl $tbl; done

DO $$DECLARE r record; BEGIN FOR r IN SELECT tablename FROM pg_tables WHERE schemaname = ‘public’ LOOP EXECUTE ‘alter table ‘|| r.tablename ||’ owner to newowner;’; END LOOP; END$$;

Postgresql can fail with numerous errors with the route cause hidden behind lots of invalid command \N To stop at first error run with the below -v switch psql -v ON_ERROR_STOP=1

Moving file called HP40NE into folder called HP. For all files in folder (creating the dir if required) for f in *.tif; do mkdir ${f:0:2}; mv $f ${f:0:2}; done ${f:0:2} takes 2 characters from starting position 0 for variable f