Python-GIS-BG

## simple_idw.ipynb

      
              1 file
            
          
              5 forks
            
          
              7 comments
            
          
              7 stars
            
          
                Majramos
                / simple_idw.ipynb
            
            
              Last active
              December 14, 2023 17:47
            
              
                Simple inverse distance weighted (IDW) interpolation with python
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## clip_layers_by_other_layers.py
# Note: this script is designed to run with Python 3 and ArcGIS Pro ArcPy

# import modules
# arcpy => provides access to Esri ArcGIS Pro
# os => provides convient way to construct file paths
# sys => provides way to capture errors
# re => used for snake case helper function (taken from https://www.30secondsofcode.org/python/s/snake)
import arcpy, os, sys
from re import sub

## README.md

      
              1 file
            
          
              1 fork
            
          
              2 comments
            
          
              13 stars
            
          
                ThomasG77
                / README.md
            
            
              Last active
              April 8, 2024 20:17
            
              
                Run PyQGIS in Jupyter Notebook
              
          
    Run Jupyter notebook with PyQGIS

On Windows

Look at this existing tutorial https://lerryws.xyz/posts/PyQGIS-in-Jupyter-Notebook
On Ubuntu

Install


## psql-error-fix.md

      
              1 file
            
          
              45 forks
            
          
              39 comments
            
          
              217 stars
            
          
                AtulKsol
                / psql-error-fix.md
            
            
              Last active
              April 10, 2024 07:41
            
              
                Solution of psql: FATAL: Peer authentication failed for user “postgres” (or any user)
              
          
    psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).
If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.
But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:
from

  
## map.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                yurukov
                / map.geojson
            
            
              Created
              March 12, 2015 16:20
            
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## county-epsg.csv

          
            COUNTYFIPS
            NAME
            STATEPLANEFIPS
            EPSG

            
              16079
              Shoshone County
              1103
              26970

            
              16073
              Owyhee County
              1103
              26970

            
              16071
              Oneida County
              1101
              26968

            
              16077
              Power County
              1101
              26968

            
              16075
              Payette County
              1103
              26970

            
              06115
              Yuba County
              0402
              26942

            
              06111
              Ventura County
              0405
              26945

            
              06113
              Yolo County
              0402
              26942

            
              31177
              Washington County
              2600
              32104

## .block
license: gpl-3.0
redirect: https://observablehq.com/@d3/vector-tiles
	# Note: this script is designed to run with Python 3 and ArcGIS Pro ArcPy

	# import modules
	# arcpy => provides access to Esri ArcGIS Pro
	# os => provides convient way to construct file paths
	# sys => provides way to capture errors
	# re => used for snake case helper function (taken from https://www.30secondsofcode.org/python/s/snake)
	import arcpy, os, sys
	from re import sub
COUNTYFIPS	NAME	STATEPLANEFIPS	EPSG
16079	Shoshone County	1103	26970
16073	Owyhee County	1103	26970
16071	Oneida County	1101	26968
16077	Power County	1101	26968
16075	Payette County	1103	26970
06115	Yuba County	0402	26942
06111	Ventura County	0405	26945
06113	Yolo County	0402	26942
31177	Washington County	2600	32104
	license: gpl-3.0
	redirect: https://observablehq.com/@d3/vector-tiles