Data overview
The following table presents data tables and transformation we will need to apply to them.
Date from satellite/aerial imagery will be calculated for all fields concerned.
edi_bati
|
buildings and usage when available
|
intermediate
|
2
|
SAU to review qualification/classification and to remove buildings that don't exist anymore.
|
|
Cut building with the limit roof from linear limits layer.
|
edi_construction_p
|
punctual manmade points (beacon, antenna, power pole...)
|
ok
|
4
|
|
|
|
edi_construction_l
|
linear manmade limits (fence, wall, dam...)
|
ok
|
6
|
|
|
|
edi_construction_s
|
horizontal man made objects (such as parking, swimming pool, etc).
|
intermediate
|
7
|
SAU to review qualification/classification and check marae that are (or not) open to public
|
Select swimming pool open to public
|
|
voi_mobilier_route_p
|
highway furniture (KM point, lamp..)
|
ok
|
4
|
|
|
KM point, crossing, traffic calming to be projected on the road.
|
voi_troncon_route_l
|
highway
|
intermediate
|
1
|
SAU to review qualification/classification
|
|
|
rel_lignes_repere
|
contour lines, and specific contour lines (cliff...)
|
intermediate
|
6
|
SAU to review qualification/classification
|
selection on cliffs only
|
|
rel_points_cotes
|
figure field including peaks and other remarkable points
|
yes
|
4
|
|
selection on remarkable points (peaks, etc).
|
|
ref_repere
|
geodesic reference point
|
ok
|
5
|
|
selection on SAU RGPF points with a code_repere
|
compilation of fields and extraction of elevation in a specific field (original layer is 2.5 pt layer).
|
nom_pai
|
point of interest
|
intermediate
|
3
|
SAU to review qualification/classification
|
|
|
nom_toponyme
|
localty names
|
ok
|
4
|
|
|
|
Data transformation tables and process
Color code :
Ready for transformation
|
Being improved by SAU
|
|
Common
Process:
- extract date of imagery when acquisition mode is imagery (satellite or aerial photogrammetry).
show
Transformation table for common fields
precision_plani
|
value in m
|
accuracy
|
value+m
|
yes (but more than 40 000 use)
|
date_acq
|
date
|
source:date
|
yyyy-mm-dd
|
no
|
mode_acq
|
TERRAIN_GPS
|
source:geometry or source:position for point layer
|
gps
|
no
|
mode_acq
|
TERRAIN_TOPO
|
source:geometry or source:position for point layer
|
theodolite
|
no
|
mode_acq
|
ORTHO
|
source:geometry or source:position for point layer
source:geometry:date
|
orthophotography
date
|
no
|
mode_acq
|
GPS
|
source:geometry or source:position for point layer
|
gps
|
no
|
mode_acq
|
DORIS
|
source:geometry or source:position for point layer
|
doris
|
no
|
mode_acq
|
PVS
|
source:geometry or source:position for point layer
source:geometry:date
|
Satellite photogrammetry
date
|
no
|
mode_acq
|
PVA
|
source:geometry or source:position for point layer
source:geometry:date
|
Aerial photogrammetry
date
|
no
|
Construction
Buildings
Data quality : We estimated 5 to 10% the percentage of update lack (buildings existed when they where mapped but have been destroyed and replaced by something else such as parking now) on SAU building layers. So SAU is cleaning up this layer removing buildings that don't exist anymore. The one that were not mapped won't be added at this stage as it represents a high need of work and mean (SAU buildings are 2.5D and come from stereopreparation J). Which will lead to import of buildings that do exist. On top of that SAU is correcting classification incoherence. So we suppose that buildings imported will be of high quality and will be of a high benefit for OSM. To be noted that there is a big lack of buildings in OSM in French Polynesia, and mainly in Tahiti. SAU corrected buildings for Society islands.
Process :
- Cut building with the limit roof from linear limits layer
- Extract centroid from transformers
Quality improvement : Update types from name when available
show
Transformation table for buildings
categorie
|
0
|
Professionnel – Primaire
|
operator:type
|
private
|
no
|
categorie
|
1
|
Professionnel – Secondaire
|
operator:type
|
private
|
no
|
categorie
|
2
|
Professionnel – Service
|
operator:type
|
private
|
no
|
categorie
|
3
|
Service Public
|
operator:type
|
public
|
no
|
categorie
|
5
|
Religieux
|
operator:type
|
religious
|
no
|
sous_categorie
|
AGRI_ELEVAGE
|
|
building
|
farm_auxiliary
|
no
|
sous_categorie
|
AGRO_ALIMENTAIRE
|
|
man_made
product
|
works
food
|
no
|
sous_categorie
|
AQUACOLE
|
|
landuse
|
aquaculture
|
no
|
sous_categorie
|
AUTRE_MEDIC
|
|
amenity
|
doctors
|
no
|
sous_categorie
|
BANQUE
|
|
amenity
|
bank
|
no
|
sous_categorie
|
BATIMENT SPORTIF
|
|
leisure
fixme
|
sports_centre
à vérifier et adapter en club=sport en fonction de la taille
|
no
|
sous_categorie
|
BTP
|
|
office
|
construction_company
|
yes (500 use case).
|
sous_categorie
|
CENTRALE_HYDRO_ELEC
|
|
power
plant:source
|
plant
hydro
|
no
|
sous_categorie
|
CENTRALE_THERM
|
|
power
|
plant
|
no
|
sous_categorie
|
CENTRE_COMMERCIAL
|
|
building
shop
|
retail
mall
|
no
|
sous_categorie
|
CHAPELLE
|
|
building
|
chapel
|
no
|
sous_categorie
|
CLINIQUE
|
|
amenity
|
clinic
|
no
|
sous_categorie
|
COLLEGE
|
|
building
amenity
school:FR
|
school
school
collège
|
no
|
sous_categorie
|
COMMERCE
|
|
shop
|
yes
|
no
|
sous_categorie
|
DISPENS
|
|
amenity
health_facility:type
|
clinic
dispensary
|
health_facility:type not approved but gathers >10000 use.
|
sous_categorie
|
ECOLE_ELEM
|
|
building
amenity
school:FR
|
school
school
élémentaire
|
no
|
sous_categorie
|
ECOLE_MAT
|
|
building
amenity
school:FR
|
school
kindergarten
maternelle
|
no
|
sous_categorie
|
ECOLE_PRIM
|
|
building
amenity
school:FR
|
school
school
primaire
|
no
|
sous_categorie
|
EGLISE_ADVENTISTE
|
|
amenity
religion
denomination
|
place_of_worship
christian
adventist
|
no
|
sous_categorie
|
EGLISE_CATHOLIQUE
|
|
amenity
religion
denomination
|
place_of_worship
christian
catholic
|
no
|
sous_categorie
|
EGLISE_JEHOVAH
|
|
amenity
religion
denomination
|
place_of_worship
christian
jehovahs_witness
|
no
|
sous_categorie
|
ETAB_RECHERCHE
|
|
amenity
|
research_institute
|
no
|
sous_categorie
|
ETAB_SUP
|
|
amenity
|
university
|
no
|
sous_categorie
|
FORMATION_PROF
|
|
amenity
|
college
|
no
|
sous_categorie
|
GENDARMERIE
|
|
amenity
police:FR
operator
|
police
gendarmerie
Gendarmerie nationale
|
no
|
sous_categorie
|
HOPITAL
|
|
amenity
|
hospital
|
no
|
sous_categorie
|
HOTELLERIE
|
|
tourism
|
hotel
|
no
|
sous_categorie
|
MAIRIE
|
|
amenity
|
townhall
|
no
|
sous_categorie
|
MAISON_REUNION
|
|
amenity
community_centre
|
community_centre
meeting_room
|
no
|
sous_categorie
|
MARCHE
|
|
amenity
|
marketplace
|
no
|
sous_categorie
|
MILITAIRE
|
|
military
|
yes
|
no
|
sous_categorie
|
MONUMENT
|
|
historic
|
monument
|
no
|
sous_categorie
|
PERLICULTURE
|
|
landuse
aquaculture
seamark:marine_farm:category
seamark:type
|
aquaculture
oyster
pearl_culture
marine_farm
|
no
|
sous_categorie
|
PHARE
|
|
man_made
|
lighthouse
|
no
|
sous_categorie
|
PHARMACIE
|
|
amenity
|
pharmacy
|
no
|
sous_categorie
|
POLICE
|
|
amenity
police:FR
|
police
police
|
no
|
sous_categorie
|
POMPIER
|
|
amenity
|
fire_station
|
no
|
sous_categorie
|
POSTE
|
|
amenity
|
post_office
|
no
|
sous_categorie
|
PRISON
|
|
amenity
|
prison
|
no
|
sous_categorie
|
RESTAURATION
|
|
amenity
fixme
|
restaurant
à vérifier et adapter le cas échéant (si restauration rapide..)
|
no
|
sous_categorie
|
SERVICE_ADMIN
|
|
office
|
government
|
no
|
sous_categorie
|
STAT_AEP
|
|
man_made
pumping_station
substance
drinking_water
|
pumping_station
water
water
yes
|
no
|
sous_categorie
|
STAT_EPUR
|
|
man_made
|
wastewater_plant
|
no
|
sous_categorie
|
STAT_SERVICE
|
|
amenity
|
fuel
|
no
|
sous_categorie
|
STOCK_EAU_POTABLE
|
|
man_made
content
drinking_water
|
storage_tank
water
yes
|
no
|
sous_categorie
|
STOCK_HYDROCARBURE
|
|
man_made
content
|
storage_tank
hydrocarbons
|
no
|
sous_categorie
|
STRUC_TRANSPORT
|
|
public_transport
|
station
|
no
|
sous_categorie
|
TEMPLE_MORMON
|
|
amenity
religion
denomination
|
place_of_worship
christian
mormon
|
no
|
sous_categorie
|
TEMPLE_PROTESTANT
|
|
amenity
religion
denomination
|
place_of_worship
christian
protestant
|
no
|
sous_categorie
|
TEMPLE_SANITO
|
|
amenity
religion
denomination
denomination:description
|
place_of_worship
religion
mormon
sanito
|
no
|
sous_categorie
|
TRANSFORMATEUR
|
|
power
|
transformer
|
no
|
sous_categorie
|
TRIBUNAL
|
|
amenity
|
courthouse
|
no
|
sous_categorie
|
TRIBUNE
|
|
building
|
grandstand
|
no
|
position_sol
|
0
|
niveau sol
|
location
|
surface
|
no
|
position_sol
|
1
|
niveau sur édifice
|
location
|
roof
|
no
|
structure_touristique
|
1
|
|
tourism
|
yes
|
no
|
gestionnaire
|
ETAT
|
|
operator
operator:type
|
Etat
government
|
no
|
gestionnaire
|
PAYS
|
|
operator
operator:type
|
Pays
government
|
no
|
gestionnaire
|
COMMUNE
|
|
operator:type
government
|
government
commune
|
no
|
gestionnaire
|
PRIVE
|
|
operator:type
|
private
|
no
|
etat
|
RUINE
|
|
demolished:building
or historic
|
*
ruins for MARAE only
|
no
|
etat
|
EN_CONSTR
|
|
operational_status
|
under_construction
|
yes but more than 60 000 use
|
etat
|
EN_FONCTION
|
|
operational_status
|
operational
|
yes but more than 60 000 use
|
materiau
|
LEGER
|
|
building:material
|
light
|
yes
|
materiau
|
DUR
|
|
building:material
|
hard
|
yes
|
materiau
|
HANGAR-SILO
|
|
building
|
warehouse
|
no
|
materiau
|
SERRE
|
|
building
|
greenhouse
|
no
|
nom
|
|
|
name
|
*
|
no
|
|
|
|
building
|
yes
|
no
|
Manmade points
Process: add centroids of transformers from building layer
show
Transformation table for manmade points
categorie
|
0
|
Antenne (relai vini, hz..)
|
man_made
|
beacon
|
no
|
categorie
|
1
|
Balise de guidage/navigation (avec ou sans feu)
|
man_made
pumping_station
|
pumping_station
water
|
no
|
categorie
|
2
|
Captage (station pompage au fil de l’eau)
|
power
generator:source
generator:method
|
generator
wind
wind_turbine
|
no
|
categorie
|
3
|
Eolienne
|
power
|
pole
|
no
|
categorie
|
4
|
Pylône
|
|
|
no
|
sous categorie
|
REL_MOBILE
|
|
man_made
tower:type
communication:mobile_phone
|
mast
communication
yes
|
no
|
sous categorie
|
PARABOLE
|
|
man_made
tower:type
communication:microwave
|
mast
communication
yes
|
no
|
sous categorie
|
MIXTE
|
|
man_made
|
mast
|
no
|
sous categorie
|
ELEC
|
Pylone pour ligne électrique
|
power
|
tower
|
no
|
etat
|
EN FONCTION
|
|
operational_status
|
operational
|
yes but largely used (>60000 use)
|
nom
|
*
|
|
name
|
*
|
no
|
Linear limits
show
Transformation table for linear limits
categorie
|
3
|
Ligne électrique
|
power
operator
|
line
EDT ENGIE
|
no
|
sous categorie
|
QUAI
|
|
man_made
|
quay
|
no
|
sous categorie
|
BARRAGE
|
|
waterway
|
dam
|
no
|
sous categorie
|
ENROCHEMENT
|
|
barrier
wall:material
|
retaining_wall
stones
|
no
|
etat
|
EN FONCTION
|
|
operational_status
|
operational
|
yes but largely used (>60000 use)
|
etat
|
EN RUINE
|
|
demolished:key
|
value
|
no
|
nom
|
*
|
|
name
|
*
|
no
|
position_sol
|
1
|
|
location
|
roof
|
no
|
position_sol
|
0
|
|
location
|
surface
|
no
|
position_sol
|
-1
|
|
location
|
underground
|
no
|
materiau
|
LEGER
|
|
material
|
light
|
yes
|
materiau
|
DUR
|
|
material
|
hard
|
yes
|
Horizontal man made area
Data quality : SAU to clean up classification
Quality improvement : update types from names when available
Selection: Swimming pools with no names excluded as most of them are private.
show
Transformation table for Horizontal man made
categorie
|
1
|
Cimetière
|
landuse
|
cemetery
|
no
|
categorie
|
2
|
piscine
|
leisure
|
swimming_pool
|
no
|
categorie
|
4
|
Parking
|
amenity
|
parking
|
no
|
categorie
|
9
|
Ponton
|
man_made
floating
|
pier
yes
|
no
|
sous categorie
|
PISTE
|
Piste aéronautique : décollage/atterrissage
|
man_made
|
aeroway
|
no
|
sous categorie
|
PLATEAU_MULTI_SPORT
|
Plateau multi sport : basket / hand / volley / etc.
|
leisure
sport
|
pitch
multi
|
no
|
sous categorie
|
TERRAIN_FOOT
|
Terrain de Football / Rugby
|
leisure
sport
|
pitch
soccer
|
no
|
sous categorie
|
TERRAIN_TENNIS
|
Terrain de Tennis
|
leisure
sport
|
pitch
tennis
|
no
|
sous categorie
|
GOLF
|
Parcours/practice de golf
|
leisure
|
golf_course
|
no
|
sous categorie
|
PISTE_SPORT
|
Piste de sport / athlétisme
|
leisure
|
track
|
no
|
sous categorie
|
BOULO
|
Boulodrome
|
leisure
sport
|
pitch
bowls
|
no
|
sous categorie
|
MARAE
|
Marae
|
boundary
protect_class
|
protected_area
21
|
no
|
sous categorie
|
CENTRALE_SOLAIRE
|
Centrale solaire
|
power
plant:source
|
plant
solar
|
no
|
sous categorie
|
DALLE
|
Dalle en dur (béton)
|
area
surface
|
yes
concrete
|
no
|
sous categorie
|
PONTON
|
Ponton
|
man_made
floating
|
pier
yes
|
no
|
etat
|
RUINE
|
|
demolished:key
|
value
|
no
|
etat
|
EN_FONCTION
|
|
operational_status
|
operational
|
no
|
gestionnaire
|
PAYS
|
|
operator
operator:type
|
Pays
government
|
no
|
gestionnaire
|
PRIVE
|
|
operator:type
|
private
|
no
|
gestionnaire
|
COMMUNE
|
|
operator:type
government
|
government
commune
|
no
|
position_sol
|
1
|
|
location
|
roof
|
no
|
position_sol
|
0
|
|
location
|
surface
|
no
|
position_sol
|
-1
|
|
location
|
underground
|
no
|
materiau
|
herbe
|
|
surface
|
grass
|
no
|
materiau
|
LEGER
|
|
material
|
light
|
yes
|
materiau
|
DUR
|
|
material
|
hard
|
yes
|
nom
|
|
|
name
|
|
no
|
Highway
Furnitures
Process: categories 0, 3, 4 to be projected on the highway as they need to be on a point of the highway.
show
Transformation table for highways furniture
categorie
|
0
|
Borne kilométrique (PK)
|
highway
|
milestone
|
no
|
categorie
|
1
|
Borne incendie
|
emergency
|
fire_hydrant
|
no
|
categorie
|
2
|
Lampadaire
|
highway
|
street_lamp
|
no
|
categorie
|
3
|
Ralentisseur
|
traffic_calming
|
yes
|
no
|
categorie
|
4
|
Passage piéton
|
highway
|
crossing
|
no
|
etat
|
EN FONCTION
|
|
operational_status
|
operational
|
yes but largely used (>60000 use)
|
kilometrage
|
int
|
|
distance
|
*
|
no
|
designation
|
text
|
associate PK to its area/zone.
|
network
|
text
|
might be experimental for KP, but is approved for other features.
|
Highways
Data quality : SAU is cleaning and improving this dataset (geometry and qualification).
Finally, following the trial on Arue pilote, this is more part of an integration process as everything has gone manually, following those reasons :
- difficulty to automatically cut or expand when needed (need manual interaction)
- difficulty to find road equivalent from one dataset to the other due to itinerary and itinerary break differences
- difficulty to merge one road network to OSM road network as OSM may have attributes on points (need manual interaction)
- easier to go all manual due to the quantity of data to integer
show
Transformation table for highways
classement
|
SECONDAIRE
|
|
highway
|
secondary
|
no
|
categorie
|
PRIMAIRE
|
|
highway
|
primary
|
no
|
categorie
|
INDETERMINE
|
|
highway
|
road
|
no
|
categorie
|
SERVICE
|
|
highway
|
service
|
no
|
categorie
|
RUE_PIETONNE
|
|
highway
|
pedestrian
|
no
|
categorie
|
PISTE4-4
|
|
highway
smoothness
|
road
horrible
|
no
|
categorie
|
PIETON
|
|
highway
|
footway
|
no
|
categorie
|
SENTIER
|
|
highway
|
path
|
no
|
categorie
|
CYCLABLE
|
|
highway
|
cycleway
|
no
|
categorie
|
RESIDENTIEL
|
|
highway
|
residential
|
no
|
categorie
|
TERTIAIRE
|
|
highway
|
tertiary
|
no
|
sens
|
DOUBLE
|
|
oneway
|
no
|
no
|
sens
|
UNIQUE_INVNUM
|
|
oneway
|
-1
|
no
|
sens
|
UNIQUE_NUM
|
|
oneway
|
yes
|
no
|
condition
|
EN_SERVICE
|
|
operational_status
|
operational
|
no
|
condition
|
EN_CONSTR
|
|
highway
|
construction
|
no
|
gestionaire
|
PAYS
|
|
operator
|
Pays
|
no
|
gestionaire
|
PRIVE
|
|
operator:type
|
private
|
no
|
position_sol
|
AU_SOL
|
|
location
|
surface
|
no
|
position_sol
|
PASS_SUP
|
|
layer
|
1
|
no
|
position_sol
|
TUNNEL
|
|
tunnel
covered
|
yes
yes
|
no
|
position_sol
|
PASS_INF
|
|
layer
|
-1
|
no
|
position_sol
|
PASSAGE_GUE
|
|
ford
|
yes
|
no
|
revetement
|
NON_REVETU
|
|
surface
|
unpaved
|
no
|
revetement
|
REVETU
|
|
surface
|
paved
|
no
|
nature
|
ROND-POINT
|
|
junction
|
roundabout
|
no
|
nom
|
|
|
name
|
*
|
no
|
autre_nom
|
|
|
access:description
|
*
|
no
|
Topography
Cliffs and ridge
Data quality : SAU is cleaning cliffs orientation.
Selection : select cliffs and ridge only from contour line layer.
show
Transformation table for cliffs
sous categorie
|
FALAISE
|
|
natural
|
cliff
|
no
|
sous categorie
|
CRETE
|
|
natural
|
ridge
|
no
|
nom
|
|
|
name
|
*
|
no
|
Selection : only remarkable topographic points (peaks, saddles)
Process: extract elevation in a specific field (original layer is 2.5 pt layer).
ele:local is used to say that the altimetric reference system has been built with GPS altimetry. This is not proper precise levelling process and this way is independant from NGPF (general levelling for french polynesia)
show
Transformation table for remarkable points
altitude
|
*
|
|
ele:ngpf or ele:local
|
float
|
no
|
ele:local:description (if ele:local not null)
|
On entend par local qu’il a été réalisé par interpolation GPS (pas un système de nivellement de précision). Ce faisant il ne bénéficie pas de code associé.
|
no
|
categorie
|
1
|
Sommet intermédiaire
|
natural
|
peak
|
no
|
categorie
|
2
|
Col
|
natural
|
saddle
|
no
|
categorie
|
0
|
Sommet principal
|
natural
|
peak
|
no
|
|
nom
|
*
|
|
name
|
*
|
no
|
Geodesic reference points
Selection : from RGPF only, with a code_repere
Process :
- adapt ele ref system, name depending on location.
- Get lat, long, ele from geometry
Info: id_repere is the unique id of the reference point, code_repere is the name used for it. id_repere is unique, code_repere is not unique for the whole of FP. code_repere + island ID is unique. So this is the concatenation being used for name.
SAU is going to publish the geodesic reference points pdf records on the future, which will be possible to gather through id_repere (ref) and source = SAU in the future. So url and url:description are temporary and could be removed from this time and replaced with Tag2Link use.
show
Transformation table for geodesic reference points
categorie_repere
|
0
|
Repère/station géodésique
|
triangulation_point
man_made
url
url:description
|
yes
survey_point
ftp://aveia.gov.pf/Fiches/RGPF%20Reperes%20geodesiques/0%20fiches%20individuelles/
L'ensemble des fiches sont accessibles via solution FTP à l'adresse indiquée
|
no
|
categorie_repere
|
1
|
Repère de nivellement
|
benchmark
man_made
url
url:description
|
yes
survey_point
ftp://aveia.gov.pf/Fiches/NGPF%20Reperes%20de%20nivellement/0%20fiches%20individuelles/
L'ensemble des fiches sont accessibles via solution FTP à l'adresse indiquée
|
no
|
ordre
|
B
|
Base 1er réseau densification (1 point par île)
|
survey_point
network
|
trig_1st
"RRPF - " + ordre
|
no
|
ordre
|
D
|
Densification, 2ème densification (1 point/10km)
|
survey_point
network
|
trig_2nd
"RRPF - " + ordre
|
no
|
ordre
|
R
|
Référence réseau de base 13 points DORIS
|
survey_point
network
|
trig_1st
"RRPF - " + ordre
|
no
|
ordre
|
4
|
4ème Densification (VRS Aveia)
|
survey_point
network
|
trig_4th
"RRPF - " + ordre
|
no
|
ordre
|
3
|
3ème Densification (1 point/5km) et/ou station VRS
|
survey_point
network
|
trig_3rd
"RRPF - " + ordre
|
no
|
dernier_etat
|
VALABLE_BON
|
|
operational_status
|
operational
|
yes but >60000 use
|
dernier_etat
|
VALABLE
|
|
operational_status
|
operational
|
yes but >60000 use
|
dernier_etat
|
VALABLE_MOYEN
|
|
operational_status
|
operational
|
yes but >60000 use
|
dernier_etat
|
NON_EXPLOITABLE
|
|
operational_status
|
out_of_order
|
yes but >60000 use
|
dernier_etat
|
VALABLE_MAUVAIS
|
|
operational_status
|
operational
|
yes but >60000 use
|
dernier_etat
|
NON_RETROUVE
|
|
operational_status
operational_status:description
|
no
non retrouve
|
yes but >60000 use
|
code_repere
|
string
|
|
name
|
code_repere + « - » + id_ile
|
no
|
date_creation
|
yyyy-mm-dd
|
|
start_date
|
yyyy-mm-dd
|
no
|
nature_repere
|
string
|
|
survey_point:description
|
|
no
|
designation
|
string
|
|
description
|
designation + « - » + remarque
|
no
|
remarque
|
string
|
|
description
|
designation + « - » + remarque
|
no
|
proprietaire_autorisation
|
string
|
|
access:description
|
proprietaire_autorisation + "-" + temps_acces
|
no
|
temps_acces
|
string
|
|
access:description
|
proprietaire_autorisation + "-" + temps_acces
|
no
|
date_dernier_etat
|
yyyy-mm-dd
|
|
check_date
|
yyyy-mm-dd
|
no
|
id_repere
|
int
|
|
ref
|
*
|
|
|
|
|
source
|
SAU
|
|
|
|
|
longitude:rgpf
|
float
|
yes but longitude>5000 use
|
|
|
|
latitude:rgpf
|
float
|
yes but latitude>5000 use
|
|
|
|
ele:ngpf or ele:local
ele:local:description
|
int
On entend par local qu’il a été réalisé par interpolation GPS (pas un système de nivellement de précision). Ce faisant il ne bénéficie pas de code associé.
|
no
|
Point of interest
Data quality : classification incoherence being cleaned by SAU.
Quality Improvement : classify from name automatically
show
Transformation table for points of interest
sous_categorie
|
AERIEN
|
|
aeroway
|
aerodrome
|
no
|
sous_categorie
|
ARCHEO
|
|
historic
|
ruins
|
no
|
sous_categorie
|
BANQUE
|
|
amenity
|
bank
|
no
|
sous_categorie
|
BATI_SPORT
|
|
leisure
fixme
|
sports_centre
à vérifier et adapter en club=sport en fonction de la taille
|
no
|
sous_categorie
|
BELVEDERE-PANORAMA
|
|
tourism
|
viewpoint
|
no
|
sous_categorie
|
BOULO
|
|
leisure
sport
|
pitch
bowls
|
no
|
sous_categorie
|
CAMPING
|
|
tourism
|
camp_site
|
no
|
sous_categorie
|
CASCADE
|
|
waterway
|
waterfall
|
no
|
sous_categorie
|
CENTRE_ARTISANAL
|
|
craft
|
atelier
|
no
|
sous_categorie
|
CENTRE_MEDIC
|
|
amenity
|
doctors
|
no
|
sous_categorie
|
CENTRE_PLONGEE
|
|
amenity
|
dive_centre
|
no
|
sous_categorie
|
CENTRE_SOIN
|
|
amenity
|
doctors
|
no
|
sous_categorie
|
CIRCUIT
|
|
highway
fixme
|
raceway
tracer le chemin si possible
|
no
|
sous_categorie
|
COLLEGE
|
|
building
amenity
school:FR
|
school
school
collège
|
no
|
sous_categorie
|
COMMERCE
|
|
shop
fixme
|
yes
affiner le type de magasin si possible
|
no
|
sous_categorie
|
CURIOSITE
|
|
tourism
|
yes
|
no
|
sous_categorie
|
ECOLE_ELEM
|
|
amenity
school:FR
|
school
élémentaire
|
no
|
sous_categorie
|
ECOLE_MAT
|
|
amenity
school:FR
|
school
maternelle
|
no
|
sous_categorie
|
ECOLE_PRIM
|
|
amenity
school:FR
|
school
primaire
|
no
|
sous_categorie
|
EGLISE
|
|
amenity
|
place_of_worship
|
no
|
sous_categorie
|
ESPACE_CULT
|
|
amenity
community_centre
|
community_centre
cultural_centre
|
no
|
sous_categorie
|
ETAB_RECHERCHE
|
|
amenity
|
research_institute
|
no
|
sous_categorie
|
ETAB_SUP
|
|
amenity
|
university
|
no
|
sous_categorie
|
FORMATION_PROF
|
|
amenity
|
college
|
no
|
sous_categorie
|
GENDAR
|
|
amenity
police:FR
operator
|
police
gendarmerie
Gendarmerie nationale
|
no
|
sous_categorie
|
GOLF
|
|
leisure
|
golf_course
|
no
|
sous_categorie
|
GROTTE
|
|
natural
|
cave_entrance
|
no
|
sous_categorie
|
HIPPO
|
|
leisure
sport
|
track
horse_racing
|
no
|
sous_categorie
|
HOPITAL_CLINIQUE
|
|
amenity
fixme
|
clinic
à vérifier, adapter en hopital le cas échéant.
|
no
|
sous_categorie
|
HOTEL
|
|
tourism
|
hotel
|
no
|
sous_categorie
|
INDUSTRIE
|
|
landuse
|
industrial
|
no
|
sous_categorie
|
LYCEE
|
|
amenity
school:FR
|
school
lycée
|
no
|
sous_categorie
|
MAIRIE
|
|
amenity
|
townhall
|
no
|
sous_categorie
|
MARAE_PAEPAE
|
|
boundary
protect_class
fixme
|
protected_area
21
dessiner l’emprise si possible
|
no
|
sous_categorie
|
MARCHE
|
|
amenity
|
marketplace
|
|
sous_categorie
|
MARITIME
|
Gare maritime
|
public_transport
amenity
|
station
ferry_terminal
|
no
|
sous_categorie
|
MILITAIRE
|
|
military
|
yes
|
no
|
sous_categorie
|
MONUMENT
|
|
historic
|
monument
|
no
|
sous_categorie
|
MUSEE
|
|
tourism
|
museum
|
no
|
sous_categorie
|
PARC_PUBLIC
|
|
leisure
|
park
|
no
|
sous_categorie
|
PARKING
|
|
amenity
|
parking
|
no
|
sous_categorie
|
PENSION_FAMILLE
|
|
touism
|
guest_house
|
no
|
sous_categorie
|
PHARE
|
|
man_made
|
lighthouse
|
no
|
sous_categorie
|
PHARMACIE
|
|
amenity
|
pharmacy
|
no
|
sous_categorie
|
PLAGE
|
|
natural
|
beach
|
no
|
sous_categorie
|
PLATEAU_SPORTIF
|
|
leisure
sport
|
pitch
multi
|
no
|
sous_categorie
|
POLICE
|
|
amenity
police:FR
|
police
police
|
no
|
sous_categorie
|
POMPIER
|
|
amenity
|
fire_station
|
no
|
sous_categorie
|
PORT_PLAISANCE
|
|
landuse
|
marina
|
no
|
sous_categorie
|
POSTE
|
|
amenity
|
post_office
|
no
|
sous_categorie
|
PRISON
|
|
amenity
|
prison
|
no
|
sous_categorie
|
REFUGE
|
|
tourism
|
wilderness_hut
|
no
|
sous_categorie
|
RESTO
|
|
amenity
fixme
|
restaurant
à vérifier et adapter le cas échéant (si restauration rapide..)
|
no
|
sous_categorie
|
ROUTIER
|
Gare routière
|
public_transport
amenity
|
station
bus_station
|
no
|
sous_categorie
|
SECT_PRIMAIRE
|
|
operator:type
|
private
|
no
|
sous_categorie
|
SERV_ADMIN
|
|
office
|
government
|
no
|
sous_categorie
|
STAT-SERVICE
|
|
amenity
|
fuel
|
no
|
sous_categorie
|
SYNAGOGUE
|
|
amenity
religion
|
place_of_worship
jewish
|
no
|
sous_categorie
|
TEMPLE
|
|
amenity
fixme
|
place_of_worship
specifier religion et denomination si possible
|
no
|
sous_categorie
|
TERRAIN_FOOT
|
|
leisure
sport
|
pitch
soccer
|
no
|
sous_categorie
|
TERRAIN_TENNIS
|
|
leisure
sport
|
pitch
tennis
|
no
|
sous_categorie
|
TRIBUNAL
|
|
amenity
|
courthouse
|
no
|
sous_categorie
|
ZONE_ACTIV
|
|
landuse
fixme
|
industrial
dessiner la zone si possible
|
no
|
vocation_tour
|
1
|
|
tourism
|
yes
|
no
|
nom
|
string
|
|
name
|
|
no
|
Localities
show
Transformation table for localities
sous categorie
|
RECIF
|
|
natural
place
|
reef
locality
|
no
|
sous categorie
|
PASSE
|
|
natural
place
|
strait
locality
|
no
|
sous categorie
|
BANC
|
|
natural
reef
|
reef
sand
|
no
|
sous categorie
|
CHEF_LIEU
|
|
place
|
village
|
no
|
sous categorie
|
VILLAGE
|
|
place
|
village
|
no
|
sous categorie
|
NON-HABITE
|
|
place
|
locality
|
no
|
sous categorie
|
BAIE
|
|
natural
|
bay
|
no
|
sous categorie
|
COL
|
|
natural
|
saddle
|
no
|
sous categorie
|
CRETE
|
|
natural
|
ridge
|
no
|
sous categorie
|
FALAISE
|
|
natural
|
cliff
|
no
|
sous categorie
|
GRP_HABITATION
|
|
place
|
neighbourhood
|
no
|
sous categorie
|
LAGON
|
|
natural
water
|
water
lagoon
|
no
|
sous categorie
|
MOTU
|
|
place
|
islet
|
yes
|
sous categorie
|
PLATEAU
|
|
natural
|
plateau
|
no
|
sous categorie
|
POINTE
|
|
place
|
locality
|
no
|
sous categorie
|
RESIDENCE
|
|
building
|
apartments
|
no
|
sous categorie
|
ROCHER
|
|
natural
|
rock
|
no
|
sous categorie
|
SOMMET
|
|
natural
|
peak
|
no
|
sous categorie
|
VALLEE
|
|
natural
fixme
|
valley
dessiner la zone si possible
|
no
|
vocation_tour
|
1
|
|
tourism
|
yes
|
no
|
nom
|
|
|
name
|
*
|
no
|
Import follow up
edi_bati
|
buildings and usage when available
|
#74988674, #74988677, #74988683, #74988693
|
https://www.openstreetmap.org/user/A%20Vos%20Cartes%20-%20Imports/history#map=5/-16.380/-144.800
|
edi_construction_p
|
punctual manmade points (beacon, antenna, power pole...)
|
#75027116
|
edi_construction_l
|
linear manmade limits (fence, wall, dam...)
|
#75026237
|
edi_construction_s
|
horizontal man made objects (such as parking, swimming pool, etc).
|
#75026934
|
voi_mobilier_route_p
|
highway furniture (KM point, lamp..)
|
#75030231
|
voi_troncon_route_l
|
highway
|
#74936826
|
rel_lignes_repere
|
contour lines, and specific contour lines (cliff...)
|
#75029646
|
rel_points_cotes
|
figure field including peaks and other remarkable points
|
nodata
|
ref_repere
|
geodesic reference point
|
#75029614
|
nom_pai
|
point of interest
|
#75028891
|
nom_toponyme
|
localty names
|
#75029107
|