[mapguide-users] Layer's selection Problem
padmini godavarthi
godavarthi.padmini at gmail.com
Tue Mar 17 21:30:49 EDT 2009
Hi,
Thanks for u r reply
Now i have checked that srid in my database table was :32643
so that in maestro (map definition) i have setted the coordinate system as
WGS 84 / UTM zone 43N (EPSG:32643)
but iam unable to see the map on the viewer
http://n2.nabble.com/file/n2494902/layer.jpeg
can u plz tell me the solution
so thati want the layer selection in oracle package.
Thanks and Regards,
Padmini.
miansi wrote:
>
> You do not confirm one more thing:
>
> Did you check that your map using same coordinate system as records SRID?
>
> http://n2.nabble.com/file/n2492571/nabble.png
>
>
>
> padmini godavarthi wrote:
>>
>> Hi,
>> Thank u very much for your reply.
>> i have a table with the following columns
>>
>>
>> Name Null? Type
>> ----------------------------------------- --------
>> ----------------------------
>> OBJECTID NOT NULL NUMBER(38)
>> PROP_ID VARCHAR2(50)
>> GIS_SHEET_IDV VARCHAR2(50)
>> PROP_RMKS VARCHAR2(50)
>> PROP_TMPD DATE
>> SHAPE MDSYS.SDO_GEOMETRY
>> SE_ANNO_CAD_DATA BLOB
>> PROP_IMG BLOB
>> AREA NUMBER(38,8)
>>
>> 1) Here Shape is the spatial column and PROP_ID is unique int his table
>> 2) i have a spatial index for the shape column
>> 3) and in this shape column srid is 32643 for all the shapes
>> 4) and the layer is checked as selectable
>> 5) iam not using views . i have taken a table for displaying map
>>
>> But the problem is same .iam unable to select the layer on the viewer
>> and the layer length came as '0'.iam unable to get
>> it.
>> iam sending my screen shot
>> can u plz tell me the solution
>>
>>
>> http://n2.nabble.com/file/n2489737/map.jpeg
>>
>>
>> http://n2.nabble.com/file/n2489737/map1.jpeg
>>
>> Regards,
>> Padmini.
>>
>>
>> miansi wrote:
>>>
>>> Hello,
>>>
>>> Sorry for late responce.
>>>
>>> Everything should work. You have to check few things:
>>>
>>> 1. You have to have UNIQUE NON CLUSTERED INDEX on PointID column
>>> 2. You have to have Spatial INDEX on Point column
>>> 3. Map also have to use SRID 4326 (WGS 84)
>>> 4. Check on the Map that layer marked as selectable - it is not by
>>> default
>>> 5. If you using Views - No JOINS - it is confirmed bug. As soon as you
>>> introduce JOINS in Views - you will loose selection functionality
>>>
>>>
>>> It should work,
>>>
>>> Andrei
>>>
>>>
>>>
>>> aniliht wrote:
>>>>
>>>> I'm also using a sql server 2008 and have 2 simple tables as follows:
>>>>
>>>> Drawing
>>>> - DrawingID (PK, int, not null)
>>>> - DrawingName (varchar(50))
>>>>
>>>> Point
>>>> - PointID (PK, int, not null)
>>>> - DrawingID (FK, int, not null)
>>>> - Name (varchar(50))
>>>> - Point (geography, not null)
>>>>
>>>> There is one row in each table, the geography instance is in SRID 4326
>>>> (WGS 84). The item displays properly but I can't select it no matter
>>>> what.
>>>>
>>>> I'm using the windows install of Mapguide 2.0.2:
>>>> MgServerSetup-2.0.2.3011.exe. It did not have the SQL Server Spatial
>>>> provider bundled. So I installed the
>>>> fdosqlserverspatial-3.3.0_win32.tar.gz which is SQL Server Spatial BETA
>>>> 1. I chose this because the dll version of the bundled FDO.dll that
>>>> the MgServerSetup installed was 3.3.0.3901.
>>>>
>>>> Do you know if the BETA 1 version of the SQL Server Spatial provider
>>>> doesn't support selection on layers?
>>>>
>>>> What version of MapGuide, FDO, SQL Server Spatial Provider releases
>>>> work to be able to select points on a SQL layer?
>>>>
>>>> Is it ok to install the latest version of FDO (which is 3.3.2) into the
>>>> C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO directory,
>>>> overwritting the contents that the MgServerSetup placed?
>>>>
>>>> The release notes for MG 2.0.2 says: "MGOS 2.0.2 is compatible with FDO
>>>> 3.3.1 but the version packaged with the installers is actually a newer
>>>> version." But the version of FDO in the Bin directory appears to be
>>>> 3.3.0.3901.
>>>>
>>>> Thanks for any clues you can provide.
>>>>
>>>>
>>>>
>>>> miansi wrote:
>>>>>
>>>>> I have exactly the same behaviour for SQL 2008.
>>>>>
>>>>> I do not know if this is applicable for Oracle, but for SQL
>>>>> 1. You have to have Primary Key (clustered) on the table you want to
>>>>> show on the layer
>>>>> 2. PK has to be int
>>>>> 3. You have to create spatial index on the spatial column
>>>>> 4. As soon as you will try to add JOINS to your database view (if you
>>>>> trying to show layer off View) - you will lose selection
>>>>> functionality. I am fighting with this one for week already.
>>>>>
>>>>>
>>>>> Hope that will help
>>>>>
>>>>>
>>>>> padmini godavarthi wrote:
>>>>>>
>>>>>> Hi,
>>>>>> iam using mapguide opensource 2.0 (with .net 2.0 +IIS 5.1)
>>>>>>
>>>>>> I have created a package using Oracle "OSGEO FDO provider for Oracle"
>>>>>> and Mapguide Maestro.
>>>>>> but while seeing the map by"Show in browser" the layers are does not
>>>>>> selecting on map and the properties is not displaying even after i
>>>>>> checked the option "Features on layer are selectable" in the map
>>>>>> resource.
>>>>>>
>>>>>> Is anything i did wrong?
>>>>>>
>>>>>> Can u plz tell me the solution?
>>>>>>
>>>>>>
>>>>>> Thanks and Regards,
>>>>>> Padmini.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
--
View this message in context: http://n2.nabble.com/Layer%27s-selection-Problem-tp2352146p2494902.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list