New answers tagged spatial-database
I would recommend that if you can process data yourself then you can go for maxmind.com free database or shell out a few bucks for a cities database from http://www.worldcitiesdatabase.com Even geonames is a good resource to look..also check for a open source cities database hosted on code.google.com
Yes to MickyT's answer - and also the DatabaseUpdater transformer might be of use. Also, there's an FME Tutorial on Spatial Databases at: http://www.safe.com/learning/training/on-demand/tutorials/ which I happen to know covers updates.
When using FME, rather than using a joiner factory open the properties of the the writer and go to the parameters tab. In there change the writer mode from INSERT to UPDATE. Then set your unique key field in the Update Key Columns field. Here's a link that may help Editing Writer Properties
This can be done with PostGIS's ST_LocateBetween function, where you can extract point and linestrings from either a single time or between a range of times. To do this, you need to have geometries with a measure dimension, that is [Multi]Point [Z]M or [Multi]LineString [Z]M geometries. A numeric timestamp (e.g. Unix time) can be used for the M-dimension. ...
For PostGIS, make sure you are following the hard upgrade procedure: pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f file.backup thedatabase This way it can be restored in the existing database, or it can be discovered with a future version of PostGIS using the postgis_restore.pl command. For Windows, you need to tailor a simple BAT file described ...
My problem was that I could not find the pg_dump command. I thought it was a subcommand of psql command. You nead to add c:\program files\postgresql\9.3\bin> to path(system variables) of windows or use its direct executable file: eport: c:\program files\postgresql\9.3\bin> pg_dump.exe -U postgres test2 >"d:\backup.sql" import: c:\program ...
The pair that you want is PG_Dump and PG_Restore... I use PG_Dump on a scheduled task to backup our PostGIS databases in a format that can be restored easily - and more importantly will work! pg_dump.exe --file=c:\Your\path\BACKUP_Name.Backup -Fc -Z9 -o DatabaseName Custom format Z9 compression (to save space) Include objectIDs and then to restore on ...
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 ...
Top 50 recent answers are included