Part 4: ArcSDE on Red Hat Linux

Continue the installation process and install the other required packages. After all the installation has been done you can now execute the sdesetup command as user to setup the SDE database template. The command is written as follows:

• sdesetup -o install -d POSTGRESQL -u user -p password -D databasename -s serveraddress -l ArcSDELicense.ecp

To start the services identified in you services.sde execute the following command as sde user:

• sdemon -o start -i servicename

Part 4: ArcSDE on Red Hat Linux

Continue the installation process and install the other required packages. After all the installation has been done you can now execute the sdesetup command as user to setup the SDE database template. The command is written as follows:

• sdesetup -o install -d POSTGRESQL -u user -p password -D databasename -s serveraddress -l ArcSDELicense.ecp

To start the services identified in you services.sde execute the following command as sde user:

• sdemon -o start -i servicename

PART 3: ArcSDE on Red Hat Linux

This post contains the continuation of the installation of ArcSDE.

Please note to edit the dbinit.sde file according to your setup. You need to set the settings in the file:

• set PGHOSTADDR = hostaddress (ex. 192.168.50.1)
• set SDE_DATABASE = databasename

PART 3: ArcSDE on Red Hat Linux

This post contains the continuation of the installation of ArcSDE.

Please note to edit the dbinit.sde file according to your setup. You need to set the settings in the file:

• set PGHOSTADDR = hostaddress (ex. 192.168.50.1)
• set SDE_DATABASE = databasename

PART 2: ArcSDE on Red Hat Linux

Follow the video for the ArcSDE installation or refer to the installation instructions from the ArcSDE CD.

PART 2: ArcSDE on Red Hat Linux

Follow the video for the ArcSDE installation or refer to the installation instructions from the ArcSDE CD.

PART 1: ArcSDE on Red Hat Linux

The next part of the tutorial will show you how to create the database for ArcSDE. The procedure is quite the same with PostGIS database but here we need to install ArcSDE to run the setup for the SDE database.

PART 1: ArcSDE on Red Hat Linux

The next part of the tutorial will show you how to create the database for ArcSDE. The procedure is quite the same with PostGIS database but here we need to install ArcSDE to run the setup for the SDE database.

PART 4: PostGIS on Red Hat Linux

Next we then edit the postgresql.conf file. Set the listener address = '*'. The next step is to create the PostGIS database, sde role, schema, and grant the permission for the user.

To create the database template for the PostGIS database, execute this following command:

• psql -d databasename -U user -c "CREATE LANGUAGE plpgsql"
• psql -d databasename -U user -f postgis/postgis.sql
• psql -d databasename -U user -f spatial_ref_sys.sql

To verify all is good, run the command bellow in the database ou just created using psql or PgAdminIII:

• SELECT postgis_full_version();

PART 4: PostGIS on Red Hat Linux

Next we then edit the postgresql.conf file. Set the listener address = '*'. The next step is to create the PostGIS database, sde role, schema, and grant the permission for the user.

To create the database template for the PostGIS database, execute this following command:

• psql -d databasename -U user -c "CREATE LANGUAGE plpgsql"
• psql -d databasename -U user -f postgis/postgis.sql
• psql -d databasename -U user -f spatial_ref_sys.sql

To verify all is good, run the command bellow in the database ou just created using psql or PgAdminIII:

• SELECT postgis_full_version();

PART 3: PostGIS on Red Hat Linux

The next step is to configure and define some variables in our PostgreSQL server. These variables will be used in creating our database to set the location for our tablespace. We also then need to configure the pg_hba.conf for client authentication. This will enable our clients to access the database. The following video will give us the illustration. 

PART 3: PostGIS on Red Hat Linux

The next step is to configure and define some variables in our PostgreSQL server. These variables will be used in creating our database to set the location for our tablespace. We also then need to configure the pg_hba.conf for client authentication. This will enable our clients to access the database. The following video will give us the illustration. 

PART 2: PostGIS on Red Hat Linux

The next video shows the installation of the following packages:

• libxml2-2.7.6
• postgis-1.5.3

To check weather the installation had some issues or have been successfully completed, run this command on root: ldd -d /usr/lib64/pgsql/postgis-1.5.3.so

The next step is to copy the st_geometry.so and libst_raster.so files from the installation folder to /usr/lib64/pgsql/data directory. these files will be used later in creating the PostGIS and the ArcSDE geodatabase.

Now we run the initdb for PostgreSQL to initialize the database server configuration. We do that by executing this command as postgres: /usr/bin/initdb –D /var/lib/pgsql/data

PART 2: PostGIS on Red Hat Linux

The next video shows the installation of the following packages:

• libxml2-2.7.6
• postgis-1.5.3

To check weather the installation had some issues or have been successfully completed, run this command on root: ldd -d /usr/lib64/pgsql/postgis-1.5.3.so

The next step is to copy the st_geometry.so and libst_raster.so files from the installation folder to /usr/lib64/pgsql/data directory. these files will be used later in creating the PostGIS and the ArcSDE geodatabase.

Now we run the initdb for PostgreSQL to initialize the database server configuration. We do that by executing this command as postgres: /usr/bin/initdb –D /var/lib/pgsql/data

PART 1: PostGIS on Red Hat Linux

The next series of post deals with the PostGIS installation. This will be used for Quantum GIS, an Open Source mapping application, to connect to our PostgreSQL database. 

The video will cover the installation of the following packages:

• GCC- C++
• configuration of ld.so.conf
• proj-4.7.1
• geos-3.3.1

PART 1: PostGIS on Red Hat Linux

The next series of post deals with the PostGIS installation. This will be used for Quantum GIS, an Open Source mapping application, to connect to our PostgreSQL database. 

The video will cover the installation of the following packages:

• GCC- C++
• configuration of ld.so.conf
• proj-4.7.1
• geos-3.3.1

PostgreSQL on Red Hat Linux

This is part of the series of Videos that we have documented in PICTU Bukidnon for the installation of PostgreSQL, PostGIS and ArcSDE.

WE WOULD LIKE TO EXTEND OUR HEARTFELT GRATITUDE TO THE MEMBERS OF THE PHILIPPINE ROAD MANAGEMENT FACILITY (PRMF) TEAM.

PostgreSQL on Red Hat Linux

This is part of the series of Videos that we have documented in PICTU Bukidnon for the installation of PostgreSQL, PostGIS and ArcSDE.

WE WOULD LIKE TO EXTEND OUR HEARTFELT GRATITUDE TO THE MEMBERS OF THE PHILIPPINE ROAD MANAGEMENT FACILITY (PRMF) TEAM.

.NET to GIS Web Application Development

Finally, after some time since my last post about my current projects in .Net to share some learning for the past 6 months. I have undergone some training for GIS Web Application Development. I apologize to those people who have been dropping down comments on the SMS application using VB.net and AT commands. The good news is that I have found some interesting resources for you to complete your project. I'll be talking about these stuff later in a series of post plus ill give you the source code for you to integrate it in you own projects.

The next series of post are video tutorials on installing GIS Server, ArcSDE and PostGIS for Linux. I'v been lucky enough to work with some specialist in GIS and Oracle Database to complete this task. At first we were really having a hard time dealing with the setup. The common installation for ArcGIS Server is with the .Net platform running in Microsoft Server and other windows environment. Now we have faced a new challenge which is to install the GIS Server using the Java platform for Linux. I hope this series of post will show you some insights and help you along the way if your planning to go with opensource server application and GIS. 

Bellow is a web application we have developed. This application was a test web application showing that the ArcGIS Server could really run in a Linux environment. The application is developed using ArcGIS viewer for Flex which uses the Flex API for ArcGIS.

.NET to GIS Web Application Development

Finally, after some time since my last post about my current projects in .Net to share some learning for the past 6 months. I have undergone some training for GIS Web Application Development. I apologize to those people who have been dropping down comments on the SMS application using VB.net and AT commands. The good news is that I have found some interesting resources for you to complete your project. I'll be talking about these stuff later in a series of post plus ill give you the source code for you to integrate it in you own projects.

The next series of post are video tutorials on installing GIS Server, ArcSDE and PostGIS for Linux. I'v been lucky enough to work with some specialist in GIS and Oracle Database to complete this task. At first we were really having a hard time dealing with the setup. The common installation for ArcGIS Server is with the .Net platform running in Microsoft Server and other windows environment. Now we have faced a new challenge which is to install the GIS Server using the Java platform for Linux. I hope this series of post will show you some insights and help you along the way if your planning to go with opensource server application and GIS. 

Bellow is a web application we have developed. This application was a test web application showing that the ArcGIS Server could really run in a Linux environment. The application is developed using ArcGIS viewer for Flex which uses the Flex API for ArcGIS.