back to first page[..][[BR]] Problem with the names too long they are renamed with only ten character!!! So maybe we could change it before saving the data inot a shape file !![[BR]] {{{ C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\riversegments.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.riversegments C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\catchments.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.catchments C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\upstream_riversegments.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.upstream_riversegments C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\coast.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.coast C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\islands.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.islands C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\lakes.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.lakes C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\mainrivers.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.mainrivers C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\namedrivers.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.namedrivers C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\rivernodes.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.rivernodes C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\seaoutlets.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 ccm21.seaoutlets C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\seaoutlets.shp" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 uga2010.uga }}} Warning, field up_catchment_area renamed to up_catchme[[BR]] Warning, field up_art_11_13 renamed to up_art_11_[[BR]] Warning, field up_arable_21 renamed to up_arable_[[BR]] Warning, field up_permcrop_22 renamed to up_permcro[[BR]] Warning, field up_pasture_23 renamed to up_pasture[[BR]] Warning, field up_hetagr_24 renamed to up_hetagr_[[BR]] Warning, field up_forest_31 renamed to up_forest_[[BR]] Warning, field up_natural_32_33 renamed to up_natural[[BR]] Warning, field up_wetlands_4 renamed to up_wetland[[BR]] Warning, field up_inwat_51 renamed to up_inwat_5[[BR]] Warning, field up_marwat_52 renamed to up_marwat_[[BR]] Warning, field catchment_area renamed to catchme_01[[BR]] Warning, field artificial_surfaces_11_13 renamed to artificial[[BR]] Warning, field artificial_vegetated_14 renamed to artific_01[[BR]] Warning, field arable_land_21 renamed to arable_lan[[BR]] Warning, field permanent_crops_22 renamed to permanent_[[BR]] Warning, field pastures_23 renamed to pastures_2[[BR]] Warning, field heterogeneous_agricultural_24 renamed to heterogene[[BR]] Warning, field natural_32_33 renamed to natural_32[[BR]] Warning, field inland_waterbodies_51 renamed to inland_wat[[BR]] Warning, field marine_water_52 renamed to marine_wat[[BR]] Warning, field distance_source renamed to distance_s[[BR]] I propose to renamed it (if it's necessary) : ||Variable||rename to|| ||catchment_area||catch_area|| ||artificial_surfaces_11_13||art_surf11_13| ||artificial_vegetated_14||art_veg14|| ||arable_land_21||ara_land21|| ||permanent_crops_22||perm_crop22|| ||pastures_23||past23|| ||heterogeneous_agricultural_24||het_agr24|| ||natural_32_33||nat32_33|| ||inland_waterbodies_51||inl_wat51|| ||marine_water_52||mar_wat52|| ||distance_source||d_source|| ||up_catchment_area||u_cat_area|| ||up_art_11_13||u_art11_13|| ||up_arable_21||u_ara21|| ||up_permcrop_22||u_permcr22|| ||up_pasture_23||u_past23|| ||up_hetagr_24||u_hetagr24|| ||up_forest_31||u_fore31|| ||up_natural_32_33||u_nat32_33|| ||up_wetlands_4||u_wet4|| ||up_inwat_51||u_inwat51|| ||up_marwat_52||u_marwat52||