mdiener21

import csv, arcpy
from arcpy import env

# set path using raw string to personal geodatabase
env.workspace = r"c:\users\mdiener\documents\mypersonalgeodatabase.gdb"

# create a python list of all datasets in personal geodatabase
datasetList = arcpy.ListDatasets('*','Feature')

# open a file for writing.

mdiener21

from pyproj import Proj, transform

## my test coordinates, location is on the end of a peer on lake Wörthersee
## if the tranformation is wrong our point will be in the water 

#   these coorinates below I believe I can trust
#   and are all TRUE  for reference ( source KAGIS Atlas 17.10.2014)

#       epsg        proj      coord
#       epsg:31252  GK M31	70534.8	165013.4

mdiener21

import os
import django
from myapp import models

os.environ.setdefault("DJANGO_SETTINGS_MODULE", "myapp.settings")
django.setup()

print models.MyModel.objects.get(pk=1)

mdiener21

import os
import shutil
import distutils
import subprocess

base_source_path = r"E:\WEBGIS\source\trunk\mysite"   # svn source location
base_deploy_path = r"C:\inetpub\mysite"


source_dir3 = r"C:\Python27\Lib\site-packages\django_admin_bootstrapped\static\admin"

mdiener21

#download apache binaries: http://www.apachelounge.com/download/
#http://www.apachelounge.com/download/VC11/binaries/httpd-2.4.10-win32-VC11.zip
#unzip to a location you have permissions on your machine
#go in to folder to install apache and start it
cd c:\Apache24\conf

# edit file httpd.conf
# change all directory paths to cd c:\Apache24\

#install apache

mdiener21

from django.db import models

class AppQueryset(models.QuerySet):
    pass

class AppManager(models.Manager):
    queryset_class = AppQuerySet
    
    def get_queryset(self):
        return self.queryset_class(self.model)

mdiener21

x-geom
substr(to_string(geom_to_wkt(transform(  $geometry ,'EPSG:4326','EPSG:3857'))),7,16)

y-geom
substr(to_string(geom_to_wkt(transform(  $geometry ,'EPSG:4326','EPSG:3857'))),25,16)
 

mdiener21

update tableName set columnName = json_build_object('keyfieldname1',fieldname1,'keyfieldname2',fieldname2)
-- keyfieldname1 is any text name you give to the key
-- fieldname1 is an existing column name you have in your table
-- docs https://www.postgresql.org/docs/9.5/static/functions-json.html

mdiener21

import pandas as pd

df = pd.read_csv('..\data\hospitals.csv')
#print(df.to_json(orient='records'))
with open('..\data\hospitals.json', 'w') as outfile:
   outfile.write(df.to_json(orient='records'))

mdiener21

#In a terminal, type:

sudo -u postgres psql postgres
# this connects as a role with same name as the local user, i.e. "postgres", to the database called "postgres" (1st argument to psql).

# Set a password for the "postgres" database role using the command:
\password postgres