Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

No changes between revisions

Ignore whitespace Rev 165 → Rev 166

/trunk/docs/osm/bdd/OSM.mwb
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/docs/osm/bdd/OSM.mwb
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/docs/osm/bdd/CommunesFrance.sql
New file
0,0 → 1,101
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 15 Juin 2011 à 16:30
-- Version du serveur: 5.5.8
-- Version de PHP: 5.3.5
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
--
-- Base de données: `osmMAJ`
--
 
-- --------------------------------------------------------
 
--
-- Structure de la table `osm_communes`
--
 
CREATE TABLE IF NOT EXISTS `osm_communes` (
`id_relation` int(11) NOT NULL,
`nom` text NOT NULL,
`code_insee` varchar(11) NOT NULL,
`polygon` multipolygon DEFAULT NULL,
`note` varchar(100) NOT NULL,
`centre` point NOT NULL,
PRIMARY KEY (`id_relation`),
KEY `INSEE` (`code_insee`),
KEY `communeOSM_polygone_index` (`polygon`(767),`centre`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
--
-- Structure de la table `osm_chemin_a_noeuds`
--
 
CREATE TABLE IF NOT EXISTS `osm_chemin_a_noeuds` (
`id_chemin` int(11) NOT NULL,
`id_noeud` int(11) NOT NULL,
`ordre` int(11) NOT NULL,
PRIMARY KEY (`id_chemin`,`id_noeud`,`ordre`),
KEY `id_way` (`id_chemin`),
KEY `id_node` (`id_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
 
-- --------------------------------------------------------
 
--
-- Structure de la table `osm_noeuds`
--
 
CREATE TABLE IF NOT EXISTS `osm_noeuds` (
`id_noeud` int(11) NOT NULL,
`lat` double NOT NULL,
`long` double NOT NULL,
PRIMARY KEY (`id_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
--
-- Structure de la table `osm_relations`
--
 
CREATE TABLE IF NOT EXISTS `osm_relations` (
`id_relation` int(11) NOT NULL,
`nom` text NOT NULL,
`code_insee` varchar(11) NOT NULL,
PRIMARY KEY (`id_relation`),
KEY `INSEE` (`code_insee`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
--
-- Structure de la table `osm_relation_a_chemins`
--
 
CREATE TABLE IF NOT EXISTS `osm_relation_a_chemins` (
`id_relation` int(11) NOT NULL,
`id_chemin` int(11) NOT NULL,
`role` varchar(20) CHARACTER SET latin1 NOT NULL,
`ordre` int(11) NOT NULL,
`sens` varchar(15) CHARACTER SET latin1 NOT NULL,
`nbre_poly` int(11) NOT NULL,
PRIMARY KEY (`id_relation`,`id_chemin`),
KEY `role` (`role`),
KEY `ordre` (`ordre`),
KEY `sens` (`sens`),
KEY `nbPoly` (`nbre_poly`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
/trunk/docs/osm/bdd/osm.mdb.mwb
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/docs/osm/bdd/osm.mdb.mwb
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/docs/osm/bdd/osm2.pdf
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/docs/osm/bdd/osm2.pdf
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property