marcellobenigno

WITH municipio AS (
    SELECT geom
    FROM maps_geometriamunicipio
    WHERE cod_ibge_m = '5007935'
)

SELECT
    t.*
FROM maps_texturasolo t
JOIN maps_grade10000 g

marcellobenigno

CREATE OR REPLACE FUNCTION get_municipios_geojson()
RETURNS json LANGUAGE sql STABLE SECURITY DEFINER AS $$
  SELECT json_build_object(
    'type', 'FeatureCollection',
    'features', json_agg(
      json_build_object(
        'type', 'Feature',
        'geometry', ST_AsGeoJSON(geom)::json,
        'properties', json_build_object(
          'nome',              nome,

marcellobenigno

iTerm2 Shortcuts

Tab navigation

• open new tab: Cmd + t
• next tab: Cmd + Shift + ]
• previous tab: Cmd + Shift + [

Pane navigation

marcellobenigno

# Layer from Memory
layer =  QgsVectorLayer('Point?crs=epsg:4326', 'MyPoint' ,'memory')
pr = layer.dataProvider()
pt = QgsFeature()
point1 = QgsPoint(-35.92,-7.24)
pt.setGeometry(QgsGeometry.fromPoint(point1))
pr.addFeatures([pt])
layer.updateExtents()
QgsMapLayerRegistry.instance().addMapLayers([layer])

luzfcb

baseado no meu outro tutorial https://gist.github.com/luzfcb/1a7f64adf5d12c2d357d0b4319fe9dcd que é mais atualizado que este. Eu não constumo atualizar esse tutorial, mas é bom para dar uma visão geral simplista das configurações.

Use o pyenv https://github.com/pyenv/pyenv para baixar, instalar e gerenciar múltiplas versões do INTERPRETADOR Python na sua maquina.

Primeiro instale as dependências:

Linux (Ubuntu):

marcellobenigno

# Shell script to create a complete Django project.
# This script require Python 3.x and pyenv
# Settings.py is config to Django 1.9.3

# The project contains:
# Settings config
# Person model and form
# Person list and detail
# Person create, update and delete
# Admin config

rg3915

# Shell script to create a complete Django project.
# This script require Python 3.x and pyenv
# Settings.py is config to Django 2.2.12

# The project contains:
# Settings config
# Person model and form
# Person list and detail
# Person create, update and delete
# Admin config

soifou

iTerm2 Shortcuts

Tab navigation

• open new tab: Cmd + t
• next tab: Cmd + Shift + ]
• previous tab: Cmd + Shift + [

Pane navigation

clhenrick

PostgreSQL & PostGIS Cheat sheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

TOC

• PostgreSQL & PostGIS Cheat sheet
  • TOC
  • Installation
• Postgres

leocomelli

GIT

Estados

• Modificado (modified);
• Preparado (staged/index)
• Consolidado (comitted);

Ajuda