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 : ( 29.825587 , -82.800477 , 30.597734 , -82.452518 )
Wikipedia ID for Columbia : Q173867
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:Q173867 wdt:P1082 ?population. }
OPTIONAL { wd:Q173867 wdt:P2044 ?elevation. }
OPTIONAL { wd:Q173867 wdt:P2046 ?area. }
OPTIONAL { wd:Q173867 wdt:P281 ?postal_code. }
OPTIONAL { wd:Q173867 wdt:P395 ?license_plate. }
OPTIONAL {
wd:Q173867 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"](29.825587, -82.800477, 30.597734, -82.452518);
);
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) |
Bass | 30.108570 , -82.695960 |
Benton | 30.486610 , -82.660680 |
Columbia | 30.073840 , -82.695680 |
Deep Creek | 30.373000 , -82.622900 |
Ebenezer | 30.096070 , -82.570680 |
Ellisville | 30.003850 , -82.597340 |
Fairview | 30.451330 , -82.518740 |
Five Points | 30.222457 , -82.646385 |
Fort White | 29.922408 , -82.713555 |
Greenfield | 30.313840 , -82.562620 |
Hollingsworth Bluff | 29.869120 , -82.742900 |
Lacymark | 30.212170 , -82.648460 |
Lake City | 30.189218 , -82.646894 |
Lulu | 30.107460 , -82.491230 |
McColskey | 30.189120 , -82.562340 |
McColsky | 30.186900 , -82.549010 |
Mikesville | 29.946630 , -82.602060 |
Mount Carrie | 30.195230 , -82.503730 |
Myrtis | 30.065510 , -82.600120 |
Navair | 30.170230 , -82.584290 |
Newco | 30.183010 , -82.602620 |
Rolling Meadows | 30.140000 , -82.693890 |
Springville | 30.292730 , -82.763460 |
Suwannee Valley | 30.299120 , -82.708180 |
Watertown | 30.185444 , -82.602437 |
Wilburn | 30.190790 , -82.578730 |
Winfield | 30.263010 , -82.685960 |
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.