Hi All,
In a Proceess of dividing of our blogs in diffrent technologies. we have started creating the new blogs..
http://indiaarcgis.blogspot.com/
http://autocadprogramming.blogspot.com/
Coming soon....
Keep visiting our blogs and don't forget to post your comments
Regards,
public FDOOracleClass(string username,string password,string servicename,string featureclassname)
{
FDOConnection.ConnectionInfo.ConnectionProperties.SetProperty("USERNAME", username);
FDOConnection.ConnectionInfo.ConnectionProperties.SetProperty("PASSWORD", password);
FDOConnection.ConnectionInfo.ConnectionProperties.SetProperty("SERVICE", servicename);
FDOConnection.ConnectionInfo.ConnectionProperties.SetProperty("DATASTORE", username);
if u want to know how to manipluate the geometry Please post you comment.
Thank You,
Hi All,
Today we are going to tell, how to connect and retrive the shape file information through FDO using .net.
• Download the latest version of FDO providers from internet.
• Extract and copy the dll in to your local machine.
• Open the visual studio .net 2005
• Create new c# windows application project.
• Right click on the references and add the following dlls to your project from FDO Bin folder
• Create a new class say “FDOShapeFileClass”
• Below we have shown the code connect and read the shape file geometry
public class FDOShapeFileClass:IDisposable
{
private IProviderRegistry FDORegistry = FeatureAccessManager.GetProviderRegistry();
private IConnectionManager FDOManager = FeatureAccessManager.GetConnectionManager();
private IConnection FDOConnection = FeatureAccessManager.GetConnectionManager().CreateConnection("OSGeo.SHP.3.3"); // Replace the version of DLL your using…
public string OpenedFile;
public ConnectionState Constate;
public FDOShapeFileClass(string _ShapeFile)
{
OpenedFile = _ShapeFile;
FDOConnection.ConnectionInfo.ConnectionProperties.SetProperty("DefaultFileLocation", _ShapeFile);
Constate = FDOConnection.Open();
}
// To check the connection state of the Shape file…
public ConnectionState CheckConnected
{
get
{
return Constate;
}
}
// By using below function we can retrive the all geometry in the shape file at once..
// this function will return the Geomtrycollection… of the shape file.
public GeometryCollection SelectAllQuery()
{
ISelect sel = (ISelect)FDOConnection.CreateCommand(OSGeo.FDO.Commands.CommandType.CommandType_Select);
sel.SetFeatureClassName(System.IO.Path.GetFileNameWithoutExtension(OpenedFile));
IFeatureReader FDOReader = sel.Execute();
GeometryCollection Geo_Collection = new GeometryCollection();
FgfGeometryFactory GeoFac = new FgfGeometryFactory();
while (FDOReader.ReadNext())
{
Byte[] Tmppts = FDOReader.GetGeometry("Geometry");
IGeometry Geo = GeoFac.CreateGeometryFromFgf(Tmppts);
Geo_Collection.Add((IGeometry)Geo);
}
return Geo_Collection;
}
// By using this function we can the extents of shape file in the form of ipolygon.
public IPolygon GetExtents()
{
IPolygon retpolygon;
ISelectAggregates pselagree = (ISelectAggregates)FDOConnection.CreateCommand(CommandType.CommandType_SelectAggregates);
pselagree.SetFeatureClassName(System.IO.Path.GetFileNameWithoutExtension(OpenedFile));
IdentifierCollection props = pselagree.PropertyNames;
Expression exp = Expression.Parse("SpatialExtents(Geometry)");
ComputedIdentifier se = new ComputedIdentifier("Extents", exp);
props.Add(se);
IDataReader FDOReader = pselagree.Execute();
FgfGeometryFactory GeoFac = new FgfGeometryFactory();
FDOReader.ReadNext();
Byte[] Tmppts = FDOReader.GetGeometry("Extents");
IGeometry Geo = GeoFac.CreateGeometryFromFgf(Tmppts);
retpolygon = (IPolygon)Geo;
return retpolygon;
}
// we will give this function in the next post…
public void UpdateQuery()
{
throw new System.NotImplementedException();
}
public void DeleteQuery()
{
throw new System.NotImplementedException();
}
public void Dispose()
{
Close();
FDORegistry.Dispose();
FDOManager.Dispose();
FDOConnection.Dispose();
}
private void Close()
{
FDOConnection.Close();
}
• Based on your feedback in the next post we will tell you how to use this retrived geometry in to your application.
Thank You,
create table Landsat7 (id number,name varchar2(45),georaster sdo_georaster);
CREATE TABLE Landsat7_RDT OF SDO_RASTER (PRIMARY KEY(RASTERID, PYRAMIDLEVEL, BANDBLOCKNUMBER,ROWBLOCKNUMBER, COLUMNBLOCKNUMBER))LOB(RASTERBLOCK) STORE AS (NOCACHE NOLOGGING);· execute CREATEDMLTRIGGER on table Landsat7o EXECUTE SDO_GEOR_UTL.CREATEDMLTRIGGER('Landsat7','GEORASTER');
call dbms_java.grant_permission('MDSYS','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tif', 'read' );o call dbms_java.grant_permission('GEOSPATIAL','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tif', 'read' );o call dbms_java.grant_permission('PUBLIC','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tif', 'read' );o call dbms_java.grant_permission('MDSYS','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tfw', 'read' );o call dbms_java.grant_permission('GEOSPATIAL','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tfw', 'read' );o call dbms_java.grant_permission('PUBLIC','SYS:java.io.FilePermission', 'C:\oracle\raster\georaster_table.tfw', 'read' );
INSERT INTO Landsat7 VALUES(1,'p174r037',SDO_GEOR.INIT('Landsat7_RDT'));·
Declare
geo SDO_GEORASTER;
BEGINSELECT GEORASTER INTO geo FROM Landsat7 WHERE ID=1 FOR UPDATE;SDO_GEOR.IMPORTFROM(geo,'blocksize=(512,512)','TIFF','file','C:\oracle\raster\georaster_table.tif','WORLDFILE','file','C:\oracle\raster\georaster_table.tfw');UPDATE Landsat7 SET GEORASTER = geo WHERE ID=1;END;/
DECLARE
geo sdo_georaster;
BEGIN
SELECT georaster INTO geo FROM Landsat7 WHERE id=1 FOR UPDATE;sdo_geor.setModelSRID(geo, 32636);UPDATE Landsat7 SET georaster = geo WHERE id=1;
END;
UPDATE Landsat7 cSET c.georaster.spatialExtent = sdo_geor.generateSpatialExtent(georaster)WHERE c.id = 1;COMMIT;
DECLARE
geo sdo_georaster;
BEGIN
SELECT georaster INTO geo from landsat7 where id = 1 FOR UPDATE;sdo_geor.generatePyramid(geo, 'rLevel=5, resampling=NN');UPDATE landsat7 SET georaster = geo where id = 1;
COMMIT;
END;
select count(*) from Landsat7;
select count(*) from Landsat7_RDT;
set long 10000;
select a.georaster.metadata from Landsat7 a;
SELECT t.id, sdo_geor.validategeoraster(t.georaster) isvalid from Landsat7 t order by id;
