Tag Info

New answers tagged

3

Postgis is an extension to Postgres, rather than a stand alone application, that provides a spatial data type to Postgres, and provides numerous spatial functions that operate on geometry(ies). Spatial indexing, which you will surely need to find n closest points efficiently, is implemented as an extended R-tree, but the indexing mechanism comes from ...


3

Use featureMerger , joining and grouping by the common fields from DATABASE AND INPUT DATA.


2

If you have the database characteristics indicated by the diagram. Small input, tiny overlap, large target. Then the following sort of workspace may work quite efficiently, even though it will be doing multiple queries against the database. So for each feature read from the input query for the matching feature in the database. Make sure there is ...


0

There may be some pieces missing in your question; it may be helpful to be more precise. Right now, if you have 4 files of data with one column in each, how do you know they match each other? What is the (primary) key to each of these? You could create a new table based on joins between existing tables. Also you have a column for coordinates as well as ...


3

I didn't use FME, but I had a similar processing task that required using the output of a 5-hour processing job to identify three possible processing cases for a parallel database across a low-bandwidth network link: New features to be added Existing features to be updated Exisitng features to be deleted Since I did have a guarantee that all features ...


1

You should add a PostGIS extension, and use the geometry type instead. It will handle 30000 features easily, and work with many GIS systems (e.g. QGIS). You can always extract the WKT equivalent from a geometry column using ST_AsText. Here's an example workflow, assuming it's a table in postgres --Say you have a table described in your question CREATE TEMP ...


2

Changing text fields length needs an exclusive schema lock on the dataset. Exclusive schema locks—In contrast to shared schema locks, exclusive schema locks are controlled by the developer or ArcGIS application, such as ArcMap or ArcCatalog. An exclusive lock is used to lock a geodatabase dataset or object from use by others to make the necessary ...


0

If I am understanding your question correctly, I would recommend creating a point feature class using the begin and end point coordinates of each pipe, and then constructing a line from those points. You should then be able to use your line to create a route if you wish. As a side note: The Create Routes tool only prepares an already created line for use ...


1

In QGIS it is worth to say that it is not possible to change field width (if we are talking about shapefiles) for existing columns. But it is really easy to create new column with needed length and copy content into that column from the old one. You can do that with Field calculator. For renaming / reordering / adding multiple fields etc. there is great ...


0

Interestingly enough, when we created a new enterprise geodatabase in arccatalog and mapped each active directory user to this database in sql server, myuser was able to add a connection to both the new database and the original database in arccatalog. This has solved the problem, however the root of the initial problem still remains a mystery !


0

CartoDB doesn't allow by default direct connections to the user databases to external databases. If you're not an enterprise customer, perhaps the Foreign Data Wrappers that CartoDB offers, as said in the comment, are not interesting to you. The best approach would be connecting your database with the CartoDB SQL API so that you're able to maintain both ...


1

Try this: http://download.geonames.org/export/zip/ It is licensed under a Creative Commons Attribution 3.0 License. They even have zip codes of various other countries around the world.



Top 50 recent answers are included