Questions tagged [maintenance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Enterprise geodatabase maintenance Esri vs. SQL Server (rebuild index and update statistics)

I'm looking at two geodatabase maintenance practices and seeing if they need to be updated/refined, and I'm noticing that these can be accomplished via ESRI tools or directly via SQL / within SQL ...
0 votes
1 answer
162 views

Example of QGIS for landscape management and maintenance plans?

I'm writing about landscape management and maintenance plans, and that most of them are in a Word file with perhaps a table of tasks, as opposed to a smart document such as a QGIS file with a linked ...
0 votes
0 answers
134 views

Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?

According to the ESRI documentation, the Rebuild Indexes tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In ...
  • 5,747
2 votes
0 answers
40 views

Is there an equivalent "why-upgrade PostgreSQL" tool for PostGIS?

I rarely keep up with the PostgreSQL and PostGIS releases and it can a challenge deciding on when to do so for the major/minor releases. The why-upgrade site (http://why-upgrade.depesz.com/show?from=...
  • 14.5k
5 votes
1 answer
995 views

How to create a restorable PostGIS/PostgreSQL database backup with pg_dump?

I am unable to restore a database backup when the database contains schema's that contain geometry datatypes or postgis functions. During restore, I get the spatial_ref_sys relation not found error. ...
  • 14.5k
2 votes
1 answer
86 views

Does the version admin workflow change when all users edit the SDE.DEFAULT version?

An esri blog article (5 Best Practices SDE Maintenance) states, when discussing updating statistics for an ArcSDE, "... in situations where all users are editing just the SDE.DEFAULT version [this is ...
  • 1,481
1 vote
1 answer
192 views

Will there be a new ArcGIS API for Silverlight that will be updated for ArcGIS 10.4?

Will there be a new ArcGIS API for Silverlight that will be 100% compatible with ArcGIS Server 10.4 (I know a lot of 3.3 API works, but I also know that older APIS never completely work and have to be ...
  • 14.5k
2 votes
1 answer
96 views

Does it matter whether I use ArcCatalog or Access to compact a geodatabase?

I've been tasked with compacting some of the personal geodatabases (MDB files) in our office every few weeks. These reside on a couple of separate file servers. I have been using ArcCatalog to do ...
  • 123
2 votes
0 answers
57 views

wastewater utility web app

I'm trying to create a web-based GIS wastewater utility application integrated with with some maintenance system in the same interface so that for example any problem in the wastewater utility network ...
5 votes
1 answer
387 views

Maintaining ArcSDE for PostgreSQL database?

I'm getting familiarized with using PostgreSQL for ArcGIS. I've only ever used SQL Server. I was successful in setting up an ArcSDE database within PostgreSQL 9.2, but what maintenance should I do ...
  • 9,051
2 votes
0 answers
54 views

What resources are there for PostGIS maintenance? [duplicate]

I am recommending the usage of a Postgres+PostGIS database to a client for storage of their Geospatial Data. I need to recommend the processes for maintenance of the database. The Client is an Oracle ...