HKDevTips

In GeoNework (3.x), the XSL caching is enabled by default. To disable this, we can modify the following: In the ZIP GeoNetwork version, find the file "<GeoNetwork-Directory>/web/geonetwork/WEB-INF/classes/META-INF/services/javax.xml.transform.TransformerFactory" This file should contains the following:      de.fzi.dbs.xml.transform.CachingTransformerFactory Change this to the following:      net.sf.saxon.TransformerFactoryImpl Then the XSL transformation will not be cached. Reference:  http://mapas.mda.gov.br/geonetwork/docs/eng/users/quickstartguide/installing/index.html

Just being asked to convert string "1/1/2020 0:00' to date field in Oracle, and come up with this: select to_date('1/1/2020 0:00', 'dd/mm/yyyy hh24:mi') from dual

According to the documentation in GeoPandas , the following codes could read a local GeoJSON file and import to a PostGIS DB: import geopandas from sqlalchemy import create_engine path_to_data = "./my_file.geojson" gdf = geopandas.read_file(path_to_data) db_connection_url = "postgres://user:pwd@localhost:5432/db"; engine = create_engine(db_connection_url) gdf.to_postgis("my_file_table", con=engine) I found the following tips: "postgres://" has to be changed to "postgresql://" .  Package " psycopg2 " is required together with " sqlalchemy " (Details could be found in DBAPI support section in PostgreSQL documentation ) Package " GeoAlchemy2 " is required together with " sqlalchemy " Enjoy!