Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Mete Ercan Pakdil mtrcn

🏠
Working from home
View GitHub Profile
@mtrcn
mtrcn / ilceler.json
Created Apr 5, 2020
Turkiye Ilceler JSON
View ilceler.json
[
{
"bolge": "AKDENİZ",
"id": 1,
"il": "ADANA",
"ilce": "ALADAĞ",
"plaka": 1
},
{
"bolge": "AKDENİZ",
@mtrcn
mtrcn / index.js
Last active Feb 25, 2020
Print ArcGIS Server Layers in a tree
View index.js
const axios = require('axios');
const treeify = require('treeify');
const server_url = 'http://sampleserver1.arcgisonline.com/arcgis/';
const getFolders = async function(){
let response = await axios.get(`${server_url}rest/services?f=json`);
return response.data.folders;
}
View compare_dfs.py
def compareFields(jdbcDF, domainDf):
print "Missing Columns:"
print [col_name for col_name in [x.lower().replace(" ", "") for x in jdbcDF.columns] if not col_name in domainDf.columns]
print "Redundant Columns:"
print [col_name for col_name in domainDf.columns if not col_name in [x.lower().replace(" ", "") for x in jdbcDF.columns]]
mismatched_types = dict()
for col in (col_name for col_name in jdbcDF.columns if col_name.lower().replace(" ", "") in requests_consultaanvraag_df.columns):
colLowerName = col.lower().replace(" ", "")
destinationColType = str(domainDf.schema.fields[domainDf.columns.index(colLowerName)].dataType)
sourceColType = str(jdbcDF.schema.fields[jdbcDF.columns.index(col)].dataType)
View ContextCmder-Disable.reg
Windows Registry Editor Version 5.00
[-HKEY_CLASSES_ROOT\Directory\Background\shell\Cmder]
[-HKEY_CLASSES_ROOT\Directory\shell\Cmder]