Thanks a lot Jodi. you are making me very good.I am able to insert the data
into database now. But the problem is I am very new to postgresql.. Now I
am inserting each and every coordinate into polygon,Is this is the right
way? Is there any way to insert polygon directly into the database,I mean
The synatax of my postgresql polygaon is
(INSERT INTO "New"(
poly)
VALUES ('2,4,7,8,13,56');
Is there any other way to store polygon as it as we are getting as a
geomentry in our program
POLYGON ((103.89888293296089 1.418753631284916, 103.91762259776536
1.407041340782123, 103.90778427374302 1.3850222346368715, 103.88904460893855
1.389238659217877, 103.89888293296089 1.418753631284916))
Why I am asking all this because ,Weather I may get any problem while
retriveng the data from the database ?
plese suggest me ..
Thanks in advance..
Babu.
On Mon, Mar 30, 2009 at 11:49 AM, Jody Garnett <[email protected]>wrote:
> The format the data comes in is called "features"; part of a feature
> is a geometry; the other part is attributes (like the data values
> about the polygon).
>
> The export to shapefile operation example shows how to put an
> operation on a "FeatureSource"; you can use the feature source api to
> retrieve a feature collection; and from there you can go through each
> feature and place it in your database.
>
> The ShapefileExport actually does this work; it creates a new
> shapefile and copies the features into it. For more examples of
> working with feature collections see the geotools wiki:
> - http://docs.codehaus.org/display/GEOTDOC/08+FeatureCollection
>
>
> Jody
>
> On Mon, Mar 30, 2009 at 2:43 PM, prasad babu <[email protected]>
> wrote:
> > Thanks a lot jodi, Yes I looked at the operations Section and I have
> > creataed a new operation named as "exp to database" and I have written
> a new
> > class for that and I am able to call that class, But here in my program
> > I have liitlebit confusion, I mean in which format we will get the
> > data programitically in my class.I did not see any coordinates in the
> > program. I am trying to create a new table once user clicks the "exp to
> > database" tab and planning to store the polygons or ? in to the table.
> > is it the right way?
> >
> > Sorry for my confusion..
> >
> > Thanks in advance
> >
> > babu
> > On Mon, Mar 30, 2009 at 11:18 AM, Jody Garnett <[email protected]>
> > wrote:
> >>
> >> > I gone through the ShpExport plugin and I have changed accordingly,But
> >> > my
> >> > question here is how can I get the data from Map.
> >>
> >> The operation is available when you right click on a layer. Check the
> >> plugin.xml file and look for a section on "operations".
> >>
> >> > I mean I can create a postGis table manually here,But how I can paste
> >> > the
> >> > data into table,Is there any predefined code in the shpexport class.
> >> > First I
> >> > will finsih stroing the data into database then i will try how to
> fetch
> >> > it.
> >> > you want me to write query to fetch the data?
> >>
> >> Correct; the code example should show how to perform a query. Indeed
> >> their are a few examples to this effect.
> >> Jody
> >> _______________________________________________
> >> User-friendly Desktop Internet GIS (uDig)
> >> http://udig.refractions.net
> >> http://lists.refractions.net/mailman/listinfo/udig-devel
> >
> >
> > _______________________________________________
> > User-friendly Desktop Internet GIS (uDig)
> > http://udig.refractions.net
> > http://lists.refractions.net/mailman/listinfo/udig-devel
> >
> >
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
