Pro 3.x Database Guide Books for Mapping & Charting

523
0
06-24-2022 04:58 PM
MarceloMarques
Esri Regular Contributor
1 0 523

Intended for database administrators as recommendations for establishing the production database in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).

Production Mapping, Defense Mapping, Data Reviewer, Workflow Manager, Maritime, Aviation, Roads and Highways, Pipeline Referencing, Indoors

Create a geodatabase for each software product workspace.

 pm - production database 
Production Mapping & Defense Mapping - Topographic Mapping - MGCP, TDS, etc.
your gis data - create separate geodatabase for each
cartographic scale e.g. pm50 (1:50k); pm250 (1:250k)

 rev - data reviewer workspace - Data Reviewer
 wmx - workflow manager workspace - Workflow Manager
 mar1 - maritime charting database - Nautical
your gis data - create separate geodatabase for each
cartographic scale e.g. mar500k (1:500,000); mar1m (1:1,000,000)
mar2 - bathymetric database
- Nautical
 aero1 - aeronautical charting database
- Aviation
your gis data - create separate geodatabase for each
cartographic scale e.g. aero500k (1:500,000); aero1m (1:1,000,000)
 aero2 - airports database - Aviation
 lr - linear referencing database
- Roads & Highways / Pipeline Referencing
 ind - indoors database
- Indoors

Guide Books ArcGIS Pro

The guide books are intended for database administrators to help establish the product workspaces in an Enterprise Geodatabase.

ArcGIS Pro 3.x - June/23/2022
   
    Production Mapping & Defense Mapping - Topographic Mapping
Production Database
         Best Practices Production Mapping 3.x Workspace in Oracle® June/23/2022 New
         Best Practices Production Mapping 3.x Workspace in SQL Server® June/23/2022 New
         Best Practices Production Mapping 3.x Workspace in PostgreSQL® June/23/2022 New

    Data Reviewer
      Best Practices Data Reviewer 3.x Workspace in Oracle® June/23/2022 New
      Best Practices Data Reviewer 3.x Workspace in SQL Server® June/23/2022 New
      Best Practices Data Reviewer 3.x Workspace in PostgreSQL® June/23/2022 New

    Workflow Manager
      Best Practices Workflow Manager 3.x Workspace in Oracle® June/23/2022 New
      Best Practices Workflow Manager 3.x Workspace in SQL Server® June/23/2022 New
      Best Practices Workflow Manager 3.x Workspace in PostgreSQL® June/23/2022 New

Aviation - Charting / Airports
Best Practices Aviation 3.x Workspace in Oracle® June/23/2022 New
Best Practices Aviation 3.x Workspace in SQL Server® June/23/2022 New
Best Practices Aviation 3.x Workspace in PostgreSQL® June/23/2022 New

Maritime - Charting
Best Practices Maritime Charting 3.x Workspace in Oracle® June/23/2022 New
Best Practices Maritime Charting 3.x Workspace in SQL Server® June/23/2022 New
Best Practices Maritime Charting 3.x Workspace in PostgreSQL® Coming at Pro 3.1

Maritime - Bathymetric - Coming at Pro 3.1 ...
Best Practices Maritime Bathymetric 3.x Workspace in Oracle®
Best Practices Maritime Bathymetric 3.x Workspace in SQL Server®
Best Practices Maritime Bathymetric 3.x Workspace in PostgreSQL®

Linear Referencing - Roads & Highways / Pipeline Referencing
Best Practices LR 3.x Workspace in Oracle® June/23/2022 New
Best Practices LR 3.x Workspace in SQL Server® June/23/2022 New
Best Practices LR 3.x Workspace in PostgreSQL® June/23/2022 New

Indoors
Best Practices Indoors 3.x Workspace in Oracle® June/23/2022 New
Best Practices Indoors 3.x Workspace in SQL Server® June/23/2022 New
Best Practices Indoors 3.x Workspace in PostgreSQL® June/23/2022 New

For more best practices such as database connectionsdatabase template scripts and more then go to Mapping & Charting Solutions (MCS) Enterprise Databases Best Practices

About the Author
| Marcelo Marques | Principal Product Engineer | Esri | Cloud & Database Administrator | OCP - Oracle Certified Professional | 30 years experience | www.linkedin.com/in/mmarquesbr | I have worked with Esri Technology since 1992 and I have been working with Enterprise Geodatabases since 1997 when the Geodatabase was first released. | " a successful Enterprise ArcGIS application deployment starts with a strong physical database design and best database administration practices" | " I do not fear computers. I fear the lack of them." - Isaac Asimov |