Joseph Rios alotau

## Create "circles" in PostGIS for QGIS
# Assumptions:
#  1.  You have a table (sample) with a Geography column (loc).
#  2.  That column contains only points (not a hard reqmt).
#  3.  You have a double precision column representing radius.
#  4.  That radius is in METERS (otherwise need to convert something somewhere).

# Found it easiest to create a new table rather than
# a view for use within QGIS.
CREATE TABLE sample_buffers AS
  SELECT ST_Buffer(sample.loc,sample.radius_meters)

## D1X3.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                alotau
                / D1X3.geojson
            
            
              Last active
              September 20, 2016 15:53
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## sqlite and double quotes
Just a note on double quotes in sqlite.

I have a workflow where I parse some data and generate an input file for a sqlite DB.  Within sqlite I do the following:

sqlite> .separator |
sqlite> .import my_data_file.txt my_table

I was getting errors for some lines like the following:

my_data_file.txt:2389: unescaped " character
	# Assumptions:
	# 1. You have a table (sample) with a Geography column (loc).
	# 2. That column contains only points (not a hard reqmt).
	# 3. You have a double precision column representing radius.
	# 4. That radius is in METERS (otherwise need to convert something somewhere).

	# Found it easiest to create a new table rather than
	# a view for use within QGIS.
	CREATE TABLE sample_buffers AS
	SELECT ST_Buffer(sample.loc,sample.radius_meters)
	Just a note on double quotes in sqlite.

	I have a workflow where I parse some data and generate an input file for a sqlite DB. Within sqlite I do the following:

	sqlite> .separator \|
	sqlite> .import my_data_file.txt my_table

	I was getting errors for some lines like the following:

	my_data_file.txt:2389: unescaped " character