Skip to content

Instantly share code, notes, and snippets.

View pigreco's full-sized avatar
😎

Salvatore Fiandaca pigreco

😎
76 followers · 4 following
View GitHub Profile
@pigreco
pigreco / point_Z.csv
Created April 5, 2016 13:28
P Y X Z
1001 5729447.89 7401421.26 200.380
1002 5729448.15 7401421.48 200.385
1003 5729445.77 7401425.13 199.945
1004 5729442.99 7401427.86 200.757
1005 5729445.88 7401422.16 197.211
1006 5729449.15 7401424.75 198.673
1007 5729450.18 7401425.57 198.895
1008 5729452.69 7401428.00 198.969
1009 5729454.85 7401430.12 198.823
@pigreco
pigreco / vrt.sql
Created April 6, 2016 10:26
SELECT *, make_point(x, y, z) as geometry FROM p969punti
@pigreco
pigreco / shell.ogr
Created April 9, 2016 20:42
C:\Users\Salvatore\Desktop>ogr2ogr -f DXF C:\Users\Salvatore\Desktop\prova\daidai.dxf C:\Users\Salvatore\Desktop\toto\dad_1.shp
@pigreco
pigreco / toto.sql
Last active April 11, 2016 12:43
concat('LABEL(f:Arial,s:3000pt,t:', "PICCHETTO",')')
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Tool parameter units
Several parameter values can be expressed in different measurement units depending on the file format you are dealing with. For instance, some systems express line width, or text height in points, other in pixels, and others use ground units. In order to accommodate all that, all parameters can be specified in one of the following units systems:
g: Map Ground Units (whatever the map coordinate units are)
px: Pixels
pt: Points (1/72 Inch)
mm: Millimeters
cm: Centimeters
@pigreco
pigreco / etichette_3D_dxf.py
Last active April 12, 2016 09:27
"""
/***************************************************************************
Name : Label DXF 3D
Description : popola il campo OGR_STYLE per label DXF 3D
Date : 11 - aprile - 2016
copyright : (C) 2016 by Salvatore Fiandaca
email : pigrecoinfinito@gmail.com
***************************************************************************/
@pigreco
pigreco / italia.geojson
Created April 13, 2016 20:16
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@pigreco
pigreco / index.html
Last active April 13, 2016 21:20
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="initial-scale=1,user-scalable=no,maximum-scale=1,width=device-width">
<meta name="mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-capable" content="yes">
<link rel="stylesheet" href="./resources/ol.css" />
<link rel="stylesheet" href="./resources/ol3-layerswitcher.css">
@pigreco
pigreco / prov211g.js
Created April 13, 2016 20:58
var geojson_prov211g = {
"type": "FeatureCollection",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "cod_pro": 83.000000, "gid": 88.000000, "cod_reg": 19.000000, "nome_pro": "83", "shape_leng": 0.000000, "shape_area": 550544.891179, "pop_istat_2015": 3265856721.710000, "nom_pro_breve": "645296", "iniziali": "ME" }, "geometry": { "type": "MultiPolygon", "coordinates": [ [ [ [ 14.966714, 38.154146 ], [ 14.966656, 38.153953 ], [ 14.967239, 38.153499 ], [ 14.967912, 38.153210 ], [ 14.968688, 38.152881 ], [ 14.969622, 38.152503 ], [ 14.970141, 38.152304 ], [ 14.976666, 38.150625 ], [ 14.977798, 38.150500 ], [ 14.981664, 38.150162 ], [ 14.981821, 38.150149 ], [ 15.005979, 38.149183 ], [ 15.007860, 38.149124 ], [ 15.011602, 38.149111 ], [ 15.011789, 38.149111 ], [ 15.028376, 38.149908 ], [ 15.03142
@pigreco
pigreco / v_centroidi_comuni.sql
Last active April 15, 2016 09:27
-- la tua tabella
id integer NOT NULL DEFAULT nextval('comuni_id_seq'::regclass),
geom geometry(MultiPolygon,32633),
cod_reg integer,
cod_pro integer,
pro_com integer,
nome_com character varying(58),
nome_ted character varying(100),
CONSTRAINT comuni_pkey PRIMARY KEY (id)
@pigreco
pigreco / Lista_video_youtube.txt
Last active April 15, 2016 18:22
Lista video Youtube
https://www.youtube.com/watch?v=Lq4dFizTO44&index=1&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=uAFQRb04HsQ&index=2&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=asgd4wp9t2Q&index=3&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=RFbIUDxHqv8&index=4&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=6FW7dyKCCYs&index=5&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=EYYhlTyUHD4&index=6&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=iL2QvCKfC-g&index=7&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=LRCkieXen9s&index=8&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200
https://www.youtube.com/watch?v=e8y8hYbye8o&index=9&list=PLqDFjeQq7NBga78nkZUVr6IjDe8_xWUjJ;w=332&amp;h=200