back to first page..

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:\!\exports_shape\riversegments.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.riversegments
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\catchments.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.catchments
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\upstream_riversegments.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.upstream_riversegments
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\coast.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.coast
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\islands.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.islands
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\lakes.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.lakes
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\mainrivers.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.mainrivers
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\namedrivers.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.namedrivers
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\rivernodes.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.rivernodes
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\seaoutlets.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.seaoutlets
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\uga.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 uga2010.uga
C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\!\exports_shape\riversegments_france.shp" -p 5432 -u postgres -P !!! -g the_geom -r -k eda2.0 ccm21.riversegments_france

Warning, field up_catchment_area renamed to up_catchme
Warning, field up_art_11_13 renamed to up_art_11_
Warning, field up_arable_21 renamed to up_arable_
Warning, field up_permcrop_22 renamed to up_permcro
Warning, field up_pasture_23 renamed to up_pasture
Warning, field up_hetagr_24 renamed to up_hetagr_
Warning, field up_forest_31 renamed to up_forest_
Warning, field up_natural_32_33 renamed to up_natural
Warning, field up_wetlands_4 renamed to up_wetland
Warning, field up_inwat_51 renamed to up_inwat_5
Warning, field up_marwat_52 renamed to up_marwat_
Warning, field catchment_area renamed to catchme_01
Warning, field artificial_surfaces_11_13 renamed to artificial
Warning, field artificial_vegetated_14 renamed to artific_01
Warning, field arable_land_21 renamed to arable_lan
Warning, field permanent_crops_22 renamed to permanent_
Warning, field pastures_23 renamed to pastures_2
Warning, field heterogeneous_agricultural_24 renamed to heterogene
Warning, field natural_32_33 renamed to natural_32
Warning, field inland_waterbodies_51 renamed to inland_wat
Warning, field marine_water_52 renamed to marine_wat
Warning, field distance_source renamed to distance_s

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