<div>Hi ,</div> <div> 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.</div> <div> </div> <div>Cheers</div> <div>Max !!</div> <div><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-2<BR><BR>Now I established connection Mapguide studio 2007 with postgressql/postgis<BR>Database and also add PostGIS provider in FDO2FDO. Connection is OK. But<BR>after assignig source attribute with destination table attribute and<BR>providing Source class name: [SDF file name] and Destination class name:<BR>[Destination Table name] and when press Run Copy Task
then it show<BR>Error:c_FDO_Api::CopyFdoClass:Unable to find Class 'mouza' in destiantion!.<BR>but mouza table is persent in destination database. Rahul anything wrong in<BR>my step ? I also transfered SHP file using OGR2OGR in Postgres but due to<BR>performance problem i want to transfer sdf or shp file directly in database<BR>table using FDo2FDO. Rahul is it posible ? if you have any idea, how to<BR>transfer all data in PostgreSQL/PostGIS database using FDO2FDO then help me.<BR>I am asking to you because you already used PostgreSQL. Thankyou in Advance.<BR><BR>Regards,<BR>Dhirendra Kumar<BR><BR>Rahul-2 wrote:<BR>> <BR>> Hi,<BR>> OracleXE is free to download ,you can check on oracle<BR>> website,Regarding the slowness its nothing to do with PostGIS Database as<BR>> i already used some other webGIS solutions and no problem regarding<BR>> selection or anything ,may be something to do with OGR Provider(No Idea)<BR>> may be better clarification required
from Tarain or Kenneth.<BR>> <BR>> I think you try with SDF and 20 layers are not important ,the important<BR>> thing is data size and if you follow the "Guide--implementing best<BR>> practises using the MapGuide",i think u can work with 20 layers,just try<BR>> to work through with SDF if you have no customer limitations regarding the<BR>> Database.<BR>> <BR>> Cheers<BR>> Max !!<BR>> <BR>> Dhirendra Kumar <DHIRENDRA.MGOS@GMAIL.COM>wrote:<BR>> <BR>> Hi Rahul,<BR>> <BR>> Thankyou for suggestion. I want to use free database i have not idea about<BR>> OracleXE, it is free or not ? but i already test PostGIS. PostGIS is slow<BR>> in<BR>> compare of MySQL. In PostGIS when i select one polygon then polygon<BR>> higlight<BR>> after few second on my local machine. Any method to increase PostGIS<BR>> performence ? 20 layers in my project so i think SQLite will be not good<BR>> for<BR>> this project. help me.
Thankyou in Advance.<BR>> <BR>> Regards,<BR>> <BR>> Dhirendrs Kumar<BR>> <BR>> Rahul-2 wrote:<BR>>> <BR>>> Hi,<BR>>> I think you can try OracleXE and use King Oracle Provider 0.7.1<BR>>> or you can try PostGIS as both are much better Spatial Databases as<BR>>> compared to MySQL. <BR>>> <BR>>> SDF uses SQLite inbuilt database so i think for small scale not for<BR>>> enterprise solution SDF will also be an option to consider upon<BR>>> seriously.<BR>>> <BR>>> Cheers<BR>>> Max<BR>>> <BR>>> Dhirendra Kumar wrote:<BR>>> <BR>>> Hi Kenneth,<BR>>> <BR>>> Thankyou for replay and giving suggestion once again. I can't use Oracle<BR>>> as<BR>>> a FDO Database so for that resion i want use MySQL. you mentioned in 3rd<BR>>> no.<BR>>> points Use another provider, so which provider is better ? and another<BR>>> thing<BR>>> you
mentioned transfer all data using sdf file. So i transfered all data<BR>>> in<BR>>> MySQL database using FDO2FDO, 1st i convert shp file to sdf and after<BR>>> that<BR>>> importing sdf file in MySQL using FDO2FDO.Kenneth, any thing wrong in my<BR>>> steps ? I am waiting for your suggestion.<BR>>> <BR>>> Regards,<BR>>> Dhirendra Kumar<BR>>> <BR>>> <BR>>> Kenneth, GEOGRAF A/S wrote:<BR>>>> <BR>>>> As someone else mentioned, the selection problem is a known bug in 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 do it)<BR>>>> 3. Use another provider<BR>>>> <BR>>>> If you MUST use a "real" database, I can only suggest Oracle (you 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>>>>> 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 way<BR>>>>> to<BR>>>>> solve this polygon selection problem ? :(<BR>>>>> PROBLEM:- When i select some polygon then near polygon get 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>>>> 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#a11918234<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:<BR>> http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11919719<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#a11941126<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>Boardwalk for $500? In 2007? Ha! <br><a href="http://us.rd.yahoo.com/evt=48223/*http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow">Play Monopoly Here and Now</a> (it's updated for today's economy) at Yahoo! Games.