Open vmromero opened 2 years ago
jultra
commented
2 years ago The data used for addresses is based on PSGC database, but unfortunately, the PSGC code was missing from the db dump used. Do you have a link to a complete SQL dump of the PSGC database?
vmromero
commented
2 years ago Not an SQL dump, but the updated codes upto the barangay level for the entire Philippines can be found here:
https://psa.gov.ph/classification/psgc/downloads/PSGC-2Q-2021-Publication-Datafile-01092021.xlsx
jultra
commented
2 years ago Yes, but it will take a bit of processing to use that data.
On Fri, Jan 14, 2022 at 7:13 PM vmromero @.***> wrote:
Not an SQL dump, but the updated codes upto the barangay level for the entire Philippines can be found here:
https://psa.gov.ph/classification/psgc/downloads/PSGC-2Q-2021-Publication-Datafile-01092021.xlsx
— Reply to this email directly, view it on GitHub https://github.com/jultra/sappat/issues/1#issuecomment-1013027918, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABX7EOJPML3CQUSYIX2QNS3UWAAL3ANCNFSM5LX7UAAQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
You are receiving this because you commented.Message ID: @.***>
Geographic data should be consistent with the Philippine Standard Geographic Code to make later visualization more straightforward and for purpose of consistency with other government institutions.