This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
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
<?xml version='1.0' encoding='UTF-8'?> | |
<gexf xmlns="http://gexf.net/1.3" version="1.3" xmlns:viz="http://gexf.net/1.3/viz" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://gexf.net/1.3 http://gexf.net/1.3/gexf.xsd"> | |
<meta lastmodifieddate="2024-03-14"> | |
<creator>Gephi 0.10.1</creator> | |
<title></title> | |
<description></description> | |
</meta> | |
<graph defaultedgetype="directed" mode="static"> | |
<nodes> | |
<node id="Uncle Vernon"> |
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
<?xml version='1.0' encoding='UTF-8'?> | |
<gexf xmlns="http://gexf.net/1.3" version="1.3" xmlns:viz="http://gexf.net/1.3/viz" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://gexf.net/1.3 http://gexf.net/1.3/gexf.xsd"> | |
<meta lastmodifieddate="2024-03-14"> | |
<creator>Gephi 0.10.1</creator> | |
<title></title> | |
<description></description> | |
</meta> | |
<graph defaultedgetype="directed" mode="static"> | |
<nodes> | |
<node id="Uncle Vernon"> |
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
10-19 business | |
11 projects | |
11.01 current | |
11.02 arhived | |
12 company_1 | |
13 volunteering | |
14 resume | |
15 youtube | |
16 activism | |
17 manufacturing |
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
- name: DO | |
hosts: localhost | |
vars: | |
project_name: "PUT A NAME FOR YOUR PROJECT HERE" | |
do_token: "PUT YOUR DIGITAL OCEAN API KEY HERE ==> https://cloud.digitalocean.com/settings/api/tokens" | |
repository: "PUT YOUR REPOSITORY URL HERE" | |
- name: NODE | Clone/Pull repo | |
git: | |
repo: "{{repository}}" |
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
U UNITY SOFTWARE INC COM 22.0 3038.76 | |
RY ROYAL BK CDA COM 15.0 1074.94 | |
SNE SONY CORP SPONSORED ADR 11.0 954.31 | |
ABT ABBOTT LABS COM 9.0 948.43 | |
AL AIR LEASE CORP CL A 20.8 724.21 | |
VIACA VIACOMCBS INC CL A 20.0 638.22 | |
ABBV ABBVIE INC COM 6.0 544.41 | |
TFC TRUIST FINL CORP COM 13.0 513.86 | |
MMM 3M CO COM 3.0 504.77 | |
UMC UNITED MICROELECTRONICS CORP SPON ADR NEW 75.0 483.6 |
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
Definition of Structure: | |
Level: Level Name: Code Format: Number of Items: | |
Level 1 Major Group 1 10 items | |
Level 2 Sub-major Group 12 43 items | |
Level 3 MInor Group 121 130 items | |
Level 4 Unit Group 1211 436 items |
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
#!/bin/bash | |
fileA="$1" | |
shift | |
for fileB in "$@"; do | |
( | |
# diff once grep twice with the help of tee and stderr | |
diff $fileA $fileB | \ | |
tee >(grep -cE '^< ' >&2) | \ | |
grep -cE '^> ' >&2 |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
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
Category were the 30 under 30 person was selected,Forbes Name,Forbes Age,Forbes Country,Role in the Company,Company,Description,LinkedIn Profile,linkedin_name,Exact match between the name ?,Did I had o perform a manual searh to find the linkedin profile ? | |
30 Under 30 - Europe - Social Entrepreneurs,Margherita Pagani,29,Argentina,Founder, Impacton.org,"Pagani aims to create an encyclopedia of blueprints for of purpose-driven projects for impact investing. The Italian-born and Argentina-based entrepreneur believes works with universities, governments and private companies to co-design programs based on proven models.",https://www.linkedin.com/in/magheritapagani,Margherita Pagani - CEO and Founder - Impacton.org ,FALSE,NO | |
30 Under 30 - Europe - Media & Marketing,Mohamed Khairat,25,Australia,Cofounders, Egyptian Streets,"Amin and Khairat founded Egyptian Streets back in 2012, less than two years after the Arab Spring. The digital publication that strives to address challenging issues--such as sexual harassment an |
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 glob | |
import os | |
import xml.etree.cElementTree as ET | |
#TODO Interator over a specifc folder, | |
#TODO increase value by 100000 for each new file | |
input_folder = './../../cygnus_output/output/' | |
output_folder = './../../step_11_ready2merge_output/' | |
start_number = 1 |
NewerOlder