This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO public.caravanas (id, geom, data, estado, caravana, municipio, territorio, ano, tema) VALUES (17, '0101000020E6100000848FD2B6ABF445C02A464C3F97CF33C0', '15/04/2023', 'BH', 'BELO HORIZONTE', 'Belo Horizonte', 'Complexo Izidora', 2023, 'Caravana Periferia Viva'); | |
INSERT INTO public.caravanas (id, geom, data, estado, caravana, municipio, territorio, ano, tema) VALUES (18, '0101000020E61000001278712C39F445C0232AF97DA4ED33C0', '15/04/2023', 'BH', 'BELO HORIZONTE', 'Belo Horizonte', 'Kilombo Manzo', 2023, 'Caravana Periferia Viva'); | |
INSERT INTO public.caravanas (id, geom, data, estado, caravana, municipio, territorio, ano, tema) VALUES (19, '0101000020E6100000725BC75D29F247C0DB1C42F053982FC0', '27/04/2023', 'DF', 'BRASÍLIA', 'BRASÍLIA', NULL, 2023, 'Caravana Periferia Viva'); | |
INSERT INTO public.caravanas (id, geom, data, estado, caravana, municipio, territorio, ano, tema) VALUES (20, '0101000020E610000068F228F0A9A248C07024D060536F39C0', '30/09/2023', 'PR', 'CURITIBA', 'Curitiba', 'Núcleo Periférico', 20 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import os | |
import subprocess | |
import geopandas as gpd | |
from datetime import datetime | |
# Diretório onde os arquivos estão localizados | |
path = '/Users/marcellodebarrosfilho/Downloads/car_2024_rep' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
delete from iniciativa where origem = 'redus'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO public.iniciativa (id, nome_acao, nome_comunidade, localidade, organizacao, categoria, uf, municipio_cadastro, origem, premiado, ano, geom, municipio_bbox_id, organizacao_slug, id_resposta) VALUES (2600, 'Portal Favelas ', 'Rio de Janeiro ', 'Maré, 21042, Rio de Janeiro, Rio de Janeiro, Brasil', 'Portal Favelas ', 'Acesso à Justiça e Combate às Desigualdades', 'RJ', 'Rio de Janeiro', 'redus', false, NULL, '0101000020E61000003B014D840D9F45C024B9FC87F4DB36C0', 2417, 'portal-favelas', '7dfc0656-843b-4c6a-8085-c9bf67d81855'); | |
INSERT INTO public.iniciativa (id, nome_acao, nome_comunidade, localidade, organizacao, categoria, uf, municipio_cadastro, origem, premiado, ano, geom, municipio_bbox_id, organizacao_slug, id_resposta) VALUES (2646, 'Projeto social filhos da inclusão ', 'Ilha de Santa Terezinha ', 'Rua Mário Albuquerque Cavalcanti, Santo Amaro, Recife - Pernambuco, 50110, Brasil', 'Filhos da inclusão ', 'Saúde Integral e Dignidade Humana', 'PE', 'Recife', 'redus', false, NULL, '0101000020E6100000 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- PostgreSQL database dump | |
-- | |
-- Dumped from database version 13.13 | |
-- Dumped by pg_dump version 13.13 | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from collections import defaultdict | |
from osgeo import ogr | |
from shapely.geometry import MultiLineString | |
from shapely.wkt import loads | |
ogr.UseExceptions() | |
class Demanda: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def handle(self, *args, **options): | |
val = options['município/estado/ano'] | |
slug = slugify(val.split('/')[0]) | |
sigla_uf = val.split('/')[1].strip().upper() | |
ano = int(val.split('/')[2].strip()) | |
municipio = Municipio.objects.get(slug=slug, sigla_uf=sigla_uf) | |
SnciUsoOcupacao.objects.filter(snci__municipio=municipio.cod_ibge_m, ano=ano).delete() | |
SigefUsoOcupacao.objects.filter(sigef__municipio=municipio.cod_ibge_m, ano=ano).delete() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def create_point(name): | |
uri = "point?crs=epsg:4326" | |
points = QgsVectorLayer(uri, name, 'memory') | |
QgsProject.instance().addMapLayer(points) | |
# chamando o provider para poder criar | |
# tanto os campos, quanto validar todo o processo: | |
provider = points.dataProvider() | |
# definindo os campos da minha camada |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<template> | |
<div class="row"> | |
<div class="col-md-6"> | |
<canvas id="myChart"></canvas> | |
</div> | |
<div class="col-md-6"> | |
<select class="form-select" v-model="year" v-on:change="getTotalByYear(year)"> | |
<option selected>Escolha o ano</option> | |
<option v-for="(year, index) in years" :key="index" :value="year">{{ year }}</option> | |
</select> |
NewerOlder