Ottawa/Import/TopographicMap
Jump to navigation
Jump to search
Ottawa 2000 Scale data mapping notes
As the city didn't provide any docs …
Source URL
http://data.ottawa.ca/dataset/cad-topographic-data
Licence
City of Ottawa Open Data Licence Version 2.0
Format
AutoCAD DWG (*ack!* *phbfft!*)
Data Conversion Example
Once the DWG is converted to DXF format you can then use ogr2ogr to convert it into a more useful format:
ogr2ogr -f GeoJSON -s_srs epsg:2951 -t_srs epsg:4326 \
-dialect SQLite \
-sql "select * from entities where LAYER='house'" \
glebe-houses-4326.geojson 368029.dxf
Coordinate Reference System
MTM (Modified Transverse Mercator), Zone 9. Most likely epsg:2951 - NAD83(CSRS) / MTM zone 9, as other city data sets use it (*he adds, naïvely …*). Getting this right is critical, unless you want the data shifted a few hundred metres.
Size
- Download: 3.1 GB (tar.gz)
- Expanded: 4.4 GB
- Converted to DXF: 31 GB (AutoCAD 2013, ASCII, via Teigha File Converter
File Creation Dates
Mid 2011
File naming convention
Samples: 378035.dwg, 376002.dwg, 356006.dwg
Assumed to be
EEENNN.dwg
where
- EEE - first three digits of MTM easting of lower left corner of tile
- NNN - second to fourth digits of MTM northing of lower left corner of tile (first digit of false northing is always 5).
so lower left corners of files would be
- 378035.dwg - E 378000 N 5035000
- 376002.dwg - E 376000 N 5002000
- 356006.dwg - E 356000 N 5006000
File extents
Typically 2 km × 1 km. Note that house outlines are split if they cross tile boundaries, and these would need to be rejoined.
Layers of potential interest to OSM building mappers
There may be more that I missed out of the 177 total layers
- building
- **buildingShapes** - these seem to be an aggregate of all the other building layers, so care would be needed not to double import.
- house
- mobile home
- parking garage
- porch
- ruin
- shed
- silo
- spot height (building)
- structure
Sample converted data
Please see companion gist scruss/glebe-houses-4326.geojson
Full layer list
| Layer Name | Description | Notes |
|---|---|---|
| 2kRoadNameText | ||
| adjoining sheet hypsographic data (noplot) (dtm) | ||
| annotation | ||
| ANT | ||
| area under construction (dtm) | ||
| barrier or precast jersey barrier | ||
| billboard | ||
| border | ||
| bridge joints | ||
| bridge (pedestrian cycle) | ||
| bridge (railway) | ||
| bridge (roadway) | ||
| bridge (roadway and railway) | ||
| bridgeShapes | ||
| building | ||
| buildingShapes | ||
| bus bay (dtm) | ||
| cemetery | ||
| concrete area (dtm) | ||
| contour annotation (major) | ||
| contours major depression | ||
| contours major depression (hidden) | ||
| contours major (every fourth) | ||
| contours major (hidden) | ||
| contours minor | ||
| contours minor depression | ||
| CP | ||
| crossing gate (railway) | ||
| culvert (concrete) | ||
| culvert (end) | ||
| culvert (general plastic) | ||
| culvert (railway) | ||
| culvert (roadway) | ||
| culvert (steel pipe) | ||
| curbing road (dtm) | ||
| curbing road (on bridge) | ||
| dam | ||
| dam (beaver) | ||
| deck | ||
| ditch (dtm) | ||
| dock (wharf jetty pier) | ||
| drivewayShapes | ||
| embankment fill (railway) (dtm) | ||
| embankment fill (roadway) (dtm) | ||
| falls (water) | ||
| feature outline (dtm) | ||
| fence (chain link) | ||
| fence (on bridge) | ||
| fence (unknown type) | ||
| fence (wire) | ||
| fence (wood) | ||
| FLOARR | ||
| flow arrow | ||
| forestShapes | ||
| FP | ||
| gabion (dtm) | ||
| gate | ||
| golf course | ||
| gravel area (dtm) | ||
| gravel shoulder (dtm) | ||
| grid line | ||
| grid text | ||
| guard rail | ||
| guard rail (on bridge) | ||
| guy wire | ||
| headwall (large culvert to scale) (dtm) | ||
| hedge | ||
| house | ||
| lanewayShapes | ||
| Level 62 | ||
| light standard (electrical) | ||
| LS | ||
| map edge hypsographic data (dtm) (noplot) | ||
| MARSH | ||
| marsh (outline) (dtm) | ||
| marsh (symbol) | ||
| mobile home | ||
| MP | ||
| MWANT | ||
| neat line | ||
| orchard | ||
| overhead sign | ||
| parking garage | ||
| parking lot (paved) (dtm) | ||
| parking lot paved (on bridge) | ||
| parkingLotPavedShapes | ||
| parking lot (unpaved) (dtm) | ||
| parkingLotUnpavedShapes | ||
| pathwayShapes | ||
| patio (dtm) | ||
| paved shoulder | ||
| pile edge (dtm) | ||
| pit edge (dtm) | ||
| playground (dtm) | ||
| playing field (sports) (dtm) | ||
| pole - concrete | ||
| pole - metal | ||
| pole - wood | ||
| pond outline (dtm) | ||
| porch | ||
| POST | ||
| race track edge (dtm) | ||
| railway track | ||
| railway track (on bridge) | ||
| rapids | ||
| RC | ||
| RC2 | ||
| reservoir | ||
| retaining wall (dtm) | ||
| river edge (dtm) | ||
| river or stream (indefinite) (dtm) | ||
| river or stream (intermittent) (dtm) | ||
| river or stream (single line) (dtm) | ||
| road centre line (analytical) (dtm) (noplot) | ||
| road centre line (analytical) (on bridge) (noplot) | ||
| road - construction (dtm) | ||
| road - gravel (dtm) | ||
| road - paved (dtm) | ||
| road paved (on bridge) | ||
| roadShapes | ||
| road - unknown surface (dtm) | ||
| rock outcrop (dtm) | ||
| ruin | ||
| runway edge (dtm) | ||
| runwayShapes | ||
| scrub (line) | ||
| shed | ||
| shoreline (dtm) | ||
| shoreline (indefinite) (dtm) | ||
| shrub (line) | ||
| sidewalk (concrete) (dtm) | ||
| sidewalk concrete (on bridge) | ||
| sidewalk (gravel) (dtm) | ||
| sidewalk (paved) (dtm) | ||
| sidewalk paved (on bridge) | ||
| sidewalk (paving stone) (dtm) | ||
| sidewalkShapes | ||
| sidewalk (unknown surface) (dtm) | ||
| sign to scale | ||
| silo | ||
| smoke stack or chimney | ||
| SPOTB | ||
| spot height (building) (noplot) | ||
| spot height (open area) (dtm) (noplot) | ||
| spot height (open area) (on bridge) | ||
| spot height (road) (dtm) (noplot) | ||
| spot height (road) (on bridge) | ||
| spot height text (open area) | ||
| spot height text (open area) (on bridge) | ||
| spot height text (road) | ||
| spot height text (road) (on bridge) | ||
| spot height (water) (dtm) (noplot) | ||
| SPTOTH | ||
| steps (substantial) | ||
| structure | ||
| tower mast (communication) | ||
| tower pylon (electrical) | ||
| track (cart or tractor) (dtm) | ||
| track (dtm) | ||
| traffic light | ||
| trail (dtm) | ||
| trail (improved bicycle) (dtm) | ||
| tree crown drip line | ||
| treeCrownDripLineShape | ||
| TREENT | ||
| tree (small) no trunk | ||
| tree (small) with trunk | ||
| TREEWT | ||
| virtual breaklines (dtm) (noplot) | ||
| virtual breakpoints (dtm) (noplot) | ||
| virtual point (on bridge) | ||
| wall | ||
| waterShapes | ||
| wooded area | ||
| WP |
Credit
Credit goes to https://wiki.openstreetmap.org/wiki/User:Scruss who has documented this data via talk-ca discussion and on his Github: Ottawa 2000 Scale data mapping notes