Download outline map of Columbia (geojson format) :
Columbia.geojson (**)
Download polygon array of Columbia map for "Google Maps" :
Columbia.txt
Bounding Box for Columbia Map : ( 45.721229 , -123.366034 , 46.188979 , -122.760108 )
Wikipedia ID for Columbia : Q484385
Wikipedia SPARQL Query for Columbia (population,elevation,area,lat,long, postal code,licence plate) :
SELECT ?population ?elevation ?area ?latitude ?longitude ?postal_code ?license_plate
WHERE {
OPTIONAL { wd:Q484385 wdt:P1082 ?population. }
OPTIONAL { wd:Q484385 wdt:P2044 ?elevation. }
OPTIONAL { wd:Q484385 wdt:P2046 ?area. }
OPTIONAL { wd:Q484385 wdt:P281 ?postal_code. }
OPTIONAL { wd:Q484385 wdt:P395 ?license_plate. }
OPTIONAL {
wd:Q484385 p:P625 ?coordinate.
?coordinate psv:P625 ?coordinate_node.
?coordinate_node wikibase:geoLatitude ?latitude.
?coordinate_node wikibase:geoLongitude ?longitude.
}
}
Run this SPARQL Query on Wikidata Page (Click RUN button on the opened page!)
Run this Query with SPARQL API
Get Boundaries from overpass-turbo (OSM) with boundary box of Columbia map
[out:json];
(
relation["boundary"="administrative"]["admin_level"~"5|6|7"](45.721229, -123.366034, 46.188979, -122.760108);
);
out geom;
Run this query on overpass-turbo (Click RUN button on the opened page!)
Get Boundaries from overpass-turbo (OSM) with place name (Columbia)
[out:json];
(
rel["name"="Columbia"][type=boundary];
rel["name:en"="Columbia"][type=boundary];
);
out geom;
Run this query on overpass-turbo (Click RUN button on the opened page!)
Neighborhoods and Villages of Columbia
Neighborhoods and Villages | Coordinates (Latitude, Longitude) |
Alston | 46.099280 , -123.047060 |
Apiary | 46.014000 , -123.030110 |
Beaver Homes | 46.005670 , -122.927050 |
Beaver Springs | 46.045950 , -122.948170 |
Birkenfeld | 45.990670 , -123.337620 |
Canaan | 45.932060 , -122.917890 |
Chapman | 45.825110 , -122.985390 |
Chapman Landing | 45.745950 , -122.840660 |
Clatskanie | 46.103508 , -123.205116 |
Clatskanie Heights | 46.056400 , -123.204900 |
Clear Creek | 45.805940 , -123.279560 |
Columbia City | 45.895123 , -122.811502 |
Deer Island | 45.932995 , -122.849763 |
Delena | 46.098440 , -123.074000 |
Goble | 46.015950 , -122.875390 |
Inglis | 46.126500 , -123.165120 |
Johnson Crossing | 45.731230 , -122.875660 |
Keasey | 45.861500 , -123.329560 |
Kerry | 46.120940 , -123.351790 |
Lindbergh | 46.074840 , -122.906220 |
Marshland | 46.111220 , -123.285680 |
Mayger | 46.163440 , -123.108170 |
McNulty | 45.840390 , -122.841770 |
Mist | 45.996220 , -123.256510 |
Natal | 45.976294 , -123.189610 |
Neer City | 46.026657 , -122.884483 |
Neverstill | 45.975940 , -123.344570 |
Prescott | 46.048166 , -122.887938 |
Quincy | 46.143720 , -123.160120 |
Rainier | 46.092462 , -122.946978 |
Reuben | 46.008720 , -122.877330 |
Ruley | 45.816556 , -122.999647 |
Scappoose | 45.756602 , -122.876706 |
Spitzenberg | 45.825670 , -122.946220 |
St. Helens | 45.857877 , -122.816035 |
Trenholm | 45.895390 , -122.965390 |
Trojan | 46.036956 , -122.886242 |
Vernonia | 45.861150 , -123.183338 |
Warren | 45.813308 , -122.879668 |
West Rainier | 46.098657 , -122.963300 |
Woodson | 46.114550 , -123.324290 |
Yankton | 45.866780 , -122.886770 |
Notes:
- You can download geometry data for Columbia in various formats (Geojson,KML,GPX,raw OSM data) by clicking export button on the overpass-turbo
- You can freely use the jpeg type map images you created on the "map cropping" page or downloaded from the "samples" pages.
- (**)
Terms of Use for downloaded geojson files.