Git Repositories

Meilleure recherche affinée même sans l'aide de la proximité géographique
authorCyrille Pontvieux <cyrille@enialis.net>
Thu, 3 Nov 2016 00:16:37 +0000 (01:16 +0100)
committerCyrille Pontvieux <cyrille@enialis.net>
Thu, 3 Nov 2016 00:16:37 +0000 (01:16 +0100)
README.txt
pom.xml
src/main/java/com/viseo/xerox/elastic/ESJsonConfig.java
src/main/java/com/viseo/xerox/elastic/ESRequest.java
src/main/java/com/viseo/xerox/elastic/Main.java
src/main/resources/insert_data.sql

index e4dbf53..2337172 100644 (file)
@@ -22,10 +22,10 @@ Le projet
 JDK 8 nécessaire
 Créer le paquet avec maven :
   mvn package
-Créer la base de données :
-  java -jar target/xerox-elastic-poc-1.0-shaded.jar create
-Indexer les données :
-  java -jar target/xerox-elastic-poc-1.0-shaded.jar index
-Faire des recherches :
-  java -jar target/xerox-elastic-poc-1.0-shaded.jar query
+Exécuter le jar avec :
+  java -jar target/xerox-elastic-poc-1.0.jar [action]
+Actions possible :
+  create : créer la base de données
+  index  : indexer les données
+  query  : faire des recherches
 
diff --git a/pom.xml b/pom.xml
index 89e4acf..47ded65 100644 (file)
--- a/pom.xml
+++ b/pom.xml
             <version>2.8.4</version>
         </dependency>
     </dependencies>
+    <profiles>
+        <profile>
+            <id>query</id>
+            <activation>
+                <activeByDefault>true</activeByDefault>
+            </activation>
+            <properties>
+                <exec-argument>query</exec-argument>
+            </properties>
+        </profile>
+        <profile>
+            <id>create</id>
+            <properties>
+                <exec-argument>create</exec-argument>
+            </properties>
+        </profile>
+        <profile>
+            <id>index</id>
+            <properties>
+                <exec-argument>index</exec-argument>
+            </properties>
+        </profile>
+    </profiles>
     <build>
         <plugins>
             <plugin>
@@ -75,7 +98,7 @@
                             <goal>shade</goal>
                         </goals>
                         <configuration>
-                            <shadedArtifactAttached>true</shadedArtifactAttached>
+                            <shadedArtifactAttached>false</shadedArtifactAttached>
                             <transformers>
                                 <transformer implementation="org.apache.maven.plugins.shade.resource.ManifestResourceTransformer">
                                     <mainClass>com.viseo.xerox.elastic.Main</mainClass>
                     </execution>
                 </executions>
             </plugin>
+            <plugin>
+                <groupId>org.codehaus.mojo</groupId>
+                <artifactId>exec-maven-plugin</artifactId>
+                <version>1.5.0</version>
+                <executions>
+                    <execution>
+                        <goals>
+                            <goal>java</goal>
+                        </goals>
+                    </execution>
+                </executions>
+                <configuration>
+                    <mainClass>com.viseo.xerox.elastic.Main</mainClass>
+                    <arguments>
+                        <argument>${exec-argument}</argument>
+                    </arguments>
+                </configuration>
+            </plugin>
         </plugins>
     </build>
-</project>
\ No newline at end of file
+</project>
index 2017be9..add2498 100644 (file)
@@ -165,77 +165,99 @@ public class ESJsonConfig {
     public String getJsonQuery(String queryString, double latitude, double longitude) throws IOException {
         StringWriter stringWriter = new StringWriter();
         JsonGenerator jg = factory.createGenerator(stringWriter);
+        jg.writeStartObject();
         switch (searchMode) {
             case BY_SCORE:
-                // @formatter:off
-                jg.writeStartObject();
-                    jg.writeObjectFieldStart("query");
-                        jg.writeObjectFieldStart("multi_match");
-                            writeQueryOptions(jg, queryString);
-                            writeSearchFields(jg);
-                        jg.writeEndObject();
-                    jg.writeEndObject();
-                    jg.writeArrayFieldStart("sort");
-                        jg.writeString("_score");
-                        // this will not sort by geo distance but will compute it nevertheless
-                        writeJsonGeoSorting(latitude, longitude, jg);
-                    jg.writeEndArray();
-                    jg.writeBooleanField("track_scores", true);
-                jg.writeEndObject();
-                // @formatter:on
+                writeByScore(jg, queryString, latitude, longitude);
                 break;
             case BY_PROXIMITY:
-                // @formatter:off
-                jg.writeStartObject();
-                    jg.writeObjectFieldStart("query");
-                        jg.writeObjectFieldStart("multi_match");
-                            writeQueryOptions(jg, queryString);
-                            writeSearchFields(jg);
-                        jg.writeEndObject();
-                    jg.writeEndObject();
-                    jg.writeArrayFieldStart("sort");
-                        writeJsonGeoSorting(latitude, longitude, jg);
-                    jg.writeEndArray();
-                    jg.writeBooleanField("track_scores", true);
-                jg.writeEndObject();
-                // @formatter:on
+                writeByProximity(jg, queryString, latitude, longitude);
                 break;
             case BY_SCORE_AND_PROXIMITY:
-                // @formatter:off
-                jg.writeStartObject();
-                    jg.writeObjectFieldStart("query");
-                        jg.writeObjectFieldStart("function_score");
-                            jg.writeObjectFieldStart("query");
-                                jg.writeObjectFieldStart("multi_match");
-                                    writeQueryOptions(jg, queryString);
-                                    writeSearchFields(jg);
-                                jg.writeEndObject();
-                            jg.writeEndObject();
-                            jg.writeArrayFieldStart("functions");
-                                jg.writeStartObject();
-                                    writeExpDistanceDecayScore(jg, latitude, longitude, 10, 50, 0.33 );
-                                jg.writeEndObject();
-                            jg.writeEndArray();
-                            jg.writeStringField("boost_mode", "multiply");
-                        jg.writeEndObject();
-                    jg.writeEndObject();
-                    jg.writeArrayFieldStart("sort");
-                        jg.writeString("_score");
-                        // this will not sort by geo distance but will output it
-                        writeJsonGeoSorting(latitude, longitude, jg);
-                    jg.writeEndArray();
-                    jg.writeBooleanField("track_scores", true);
-                jg.writeEndObject();
-                // @formatter:on
+                writeByScoreAndProximity(jg, queryString, latitude, longitude);
                 break;
         }
+        jg.writeEndObject();
         jg.close();
         return stringWriter.toString();
     }
 
-    private void writeQueryOptions(JsonGenerator jg, String queryString) throws IOException {
+    private void writeByScore(JsonGenerator jg, String queryString, double latitude, double longitude) throws IOException {
+        // @formatter:off
+        jg.writeObjectFieldStart("query");
+            writeDisMaxQuery(jg, queryString);
+        jg.writeEndObject();
+        jg.writeArrayFieldStart("sort");
+            jg.writeString("_score");
+            // this will not sort by geo distance but will compute it nevertheless
+            writeJsonGeoSorting(latitude, longitude, jg);
+        jg.writeEndArray();
+        jg.writeBooleanField("track_scores", true);
+        // @formatter:on
+    }
+
+    private void writeByProximity(JsonGenerator jg, String queryString, double latitude, double longitude) throws IOException {
+        // @formatter:off
+        jg.writeObjectFieldStart("query");
+            writeDisMaxQuery(jg, queryString);
+        jg.writeEndObject();
+        jg.writeArrayFieldStart("sort");
+            writeJsonGeoSorting(latitude, longitude, jg);
+        jg.writeEndArray();
+        jg.writeBooleanField("track_scores", true);
+        // @formatter:on
+    }
+
+    private void writeByScoreAndProximity(JsonGenerator jg, String queryString, double latitude, double longitude) throws IOException {
+        // @formatter:off
+        jg.writeObjectFieldStart("query");
+            jg.writeObjectFieldStart("function_score");
+                jg.writeObjectFieldStart("query");
+                    writeDisMaxQuery(jg, queryString);
+                jg.writeEndObject();
+                jg.writeArrayFieldStart("functions");
+                    jg.writeStartObject();
+                        writeExpDistanceDecayScore(jg, latitude, longitude, 10, 50, 0.33 );
+                    jg.writeEndObject();
+                jg.writeEndArray();
+                jg.writeStringField("boost_mode", "multiply");
+            jg.writeEndObject();
+        jg.writeEndObject();
+        jg.writeArrayFieldStart("sort");
+            jg.writeString("_score");
+            // this will not sort by geo distance but will output it
+            writeJsonGeoSorting(latitude, longitude, jg);
+        jg.writeEndArray();
+        jg.writeBooleanField("track_scores", true);
+        // @formatter:on
+    }
+
+    private void writeDisMaxQuery(JsonGenerator jg, String queryString) throws IOException {
+        // @formatter:off
+        jg.writeObjectFieldStart("dis_max");
+            jg.writeArrayFieldStart("queries");
+                writeMultiMatch(jg, queryString, "most_fields", false, "name^10", "town^10");
+                writeMultiMatch(jg, queryString, "most_fields", fuzziness, "name.french", "town.french");
+                writeMultiMatch(jg, queryString, "cross_fields", false, "name.french", "town.french");
+            jg.writeEndArray();
+        jg.writeEndObject();
+        // @formatter:on
+    }
+
+    private void writeMultiMatch(JsonGenerator jg, String queryString, String type, boolean fuzziness, String... fields) throws IOException {
+        // @formatter:off
+        jg.writeStartObject();
+            jg.writeObjectFieldStart("multi_match");
+                writeQueryOptions(jg, queryString, type,fuzziness);
+                writeSearchFields(jg, fields);
+            jg.writeEndObject();
+        jg.writeEndObject();
+        // @formatter:on
+    }
+
+    private void writeQueryOptions(JsonGenerator jg, String queryString, String type, boolean fuzziness) throws IOException {
         jg.writeStringField("query", queryString);
-        jg.writeStringField("type", fuzziness ? "best_fields" : "cross_fields");
+        jg.writeStringField("type", type);
         jg.writeStringField("operator", "and");
         jg.writeStringField("zero_terms_query", "all");
         if (fuzziness) {
@@ -243,12 +265,11 @@ public class ESJsonConfig {
         }
     }
 
-    private void writeSearchFields(JsonGenerator jg) throws IOException {
+    private void writeSearchFields(JsonGenerator jg, String... fields) throws IOException {
         jg.writeArrayFieldStart("fields");
-        jg.writeString("name^3");
-        jg.writeString("name.french^3");
-        jg.writeString("town");
-        jg.writeString("town.french");
+        for (String field : fields) {
+            jg.writeString(field);
+        }
         jg.writeEndArray();
     }
 
@@ -266,6 +287,7 @@ public class ESJsonConfig {
         // @formatter:on
     }
 
+    @SuppressWarnings("SameParameterValue")
     private void writeExpDistanceDecayScore(JsonGenerator jg, double latitude, double longitude, int offsetInKm, int scaleInKm, double decay) throws IOException {
         // @formatter:off
         jg.writeObjectFieldStart("exp");
index bab8d47..7f7b9f3 100644 (file)
@@ -93,11 +93,13 @@ public class ESRequest {
 
     public String find(String jsonRequest, String indexName, String queryString) throws URISyntaxException, IOException {
         printAction(String.format("Querying %s with « %s »…", indexName, queryString));
-        HttpGet get = new HttpGet(String.format("%s/%s/_search", url, indexName));
-        get.setURI(new URIBuilder(get.getURI()).addParameter("source", jsonRequest).build());
+        HttpGet get = new HttpGet(new URIBuilder(String.format("%s/%s/_search", url, indexName)).addParameter("source", jsonRequest).build());
+        LOG.debug("{}\n{}", get.getURI().getPath(), jsonRequest);
         HttpResponse response = getClient().execute(get);
         printResultStatus(response);
         InputStream content = response.getEntity().getContent();
-        return IOUtils.toString(content, StandardCharsets.UTF_8.name());
+        String result = IOUtils.toString(content, StandardCharsets.UTF_8.name());
+        LOG.debug("Result:\n{}", result);
+        return result;
     }
 }
index 105e5f2..e59b996 100644 (file)
@@ -36,7 +36,11 @@ public class Main {
         } catch (Exception e) {
             LOG.error(e.getMessage(), e);
         } finally {
-            EntityManagerProvider.getInstance().getEmf().close();
+            try {
+                EntityManagerProvider.getInstance().getEmf().close();
+            } catch (Exception e) {
+                e.printStackTrace();
+            }
         }
     }
 
@@ -202,9 +206,7 @@ public class Main {
 
     private List<Point> queryES(String queryString, double latitude, double longitude) throws IOException, URISyntaxException {
         String jsonRequest = esJsonConfig.getJsonQuery(queryString, latitude, longitude);
-        LOG.debug(jsonRequest);
         String jsonResult = new ESRequest(ESJsonConfig.ES_BASE_URL).find(jsonRequest, ESJsonConfig.INDEX_NAME, queryString);
-        LOG.debug(jsonResult);
         return esJsonConfig.parseJsonResult(jsonResult);
     }
 
index 9878c14..4ff0078 100644 (file)
@@ -500,8 +500,8 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('322213','322212','test2','0','0',null,'test2',null,null,'32E66E119FD746A15AE4B8DEE17D64C4ED682736',null,'1');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385759','293407','VOYAGES INGLARD','50.72788','2.5333',null,'FR:59295:POI:VOYAGES INGLARD:NAO568',null,null,'11865C164548C517E5075AF487DEA0F49EF115B4','Hazebrouck','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385760','293409','AUTOCARS SCHOONAERT','50.84125','2.20877',null,'FR:59307:POI:AUTOCARS SCHOONAERT:NAO568',null,null,'F6B256EAFC44C58BD4100A4F7DFA71798D7A73FF','Holque','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385764','293417','LE TOTEM','50.52949','2.93179',null,'FR:59011:POI:LE TOTEM:NAO568',null,null,'7BADB8A6D64361F008DC3003FB29996D2B1B9C6F','Ann�ullin','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385765','293419','A LA CIVETTE','50.68279','2.87856',null,'FR:59017:POI:A LA CIVETTE:NAO568',null,null,'D8B653384EFAFFE45F56FF77D04D66C5E1B256C0','Armenti�res','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385764','293417','LE TOTEM','50.52949','2.93179',null,'FR:59011:POI:LE TOTEM:NAO568',null,null,'7BADB8A6D64361F008DC3003FB29996D2B1B9C6F','Ann_ullin','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385765','293419','A LA CIVETTE','50.68279','2.87856',null,'FR:59017:POI:A LA CIVETTE:NAO568',null,null,'D8B653384EFAFFE45F56FF77D04D66C5E1B256C0','Armenti_res','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('321990','233784','AUTOCARS SCHOONAERT','50.84125','2.20877',null,'FR:59307:POI:AUTOCARS SCHOONAERT:NAO568',null,null,'C0B3D0F31BEA7040CDA9355288C5E5783C3542EB','Holque','1');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('321993','233790','AUTOCARS MAZEREEUW','50.81199','2.62783',null,'FR:59580:POI:AUTOCARS MAZEREEUW:NAO568',null,null,'0CB09B849597AAA2F698BBB482210054E773C484','Steenvoorde','1');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('321999','233802','VOYAGES ACCOU','50.64358','2.73187',null,'FR:59212:POI:VOYAGES ACCOU:NAO568',null,null,'5C5DCC65ECE06F0BDD0C7B4F24584AF96CBC7DEE','Estaires','1');
@@ -723,9 +723,9 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385817','293539','Calais Presse','50.95905','1.84698',null,'FR:62193:POI:Calais Presse:NAO28',null,null,'24BA17999EEACE3193592E881C32C07E5D09D646','Calais','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385818','293541','Tabac Presse Loto','50.95181','1.88803',null,'FR:62193:POI:Tabac Presse Loto:NAO28',null,null,'0D90CA9EB43856B36C7182A088C53257C1F139CA','62100','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385819','293543','Le Nemrod','50.9522','1.84596',null,'FR:62193:POI:Le Nemrod:NAO28',null,null,'57854B89ABC544902C7B47AA58DB858B7DA02DED','Calais','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385820','293545','Tabac Journaux Loto','50.86837','1.86629',null,'FR:62397:POI:Tabac Journaux Loto:NAO28',null,null,'3AF5EE38A82B5F15C250B30931B3FB7571751B60','Gu�nes','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385822','385821','Espace ï¿½v�ole','50.36782','3.08235',null,'FR:59178:POI:Espace ï¿½v�ole:NAO44',null,null,'FE4BB63E28868DF3CCE1A07C3609247EF3118DE3','Douai','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385824','385823','Agence ï¿½v�ole','50.37189','3.08786',null,'FR:59178:POI:Agence ï¿½v�ole:NAO44',null,null,'36F276D246FF66D34DA8823CA749472321D320BE','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385820','293545','Tabac Journaux Loto','50.86837','1.86629',null,'FR:62397:POI:Tabac Journaux Loto:NAO28',null,null,'3AF5EE38A82B5F15C250B30931B3FB7571751B60','Gu_nes','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385822','385821','Espace _v_ole','50.36782','3.08235',null,'FR:59178:POI:Espace _v_ole:NAO44',null,null,'FE4BB63E28868DF3CCE1A07C3609247EF3118DE3','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385824','385823','Agence _v_ole','50.37189','3.08786',null,'FR:59178:POI:Agence _v_ole:NAO44',null,null,'36F276D246FF66D34DA8823CA749472321D320BE','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387183','387182','Piste cyclable SITURV ','50.46118','3.59914',null,'FR:01:POI:CYCL:95',null,null,'B7CCCB99E7F6784765F286D37E027A27CE0924D5','Condé-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387185','387184','Piste cyclable SITURV ','50.46149','3.59369',null,'FR:01:POI:CYCL:96',null,null,'1D167CA79EE3E7920B4E30982F7257283FE9E200','Condé-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387187','387186','Piste cyclable SITURV ','50.46266','3.59414',null,'FR:01:POI:CYCL:97',null,null,'4F4CE3A6BB631A23E8FBCF445C0F78391B67E58B','Condé-sur-l''Escaut','29');
@@ -737,7 +737,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387201','387200','Piste cyclable SITURV ','50.39943','3.52192',null,'FR:01:POI:CYCL:104',null,null,'04FAD00061E6C1B26BB4F93A84B6F1F98F3101A2','Bruay-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('322193','293591','Café-Tabac','50.35165','3.06199',null,'FR:59329:POI:Café-Tabac:NAO44',null,null,'34CDB0B92A48150946E8E32D52C7165D8B1BB676','Lambres-lez-Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('322194','293593','Le Sevange','50.3384','3.18892',null,'FR:59390:POI:Le Sevange:NAO44',null,null,'119DF4CBB45C42EC4DA84D7CD0E029EDCCBAF98C','Masny','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385826','385825','Le Palais de la Bi�re','50.33136','3.24817',null,'FR:59008:POI:Le Palais de la Bi�re:NAO44',null,null,'7927A066426E3A42839634492565D1B1F52B17B9','Aniche','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385826','385825','Le Palais de la Bi_re','50.33136','3.24817',null,'FR:59008:POI:Le Palais de la Bi_re:NAO44',null,null,'7927A066426E3A42839634492565D1B1F52B17B9','Aniche','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387205','387204','Piste cyclable SITURV ','50.31227','3.2718',null,'FR:01:POI:CYCL:106',null,null,'40A0BAE548D309B965BE9B60936191D1E26EEFCE','Aniche','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387207','387206','Piste cyclable SITURV ','50.4668','3.59595',null,'FR:01:POI:CYCL:107',null,null,'73969B53DC26176B9CFF0B32376ED42EC719CFED','Condé-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387209','387208','Piste cyclable SITURV ','50.48754','3.56948',null,'FR:01:POI:CYCL:108',null,null,'EF05631C8CC0844B6900F389681BC93597328A22','Vieux-Conde','29');
@@ -844,14 +844,14 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385761','293411','AUTOCARS BRUNEL','50.64292','2.64955',null,'FR:59400:POI:AUTOCARS BRUNEL:NAO568',null,null,'A08C7397DA36B71C201C5C8FAF650E728067F1DE','Merville','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385762','293413','CARS DELGRANGE','50.92504','2.5987',null,'FR:59448:POI:CARS DELGRANGE:NAO568',null,null,'F9B3BD5FBE87759C093BD9611E8BF263098AF3EB','Oost-Cappel','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385763','293415','AUTOCARS MAZEREEUW','50.81199','2.62783',null,'FR:59580:POI:AUTOCARS MAZEREEUW:NAO568',null,null,'D31B4592D1F2904AE4802FA20A4BFDB841DA4761','Steenvoorde','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385770','293429','MARIOT-GAMELIN','50.53234','2.81172',null,'FR:59051:POI:MARIOT-GAMELIN:NAO568',null,null,'E1A7DCF40C9A3E221E251FE630B2E9FC935D8C32','La Bass�e','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385770','293429','MARIOT-GAMELIN','50.53234','2.81172',null,'FR:59051:POI:MARIOT-GAMELIN:NAO568',null,null,'E1A7DCF40C9A3E221E251FE630B2E9FC935D8C32','La Bass_e','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385827','293557','Tabac Presse de la Place','50.33154','3.23116',null,'FR:59008:POI:Tabac Presse de la Place:NAO44',null,null,'C60440FC910FE5AD2961E487B5A0AA5617C5D1BC','Aniche','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385828','293561','Le Deauville','50.3294','3.23259',null,'FR:59024:POI:Le Deauville:NAO44',null,null,'28D3E6C0E216FEDC45DD30AA5C0DCD1016C664EA','Auberchicourt','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385829','293563','Le Balto SNC','50.41471','3.05188',null,'FR:59028:POI:Le Balto SNC:NAO44',null,null,'21BF9417E9471DE46D758D4DBD77BDEBA69F53C6','Auby','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385830','293565','Tabac Presse Loto','50.31197','3.12116',null,'FR:59126:POI:Tabac Presse Loto:NAO44',null,null,'3D987055BE1B2D7A42AE770BCF6AF00D69284DFF','Cantin','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385831','293567','Le Galibot','50.3578','3.12385',null,'FR:59170:POI:Le Galibot:NAO44',null,null,'842231AC518163B13B4DB45E8CBC6562E82920BD','Dechy','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385832','293569','Kiosque Presse Relais','50.33982','3.09711',null,'FR:59170:POI:Kiosque Presse Relais:NAO44',null,null,'29686B418DF4967CF708EFCD3C00A55B157066AD','Dechy','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385834','385833','Caf�-Tabac Loto Presse Brasserie','50.36431','3.07669',null,'FR:59178:POI:Caf�-Tabac Loto Presse Brasserie:NAO44',null,null,'D30FFD2D8B89B0DE73FC16C23594C056C4487ACB','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385834','385833','Caf_-Tabac Loto Presse Brasserie','50.36431','3.07669',null,'FR:59178:POI:Caf_-Tabac Loto Presse Brasserie:NAO44',null,null,'D30FFD2D8B89B0DE73FC16C23594C056C4487ACB','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385835','293573','A la Pipe d''Or','50.36753','3.0803',null,'FR:59178:POI:A la Pipe d''Or:NAO44',null,null,'AB97B9B8A882554CFC7637EED241EDB07287D338','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('417620','400336','CYCL_01 ','50.45936','3.575',null,'FR:01:POI:CYCL:16',null,'me~rHkgyT_BHsBP}@J','A81ADC8FE440D623BE69422756DD207696ED874B','Vieux-Condé','27');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('417621','400330','CYCL_01 ','50.46211','3.57435',null,'FR:01:POI:CYCL:17',null,'{s~rH}cyT{@BmBNyALgARCBIFMH','526033413D31441DB9565263FCDC6312284F0480','Vieux-Condé','27');
@@ -879,11 +879,11 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385836','293575','Le Maryland','50.36724','3.08169',null,'FR:59178:POI:Le Maryland:NAO44',null,null,'5694972BBC917970F74FE844CBDDA484B26E4AFD','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385837','293577','Le Cadre Noir','50.37159','3.08276',null,'FR:59178:POI:Le Cadre Noir:NAO44',null,null,'23852D76948D8815443E74728313A28FCDD4B195','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385838','293579','Le Flandre','50.3767','3.07492',null,'FR:59178:POI:Le Flandre:NAO44',null,null,'A206006F9371909AC544F715ABC18604ADEAE8F2','Douai','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385840','385839','Au Jubil�','50.36999','3.0734',null,'FR:59178:POI:Au Jubil�:NAO44',null,null,'24C4993E1046D0C8C13F8A9A5D7CE5ED7BCC1CDC','Douai','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385842','385841','Caf� Loto Tabac','50.39207','3.08181',null,'FR:59178:POI:Caf� Loto Tabac:NAO44',null,null,'64A9A0CB0B2EE947FFF6FB6E756C06F4D1B61C53','Douai','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385844','385843','Caf� Brasserie','50.39208','3.08181',null,'FR:59178:POI:Caf� Brasserie:NAO44',null,null,'35BF3B78CBBF8B575BEB94164C9C7625F64EF9F8','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385840','385839','Au Jubil_','50.36999','3.0734',null,'FR:59178:POI:Au Jubil_:NAO44',null,null,'24C4993E1046D0C8C13F8A9A5D7CE5ED7BCC1CDC','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385842','385841','Caf_ Loto Tabac','50.39207','3.08181',null,'FR:59178:POI:Caf_ Loto Tabac:NAO44',null,null,'64A9A0CB0B2EE947FFF6FB6E756C06F4D1B61C53','Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385844','385843','Caf_ Brasserie','50.39208','3.08181',null,'FR:59178:POI:Caf_ Brasserie:NAO44',null,null,'35BF3B78CBBF8B575BEB94164C9C7625F64EF9F8','Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385845','293589','Presse du Centre','50.39874','3.01136',null,'FR:59234:POI:Presse du Centre:NAO44',null,null,'6BFB32EA1188A8C69B883609DE20D6B8959E5BFA','Flers-en-Escrebieux','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385847','385846','Caf�-Tabac','50.35165','3.06199',null,'FR:59329:POI:Caf�-Tabac:NAO44',null,null,'E32AF392E0AEC588F3773DB5D23CF2BE5A286A8C','Lambres-lez-Douai','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385847','385846','Caf_-Tabac','50.35165','3.06199',null,'FR:59329:POI:Caf_-Tabac:NAO44',null,null,'E32AF392E0AEC588F3773DB5D23CF2BE5A286A8C','Lambres-lez-Douai','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('322122','293449','Voyages A. FOUACHE','50.33975','3.01945',null,'FR:62173:POI:Voyages A. FOUACHE:NAO568',null,null,'46702D564251ABC023813B9D4AF1B409EEF0A25E','Brebières','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('322126','293457','Cars VALENCIENNOIS','50.37292','3.53688',null,'FR:59606:POI:Cars VALENCIENNOIS:NAO568',null,null,'E7D14F3B459BB1D2B384FFF2F7DEF0B4273677F0','Valenciennes','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('417682','417430','CYCL_01 ','50.42526','3.37742',null,'FR:01:POI:CYCL:78',null,'igwrHapqSUYc@m@[i@a@q@k@s@a@o@[e@We@Yk@Wg@Sm@Ug@ISSc@Yy@I_@G[Gg@Ii@Iy@KgAOmAMsAM{AMsAIu@Gq@Eq@G}@Gw@C[Aa@Cw@C{@EcACgACaACeAEeAEaAEcACs@AW?WGgBCq@AU','8462DBE3AA4E521DC899F522E22D8C02ED43F69A','Hasnon','27');
@@ -905,7 +905,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385850','293599','Ferry Boutique','50.43714','3.09391',null,'FR:59489:POI:Ferry Boutique:NAO44',null,null,'76E4A580D50C26DE973BDB0BFD89A829D98A3E8C','Raimbeaucourt','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385852','293603','Le Gallia','50.34198','3.09765',null,'FR:59569:POI:Le Gallia:NAO44',null,null,'498C8A2E1883B07C674550E2BC1EEBD00C4F82E8','Sin-le-Noble','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385853','293605','Le Royal','50.36293','3.09979',null,'FR:59569:POI:Le Royal:NAO44',null,null,'5D3F3D37A93BE230978170632AAA2CE0B9D1CDE3','Sin-le-Noble','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385855','385854','Caf�-Tabac Loto','50.38551','3.11157',null,'FR:59654:POI:Caf�-Tabac Loto:NAO44',null,null,'6AC02EF1F9DBF648921F204A3DE0B1F3ED63E9C1','Waziers','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385855','385854','Caf_-Tabac Loto','50.38551','3.11157',null,'FR:59654:POI:Caf_-Tabac Loto:NAO44',null,null,'6AC02EF1F9DBF648921F204A3DE0B1F3ED63E9C1','Waziers','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385856','293609','Le Gallia','50.38303','3.10018',null,'FR:59654:POI:Le Gallia:NAO44',null,null,'DCE0A9AE0745754F16896BDDC417C0A19733AE00','Waziers','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385857','293611','Le Green','50.3722','3.10843',null,'FR:59654:POI:Le Green:NAO44',null,null,'033F1FC288528C844BD1D3F9C436825934603F67','Waziers','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('417629','417324','CYCL_01 ','50.43515','3.57609',null,'FR:01:POI:CYCL:25',null,'uoyrHigyT_@y@{@}Bq@mBIYGW','F0C4993319B4BD976669933E97B75D73CA61D8BB','Fresnes-sur-Escaut','27');
@@ -956,7 +956,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385776','293441','AU DERBY','50.48645','3.03621',null,'FR:59630:POI:AU DERBY:NAO568',null,null,'D721C23E08B27CFEC673BD32BB7FB7E706A4241C','Wahagnies','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385777','293443','Agence commerciale','50.65692','3.12785',null,'FR:59646:POI:Agence commerciale:NAO568',null,null,'9667B4952E24E6DF628BB1EBCB22EDAD0F633EF1','Wasquehal','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385778','293445','ID VOYAGES','50.48766','2.85618',null,'FR:62895:POI:ID VOYAGES:NAO568',null,null,'3E920F7E9F5918A8DC0508CB73C0AB0D1410BCAF','Wingles','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385780','385779','Les Autocars du Cambr�sis (CFC)','50.12794','3.41478',null,'FR:59139:POI:Les Autocars du Cambr�sis (CFC):NAO568',null,null,'88456810495608FE58C14390534FB2F89FD4AD9D','Caudry','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385780','385779','Les Autocars du Cambr_sis (CFC)','50.12794','3.41478',null,'FR:59139:POI:Les Autocars du Cambr_sis (CFC):NAO568',null,null,'88456810495608FE58C14390534FB2F89FD4AD9D','Caudry','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387077','387076','Piste cyclable SITURV PROM SAINTE-PHARAILDE','50.40482','3.53514',null,'FR:01:POI:CYCL:42',null,null,'BB641BD49F0A88F1AA2D53B164A28DCB77814385','Bruay-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387083','387082','Piste cyclable SITURV PROM SAINTE-PHARAILDE','50.4028','3.53294',null,'FR:01:POI:CYCL:45',null,null,'739F8DD42B9FFFB52F81313A4804D79FB962CA05','Bruay-sur-l''Escaut','29');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('387085','387084','Piste cyclable SITURV PROM SAINTE-PHARAILDE','50.39046','3.52502',null,'FR:01:POI:CYCL:46',null,null,'566E6AEBF62F1B393D28A3BAC2083CEA6F06B9C1','Bruay-sur-l''Escaut','29');
@@ -989,7 +989,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385789','293473','La Civette','50.12148','3.93343',null,'FR:59036:POI:La Civette:NAO568',null,null,'A6015F70B6C130C136AD7A60811F8C4D07AF84B2','Avesnes-sur-Helpe','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385790','293475','Termerair','50.27774','3.9738',null,'FR:59392:POI:Termerair:NAO568',null,null,'8A9960CE8AB742318A4EF879B54BA441671F616E','Maubeuge','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385791','293477','Le Havanitos','50.29881','3.79445',null,'FR:59053:POI:Le Havanitos:NAO568',null,null,'93818B066FD266A882752D93925DC3EF11B8FCD8','Bavay','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385793','385792','Au Pav�','50.08571','4.00658',null,'FR:59525:POI:Au Pav�:NAO568',null,null,'94AB6A150FBDDB7910B082300E3CE538AAC7A317','Sains-du-Nord','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385793','385792','Au Pav_','50.08571','4.00658',null,'FR:59525:POI:Au Pav_:NAO568',null,null,'94AB6A150FBDDB7910B082300E3CE538AAC7A317','Sains-du-Nord','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385794','293487','L''Arc de Triomphe','50.36316','3.51786',null,'FR:59606:POI:L''Arc de Triomphe:NAO568',null,null,'98730B462EE338BC6DA699A252174E6E3D168607','Valenciennes','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385795','293489','Agence commerciale','50.19111','3.84842',null,'FR:59344:POI:Agence commerciale:NAO568',null,null,'E2EDD524EADAB1A9EDA1AC9F39D51385D7A1C118','Leval','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385796','293493','Les Cars du Hainaut','50.25468','3.6361',null,'FR:59481:POI:Les Cars du Hainaut:NAO568',null,null,'F85165BD5C41CCA2E1C38BACF4F11BE5804595DD','Le Quesnoy','15');
@@ -1011,7 +1011,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385798','293497','Le Penalty','50.94618','1.88223',null,'FR:62193:POI:Le Penalty:NAO28',null,null,'20FAA22ED6198387CFA01949BAEBA934A88E6B15','Calais','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385799','293499','Le Concorde','50.94741','1.95146',null,'FR:62548:POI:Le Concorde:NAO28',null,null,'60EC5C654DE7850217DC6C705E354C0459D907EC','Marck','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385800','293501','Le Salengro','50.94536','1.83044',null,'FR:62193:POI:Le Salengro:NAO28',null,null,'E21A50CE3E3587F76D6C8AB235C2C17E26776A76','Calais','15');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385802','385801','Au Cond�','50.94538','1.82388',null,'FR:62193:POI:Au Cond�:NAO28',null,null,'84737B49BA0E9A9FDEB30C3A2FFC83DD19DC8229','Calais','15');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385802','385801','Au Cond_','50.94538','1.82388',null,'FR:62193:POI:Au Cond_:NAO28',null,null,'84737B49BA0E9A9FDEB30C3A2FFC83DD19DC8229','Calais','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385803','293505','Au Brazza','50.94661','1.84198',null,'FR:62193:POI:Au Brazza:NAO28',null,null,'866BF02FB3DEFE21903E7687E8F04216053D1E77','Calais','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385804','293507','La Maison du Cadeau','50.94788','1.85207',null,'FR:62193:POI:La Maison du Cadeau:NAO28',null,null,'3E86F20D47BA62AAAC0A5227D2467D6E35DC6675','Calais','15');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('385805','293509','Tabac Nation','50.94557','1.86513',null,'FR:62193:POI:Tabac Nation:NAO28',null,null,'D247B1077D726E2760D8405D318572070D4D3B42','Calais','15');
@@ -2137,7 +2137,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538427','538426','AS SIN LE NOBLE','50.38011','3.1378',null,'FOOT_661',null,null,'6A00100277C791034707E82D9DE6748EB13F0BB7','SIN-LE-NOBLE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538429','538428','LES EPIS FOOT','50.35908','3.10959',null,'FOOT_662',null,null,'9FDB3E1F48DCD244F5C587FA8976608E344A2B77','SIN-LE-NOBLE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538431','538430','FC SOLESMES','50.17016','3.52159',null,'FOOT_663',null,null,'A58B4C412A8B0613FF31DE3660178B727C085AF5','SOLESMES','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538433','538432','AVT G SOLRE LE CH�TEAU','50.16898','4.08996',null,'FOOT_664',null,null,'EA69E3CD531BDDC19BEE096330017CE2D26C9E1E','SOLRE-LE-CH�TEAU','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538433','538432','AVT G SOLRE LE CH_TEAU','50.16898','4.08996',null,'FOOT_664',null,null,'EA69E3CD531BDDC19BEE096330017CE2D26C9E1E','SOLRE-LE-CH_TEAU','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538435','538434','US ART CHEMINOTS SOMAIN','50.36042','3.27547',null,'FOOT_665',null,null,'F3E7F2A58A378AB87720018975E12F114F601184','SOMAIN','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538737','538736','PREMESQUE FC','50.65916','2.95028',null,'FOOT_816',null,null,'8BB8D30A5D6E44637AF224C8C74B1B3060F8B6C9','PREMESQUES','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538739','538738','US PROVIN','50.51227','2.91555',null,'FOOT_817',null,null,'19703D5FCEE6E28D9631F470AFC7D710F415A03B','PROVIN','3');
@@ -2637,7 +2637,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538071','538070','AS CATILLONAISE','50.06852','3.64114',null,'FOOT_483',null,null,'A609CB00AC950ECB839AF63AE897975703AFB3BE','CATILLON-SUR-SAMBRE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538073','538072','US CATTENIERES','50.13236','3.33671',null,'FOOT_484',null,null,'6E8DD99E81B42A9E4CD8E71471B744BB8C83DE3D','CATTENIERES','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538075','538074','ENT S DE CAUDRY','50.12003','3.41398',null,'FOOT_485',null,null,'0DBA38DAC9A852F3547D8C77F10C0A26396185D5','CAUDRY','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538077','538076','AMS CH�TEAU L''ABBAYE','50.48611','3.47797',null,'FOOT_486',null,null,'E71C078C7C497547438C4C3BBA4E7BAEE45D72EB','CH�TEAU-L''ABBAYE','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538077','538076','AMS CH_TEAU L''ABBAYE','50.48611','3.47797',null,'FOOT_486',null,null,'E71C078C7C497547438C4C3BBA4E7BAEE45D72EB','CH_TEAU-L''ABBAYE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538079','538078','AMFC COLLERET','50.26058','4.08055',null,'FOOT_487',null,null,'9F192E6309041358E264DE7B10CB8F6E11C0386C','COLLERET','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538357','538356','AS PREUX AU BOIS','50.16579','3.6563',null,'FOOT_626',null,null,'33C41EEDCD72F01C2C062EB9C67BFA0BAA9B9561','PREUX-AU-BOIS','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538359','538358','US PRISCHES','50.07761','3.75548',null,'FOOT_627',null,null,'120DB57A46F3A84CC7AE94135296BBF7B463865D','PRISCHES','3');
@@ -4156,7 +4156,7 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539523','539522','VOLLEY CLUB LIEVINOIS','50.4246','2.76959',null,'VOLLEY_82',null,null,'3F76D6CC3B48ACE8106DAC868ECD358D473EE1FC','Liévin','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539525','539524','SPORTING CLUB AUBINOIS','50.34544','2.58531',null,'VOLLEY_83',null,null,'F0BF4E817E6815519B394202DF373BBC81C7E8C6','Aubigny-en-Artois','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539527','539526','Notre Dame de Lorette','50.40112','2.71914',null,'MEMO_1',null,null,'67B284C7D0C3914987BE8C2D44103999330506C7','Ablain-Saint-Nazaire','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539529','539528','Statue du G�n�ral Barbot','50.38622','2.74424',null,'MEMO_2',null,null,'3A681C743CE14C0320FB33A2F6C1C6CC09EAE997','Souchez','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539529','539528','Statue du G_n_ral Barbot','50.38622','2.74424',null,'MEMO_2',null,null,'3A681C743CE14C0320FB33A2F6C1C6CC09EAE997','Souchez','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539531','539530','Cabaret Rouge','50.38044','2.74119',null,'MEMO_3',null,null,'80FC619D50D0A05A48F4D632F46F8907BE1D6596','Souchez','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539533','539532','Monument de la Division Marocaine','50.37924','2.76962',null,'MEMO_4',null,null,'EEF3BF00B25748CAC035A212089FD6A44767CAA0','Givenchy-En-Gohelle','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538897','538896','RC DE COUDEKERQUE','51.01875','2.39538',null,'FOOT_896',null,null,'01C568FBF7007FF487B672FFC9B040C48D1C3DCA','COUDEKERQUE-BRANCHE','3');
@@ -4179,15 +4179,15 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539237','539236','MONTREUIL - Handball','50.46691','1.76465',null,'HAND_32',null,null,'6A990D95F085A2E9526948745F4C53BC3EA54B78','MONTREUIL','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539239','539238','AULNOYE-AYMERIES - Handball1','50.205','3.83854',null,'HAND_33',null,null,'6BCDD352DC99745F8D134AE9AF261EBF5A00B2BB','AULNOYE-AYMERIES','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539241','539240','AULNOYE-AYMERIES - Handball2','50.193','3.82229',null,'HAND_34',null,null,'2985080E6BB264BEAB824D6F1212F986C234A45F','AULNOYE-AYMERIES','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539535','539534','Parc comm�moratif canadien de Vimy','50.37175','2.77101',null,'MEMO_5',null,null,'B28D60082DEAF6B24229B105DEED4A695849535A','Neuville-Saint-Vaast','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539535','539534','Parc comm_moratif canadien de Vimy','50.37175','2.77101',null,'MEMO_5',null,null,'B28D60082DEAF6B24229B105DEED4A695849535A','Neuville-Saint-Vaast','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539537','539536','Zivy Crater cemetery','50.35472','2.77813',null,'MEMO_6',null,null,'471A04E8190B8729AE2735C74A30278BABBD46DA','Thelus','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539539','539538','Monument aux Morts','50.35508','2.75995',null,'MEMO_7',null,null,'377033530D3897AAD9A6FD02AB692A793BF297F9','Neuville-Saint-Vaast','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539541','539540','Eglise St-Laurent','50.35507','2.76129',null,'MEMO_8',null,null,'3BBF95B3E0A97FE849BC9E2B59C5055BCDA2030D','Neuville-Saint-Vaast','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539543','539542','Cimeti�re allemand de la Maison Blanche','50.3426','2.75378',null,'MEMO_9',null,null,'4FE169A3E8C83981C321773EDF40A5624CE98801','Neuville-Saint-Vaast','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539543','539542','Cimeti_re allemand de la Maison Blanche','50.3426','2.75378',null,'MEMO_9',null,null,'4FE169A3E8C83981C321773EDF40A5624CE98801','Neuville-Saint-Vaast','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539545','539544','Monument Leuregans','50.34605','2.76499',null,'MEMO_10',null,null,'EF871A865B7A3CF6343062447B7D5B7E1D5C128E','Neuville-Saint-Vaast','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539547','539546','Flambeau de la Paix','50.35466','2.74862',null,'MEMO_11',null,null,'02AE8800B738F5FDA467E1A7293D2B3C1D782A50','Neuville-Saint-Vaast','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539549','539548','N�cropole de la Targette','50.34998','2.74642',null,'MEMO_12',null,null,'8B849ECFE9A7C69CAE842152370B77457B14C62A','Neuville-Saint-Vaast','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539551','539550','Cimeti�re franco-britannique d''Ecoivres','50.34315','2.68663',null,'MEMO_13',null,null,'9EE865DA8792F5F77F350A1DAD7A50A2D21D93FB','Mont-Saint-Eloi','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539549','539548','N_cropole de la Targette','50.34998','2.74642',null,'MEMO_12',null,null,'8B849ECFE9A7C69CAE842152370B77457B14C62A','Neuville-Saint-Vaast','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539551','539550','Cimeti_re franco-britannique d''Ecoivres','50.34315','2.68663',null,'MEMO_13',null,null,'9EE865DA8792F5F77F350A1DAD7A50A2D21D93FB','Mont-Saint-Eloi','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538919','538918','OC FORT MARDYCK','51.03128','2.30729',null,'FOOT_907',null,null,'66241DE62D7CEE89B8C8E9A74B2BEE5E81F8E122','FORT-MARDYCK','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538921','538920','JS GHYVELDE','51.04133','2.50711',null,'FOOT_908',null,null,'EB25DE304C4A5731AFF2956080FCCBD9A161AFAD','GHYVELDE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('538923','538922','SC GRAND FORT PHILIPPE','50.99585','2.10768',null,'FOOT_909',null,null,'13D5BD0DE82F25EF9551F3AFBAC69F46790DA0AF','GRAND-FORT-PHILIPPE','3');
@@ -4209,14 +4209,14 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539259','539258','DOUCHY-LES-MINES - Handball','50.30248','3.39073',null,'HAND_43',null,null,'2B561A27734F209FF86AEF69516A0A92AC6F71C9','DOUCHY-LES-MINES','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539261','539260','FOURMIES - Handball','50.00543','4.06076',null,'HAND_44',null,null,'42CAAF93FFDCDDAC976D51FEFA4E2078858B0E09','FOURMIES','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539553','539552','Vestiges abbaye du Mont-St-Eloi','50.34973','2.69281',null,'MEMO_14',null,null,'3F54B9DB93FBF97C639AB89BDDE9C4F60476E59F','Mont-Saint-Eloi','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539555','539554','Vieille ï¿½glise d''Ablain-St-Nazaire','50.39325','2.72094',null,'MEMO_15',null,null,'AFDEEA43541BFB1136F9FE43A96EF3037B1BD893','Ablain-Saint-Nazaire','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539555','539554','Vieille _glise d''Ablain-St-Nazaire','50.39325','2.72094',null,'MEMO_15',null,null,'AFDEEA43541BFB1136F9FE43A96EF3037B1BD893','Ablain-Saint-Nazaire','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539557','539556','Monument aux morts','50.39078','2.74121',null,'MEMO_16',null,null,'B89557F679E510F4217F2FBE15F158D1A9FCBC4C','Souchez','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539559','539558','Cimeti�re britannique','50.30385','2.7704',null,'MEMO_17',null,null,'B478D9241B413658E1F76DEF2F9A457C4032AAC9','Sainte-Catherine','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539559','539558','Cimeti_re britannique','50.30385','2.7704',null,'MEMO_17',null,null,'B478D9241B413658E1F76DEF2F9A457C4032AAC9','Sainte-Catherine','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539561','539560','Les Boves','50.29227','2.77901',null,'MEMO_18',null,null,'F0637067F14DA2547398390FD87FEE5C9DF5B024','Arras','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539563','539562','M�morial','50.2873','2.75986',null,'MEMO_19',null,null,'5167CFD5EC03EA7C7ADF7A9FC72A84545C7AC797','Achicourt','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539565','539564','Carri�re Wellington','50.2801','2.78301',null,'MEMO_20',null,null,'5DA19990559DE493783C7CE913C01E74C8450F5B','Arras','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539567','539566','Cimeti�re Britannique','50.26856','2.77489',null,'MEMO_21',null,null,'FDAC8D86F2E6960ADABB3F919353D69C3D3803A5','Achicourt','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539569','539568','Cimeti�re Britannique','50.26562','2.75372',null,'MEMO_22',null,null,'8139FF85140310F4BEDDC6C78D81CBCEA9CFE7E9','Agny','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539563','539562','M_morial','50.2873','2.75986',null,'MEMO_19',null,null,'5167CFD5EC03EA7C7ADF7A9FC72A84545C7AC797','Achicourt','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539565','539564','Carri_re Wellington','50.2801','2.78301',null,'MEMO_20',null,null,'5DA19990559DE493783C7CE913C01E74C8450F5B','Arras','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539567','539566','Cimeti_re Britannique','50.26856','2.77489',null,'MEMO_21',null,null,'FDAC8D86F2E6960ADABB3F919353D69C3D3803A5','Achicourt','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539569','539568','Cimeti_re Britannique','50.26562','2.75372',null,'MEMO_22',null,null,'8139FF85140310F4BEDDC6C78D81CBCEA9CFE7E9','Agny','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('644556','644555','LE GRAND CERF','50.40722','3.27922',null,'CD59- R 20-LE GRAND CERF',null,null,'B1C3ADA8BC30DC2AD31F0CD45F5BC563F36BAAA9','Marchiennes','17');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('644558','644557','LAPAGE','50.47378','3.24268',null,'CD59- R 20-LAPAGE',null,null,'B401D3C5BE2AB3DDCF8D0F7879DA3BED52F55936','Orchies','17');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('644560','644559','SOMAIN PRESSE','50.35756','3.27959',null,'CD59- R 20-SOMAIN PRESSE',null,null,'BE7779AE65E832D8CADF9987F8A0CC8FFFADCF25','Somain','17');
@@ -4240,8 +4240,8 @@ Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539277','539276','SAINT-AMAND-LES-EAUX - Handball','50.4371','3.4448',null,'HAND_52',null,null,'585EE3A4124F8FF20C576F110637C7A5264E173D','SAINT-AMAND-LES-EAUX','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539279','539278','TRITH-SAINT-LEGER - Handball','50.33025','3.48221',null,'HAND_53',null,null,'9BFDC3C5A6A9CC11360B8B4BDB691B033503B20C','TRITH-SAINT-LEGER','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539281','539280','VIEUX-CONDE - Handball','50.4724','3.56523',null,'HAND_54',null,null,'97FC90E348D3F0E5D8EA7AD5EBA058057499EDF5','VIEUX-CONDE','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539571','539570','Cimeti�re Britannique','50.28255','2.71076',null,'MEMO_23',null,null,'989D3150EEB46D49F3729890147A858AEA0E9D27','Dainville','3');
-Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539573','539572','Cimeti�re Britannique','50.24763','2.71825',null,'MEMO_24',null,null,'B2829992ABC55DC033A6038D6EE64D30082A49B5','Wailly','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539571','539570','Cimeti_re Britannique','50.28255','2.71076',null,'MEMO_23',null,null,'989D3150EEB46D49F3729890147A858AEA0E9D27','Dainville','3');
+Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539573','539572','Cimeti_re Britannique','50.24763','2.71825',null,'MEMO_24',null,null,'B2829992ABC55DC033A6038D6EE64D30082A49B5','Wailly','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539575','539574','IAE','50.64629','3.0618',null,'ESUP_1',null,null,'D7CC9308AC326BEF0FDBAD64D477B685857F32D0','LILLE','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539577','539576','IUT du Recueil','50.64955','3.15737',null,'ESUP_2',null,null,'C8B769B19273648EA2348CA826EF8526DF5584C4','VILLENEUVE D''ASCQ','3');
 Insert into TOP_INTEREST_POINT (STATE_ID,FUNC_ID,NAME,LATITUDE,LONGITUDE,PARENT_ID,EXT_ID,ICON_ID,SHAPE,SIGNATURE,TOWN,NETWORK_ID) values ('539579','539578','CUEEP - 2 rue Montyon TOURCOING','50.71459','3.1599',null,'ESUP_3',null,null,'55273EDAF1386F466A805DD9ED0FA44856DE0CAC','TOURCOING','3');