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-tp2352146p2492571.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
