[Talk-it] Statistiche

[David Paleino]

On Mon, 1 Jun 2009 13:04:26 +0200, Diego Guidotti - Aedit s.r.l. wrote:

> [..] 
> 
> 2) SQL da eseguire per spezzare le linee -> genera la tabella
> osm_stat_20090530 con le geometrie spezzate
> 
>  create table osm_stat_20090530 as select c.cod_reg, c.pro_com, l.highway,
>  l.ref, l.name , intersection (l.way, transform(c.geom,4326)) FROM
>  italy_20090530_line l, it_comuni c [..]  
                          ^^^^^^^^^
Com'è combinata questa tabella? Colonne? Indici? Se fai un dump di quello che
hai è meglio ;)

Ciao e grazie,
David

-- 
 . ''`.  Debian maintainer | http://wiki.debian.org/DavidPaleino
 : :'  : Linuxer #334216 --|-- http://www.hanskalabs.net/
 `. `'`  GPG: 1392B174 ----|---- http://snipr.com/qa_page
   `-   2BAB C625 4E66 E7B8 450A C3E1 E6AA 9017 1392 B174
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/talk-it/attachments/20090601/deb86f10/attachment.pgp>