Thank you for your recommendations, Saber. Yes, indexing is important
and metadata is even more so.
Cheers
Hernán
On 2019-11-20 12:13, Saber Razmjooei wrote:
Some other things to consider:
- Indexing (especially spatial indexing) your vectors.
- Meta-data: trying to capture meta-data as you go. There are some
plugins available (Layer Metadata Search: which both captures and
allows you to search for your meta-data...happy to help with the set
up if you need assistance).
Hope that helps.
Regards
Saber
On Wed, 20 Nov 2019 at 11:08, Hernán De Angelis <[email protected]
<mailto:[email protected]>> wrote:
Hello Andreas
Thank you very much for your comment. These are definitely things
I did not think about.
Our people are in two separate buildings (in two separate
regions!) but our systems can handle this without problems.
The editing conflicts seem more serious to me. I guess these could
be minimized by encouraging users to save edits more often but, as
you write, a proper solution may require proper versioning. But
then that may likely push up the costs.
Good material for thought and a test.
Thank you again!
Hernán
On 2019-11-20 11:40, Andreas Neumann wrote:
Are those 15 people in the same office/same location or
distributed? If the latter, at how many places are they distributed?
In my experience, using Postgis sources over the internet (not in
the LAN) is way too slow. It will only upset your users. In such
a scenario you would have to set up replication.
Another aspect: avoid editing the same features simultaneously by
different users. Only the last save will stay. QGIS starts an
edit session and will only save at the end of the sesssion, when
you actually save the features. In such a scenario you should
assign certain geographic areas to different users (e.g. user A
edits features in municipality x, and user b in municipality y,
but not x).
Otherwise you will have to deal with handling conflicts. That
would require more complicated table setups with versioning and
conflict detection.
Andreas
On 2019-11-20 11:32, Hernán De Angelis wrote:
I am evaluating setting up a server running PostgreSQL/PostGIS for use
as data sharing/collaborating environment for spatial data. The user
group may consist of up to 15 people, mostly using QGIS but one or two
may use other software (non OS). Data is almost exclusively of vector
type. The use is within a single organization.
I understand some people in this list have experience with this kind of
environment and would appreciate if any of you would share any useful
experience, challenges, thought or things to watch out for. I understand
basic management routines are critical (user management, user rights),
as well as a sound backup and update strategy. I also understand that
proper data management procedures have to be in place, like rules for
table creation and eventual deletion, attribute selection, etc. But what
else can go wrong with this kind of setup if not managed properly?
Thoughts and experiences welcome!
in our experience the solution is pretty straightforward. The only other
challenge I'd add is having good bandwidth, otherwise using PostGIS data
can be sluggish.
All the best.
Excellent point, Paolo! I had not thought about it. Thank you!
All the best
_______________________________________________
Qgis-user mailing list
[email protected] <mailto:[email protected]>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected] <mailto:[email protected]>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
Saber Razmjooei
www.lutraconsulting.co.uk <http://www.lutraconsulting.co.uk>
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
