Last active
August 29, 2015 14:21
-
-
Save smsm1/931c1b91cc2b40bdcc3f to your computer and use it in GitHub Desktop.
England OSM place points and areas that have different place values
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
node_id | node_name | node_place | area_id | area_name | area_place | |
------------+---------------------------+-------------------+-----------+---------------------------+------------------- | |
3170944449 | White Island | island | 237771677 | White Island | islet | |
3135514753 | Puffin Island | island | 237775398 | Puffin Island | islet | |
3130896739 | Foremans Island | island | 236953354 | Foremans Island | islet | |
3130894687 | Newford Island | islet | 239078676 | Newford Island | island | |
3130895311 | Toll's Island | island | 191593861 | Toll's Island | islet | |
3169261904 | Frenchman's Rock | islet | 191501886 | Frenchman's Rock | island | |
1617936495 | Higher Whiteleigh | locality | 119263644 | Higher Whiteleigh | hamlet | |
27587867 | Askam-in-Furness | village | 340212024 | Askam-in-Furness | town | |
1446067003 | Piel Island | hamlet | 3099422 | Piel Island | island | |
29676311 | Clapton | village | 261414628 | Clapton | hamlet | |
307495368 | Branton | village | 228137075 | Branton | hamlet | |
334845912 | Powburn | village | 228124688 | Powburn | hamlet | |
307089536 | Edlingham | hamlet | 228272929 | Edlingham | village | |
2321235990 | Ulgham | village | 100461241 | Ulgham | hamlet | |
2042760990 | Portway Industrial Estate | suburb | 28140370 | Portway Industrial Estate | industrial_estate | |
1249222817 | Walworth Business Park | suburb | 28140375 | Walworth Business Park | locality | |
54903442 | Romanby | suburb | 31159126 | Romanby | town | |
30171198 | Ingleby Barwick | town | 77989220 | Ingleby Barwick | suburb | |
3471229040 | Gundleton | village | 169870437 | Gundleton | hamlet | |
194490879 | Rievaulx | hamlet | 235462595 | Rievaulx | village | |
29072084 | Helmsley | town | 39885622 | Helmsley | village | |
243511444 | Sudbrook | hamlet | 178387116 | Sudbrook | village | |
1604025152 | Ifold | village | 24611982 | Ifold | hamlet | |
243406292 | Washingborough | town | -4536979 | Washingborough | village | |
82536385 | Sapperton | village | 319229998 | Sapperton | hamlet | |
2983956374 | The Old Dairy | isolated_dwelling | 319187564 | The Old Dairy | farm | |
243406266 | Sudbrooke | hamlet | 320412660 | Sudbrooke | village | |
243488401 | Metheringham | town | -4498898 | Metheringham | village | |
1747512598 | Boyle Farm Island | locality | 48076587 | Boyle Farm Island | island | |
27409172 | Heckington | town | 178201190 | Heckington | village | |
243514910 | Ewerby Thorpe | hamlet | 178201193 | Ewerby Thorpe | village | |
244452628 | Little Hale | hamlet | 191258486 | Little Hale | village | |
3002324660 | Monks Gate | hamlet | 211234357 | Monks Gate | village | |
298728640 | Martin Dales | hamlet | 260164402 | Martin Dales | locality | |
29543429 | Hassocks | village | 33528270 | Hassocks | town | |
1366491282 | Cuckfield | village | 33650872 | Cuckfield | town | |
879281603 | Eastrea | hamlet | 236390054 | Eastrea | village | |
2654323663 | Aby | hamlet | 311130807 | Aby | village | |
1593003662 | Wentworth | hamlet | 146396915 | Wentworth | village | |
25292436 | Snailwell | hamlet | 146396909 | Snailwell | village | |
3154860283 | Widford | neighbourhood | 167538682 | Widford | suburb | |
29703122 | Robertsbridge | town | 198585629 | Robertsbridge | village | |
267132368 | Upend | village | 236234664 | Upend | hamlet | |
1920630236 | Rodmersham Green | village | 77552357 | Rodmersham Green | hamlet | |
(44 rows) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select node.osm_id node_id,node.name node_name,node.place node_place,area.osm_id area_id,area.name area_name,area.place area_place from planet_osm_point node, planet_osm_polygon area where node.name = area.name and node.place != area.place and ST_Within(node.way, area.way); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment