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.998887 , -118.24264 , 46.624773 , -117.603113 )
Wikipedia ID for Columbia : Q156253
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:Q156253 wdt:P1082 ?population. }
OPTIONAL { wd:Q156253 wdt:P2044 ?elevation. }
OPTIONAL { wd:Q156253 wdt:P2046 ?area. }
OPTIONAL { wd:Q156253 wdt:P281 ?postal_code. }
OPTIONAL { wd:Q156253 wdt:P395 ?license_plate. }
OPTIONAL {
wd:Q156253 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.998887, -118.24264, 46.624773, -117.603113);
);
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) |
Alto | 46.386250 , -118.111620 |
Baileysburg | 46.299030 , -117.952710 |
Covello | 46.383200 , -117.832980 |
Dayton | 46.316958 , -117.976765 |
Delaney | 46.510700 , -117.971890 |
Dumas | 46.287080 , -118.061330 |
Huntsville | 46.287080 , -118.107170 |
Jackson | 46.534310 , -117.912990 |
Long | 46.291530 , -118.026610 |
Marengo | 46.440700 , -117.748810 |
McKay | 46.337360 , -118.138010 |
Menoken | 46.299310 , -118.161900 |
Mountain Home Park | 46.237090 , -117.893540 |
Mountain Top | 46.241810 , -117.764360 |
Patit | 46.335700 , -117.859370 |
Powers | 46.537920 , -118.152460 |
Relief | 46.453200 , -118.085780 |
Ronan | 46.363750 , -117.922430 |
Starbuck | 46.518386 , -118.125156 |
Tucannon | 46.489030 , -117.960220 |
Turner | 46.412370 , -117.854650 |
Varna | 46.289580 , -118.082170 |
Whetstone | 46.393200 , -117.896880 |
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.