You can now install PostGIS via cPanel.
Simply log into cPanel and click the PostGIS icon located in the “Databases” section.
Select the database and click the “Install PostGIS” button.
PostGIS cPanel
Ideal for getting started or for smaller apps, our PostGIS cPanel hosting combines our powerful PostGIS tools with the convenience of cPanel.
View PlansPostGIS
AcuGIS offers PostGIS Hosting solutions for all needs and budgets. View hosting solutions at left.
PostGIS Dedicated
Complete PostGIS Dedicated hosting on your own VM. The extra performance and security you need for mission critical work loads.
View Planspg_tileserv Hosting
Complete pg_tileserv Hosting solutions with everything you need: pg_tileserv, pg_featurserv, PostgreSQL, PostGIS latest, control panel, SSL, and more.
View PlansYour Choice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo
Certified Data Centers
Cited, Inc. provides hosting in Data Centers that are SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
QGIS Mapping
AcuGIS offers Lizmap, QWC2, G3W-Suite, and QuartzMap hosting for your QGIS Maps. All services are complete solutions that contain everything you need.
Lizmap Hosting
Complete Lizmap hosting - everything you need; Lizmap, PostGIS, Domain Hosting, FTP, SSH, control panel, SSL, and more.
View PlansG3W-Suite Hosting
Complete G3W Suite hosting = includes everything you need; G3W Suite, PostGIS latest, control panel, web, domain mapping, email, and much more. Change plans at any time.
View PlansQuartzMap Hosting
QuartzMap turns your qgis2web maps into secure, data-driven maps connected to PostGIS and GeoServer.
View PlansQWC2 Hosting
Dedicated QGIS Web Client 2 (QWC2) Hosting. Your own QWC2 instances with all QWC2 services. Use your own domain or sub domain. Create unlimited Tenants.
View PlansChoice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Data Center Certifications
SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
GeoServer
AcuGIS offers a full array of GeoServer hosting options, from our affordable GeoServer cPanel to GeoServer Dedicated and High Availability GeoServer Clusters. Complete GeoNetwork and GeoNode hosting solutions are also available.
GeoServer cPanel
Our affordable GeoServer with cPanel is great for getting started with GeoServer or for light applications.
View PlansGeoServer Dedicated
GeoServer on a dedicated VM with the latest production versions of GeoServer and PostGIS. No-cost option of mapping applications such as MapStore2, Lizmap, and G3W-Suite. Your choice of 14 hosting locations worldwide.
View PlansGeoServer Cluster
High Availability GeoServer Clusters. Scale your service in any direction by adding or removing standbys. Scale your Data Directory independetly of other resources.
View PlansGeoNetwork
Complete GeoNetwork hosting. Includes everything you need; GeoNetwork, PostGIS, Elastic Search, Kibana Dashboard, FTP, SSH, Control Panel, SSL, and more. Your choice of 14 hosting locations.
View PlansYour Choice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Certified Data Centers
Cited, Inc. provides services to customers in over 80 countries worldwide. SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
GeoNode
Complete GeoNode hosting. Includes everything you need; GeoNode, GeoServer, web space, SSL, email, PostGIS latest, backup and restore, and much more. Your choice of 14 hosting locations worldwide.
View PlansGeoNode Plus Mobile
Field survey is a complete Mobile and Mapping solution. Your choice of QGIS Mapping application, GeoSync, with optional GeoServer or GeoNode.
View PlansYour Choice of 14 Hosting Locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Certified Data Centers
Cited, Inc. provides services to customers in over 80 countries worldwide. SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
SaaS Solutions
AcuGIS offers a modular SaaS GIS services that allows you to add and remove those components you need.
Find out moreGeoSync
Synchronize Mobile Data to PostGIS. Works with QFieldCloud, ArcGIS Survey123, and MerginMaps.
View PlansJasper Publisher QE
Our own Jasper Publisher with integrated QGIS Mapping and Reporting. Add Reports to your QGIS maps, schedule Map reports, and much more.
View PlansField Data Entrprise
Field Data Enterprise is a complete Mobile and Mapping solution. Your choice of QGIS Mapping application, GeoSync, with optional GeoServer or GeoNode.
View PlansYour choice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Certified Data Centers
Cited, Inc. provides services to customers in over 80 countries worldwide. SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
On Site and SaaS
AcuGIS services can be provided on AWS, Azure, GoogleCloud, or DigitalOcean. On Site services can be provided on your own infrastructure, other services are available as SaaS.
View PlansOn Site Services
GeoServer
Lizmap
G3W-Suite
DSpace7
GeoNetwork
GeoNode
SaaS Services
QWC2 Hosting
GeoSync
Field Data Express
Jasper QE
Corporation
Cited, Inc. of Wilmington, Delaware provides GIS hosting and provisioning services to customers in over 80 countries worldwide.
About
Cited, Inc. of Wilmington, Delaware provides GIS hosting and provisioning services to customers in over 80 countries worldwide.
Find out moreData Centers
All hosting is offered in your choice of 12 worldwide hosting locations. All Data Centers are are SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
Find out moreOpen Source Projects
AcuGIS is committed to Open Source. We've produced and maintain Open Source projects that provide System Administration for GIS services.
Jasper Publisher
Open Source Jasper Report Publisher. Publish, schedule, email, and on-demand reporting.
Find out moreOpenTileServer
Our OpenTileServer script and Docker image allow you to quickly build an OpenStreetMap tile server.
Find out moreModules
We've created modules for installing and managing Tomcat, Nagios, Certbot, Oracle Instant Client, and more...
Find out moreAcademic Discounts
Learn about our Academic Discounts for schools, NGOs, and community projects.
Find out moreYour choice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Certified Data Centers
Cited, Inc. provides services to customers in over 80 countries worldwide. SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
Your choice of 14 hosting locations
Your choice of 14 hosting locations worldwide. New York City, San Francisco, Toronto, London, Paris, Frankfurt, Stockholm, Amsterdam, Madrid, Sao Paulo, Santiago, Sydney, Singapore, and Tokyo.
Certified Data Centers
Cited, Inc. provides services to customers in over 80 countries worldwide. SSAE16, SOC, PCI, and HIPAA-Compliant. ISO 9001: 2008 for quality management systems and ISO/IEC 27001:2005 for information security management systems.
AcuGIS Blogs
You can now install PostGIS via cPanel.
Simply log into cPanel and click the PostGIS icon located in the “Databases” section.
Select the database and click the “Install PostGIS” button.
Subversion (SVN) and GIT are now enabled on all cPanel servers.
If you have questions, please raise a support ticket.
Unlike PhpMySQL, PhpPgAdmin does not feature a nice drop-down to auto increment on a column.
This post will demonstrate how to auto increment on a column in PostgreSQL using either the PhpPgAdmin SQL Editor as well as how to make use of PhpPgAdmin GUI to do some of the work for us.
The steps for using the PhpPgAdmin SQL Editor can be applied to using the command line (psql) as well.
In our example we will create a table, Managers.
Our table will have three columns: mgr_id, mgr_name, and mgr_email.
For each insertion of a new Manager entry, we want to auto increment our primary key, mgr_id, by 1.
Let’s start by using the command line. You can use below for the PhpPgAdmin SQL Editor as well.
testdb=> CREATE SEQUENCE mgr_id_seq; CREATE SEQUENCE
We now create the Manager table.
For mgr_id, set as PRIMARY KEY and set the DEFAULT to NEXTVAL(‘mgr_id_seq’) as shown below.
This will increment our sequence by 1 each time a new Manager entry is inserted.
testdb=> CREATE TABLE managers( testdb(> mgr_id INTEGER PRIMARY KEY DEFAULT NEXTVAL('mgr_id_seq'), testdb(> mgr_name VARCHAR(50), testdb(> mgr_email VARCHAR(50) testdb(> ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "managers_pkey" for table "managers" CREATE TABLE testdb=>
testdb=> INSERT INTO managers (mgr_name, mgr_email) VALUES('bob smith', 'bob@smith.com'); INSERT 0 1 testdb=> INSERT INTO managers (mgr_name, mgr_email) VALUES('tom jones', 'tom@jones.com'); INSERT 0 1
testdb=> select * from managers; mgr_id | mgr_name | mgr_email --------+-----------+--------------- 1 | bob smith | bob@smith.com 2 | tom jones | tom@jones.com (2 rows) testdb=>
As we an see from above, the increment begins at 1 and increments by 1 by default.
Now, let’s take a look at how we can do this using some of the PhpPgAdmin GUI tools.
Using the PhpPgAdmin GUI Tools
Step 1: Create Sequence in PhpPgAdmin
Create your sequence using by selecting the Sequence node in PhpPgAdmin and then click “Create Sequence”
Enter the sequence name as shown below.
With your sequence created, you can now set the DEFAULT value for the mgr_id column to nextval(‘mgr_id_seq’) in the table creation GUI as shown below:
More on Sequences in PostgreSQL:
http://www.postgresql.org/docs/9.0/static/sql-createsequence.html
http://www.postgresql.org/docs/9.1/static/functions-sequence.html
Welcome to the new AcuGIS Blog.
Our new AcuGIS Blog is built with Apache Roller 5.0 and PostgreSQL 9.1.
We are just getting started the week of 02 January, 2012.
Please check back soon!