http://wiki.beopen.it/ 2010-09-09T13:26:24+02:00 http://wiki.beopen.it/ http://wiki.beopen.it/lib/images/favicon.ico text/html 2006-08-24T13:40:59+02:00 http://wiki.beopen.it/java?rev=1156419659 Java related * Resin on debian text/html 2006-09-05T19:52:25+02:00 http://wiki.beopen.it/mapserver?rev=1157478745 * Symbol examples * compile mapserver with ming on debian unstable * Mapserver tricks text/html 2006-07-28T20:50:25+02:00 http://wiki.beopen.it/pmapper?rev=1154112625 PMAPPER Notes * join mysql table The original Wiki for pmapper from Armin Burger is Here text/html 2006-09-04T19:38:47+02:00 http://wiki.beopen.it/postgresql?rev=1157391527 * Note di installazione su debian * pgloader on debian * Postgresql Postgis notes * Bechmark tra shp e postgis, indicizzati o meno * Postgis query for parcels text/html 2006-08-14T12:22:29+02:00 http://wiki.beopen.it/sql_copy?rev=1155550949 new ordered table CREATE TABLE <newtable> AS SELECT * FROM <sourcetable> order by <field1>,<field2>; ALTER TABLE <newtable> RENAME TO <newname>; dump on file selected items CREATE TEMP TABLE rescomo AS SELECT * FROM residenti WHERE provincia = 13 AND res2001 > 1500; COPY rescomo TO '/home/luca/tmp/rescomo.csv'; text/html 2006-07-18T21:12:45+02:00 http://wiki.beopen.it/sql_like?rev=1153249965 SQL LIKE LIKE is another keyword that is used in the WHERE clause. Basically, LIKE allows you to do a search based on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN). The syntax for is as follows: text/html 2007-02-03T19:49:25+02:00 http://wiki.beopen.it/start?rev=1170528565 MAPSERVER * Symbol examples * compile mapserver with ming on debian unstable * Mapserver tricks PMAPPER * join mysql table ShapeLib * Installare ShapeLib e i tools POSTGRESQL & POSTGIS * Note di installazione su debian * pgloader on debian * Postgresql notes * Bechmark tra shp e postgis, indicizzati o meno * Postgis query for parcels