Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: brgy_finance_df
|   Column1 | PSGC_BRGY   | NAME_BRGY          | NAME_MUNI                       | NAME_PROV     | geometry                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | centroid                                    |   longitude |   latitude |   HH_pop |   Total_under15 |   Total_15to17 |   Total_18to29 |   Total_30to39 |   Total_40to49 |   Total_50to59 |   Total_over60 |   num_atm |   num_bank |   num_cooperative |   num_finservice |   num_foundation |   num_pawnshop |   num_others |   num_atm_to_hh |   num_bank_to_hh |   num_cooperative_to_hh |   num_finservice_to_hh |   num_foundation_to_hh |   num_pawnshop_to_hh |   num_others_to_hh |   closest_atm_distance |   closest_bank_distance |   closest_cooperative_distance |   closest_finservice_distance |   closest_foundation_distance |   closest_pawnshop_distance |   closest_others_distance |   num_total_finance |   Total_Population |   num_bank_atm |   Closest_min |
|----------:|:------------|:-------------------|:--------------------------------|:--------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------|------------:|-----------:|---------:|----------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|----------:|-----------:|------------------:|-----------------:|-----------------:|---------------:|-------------:|----------------:|-----------------:|------------------------:|-----------------------:|-----------------------:|---------------------:|-------------------:|-----------------------:|------------------------:|-------------------------------:|------------------------------:|------------------------------:|----------------------------:|--------------------------:|--------------------:|-------------------:|---------------:|--------------:|
|       795 | PH153601001 | Ampao              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1414685880001 7.856964539000046, 124.1413444870001 7.856853894000039, 124.140988536 7.856521496000026, 124.1407261530001 7.856289160000074, 124.1405663040001 7.856505956000035, 124.140693454 7.856615223000061, 124.1406278820001 7.856723788000066, 124.1405728120001 7.856809728000029, 124.1404831900001 7.856966816000066, 124.1405367630001 7.857502831000032, 124.1401303700001 7.85846326400002, 124.137008421 7.865064083000048, 124.137580778 7.86523827900004, 124.1400454300001 7.859938143000021, 124.140710182 7.858521245000076, 124.1411609690001 7.857373957000051, 124.14131492 7.857124653000028, 124.1414685880001 7.856964539000046))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | POINT (124.1392997553405 7.860807897200258) |     124.139 |    7.86081 |      904 |             344 |             33 |            236 |            101 |             92 |             53 |             28 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                19709.7 |                19563.7  |                        9229.85 |                       19855   |                       73249.5 |                      576300 |                  22817.8  |                   0 |                887 |              0 |       9229.85 |
|       796 | PH153601002 | Bagoaingud         | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1380393380001 7.855043504000036, 124.1380015560001 7.855046647000051, 124.13783707 7.855030558000065, 124.137695127 7.855011106000063, 124.1375433390001 7.855046022000069, 124.137475448 7.855049053000071, 124.1374074150001 7.85500061500005, 124.137281203 7.855058185000074, 124.137155234 7.85515448600006, 124.137084744 7.85525091900007, 124.136622899 7.855295723000039, 124.1364746380001 7.855433572000038, 124.136319929 7.855551591000049, 124.136198162 7.85559319600003, 124.1361883020001 7.855591358000027, 124.136039005 7.855563526000023, 124.1364187280001 7.856380593000039, 124.1363837990001 7.85639479300005, 124.1365759280001 7.856981639000026, 124.1357949130001 7.858697784000073, 124.1349123170001 7.860555307000028, 124.1333165090001 7.864035248000051, 124.134646534 7.864350639000065, 124.137407238 7.858821646000024, 124.137843778 7.857946170000048, 124.1380151550001 7.856285242000068, 124.1379835990001 7.855983991000076, 124.138109802 7.855743427000051, 124.138045098 7.855488740000058, 124.1380812440001 7.855475820000039, 124.138047313 7.855313379000052, 124.138052622 7.855187954000033, 124.1380393380001 7.855043504000036))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | POINT (124.1360409273194 7.859599736138784) |     124.136 |    7.8596  |      696 |             353 |             22 |            121 |             76 |             68 |             29 |             12 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                20047.3 |                19899.9  |                        9592.16 |                       20194   |                       73173   |                      575926 |                  23173.8  |                   0 |                681 |              0 |       9592.16 |
|       797 | PH153601004 | Balut              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1583140230001 7.834504480000017, 124.1586668970001 7.834456470000021, 124.1589282910001 7.834309569000026, 124.159201283 7.834107490000065, 124.1595214580001 7.83416376300005, 124.1597890060001 7.834148455000046, 124.1599998710001 7.834110536000027, 124.160095712 7.834010678000026, 124.1600755000001 7.833845749000035, 124.1601692250001 7.833562724000045, 124.1602526080001 7.833382012000071, 124.1603303530001 7.833196496000027, 124.1602452530001 7.833081403000047, 124.1600699910001 7.833003525000037, 124.1600096240001 7.832883624000033, 124.1599335100001 7.832734681000034, 124.1597983890001 7.832697922000023, 124.1596054260001 7.832706138000047, 124.1595627800001 7.832800165000037, 124.159480088 7.832890072000056, 124.159402437 7.832951404000026, 124.159335549 7.832957180000053, 124.1592072830001 7.832934766000053, 124.1590930530001 7.832921517000043, 124.1589996770001 7.832912818000072, 124.1588666350001 7.832818981000058, 124.1587598780001 7.832765808000032, 124.158664109 7.832657096000046, 124.1585268970001 7.832626731000063, 124.158453117 7.832624113000065, 124.1583041240001 7.832567822000042, 124.158220258 7.832585661000055, 124.158196255 7.832656568000063, 124.1580203560001 7.832666396000034, 124.1579371700001 7.832674805000067, 124.1577608340001 7.832873319000042, 124.1576670200001 7.832880305000062, 124.1575894660001 7.832957908000027, 124.1575227100001 7.833005983000019, 124.157479662 7.833077745000026, 124.1574917050001 7.833110379000062, 124.1574361430001 7.833177955000053, 124.1573850460001 7.833156955000047, 124.1572644280001 7.833185356000057, 124.1572258570001 7.833303594000023, 124.1572204080001 7.833350334000047, 124.1571535550001 7.833369264000058, 124.157072767 7.83341275400005, 124.1570488900001 7.833521272000041, 124.156921742 7.833545639000022, 124.156884543 7.833666987000072, 124.1567829260001 7.83369245600005, 124.156796104 7.833775781000043, 124.1566816770001 7.833871071000035, 124.1566082000001 7.833868696000021, 124.1564960710001 7.833954114000049, 124.1564367330001 7.834004632000071, 124.1563518160001 7.834089687000072, 124.15629574 7.834238510000035, 124.1563866170001 7.834344550000026, 124.1565617660001 7.83436841200006, 124.1567705560001 7.834462683000025, 124.1571131560001 7.834457942000028, 124.1572085940001 7.834524671000053, 124.157420772 7.834610239000028, 124.1578156500001 7.834605873000043, 124.1580961980001 7.83452009100006, 124.1583140230001 7.834504480000017))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | POINT (124.158403511832 7.833647189411358)  |     124.158 |    7.83365 |      594 |             248 |             24 |            106 |             78 |             71 |             23 |             28 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                20917.2 |                19002.9  |                       10234.7  |                       21034.7 |                       69959.7 |                      576441 |                  23586.6  |                   0 |                578 |              0 |      10234.7  |
|       798 | PH153601005 | Barua              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1482116330001 7.87012118800004, 124.1460619220001 7.867845592000037, 124.140859223 7.869346287000043, 124.137725487 7.870188186000065, 124.135784442 7.870726066000028, 124.134411096 7.871085530000073, 124.0995957680001 7.921072376000041, 124.0957799520001 7.931956739000042, 124.139659445 7.87927251800005, 124.1482116330001 7.87012118800004))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | POINT (124.1234847452403 7.893477255528523) |     124.123 |    7.89348 |      805 |             369 |             32 |            179 |             81 |             62 |             39 |             18 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                18482.2 |                18307.3  |                        9111.51 |                       18654.6 |                       77116   |                      576822 |                  21992.9  |                   0 |                780 |              0 |       9111.51 |
|       799 | PH153601006 | Buadiawani         | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1333165090001 7.864035248000051, 124.1349123170001 7.860555307000028, 124.1357949130001 7.858697784000073, 124.1365759280001 7.856981639000026, 124.1363837990001 7.85639479300005, 124.1364187280001 7.856380593000039, 124.136039005 7.855563526000023, 124.1359399940001 7.855666417000067, 124.1358398140001 7.855683655000065, 124.135605024 7.855712163000021, 124.1354112450001 7.855817080000066, 124.1353585120001 7.855922370000028, 124.1353060070001 7.856126884000048, 124.135364868 7.856272925000042, 124.1353769560001 7.856401701000039, 124.1352015480001 7.856447800000071, 124.1351552550001 7.856540941000047, 124.1349686900001 7.85664194900005, 124.1349444140001 7.856793518000075, 124.134687973 7.856897960000024, 124.1345309320001 7.857008198000075, 124.1343890910001 7.857066513000063, 124.134291026 7.857101348000067, 124.134213594 7.857195054000046, 124.1341291460001 7.857227109000062, 124.1340738800001 7.857278414000063, 124.1339662950001 7.857348520000073, 124.1337596990001 7.857321843000022, 124.1336753510001 7.857286096000053, 124.1335661480001 7.85740195000005, 124.1333042110001 7.857503638000027, 124.1332928710001 7.857508040000029, 124.1332602580001 7.857450798000059, 124.1332232250001 7.857478496000057, 124.133255768 7.857525342000027, 124.1335955740001 7.858178963000055, 124.1318031600001 7.861557891000075, 124.1289464560001 7.866944687000058, 124.1333165090001 7.864035248000051))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | POINT (124.133277602721 7.861066324081695)  |     124.133 |    7.86107 |      513 |             200 |             22 |             94 |             71 |             70 |             32 |              5 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                20129.6 |                19979.5  |                        9730.28 |                       20278.7 |                       73383   |                      575759 |                  23292.7  |                   0 |                494 |              0 |       9730.28 |
|       800 | PH153606006 | Bualan             | BUBONG                          | LANAO DEL SUR | POLYGON ((124.3783536410001 8.005079314000055, 124.376705053 8.000760955000032, 124.3748657100001 7.996179611000061, 124.3746436590001 7.995204440000065, 124.373319142 7.990675109000051, 124.372884341 7.989077249000045, 124.372564312 7.988670866000064, 124.372417484 7.988587627000072, 124.372307824 7.988536362000048, 124.372176039 7.988434507000022, 124.3721022560001 7.988368103000026, 124.372091188 7.988272185000028, 124.3720100270001 7.988157822000063, 124.3719768250001 7.988080350000074, 124.3718587730001 7.987999189000048, 124.371745859 7.987900023000066, 124.3717134360001 7.987872825000064, 124.371674316 7.98779997500003, 124.371564945 7.987729308000041, 124.371488234 7.987658804000033, 124.3713198510001 7.98756668200002, 124.371244377 7.987458786000048, 124.3711275210001 7.987271565000071, 124.370917542 7.987308156000039, 124.3708665180001 7.987592378000043, 124.370808762 7.987871850000032, 124.3707140820001 7.988242410000052, 124.3707085030001 7.988311299000032, 124.3706306460001 7.988559065000059, 124.370363554 7.989114977000042, 124.3699169710001 7.989336864000051, 124.3697504720001 7.989753112000075, 124.3695673230001 7.990335860000073, 124.368836845 7.991878584000061, 124.3687711150001 7.992603716000078, 124.3764322540001 8.009636275000048, 124.3783536410001 8.005079314000055))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | POINT (124.3735129314689 7.99787001034283)  |     124.374 |    7.99787 |      608 |             232 |             17 |            155 |            117 |             37 |             20 |             21 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                12873.3 |                 9045.88 |                        8097.86 |                       12664   |                       88812.9 |                      606238 |                   8951.19 |                   0 |                599 |              0 |       8097.86 |
|       801 | PH153606007 | Poblacion (Bubong) | BUBONG                          | LANAO DEL SUR | POLYGON ((124.3656385480001 7.983576224000045, 124.365469648 7.983547724000058, 124.365123721 7.983583204000069, 124.3648603180001 7.983484581000027, 124.36461637 7.983450534000042, 124.364491152 7.983352994000031, 124.3641234920001 7.982818312000063, 124.3637561410001 7.982385880000037, 124.3634354860001 7.982121029000039, 124.3632020350001 7.982144287000037, 124.3631355150001 7.982243889000077, 124.3630903070001 7.982421553000052, 124.3630492330001 7.982673953000075, 124.3629421600001 7.982994803000052, 124.3627305690001 7.983203001000049, 124.3623508970001 7.983356250000044, 124.3620630520001 7.983530363000056, 124.3618534310001 7.98368441600007, 124.3615327600001 7.983784283000034, 124.3613011120001 7.983812192000074, 124.3610760190001 7.983778273000038, 124.360875197 7.983713137000053, 124.3607680540001 7.983575897000036, 124.3606259430001 7.983291656000064, 124.3604490480001 7.982945558000039, 124.360112209 7.982625251000059, 124.3598876020001 7.982330274000047, 124.35987991 7.98213799800004, 124.3598042220001 7.982394114000044, 124.3592359610001 7.982951219000027, 124.355773095 7.983013061000067, 124.3565567210001 7.986300469000069, 124.3632965320001 7.986324215000026, 124.3632965320001 7.985790314000043, 124.363814936 7.985787128000026, 124.364733686 7.985774945000059, 124.3647385400001 7.985713407000047, 124.36486376 7.985676200000057, 124.3649612610001 7.985658809000028, 124.3650779430001 7.985636673000045, 124.3652361820001 7.985627209000028, 124.3653848230001 7.985646234000058, 124.365406902 7.985651981000045, 124.3654408000001 7.985500520000072, 124.3656118710001 7.985191970000074, 124.365617409 7.983808014000032, 124.3656385480001 7.983576224000045))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | POINT (124.3606410157623 7.984574832846461) |     124.361 |    7.98457 |      613 |             303 |             18 |             95 |             72 |             75 |             29 |              7 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                11505.6 |                 7822.7  |                        6893.91 |                       11298.5 |                       87130   |                      604247 |                   7707.31 |                   0 |                599 |              0 |       6893.91 |
|       802 | PH153606008 | Bubonga Didagun    | BUBONG                          | LANAO DEL SUR | POLYGON ((124.4671228740001 7.968306421000023, 124.4578153540001 7.962843312000076, 124.4040407140001 7.987786711000071, 124.403336049 7.993589391000057, 124.403295982 7.993649602000062, 124.4032601660001 7.993708222000065, 124.40318503 7.993859374000068, 124.403064725 7.994086908000043, 124.402979714 7.994185238000059, 124.402964267 7.994385828000076, 124.4029693450001 7.994601737000039, 124.4029767850001 7.994769055000061, 124.4029681320001 7.994833248000019, 124.4030262260001 7.994872744000078, 124.4031409000001 7.994845960000019, 124.403214111 7.994734169000026, 124.403260078 7.994649438000065, 124.403310056 7.994620565000048, 124.4034078730001 7.994657839000068, 124.40346619 7.994626888000027, 124.4034765700001 7.994575268000061, 124.403528574 7.994534036000061, 124.4036765280001 7.994546503000039, 124.403763946 7.994569195000054, 124.403892679 7.99465772000002, 124.4039900710001 7.994686598000044, 124.4040193940001 7.994680702000039, 124.404098996 7.994731459000035, 124.4040576230001 7.994855578000057, 124.4040293150001 7.994975342000034, 124.4040271380001 7.995108171000027, 124.404005363 7.995206159000073, 124.40396321 7.995301300000052, 124.403969221 7.995458182000053, 124.403997773 7.995611326000072, 124.4040860260001 7.995769662000042, 124.404140535 7.995865702000061, 124.4043663590001 7.996052591000022, 124.4044032620001 7.996184241000038, 124.4046230870001 7.996215645000063, 124.405053764 7.996439956000074, 124.405282562 7.996408552000046, 124.4055158460001 7.996475846000067, 124.4058074510001 7.996614919000023, 124.4060900830001 7.996664267000028, 124.4062331270001 7.996648954000023, 124.4063749280001 7.996679973000026, 124.4066369860001 7.996792191000055, 124.406705028 7.996837351000068, 124.406740321 7.996870103000048, 124.4067977240001 7.996923371000037, 124.406832813 7.996955933000039, 124.4069152660001 7.997038194000025, 124.4070091210001 7.99712303800004, 124.410916057 8.002354968000077, 124.410475473 7.998912627000038, 124.4104006590001 7.998249996000025, 124.410528911 7.997779742000036, 124.4098581200001 7.996553220000068, 124.4098482500001 7.996529194000058, 124.4106514700001 7.995632130000047, 124.41190624 7.991992960000062, 124.4671228740001 7.968306421000023))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | POINT (124.4328849895758 7.979200795706954) |     124.433 |    7.9792  |      738 |             348 |             35 |            133 |             87 |             68 |             29 |             11 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                19482.1 |                15755.6  |                       14625.9  |                       19274.8 |                       88098.3 |                      610640 |                  15647.5  |                   0 |                711 |              0 |      14625.9  |
|       803 | PH153606011 | Carigongan         | BUBONG                          | LANAO DEL SUR | POLYGON ((124.410916057 8.002354968000077, 124.4070091210001 7.99712303800004, 124.4069152660001 7.997038194000025, 124.406832813 7.996955933000039, 124.4067977240001 7.996923371000037, 124.406740321 7.996870103000048, 124.406705028 7.996837351000068, 124.4066369860001 7.996792191000055, 124.4063749280001 7.996679973000026, 124.4062331270001 7.996648954000023, 124.4060900830001 7.996664267000028, 124.4058074510001 7.996614919000023, 124.4055158460001 7.996475846000067, 124.405282562 7.996408552000046, 124.405053764 7.996439956000074, 124.4046230870001 7.996215645000063, 124.4044032620001 7.996184241000038, 124.4043663590001 7.996052591000022, 124.404140535 7.995865702000061, 124.4040860260001 7.995769662000042, 124.403997773 7.995611326000072, 124.403969221 7.995458182000053, 124.40396321 7.995301300000052, 124.404005363 7.995206159000073, 124.4040271380001 7.995108171000027, 124.4040293150001 7.994975342000034, 124.4040576230001 7.994855578000057, 124.404098996 7.994731459000035, 124.4040193940001 7.994680702000039, 124.4039900710001 7.994686598000044, 124.403892679 7.99465772000002, 124.403763946 7.994569195000054, 124.4036765280001 7.994546503000039, 124.403528574 7.994534036000061, 124.4034765700001 7.994575268000061, 124.40346619 7.994626888000027, 124.4034078730001 7.994657839000068, 124.403310056 7.994620565000048, 124.403260078 7.994649438000065, 124.403214111 7.994734169000026, 124.4031409000001 7.994845960000019, 124.4030262260001 7.994872744000078, 124.4029681320001 7.994833248000019, 124.4029767850001 7.994769055000061, 124.4029693450001 7.994601737000039, 124.402964267 7.994385828000076, 124.402979714 7.994185238000059, 124.403064725 7.994086908000043, 124.40318503 7.993859374000068, 124.4032601660001 7.993708222000065, 124.4029752130001 7.993710109000064, 124.402868522 7.99370996500005, 124.402746459 7.993691780000063, 124.402657211 7.993607644000067, 124.4026101640001 7.993508975000055, 124.4026826830001 7.993386327000054, 124.4027696750001 7.993281012000066, 124.4028786480001 7.99314821400003, 124.402964643 7.993016762000023, 124.4029961910001 7.992829844000028, 124.402945828 7.992561124000077, 124.402848198 7.992412985000045, 124.4027383010001 7.992397856000029, 124.4024787390001 7.992452239000047, 124.4023780600001 7.992551989000051, 124.4023400100001 7.992766209000024, 124.4023009240001 7.993039555000053, 124.4022657480001 7.993258663000061, 124.4021349450001 7.993473331000075, 124.401999625 7.993620251000039, 124.4018699840001 7.993665238000064, 124.4017459690001 7.993613712000069, 124.4016461010001 7.993508208000038, 124.401519608 7.993388964000074, 124.4013209470001 7.993217861000062, 124.40121177 7.994878600000049, 124.40050651 8.003173080000069, 124.4005424090001 8.003906017000077, 124.4009118600001 8.008533980000037, 124.401042003 8.012344567000071, 124.4011851280001 8.01563128600003, 124.401540552 8.016653449000046, 124.4016350320001 8.01767070400007, 124.401718949 8.017785269000058, 124.4020281870001 8.018402354000047, 124.4024784430001 8.019135809000034, 124.402483454 8.019339348000068, 124.4025379950001 8.019567392000056, 124.4026905630001 8.019661399000027, 124.4029946910001 8.019926185000031, 124.4031431850001 8.019984790000027, 124.4032958020001 8.020021245000066, 124.4033738050001 8.020128835000039, 124.4043043850001 8.020614743000065, 124.4053554770001 8.020327697000026, 124.406364839 8.020725756000047, 124.4068159960001 8.02065128600003, 124.407148664 8.02062203400004, 124.4074597440001 8.020629467000049, 124.4077276970001 8.020844355000063, 124.4084190030001 8.021226072000045, 124.408956941 8.021307026000045, 124.409228073 8.021565097000064, 124.4095276100001 8.02188740100007, 124.4098556610001 8.021839128000066, 124.4101524040001 8.02124436500003, 124.4103088700001 8.021564774000067, 124.410358466 8.021631027000071, 124.4108525720001 8.021741772000041, 124.411503271 8.021773666000058, 124.41220995 8.021671517000073, 124.412587397 8.02201652700006, 124.412865946 8.022633481000071, 124.4123640250001 8.015187516000026, 124.410916057 8.002354968000077)) | POINT (124.4061985981631 8.008984375028144) |     124.406 |    8.00898 |      627 |             250 |             21 |            138 |             66 |             72 |             41 |             17 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                16544.3 |                12677.5  |                       10520.9  |                       16335.2 |                       90683.5 |                      609935 |                  12595.4  |                   0 |                605 |              0 |      10520.9  |
|       804 | PH153606012 | Bacolod            | BUBONG                          | LANAO DEL SUR | POLYGON ((124.383677881 7.980710821000058, 124.3806944600001 7.980027540000038, 124.3789808130001 7.979669951000062, 124.3790551280001 7.98143125200005, 124.3790957660001 7.981779750000045, 124.379151565 7.981967484000053, 124.3793145410001 7.982582187000047, 124.379451968 7.983134228000041, 124.3797107590001 7.984232364000034, 124.381409101 7.987550690000036, 124.383323364 7.989303046000034, 124.384126012 7.990034847000059, 124.3839524120001 7.983105138000041, 124.3838051260001 7.98251133700006, 124.383686579 7.982116205000068, 124.383641525 7.981813769000043, 124.383677881 7.980710821000058))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | POINT (124.3818870502832 7.984034476552315) |     124.382 |    7.98403 |      674 |             292 |             23 |            135 |             89 |             58 |             23 |             37 |         0 |          0 |                 0 |                0 |                0 |              0 |            0 |               0 |                0 |                       0 |                      0 |                      0 |                    0 |                  0 |                13840.9 |                10127.1  |                        9189.75 |                       13633.5 |                       87454   |                      606185 |                  10016    |                   0 |                657 |              0 |       9189.75 |


Table: brgy_health_df
|   Column1 | PSGC_BRGY   | NAME_BRGY          | NAME_MUNI                       | NAME_PROV     | geometry                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | centroid                                    |   longitude |   latitude |   num_hospitals |   num_rhus |   hosp_exist |   rhu_exist |   Total_under18 |   Total_18to59 |   Total_over60 |   Male_under18 |   Male_18to59 |   Male_over60 |   Female_under18 |   Female_18to59 |   Female_over60 |   num_hosp_to_children |   num_hosp_to_adults |   num_hosp_to_elderly |   num_rhus_to_children |   num_rhus_to_adults |   num_rhus_to_elderly |   closest_hosp_distance |   closest_rhu_distance |
|----------:|:------------|:-------------------|:--------------------------------|:--------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------|------------:|-----------:|----------------:|-----------:|-------------:|------------:|----------------:|---------------:|---------------:|---------------:|--------------:|--------------:|-----------------:|----------------:|----------------:|-----------------------:|---------------------:|----------------------:|-----------------------:|---------------------:|----------------------:|------------------------:|-----------------------:|
|       795 | PH153601001 | Ampao              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1414685880001 7.856964539000046, 124.1413444870001 7.856853894000039, 124.140988536 7.856521496000026, 124.1407261530001 7.856289160000074, 124.1405663040001 7.856505956000035, 124.140693454 7.856615223000061, 124.1406278820001 7.856723788000066, 124.1405728120001 7.856809728000029, 124.1404831900001 7.856966816000066, 124.1405367630001 7.857502831000032, 124.1401303700001 7.85846326400002, 124.137008421 7.865064083000048, 124.137580778 7.86523827900004, 124.1400454300001 7.859938143000021, 124.140710182 7.858521245000076, 124.1411609690001 7.857373957000051, 124.14131492 7.857124653000028, 124.1414685880001 7.856964539000046))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | POINT (124.1392997553405 7.860807897200258) |     124.139 |    7.86081 |               0 |          0 |            0 |           0 |             394 |            482 |             28 |            181 |           219 |            11 |              213 |             263 |              17 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 8004.8  |                4485.91 |
|       796 | PH153601002 | Bagoaingud         | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1380393380001 7.855043504000036, 124.1380015560001 7.855046647000051, 124.13783707 7.855030558000065, 124.137695127 7.855011106000063, 124.1375433390001 7.855046022000069, 124.137475448 7.855049053000071, 124.1374074150001 7.85500061500005, 124.137281203 7.855058185000074, 124.137155234 7.85515448600006, 124.137084744 7.85525091900007, 124.136622899 7.855295723000039, 124.1364746380001 7.855433572000038, 124.136319929 7.855551591000049, 124.136198162 7.85559319600003, 124.1361883020001 7.855591358000027, 124.136039005 7.855563526000023, 124.1364187280001 7.856380593000039, 124.1363837990001 7.85639479300005, 124.1365759280001 7.856981639000026, 124.1357949130001 7.858697784000073, 124.1349123170001 7.860555307000028, 124.1333165090001 7.864035248000051, 124.134646534 7.864350639000065, 124.137407238 7.858821646000024, 124.137843778 7.857946170000048, 124.1380151550001 7.856285242000068, 124.1379835990001 7.855983991000076, 124.138109802 7.855743427000051, 124.138045098 7.855488740000058, 124.1380812440001 7.855475820000039, 124.138047313 7.855313379000052, 124.138052622 7.855187954000033, 124.1380393380001 7.855043504000036))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | POINT (124.1360409273194 7.859599736138784) |     124.136 |    7.8596  |               0 |          0 |            0 |           0 |             390 |            294 |             12 |            191 |           138 |             9 |              199 |             156 |               3 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 8027.22 |                4208.3  |
|       797 | PH153601004 | Balut              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1583140230001 7.834504480000017, 124.1586668970001 7.834456470000021, 124.1589282910001 7.834309569000026, 124.159201283 7.834107490000065, 124.1595214580001 7.83416376300005, 124.1597890060001 7.834148455000046, 124.1599998710001 7.834110536000027, 124.160095712 7.834010678000026, 124.1600755000001 7.833845749000035, 124.1601692250001 7.833562724000045, 124.1602526080001 7.833382012000071, 124.1603303530001 7.833196496000027, 124.1602452530001 7.833081403000047, 124.1600699910001 7.833003525000037, 124.1600096240001 7.832883624000033, 124.1599335100001 7.832734681000034, 124.1597983890001 7.832697922000023, 124.1596054260001 7.832706138000047, 124.1595627800001 7.832800165000037, 124.159480088 7.832890072000056, 124.159402437 7.832951404000026, 124.159335549 7.832957180000053, 124.1592072830001 7.832934766000053, 124.1590930530001 7.832921517000043, 124.1589996770001 7.832912818000072, 124.1588666350001 7.832818981000058, 124.1587598780001 7.832765808000032, 124.158664109 7.832657096000046, 124.1585268970001 7.832626731000063, 124.158453117 7.832624113000065, 124.1583041240001 7.832567822000042, 124.158220258 7.832585661000055, 124.158196255 7.832656568000063, 124.1580203560001 7.832666396000034, 124.1579371700001 7.832674805000067, 124.1577608340001 7.832873319000042, 124.1576670200001 7.832880305000062, 124.1575894660001 7.832957908000027, 124.1575227100001 7.833005983000019, 124.157479662 7.833077745000026, 124.1574917050001 7.833110379000062, 124.1574361430001 7.833177955000053, 124.1573850460001 7.833156955000047, 124.1572644280001 7.833185356000057, 124.1572258570001 7.833303594000023, 124.1572204080001 7.833350334000047, 124.1571535550001 7.833369264000058, 124.157072767 7.83341275400005, 124.1570488900001 7.833521272000041, 124.156921742 7.833545639000022, 124.156884543 7.833666987000072, 124.1567829260001 7.83369245600005, 124.156796104 7.833775781000043, 124.1566816770001 7.833871071000035, 124.1566082000001 7.833868696000021, 124.1564960710001 7.833954114000049, 124.1564367330001 7.834004632000071, 124.1563518160001 7.834089687000072, 124.15629574 7.834238510000035, 124.1563866170001 7.834344550000026, 124.1565617660001 7.83436841200006, 124.1567705560001 7.834462683000025, 124.1571131560001 7.834457942000028, 124.1572085940001 7.834524671000053, 124.157420772 7.834610239000028, 124.1578156500001 7.834605873000043, 124.1580961980001 7.83452009100006, 124.1583140230001 7.834504480000017))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | POINT (124.158403511832 7.833647189411358)  |     124.158 |    7.83365 |               0 |          0 |            0 |           0 |             288 |            278 |             28 |            134 |           139 |             8 |              154 |             139 |              20 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 4479.15 |                5824.42 |
|       798 | PH153601005 | Barua              | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1482116330001 7.87012118800004, 124.1460619220001 7.867845592000037, 124.140859223 7.869346287000043, 124.137725487 7.870188186000065, 124.135784442 7.870726066000028, 124.134411096 7.871085530000073, 124.0995957680001 7.921072376000041, 124.0957799520001 7.931956739000042, 124.139659445 7.87927251800005, 124.1482116330001 7.87012118800004))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | POINT (124.1234847452403 7.893477255528523) |     124.123 |    7.89348 |               0 |          0 |            0 |           0 |             426 |            361 |             18 |            196 |           193 |            12 |              230 |             168 |               6 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 8602.63 |                3151.27 |
|       799 | PH153601006 | Buadiawani         | BACOLOD-KALAWI (BACOLOD GRANDE) | LANAO DEL SUR | POLYGON ((124.1333165090001 7.864035248000051, 124.1349123170001 7.860555307000028, 124.1357949130001 7.858697784000073, 124.1365759280001 7.856981639000026, 124.1363837990001 7.85639479300005, 124.1364187280001 7.856380593000039, 124.136039005 7.855563526000023, 124.1359399940001 7.855666417000067, 124.1358398140001 7.855683655000065, 124.135605024 7.855712163000021, 124.1354112450001 7.855817080000066, 124.1353585120001 7.855922370000028, 124.1353060070001 7.856126884000048, 124.135364868 7.856272925000042, 124.1353769560001 7.856401701000039, 124.1352015480001 7.856447800000071, 124.1351552550001 7.856540941000047, 124.1349686900001 7.85664194900005, 124.1349444140001 7.856793518000075, 124.134687973 7.856897960000024, 124.1345309320001 7.857008198000075, 124.1343890910001 7.857066513000063, 124.134291026 7.857101348000067, 124.134213594 7.857195054000046, 124.1341291460001 7.857227109000062, 124.1340738800001 7.857278414000063, 124.1339662950001 7.857348520000073, 124.1337596990001 7.857321843000022, 124.1336753510001 7.857286096000053, 124.1335661480001 7.85740195000005, 124.1333042110001 7.857503638000027, 124.1332928710001 7.857508040000029, 124.1332602580001 7.857450798000059, 124.1332232250001 7.857478496000057, 124.133255768 7.857525342000027, 124.1335955740001 7.858178963000055, 124.1318031600001 7.861557891000075, 124.1289464560001 7.866944687000058, 124.1333165090001 7.864035248000051))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | POINT (124.133277602721 7.861066324081695)  |     124.133 |    7.86107 |               0 |          0 |            0 |           0 |             241 |            267 |              5 |            110 |           134 |             4 |              131 |             133 |               1 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 8307.06 |                3863.62 |
|       800 | PH153606006 | Bualan             | BUBONG                          | LANAO DEL SUR | POLYGON ((124.3783536410001 8.005079314000055, 124.376705053 8.000760955000032, 124.3748657100001 7.996179611000061, 124.3746436590001 7.995204440000065, 124.373319142 7.990675109000051, 124.372884341 7.989077249000045, 124.372564312 7.988670866000064, 124.372417484 7.988587627000072, 124.372307824 7.988536362000048, 124.372176039 7.988434507000022, 124.3721022560001 7.988368103000026, 124.372091188 7.988272185000028, 124.3720100270001 7.988157822000063, 124.3719768250001 7.988080350000074, 124.3718587730001 7.987999189000048, 124.371745859 7.987900023000066, 124.3717134360001 7.987872825000064, 124.371674316 7.98779997500003, 124.371564945 7.987729308000041, 124.371488234 7.987658804000033, 124.3713198510001 7.98756668200002, 124.371244377 7.987458786000048, 124.3711275210001 7.987271565000071, 124.370917542 7.987308156000039, 124.3708665180001 7.987592378000043, 124.370808762 7.987871850000032, 124.3707140820001 7.988242410000052, 124.3707085030001 7.988311299000032, 124.3706306460001 7.988559065000059, 124.370363554 7.989114977000042, 124.3699169710001 7.989336864000051, 124.3697504720001 7.989753112000075, 124.3695673230001 7.990335860000073, 124.368836845 7.991878584000061, 124.3687711150001 7.992603716000078, 124.3764322540001 8.009636275000048, 124.3783536410001 8.005079314000055))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | POINT (124.3735129314689 7.99787001034283)  |     124.374 |    7.99787 |               0 |          0 |            0 |           0 |             258 |            329 |             21 |            111 |           162 |            11 |              147 |             167 |              10 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 8009.02 |                1729.73 |
|       801 | PH153606007 | Poblacion (Bubong) | BUBONG                          | LANAO DEL SUR | POLYGON ((124.3656385480001 7.983576224000045, 124.365469648 7.983547724000058, 124.365123721 7.983583204000069, 124.3648603180001 7.983484581000027, 124.36461637 7.983450534000042, 124.364491152 7.983352994000031, 124.3641234920001 7.982818312000063, 124.3637561410001 7.982385880000037, 124.3634354860001 7.982121029000039, 124.3632020350001 7.982144287000037, 124.3631355150001 7.982243889000077, 124.3630903070001 7.982421553000052, 124.3630492330001 7.982673953000075, 124.3629421600001 7.982994803000052, 124.3627305690001 7.983203001000049, 124.3623508970001 7.983356250000044, 124.3620630520001 7.983530363000056, 124.3618534310001 7.98368441600007, 124.3615327600001 7.983784283000034, 124.3613011120001 7.983812192000074, 124.3610760190001 7.983778273000038, 124.360875197 7.983713137000053, 124.3607680540001 7.983575897000036, 124.3606259430001 7.983291656000064, 124.3604490480001 7.982945558000039, 124.360112209 7.982625251000059, 124.3598876020001 7.982330274000047, 124.35987991 7.98213799800004, 124.3598042220001 7.982394114000044, 124.3592359610001 7.982951219000027, 124.355773095 7.983013061000067, 124.3565567210001 7.986300469000069, 124.3632965320001 7.986324215000026, 124.3632965320001 7.985790314000043, 124.363814936 7.985787128000026, 124.364733686 7.985774945000059, 124.3647385400001 7.985713407000047, 124.36486376 7.985676200000057, 124.3649612610001 7.985658809000028, 124.3650779430001 7.985636673000045, 124.3652361820001 7.985627209000028, 124.3653848230001 7.985646234000058, 124.365406902 7.985651981000045, 124.3654408000001 7.985500520000072, 124.3656118710001 7.985191970000074, 124.365617409 7.983808014000032, 124.3656385480001 7.983576224000045))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | POINT (124.3606410157623 7.984574832846461) |     124.361 |    7.98457 |               0 |          0 |            0 |           0 |             335 |            271 |              7 |            150 |           128 |             3 |              185 |             143 |               4 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 6814.01 |                2341.26 |
|       802 | PH153606008 | Bubonga Didagun    | BUBONG                          | LANAO DEL SUR | POLYGON ((124.4671228740001 7.968306421000023, 124.4578153540001 7.962843312000076, 124.4040407140001 7.987786711000071, 124.403336049 7.993589391000057, 124.403295982 7.993649602000062, 124.4032601660001 7.993708222000065, 124.40318503 7.993859374000068, 124.403064725 7.994086908000043, 124.402979714 7.994185238000059, 124.402964267 7.994385828000076, 124.4029693450001 7.994601737000039, 124.4029767850001 7.994769055000061, 124.4029681320001 7.994833248000019, 124.4030262260001 7.994872744000078, 124.4031409000001 7.994845960000019, 124.403214111 7.994734169000026, 124.403260078 7.994649438000065, 124.403310056 7.994620565000048, 124.4034078730001 7.994657839000068, 124.40346619 7.994626888000027, 124.4034765700001 7.994575268000061, 124.403528574 7.994534036000061, 124.4036765280001 7.994546503000039, 124.403763946 7.994569195000054, 124.403892679 7.99465772000002, 124.4039900710001 7.994686598000044, 124.4040193940001 7.994680702000039, 124.404098996 7.994731459000035, 124.4040576230001 7.994855578000057, 124.4040293150001 7.994975342000034, 124.4040271380001 7.995108171000027, 124.404005363 7.995206159000073, 124.40396321 7.995301300000052, 124.403969221 7.995458182000053, 124.403997773 7.995611326000072, 124.4040860260001 7.995769662000042, 124.404140535 7.995865702000061, 124.4043663590001 7.996052591000022, 124.4044032620001 7.996184241000038, 124.4046230870001 7.996215645000063, 124.405053764 7.996439956000074, 124.405282562 7.996408552000046, 124.4055158460001 7.996475846000067, 124.4058074510001 7.996614919000023, 124.4060900830001 7.996664267000028, 124.4062331270001 7.996648954000023, 124.4063749280001 7.996679973000026, 124.4066369860001 7.996792191000055, 124.406705028 7.996837351000068, 124.406740321 7.996870103000048, 124.4067977240001 7.996923371000037, 124.406832813 7.996955933000039, 124.4069152660001 7.997038194000025, 124.4070091210001 7.99712303800004, 124.410916057 8.002354968000077, 124.410475473 7.998912627000038, 124.4104006590001 7.998249996000025, 124.410528911 7.997779742000036, 124.4098581200001 7.996553220000068, 124.4098482500001 7.996529194000058, 124.4106514700001 7.995632130000047, 124.41190624 7.991992960000062, 124.4671228740001 7.968306421000023))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | POINT (124.4328849895758 7.979200795706954) |     124.433 |    7.9792  |               0 |          0 |            0 |           0 |             410 |            317 |             11 |            203 |           151 |             8 |              207 |             166 |               3 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                14729.7  |                5141.63 |
|       803 | PH153606011 | Carigongan         | BUBONG                          | LANAO DEL SUR | POLYGON ((124.410916057 8.002354968000077, 124.4070091210001 7.99712303800004, 124.4069152660001 7.997038194000025, 124.406832813 7.996955933000039, 124.4067977240001 7.996923371000037, 124.406740321 7.996870103000048, 124.406705028 7.996837351000068, 124.4066369860001 7.996792191000055, 124.4063749280001 7.996679973000026, 124.4062331270001 7.996648954000023, 124.4060900830001 7.996664267000028, 124.4058074510001 7.996614919000023, 124.4055158460001 7.996475846000067, 124.405282562 7.996408552000046, 124.405053764 7.996439956000074, 124.4046230870001 7.996215645000063, 124.4044032620001 7.996184241000038, 124.4043663590001 7.996052591000022, 124.404140535 7.995865702000061, 124.4040860260001 7.995769662000042, 124.403997773 7.995611326000072, 124.403969221 7.995458182000053, 124.40396321 7.995301300000052, 124.404005363 7.995206159000073, 124.4040271380001 7.995108171000027, 124.4040293150001 7.994975342000034, 124.4040576230001 7.994855578000057, 124.404098996 7.994731459000035, 124.4040193940001 7.994680702000039, 124.4039900710001 7.994686598000044, 124.403892679 7.99465772000002, 124.403763946 7.994569195000054, 124.4036765280001 7.994546503000039, 124.403528574 7.994534036000061, 124.4034765700001 7.994575268000061, 124.40346619 7.994626888000027, 124.4034078730001 7.994657839000068, 124.403310056 7.994620565000048, 124.403260078 7.994649438000065, 124.403214111 7.994734169000026, 124.4031409000001 7.994845960000019, 124.4030262260001 7.994872744000078, 124.4029681320001 7.994833248000019, 124.4029767850001 7.994769055000061, 124.4029693450001 7.994601737000039, 124.402964267 7.994385828000076, 124.402979714 7.994185238000059, 124.403064725 7.994086908000043, 124.40318503 7.993859374000068, 124.4032601660001 7.993708222000065, 124.4029752130001 7.993710109000064, 124.402868522 7.99370996500005, 124.402746459 7.993691780000063, 124.402657211 7.993607644000067, 124.4026101640001 7.993508975000055, 124.4026826830001 7.993386327000054, 124.4027696750001 7.993281012000066, 124.4028786480001 7.99314821400003, 124.402964643 7.993016762000023, 124.4029961910001 7.992829844000028, 124.402945828 7.992561124000077, 124.402848198 7.992412985000045, 124.4027383010001 7.992397856000029, 124.4024787390001 7.992452239000047, 124.4023780600001 7.992551989000051, 124.4023400100001 7.992766209000024, 124.4023009240001 7.993039555000053, 124.4022657480001 7.993258663000061, 124.4021349450001 7.993473331000075, 124.401999625 7.993620251000039, 124.4018699840001 7.993665238000064, 124.4017459690001 7.993613712000069, 124.4016461010001 7.993508208000038, 124.401519608 7.993388964000074, 124.4013209470001 7.993217861000062, 124.40121177 7.994878600000049, 124.40050651 8.003173080000069, 124.4005424090001 8.003906017000077, 124.4009118600001 8.008533980000037, 124.401042003 8.012344567000071, 124.4011851280001 8.01563128600003, 124.401540552 8.016653449000046, 124.4016350320001 8.01767070400007, 124.401718949 8.017785269000058, 124.4020281870001 8.018402354000047, 124.4024784430001 8.019135809000034, 124.402483454 8.019339348000068, 124.4025379950001 8.019567392000056, 124.4026905630001 8.019661399000027, 124.4029946910001 8.019926185000031, 124.4031431850001 8.019984790000027, 124.4032958020001 8.020021245000066, 124.4033738050001 8.020128835000039, 124.4043043850001 8.020614743000065, 124.4053554770001 8.020327697000026, 124.406364839 8.020725756000047, 124.4068159960001 8.02065128600003, 124.407148664 8.02062203400004, 124.4074597440001 8.020629467000049, 124.4077276970001 8.020844355000063, 124.4084190030001 8.021226072000045, 124.408956941 8.021307026000045, 124.409228073 8.021565097000064, 124.4095276100001 8.02188740100007, 124.4098556610001 8.021839128000066, 124.4101524040001 8.02124436500003, 124.4103088700001 8.021564774000067, 124.410358466 8.021631027000071, 124.4108525720001 8.021741772000041, 124.411503271 8.021773666000058, 124.41220995 8.021671517000073, 124.412587397 8.02201652700006, 124.412865946 8.022633481000071, 124.4123640250001 8.015187516000026, 124.410916057 8.002354968000077)) | POINT (124.4061985981631 8.008984375028144) |     124.406 |    8.00898 |               0 |          0 |            0 |           0 |             293 |            317 |             17 |            153 |           162 |            11 |              140 |             155 |               6 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                11644.2  |                2783.59 |
|       804 | PH153606012 | Bacolod            | BUBONG                          | LANAO DEL SUR | POLYGON ((124.383677881 7.980710821000058, 124.3806944600001 7.980027540000038, 124.3789808130001 7.979669951000062, 124.3790551280001 7.98143125200005, 124.3790957660001 7.981779750000045, 124.379151565 7.981967484000053, 124.3793145410001 7.982582187000047, 124.379451968 7.983134228000041, 124.3797107590001 7.984232364000034, 124.381409101 7.987550690000036, 124.383323364 7.989303046000034, 124.384126012 7.990034847000059, 124.3839524120001 7.983105138000041, 124.3838051260001 7.98251133700006, 124.383686579 7.982116205000068, 124.383641525 7.981813769000043, 124.383677881 7.980710821000058))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | POINT (124.3818870502832 7.984034476552315) |     124.382 |    7.98403 |               0 |          0 |            0 |           0 |             332 |            305 |             37 |            158 |           153 |            14 |              174 |             152 |              23 |                      0 |                    0 |                     0 |                      0 |                    0 |                     0 |                 9107.12 |                1079.79 |


Table: educ_df
| PSGC_BRGY   | geometry                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | centroid                                    |   longitude |   latitude | PSGC_MUNI   | PSGC_PROV   |   num_MD |   num_SUC |   BRGY_SCHOOLS |   num_ES |   num_JHS |   num_SHS |   elem_age_pop |   jhs_age_pop |   shs_age_pop |   suc_age_pop |   num_elem_to_elem_age_pop |   num_jhs_to_jhs_age_pop |   num_shs_to_shs_age_pop |   num_suc_to_suc_age_pop |   closest_ES_distance |   closest_JHS_distance |   closest_SHS_distance |   closest_SUC_distance |
|:------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------|------------:|-----------:|:------------|:------------|---------:|----------:|---------------:|---------:|----------:|----------:|---------------:|--------------:|--------------:|--------------:|---------------------------:|-------------------------:|-------------------------:|-------------------------:|----------------------:|-----------------------:|-----------------------:|-----------------------:|
| PH153601001 | POLYGON ((124.1414685880001 7.856964539000046, 124.1413444870001 7.856853894000039, 124.140988536 7.856521496000026, 124.1407261530001 7.856289160000074, 124.1405663040001 7.856505956000035, 124.140693454 7.856615223000061, 124.1406278820001 7.856723788000066, 124.1405728120001 7.856809728000029, 124.1404831900001 7.856966816000066, 124.1405367630001 7.857502831000032, 124.1401303700001 7.85846326400002, 124.137008421 7.865064083000048, 124.137580778 7.86523827900004, 124.1400454300001 7.859938143000021, 124.140710182 7.858521245000076, 124.1411609690001 7.857373957000051, 124.14131492 7.857124653000028, 124.1414685880001 7.856964539000046))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | POINT (124.1392997553405 7.860807897200258) |     124.139 |    7.86081 | PH153601000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            119 |            64 |            33 |           104 |                 0.00840336 |                        0 |                        0 |                        0 |               349.388 |               1060.63  |                479.58  |                4784.69 |
| PH153601005 | POLYGON ((124.1482116330001 7.87012118800004, 124.1460619220001 7.867845592000037, 124.140859223 7.869346287000043, 124.137725487 7.870188186000065, 124.135784442 7.870726066000028, 124.134411096 7.871085530000073, 124.0995957680001 7.921072376000041, 124.0957799520001 7.931956739000042, 124.139659445 7.87927251800005, 124.1482116330001 7.87012118800004))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | POINT (124.1234847452403 7.893477255528523) |     124.123 |    7.89348 | PH153601000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            147 |            81 |            32 |            86 |                 0.00680272 |                        0 |                        0 |                        0 |              1930.57  |               4103.82  |               4393.34  |                6115.73 |
| PH153601006 | POLYGON ((124.1333165090001 7.864035248000051, 124.1349123170001 7.860555307000028, 124.1357949130001 7.858697784000073, 124.1365759280001 7.856981639000026, 124.1363837990001 7.85639479300005, 124.1364187280001 7.856380593000039, 124.136039005 7.855563526000023, 124.1359399940001 7.855666417000067, 124.1358398140001 7.855683655000065, 124.135605024 7.855712163000021, 124.1354112450001 7.855817080000066, 124.1353585120001 7.855922370000028, 124.1353060070001 7.856126884000048, 124.135364868 7.856272925000042, 124.1353769560001 7.856401701000039, 124.1352015480001 7.856447800000071, 124.1351552550001 7.856540941000047, 124.1349686900001 7.85664194900005, 124.1349444140001 7.856793518000075, 124.134687973 7.856897960000024, 124.1345309320001 7.857008198000075, 124.1343890910001 7.857066513000063, 124.134291026 7.857101348000067, 124.134213594 7.857195054000046, 124.1341291460001 7.857227109000062, 124.1340738800001 7.857278414000063, 124.1339662950001 7.857348520000073, 124.1337596990001 7.857321843000022, 124.1336753510001 7.857286096000053, 124.1335661480001 7.85740195000005, 124.1333042110001 7.857503638000027, 124.1332928710001 7.857508040000029, 124.1332602580001 7.857450798000059, 124.1332232250001 7.857478496000057, 124.133255768 7.857525342000027, 124.1335955740001 7.858178963000055, 124.1318031600001 7.861557891000075, 124.1289464560001 7.866944687000058, 124.1333165090001 7.864035248000051))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | POINT (124.133277602721 7.861066324081695)  |     124.133 |    7.86107 | PH153601000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |             79 |            56 |            22 |            41 |                 0.0126582  |                        0 |                        0 |                        0 |               423.765 |               1080.74  |               1127.91  |                5366.53 |
| PH153606011 | POLYGON ((124.410916057 8.002354968000077, 124.4070091210001 7.99712303800004, 124.4069152660001 7.997038194000025, 124.406832813 7.996955933000039, 124.4067977240001 7.996923371000037, 124.406740321 7.996870103000048, 124.406705028 7.996837351000068, 124.4066369860001 7.996792191000055, 124.4063749280001 7.996679973000026, 124.4062331270001 7.996648954000023, 124.4060900830001 7.996664267000028, 124.4058074510001 7.996614919000023, 124.4055158460001 7.996475846000067, 124.405282562 7.996408552000046, 124.405053764 7.996439956000074, 124.4046230870001 7.996215645000063, 124.4044032620001 7.996184241000038, 124.4043663590001 7.996052591000022, 124.404140535 7.995865702000061, 124.4040860260001 7.995769662000042, 124.403997773 7.995611326000072, 124.403969221 7.995458182000053, 124.40396321 7.995301300000052, 124.404005363 7.995206159000073, 124.4040271380001 7.995108171000027, 124.4040293150001 7.994975342000034, 124.4040576230001 7.994855578000057, 124.404098996 7.994731459000035, 124.4040193940001 7.994680702000039, 124.4039900710001 7.994686598000044, 124.403892679 7.99465772000002, 124.403763946 7.994569195000054, 124.4036765280001 7.994546503000039, 124.403528574 7.994534036000061, 124.4034765700001 7.994575268000061, 124.40346619 7.994626888000027, 124.4034078730001 7.994657839000068, 124.403310056 7.994620565000048, 124.403260078 7.994649438000065, 124.403214111 7.994734169000026, 124.4031409000001 7.994845960000019, 124.4030262260001 7.994872744000078, 124.4029681320001 7.994833248000019, 124.4029767850001 7.994769055000061, 124.4029693450001 7.994601737000039, 124.402964267 7.994385828000076, 124.402979714 7.994185238000059, 124.403064725 7.994086908000043, 124.40318503 7.993859374000068, 124.4032601660001 7.993708222000065, 124.4029752130001 7.993710109000064, 124.402868522 7.99370996500005, 124.402746459 7.993691780000063, 124.402657211 7.993607644000067, 124.4026101640001 7.993508975000055, 124.4026826830001 7.993386327000054, 124.4027696750001 7.993281012000066, 124.4028786480001 7.99314821400003, 124.402964643 7.993016762000023, 124.4029961910001 7.992829844000028, 124.402945828 7.992561124000077, 124.402848198 7.992412985000045, 124.4027383010001 7.992397856000029, 124.4024787390001 7.992452239000047, 124.4023780600001 7.992551989000051, 124.4023400100001 7.992766209000024, 124.4023009240001 7.993039555000053, 124.4022657480001 7.993258663000061, 124.4021349450001 7.993473331000075, 124.401999625 7.993620251000039, 124.4018699840001 7.993665238000064, 124.4017459690001 7.993613712000069, 124.4016461010001 7.993508208000038, 124.401519608 7.993388964000074, 124.4013209470001 7.993217861000062, 124.40121177 7.994878600000049, 124.40050651 8.003173080000069, 124.4005424090001 8.003906017000077, 124.4009118600001 8.008533980000037, 124.401042003 8.012344567000071, 124.4011851280001 8.01563128600003, 124.401540552 8.016653449000046, 124.4016350320001 8.01767070400007, 124.401718949 8.017785269000058, 124.4020281870001 8.018402354000047, 124.4024784430001 8.019135809000034, 124.402483454 8.019339348000068, 124.4025379950001 8.019567392000056, 124.4026905630001 8.019661399000027, 124.4029946910001 8.019926185000031, 124.4031431850001 8.019984790000027, 124.4032958020001 8.020021245000066, 124.4033738050001 8.020128835000039, 124.4043043850001 8.020614743000065, 124.4053554770001 8.020327697000026, 124.406364839 8.020725756000047, 124.4068159960001 8.02065128600003, 124.407148664 8.02062203400004, 124.4074597440001 8.020629467000049, 124.4077276970001 8.020844355000063, 124.4084190030001 8.021226072000045, 124.408956941 8.021307026000045, 124.409228073 8.021565097000064, 124.4095276100001 8.02188740100007, 124.4098556610001 8.021839128000066, 124.4101524040001 8.02124436500003, 124.4103088700001 8.021564774000067, 124.410358466 8.021631027000071, 124.4108525720001 8.021741772000041, 124.411503271 8.021773666000058, 124.41220995 8.021671517000073, 124.412587397 8.02201652700006, 124.412865946 8.022633481000071, 124.4123640250001 8.015187516000026, 124.410916057 8.002354968000077))                                                                                  | POINT (124.4061985981631 8.008984375028144) |     124.406 |    8.00898 | PH153606000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            101 |            71 |            21 |            69 |                 0.00990099 |                        0 |                        0 |                        0 |              1386.23  |               3669.99  |               4820.84  |                5938.37 |
| PH153606015 | POLYGON ((124.4032601660001 7.993708222000065, 124.403295982 7.993649602000062, 124.403336049 7.993589391000057, 124.4040407140001 7.987786711000071, 124.4024230810001 7.986012334000067, 124.4022452360001 7.985859517000051, 124.4020610150001 7.985685547000059, 124.401886739 7.985398286000075, 124.4018757040001 7.985096950000073, 124.4020047560001 7.984929758000019, 124.4022494770001 7.98471405400005, 124.402347165 7.983861512000033, 124.4023205230001 7.983621734000052, 124.4011300860001 7.979124465000043, 124.3964685770001 7.981238844000077, 124.396541389 7.982054939000021, 124.39483066 7.984812143000054, 124.394173289 7.985912831000061, 124.394287886 7.986530733000051, 124.394448889 7.987028091000068, 124.3945917000001 7.988752448000071, 124.394708378 7.988807245000032, 124.3949285810001 7.988910915000076, 124.3949817260001 7.988950398000043, 124.395072353 7.989017429000057, 124.3951552750001 7.989148192000072, 124.395134908 7.989327737000053, 124.3951050000001 7.989483098000051, 124.395032796 7.98962570600003, 124.3948443070001 7.989664787000036, 124.394745959 7.989622169000029, 124.394619893 7.989582547000056, 124.3944630890001 7.989545927000052, 124.39434886 7.989633583000056, 124.3943358130001 7.989796902000022, 124.3943913630001 7.990021730000024, 124.3944131220001 7.990190491000021, 124.394456413 7.990348452000036, 124.394549018 7.990524869000069, 124.3947145110001 7.990699989000066, 124.3948345440001 7.990900669000039, 124.394926389 7.991098389000058, 124.394990568 7.991262498000025, 124.395030192 7.991396104000047, 124.3951191470001 7.991450800000052, 124.3952513410001 7.991435745000046, 124.3953655350001 7.991311340000039, 124.395452168 7.991180695000026, 124.3954522030001 7.991171572000044, 124.3954867270001 7.99098596700003, 124.3954875220001 7.990781848000038, 124.39542052 7.990583577000052, 124.3952999980001 7.990458816000058, 124.3952192510001 7.990316136000043, 124.3952806100001 7.990176216000066, 124.395363681 7.990069634000064, 124.3955178650001 7.990069301000061, 124.39568092 7.990084508000053, 124.3958440800001 7.990166671000055, 124.395966873 7.990285569000037, 124.3962063620001 7.990590222000038, 124.3963937620001 7.990909971000066, 124.3965420000001 7.99110262600004, 124.3965935230001 7.991279510000025, 124.396552947 7.991440960000035, 124.3964511840001 7.991562690000023, 124.396349459 7.991696487000071, 124.3963490630001 7.991814996000074, 124.3964037070001 7.991972877000023, 124.3965775270001 7.992191235000067, 124.3967271150001 7.992300309000027, 124.3969277640001 7.992315118000024, 124.3971093230001 7.992300737000049, 124.397160062 7.992296256000031, 124.397325861 7.99222334600006, 124.3975689230001 7.992213812000045, 124.397932843 7.992291594000048, 124.398237158 7.992368828000053, 124.398620033 7.992420171000049, 124.3989812460001 7.99246676000007, 124.3991327860001 7.992571912000074, 124.3993195150001 7.992731661000049, 124.399481204 7.992852291000076, 124.3996702620001 7.992888634000053, 124.3998469640001 7.992840532000062, 124.400032064 7.99272899600004, 124.4002807930001 7.99267489600004, 124.400534016 7.992720450000036, 124.4007810200001 7.992835241000022, 124.401074912 7.993056031000035, 124.401134274 7.993098235000048, 124.4013209470001 7.993217861000062, 124.401519608 7.993388964000074, 124.4016461010001 7.993508208000038, 124.4017459690001 7.993613712000069, 124.4018699840001 7.993665238000064, 124.401999625 7.993620251000039, 124.4021349450001 7.993473331000075, 124.4022657480001 7.993258663000061, 124.4023009240001 7.993039555000053, 124.4023400100001 7.992766209000024, 124.4023780600001 7.992551989000051, 124.4024787390001 7.992452239000047, 124.4027383010001 7.992397856000029, 124.402848198 7.992412985000045, 124.402945828 7.992561124000077, 124.4029961910001 7.992829844000028, 124.402964643 7.993016762000023, 124.4028786480001 7.99314821400003, 124.4027696750001 7.993281012000066, 124.4026826830001 7.993386327000054, 124.4026101640001 7.993508975000055, 124.402657211 7.993607644000067, 124.402746459 7.993691780000063, 124.402868522 7.99370996500005, 124.4029752130001 7.993710109000064, 124.4032601660001 7.993708222000065)) | POINT (124.3992200364748 7.986929173262192) |     124.399 |    7.98693 | PH153606000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            122 |            77 |            37 |            61 |                 0.00819672 |                        0 |                        0 |                        0 |               147.675 |               1601.15  |               3401.32  |                4263.78 |
| PH153617025 | POLYGON ((124.2579096290001 8.001123468000058, 124.2578730030001 8.001121125000054, 124.2577586440001 8.001096063000034, 124.257393813 8.000997221000034, 124.2572551390001 8.000944377000055, 124.257126283 8.000894675000042, 124.2570344110001 8.000827880000031, 124.2569254680001 8.000703702000068, 124.2567533 8.000442959000052, 124.256681682 8.000315816000066, 124.2564912370001 8.000343221000035, 124.255954833 8.00038205200002, 124.2552455150001 8.000424118000067, 124.2550168180001 8.00043913600007, 124.2543213570001 8.000466045000053, 124.254115153 8.000475823000047, 124.253658177 8.000502608000033, 124.252905015 8.000563396000077, 124.252366099 8.00063239900004, 124.2523928190001 8.000684038000031, 124.252376194 8.000889939000047, 124.2520671310001 8.00529841900004, 124.2517369770001 8.00650554200007, 124.2538523330001 8.007141392000054, 124.255056188 8.007504223000071, 124.2560151620001 8.007776221000029, 124.256804288 8.004928538000057, 124.2569475570001 8.004335290000027, 124.257039219 8.00367951000004, 124.2571838820001 8.003291213000068, 124.2572846410001 8.002953314000024, 124.2574089450001 8.002623096000036, 124.2575448780001 8.002248179000048, 124.257638033 8.00196966200002, 124.2577468330001 8.001678260000062, 124.2577618500001 8.001634077000062, 124.2578004190001 8.001520096000037, 124.2579096290001 8.001123468000058))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | POINT (124.2546663245534 8.003735823837557) |     124.255 |    8.00374 | PH153617000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            752 |           438 |           213 |           510 |                 0.00132979 |                        0 |                        0 |                        0 |               333.071 |                965.7   |               1519.89  |                 583.36 |
| PH153631015 | POLYGON ((124.1625893890001 7.625573479000025, 124.1622427780001 7.625389571000028, 124.161375915 7.625232186000063, 124.158964232 7.624523417000035, 124.1586292210001 7.624416326000073, 124.1429026650001 7.619723332000035, 124.1408577510001 7.620138751000068, 124.141851542 7.628209021000031, 124.1419806390001 7.629296410000054, 124.1432907240001 7.640817710000019, 124.165933643 7.642265527000062, 124.1668594790001 7.638688314000035, 124.166773678 7.638157775000025, 124.1669085840001 7.637436583000067, 124.166342811 7.635603883000044, 124.166336728 7.635261227000056, 124.166429235 7.63477332100007, 124.1665077190001 7.634260763000042, 124.1663352940001 7.633418175000031, 124.166321915 7.632808798000041, 124.1663916340001 7.632400305000034, 124.1664342700001 7.63197760400004, 124.1657954630001 7.630904159000068, 124.1655185080001 7.630330660000027, 124.1653982510001 7.629900477000035, 124.1651062420001 7.629568036000025, 124.164164173 7.629166339000051, 124.1638992160001 7.628961451000067, 124.1637925880001 7.628525434000042, 124.163830371 7.62808204600003, 124.1638080190001 7.627746656000055, 124.163599802 7.62733580500003, 124.163233063 7.626972641000068, 124.1629448460001 7.626661053000023, 124.162852549 7.626213747000063, 124.1625893890001 7.625573479000025))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | POINT (124.1533584363669 7.632113256224744) |     124.153 |    7.63211 | PH153631000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            107 |            42 |            13 |            38 |                 0.00934579 |                        0 |                        0 |                        0 |              4395.35  |               2599.74  |               4962.33  |               10593.5  |
| PH153634055 | POLYGON ((124.3714505190001 7.890694592000044, 124.3713276090001 7.890730619000067, 124.3710000470001 7.890662948000057, 124.3706577270001 7.89060131800005, 124.3703921000001 7.890662413000028, 124.3700256760001 7.890804573000025, 124.3697748080001 7.891127118000044, 124.369530013 7.891328874000066, 124.3693481450001 7.891480171000071, 124.3690572520001 7.891578538000034, 124.3689274680001 7.891427151000075, 124.3688781200001 7.891255179000042, 124.3689658850001 7.890999891000037, 124.3691131600001 7.890897123000059, 124.3692527070001 7.890804339000058, 124.369678256 7.890515226000047, 124.369920017 7.890197324000042, 124.370063425 7.889878463000056, 124.3699122610001 7.889691132000054, 124.3694715590001 7.889669923000041, 124.3691155280001 7.889780649000047, 124.3688458900001 7.890128357000038, 124.3687379210001 7.890425335000034, 124.368392618 7.890848733000039, 124.3682119140001 7.890959848000024, 124.368054872 7.891054548000057, 124.367678262 7.891073361000053, 124.3673235220001 7.890995075000034, 124.367019742 7.890935451000076, 124.3666568680001 7.890679138000054, 124.366595888 7.890522553000038, 124.3664578780001 7.890202139000055, 124.366482517 7.889787458000058, 124.366444279 7.889400684000064, 124.3662169740001 7.889080525000054, 124.365814255 7.88891037600007, 124.365231726 7.888601152000036, 124.3641720820001 7.889732093000017, 124.3640125950001 7.889826879000054, 124.3640484750001 7.889870313000074, 124.3638009560001 7.89009221600003, 124.363430351 7.895307291000051, 124.363007312 7.900097392000022, 124.363027395 7.900108522000036, 124.365151534 7.901629543000068, 124.3664325000001 7.902548306000029, 124.368359357 7.903953753000053, 124.36902792 7.904442911000047, 124.3713296410001 7.891817541000025, 124.3714505190001 7.890694592000044))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | POINT (124.3670149280286 7.896087276324386) |     124.367 |    7.89609 | PH153634000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            141 |            87 |            47 |            90 |                 0.0070922  |                        0 |                        0 |                        0 |               511.196 |               1097.83  |               2355.1   |                1720.18 |
| PH153601011 | POLYGON ((124.1425616020001 7.85726095600006, 124.1425211950001 7.857180423000047, 124.1424969510001 7.857054295000069, 124.1424968390001 7.857048852000049, 124.142511527 7.856971116000067, 124.1425898540001 7.856923317000052, 124.1425836670001 7.856881772000068, 124.142505429 7.856870596000019, 124.1424757670001 7.85675682100003, 124.1425803210001 7.856683239000061, 124.142545766 7.85660869000003, 124.1424193490001 7.85667618700006, 124.1423645450001 7.856608072000024, 124.1423089040001 7.856481884000059, 124.142275452 7.856383424000057, 124.142008709 7.856511083000043, 124.141748891 7.856766571000039, 124.1417043500001 7.856753492000052, 124.1414685880001 7.856964539000046, 124.14131492 7.857124653000028, 124.1411609690001 7.857373957000051, 124.140710182 7.858521245000076, 124.1400454300001 7.859938143000021, 124.137580778 7.86523827900004, 124.138178679 7.865538921000051, 124.1407893520001 7.860324819000026, 124.1422970910001 7.857573214000068, 124.1425616020001 7.85726095600006))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | POINT (124.1401919291039 7.860645697006387) |     124.14  |    7.86065 | PH153604000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |             95 |            51 |            32 |            64 |                 0.0105263  |                        0 |                        0 |                        0 |               266.567 |                985.545 |                382.106 |                4706.99 |
| PH153601014 | POLYGON ((124.139642543 7.854954133000034, 124.139573754 7.854554536000022, 124.139421122 7.854612024000064, 124.139328728 7.854641296000068, 124.1389999750001 7.854745452000031, 124.1390158800001 7.854837050000071, 124.138945495 7.85483610400007, 124.138930873 7.855205526000021, 124.138912331 7.855413645000053, 124.138854013 7.855808828000023, 124.138713646 7.858025249000036, 124.138204888 7.859082971000022, 124.1355768330001 7.864601405000028, 124.1359230730001 7.864687965000032, 124.1362494250001 7.864802790000055, 124.138786672 7.859228417000051, 124.1393462770001 7.858005480000034, 124.1394603560001 7.856188496000073, 124.1395079470001 7.855904538000059, 124.1395513960001 7.855890122000061, 124.139573701 7.855782459000068, 124.139529354 7.855731937000031, 124.139551222 7.855501636000042, 124.1396020780001 7.855223101000036, 124.1395981320001 7.855106309000062, 124.13965496 7.855043740000043, 124.139642543 7.854954133000034))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | POINT (124.1379741093428 7.859828001828677) |     124.138 |    7.85983 | PH153611000 | PH153600000 |        0 |         0 |              1 |        1 |         0 |         0 |            136 |            69 |            29 |            63 |                 0.00735294 |                        0 |                        0 |                        0 |               433.832 |               1241.43  |                595.545 |                4964.93 |


Table: Muni_wClusters
|   Column1 | PSGC_MUNI   |   muni_area |    LONG |     LAT |   Pop2010 |   Pop2015 |   HH_pop |   num_hh0 |   num_hh0_mal |   num_hh0_fem |   num_hh0_both |   Total_under10 |   Total_10to20 |   Total_21to30 |   Total_31to44 |   Total_45to60 |   Total_over60 |   Male_under10 |   Male_10to20 |   Male_21to30 |   Male_31to44 |   Male_45to60 |   Male_over60 |   Female_under10 |   Female_10to20 |   Female_21to30 |   Female_31to44 |   Female_45to60 |   Female_over60 |   Pop_Density_2010 |   Pop_Density_2015 |   MUNI_tot_15_ovr_both_sexes |   MUNI_man_15_ovr_both_sexes |   MUNI_pro_15_ovr_both_sexes |   MUNI_tec_15_ovr_both_sexes |   MUNI_cle_15_ovr_both_sexes |   MUNI_ser_15_ovr_both_sexes |   MUNI_ski_15_ovr_both_sexes |   MUNI_cra_15_ovr_both_sexes |   MUNI_pla_15_ovr_both_sexes |   MUNI_ele_15_ovr_both_sexes |   MUNI_arm_15_ovr_both_sexes |   MUNI_oth_15_ovr_both_sexes |   MUNI_oth_15_ovr_both_sexes.1 |   On-site |   Off-site |   Total |   On_site_over_muni_area |   Off_site_over_muni_area |   Total_Banks_over_muni_area |   Bank_Count |   Firm_Count |   MUNI_Establishment_Count |   Hospital |   Rural Health Unit |   hosp_over_muni_area |   rhus_over_muni_area |   SCHOOLS_total |   SCHOOLS_total_over_muni_area |   SCHOOLS_CES |   SCHOOLS_ES |   SCHOOLS_JHS |   SCHOOLS_MD |   SCHOOLS_PES |   SCHOOLS_PJHS |   SCHOOLS_PS |   SCHOOLS_PSHS |   SCHOOLS_SHS |   SCHOOLS_SUC |   Cluster | MUNI_NAME                      | PSGC_PROV   | PROV_NAME     | Cluster_Txt   | Pop2015_over_hosp   |   Pop2015_over_RHUs |   Bank_over_area |
|----------:|:------------|------------:|--------:|--------:|----------:|----------:|---------:|----------:|--------------:|--------------:|---------------:|----------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|--------------:|--------------:|--------------:|--------------:|--------------:|-----------------:|----------------:|----------------:|----------------:|----------------:|----------------:|-------------------:|-------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-------------------------------:|----------:|-----------:|--------:|-------------------------:|--------------------------:|-----------------------------:|-------------:|-------------:|---------------------------:|-----------:|--------------------:|----------------------:|----------------------:|----------------:|-------------------------------:|--------------:|-------------:|--------------:|-------------:|--------------:|---------------:|-------------:|---------------:|--------------:|--------------:|----------:|:-------------------------------|:------------|:--------------|:--------------|:--------------------|--------------------:|-----------------:|
|         1 | PH156619000 |    1011.09  | 121.393 | 5.98858 |     18098 |     25116 |    25116 |      4441 |          4165 |           276 |           4441 |            7452 |           6746 |           3519 |           4460 |           2445 |            613 |           3679 |          3355 |          1676 |          2081 |          1324 |           322 |             3773 |            3391 |            1843 |            2379 |            1121 |             291 |            17.8994 |            24.8404 |                         7706 |                          308 |                           81 |                           25 |                           21 |                          447 |                         5645 |                           67 |                          181 |                          903 |                            4 |                            0 |                             24 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            2 |            0 |                         68 |          0 |                   1 |            0          |           0.000989028 |              17 |                      0.0168135 |             0 |           13 |             1 |            0 |             0 |              0 |            2 |              0 |             1 |             0 |         0 | OMAR                           | PH156600000 | SULU          | Cluster 0     | ∞                   |               25116 |       0.00197806 |
|         2 | PH156609000 |     853.566 | 120.921 | 5.93564 |     58028 |     62172 |    62172 |      9858 |          9360 |           498 |           9858 |           18131 |          17384 |           8681 |          11091 |           5590 |           1523 |           8624 |          8390 |          4001 |          5333 |          3046 |           783 |             9507 |            8994 |            4680 |            5758 |            2544 |             740 |            67.983  |            72.8379 |                        17217 |                          881 |                          568 |                          160 |                          298 |                         1571 |                        10204 |                          457 |                         1127 |                         1839 |                           49 |                            0 |                             63 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            7 |            0 |                         23 |          1 |                   2 |            0.00117156 |           0.00234311  |              32 |                      0.0374898 |             1 |           10 |             1 |            0 |             0 |              0 |           19 |              0 |             1 |             0 |         1 | PARANG                         | PH156600000 | SULU          | Cluster 1     | 62172               |               31086 |       0.00820089 |
|         4 | PH153621000 |     989.076 | 124.167 | 7.99189 |     21974 |     25440 |    25440 |      4067 |          3872 |           195 |           4067 |            7941 |           6698 |           4042 |           4236 |           2058 |            545 |           3998 |          3357 |          1886 |          2061 |          1129 |           321 |             3943 |            3341 |            2156 |            2175 |             929 |             224 |            22.2167 |            25.721  |                         6726 |                          562 |                          119 |                           20 |                           26 |                          204 |                         4978 |                          139 |                          430 |                          199 |                            2 |                            0 |                             47 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            0 |            0 |                          0 |          0 |                   1 |            0          |           0.00101105  |              33 |                      0.0333645 |             2 |            5 |             2 |            0 |             0 |              0 |           22 |              0 |             2 |             0 |         3 | PIAGAPO                        | PH153600000 | LANAO DEL SUR | Cluster 3     | ∞                   |               25440 |       0          |
|         5 | PH150704000 |     946.547 | 121.901 | 6.51581 |     33803 |     40646 |    40646 |      6294 |          5505 |           789 |           6294 |           10996 |          11023 |           6760 |           6325 |           4163 |           1596 |           5611 |          5442 |          3290 |          3120 |          2103 |           792 |             5385 |            5581 |            3470 |            3205 |            2060 |             804 |            35.7119 |            42.9413 |                        10628 |                          551 |                          344 |                          143 |                          173 |                         1100 |                         5841 |                          260 |                          745 |                         1343 |                          106 |                            1 |                             21 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            3 |            0 |                        177 |          0 |                   1 |            0          |           0.00105647  |              20 |                      0.0211294 |             2 |           16 |             0 |            0 |             0 |              0 |            0 |              1 |             1 |             0 |         3 | MALUSO                         | PH150700000 | BASILAN       | Cluster 3     | ∞                   |               40646 |       0.00316941 |
|         6 | PH153813000 |     883.96  | 124.632 | 6.91591 |     22547 |     22425 |    22425 |      3528 |          3318 |           210 |           3528 |            7070 |           5726 |           3545 |           3478 |           2154 |            533 |           3790 |          3032 |          1678 |          1739 |          1116 |           267 |             3280 |            2694 |            1867 |            1739 |            1038 |             266 |            25.5068 |            25.3688 |                         6436 |                          416 |                           98 |                           34 |                           74 |                          421 |                         4005 |                           92 |                          399 |                          857 |                            2 |                            0 |                             38 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            0 |            0 |                          7 |          0 |                   1 |            0          |           0.00113127  |              14 |                      0.0158378 |             1 |           10 |             1 |            0 |             0 |              0 |            1 |              0 |             1 |             0 |         0 | SULTAN SA BARONGIS (LAMBAYONG) | PH153800000 | MAGUINDANAO   | Cluster 0     | ∞                   |               22425 |       0          |
|         7 | PH157005000 |     439.619 | 119.402 | 4.74873 |     30514 |     33334 |    33334 |      6045 |          5778 |           267 |           6045 |            9250 |           8564 |           5265 |           5548 |           3699 |           1242 |           4686 |          4268 |          2447 |          2781 |          1967 |           709 |             4564 |            4296 |            2818 |            2767 |            1732 |             533 |            69.4101 |            75.8247 |                        10445 |                          303 |                          232 |                          163 |                          113 |                          986 |                         7986 |                          125 |                           32 |                          435 |                            3 |                            0 |                             67 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            1 |            0 |                         88 |          0 |                   1 |            0          |           0.0022747   |              18 |                      0.0409445 |             1 |            9 |             0 |            0 |             0 |              1 |            2 |              0 |             3 |             2 |         3 | SITANGKAI                      | PH157000000 | TAWI-TAWI     | Cluster 3     | ∞                   |               33334 |       0.0022747  |
|         8 | PH153831000 |     281.274 | 124.355 | 7.00991 |     13339 |     25016 |    24799 |      3844 |          3602 |           242 |           3844 |            7988 |           7149 |           3606 |           3941 |           1889 |            570 |           4301 |          3745 |          1706 |          1915 |           999 |           290 |             3687 |            3404 |            1900 |            2026 |             890 |             280 |            47.4236 |            88.9383 |                         7208 |                          850 |                          113 |                           38 |                           55 |                          179 |                         3979 |                          104 |                          507 |                         1365 |                            7 |                            0 |                             11 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            0 |            0 |                          0 |          0 |                   1 |            0          |           0.00355526  |               7 |                      0.0248868 |             1 |            6 |             0 |            0 |             0 |              0 |            0 |              0 |             0 |             0 |         0 | DATU ANGGAL MIDTIMBANG         | PH153800000 | MAGUINDANAO   | Cluster 0     | ∞                   |               25016 |       0          |
|         9 | PH153603000 |     325.949 | 124.181 | 7.92129 |     26007 |     29180 |    29159 |      4183 |          3849 |           334 |           4183 |            8708 |           7383 |           4410 |           5141 |           2829 |            811 |           4326 |          3614 |          2108 |          2455 |          1482 |           431 |             4382 |            3769 |            2302 |            2686 |            1347 |             380 |            79.7886 |            89.5233 |                         7787 |                         2083 |                          255 |                          533 |                           83 |                          467 |                         3208 |                          289 |                          673 |                          111 |                            4 |                            0 |                             81 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            1 |            0 |                         34 |          1 |                   1 |            0.00306797 |           0.00306797  |              36 |                      0.110447  |             2 |           12 |             0 |            0 |             0 |              0 |           20 |              0 |             1 |             1 |         4 | BALINDONG (WATU)               | PH153600000 | LANAO DEL SUR | Cluster 4     | 29180               |               29180 |       0.00306797 |
|        10 | PH153836000 |     244.984 | 124.48  | 7.0005  |     15062 |     14947 |    14947 |      2600 |          2453 |           147 |           2600 |            4543 |           4122 |           2371 |           2173 |           1398 |            416 |           2220 |          2094 |          1111 |          1028 |           764 |           215 |             2323 |            2028 |            1260 |            1145 |             634 |             201 |            61.4817 |            61.0123 |                         4908 |                          109 |                           61 |                           24 |                          132 |                          592 |                         2261 |                          537 |                          631 |                          389 |                            0 |                            0 |                            172 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            0 |            0 |                         32 |          0 |                   1 |            0          |           0.00408191  |               8 |                      0.0326553 |             1 |            1 |             0 |            0 |             0 |              0 |            6 |              0 |             0 |             0 |         0 | DATU SALIBO                    | PH153800000 | MAGUINDANAO   | Cluster 0     | ∞                   |               14947 |       0          |
|        11 | PH153636000 |     142.259 | 124.282 | 7.77329 |     14308 |     16372 |    16090 |      2499 |          2386 |           113 |           2499 |            5321 |           3929 |           2693 |           2976 |           1282 |            208 |           2601 |          1923 |          1305 |          1494 |           721 |           130 |             2720 |            2006 |            1388 |            1482 |             561 |              78 |           100.577  |           115.086  |                         4285 |                          808 |                          310 |                           34 |                           38 |                          231 |                         2402 |                           80 |                          246 |                           99 |                            3 |                            0 |                             34 |         0 |          0 |       0 |                        0 |                         0 |                            0 |            0 |            0 |                         33 |          0 |                   1 |            0          |           0.00702941  |              25 |                      0.175735  |             2 |            9 |             0 |            0 |             0 |              0 |           13 |              0 |             1 |             0 |         4 | LUMBAYANAGUE                   | PH153600000 | LANAO DEL SUR | Cluster 4     | ∞                   |               16372 |       0          |


Table: POIs
|   Column1 | TYPE      | SUBTYPE   | ID         | NAME                         |     LAT |    LONG | PSGC_BRGY   | PSGC_MUNI   | PSGC_PROV   | CATEGORY   | SHAPE_SIZE   | SHAPE_METRICS   | BARANGAY     | MUNICIPALITY                   | PROVINCE    | TYPE_Colors   | CATEGORY_Colors   |
|----------:|:----------|:----------|:-----------|:-----------------------------|--------:|--------:|:------------|:------------|:------------|:-----------|:-------------|:----------------|:-------------|:-------------------------------|:------------|:--------------|:------------------|
|        99 | Education | Public    | EDUC133894 | Bualan ES                    | 7.43896 | 124.301 | PH153818002 | PH153818000 | PH153800000 | ES         |              |                 | BUALAN       | BARIRA                         | MAGUINDANAO | 2F52A4        | Elementary        |
|       114 | Education | Public    | EDUC133945 | Datu Idon S'pi ES            | 6.72968 | 124.796 | PH153803039 | PH153803000 | PH153800000 | ES         |              |                 | POBLACION    | BULUAN                         | MAGUINDANAO | 2F52A4        | Elementary        |
|       242 | Education | Public    | EDUC133936 | Datu Yuseff Paglas ES        | 6.71655 | 124.793 | PH153803039 | PH153803000 | PH153800000 | ES         |              |                 | POBLACION    | BULUAN                         | MAGUINDANAO | 2F52A4        | Elementary        |
|       906 | Education | Public    | EDUC134262 | Aliman B.Gunsi ES            | 6.85062 | 124.252 | PH153817008 | PH153817000 | PH153800000 | ES         |              |                 | PANDAN       | SOUTH UPI                      | MAGUINDANAO | 2F52A4        | Elementary        |
|       907 | Education | Public    | EDUC134204 | Alimao ES                    | 7.04336 | 124.396 | PH153831006 | PH153831000 | PH153800000 | ES         |              |                 | TUGAL        | DATU ANGGAL MIDTIMBANG         | MAGUINDANAO | 2F52A4        | Elementary        |
|       912 | Education | Public    | EDUC134176 | Angkayamat ES                | 6.885   | 124.677 | PH153813001 | PH153813000 | PH153800000 | ES         |              |                 | ANGKAYAMAT   | SULTAN SA BARONGIS (LAMBAYONG) | MAGUINDANAO | 2F52A4        | Elementary        |
|       913 | Education | Public    | EDUC216655 | Angkokoy ES                  | 6.72956 | 124.905 | PH153805010 | PH153805000 | PH153800000 | ES         |              |                 | PUYA         | DATU PAGLAS                    | MAGUINDANAO | 2F52A4        | Elementary        |
|       914 | Education | Public    | EDUC216633 | Assemb. Mama Masukat, Sr. ES | 6.87839 | 124.501 | PH153820011 | PH153820000 | PH153800000 | ES         |              |                 | MANONGKALING | MAMASAPANO                     | MAGUINDANAO | 2F52A4        | Elementary        |
|       915 | Education | Public    | EDUC134195 | Bagan ES                     | 6.94562 | 124.403 | PH153825002 | PH153825000 | PH153800000 | ES         |              |                 | BAGAN        | GUINDULUNGAN                   | MAGUINDANAO | 2F52A4        | Elementary        |
|       916 | Education | Public    | EDUC133948 | Baguadatu ES                 | 6.75971 | 124.877 | PH153805004 | PH153805000 | PH153800000 | ES         |              |                 | KATIL        | DATU PAGLAS                    | MAGUINDANAO | 2F52A4        | Elementary        |

 


tables: name: brgy_finance_df
data: brgy_finance_df.csv
name: brgy_health_df
data: brgy_health_df.csv
name: educ_df
data: educ_df.csv
name: Muni_wClusters
data: Muni_wClusters.csv
name: POIs
data: POIs.csv
label: POIs
PSGC_BRGY
educ_df
PSGC_BRGY
POIs
PSGC_BRGY
brgy_health_df
PSGC_BRGY
Muni_wClusters
Column1
POIs
Column1
POIs
PSGC_BRGY
brgy_finance_df
PSGC_BRGY
output: {
    "joins": [
        {
            "from_table": "POIs",
            "from_column": "PSGC_BRGY",
            "to_table": "educ_df",
            "to_column": "PSGC_BRGY"
        },
        {
            "from_table": "POIs",
            "from_column": "PSGC_BRGY",
            "to_table": "brgy_health_df",
            "to_column": "PSGC_BRGY"
        },
        {
            "from_table": "Muni_wClusters",
            "from_column": "Column1",
            "to_table": "POIs",
            "to_column": "Column1"
        },
        {
            "from_table": "POIs",
            "from_column": "PSGC_BRGY",
            "to_table": "brgy_finance_df",
            "to_column": "PSGC_BRGY"
        }
    ]
}