Exemple #1
0
def get_last_values(station):
    # Do query from DB
    db = PostGIS(config)

    # Default is to get all last measurements
    query = 'SELECT * from v_last_measurements'
    if station:
        # Last measurements for single station
        query = query + ' WHERE device_id = ' + station
    return db.do_query(query, 'v_last_measurements')
Exemple #2
0
def get_last_values(station):
    # Do query from DB
    db = PostGIS(config)

    # Default is to get all current measurements
    query = 'SELECT * from v_cur_measurements'
    if station:
        # stations = station.split(',')

        # Last measurements for single station
        query = query + ' WHERE device_id = ' + station

        # May have provided multiple comma-separated stations
        # if len(stations) > 1:
        #     for i in range(1, len(stations)-1):
        #         query = query + ' OR device_id = ' + stations[i]
    return db.do_query(query, 'v_cur_measurements')
Exemple #3
0
def main():

	# validate args
	if len(sys.argv) != 2:
		get_usage()
	else:
		configfile = sys.argv[1]

	# read the config file
	config = ConfigParser()
	config.read(configfile)
	if config.sections() != ['PostGIS', 'Geoserver', 'Styles']:
		print 'Invalid config file...'
		sys.exit(1)

	# connect to postgis
	pginfo = dict(config.items('PostGIS'))
	pgdb = PostGIS(**pginfo)
	pgdb.info()
	pgdb.connect()

	# connect to geoserver
	gsinfo = Struct(**dict(config.items('Geoserver')))
	gscat = Catalog(gsinfo.url, gsinfo.user, gsinfo.password)

	print '\nGeoserver info:'
	print ' Url:', gsinfo.url
	print ' User:'******' password:'******'\nConnect to Geoserver...'

	if gsws == None:
		wsuri = '{0}/{1}'.format(gsinfo.url, gsinfo.workspace)
		gsws = gscat.create_workspace(gsinfo.workspace, wsuri)
		print 'Workspace created...'

	# sldfile info
	sld_info = Struct(**dict(config.items('Styles')))
	sld_info.folder = config.get('Styles', 'folder')
	sld_info.overwrite = config.getboolean('Styles', 'overwrite')

	print '\nStyles info:'
	print ' Folder: ', sld_info.folder
	print ' Overwrite: ', sld_info.overwrite

	# publish layers from postgis to geoserver
	publish_layers(pgdb, pginfo, gscat, gsws, sld_info)

	# close postgis connection
	pgdb.conn.close()

	print("\nCompleted!")
Exemple #4
0
def main():

    filegdb = FileGDB(fgdb, a_srs)
    filegdb.info()
    filegdb.open_files()
    filegdb.process_domains()
    filegdb.process_subtypes()
    filegdb.process_relations()
    filegdb.process_schemas()
    filegdb.close_files()

    postgis = PostGIS(host, port, user, password, pgdb, t_srs)
    postgis.info()
    postgis.connect()
    postgis.update_views()
    postgis.create_schemas(filegdb)
    postgis.load_database(filegdb)
    postgis.apply_sql(filegdb)
    postgis.disconnect()

    filegdb.cleanup()

    print "\nComplete!"
Exemple #5
0
def get_stations():
    # Do query from DB
    db = PostGIS(config)
    return db.do_query('SELECT * from stations', 'stations')