private static void ReadAdmin2000(GeodatabaseNet gdbnet) { Console.WriteLine("Opening Admin2000 table."); TableNet table = gdbnet.OpenTable("\\Admin2000"); Console.WriteLine("Executing table search."); EnumRowsNet queryRows = table.Search("*", "", true); Console.WriteLine("Enumerating polygon results (first 10 results only)..."); int i = 0; RowNet row; MultiPartShapeBufferNet mpsb; PointNet[] pts; EnvelopeNet extent; while ((row = queryRows.Next()) != null && i++ < 10) { mpsb = (MultiPartShapeBufferNet)row.GetGeometry(); mpsb.GetPoints(out pts); extent = mpsb.GetExtent(); Console.WriteLine(String.Format("Polygon extent: {0}, {1}, {2}, {3}", extent.XMin, extent.YMin, extent.XMax, extent.YMax)); Console.WriteLine(String.Format("Number of Parts: {0} Number of Points: {1}", mpsb.GetNumParts(), mpsb.GetNumPoints())); } Console.WriteLine("Closing enumerator."); queryRows.Close(); Console.WriteLine("Closing Admin2000 Table"); gdbnet.CloseTable(table); }
private static void ReadCities(GeodatabaseNet gdbnet) { Console.WriteLine("Opening Cities table"); TableNet table = gdbnet.OpenTable("\\Cities"); Console.WriteLine("Executing table search."); EnumRowsNet queryRows = table.Search("*", "", true); RowNet row; PointShapeBufferNet psb; Console.WriteLine("Enumerating point results (first 10 results only)..."); int i = 0; PointNet[] pts; while ((row = queryRows.Next()) != null && i++ < 10) { psb = (PointShapeBufferNet)row.GetGeometry(); psb.GetPoints(out pts); Console.WriteLine(String.Format("X: {0} Y: {1}", pts[0].x, pts[0].y)); } Console.WriteLine("Closing enumerator."); queryRows.Close(); Console.WriteLine("Closing Cities Table"); gdbnet.CloseTable(table); }
public static void Run() { string gdbpath = "data\\ExecuteSQL.gdb"; Console.WriteLine(); Console.WriteLine("***** Running Table Schema Info Test *****"); try { GeodatabaseNet gdbnet = new GeodatabaseNet(); Console.WriteLine("Opening database"); gdbnet.OpenGeodatabase(gdbpath); Console.WriteLine("Opening table"); TableNet table = gdbnet.OpenTable("\\Cities"); Console.WriteLine("Getting Table Definition"); string tableDef = table.GetDefinition(); Console.WriteLine("Getting table docutmentation"); string tableDoc = table.GetDocumentation(); Console.WriteLine("Setting table documentation"); table.SetDocumentation(tableDoc); Console.WriteLine("Closing table"); gdbnet.CloseTable(table); Console.WriteLine("Closing Geodatabase"); gdbnet.CloseGeodatabase(); Console.WriteLine("***** Finished Table Schema Info Test *****"); } catch (FGDBException exc) { Console.WriteLine("Exception caught while running test."); Console.WriteLine("Code: " + exc.ErrorCode); Console.WriteLine("Message: " + exc); Console.WriteLine("Description: " + exc.ErrorDescription); } }
public static void Run() { string gdbpath = "data\\Editing.gdb"; Console.WriteLine(); Console.WriteLine("***** Running Editing Test *****"); try { Console.WriteLine("Opening Geodatabase..."); GeodatabaseNet gdbnet = new GeodatabaseNet(); gdbnet.OpenGeodatabase(gdbpath); Console.WriteLine("Opening table"); TableNet table = gdbnet.OpenTable("\\Cities"); Console.WriteLine("Getting IsEditable property for the table"); bool isEditable = table.IsEditable(); if (!isEditable) { Console.WriteLine("Cities table is not editable, exiting..."); return; } Console.WriteLine("Getting table row count."); int rowCount = table.GetRowCount(); Console.WriteLine("Table has " + rowCount + " rows"); Console.WriteLine("Getting table extent."); EnvelopeNet extent = table.GetExtent(); Console.WriteLine(String.Format("Table Extent: {0}, {1}, {2}, {3}", extent.XMin, extent.YMin, extent.XMax, extent.YMax)); Console.WriteLine("Query table for AREANAME='Apple Valley' records"); EnumRowsNet avQueryResult = table.Search("*", "AREANAME = 'Apple Valley'", false); Console.WriteLine("Getting the first row from the result"); RowNet avRow = avQueryResult.Next(); if (avRow == null) { Console.WriteLine("Error - Query completed successfully but no rows were returned."); return; } Console.WriteLine("Setting CLASS attribute to 'city'"); avRow.SetString("CLASS", "city"); Console.WriteLine("Updating table to persist the edit."); table.Update(avRow); Console.WriteLine("Closing enumerator"); avQueryResult.Close(); Console.WriteLine("Performing a spatial query"); EnvelopeNet envelope = new EnvelopeNet(-117.4, -116.8, 33.64, 33.86); EnumRowsNet deleteRows = table.Search("*", "", envelope, false); Console.WriteLine("Enumerating spatial query result"); RowNet deleteRow; string areaName; bool isNull; while ((deleteRow = deleteRows.Next()) != null) { Console.WriteLine("Getting string and isnull properties for current row"); areaName = deleteRow.GetString("AREANAME"); isNull = deleteRow.IsNull("ELEVATION"); if (isNull) { Console.WriteLine("ELEVATION attribute is null, deleting row"); table.Delete(deleteRow); } } Console.WriteLine("Closing enumerator"); deleteRows.Close(); Console.WriteLine("Closing table"); gdbnet.CloseTable(table); Console.WriteLine("Closing Geodatabase"); gdbnet.CloseGeodatabase(); Console.WriteLine("***** Finished Running Geodatabase Management Test *****"); } catch (FGDBException exc) { Console.WriteLine("Exception caught while running test."); Console.WriteLine("Code: " + exc.ErrorCode); Console.WriteLine("Message: " + exc); Console.WriteLine("Description: " + exc.ErrorDescription); } }