git.8kb.co.uk Git - postgresql/geographic_data/atom logSome scripts to assist importing OrdnanceSurvey / Royal Mail PAF data into PostgreSQL with latitude / longitude.https://git.8kb.co.uk?p=postgresql/geographic_datastatic/git-favicon.pngstatic/git-logo.png2015-11-11T14:23:15ZgitwebFix: when re-importing data into existing tables truncate needs cascade due to foreig... 2015-11-11T14:23:15Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2015-11-11T14:23:15Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=bee817ca58c5edb372ba13b97976c106079d64f1
Fix: when re-importing data into existing tables truncate needs cascade due to foreign keys.
Mark escaped strings as so2015-11-11T14:19:18Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2015-11-11T14:19:18Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=6bcf4ac235f27bc6a4c0e3f69aac134fda8e331b
Alter master views to account for quirk in PAF schema where mainfile address_key... 2014-08-11T10:12:38Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2014-08-11T10:12:38Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=dbe06233a9220029439c5baa17ebc83eb52d457e
Alter master views to account for quirk in PAF schema where mainfile address_key relates to organisations instead of organisation_key when postcode_type is L
Alter master views to account for quirk in PAF schema where mainfile address_key... 2014-08-11T09:51:13Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2014-08-11T09:51:13Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=f3a230a6b9e9fd5cd660e7b6fadf98cd0dc0be92
Alter master views to account for quirk in PAF schema where mainfile address_key relates to organisations instead of organisation_key when postcode_type is L
Fix a couple of typo's in paf_postgresql_import_postgis.plpgsql2014-05-23T11:29:39Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2014-05-23T11:29:39Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=2643753a92fb1873da17f5afd4d76b151fc9304f
Fix a couple of typo's in paf_postgresql_import_postgis.plpgsql
Create copy of paf_postgresql_import.plpgsql named paf_postgresql_import_postgis... 2014-05-22T15:05:07Zglynglyn@8kb.co.ukglynglyn@8kb.co.uk2014-05-22T15:05:07Zhttps://git.8kb.co.uk?p=postgresql/geographic_data;a=commitdiff;h=50dff4a45fc4d6c1456a35ed61c02d71c9e1f67d
Create copy of paf_postgresql_import.plpgsql named paf_postgresql_import_postgis.plpgsql generating all latlong data via postgis (thus no need for paf_convert.pl) and capable of doing complete updates