Tag Info

New answers tagged

2

According to this answer, there is an ole Db provider for accdb files. Once you have the driver installed, you should be able set up an ole DB connection in Arcmap. You should then be able to drag and drop a table from the .accdb file into the TOC, and set up a join to it like you would any other table.


1

It worked I guess the problem was in the "degree" symbol which i replaced with "~" in the excel sheet and also in the vba code and bang !!! It worked !!! reference: https://www.youtube.com/watch?v=0QxxuSIFdFU


4

Are the longitude and latitude values in separate fields? Because the Convert_Decimal function requires a single value. After trying this myself, I think you were trying to convert the DMS values to DD in-place. That is, in the same column. Instead, use the script in a new column, referring to the one you want to convert. See image below where I have a DMS ...


1

I don't know what the magic in table2 is all about. However, your x looks like '2008-11-04' and y looks like '2012-11-06'. If your dates have a time component in them, then you may be failing to match on date i.e. 2011-11-06 may have a time value of 00:00:00 or midnight while the dates in your table have 2011-11-06 16:35:33. Those two dates are not equal. ...


2

I'm assuming the ID field is what uniquely identifies the person. BTW, really bad to use * especially since Table1 and TAble2 have at least ID in common. SELECT Table1.* FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID WHERE Table1.Date = '2008-11-04' AND NOT EXISTS ( SELECT Y.ID FROM Table1 As Y WHERE Y.ID = Table1.ID ...


0

I am trying to create search functionality on move map according to center point of map want to get result. you can see example like www.airbnb.com Please do need full for me .


4

After the suggestions of user30184, Paul Ramsey and my own experiments. I decided to answer this question. I failed to mention in this question that I am importing data to a remote server. (although it is described in the blog post I refer to). Operations such as inserts, over the internet are subject to a network latency. Perhaps it is not irrelevant to ...


9

I made a test for you: PostgreSQL 9.3 PostGIS 2.1 Windows 7 i7 3770@3.4 GHz processor GDAL 2.0-dev 64-bit shapefile of 1.14 million polygons, file size 748 MB Ogr2ogr command: ogr2ogr -f PostgreSQL PG:"dbname='databasename' host='addr' port='5432' user='x' password='y'" test.shp --config PG_USE_COPY YES -nlt MULTIPOLYGON Total time:1 minute ...


2

You could use an OGR Virtual Format. This link has a section called "Reading CSV containing spatial information" which shows how to create a VRT file that reads a CSV file with a lat/lon column. This example is a basic template but could be manipulated to suit your case. Basically you copy the code below into a text file and save it with a file extension ...


0

Have you tried Geonames? They keep a global database of POIs. I took a quick glance at it and was able to download the most recent dump as a .txt and then opened in QGIS as a tab delineated file. Be patient as it is a large file (1.06 gigs) and will take some time to render. As far as I can tell I cannot find a popularity index associated with the data ...


-1

You can use Spatial Manager Desktop to import OSM data into PostGIS. Please, watch this post: http://www.spatialmanager.com/import-directly-postgis-databases/ There is a limited trial version ,you can download it here: http://www.spatialmanager.com/downloads/ If you need help on this feel free to tell me. Disclaimer: I work for Opencartis (Spatial Manager ...



Top 50 recent answers are included