Re: [Geotools-gt2-users] What's the difference between gt-postgis and gt-jdbc-postgis

[Yingqi T. <ana...@gm...>]

Justin,

I do have entry in geometry_columns for that particular table and the record
has srid set to 4326.

Thanks

On Thu, Aug 26, 2010 at 1:47 PM, Justin Deoliveira <jde...@op...>wrote:

> Hi Yinqi,
>
> "NG" stands for next generation. It is what we codenamed the new jdbc
> datastore architecture, which was really a total rewrite.
>
> As for your problem of getting a null crs back it usually means that
> geotools could not figure out what the srs of your data is. The most common
> cause of this with postgis would probably be a missing entry in the
> geometry_columns table. Does the geometry column in your table have an entry
> in geometry_columns? And if so does it set the srs?
>
> -Justin
>
>
> On Thu, Aug 26, 2010 at 12:34 PM, Yingqi Tang <ana...@gm...>wrote:
>
>> Justin,
>>
>> What does "NG" stand for in PostgisNGDataStoreFactory? I tried the
>> following code
>>
>> ...prepare postgis connections params...
>>
>> jdbcDataStore = pgNgDataStoreFactory.createDataStore(params);
>> SimpleFeatureType simpleFeatureType =
>> jdbcDataStore.getSchema(typeNames[0]);
>> System.out.println("crs code: " +
>> simpleFeatureType.getCoordinateReferenceSystem().getName().getCode());
>>
>> ...
>>
>> I am getting null on getCoordinateReferenceSystem(), but the table in my
>> PostGIS database has srid as 4326 if I execute something like:
>>
>> SELECT ST_AsEWKT(the_geom) FROM table WHERE gid=1
>>
>> Do you know why crs is null for a simple feature type?
>>
>> Thanks.
>>
>>
>> On Thu, Aug 26, 2010 at 7:18 AM, Yingqi Tang <ana...@gm...>wrote:
>>
>>> Thanks a lot, Justin. That solved the problem.
>>>
>>>
>>> On Thu, Aug 26, 2010 at 7:13 AM, Justin Deoliveira <jde...@op...
>>> > wrote:
>>>
>>>> Hi Yinqi,
>>>>
>>>> Yeah, the group id for the new gt-jdbc-* modules is actually
>>>> org.geotools.jdbc, rather than just org.geotools. Change it and the new
>>>> artifact should be picked up.
>>>>
>>>> -Justin
>>>>
>>>> On Thu, Aug 26, 2010 at 8:01 AM, Yingqi Tang <ana...@gm...>wrote:
>>>>
>>>>> Thanks for the explanation, Ben.
>>>>>
>>>>> A follow up question though, when I follow the steps in GeoTools "Get
>>>>> Started" and include the gt-jdbc-postgis as a dependency in pom.xml like
>>>>> below:
>>>>>
>>>>>         <dependency>
>>>>>             <groupId>org.geotools</
>>>>> groupId>
>>>>>             <artifactId>gt-jdbc-postgis</artifactId>
>>>>>             <version>2.7-SNAPSHOT</version>
>>>>>         </dependency>
>>>>>
>>>>> If I run "mvn install", I will get an error saying gt-jdbc-postgis
>>>>> missing or can not be found in the repository, something like that. Actually
>>>>> if you go to
>>>>> http://download.osgeo.org/webdav/geotools/org/geotools/gt-jdbc-postgis/,
>>>>> there is no jar file there, and also if I build GeoTools from source code
>>>>> myself the gt-jdbc-postgis will not be added into my local .m2 folder
>>>>> either.
>>>>>
>>>>> Anyone know what is the reason for that?
>>>>>
>>>>>
>>>>> On Wed, Aug 25, 2010 at 8:03 PM, Ben Caradoc-Davies
>>>>> <Ben...@cs...> wrote:
>>>>>
>>>>>> On 26/08/10 05:39, Yingqi Tang wrote:
>>>>>>
>>>>>>> I'm trying to create a sample of using GeoTools reading features from
>>>>>>> PostGIS. Now I find there are two related modules gt-postgis and
>>>>>>> gt-jdbc-postgis, so just wonder what's the difference and which one should I
>>>>>>> use?
>>>>>>>
>>>>>>
>>>>>> gt-postgis is the old PostGIS module.
>>>>>>
>>>>>> gt-jdbc-postgis is the new PostGIS module, and is part of a suite of
>>>>>> jdbc modules that share common code and have improved features.
>>>>>>
>>>>>> You should use gt-jdbc-postgis.
>>>>>>
>>>>>> Kind regards,
>>>>>> Ben.
>>>>>>
>>>>>> --
>>>>>> Ben Caradoc-Davies <Ben...@cs...>
>>>>>> Software Engineering Team Leader
>>>>>> CSIRO Earth Science and Resource Engineering
>>>>>> Australian Resources Research Centre
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
>>>>> Be part of this innovative community and reach millions of netbook
>>>>> users
>>>>> worldwide. Take advantage of special opportunities to increase revenue
>>>>> and
>>>>> speed time-to-market. Join now, and jumpstart your future.
>>>>> http://p.sf.net/sfu/intel-atom-d2d
>>>>> _______________________________________________
>>>>> Geotools-gt2-users mailing list
>>>>> Geo...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Justin Deoliveira
>>>> OpenGeo - http://opengeo.org
>>>> Enterprise support for open source geospatial.
>>>>
>>>>
>>>
>>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
>