danleesmith

Install geopandas on ubuntu using apt-get when running into fetch/IPv6 issues:

sudo apt-get update --option Acquire::ForceIPv4=true --option Acquire::Retries=100 --option Acquire::http::Timeout=60
sudo apt-get updgrade
sudo apt get install python3-geopandas --option Acquire::ForceIPv4=true --option Acquire::Retries=100 --option Acquire::http::Timeout=60

solution thanks to @supersan on StackExchange

danleesmith

Setup PostGIS database on Debian via WSL

The following assmes that WSL version 2 is already installed and setup

In PowerShell:

wsl --install -d Debian

In the Debian terminal:

danleesmith

danleesmith

"""
This script is will 'import' a custom GeoJSON file into Houdini. It is intended to be used in the Houdini SOP context, either in the default python SOP or a custom python operator. These operators need to have the four custom paramters as listed in the 'node parameters' section. 

There are several steps/limitations with the import that must be taken into account:
- Will handle point, line and polygone features
- Will not process polygons with holes
- Will not handle geographic coordinates properly (latitude and longitude). The features must use a projected (X,Y,Z) datum. This technically means that the input GeoJSON will not adhere to the spec which demands coodrinates on WGS84).
- Will not handle NULL or None type attributes for any feature. All features must have a value for all attributes. If there is a NULL for a string use and empty: "". If there is a null for a number use -9999.
"""