[postgis-users] Beginning in PostGIS

[Luciano]

Ok,

I have a shape file with the following structure.

Shape file, columns:
town ​​code;
town description;
Neighborhood code;
name of the neighborhood;
block code;
Street code;
street name;

Using the How to Copy / paste a geometry from shape file to postgis with
follow structure:

Cities table (data):
- Town id
- Description of town

Neighborhoods table (data):
- Id of the neighborhood
- Description of the neighborhood
- Id of town (foreign key)

Blocks table:
- Id of the court
- Block of code
- Town id (foreign key)
- Geometry, polygon

Streets table:
- Street id
- Street name
- Town id (foreign key)
- Geometry, line



2015-04-18 13:36 GMT-03:00 Rémi Cura <remi.cura at gmail.com>:

> maintaining your data model is easy to do with triggers.
>
> About copy / past.
> Sorry this just doesn't make much sense to me.
>
> You can import shapefile into postgres if it is the question.
> You can also use trigger on the import table to fill you rmodel with the
> imported data.
>
> Cheers,
> Rémi-C
>
> 2015-04-18 17:39 GMT+02:00 Luciano <br.analistagis at gmail.com>:
>
>>
>> Hi,
>> I wonder how can I update a postgresql postgis database before the
>> following scenario:
>> Always worked with shape files and update them used copy / paste between
>> files.
>> Now, think about creating a database in PostgreSQL and would like to
>> continue using copy / paste to update polygons, but in my database
>> structure is different from the shape file. For example:
>> Imagine that the shapefile have all the fields in one table, already in
>> the database, by reason of standardization, have these columns in tables
>> distinct. Below is an example of a register of towns.
>>
>> File shape, columns:
>> town ​​code;
>> town description;
>> Neighborhood code;
>> name of the neighborhood;
>> block code;
>> Street code;
>> street name;
>>
>> In Postgres / Gis could look like this:
>>
>> Cities table (data):
>> - Town id
>> - Description of town
>>
>> Neighborhoods table (data):
>> - Id of the neighborhood
>> - Description of the neighborhood
>> - Id of town (foreign key)
>>
>> Blocks table:
>> - Id of the court
>> - Block of code
>> - Town id (foreign key)
>> - Geometry, polygon
>>
>> Streets table:
>> - Street id
>> - Street name
>> - Town id (foreign key)
>> - Geometry, line
>>
>> How could update (insert) a block in postgresql table using copy / paste
>> the shape file?
>> Would have to create a trigger/procedure (instead of) to automate the
>> process?
>> Fields of shape file should be equal to the fields of database table?
>> Some practical example as a reference?
>>
>> tia
>> --
>> Luciano
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Luciano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150418/87014771/attachment.html>