[mapguide-users] Solve problem MySQL Polygon Selection

Rahul unicorn_admirer at yahoo.com
Wed Aug 1 04:23:07 EDT 2007


Hi ,
         I think you can use Shp2PgSql Tool as i used that tool to transfer shp file into PostGIS Database.You can also try to download QGIS (Free QuantumGIS ) for importing shapefile into PostGIS using Graphical user interface.You can define SRID as well as Geometry Column Name and public schema etc.
   
  Cheers
  Max !!
  

Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
  
Hi Rahul-2

Now I established connection Mapguide studio 2007 with postgressql/postgis
Database and also add PostGIS provider in FDO2FDO. Connection is OK. But
after assignig source attribute with destination table attribute and
providing Source class name: [SDF file name] and Destination class name:
[Destination Table name] and when press Run Copy Task then it show
Error:c_FDO_Api::CopyFdoClass:Unable to find Class 'mouza' in destiantion!.
but mouza table is persent in destination database. Rahul anything wrong in
my step ? I also transfered SHP file using OGR2OGR in Postgres but due to
performance problem i want to transfer sdf or shp file directly in database
table using FDo2FDO. Rahul is it posible ? if you have any idea, how to
transfer all data in PostgreSQL/PostGIS database using FDO2FDO then help me.
I am asking to you because you already used PostgreSQL. Thankyou in Advance.

Regards,
Dhirendra Kumar

Rahul-2 wrote:
> 
> Hi,
> OracleXE is free to download ,you can check on oracle
> website,Regarding the slowness its nothing to do with PostGIS Database as
> i already used some other webGIS solutions and no problem regarding
> selection or anything ,may be something to do with OGR Provider(No Idea)
> may be better clarification required from Tarain or Kenneth.
> 
> I think you try with SDF and 20 layers are not important ,the important
> thing is data size and if you follow the "Guide--implementing best
> practises using the MapGuide",i think u can work with 20 layers,just try
> to work through with SDF if you have no customer limitations regarding the
> Database.
> 
> Cheers
> Max !!
> 
> Dhirendra Kumar wrote:
> 
> Hi Rahul,
> 
> Thankyou for suggestion. I want to use free database i have not idea about
> OracleXE, it is free or not ? but i already test PostGIS. PostGIS is slow
> in
> compare of MySQL. In PostGIS when i select one polygon then polygon
> higlight
> after few second on my local machine. Any method to increase PostGIS
> performence ? 20 layers in my project so i think SQLite will be not good
> for
> this project. help me. Thankyou in Advance.
> 
> Regards,
> 
> Dhirendrs Kumar
> 
> Rahul-2 wrote:
>> 
>> Hi,
>> I think you can try OracleXE and use King Oracle Provider 0.7.1
>> or you can try PostGIS as both are much better Spatial Databases as
>> compared to MySQL. 
>> 
>> SDF uses SQLite inbuilt database so i think for small scale not for
>> enterprise solution SDF will also be an option to consider upon
>> seriously.
>> 
>> Cheers
>> Max
>> 
>> Dhirendra Kumar wrote:
>> 
>> Hi Kenneth,
>> 
>> Thankyou for replay and giving suggestion once again. I can't use Oracle
>> as
>> a FDO Database so for that resion i want use MySQL. you mentioned in 3rd
>> no.
>> points Use another provider, so which provider is better ? and another
>> thing
>> you mentioned transfer all data using sdf file. So i transfered all data
>> in
>> MySQL database using FDO2FDO, 1st i convert shp file to sdf and after
>> that
>> importing sdf file in MySQL using FDO2FDO.Kenneth, any thing wrong in my
>> steps ? I am waiting for your suggestion.
>> 
>> 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
>>> 
>>> 
>> 
>> -- 
>> View this message in context:
>> http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11918234
>> 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#a11919719
> 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#a11941126
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


       
---------------------------------
Boardwalk for $500? In 2007? Ha! 
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070801/934f56e0/attachment.html


More information about the mapguide-users mailing list