Ok, je range mon accent à 2 balles...
en fait j'ai une bonne expérience en PL/SQL (programmation sous Oracle)
aussi je peux produire ce que je veux avec un ptit peu de dév néanmoins en
brut sans se prendre la tête je peux sortir ça :
table structure :
INSEE ; 1er champ adresse; 2ème champ adresse; 3ème champ adresse; Geometry
example of a road in WKT :
40044;Chemin rural;du;Moulin de Biaudos à Biarrotte;LINESTRING (1354056.098
3158605.598, 1353999.791 3158605.876, 1353995.724 3158601.585, 1353985.238
3158572.738, 1353957.921 3158535.841, 1353939.684 3158518.507, 1353874.185
3158475.632, 1353830.961 3158479.148, 1353792.258 3158467.703, 1353754.848
3158467.096, 1353707.828 3158452.319, 1353678.685 3158438.98, 1353628.859
3158414.6, 1353621.269 3158414.137, 1353605.082 3158425.91)
example of a point adress in WKT :
INSEE ; number adress; first field Adresse ; second field Adress ; third
field Adresse ; Geometry
40044;32;Allée;de;Lahounit;POINT (1351410.78694129 3159018.3720919)
example of a road in GML :
40044 Chemin rural du
Moulin de Biaudos à Biarrotte <gml:LineString
srsName="SDO:" xmlns:gml="http://www.opengis.net/gml";><gml:coord
inates decimal="." cs="," ts=" ">1354056.098,3158605.598
1353999.791,3158605.876
1353995.724,3158601.585 1353985.238,3158572.738 1353957.921,3158535.841
1353939
.684,3158518.507 1353874.185,3158475.632 1353830.961,3158479.148
1353792.258,315
8467.703 1353754.848,3158467.096 1353707.828,3158452.319
1353678.685,3158438.98
1353628.859,3158414.6 1353621.269,3158414.137 1353605.082,3158425.91
</gml:coord
inates></gml:LineString>
example of a point adress in GML :
40044 32 Allée de
Lahounit <gml:Point srsName="SDO:"
xmlns:gml="http://www.opengis.net/gml";><gml:coordinate
s decimal="." cs="," ts=" ">1351410.78694129,3159018.3720919
</gml:coordinates><
/gml:Point>
--
View this message in context:
http://n2.nabble.com/Re-Imports-Import-Many-Data-in-OSM-tp4631859p4632649.html
Sent from the France mailing list archive at Nabble.com.
_______________________________________________
Talk-fr mailing list
Talk-fr@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-fr
