Solve the problem that the table name is underlined when geotools imports the shp file to the Oracle database,Problem:
Recently, we used geotools to import the shp file to the Oracle table. We found that the import failed when the Oracle table name was underlined. The problematic code line is dsOracle. getFeatureWriterAppend (oracleTable, Transaction. AUTO_COMMIT); dsOracle is org. geotools. data. dataStor
The development of the Vision Webgis platform is now making new progress, which enables the loading of the client SHP files without the conversion of data conversion tools on the PC. The Vision Webgis Platform (Remotegis) is a new generation of Webgis Foundation platform based on HTML5, which is developed using JavaScript with good system architecture and high scalability. is a new efficient, professional and stable GIS platform. Now developing online
In the MFC project to use the Mapwingis component, there are many ways to achieve,The first method, #Import来实现1, first register Mapwingis ActiveX components,2. Create a new single document project: MapGis, add an MFC class for the control in an ActiveX control, such as:Then select Map ControlFirst open the stdafx.h, adding:[CPP]View PlainCopy
#import "C:\MapWinGIS\MapWinGIS.ocx" Rename_namespace ("Mapwindow") Rename ("GetObject", "Gisgetobject")
"C:\MapWinGIS\MapWinGIS.ocx" for Ma
Problem:Recently in making use of Geotools to import SHP files into an Oracle table, a problem was found when an Oracle table name was underlined when the import failed, the question code line: Dsoracle.getfeaturewriterappend (oracletable,Transaction.auto_commit); Dsoracle for Org.geotools.data.DataStore type ObjectSolution:Online access to Data discovery is ORACLE11 Java package OJDBC version of the problem, maven search Ojdbc found the latest versio
clc;close all;clear;road=shaperead ('boston_roads.shp'); %read the shape file Figure,mapshow ('boston.tif'); %read the TIF remote sensing image and display axis image manual off;%close the local coordinate system Surveyfeetpermeter= Unitsratio ('SF','Meter'); %convert meter units to Surveyfeet units Colortab='rgbcymkw'; %color code table, different grades of highways show different colors forI=1: Numel (road) x= Surveyfeetpermeter * [Road (i). X]; %convert S
What formats of spatial data can be imported to postgis? There must be a lot of data. My data source is in the SHP format. After installing the postgis module, I directly choose postgis shapefile and DBF loader. If you are using other formats you can go to SHP and then export, of course you can also direct, direct export there is such a tool ogr2gui (http://sourceforge.net/projects/ogr2gui ).
Ogr2gui is a G
();Int id = enumids. Next ();While (ID! =-1) //-1 is reutned after the last valid ID has been reached{Featurepoint = pfeatureclass. getfeature (ID );Igeometry geometrygt = featurepoint. shape; // get the object in the SHP FileIpoint pointgt = geometrygt as ipoint;Gtzb gtxx = new gtzb ();Gtxx. GH = featurepoint. get_value (fieldindexgh). tostring ();Gtxx. xlmc = featurepoint. get_value (fieldindexxlmc). tostring ();Gtxx. zlmc = featurepoint. get_value
1. First, convert the SHP file into an SQL statement: (indicating the original projection of data)
Shp2pgsql-w gbk-s 4610-G _ GEO sample. SHP tb_sample> sample. SQL
2. Execute the SQL file generated in the previous step and import the data to the database:
Psql-D dbname-F sample. SQL-u Postgres
3. perform projection conversion:
-- Select * From geometry_columns; -- view the projection information recorded i
I used to find some materials and wrote an article
C # (. NET) operations on DBF (ArcGIS SHP Attribute Table)
URL: http://www.cnblogs.com/xiexiaokui/archive/2007/11/12/956984.html
However, none of the above methods succeeded, and I didn't know where the problem was.
Therefore, the previous statistics were performed using feature in ArcGIS, but the statistics on attribute data were too wasteful.
So in the afternoon, I began to look for inform
#!/usr/bin/env python#-*-Coding:utf-8-*-Import Urllib.requestImport OSdef get_epsg_code (EPSG):"""Get the ESRI formatted. PRJ definitionUsage Get_epsg_code (4326)We Use the http://spatialreference.org/ref/epsg/4326/esriwkt/"""F=urllib.request.urlopen ("http://spatialreference.org/ref/epsg/{0}/esriwkt/". Format (EPSG))Return (F.read ())# Shapefile filename must equal the new PRJ filenameShp_filename = "Utm_zone_boundaries"# path to where Shapefiles with No. prj is locatedOs.chdir (".. /geodata/")
#!/usr/bin/env python#-*-coding:utf-8-*-ImportGdalImportxlrdImportShapefiles#Open the Excel fileExcel_file = Xlrd.open_workbook (".. /geodata/highest-mountains-europe.xlsx")#get The first sheetSH =excel_file.sheet_by_index (0) W=Shapefiles. Writer (Shapefile. Point)#Fields available Geonameid Name country Latitude longitude Altitude (m)W.field ('Geonameid','F') W.field ('Name','C') W.field ('Country','C') W.field ('Latitude','F') W.field ('Longitude','F') W.field ('Altitude','F')#Loop over each
Problem:
Recently in the use of Geotools to import SHP files into an Oracle table, found an issue when an Oracle table name is underlined, the import fails, and the problem code line: Dsoracle.getfeaturewriterappend (oracletable, Transaction.auto_commit); Dsoracle as Org.geotools.data.DataStore type Object
Solution:
Online lookup is ORACLE11 Java package OJDBC version problem, maven search Ojdbc found the latest version of the following figure
P
#!/usr/bin/env python#-*-coding:utf-8-*-Importurllib.requestImportOSdefGet_epsg_code (EPSG):"""Get the ESRI formatted. PRJ definition usage get_epsg_code (4326) We use the HTTP://SPATIALREFERENCE.ORG/REF/EP sg/4326/esriwkt/"""F=urllib.request.urlopen ("http://spatialreference.org/ref/epsg/{0}/esriwkt/". Format (EPSG))return(F.read ())#Shapefile filename must equal the new PRJ filenameShp_filename ="utm_zone_boundaries"#path to where Shapefiles with No. prj is locatedOs.chdir (".. /geodata/")#Her
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.