[udig-devel] Create feature in postgis

Jesse Eichar jeichar at refractions.net
Tue Dec 4 10:01:29 PST 2007


On 4-Dec-07, at 9:56 AM, Jody Garnett wrote:

> Jesse Eichar wrote:
>> There is a somewhat hidden way of creating a layer directly in  
>> postGIS.  However I believe there is a bug that hasn't been fixed.   
>> If the FeatureType has a String attribute it tries to make a field  
>> that has a limit of Integer.MAX_VALUE.  Which postgis doesn't  
>> like.  But you can play with this functionality:
>>
>> 1. Import your Postgis into the catalog
>> 2. Select the Postgis service (not GeoResource) in the catalog
>> 3. Right click Select Operations>Create Feature Type
>>
>> Voila a new feature type is created.  Add it to a map and start  
>> editing.
> The other trick would be to copy and paste the content over from the  
> shapefile; something covered in walkthough 2 if I remember  
> correctly? Your request to create and populate a postgis table in  
> one go is a good one; it is not the kind of thing I would like to do  
> as a drag and drop operation; any suggestions for how to make this  
> available in the user interface? Perhaps an export wizard...
> Jody

To copy and paste you have to have a destination layer so you have to  
perform my workflow first.  Then you can copy and paste features over.

Jesse


More information about the udig-devel mailing list