<div>Hi ,</div> <div> I think first you check with the open source Tool in QGIS-0.8.1(Download it !) <STRONG>Shapefile to PostGIS Import Tool</STRONG> ,here you define SRID (PostGIS SRID:4326 for WGS 84 Lat/Lon) and define the Geomtry column of your Database as well as Schema,Finally you import the shape file in the Database and check the selection issues and other things with QGIS and once satisfied then you can try with ADSK MapGuide.</div> <div> </div> <div>cheers</div> <div>Max<BR><BR><B><I>Dhirendra Kumar <dhirendra.mgos@gmail.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Hi Rahul,<BR><BR>Thankyou for your replay, when i direct import .SHP file in Mapguide then it<BR>is working fine. but when i import shp file in PostGIS database using<BR>shp2pgsql then i get selection problem on Layer. I import .SHP file
in<BR>PostGIS database using SHP2pgsql syntex :- (1). shp2pgsql -c block.shp<BR>public.block > block.sql<BR>(2). psql -d postgis -U postgres -f block.sql<BR>Rahul help me where i m wrong ? We use Lat,Long projection system and Datum<BR>WGS 84. Any problem in importing SHP File ? Rahul i'll have to Set any<BR>Enviorment ( PGSQL_OGR_FID )variable for OGR Provider to comunicate with<BR>PostGIS Database Layer ? if yes then how. Please help me. Thankyou in<BR>Advance.<BR><BR>Regards,<BR><BR>Dhirendra Kumar<BR><BR>Rahul-2 wrote:<BR>> <BR>> Hi,<BR>> I think that there is no problem with the OGR Provider(3.2.2) but the<BR>> problem is with your original dataset(*.shp File) , i think you should<BR>> check the Topology of the Shape file(Polygons).<BR>> <BR>> Cheers<BR>> Max !!<BR>> <BR>> Dhirendra Kumar <DHIRENDRA.MGOS@GMAIL.COM>wrote:<BR>> <BR>> Hi Kenneth,<BR>> <BR>> I want your help once agian, Both are using same OGR provider (3.2.2)
but<BR>> you have not any problem, So i want know you are using which version of<BR>> MGOS and OGR Provider. In Earlier reply you mentioned some OGR version<BR>> have<BR>> problem, So tell me which verion is better and working fine with which<BR>> version of MGOS. Please help me. I am waiting for your replay. Thankyou in<BR>> Advance.<BR>> <BR>> Regards,<BR>> Dhirendra Kumar<BR>> <BR>> <BR>> Kenneth, GEOGRAF A/S wrote:<BR>>> <BR>>> I'm sorry, but I never had that problem with OGR,<BR>>> and I have no idea what may be causing it.<BR>>> <BR>>> Regards, Kenneth, GEOGRAF A/S<BR>>> <BR>>> <BR>>> <BR>>> Dhirendra Kumar skrev:<BR>>>> Hi Kenneth,<BR>>>><BR>>>> Now i established connection with OGR provider and MGOS1.2.0RC2, i can<BR>>>> make<BR>>>> layer also Performance is good. but when i select any polygon then<BR>>>>
polygon<BR>>>> not get selected. I established connection using OGR provider<BR>>>> (OGRProvider-3.2.2.win32.zip). Kenneth please help me once agian.<BR>>>> Thankyou<BR>>>> in Advance<BR>>>><BR>>>> Regards,<BR>>>> Dhirendra Kumar<BR>>>><BR>>>><BR>>>> Kenneth, GEOGRAF A/S wrote:<BR>>>> <BR>>>>> I have no experience with the PostGIS provider.<BR>>>>> I had no delays using OGR for PostGIS data.<BR>>>>><BR>>>>> Regards Kenneth, GEOGRAF A/S<BR>>>>><BR>>>>><BR>>>>><BR>>>>> Dhirendra Kumar skrev:<BR>>>>> <BR>>>>>> Hi Kenneth,<BR>>>>>><BR>>>>>> I make layer using PostGIS provider not OGR Provider. No problems with<BR>>>>>> tooltips, it is working fine. only problem with polygon selection<BR>>>>>>
taking<BR>>>>>> 4<BR>>>>>> second to highlight. OGR Provider can solve this problem ? Yes Kenneth<BR>>>>>> before displaying layer or map server use 100% CPU and before tool<BR>>>>>> tips<BR>>>>>> displaying server use 10-20% CPU. Any way to overcome this problem ?<BR>>>>>><BR>>>>>> Regards,<BR>>>>>><BR>>>>>> Dhirendra kumar<BR>>>>>><BR>>>>>><BR>>>>>> Kenneth, GEOGRAF A/S wrote:<BR>>>>>> <BR>>>>>> <BR>>>>>>> I recall that there was a problem with selection/info in some version<BR>>>>>>> of <BR>>>>>>> the OGR.<BR>>>>>>> What version of the OGR provider do you use?<BR>>>>>>><BR>>>>>>> Does your server use 100% CPU before displaying?<BR>>>>>>> Is
the problem the same with tooltip's ?<BR>>>>>>><BR>>>>>>> Regards, Kenneth, GEOGRAF A/S<BR>>>>>>><BR>>>>>>><BR>>>>>>> Dhirendra Kumar skrev:<BR>>>>>>> <BR>>>>>>> <BR>>>>>>>> Hi Kenneth,<BR>>>>>>>><BR>>>>>>>> Once again i am asking qustion to you about Postgres/PostGIS,<BR>>>>>>>> Kenneth<BR>>>>>>>> I<BR>>>>>>>> import table in PostGIS database using shp2pgsql tool. I can create<BR>>>>>>>> Layers<BR>>>>>>>> from PostGIs Database. But when i select any polygon then polygon<BR>>>>>>>> highlight<BR>>>>>>>> after 4 second, So can i increase performence of polygon selection ?<BR>>>>>>>> 300<BR>>>>>>>>
polygon on current layer. I also provide index but problem is still<BR>>>>>>>> same.<BR>>>>>>>> Any thing wrong in my process ? Please help me.<BR>>>>>>>><BR>>>>>>>> Regards,<BR>>>>>>>> Dhirendra Kumar<BR>>>>>>>><BR>>>>>>>> Kenneth, GEOGRAF A/S wrote:<BR>>>>>>>> <BR>>>>>>>> <BR>>>>>>>> <BR>>>>>>>>> As someone else mentioned, the selection problem is a known bug in<BR>>>>>>>>> the <BR>>>>>>>>> MySQL provider.<BR>>>>>>>>> You have the following options:<BR>>>>>>>>> 1. Wait until someone fixes the problem.<BR>>>>>>>>> 2. Download source and fix it yourself (or perhaps pay someone to<BR>>>>>>>>>
do<BR>>>>>>>>> it)<BR>>>>>>>>> 3. Use another provider<BR>>>>>>>>><BR>>>>>>>>> If you MUST use a "real" database, I can only suggest Oracle (you<BR>>>>>>>>> have <BR>>>>>>>>> tried the others).<BR>>>>>>>>> Are there any reason that you cannot use SDF files?<BR>>>>>>>>><BR>>>>>>>>> Regards, Kenneth, GEOGRAF A/S<BR>>>>>>>>><BR>>>>>>>>><BR>>>>>>>>><BR>>>>>>>>> Dhirendra Kumar skrev:<BR>>>>>>>>> <BR>>>>>>>>> <BR>>>>>>>>> <BR>>>>>>>>>> Hi All,<BR>>>>>>>>>><BR>>>>>>>>>> Sorry for repeating this qustion. I tested MS SQL
server, MySQL,<BR>>>>>>>>>> Postgresql/postGIS and i got result MySQL performance is better in<BR>>>>>>>>>> compare<BR>>>>>>>>>> of all, but problem in polygon selection. I want to know that, no<BR>>>>>>>>>> way<BR>>>>>>>>>> to<BR>>>>>>>>>> solve this polygon selection problem ? :(<BR>>>>>>>>>> PROBLEM:- When i select some polygon then near polygon get<BR>>>>>>>>>> highlighted<BR>>>>>>>>>> in<BR>>>>>>>>>> place of current selection.<BR>>>>>>>>>> If anyone have idea or suggestion then please help me. Thankyou in<BR>>>>>>>>>> Advance.<BR>>>>>>>>>><BR>>>>>>>>>>
Regards,<BR>>>>>>>>>><BR>>>>>>>>>> Dhirendra Kumar<BR>>>>>>>>>> <BR>>>>>>>>>> <BR>>>>>>>>>> <BR>>>>>>>>>> <BR>>>>>>>>> _______________________________________________<BR>>>>>>>>> mapguide-users mailing list<BR>>>>>>>>> mapguide-users@lists.osgeo.org<BR>>>>>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>>>>>>>><BR>>>>>>>>><BR>>>>>>>>> <BR>>>>>>>>> <BR>>>>>>>>> <BR>>>>>>>> <BR>>>>>>>> <BR>>>>>>>> <BR>>>>>>> _______________________________________________<BR>>>>>>> mapguide-users mailing
list<BR>>>>>>> mapguide-users@lists.osgeo.org<BR>>>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>>>>>><BR>>>>>>><BR>>>>>>> <BR>>>>>>> <BR>>>>>> <BR>>>>>> <BR>>>>> _______________________________________________<BR>>>>> mapguide-users mailing list<BR>>>>> mapguide-users@lists.osgeo.org<BR>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>>>><BR>>>>><BR>>>>> <BR>>>><BR>>>> <BR>>> <BR>>> _______________________________________________<BR>>> mapguide-users mailing list<BR>>> mapguide-users@lists.osgeo.org<BR>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>>> <BR>>> <BR>> <BR>> -- <BR>> View this message in context:<BR>>
http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11994528<BR>> Sent from the MapGuide Users mailing list archive at Nabble.com.<BR>> <BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> mapguide-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>> <BR>> <BR>> <BR>> ---------------------------------<BR>> Building a website is a piece of cake. <BR>> Yahoo! Small Business gives you all the tools to get online.<BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> mapguide-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>> <BR>> <BR><BR>-- <BR>View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a12010972<BR>Sent from the MapGuide Users mailing list archive at
Nabble.com.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR>mapguide-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Take the Internet to Go: Yahoo!Go puts the <a href="http://us.rd.yahoo.com/evt=48253/*http://mobile.yahoo.com/go?refer=1GNXIC">Internet in your pocket:</a> mail, news, photos & more.