Road layer - Lemap1/geoclimate GitHub Wiki

The road layer represents any kind of roadways.

Name	Type	Constraints	Definition
the_geom	LINESTRING or MULTILINESTRING	X Y dimensions	Geometry
id_road	INTEGER	Primary Key	Unique Identifier
id_source	VARCHAR	not null	Identifier of the feature from the input datasource
width	FLOAT	not null	Width of the road (expressed in meters)
type	VARCHAR	not null; in type list	Type of road
surface	VARCHAR	in surface list	The surface value is used to provide additional information about the physical surface of roads/footpaths and some other features, particularly regarding material composition and/or structure.
sidewalk	VARCHAR	not null; in (one, two, no)	Specify if the road has one, two or no sidewalk(s). Default value should be no.
zindex	INTEGER	not null ; ≥ -4 ; ≤ 4	Defines the position with respect to the ground. 0 indicates that the object is on the ground. 1 to 4 indicates that the object is above the ground surface. -4 to -1 value indicates that the object is underground.
crossing	VARCHAR	bridge , crossing or null	Indicates whether the road is located on a bridge or not (null). A bridge is defined as an artificial construction that spans features such as roads, railways, waterways or valleys and carries a road, railway or other feature. Crossing value is used when there is no information to qualify it.
maxspeed	INTEGER	-1 if unknown	Indicates the maximum legal speed limit for general traffic
direction	INTEGER	-1 if unknown	Indicates the direction of the road. 1 = one way road section and the traffic goes in the same way that the slope definition you have used, 2 = one way road section and the traffic goes in the inverse way that the slope definition you have used, 3 = bi-directional traffic flow, the flow is split into two components and correct half for uphill and half for downhill

List of type column values

The possible values for the type column are the following:

Term	Definition	Source
cycleway	Separated way for the use of cyclists.	1
ferry	A ferry route used to transport things or people from one bank of a watercourse or inlet to the other, or as a permanent or seasonal local maritime link, and a link to a foreign country.	2
footway	For designated footpaths, i.e. mainly/exclusively for pedestrians.	3
highway	Any kind of street or way.	4
highway_link	Connecting ramp to/from a highway.	5
motorway	Highest-performance highway within a territory that deserve main towns. Usually have a reglemented access.	6
path	A generic multi-use path open to non-motorized vehicles.	7
primary	Important highway linking large towns. Usually have two lanes but not separated by a central barrier.	8
residential	Highway generally used for local traffic within settlement. Usually highway accessing or around residential areas.	9
roundabout	Generally a circular (self-intersecting) highway junction where the traffic on the roundabout has right of way.	10
secondary	Highway linking large towns. Usually have two lanes but not separated by a central barrier.	11
steps	For flights of steps on footways and paths.	12
tertiary	Highway linking small settlements, or the local centers of a large town or city.	13
track	Highway for mostly agricultural use, forest tracks etc.; usually unpaved (unsealed) but may apply to paved tracks as well, that are suitable for two-track vehicles, such as tractors or jeeps.	14
trunk	Important high-performance highway that are not motorways. Deserving main towns.	15
unclassified	Minor public highway typically at the lowest level of the interconnecting grid network. Have lower importance in the highway network than tertiary and are not residential streets or agricultural tracks.	16

List of surface column values

Possible values for the surface column are the following:

Term	Definition	Source
asphalt	Any asphalt surface.	1
cobblestone	Any cobbled surface.	2
compacted	A mixture of larger (e.g., gravel) and smaller (e.g., sand) parts, compacted.	3
concrete	Cement based concrete surface.	4
grass	Grass covered ground.	5
gravel	Surface composed of broken/crushed rock larger than sand grains and thinner than pebblestone.	6
ground	Surface of the ground itself with no specific fraction of rock.	7
metal	Metallic surface.	8
mud	Wet unpaved surface.	9
paved	Surface with coating. Generic term for a highway with a stabilized and hard surface.	10
pebblestone	Surface made of rounded rock as pebblestone findable alongside body of water.	11
sand	Small to very small fractions of rock as findable alongside body of water.	12
unpaved	Generic term to qualify the surface of a highway that is predominantly unsealed along its length; i.e., it has a loose covering ranging from compacted stone chippings to ground.	13
water	Used to qualify the surface of ferry route that uses water (waterbodies, watercourses, seas,...) as a traffic surface.	14
wood	Highway made of wooden surface.	15