Select to view content in your preferred language

Best Geodatabase to use for small organizations

1804
7
Jump to solution
11-16-2022 10:45 AM
YazeedAlrashdiRVCOG
Emerging Contributor

Hello, 

I am from a small organizations and I am trying to design a central database for our GIS Data for our planning department and other departments in the organization. Initially, I have created a File Geodatabase to organize the data. I am looking for ways that allow me to manage the data and maintain it in a consistent form. And manage user access to the database.

Any suggestions on how to do that, or is there other options will be better to implement? 

 

0 Kudos
2 Solutions

Accepted Solutions
MarceloMarques
Esri Regular Contributor

PostgreSQL is free and you will only need to buy the ArcGIS Server Basic License to get access to the ArcSDE Geodatabase License File to be able to create an Enterprise Geodatabase in PostgreSQL, another option is to use SQL Lite Geodatabase, but that is not scalable for enterprise use, and SQL Lite Geodatabases do not support all the Geodatabase Features, hence the suggestion is to go with PostgreSQL Geodatabase to reduce the cost. I hope this helps.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

MarceloMarques
Esri Regular Contributor

You need first get started with PostgreSQL and there are many online courses for PostgreSQL, but I recommend you attend classes from Enterprise DB.

Postgres Training Courses and Lessons by EDB. Learn online with Tutorials & Exercises [Free & Paid] ...

Next, you will need to attend Enterprise Geodatabase Classes in the order below.

for the beginner ... a jedi student ... young padawan

https://www.esri.com/training/catalog/5c9a7395190cf23eac62a998/getting-started-with-data-management/

https://www.esri.com/training/catalog/57630436851d31e02a43f19e/getting-started-with-the-geodatabase/

https://www.esri.com/training/catalog/59c407ad3049c71bb91d784f/managing-geospatial-data-in-arcgis/

https://www.esri.com/training/catalog/5b29686482573b5e7c2fd8a4/fundamentals-of-data-management/

then the real fun begins ... the advanced classes ... for a young jedi  ... these are the 3 must take courses !!!

https://www.esri.com/training/catalog/57630436851d31e02a43f104/deploying-and-maintaining-a-multiuser... 

https://www.esri.com/training/catalog/59c407ad3049c71bb91d784f/managing-geospatial-data-in-arcgis/

https://www.esri.com/training/catalog/57630435851d31e02a43ef90/distributing-data-using-geodatabase-r...

now the more advanced classes ... to become a jedi master

https://www.esri.com/training/catalog/5ba123f446fee07da2714905/working-with-utility-networks-in-arcg...

https://www.esri.com/training/catalog/603e9d5a05fbbb7aa08fe9b5/configuring-branch-versioning-in-arcg...

I hope this helps.   "May the force be with you !!!"  🙂

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

7 Replies
AnibalMmartinez
Frequent Contributor

Hola, te conviene una GeoDatabase sencilla con un SQL Server o un Oracle Server. Si o si vas a tener que tener un administrador de BD si no tienes. En el caso de que utilices SQL server es un poco mas sencilla la administración y mantenimiento ni idea los costos de licencia. Espero que te sirva, saludos.

0 Kudos
MarceloMarques
Esri Regular Contributor

You can implement an Enterprise Geodatabase in SQL Server / PostgreSQL / Oracle.
You will need RDMBS training and Enterprise Geodatabase Training to achieve that.

What is a geodatabase?—ArcGIS Pro | Documentation

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos
YazeedAlrashdiRVCOG
Emerging Contributor

Thanks for the response. The thing is Enterprise system is not an option, for the organization, because of its price, but maybe in the future when the organization grows. And that's why I went with File Geodatabase. 

Any alternatives or suggestion on how to maximize my position? 

0 Kudos
MarceloMarques
Esri Regular Contributor

PostgreSQL is free and you will only need to buy the ArcGIS Server Basic License to get access to the ArcSDE Geodatabase License File to be able to create an Enterprise Geodatabase in PostgreSQL, another option is to use SQL Lite Geodatabase, but that is not scalable for enterprise use, and SQL Lite Geodatabases do not support all the Geodatabase Features, hence the suggestion is to go with PostgreSQL Geodatabase to reduce the cost. I hope this helps.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
YazeedAlrashdiRVCOG
Emerging Contributor

This helps a lot, thanks. Is there any learning resource you can point to me that will help?  

0 Kudos
MarceloMarques
Esri Regular Contributor

You need first get started with PostgreSQL and there are many online courses for PostgreSQL, but I recommend you attend classes from Enterprise DB.

Postgres Training Courses and Lessons by EDB. Learn online with Tutorials & Exercises [Free & Paid] ...

Next, you will need to attend Enterprise Geodatabase Classes in the order below.

for the beginner ... a jedi student ... young padawan

https://www.esri.com/training/catalog/5c9a7395190cf23eac62a998/getting-started-with-data-management/

https://www.esri.com/training/catalog/57630436851d31e02a43f19e/getting-started-with-the-geodatabase/

https://www.esri.com/training/catalog/59c407ad3049c71bb91d784f/managing-geospatial-data-in-arcgis/

https://www.esri.com/training/catalog/5b29686482573b5e7c2fd8a4/fundamentals-of-data-management/

then the real fun begins ... the advanced classes ... for a young jedi  ... these are the 3 must take courses !!!

https://www.esri.com/training/catalog/57630436851d31e02a43f104/deploying-and-maintaining-a-multiuser... 

https://www.esri.com/training/catalog/59c407ad3049c71bb91d784f/managing-geospatial-data-in-arcgis/

https://www.esri.com/training/catalog/57630435851d31e02a43ef90/distributing-data-using-geodatabase-r...

now the more advanced classes ... to become a jedi master

https://www.esri.com/training/catalog/5ba123f446fee07da2714905/working-with-utility-networks-in-arcg...

https://www.esri.com/training/catalog/603e9d5a05fbbb7aa08fe9b5/configuring-branch-versioning-in-arcg...

I hope this helps.   "May the force be with you !!!"  🙂

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
VinceAngelo
Esri Esteemed Contributor

Note that, while the PostgreSQL server software is free, the hardware on which it resides (or the RDS which exposes it) is not. Nor is the labor of a professional DBA (or the training to become a defacto DBA). So just because the database is "free" in the tenets of "free software" doesn't mean it comes without cost.

- V