Tag Info

Hot answers tagged

3

With the new "Processing" tools available in QGIS 2, this becomes a bit easier. While I have still not found a way to "live-link" the data (so that if you change the values in the MS Access table, the point moves automatically), this method seems to work pretty well. Credit goes to "Christina" and "Bernd" in the comments section of this page (and of course ...


2

Within a QGIS project, you can add layers from as many SQLite and spatialite databases as you want. Keeping the folder paths relative, it should be easy to exchange database and project files with other people working with it. It should be no problem to replace one database with an updated one (of the same name and data structure), and work on with the ...


2

Sorry, Eva, but that is not possible in a easy way: gvSIG is a desktop software, so it has no webs service to share your project or views. On the other hand, I can advise you some solutions depending on what you really need: Static information: Export your views as image or PDF. Share a layer: You can export your layer as KML and load it in google Maps or ...


2

I think a less intrusive method is to convert your queries into make table queries which could write the output back into the Access database or maybe another. Your MXD could then connect to these tables using OLE. If you needed to do some extra processing may be wrap them up in a macro? If you wrap up your processing steps in a macro then the macro can be ...


2

You should be able to use the Copy Features Tool on the layer with your selection, as long as the out_feature_class parameter is set to the path on disk of where you want the shapefile to be written out it should just work.


2

I recommend you research Microsoft Sql Server Express because it supports Spatial data as a native datatype. ArcGIS supports read/write to Sql Server Express. You have the full power of T-SQL at your disposal, allowing you to mix and match Attribute queries with Spatial queries, join tables, create views, index data, backup data. The scripting in Sql Server ...


2

Walter: the HUD data uses ID's for the blockgroups (BLKGRP) with single quotes around them... the TIGER blockgroup ID's (GEOID) do not have single quotes: I would say that you should create a new column using Excel / Open Office to truncate the first and last values from the field into the new column...but I can't remember how to do that right now!!! ...


1

You could accomplish most of these using Google Fusion Tables. Put together a list of facilities (company owned, company leased, government leased) on a map. Create a Fusion Table which lists those attributes, plus the address or lat/long of each facility Develop a system that can be easily updated by non-GIS users. Fusion Tables is a bit like Excel, ...


1

FME's MDB Reader is only a reader for pure tabular data (without geometry). It interpretes the shape column as some kind of binary data, but doesn't know that it contains geometry actually. Therefore the content then neither doesn't fit into the datatype FME initially uses for that nor does it know how to store any geometry into the SDE layer (again, ...


1

The tables are not being read because the user permissions (I believe for Admin) were not turned on inside the MS-Access DB. I turned them on for all the tables and QGIS loaded the tables (albeit somewhat slowly).


1

It is possible in Access, but I'll echo blah238, if you can use any other real RDBMS, then do so... If not: First be sure that you are starting with an actual Personal Geodatabase (i.e. one that was created in ArcGIS/Catalog). Create your query. Be sure to include both OBJECTID and Shape in addition to any other fields you need. Also, only include a ...


1

I use often this GDAL/OGR VRT format with SQLite files: <OGRVRTDataSource> <OGRVRTLayer name="test"> <SrcDataSource>path/testwkt.sqlite</SrcDataSource> <SrcLayer>geom</SrcLayer> <GeometryType>wkbPolygon</GeometryType> <LayerSRS>EPSG:31370</LayerSRS> ...


1

Good question, that would be very handy in lots of datasources. You can try VRT GDAL format in first approach, which allow you to generate 'fake' spatial datasources on the fly, using WKT or XY fields. One problem remains, reading MS Access or Excel efficiently..


1

There is a Knowledge Base Article available called HowTo: Connect to Microsoft Access 2007/2010 (ACCDB) files in ArcGIS which says: The proper way of connecting to Microsoft Access databases, either the MDB or ACCDB formats, is through an OLEDB connection. Though it is technically possible to connect to MDB files through the Add Data dialog box in ...


1

I have found that in addition to kreike's answer about installing the 32-bit driver in the proper place, I also needed to be using the 32-bit version of QGIS. The 64-bit QGIS doesn't seem to 'talk' to the 32-bit driver correctly (or it may not realize it's been placed in the SysWoWfolder).


1

You're adding a layer "FC" to your map which should be "FL" or "LAN". Either the feature layer or the layer should work. Be aware that the map may be in data view instead of layout view in which case pMxDoc.PageLayout is incorrect... I can't tell what pLayout is as it's not defined in the code block. It would be safer to use IMXDocument.FocusMap as this ...



Only top voted, non community-wiki answers of a minimum length are eligible