Subversion Repositories Sigmater

Rev

Blame | Last modification | View Log | Download | RSS feed

LOAD DATA
INFILE *
 INTO TABLE S3_SS07T_TAB_AREE_TEMATICHE
Fields terminated by ";" Optionally enclosed by '"'
(
  SS07_COD_AREA_TEMATICA NULLIF (SS07_COD_AREA_TEMATICA="NULL"),
  SS07_TABELLA,
  SS07_CREA_IN_ORDINE NULLIF (SS07_CREA_IN_ORDINE="NULL"),
  SS07_PARTIZIONATA
)
BEGINDATA
2;"S3_CT50T_PART_X_CIVICI";57;"1"
2;"S3_CT36T_FOGLI";22;"1"
2;"S3_CT22T_IDENT_TERRENI";23;"1"
1;"S3_CT38T_SOGGETTI";11;"1"
1;"S3_CT19T_PERSONE_GIURIDICHE";12;"1"
1;"S3_CT18T_PERSONE_FISICHE";13;"1"
1;"S3_CT02T_TITOLARITA";14;"1"
1;"S3_CT08T_IDENT_UIU";15;"1"
1;"S3_CT10T_RISERVE_URBANO";16;"1"
1;"S3_CT09T_UTILITA_COMUNI";17;"1"
1;"S3_CT14T_RISERVE_TERRENI";19;"1"
1;"S3_CT16T_DEDUZIONI";20;"1"
1;"S3_CT15T_PORZIONI";21;"1"
1;"S3_CT07T_STRADE_CAT";22;"1"
1;"S3_CT06T_INDIRIZZI_CAT";23;"1"
1;"S3_CT12T_TERRENI";18;"1"
1;"S3_CT04T_UIU";4;"1"
1;"S3_CT35T_MUTAZIONI";3;"1"
1;"S3_CT11T_PLANIMETRIE";25;"1"
1;"S3_CT21T_DATI_METRICI";29;"1"
1;"S3_CT43T_SCHEDE";26;"1"
1;"S3_CT17T_BILANCIO_GEOMETRIA";28;"0"
2;"S3_CT24G_PARTICELLE";24;"1"
1;"S3_CT26T_ID_UIU_X_ID_TERRENI";32;"1"
2;"S3_CT28G_CAMPITURE";28;"1"
2;"S3_CT29G_ACQUE";29;"1"
2;"S3_CT31G_FOGLI";23;"1"
2;"S3_CT32G_STRADE";32;"1"
2;"S3_CT33G_SIMBOLI";33;"1"
2;"S3_CT34G_TESTI";34;"1"
2;"S3_CT37G_VARIE";37;"1"
2;"S3_CT51G_LINEE";51;"1"
2;"S3_CT52G_FIDUCIALI";52;"1"
2;"S3_CT53G_RIF_RASTER";53;"1"
2;"S3_CT54G_TESTI_PARTICELLE";54;"1"
2;"S3_CT56G_PUNTI_FIDUCIALI";56;"1"
2;"S3_CT30G_CENTROIDI";30;"1"
1;"S3_CT44T_PIANTINE";60;"1"
1;"S3_CT45T_IMMAGINI";59;"1"
6;"S3_AU01T_NOTA_ICI";10;"0"
6;"S3_AU02T_TRASCR_NOTA_ICI";20;"0"
6;"S3_AU04T_SOGGETTO";30;"0"
6;"S3_AU05T_PERSONA_FIS";40;"0"
6;"S3_AU06T_PERSONA_GIUR";50;"0"
6;"S3_AU03T_SOGGETTO_NOTA";60;"0"
6;"S3_AU08T_IMMOBILE";70;"0"
6;"S3_AU09T_UIU";80;"0"
6;"S3_AU10T_TERRENO";90;"0"
6;"S3_AU07T_TITOLARITA";100;"0"
1;"S3_CT48T_UIU_X_CIVICI";80;"1"
7;"S3_TA01T_UIU";10;"0"
7;"S3_TA02T_SOGGETTI";20;"0"
7;"S3_TA03T_DATI_METRICI";30;"0"
7;"S3_TA04T_INDIRIZZI";40;"0"
7;"S3_TA05T_PERSONA_FIS";50;"0"
7;"S3_TA06T_PERSONA_GIUR";60;"0"