Hi,
and thanks for your answers!
I have an empty USER_SDO_GEOM_METADATA table. Might this be the problem? The
"tables" I would like to use are actually views. Do I need to manually
"register" them as spatial when creating the views, so I get records in
USER_SDO_GEOM_METADATA table?
The Schema that holds the source table with points, does not seem to have an
USER_SDO_GEOM_METADATA table at all. When I look into
MDSYS.SDO_GEOM_METADATA_TABLE, there are several rows pointing to the source
tables but none for the views.
Kind regards
Anders Erlandsson
GIS-engineer
Sundsvalls kommun
Stadsbyggnadskontoret
________________________________
Från: Harikumar Reddy [mailto:[email protected]]
Skickat: den 9 juni 2011 08:27
Till: Miles Jordan
Kopia: Erlandsson Anders; [email protected]
Ämne: Re: [Geoserver-users] Problems with SDO_POINT geometries from Oracle
[SEC=Unclassified] 11.2 [SEC=Unclassified]
Hi Miles,
It is most common error occurred for us too (inform DBA to fix metadata &
Spatial Index problems), when imported different types of geodata to into
oracle tables. The metadata (Spatial extent or bounding box of the gis layer
present in oracle tables) is not updated after geodata import.
Try to install Georaptor in sqldeveloper (its added as a plugin to
sqldeveloper) and update metadata and check for spatial indexes created? other
wise it will error as OCIIndexerror. After this process, geoserver
You can install Georaptor in sqldeveloper as given below
Open sqldeveloper and click on help, check for updates, A new window will open
with welcome, source, updates, sownload, summary links in the lefthand side.
click next and source is highlighted, click add button and give Georaptor as
name and http://georaptor.sourceforge.net/install.xml url as location. click
next till end.
after the process, restart your sqldeveloper and when you right click, you can
find Georaptor as an option, by clicking manage metadata, it will open new
window with bounding box default parameters (which are not correct). click on
calibrate MBR and then click on update and close.
I hope that this solves your problem.
Regards,
Hari.
On Thu, Jun 9, 2011 at 5:57 AM, Miles Jordan <[email protected]> wrote:
If it doesn't show up in the layers list then the most likely cause is
a missing entry in USER_SDO_GEOM_METADATA. Try logging into SQL Developer with
the same user and double check if the table is listed in there properly.
-Miles
From: Erlandsson Anders
I have a lot of 2D point tables that does not show up in the available
Layers list when trying to publish a new layer. 3D layers of the same dataset
shows fine and the only difference I can see in the two tables are the GTYPE,
that is set to 2001 for the 2D-data and 3001 for the 3D-data. I have tried to
select records using SQL Developer with the same user account as in Geoserver,
and it works fine.
Any suggestions on what might be wrong?
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you
are not the
intended recipient, you are notified that use or dissemination of this
communication is
strictly prohibited by Commonwealth law. If you have received this
transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3
6232 3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
