[GRASS-dev] PostGIS manager for GRASS GIS

[Benjamin Ducke]

On 04/02/2012 05:11 PM, Mohit Kumar wrote:

[snip]

>
> Thanks for your reply.
> Its good to know that development is ongoing for this in GRASS, I
> sincerely want to work on this as my GSoc task.
> I have made a brief idea for the manager. The following are the various
> modules of the manager
> 1. Setup connection : This module will set up the connection with the
> remote database. It will take the input parameters from user and pass
> them to a connection string. After the connection has been established,
> the user will be shown the various tables(maps) that are stored and
> other information about the database and the connection
> 2. View and edit data : This will display the data of the table in a
> window frame. One can view the map and modify the table values or the
> attributes.
> 3. Import to GRASS Data : This gives the user an option to save the data
> in Grass format for further processing/analysis of the data. This also
> gives user an option to discard the data which is of no use.
> 4. Execute PostGis functions (geometry processing)on database and save
> output in grass data format.
> 5. SQL interface : This provides the advanced user to modify the
> database by use of direct SQL commands on the database.
> 6. Export GRASS data to PostGIS data : Convert the Grass Data to SQL
> database. First convert the Grass data to Esri Shapefile(.shp) using OGR
> and then converting that data to SQL database (shape2sql).

Since the PostGIS data model is much more flexible than a Shapefile:
Why not directly convert the GRASS data to PostGIS WKB/WKT?

Ben

> 7. Projection support : I was also thinking of adding projection support
> to the manager.
> These are the various major points for a spatial database manager I can
> think of. Can you please provide me your suggestions.
>
> Looking forward to your support as the time left to apply is very less.
>
> Regards,
> --
> Mohit Kumar(mohitkharb on irc)
> Lab For Spatial Informatics
> International Institute of Information and Technology
> Hyderabad, India
> +91-970-3840-175
>
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev



-- 
Benjamin Ducke
{*} Geospatial Consultant
{*} GIS Developer

   benducke at fastmail.fm