rvg296

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

TOC

• Installing Postgres & PostGIS
• Using Postgres on the command line: PSQL
• Importing Data into Postgres
• Exporting Data from Postgres
• Joining Tables

rvg296

'''This script can be only be run either by Organization Administrator or the Feature Service Owner for exporting the data'''

import time
from datetime import date
import urllib, zipfile,json
from arcgis.gis import GIS

# Feature Service Item ID
featureService_ID = "***************"
# Local folder where the data will be downloaded (include slash at the end)