private async Task addFeatureLayer() { await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { ArcGIS.Core.Data.DatabaseConnectionProperties connectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.PostgreSQL) { AuthenticationMode = AuthenticationMode.DBMS, Instance = @"127.0.0.1", Database = "geomapmaker", User = "******", Password = "******", //Version = "dbo.DEFAULT" }; using (Geodatabase geodatabase = new Geodatabase(connectionProperties)) { // Use the geodatabase CIMSqlQueryDataConnection sqldc = new CIMSqlQueryDataConnection() { WorkspaceConnectionString = geodatabase.GetConnectionString(), GeometryType = esriGeometryType.esriGeometryPoint, OIDFields = "OBJECTID", Srid = "4326", SqlQuery = "select * from public.features where user_id = " + DataHelper.userID + " and ST_GeometryType(geom)='ST_Point'", Dataset = "features" }; featureLayer = (FeatureLayer)LayerFactory.Instance.CreateLayer(sqldc, MapView.Active.Map, layerName: DataHelper.userName + "'s points"); } }); }
private void InitDataConnection(CIMSqlQueryDataConnection connection) { DataSetName = connection.Dataset; DataSetType = FixDatasetType(connection.DatasetType); DataSourceName = connection.Dataset; WorkspacePath = FixWorkspacePath(connection.WorkspaceConnectionString); WorkspaceProgId = connection.WorkspaceFactory.ToString(); WorkspaceType = connection.WorkspaceFactory.ToString(); DataSource = BuildFullDataSourceName(); }
private Task addFeatureLayer() { Debug.WriteLine("addFeatureLayer enter"); return(ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { ArcGIS.Core.Data.DatabaseConnectionProperties connectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.PostgreSQL) { AuthenticationMode = AuthenticationMode.DBMS, Instance = @"127.0.0.1", Database = "geomapmaker", User = "******", Password = "******", //Version = "dbo.DEFAULT" }; using (Geodatabase geodatabase = new Geodatabase(connectionProperties)) { // Use the geodatabase //CIMSqlQueryDataConnection sqldc = new CIMSqlQueryDataConnection() this.sqldc = new CIMSqlQueryDataConnection() { WorkspaceConnectionString = geodatabase.GetConnectionString(), GeometryType = esriGeometryType.esriGeometryPoint, OIDFields = "OBJECTID", Srid = "4326", SqlQuery = "select * from public.features where user_id = " + DataHelper.userID + " and ST_GeometryType(geom)='ST_Point'", Dataset = "features" }; featureLayer = (FeatureLayer)LayerFactory.Instance.CreateLayer(sqldc, MapView.Active.Map, layerName: DataHelper.userName + "'s points"); /* * string url = @"C:\Users\Douglas\Documents\testCollections\GeneWash.gdb\GeneWash.gdb\CrossSectionB\CSBMapUnitPolys"; //FeatureClass of a FileGeodatabase * * Uri uri = new Uri(url); * featureLayer = (FeatureLayer)LayerFactory.Instance.CreateLayer(uri, MapView.Active.Map); */ } })); }
private async Task openDatabase() { await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => { // Opening a Non-Versioned SQL Server instance. ArcGIS.Core.Data.DatabaseConnectionProperties connectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.PostgreSQL) { AuthenticationMode = AuthenticationMode.DBMS, // Where testMachine is the machine where the instance is running and testInstance is the name of the SqlServer instance. Instance = @"127.0.0.1", // Provided that a database called LocalGovernment has been created on the testInstance and geodatabase has been enabled on the database. Database = "geomapmaker", // Provided that a login called gdb has been created and corresponding schema has been created with the required permissions. User = "******", Password = "******", //Version = "dbo.DEFAULT" }; using (Geodatabase geodatabase = new Geodatabase(connectionProperties)) { // Use the geodatabase CIMSqlQueryDataConnection sqldc = new CIMSqlQueryDataConnection() { WorkspaceConnectionString = geodatabase.GetConnectionString(), GeometryType = esriGeometryType.esriGeometryPoint, OIDFields = "OBJECTID", Srid = "4326", SqlQuery = "select * from public.features where user_id = " + DataHelper.userID, Dataset = "features" }; FeatureLayer flyr = (FeatureLayer)LayerFactory.Instance.CreateLayer(sqldc, MapView.Active.Map, layerName: "Doug's points"); } }); }