Ottawa/Import/TopographicMap

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