Hot answers tagged ms-access
5
To save yourself a bit of code you could use the geoprocessor and call DataManagementTools.CopyRows. See also: How to run a geoprocessing tool
e.g.:
// Create the geoprocessor.
Geoprocessor GP = new Geoprocessor();
// Create the tool process object.
ESRI.ArcGIS.DataManagementTools.CopyRows copyrowsTool = new
...
4
You can do both, kinda. If you wanted, which would be a good thing to do, make a Personal Geodatabase (which is a MS Access DB). This will allow you to store all the spatial data and any tabular data in one DB. You will also be able to access the tables in MS Access. There are limitations, the ones imposed by MS Access; a large one being the 2GB size ...
4
If you're looking to get your data into an access database you could skip the middle conversion step entirely (or rather have ArcGIS handle it for you) by transferring your data to a personal geodatabase, which in reality is an access database.
From ArcGIS you can use the Create Personal Geodatabase tool to create the access database, and then you should be ...
4
I think you should take into account that personal geodatabase is created and accessed through ESRI clients, following proprietary patterns. MsAccess is not a spatial database on its own (it does not provide a spatial data model, so obviously no spatial data loading capabilities, spatial indexing or extended spatial SQL), so ESRI manages spatial information ...
3
Why dont you import the MS tables into a Geodatabase? Linking from a static MS database table may not produce the results you are looking for, as you will need/want to load the data (maybe multiple data layers) and open it into ArcMap. You may also what to symbolize these layers. If you are planning on viewing this in ArcMap, why not build a MXD project ...
3
If I have this correct -- biggest constraint is that you must use the local municipal data as the geocoding reference data. This wasn't clear in your original question.
I'll give you the ArcGIS answer -- since that is available to you and what I know.
You need to create a ArcGIS locator from the municipal data, i.e. the reference data. This is your ...
3
If you're interested in PostGIS, you might want to visit the BostonGIS website. They have great material to get you started. You can also start with OpenGeo's introduction to PostGIS workshop.
PostGIS has a shapefile importer that you can use to load your shape files. As for your accdb files, you might want to convert them to SQL first. Bullzip has this ...
3
Esri's online help (see two links below as examples) discourages users from opening Personal Geodatabases stored in Microsoft Access using Access so I think your phrase "futile because pgdb technology is proprietary and no detailed publicly available knowledge exists" probably sums it up.
http://support.esri.com/es/knowledgebase/techarticles/detail/31599
...
3
You should be able to use the AccessWorkspaceFactory co-class even though it's not a personal geodatabase. You could also use ADO.NET. I am not sure why your code isn't working but I do know that working with property sets is an exercise in frustration.
2
Here are my two ideas:
Most county Auditor Departments have a parcel GIS layer (that is in a mapable format). You could contact this department to see if you can obtain this layer, then do a table join based on common parcel ID field to your table.
If you database has address information you could geocode that against the U.S Census Bureau TIGER Street ...
2
There is good news and bad news:
The good news is that ArcGIS does support geodata in an as Access database, as Ryan Garnett states in his answer..
The bad news is: Although geodata is placed in Access, the structure of a geodatabase is very complex. Thus, you should not expect to be able to update data directly in Access.
Fortunately ArcGIS is packed ...
2
I do this... but its probably not the greatest approach
public bool CreateFileGDB(ref string error, string fullshapefilepath, String shapeFileDirectory, String shapeFileName, string badfields, ShapefileType shapefiletype, string Style )
{
try
{
string projectionfile = ...
1
if you use win7 64 bit:
Probably, you configure the wrong databaseinterface.
Use this file:
%systemdrive%\Windows\SysWoW64\Odbcad32.exe
to configure it.
Its not the same as you reach by mouseklicks.
if you use mysql-db with odbc: you have to install the right driver
Maybe it helps to read / gtranslate this website
greets
kreike
1
If you zoom to the extent of your xy data,
Then select the window so you only get the records you want.
(any way you can get that selection is acceptable).
Ensure that the mxd projection is set to the projection you want to output.
Then export the data from the table of contents (not the attribute table).
Make sure that you use the selected features ...
1
If you have Access 2010 you can do this:
http://www.youtube.com/watch?v=GHoy6hsAltc
If not, then perhaps one of these links may help:
https://groups.google.com/forum/?fromgroups=#!topic/microsoft.public.access/jZnlHxayF_g
http://www.utteraccess.com/forum/Call-MapQuest-access-t582734.html#Post582734&Zp=
...
Only top voted, non community-wiki answers of a minimum length are eligible
