simgislab

#!/usr/bin/env python -u
# -*- coding: utf-8 -*-
# ---------------------------------------------------------------------------
# region-names.py
# Author: Maxim Dubinin (sim@gis-lab.info)
# About: For each input name search for reference region name and add codes to output.
# Created: 24.03.2014
# Usage example: python region-names.py in.csv ref.csv out.csv
# ---------------------------------------------------------------------------

simgislab

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#Author: https://github.com/old-bibigon
#Description: Download data on polling stations or Russia from http://www.vybory.izbirkom.ru/ik/
#

import urllib
import os
import sys
import pickle

simgislab

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#Author: https://github.com/old-bibigon
#Description: Parse downloaded data on polling stations or Russia into SQLite database
#

from sqlalchemy import types, Column, ForeignKey, orm
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker
import datetime

simgislab

new;reference_frame;hourly_data;gps_glonass;link;code;city;location;lon_old;lon;lat;height;agency;clock;dormant
0;0;1;1;http://igscb.jpl.nasa.gov/network/site/abmf.html;abmf;Les Abymes;Guadeloupe;298,4725;-61,5275;16,2623;-25;IGN-SGN;INTERNAL;0
0;0;1;0;http://igscb.jpl.nasa.gov/network/site/abpo.html;abpo;Antananarivo;Madagascar;47,2292;47,2292;-19,0183;1552,9923;JPL;INTERNAL;0
0;1;0;0;http://igscb.jpl.nasa.gov/network/site/ade1.html;ade1;Salisbury;Australia;138,6473;138,6473;-34,729;38,2;NGA;Cesium / Rcvr 1;1
0;0;0;0;http://igscb.jpl.nasa.gov/network/site/ade2.html;ade2;Salisbury;Australia;138,6473;138,6473;-34,729;38,2;NGA;Cesium / Rcvr 2;1
0;0;1;1;http://igscb.jpl.nasa.gov/network/site/adis.html;adis;Addis Ababa;ETHIOPIA;38,7663;38,7663;9,0351;2439,154;BKG;;0
0;1;1;1;http://igscb.jpl.nasa.gov/network/site/aira.html;aira;Aira;Japan;130,5996;130,5996;31,8241;314,64;GSI;CESIUM;0
0;0;1;1;http://igscb.jpl.nasa.gov/network/site/ajac.html;ajac;Ajaccio;France;8,7626;8,7626;41,9275;99;IGN-SGN;INTERNAL;0
0;1;1;0;htt

simgislab

new;reference_frame;hourly_data;gps_glonass;link;code;city;location;lon_old;lon;lat;height;agency;clock;dormant
0;1;1;0;http://igscb.jpl.nasa.gov/network/site/artu.html;artu;Arti;Russian Federation;58,5605;58,5605;56,4298;247,511;RDAAC-IRIS;INTERNAL;0
0;0;1;1;http://igscb.jpl.nasa.gov/network/site/badg.html;badg;Badary;Russian Federation;102,235;102,235;51,7697;811,4;IAA;EXTERNAL H-MASER CH1-80;0
0;1;0;0;http://igscb.jpl.nasa.gov/network/site/bili.html;bili;Bilibino;Russian Federation;166,438;166,438;68,0761;456,238;RDAAC-IRIS;INTERNAL;1
0;1;0;1;http://igscb.jpl.nasa.gov/network/site/irkj.html;irkj;Irkutsk;RUSSIA;104,3162;104,3162;52,219;502,1;VNIIFTRI;EXTERNAL H-MASER;0
0;0;1;0;http://igscb.jpl.nasa.gov/network/site/irkm.html;irkm;Irkutsk;Russia;104,3162;104,3162;52,219;502,317;ES NIIFTRI;H-MASER;0
0;1;0;0;http://igscb.jpl.nasa.gov/network/site/irkt.html;irkt;Irkutsk;Russia;104,3162;104,3162;52,219;503,3816;DEOS-DUT;H-MASER;1
0;1;0;1;http://igscb.jpl.nasa.gov/network/site/khaj.html;khaj;Khabarovsk;RUSSIA;135

simgislab

http://metro4all.org/ajax/ru/msk/routes/search?station_from=34&portal_from=17360&station_to=120&portal_to=15190

{
    "result": [
        {
            "portals": {
                "portal_to": {
                    "barriers": {
                        "lift_minus_step": "0",
                        "min_step_ramp": 0,

simgislab

{
    "result": [
        {
            "portals": {
                "portal_to": null,
                "portal_from": null
            },
            "route": [
                {
                    "station_type": "regular",

simgislab

'''python  create_stations_csv_for_logger.py in_csv out_csv
'''

import csv
import sys

f_out_name = sys.argv[2]
f_in_name = sys.argv[1]
f_out = open(f_out_name,'wb')
f_out.write("ID,NAME\n")

simgislab

ID,NAME
11,Бульвар Рокоссовского 1
12,Бульвар Рокоссовского 2
13,Бульвар Рокоссовского 3
14,Бульвар Рокоссовского 4
21,Черкизовская 1
22,Черкизовская 2
23,Черкизовская 3
24,Черкизовская 4
31,Преображенская площадь 1

simgislab

ID,NAME
31,Проспект Ветеранов 1
32,Проспект Ветеранов 2
33,Проспект Ветеранов 3
34,Проспект Ветеранов 4
41,Ленинский проспект 1
42,Ленинский проспект 2
43,Ленинский проспект 3
44,Ленинский проспект 4
51,Автово 1