Global bridges (WFP SDI-T - Logistics Database)

Date: 2014-10-14 This is the metadata file that explains the attributes for the wld_trs_bridges_wfp layer: Bridges: culverts... Any attributes which are blank or '0' had no data entered at the time of realease. Please contribute by giving your inputs at omep.gis@wfp.org or connect on http://geonode.wfp.org/

Category: Transportation Shape: Point

Schema and Attribute Details:

wld_trs_bridges_wfp

objectid integer NOT NULL: ArcGIS ID

brdgname character varying(100): Bridge name

brdgtype character varying(25): Bridge type, Unknown, Arch, Beam, Truss, Floating, Suspension, Culvert

status character varying(25): Brdige status, Unknown, Open, Closed, Planned, Restricted

dmg character varying(25): Is the bridge damaged? Unknown, Yes, No

brdglength numeric(6,1): Bridge length (in meters)

maxloadmt numeric(4,1): Maximum load declared (in MT)

estimatedcrossingtime integer: Estimated crossing time (bottle neck, in case of problems on the bridge, the crossing time could takes time or if the bridge is a ferry). Value in minutes.

curntprac character varying(25): Current practicability

basemtrl character varying(25): Base material

srftpe character varying(25): Surface type

hasbypass character varying(25): Does the bridge have by pass? Unknown, Yes, No, locprecision character varying(25): Precision of the location Accurate => GPS coordinates, digitized from an high resolution satellite imagery or a detailled map (accuracy at the street level) Approximate => Precision which is not below the city/town level. It often corresponds to a point equivalent at the point of the city/town/village Bad => Feature with a very low precision. A feature exists in 1 area (province, region...) but we don't know where exactly, the reference (settlement) is impossible to find and the point is put randomly Unknown => No information regarding the precision

latitude numeric(8,5): Latitude of the point (Calculated automatically from the geometry)

longitude numeric(8,5): Longitude of the point (Calculated automatically from the geometry)

iso3 character varying(5): ISO3 code of the country where the feature is located. This field is calculated automatically at the database level with the bnd_adm0_a_ungiwg_2012 layer

country character varying(50): Name of the country where the feature is located. This field is calculated automatically at the database level with the bnd_adm0_a_ungiwg_2012 layer

lastcheckdate timestamp without time zone: Date of the last check of all (or a part) of the attributes. The date has to be specified manually during the edits

remarks character varying(1000): Notes/Description/Remarks - The user is free to enter any information that is necessary but cannot be stored in the others fields

url_lca character varying(254): Reference to the LCA page of the feature

source character varying(254): Source of the information. It could be the source of the geometry or the source of the main attributes. Several sources can be accepted for the same feature(list of names)

createdate timestamp without time zone: Date when the feature has been created. Calculated automatically at the database level while saving (commit) the edits.

updatedate timestamp without time zone: Date of the last update. Calculated automatically at the database level while saving (commit) the edits. Different of the lastcheckdate because the user can forget to specify the date manually or because sometimes we can do a quick edit (for example change the status or correct misspelling) without checking all attributes.

ruleid integer: internal field managed by arcgis for representation

override bytea: internal field managed by argis for representation

shape geometry: Geometry

fid serial NOT NULL: Internal ID the_geom geometry: Geometry brdg_name character varying(100): Bridge ame (if exists) brdgtype integer: Type

0 - Unknown / Not specified, 1 - Arch, 2 - Beam, 3 - Truss, 4 - Floating, 5 - Suspension, 6 - Culvert

status integer: Status 0 - Unknown / Not specified, 1 - Open, 2 - Closed, 3 - Restricted, 4 - Abandonned/Disused

brdglenght numeric(10:5): Bridge length (meters)

maxload numeric(4:1): Load limit (MT)

curntprac integer: Current practicability 0 - Unknown / Not specified, 1 - Non-motorized, 2 - Motorbike, 3 - 4WD <3.5MT, 4 - Light Truck <10MT, 5 - Heavy Truck 20MT

basemtrl integer: Base material 0 - Unknown / Not specified, 1 - Wood, 2 - Concrete, 3 - Stone, 4 - Steel, 5 - PVC

srftpe integer: Surface type 0 - Unknown / Not specified, 1 - Paved, 2 - Gravel, 3 - Dirt/Sand, 4 - Steel, 5 - Wood, 6 - Grass

hasbypass integer: has by-pass 0 - Unknown / Not specified, 1 - Yes, 2 - No

notes character varying(254): Comments

url_lca character varying(254): Reference to the LCA page of the feature URL to the LCA page for the bridges

source character varying(254): Source of the information. It could be the source of the geometry or the source of the main attributes. Several sources can be accepted for the same feature(list of names) Source of the data

longitude double precision: Longitude

latitude double precision: Latitude

continent character varying(50): Continent

region character varying(50): Region of the world

"createuser" character varying(50): User who created the feature

updateuser character varying(50): User who did the last update

createdate date: Creation date of the feature

updatedate date: Date of the last update

country character varying(150): Country

iso3 character varying(3): ISO3 code of the country