Jorge Gustavo Rocha jgrocha

🏠

Working from home

Universidade do Minho

55 followers · 5 following

Geomaster, Lda
Braga, Portugal

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

jgrocha / GetProjectSettings.xml

Created October 19, 2019 18:51

	<?xml version="1.0" encoding="utf-8"?>
	<?xml-stylesheet type="text/xsl" href="http://qgis.demo:80/cgi-bin/qgis_mapserv.fcgi?MAP=postgresql:?service=pg_geotuga&sslmode=disable&schema=public&project=depende&SERVICE=WMS&REQUEST=XSL"?>
	<WMS_Capabilities xmlns:sld="http://www.opengis.net/sld" xmlns:qgs="http://www.qgis.org/wms" version="1.3.0" xmlns="http://www.opengis.net/wms" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wms http://schemas.opengis.net/wms/1.3.0/capabilities_1_3_0.xsd http://www.opengis.net/sld http://schemas.opengis.net/sld/1.1.0/sld_capabilities.xsd http://qgis.demo/cgi-bin/qgis_mapserv.fcgi?MAP=postgresql%3A%3Fservice%3Dpg_geotuga%26sslmode%3Ddisable%26schema%3Dpublic%26project%3Ddepende&SERVICE=WMS&REQUEST=GetSchemaExtension">
	<Service>
	<Name>WMS</Name>
	<KeywordList>
	<Keyword vocabulary="ISO">infoMapAccessService</Keyword>
	</KeywordList>
	<OnlineResource xlink:type="simple" xmlns:xlink="http://www.w3.org/1999/xlink"

jgrocha / github_candidates.csv

Last active June 4, 2019 22:37

fix github issue references on QGIS repo

We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.

	github
	29637
	29598
	29511
	29374
	28865
	28564
	28546
	28545
	28382

jgrocha / psql service pg_trabalho.jpg

Last active May 31, 2019 15:54

psql services=pg_trabalho

jgrocha / psycopg2

Created May 30, 2019 10:46

	import psycopg2

	connection = psycopg2.connect(service='pg_trabalho')
	# connection = psycopg2.connect(user = "cmb.user", password = "xxxxxxxx", host = "192.168.1.24", port = "5432", database = "trabalho")
	cursor = connection.cursor()
	# Print PostgreSQL Connection properties
	print ( connection.get_dsn_parameters(),"\n")
	# Print PostgreSQL version
	cursor.execute("SELECT version();")
	record = cursor.fetchone()

jgrocha / Captura de ecrã de 2018-11-28 21-29-33.png

Last active November 28, 2018 21:36

hdf

Captura de ecrã de 2018-11-28 21-29-33.png

jgrocha / qgis3_standalone_osx.py

Created August 7, 2018 15:57 — forked from dmofot/qgis3_standalone_osx.py

	"""
	Standalone python script for QGIS3 on OSX.
	"""
	import os
	import sys

	# Define plugin locations from QGIS3
	sys.path.append('/Applications/QGIS3.app/Contents/Resources/python/')
	sys.path.append('/Applications/QGIS3.app/Contents/Resources/python/plugins')
	# Define Qt5 plugin path since Qt5 can't find it

jgrocha / description

Created June 30, 2018 09:17

Scaleway

Can not attched a volume

jgrocha / qgis screenshot.png

Last active February 24, 2018 12:14

multiplolygon sample

[https://gis.stackexchange.com/questions/257974/postgis-multipolygon-when-converted-to-shapefile-doesnt-match-the-source-geomet PostGIS Multipolygon when converted to shapefile doesn't match the source geometry]

jgrocha / add postgis table dialog.png

Last active December 3, 2017 11:33

Feedback about missing spatial indexes on Postgis

jgrocha / upgrade-postgres-9.5-to-9.6.md

Last active March 16, 2017 10:53 — forked from Prototype-X/upgrade-postgres-9.5-to-9.6.md

Upgrading PostgreSQL from 9.5 to 9.6 on Ubuntu 16.04

TL;DR

Install Postgres 9.6, and then:

sudo pg_dropcluster 9.6 main --stop
sudo service postgresql stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main

NewerOlder