[mapguide-users] King.Oracle 0.4.4 & MapGuide Studio

Haris Kurtagic haris at sl-king.com
Thu Nov 16 15:31:43 EST 2006 

Hi Max,
I saw that issue with NUMERIC fields also. SHP provider is for example reporting 9 digit field (King.Oracle provider will create 9 digit column in Oracle) and than returning 10 digit number which than doesn't go into Oracle. I changed that for SHP provider NUMERIC field has +2 for precision.
This column BL_TAMBOL is char ?
I think you could could solve this by manually changing size of column in Oracle and then when importing from SHP select 'Skip Schema creatinon' (soemthing like that) in Fdo2Fdo.
I would like also to look at your shp file if you can send it to me (I can look in a couple of days).
 
Haris

________________________________

From: Rahul [mailto:unicorn_admirer at yahoo.com]
Sent: Thu 11/16/2006 7:59 AM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] King.Oracle 0.4.4 & MapGuide Studio


Hi Haris,
               Thanks a lot for your kind reply now all the things working great ,I able to upload the Shape file and later on can connect using the MapGuide Studio 2007.Your link for the King Oracle (Oracle Spatial) also helped a lot.
 
Today i tried to install another shape file with Thai characters and when i tried to copy to oracle 10gR2 Database using fdo2fdo tool ,it use to give error value too large for cloumn ,although the table and column are created by fdo2fdo tool.(Kindly refer to the attached file).
 
Any suggestions from your side.
 
Max


Joel Carranza <jec at gatekeeper.com> wrote:

	Haris,
	
	One of the problems we still face with the described setup is that, when using views, we don't really have the options of declaring spatial indexes to define the geometry type of the layer. I don't know if you can even create a spatial index on a view, but even if you could, we might have a large number of views based on the same underlying table. We don't really want to create a spatial index for each additional view.
	
	Have you given any thought to previous discussions we about a "back-door" configuration option, which allows us to specify overrides for primary key and geometry type for the tables in a schema?
	
	BTW, the provider is running great on our dataset. Thanks for the hard work! 
	
	Joel
	
	Haris Kurtagic wrote: 

		Hi,
		 
		Here is document which describes how King.Oracle provider uses Oracle Spatial.
		It is about configuring Oracle metadata, Oracle views, spatial indexes, primary keys and sequences for use with King.Oracle provider.
		 
		http://www.sl-king.com/fdooracle/KingOracleSetup.html
		 
		 
		I hope this is readable and understandable document and sorry for probable mistakes in English, any suggestions and corrections are welcome.
		 
		Haris

________________________________

		From: Rahul [mailto:unicorn_admirer at yahoo.com] 
		Sent: Wednesday, November 15, 2006 8:27 AM
		To: users at mapguide.osgeo.org
		Subject: [mapguide-users] King.Oracle 0.4.4
		
		
		Hi,
		        I tried to load the shapefile into the oracle 10gR2 using the fdo2fdo tool and after sucessfully loading the shapfile ,i tried to connect the Spatial Table with the Autodesk MapStudio 2007 using the the King.Oracle 0.4.4.0 provider ,i sucessfully able to connect to the oracle database and able to get related attributes in the Layer Editior but unable to view the Layer in the layer preview window,.
		 
		Please refer to the attached pdf file for the details and any kind of help will be highly appreciated.
		 
		 
		Max
		 

		Haris Kurtagic <haris at sl-king.com> <mailto:haris at sl-king.com>  wrote:

			Hi Juan,
			 
			Great, I would like to see the sites you created.
			 
			Haris

________________________________

			From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
			Sent: Monday, November 13, 2006 5:56 PM
			To: users at mapguide.osgeo.org
			Subject: RE: [mapguide-users] King.Oracle 0.3.3
			
			
			Great...I will get this loaded and tested.
			 
			It's be going really well lately (in terms of performance) and I'm about ready to release some sites to the Public.  The anti-Microsoft crowd should be pleased with the AJAX viewer.
			 
			Juan Butler - Senior Programmer/Analyst
			GIS Applications
			Pinellas County Information Systems
			jpbutler at pinellascounty.org
			 
			Please note: All mail sent to and from Pinellas County Government is subject to the Public Records Law of Florida.
			 
			 
			
________________________________

			From: Haris Kurtagic [mailto:haris at sl-king.com] 
			Sent: Friday, November 10, 2006 9:23 AM
			To: users at mapguide.osgeo.org
			Subject: RE: [mapguide-users] King.Oracle 0.3.3
			 
			I have found a issue with provider not closing all statements (started in version 0.3.2) , so this could lead to increase of memory usage.
			 
			I fix it in 0.4.4 version of provider.
			 
			It would be great if you can try that and tell me if it is working for you now.
			 
			Haris
			 
			
________________________________

			From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
			Sent: Tuesday, October 24, 2006 7:52 PM
			To: users at mapguide.osgeo.org
			Subject: RE: [mapguide-users] King.Oracle 0.3.3
			Haris:
			 
			I'm testing this now and it seems that your provider is pulling up the spatial data much faster.  The only problem that I'm running into is the server process is eating up memory at a large clip when adding more layers from Oracle.  It's gotten up to over a GIG.   I've had to shutdown Mapguide server completely and then restart it.  The memory usage will go back up as I interact with more Oracle spatial layers.  Not sure if it's more on the Mapguide server side or the provider.
			 
			I just wish I could use this for non Oracle Spatial tables with coordinate fields.  The ODBC provider will not show tables for me.
			 
			Juan Butler - Senior Programmer/Analyst
			GIS Applications
			Pinellas County Information Systems
			jpbutler at pinellascounty.org
			 
			Please note: All mail sent to and from Pinellas County Government is subject to the Public Records Law of Florida.
			 
			 
			
________________________________

			From: Haris Kurtagic [mailto:haris at sl-king.com] 
			Sent: Tuesday, October 24, 2006 7:17 AM
			To: users at mapguide.osgeo.org
			Subject: [mapguide-users] King.Oracle 0.3.3
			 
			Hi,
			 
			newer version of King.Oracle 0.3.3 provider:

			*	Support for Spatial Views
				It will display views based on spatial tables. Views needs to be added into sdo_geom_metadata for provider to find them. 

			Get it here: www.sl-king.com/fdooracle
			 
			Haris
			 
			 


		
________________________________

		Sponsored Link
		
		Don't quit your job <http://www.classesusa.com/clickcount.cfm?id=607556&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D607555>  - take classes online and earn your degree in 1 year. Start Today <http://www.classesusa.com/clickcount.cfm?id=607556&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D607555>  


________________________________

Sponsored Link

Mortgage rates near 39yr lows. $310,000 Mortgage for $999/mo - Calculate new house payment <http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9133-16415&moid=4673> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 17062 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061116/e937bcf7/attachment.bin

More information about the Mapguide-users mailing list