Tag Info

New answers tagged

1

There isn't really a "best practice" for SSDM but using the data dictionary in conjunction with populating the data model is a huge help. The "best practice" is to reference the associated data dictionary (the OGP model has one) with what attribute should be used in each field. Additionally, look at the geometry of each feature class to determine if you ...


0

Path should be due to the ../ in the path name "C:/Program Files/Boundless/OpenGeo/pgsql/lib/" But as stated in your first question, create a copy of the "data" dir of PostgreSQL. Then undo the tutorial you followed, by deleting the files you added to PostgreSQL, then restart postgresql and try again. If this does not work, then you might be best of ...


0

I look at this question as a workflow question. I've been working on a problem. It is easy to just use the qgis database manager and plug a query in to generate some spatial data. The problem is that I was working with an unsaved test project and all my stored queries in the project disappeared when I managed to lock up qgis. So what if I store the query ...


2

Yes it can be done with QGis. Using the QSpatiaLite Plugin "Manage your SpatiaLite databases within QGis" After installing the plugin you can run it. You will receive a series of messages/errors stating that you do not have a spatialite db. it will step you through getting one installed (choose a location for the file) and finally converting it to ...


0

I don't know of a way to express this in an SQL-style query within ArcGIS. Aside from the distance matrix, a brute-force approach would be to loop through each pharmacy, perform a select-by-location for hospitals within the search tolerance, and add a flag to the pharmacy and/or hospital(s) if any hospitals are found.


0

You have create a computed column in your database. This also means that it's up to the database to actually calculate the value in this column. As a result, you'll only see an updated value when the record has been recalculated by the database. Changing part of the record within your GIS might not tricker the database to recalculate the value. If you were ...


0

The method I ended up using was to create a fishnet grid in my area of interest with a high enough "resolution" to style and reflect the data to reasonable degree. You can read about the fishnet function here: How to create a regular polygon grid in PostGIS? CREATE TABLE fishnet AS SELECT * FROM ST_CreateFishnet(800,850,.0005,.0005,-104.9190,38.7588); ...


4

You can do this all in one step by chaining the CTEs together, but I did it in several so I could look at the results in QGIS as I progressed. First, generate a bunch of random points to work with, using a gaussian distribution so we get more overlap in the middle. create table pts as with rands as ( select generate_series as id, random() as ...


1

Here are two options: Use Make XY Event Layer to create temp points from excel (based on x/y columns) Merge or Append (database schema has to be the same for append option) event layer to destination shapefile OR Use Table to Table to convert excel to .dbf or feature class table Use search cursor to get x/y coordinates and attributes from table, and ...


-1

I know that you're looking for an answer that uses ArcGIS but if you're willing to use QGIS instead, then here is a pluggin called mmqgis. This plugin simply join a shapefile with an excel database.


2

ST_Distance (folowing the documentation) - For geometry type Returns the 2-dimensional cartesian minimum distance (based on spatial ref) between two geometries in projected units. For geography type defaults to return spheroidal minimum distance between two geographies in meters. So - if you'll feed it with geometry,4326 you'll get distance in units of 4326 ...



Top 50 recent answers are included