[mapguide-users] Solve problem MySQL Polygon Selection

Dhirendra Kumar dhirendra.mgos at gmail.com
Mon Aug 6 00:47:19 EDT 2007


Hi Rahul,

Thankyou for your replay, when i direct import .SHP file in Mapguide then it
is working fine. but when i import shp file in PostGIS database using
shp2pgsql then i get selection problem on Layer. I import .SHP file in
PostGIS database using SHP2pgsql syntex :- (1). shp2pgsql -c block.shp
public.block > block.sql
(2). psql -d postgis -U postgres -f block.sql
Rahul help me where i m wrong ? We use Lat,Long projection system and Datum
WGS 84. Any problem in importing SHP File ? Rahul i'll have to Set any
Enviorment ( PGSQL_OGR_FID  )variable for OGR Provider to comunicate with
PostGIS Database Layer ? if yes then how. Please help me. Thankyou in
Advance.

Regards,

Dhirendra Kumar

Rahul-2 wrote:
> 
> Hi,
>    I think that there is no problem with the OGR Provider(3.2.2) but the
> problem is with your original dataset(*.shp File) , i think you should
> check the Topology of the Shape file(Polygons).
>    
>   Cheers
>   Max !!
> 
> Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
>   
> Hi Kenneth,
> 
> I want your help once agian, Both are using same OGR provider (3.2.2) but
> you have not any problem, So i want know you are using which version of
> MGOS and OGR Provider. In Earlier reply you mentioned some OGR version
> have
> problem, So tell me which verion is better and working fine with which
> version of MGOS. Please help me. I am waiting for your replay. Thankyou in
> Advance.
> 
> Regards,
> Dhirendra Kumar
> 
> 
> Kenneth, GEOGRAF A/S wrote:
>> 
>> I'm sorry, but I never had that problem with OGR,
>> and I have no idea what may be causing it.
>> 
>> Regards, Kenneth, GEOGRAF A/S
>> 
>> 
>> 
>> Dhirendra Kumar skrev:
>>> Hi Kenneth,
>>>
>>> Now i established connection with OGR provider and MGOS1.2.0RC2, i can
>>> make
>>> layer also Performance is good. but when i select any polygon then
>>> polygon
>>> not get selected. I established connection using OGR provider
>>> (OGRProvider-3.2.2.win32.zip). Kenneth please help me once agian.
>>> Thankyou
>>> in Advance
>>>
>>> Regards,
>>> Dhirendra Kumar
>>>
>>>
>>> Kenneth, GEOGRAF A/S wrote:
>>> 
>>>> I have no experience with the PostGIS provider.
>>>> I had no delays using OGR for PostGIS data.
>>>>
>>>> Regards Kenneth, GEOGRAF A/S
>>>>
>>>>
>>>>
>>>> Dhirendra Kumar skrev:
>>>> 
>>>>> Hi Kenneth,
>>>>>
>>>>> I make layer using PostGIS provider not OGR Provider. No problems with
>>>>> tooltips, it is working fine. only problem with polygon selection
>>>>> taking
>>>>> 4
>>>>> second to highlight. OGR Provider can solve this problem ? Yes Kenneth
>>>>> before displaying layer or map server use 100% CPU and before tool
>>>>> tips
>>>>> displaying server use 10-20% CPU. Any way to overcome this problem ?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Dhirendra kumar
>>>>>
>>>>>
>>>>> Kenneth, GEOGRAF A/S wrote:
>>>>> 
>>>>> 
>>>>>> I recall that there was a problem with selection/info in some version
>>>>>> of 
>>>>>> the OGR.
>>>>>> What version of the OGR provider do you use?
>>>>>>
>>>>>> Does your server use 100% CPU before displaying?
>>>>>> Is the problem the same with tooltip's ?
>>>>>>
>>>>>> Regards, Kenneth, GEOGRAF A/S
>>>>>>
>>>>>>
>>>>>> Dhirendra Kumar skrev:
>>>>>> 
>>>>>> 
>>>>>>> Hi Kenneth,
>>>>>>>
>>>>>>> Once again i am asking qustion to you about Postgres/PostGIS,
>>>>>>> Kenneth
>>>>>>> I
>>>>>>> import table in PostGIS database using shp2pgsql tool. I can create
>>>>>>> Layers
>>>>>>> from PostGIs Database. But when i select any polygon then polygon
>>>>>>> highlight
>>>>>>> after 4 second, So can i increase performence of polygon selection ?
>>>>>>> 300
>>>>>>> polygon on current layer. I also provide index but problem is still
>>>>>>> same.
>>>>>>> Any thing wrong in my process ? Please help me.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Dhirendra Kumar
>>>>>>>
>>>>>>> Kenneth, GEOGRAF A/S wrote:
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>>> As someone else mentioned, the selection problem is a known bug in
>>>>>>>> the 
>>>>>>>> MySQL provider.
>>>>>>>> You have the following options:
>>>>>>>> 1. Wait until someone fixes the problem.
>>>>>>>> 2. Download source and fix it yourself (or perhaps pay someone to
>>>>>>>> do
>>>>>>>> it)
>>>>>>>> 3. Use another provider
>>>>>>>>
>>>>>>>> If you MUST use a "real" database, I can only suggest Oracle (you
>>>>>>>> have 
>>>>>>>> tried the others).
>>>>>>>> Are there any reason that you cannot use SDF files?
>>>>>>>>
>>>>>>>> Regards, Kenneth, GEOGRAF A/S
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Dhirendra Kumar skrev:
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>>> Hi All,
>>>>>>>>>
>>>>>>>>> Sorry for repeating this qustion. I tested MS SQL server, MySQL,
>>>>>>>>> Postgresql/postGIS and i got result MySQL performance is better in
>>>>>>>>> compare
>>>>>>>>> of all, but problem in polygon selection. I want to know that, no
>>>>>>>>> way
>>>>>>>>> to
>>>>>>>>> solve this polygon selection problem ? :(
>>>>>>>>> PROBLEM:- When i select some polygon then near polygon get
>>>>>>>>> highlighted
>>>>>>>>> in
>>>>>>>>> place of current selection.
>>>>>>>>> If anyone have idea or suggestion then please help me. Thankyou in
>>>>>>>>> Advance.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>>
>>>>>>>>> Dhirendra Kumar
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>> _______________________________________________
>>>>>>>> mapguide-users mailing list
>>>>>>>> mapguide-users at lists.osgeo.org
>>>>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>>>>>
>>>>>>>>
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>> _______________________________________________
>>>>>> mapguide-users mailing list
>>>>>> mapguide-users at lists.osgeo.org
>>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>>>
>>>>>>
>>>>>> 
>>>>>> 
>>>>> 
>>>>> 
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>
>>>>
>>>> 
>>>
>>> 
>> 
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11994528
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 
>        
> ---------------------------------
> Building a website is a piece of cake. 
> Yahoo! Small Business gives you all the tools to get online.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a12010972
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list