Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-users] Odd behavior displaying PostGIS layers from Census Shapefiles

The column marked "the_geom" is actually tracked in a special geometry
columns table; this table is filled in by the add geometry columns
command when you are loading your data.

Walkthrough 1 describes connection parameters to an existing postgis
instance that has already been set up.

Mark Leslie has a workbook for postgis that may be of interest to you:
- http://2009.foss4g.org/workshops/

When I am next in front of a development machine I will look at your
stack trace - it looks like it is having trouble connecting.

Jody

On Tue, Jun 29, 2010 at 8:02 PM, David Epstein <davideps@xxxxxxxxx> wrote:
> Hi Jody,
>
> I can load and display shapefiles fine. I cannot seem to display postGIS
> layers. From pgadminIII, I can see that the tables have data and--in
> particular--that "the_geom" column is not empty. I've attached below an
> example from the log. Sorry for the length. I'm not sure what is key
> information. I do notice the word "missing" coming up a lot, which
> cannot be good. I also see "feature type:null". But, shp2pgsql completes
> without an error.
>
> Is there a test, perhaps from a tutorial using known data that I can use
> to diagnose what is wrong?
>
>
> thank you,
> -david
>
>
>
>
>
> !SESSION 2010-06-29 22:09:59.974
> -----------------------------------------------
> eclipse.buildId=unknown
> java.version=1.6.0_20
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Command-line arguments:  -os linux -ws gtk -arch x86_64
> -data /home/davideps/uDigWorkspace
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.970
> !MESSAGE NLS missing message: cancel_description in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: cancel_tooltip in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_horizontal_description in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_horizontal_tooltip in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_vertical_description in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_vertical_tooltip in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_single_description in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_single_tooltip in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_automatic_description in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY org.eclipse.osgi 2 1 2010-06-29 22:10:04.971
> !MESSAGE NLS missing message: orientation_automatic_tooltip in:
> net.refractions.udig.ui.internal.messages
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:10:04.973
> !MESSAGE net.refractions.udig.ui.WorkbenchConfiguration
> "net.refractions.udig.internal.ui.UDIGWorkbenchConfiguration" specified
> but no valid extension found.
> Please check that the extension exists and that it is valid.
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:10:05.032
> !MESSAGE net.refractions.udig.ui.MenuBuilder
> "net.refractions.udig.ui.uDigMenuBuilder" specified but no valid
> extension found.
> Please check that the extension exists and that it is valid.
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:10:05.343
> !MESSAGE EnablementUtil: Expected child of
> net.refractions.udig.render.wms.basic.operation but didn't find one...
>
> !ENTRY net.refractions.udig.catalog.imageio 2 0 2010-06-29 22:10:06.269
> !MESSAGE GDAL Not Available ... some image formats disabled:
> Expected environment variable resolve to:
>
> LD_LIBRARY_PATH=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons
>        DYLD_LIBRARY_PATH=null
>        GDAL_DATA=/home/davideps/Software/udig/gdal_data
>
> java.libary.path=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
>
>
> !ENTRY net.refractions.udig.project 2 0 2010-06-29 22:14:03.855
> !MESSAGE Problem rendering: Exception rendering layer
> DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@3513126e, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
> !STACK 0
> net.refractions.udig.project.render.RenderException: Problem rendering:
> Exception rendering layer DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@3513126e, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
>        at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:378)
>        at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:224)
>        at
> net.refractions.udig.project.internal.render.impl.RenderJob.startRendering(RenderJob.java:108)
>        at
> net.refractions.udig.project.internal.render.impl.RenderJob.run(RenderJob.java:213)
>        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.lang.Exception: Exception rendering layer
> DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@3513126e, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
>        at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:703)
>        at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:524)
>        at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:350)
>        ... 4 more
> Caused by: java.lang.NullPointerException
>        at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
>        at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
>        at
> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:545)
>        at
> org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:209)
>        at
> org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:481)
>        at
> org.geotools.data.store.ContentFeatureCollection.iterator(ContentFeatureCollection.java:263)
>        at
> org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1859)
>        at
> org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1792)
>        at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:699)
>        ... 6 more
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:14:04.024
> !MESSAGE
> !STACK 0
> java.lang.NullPointerException
>        at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
>        at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
>        at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
>        at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
>        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:14:04.024
> !MESSAGE Error loading features
> !STACK 0
> java.lang.NullPointerException
>        at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
>        at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
>        at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
>        at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
>        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:14:21.301
> !MESSAGE
> !STACK 0
> java.lang.NullPointerException
>        at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
>        at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
>        at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
>        at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
>        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>
> !ENTRY net.refractions.udig.ui 1 0 2010-06-29 22:14:21.301
> !MESSAGE Error loading features
> !STACK 0
> java.lang.NullPointerException
>        at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
>        at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
>        at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
>        at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
>        at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
>        at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
>        at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
>        at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
>        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>
>


Back to the top