[mapguide-users] Join between an Oracle spatial table and a view

2011-11-23 Thread Iulia Tamas
Hello,     I'm trying to make a join between an Oracle spatial table and a view  (non-spatial view from Oracle) . This join is made in Mapguide Studio, in an King Oracle data connection In the first table are about 75 rows, while in the non-spatial view I have 33209 rows. After I make the join

Re: [mapguide-users] Join between an Oracle spatial table and a view

2011-11-23 Thread Zac Spitzer
just create a view in oracle and add the spatial metadata, search the list archives for more info On Wed, Nov 23, 2011 at 11:41 PM, Iulia Tamas wrote: > Hello, > >     I'm trying to make a join between an Oracle spatial table and a view > (non-spatial view from Oracle) . This join is made in Mapg

RE: [mapguide-users] Join between an Oracle spatial table and a view

2011-11-23 Thread Jonio, Dennis (Aviation)
Iulia, I would recommend: 1) Create a “normal” Oracle view w/your join 2) Add the entry for it in user_sdo_geom_metadata. (No need for an index.) 3) Create a layer for the view … Does all appear normal and as expected? All that I am suggesting here is to gradually add complex

[mapguide-users] Query features based on a list or array of attribute values

2011-11-23 Thread soudemans
Hi, I am not sure how to go about this. Perhaps one of you can set me on the right path. I have a list of values identifying features. I got this list by querying an independent attribute table. For example I queried a hydrant inspection table and got a list of hydrant ID numbers as part of the

[mapguide-users] Re: task pane hidden on basic web layout load

2011-11-23 Thread tmblackflag
Thanks for steering me in the right direction Jackie. I was able to get where i wanted by setting taskframe width to 0 in the weblayout, then modifying the function below in mainframe.templ: From function OpenTaskBar() { SetTaskBarWidth(orgTaskBarWidth); } To function OpenTaskBar() { Se

[mapguide-users] (no subject)

2011-11-23 Thread mohammad hossein kazemi
___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users

[mapguide-users] RE: Points from Sql/ODBC data source not showing

2011-11-23 Thread soudemans
I guess it is time to cut my losses, so I pondered the next dilemma, if I am going to put the data in a spatial data base, which will have to be ArcSDE, since the client uses MS SQL Server 2005, then how would I add a record and point data from the map's interface. How indeed? I checked with our

[mapguide-users] RE: Points from Sql/ODBC data source not showing

2011-11-23 Thread soudemans
I guess it is time to cut my losses. So I pondered the next dilemma: if I am going to put the data in a spatial data base, which will have to be ArcSDE, since the client uses MS SQL Server 2005, then how would I add a record and point data from the map's interface. How indeed? I checked with our

[mapguide-users] FDO SQL SERVER SPATIAL - Polygon ring less than 3 points?

2011-11-23 Thread GordonL
http://osgeo-org.1803224.n2.nabble.com/file/n7026243/sql_fdo.png Has anyone seen this? Even if the polygon has plenty of nodes? gordon -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/FDO-SQL-SERVER-SPATIAL-Polygon-ring-less-than-3-points-tp7026243p7026243.html Sent fro

[mapguide-users] RE: Points from Sql/ODBC data source not showing

2011-11-23 Thread Bob Basques
Just stuff the data into POSTGIS, use that for the transactional stuff, and sync it with ARCSDE when and as frequently as needed. It seems like a lot of work this way, but you end up with control of everything from front to back. bobb >>> soudemans wrote: I guess it is time to cut my

Re: [mapguide-users] RE: Points from Sql/ODBC data source not showing

2011-11-23 Thread Andrew DeMerchant
Would it be worth anything to try dumping your data into an access database just to test things out (that uses the same odbc fdo)? If you can't get it going with that, then there's got to be some other problem... Andrew Sent from iPhone On Nov 23, 2011, at 5:29 PM, soudemans wrote: > I gues

Re: [mapguide-users] RE: Points from Sql/ODBC data source not showing

2011-11-23 Thread GIS4U
Did you end up getting it working? If not, can you provide some info on: 1. How many points are you talking about? Given it is a test dataset I am assuming it is not really large. 2. Can you view the attributes in the Feature Source? If you preview, do they display? 3. Have you tr

[mapguide-users] MgInsertFeatures clears the feature source

2011-11-23 Thread mika
Hi, I don't understand the function of the MgInsertFeatures method. I have SDF feature source in MG2011. If I do MgFeatureService.UpdateFeatures with the MgInsertFeatures command, all the previous data is gone. So doing for example five inserts, with one insert command each, results one row (t

[mapguide-users] Re: FDO SQL SERVER SPATIAL - Polygon ring less than 3 points?

2011-11-23 Thread Hans Milling
Can you show the actual query sent to the SQL server (using a trace or the like )? It seems that either you have too few points (even though you write there should be many) or they are at the same x/y lat/lng (perhaps value 0 in all of them?). Best regards Hans Milling... -- View this message in