raprasad

• File to change: greenhousedb/plants/urls.py

1. Make home page the plant listing page

Change 'apps.greenhousedb.views.home' to 'apps.greenhousedb.views.view_plants'

Current lines

 # Examples:

raprasad

Find pg_hba.conf file location

bash-4.1$ psql
psql (8.4.20)
Type "help" for help.

postgres=# SHOW hba_file;
            hba_file             

raprasad

{
    "status": "OK", 
    "info": {
        "generation_time": "2016-12-16T13:10:25", 
        "cache_time_seconds": 900, 
        "params": {
            "persistentId": "doi:10.7910/DVN/26935", 
            "pretty": "true", 
            "key": "10350864-ff48-4ebd-a2d9-80a07a35f911 "
        }

raprasad

import json
from os.path import isfile, isdir, join
import os
import sys

def msg(s): print (s)
def dashes(): msg(40*'-')
def msgt(s): dashes(); msg(s); dashes()

raprasad

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package edu.harvard.iq.dataverse.datasetutility;

import edu.harvard.iq.dataverse.DataFile;
import edu.harvard.iq.dataverse.DataFileServiceBean;
import edu.harvard.iq.dataverse.Dataset;

raprasad

 
    @PUT
    @Path("{id}/metadata")
    public Response updateFileMetadata(
                    @PathParam("id") Long fileToUpdateId,
                    String jsonData
                    ){
    
        // -------------------------------------
        // (1) Get the user from the API key

raprasad

FID,province,city,plant,latDMS,capacityBb,latitude,country,employees,longitude,wikipediaP,operator,owner,longDMS,oilTank,refUnits,geoLat,geoLong,founded,capacity,mainContra
wikipedia_oil_refineries_vd7.1,,,Arpechim Refinery,,,44.79999924,,,24.93000031,http://en.wikipedia.org/wiki/Arpechim_Refinery,,Petrom,,,,44.79999924,24.93000031,,,
wikipedia_oil_refineries_vd7.2,,,Refinaria do Planalto Paulista,,,-22.72833252,,,-47.13166809,http://en.wikipedia.org/wiki/Refinaria_do_Planalto_Paulista,,,,,,-22.72833252,-47.13166809,,,
wikipedia_oil_refineries_vd7.3,,Cartagena; Colombia,Cartagena Refinery,10.315,75000,10.315,Colombia,,-75.49722222,http://en.wikipedia.org/wiki/Cartagena_Refinery,Refineria de Cartagena S.A.,Ecopetrol,-75.49722222,,crude units; visbreaking units; fluid catalytic cracker; light products plants; polymerization plants; amine plants; sulfur plants; impurities treatment plants,,,,,
wikipedia_oil_refineries_vd7.4,,Aspropyrgos,Aspropyrgos Refinery,,135000,38.03229904,Greece,,23.59840012,http://en.wikip

raprasad

when postgres in a bad state

remove lock file and reset transaction log

rm /usr/local/var/postgres/postmaster.pid
pg_resetxlog -f /usr/local/var/postgres

• source: http://www.brentmc79.com/posts/psql-could-not-connect-oh-fuck-you

raprasad

SQL commands to point a Dataverse installation at different geoconnect servers

1. Production (geoconnect.datascience.iq.harvard.edu)

update worldmapauth_tokentype set mapitlink = 'https://geoconnect.datascience.iq.harvard.edu/shapefile/map-it', hostname='geoconnect.datascience.iq.harvard.edu' where name = 'GEOCONNECT';

raprasad

(1) Error running paver build with postgis 2.0

• Error: django.db.utils.DatabaseError: operator class "gist_geometry_ops" does not exist for access method "gist"
• Last command: django-admin.py migrate --settings=geonode.settings --noinput

Solution from @capooti:

• http://stackoverflow.com/questions/13119040/failed-to-install-index-geodjango-related
• If wm_db and wmdata already exist, run query in those dbs