Re: [mapguide-users] View on Oracle Express
Could it be as simple as permissions on the view? -Original message- From: Zac Spitzer zac.spit...@gmail.com Date: Tue, 07 Sep 2010 23:39:30 -0700 To: MapGuide Users Mail List mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] View on Oracle Express also remember that mapguide caches the schema info, so once you have accessed a schema, mapguide won't read the schema until that cache expires... so no changes will show up you can flush the cache by simply opening and saving the feature source defintion z On Wed, Sep 8, 2010 at 2:30 PM, VOLZ Mark (FN) mark.v...@ergon.com.au wrote: Francesco, That all seems very strange (that it is working on tables but not views). Are you changing the geometry in anyway in your views? i.e. are you using any of cs_transform, aggr, sdo functions/procedures, custom packages/functions/procedures, etc? certain ones will null and void your index. Are the entries in your user_sdo_geom_metadata for your views exactly the same as the ones for the tables i.e. you haven't changed accuracies or x y column names. Have your tried running a sdo_relate query on your view, shown below (it will test the above questions)? Select * From xe.view v Where sdo_relate (v.geomtry_column, sdo_geometry(2003,8311,null,sdo_elem_info_array(1,1003,3),sdo_ordinate_a rray(145.683622,-16.88905,145.6925,-16.880274)), 'mask=ANYINTERACT') = 'TRUE'; Unless you are in Australia that code shouldn't return any records but it will test that your view supports spatial queries (its actually a snippet of sql that Mapguide sent to our database about 5 minutes ago). Have you tried materialized view? How did you add the primary key to the view? Did you use a statement similar to this after creating the view;? ALTER VIEW XE.VIEW ADD ( CONSTRAINT VIEW_PK PRIMARY KEY (column_name) DISABLE); Sorry if I am asking you to check simple things but I had similar problems getting my oracle setup going so I'm just running through all the different problems I ran into using views in XE and mapguide. Mark. -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Francesco Sozzi Sent: Tuesday, 7 September 2010 5:42 PM To: MapGuide Users Mail List Subject: Re: [mapguide-users] View on Oracle Express Hi Mark, Thanks for answer. I confirm primary key and spatial index for both tables and views. On Oracle Express I manage small data. Tablespaces are smaller that 100MB. I tried to drop and recreate all keys and spatial index. Oracle did the job with no warnings or errors, so I am sure all index are ok. For the moment my workaround is to create side tables with the content of views, a sort of snapshots on views I need to publish data. With these tables (populated with data from views) MG works as expected. Please note that I need views (or these side tables) to show joined data in the property panel. Best regard Francesco - Original Message - From: VOLZ Mark (FN) mark.v...@ergon.com.au To: MapGuide Users Mail List mapguide-users@lists.osgeo.org Sent: Monday, September 06, 2010 8:00 PM Subject: RE: [mapguide-users] View on Oracle Express Francesco, Can you confirm that the geometry columns (in the underlying table(s)) you are trying to use in the views have a spatial index built on them? The second thing to look at is the size of the database. A spatial index takes up table space so if you have a data set of about 4.5gb and then try and build a spatial index it will fail due to the size restriction on XE. This may be why the imported schema works in Standard/enterprise but not in XE. Mapguide always sends a spatial query when querying the data from oracle (which will fail if you don't have a spatial index), Autocad map doesn't always do this. Mark -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer Sent: Tuesday, 7 September 2010 11:27 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] View on Oracle Express have you tried the latest king oracle provider? http://www.sl-king.com/fdooracle/ Also it's always helpful to state versions of the various software z On Mon, Sep 6, 2010 at 10:38 PM, Francesco Sozzi fso...@intercad.ch wrote: Hi All, I have an Oracle schema with views to render on Mapguide Open Source. If I load this schema on an Oracle Standard or Enterprise, views are rendered. If I load on Mapguide from express, they are not rendered (I can render the table with geometry field, but not the view). All views are in USER_SDO_GEOM_METADATA and all views have primary keys. I can load and render on Autodesk Map from Oracle Express without problems. From Maestro
[mapguide-users] Re: Anonymous user without password can't connect to MGServer with MaestroAPI
Thank you, Jackie. I am waiting for the next release of Maestro! - Regards, Carl SHE -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Anonymous-user-without-password-can-t-connect-to-MGServer-with-MaestroAPI-tp5507729p5510259.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] View on Oracle Express
, they are not rendered (I can render the table with geometry field, but not the view). All views are in USER_SDO_GEOM_METADATA and all views have primary keys. I can load and render on Autodesk Map from Oracle Express without problems. From Maestro I can see them in the list, if I try to create a layer, but they are not rendered at all. Any idea or suggstions? Best regards Francesco __ Information from ESET NOD32 Antivirus, version of virus signature database 5426 (20100906) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users - To report this email as spam, please forward to s...@mailcontrol.com - * This e-mail (including any attachments) may contain confidential or privileged information and is intended for the sole use of the person(s) to whom it is addressed. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, please notify the sender of the message or send an e-mail to mailto:help.d...@ergon.com.au immediately, and delete all copies. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail by an unintended recipient is prohibited. Ergon Energy accepts no responsibility for the content of any e-mail sent by an employee which is of a personal nature. Ergon Energy Corporation Limited ABN 50 087 646 062 * ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users __ Information from ESET NOD32 Antivirus, version of virus signature database 5429 (20100906) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 5429 (20100906) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users __ Information from ESET NOD32 Antivirus, version of virus signature database 5433 (20100908) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 5434 (20100908) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Re: Anonymous user without password can't connect to MGServer with MaestroAPI
New release will be coming out *very* soon. Just need follow-ups on some remaining tickets. - Jackie -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Anonymous-user-without-password-can-t-connect-to-MGServer-with-MaestroAPI-tp5507729p5510809.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Multiple points with same lat/lon
Hello Everyone I am working on a map application that displays water sample stations. Each station is represented by a point on the map that can be clicked to activate a url to show station data. Many of the stations are two in one and share the same lat/lon. Therefore, two points are in the exact same spot on the map and I can only get the url to activate for the point that ends up on top of the other. Is there any way to give the user a choice of which point they are trying to activate if there are multiple points in the exact same spot? Thanks -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon-tp5510865p5510865.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] MapGuide Maestro 2.1.2 released
Hi All, I have put up a new release of Maestro (2.1.2). This is a bugfix release and fixes several show-stoppers relating to Mono in Linux and Mac OS. This release is highly recommended if you run Maestro under Mono. Download here: http://trac.osgeo.org/mapguide/wiki/maestro/Downloads - Jackie -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/MapGuide-Maestro-2-1-2-released-tp5510985p5510985.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Multiple points with same lat/lon
How about explaining to them that they could temporarily _turn off_ the undesirable layer? r, dennis -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Nickthetemp Sent: Wednesday, September 08, 2010 10:32 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] Multiple points with same lat/lon Hello Everyone I am working on a map application that displays water sample stations. Each station is represented by a point on the map that can be clicked to activate a url to show station data. Many of the stations are two in one and share the same lat/lon. Therefore, two points are in the exact same spot on the map and I can only get the url to activate for the point that ends up on top of the other. Is there any way to give the user a choice of which point they are trying to activate if there are multiple points in the exact same spot? Thanks -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon -tp5510865p5510865.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users Scan by McAfee ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] RE: Multiple points with same lat/lon
The points are in the same layer. Also, the map is embedded in a page with an iframe so the legend has been turned off to save space. Thanks -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon-tp5510865p5511244.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] RE: Multiple points with same lat/lon
I think you will have to execute a query in a page and return a result set to select from. Maybe include only the points that have multiple entries. Otherwise you could move the points to different layer via a filter if that's possible. But then the user would need to be able to turn off one of the layers. If your legend isn't visible you might create two buttons for the toolbar that toggle the visibility of the two layers. Just some sample ideas. I know someone had created some code to show multiple records in the results pane, but I don't know if it lets you toggle between them. Flexible layouts may allow for something like this, but if you have the legend off I'm guessing you have the properties pane off too. Dave -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Nickthetemp Sent: Wednesday, September 08, 2010 10:02 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] RE: Multiple points with same lat/lon The points are in the same layer. Also, the map is embedded in a page with an iframe so the legend has been turned off to save space. Thanks -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon-tp5510865p5511244.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] RE: Multiple points with same lat/lon
Ok ... Maybe have the user offer up a chant to the D.W.I.M(Do What I Mean) gods? ;-) r, dennis -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Nickthetemp Sent: Wednesday, September 08, 2010 12:02 PM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] RE: Multiple points with same lat/lon The points are in the same layer. Also, the map is embedded in a page with an iframe so the legend has been turned off to save space. Thanks -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon -tp5510865p5511244.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users Scan by McAfee ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] RE: Multiple points with same lat/lon
If you could force the user to select using a box, you'd always be assured that both points were selected and pass both selected points to your url, and then process it how you'd like (either display both, or let the user choose, etc). Of course, this depends on what sort of url you are opening...maybe it's static html, in which case, this wouldn't work. Andrew On 10/09/08 1:48 PM, Dave Wilson wrote: I think you will have to execute a query in a page and return a result set to select from. Maybe include only the points that have multiple entries. Otherwise you could move the points to different layer via a filter if that's possible. But then the user would need to be able to turn off one of the layers. If your legend isn't visible you might create two buttons for the toolbar that toggle the visibility of the two layers. Just some sample ideas. I know someone had created some code to show multiple records in the results pane, but I don't know if it lets you toggle between them. Flexible layouts may allow for something like this, but if you have the legend off I'm guessing you have the properties pane off too. Dave -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Nickthetemp Sent: Wednesday, September 08, 2010 10:02 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] RE: Multiple points with same lat/lon The points are in the same layer. Also, the map is embedded in a page with an iframe so the legend has been turned off to save space. Thanks -- Andrew DeMerchant tel: 506.453.1025 / toll-free: 1.877.243.6832 fax: 506.453.9470 This e-mail message (including attachments, if any) is confidential and may be privileged. Any unauthorized distribution or disclosure is prohibited. Disclosure to anyone other than the intended recipient does not constitute waiver of privilege. If you have received this e-mail in error, please notify us and delete it and any attachments from your computer system and records. -- Ce courriel (y compris les pièces jointes) est confidentiel et peut être privilégié. La distribution ou la divulgation non autorisée de ce courriel est interdite. Sa divulgation à toute personne autre que son destinataire ne constitue pas une renonciation de privilège. Si vous avez reçu ce courriel par erreur, veuillez nous aviser et éliminer ce courriel, ainsi que les pièces jointes, de votre système informatique et de vos dossiers. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] RE: [ODBC provider] Select within
Is there any chance this limitation of the provider will be worked out in the near future? Or any known workarounds? I have a real need for the functionality to work as one would expect. It worked on my old MapGuide 6.5 site, and now that I have moved to the new and improved technology, I can't get it to work, and my users are getting frustrated. Any ideas for workarounds? Still need to use ODBC connection for point data - that is non-negotiable. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/ODBC-provider-Select-within-tp3424323p5511566.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] RE: Multiple points with same lat/lon
In the past, I've done it one of two ways but you need some data processing software (such as FME or GIS or Spatial database) to make it work. Method 1: Process the data and come up with a single point that has a count of the number of items at the same point (Point on Point) and create a resultant table to store the values. Label the point with the number of points on top of each other. Method 2: Offset the points by a distance (x,y) that could rotate around the compass (or other method depending on the number of points that may overlap) then draw a line from the new point to the original point to show the user the source. Perhaps you could try buffering the points based on a increasing buffer value and then order the items so that the largest buffer displays first etc... Without the third dimension you are going to have to be a little bit flexible and creative in your solution... J 2010/9/8 Andrew DeMerchant andrew.demerch...@gemtec.ca If you could force the user to select using a box, you'd always be assured that both points were selected and pass both selected points to your url, and then process it how you'd like (either display both, or let the user choose, etc). Of course, this depends on what sort of url you are opening...maybe it's static html, in which case, this wouldn't work. Andrew On 10/09/08 1:48 PM, Dave Wilson wrote: I think you will have to execute a query in a page and return a result set to select from. Maybe include only the points that have multiple entries. Otherwise you could move the points to different layer via a filter if that's possible. But then the user would need to be able to turn off one of the layers. If your legend isn't visible you might create two buttons for the toolbar that toggle the visibility of the two layers. Just some sample ideas. I know someone had created some code to show multiple records in the results pane, but I don't know if it lets you toggle between them. Flexible layouts may allow for something like this, but if you have the legend off I'm guessing you have the properties pane off too. Dave -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org mapguide-users-boun...@lists.osgeo.org] On Behalf Of Nickthetemp Sent: Wednesday, September 08, 2010 10:02 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] RE: Multiple points with same lat/lon The points are in the same layer. Also, the map is embedded in a page with an iframe so the legend has been turned off to save space. Thanks -- -- [image: GEMTEC Limited] http://www.gemtec.ca/ *Andrew DeMerchant* tel: 506.453.1025 / toll-free: 1.877.243.6832 fax: 506.453.9470 This e-mail message (including attachments, if any) is confidential and may be privileged. Any unauthorized distribution or disclosure is prohibited. Disclosure to anyone other than the intended recipient does not constitute waiver of privilege. If you have received this e-mail in error, please notify us and delete it and any attachments from your computer system and records. -- Ce courriel (y compris les pièces jointes) est confidentiel et peut être privilégié. La distribution ou la divulgation non autorisée de ce courriel est interdite. Sa divulgation à toute personne autre que son destinataire ne constitue pas une renonciation de privilège. Si vous avez reçu ce courriel par erreur, veuillez nous aviser et éliminer ce courriel, ainsi que les pièces jointes, de votre système informatique et de vos dossiers. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users gemtec.png___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] RE: Multiple points with same lat/lon
Thanks for the replys. I will work with some of these suggestions to see if I can come up with a solution. Nick -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Multiple-points-with-same-lat-lon-tp5510865p5511640.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Mapguide 2.2 release date estimate?
Is there an updated release date for either MGOS 2.2RC or the final build? Some sort of rough timeline would be useful...I've seen the roadmap from http://trac.osgeo.org/mapguide/roadmap, but that says it's 2 months late now, with 25 open tickets remaining...does anyone have an estimate? Are we looking at a few more months, or a few more weeks? Andrew -- Andrew DeMerchant tel: 506.453.1025 / toll-free: 1.877.243.6832 fax: 506.453.9470 This e-mail message (including attachments, if any) is confidential and may be privileged. Any unauthorized distribution or disclosure is prohibited. Disclosure to anyone other than the intended recipient does not constitute waiver of privilege. If you have received this e-mail in error, please notify us and delete it and any attachments from your computer system and records. -- Ce courriel (y compris les pièces jointes) est confidentiel et peut être privilégié. La distribution ou la divulgation non autorisée de ce courriel est interdite. Sa divulgation à toute personne autre que son destinataire ne constitue pas une renonciation de privilège. Si vous avez reçu ce courriel par erreur, veuillez nous aviser et éliminer ce courriel, ainsi que les pièces jointes, de votre système informatique et de vos dossiers. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] unable to resolve conflicts between different MapGuideDotNetAPI versions
I am now just developing a website. MaestroAPI and MapGuideDotNetAPI are referenced to deal with WebGIS. (both dlls are copied from the installation folder of Maestro 2.1.1/2.1.2). But every time when I compile the project, there is a warning message. unable to resolve conflicts between MapGuideDotNetApi, Version=2.0.0.2308, Culture=neutral, PublicKeyToken=f526c48929fda856 and MapGuideDotNetApi, Version=1.2.0.4103, Culture=neutral, PublicKeyToken=6416a18f8953383b In fact, the website runs well, and MapGuide can be connected and the web map can be shown normally. Could someone tell me the meaning of above message? Thanks in advance! - Regards, Carl SHE -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/unable-to-resolve-conflicts-between-different-MapGuideDotNetAPI-versions-tp5511964p5511964.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Re: without click CTRL
Hi, I has the same question but I am the new here. Can you please tell me where is the view API file and how do you modified the Fusion layout to solve the problem in a little bit more details? Thank you for your time. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/without-click-CTRL-tp5481240p5512234.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Re: without click CTRL
Hi! I change to using Fusion layout, as the tooltip feature doesn't need to click the CTRL button to activated. What I made? the feature will be pop-up the image when the mouse is over the point feature. Then the user just click the image and then linked to another information e.g. map layout, url, web service ... That is! No more customization need to be made. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/without-click-CTRL-tp5481240p5513213.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users