[mapguide-users] Solve problem MySQL Polygon Selection
Dhirendra Kumar
dhirendra.mgos at gmail.com
Mon Aug 6 07:26:13 EDT 2007
Hi Rahul,
I could not import Shp file using Shpfile to PostGIs import tool of QGIS.
After selecting SHP file and change SRID, Geometry column name when i click
on IMPORT button then i got one Error dialog box. sending screen. Rahul if
posible then please give me steps of shp file importing in PostGIS. See
where i wrong and why i get this error. I also try to import Shp using
shp2pgsql tool syntex ( shp2pgsql -s 4326 -c MOUZA.shp public.MOUZA
>mouza.sql ) and after importing in PostGIS Database, i can't see map on
layer. Thankyou in Advance.
http://www.nabble.com/file/p12014480/error.png
Regards,
Dhirendra Kumar
Rahul-2 wrote:
>
> Hi ,
> I think first you check with the open source Tool in
> QGIS-0.8.1(Download it !) Shapefile to PostGIS Import Tool ,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.
>
> cheers
> Max
>
> Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
>
> 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 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.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>
> ---------------------------------
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
> news, photos & more.
> _______________________________________________
> 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#a12014480
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list