André Andrade mrstif

## postgis.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                mrstif
                / postgis.md
            
            
              Last active
              August 9, 2018 14:28
            
              
                PostGis
              
          
    https://postgis.net/docs/
SRIDs

3857 - Simple Spherical Mercator projection coordinate system

4326 - Geographic coordinate system
FUNCTIONS


ST_Transform: Return a new geometry with its coordinates transformed to a different spatial reference.


## createuser.sql
CREATE USER $USERNAME PASSWORD $PASSWORD;
GRANT USAGE ON SCHEMA $SCHEMA TO $USERNAME;
GRANT SELECT ON $TABLENAME TO $USERNAME;

## nginx.conf
http {
    # nginx won't resolve URLs correctly so we have to provide google's public DNS
    resolver 8.8.8.8;

    #######################
    ### Server side SSL ###
    #######################

    # based on: https://raymii.org/s/tutorials/Strong_SSL_Security_On_nginx.html
    # Test using: https://www.ssllabs.com/ssltest/
	CREATE USER $USERNAME PASSWORD $PASSWORD;
	GRANT USAGE ON SCHEMA $SCHEMA TO $USERNAME;
	GRANT SELECT ON $TABLENAME TO $USERNAME;
	http {
	# nginx won't resolve URLs correctly so we have to provide google's public DNS
	resolver 8.8.8.8;

	#######################
	### Server side SSL ###
	#######################

	# based on: https://raymii.org/s/tutorials/Strong_SSL_Security_On_nginx.html
	# Test using: https://www.ssllabs.com/ssltest/