GIS Database schema

960
2
10-26-2016 09:47 AM
Highlighted
New Contributor II

Please dears i am Senior GIS engineer and joined for project to establish GIS database schema for ministry of housing for different countries could any one help me and share with me what the role and standard to create GIS database schema ?

Reply
0 Kudos
2 Replies
Highlighted
New Contributor II

Hi Ahmed,

I understand that you are having questions in creating an enterprise geodatabase,

Here is the web link talking about the compatibility of ArcGIS with different RDBMS,


'Microsoft SQL Server database requirements for ArcGIS 10.3.x'
http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/database-requirements-sqlser... 

'Oracle database requirements for ArcGIS 10.3.x'
http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/database-requirements-oracle.htm

'PostgreSQL database requirements for ArcGIS 10.3.x'
http://desktop.arcgis.com/en/arcmap/10.3/get-started/system-requirements/database-requirements-postg...

Here is the web link talking about the privileges of different users with different RDBMS,

'Privileges for geodatabases in SQL Server'
http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/privileges-sqlserver.htm

'Privileges for geodatabases in Oracle'
http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/privileges-oracle.htm

For creating an enterprise geodatabase you need to follow the steps mentioned in the following web link,

'Create Enterprise Geodatabase'
http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/create-enterprise-geodatabase...

Hope this helps!

Thanks,
Rohit

Reply
0 Kudos
Highlighted
MVP Regular Contributor

The Office of Policy Development and Research (PD&R) U.S. Department of Housing and Urban Development has a page with eGIS API and Metadata Documentation that some field names and descriptions of their data. Maybe some of it will be applicable to the housing data you're working with.

eGIS Docs Page | HUD USER 

Reply
0 Kudos