Alle provinces polygons voor de hele wereld
https://fusiontables.google.com/DataSource?docid=1O_WugYFKPBS4GTkPdN_hof6QnldoZlnwtxMjbMU#rows:id=1
Het probleem is, dat vele provincies in de wereld niet bestaan in deze dataset.
Ik gebruik daarnaast ook deze dataset: http://www.gadm.org/version2 (dataset2)
Deze lijkt wel redelijk compleet te zijn, maar vele provincies bestaan niet in de provincie dataset, maar wel in het laatste en andersom.
1) Als ik de verschillende bekijk zijn er ruim 1800 provinces in dataset 2 die niet bestaan in dataset 1
Is er een dergelijke API of wijze hoe ik deze polygons per provincie kan opvragen en handmatig stuk voor stuk in te voeren?
2) Is er een database die compleet is desnoods tegen een vergoeding? Dus spatial coordinaten,land, isocode, regio2 (provincie) en regio3 (stad/district)
Het is in theorie mogelijk, dat ik de provincies in dataset2 invoer in dataset1.
een spatial polygon in dataset 2 is bijv:
Code (php)
1
'POLYGON((104.95781707763683 16.187810897827205,104.95761871337902 16.188150405883903,104.95748901367188 16.188400268554744,104.9573593139649 16.188648223876953,104.95725250244152 16.188890457153434,104.9571304321289 16.18913078308111,104.95700836181646 16.189361572265682,104.9569091796875 16.18963050842291,104.95680236816412 16.18988037109375,104.95671081542969 16.190130233764762,104.95664215087902 16.190401077270565,104.9565658569336 16.190671920776424,104.9565200805664 16.190929412841797,104.9564666748048 16.191200256347656,104.95642852783209 16.191459655761776,104.95639801025396 16.188369750976562,104.95862579345703 16.188262939453182,104.95838928222668 16.188140869140568,104.95813751220709 16.18799972534191,104.95781707763683 16.187810897827205))',1
In dataset1 is dat een mediumtext met xml tags als:
Code (php)
1
<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>55.493019104,25.459438324,0 55.4974975586,25.4527740479,0 55.5486068726,25.4311103821,0 55.558052063,25.4294433594,0 55.5791625977,25.4294433594,0 55.6027755737,25.4308319092,0 55.6105499268,25.4291648865,0 55.6324996948,25.4205551147,0 55.633605957,25.4180526733,0 55.6299972534,25.4052772522,0 55.619720459,25.3797187805,0 55.6097183228,25.3633308411,0 55.6049957275,25.3586082458,0 55.5991592407,25.3580551147,0 55.5097198486,25.3630523682,0 55.4766616821,25.3702774048,0 55.4697189331,25.3722190857,0 55.4474945068,25.3797187805,0 55.4248504639,25.394241333,0 55.4591598511,25.407497406,0 55.4683303833,25.4133300781,0 55.4794387817,25.4274978638,0 55.493019104,25.459438324,0</coordinates></LinearRing></outerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>55.9772186279,25.2819442749,0 55.9691619873,25.2880554199,0 55.9655532837,25.2933311462,0 55.9611053467,25.3041648865,0 55.9611053467,25.3088874817,0 55.9658279419,25.3191642761,0 55.9708328247,25.3241653442,0 55.9830551147,25.3316650391,0 55.9977722168,25.325553894,0 56.0030517578,25.3222198486,0 56.0052719116,25.319442749,0 56.0083312988,25.308052063,0 56.007774353,25.3030548096,0 55.9977722168,25.2930526733,0 55.9772186279,25.2819442749,0</coordinates></LinearRing></outerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>56.0508270264,24.8661079407,0 56.0627746582,24.8538856506,0 56.1055526733,24.820274353,0 56.0811080933,24.770275116,0 56.0786056519,24.7649993896,0 56.0747146606,24.7513885498,0 56.0741653442,24.7449989319,0 56.0769424438,24.7380523682,0 56.071105957,24.7397193909,0 56.0616607666,24.744720459,0 56.0538864136,24.7527770996,0 55.9827728271,24.86277771,0 55.9783325195,24.8727760315,0 55.9774932861,24.8783302307,0 55.9794387817,24.8838882446,0 55.9827728271,24.8877754211,0 55.9874954224,24.8899993896,0 55.9936065674,24.8911094666,0 56.0005493164,24.8911094666,0 56.0133285522,24.888885498,0 56.0241622925,24.8838882446,0 56.0330505371,24.8786087036,0 56.0508270264,24.8661079407,0</coordinates></LinearRing></outerBoundaryIs></Polygon></MultiGeometry>
Weet iemand hoe ik dataset2 kan omzetten in dataset1, of is dat te ingewikkeld?
Daniel
Gewijzigd op 20/03/2017 16:24:26 door Daniel van Seggelen
Er zijn nog geen reacties op dit bericht.