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.