ranchodeluxe

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

ranchodeluxe

SET CLIENT_ENCODING TO UTF8;
SET SEARCH_PATH TO public, postgis, topology;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "shapefile_12707" (gid serial,
"id" varchar(50),
"textlink" varchar(50),
"spcode" varchar(33),
"et_source" varchar(254),
"objectid" numeric,

ranchodeluxe

MAP
  NAME dissolved_idl
  UNITS METERS
  EXTENT -20042508.3427892 2139661.75 20042508.3427892 13006341.025845
  IMAGETYPE PNG
   
  OUTPUTFORMAT 
    NAME PNG
    DRIVER 'GD/PNG'
    MIMETYPE 'image/png'

ranchodeluxe

#!/bin/bash
#export  PROJ_LIB="/data2/greg.noaaerma.org/regional/arctic/localdata/proj"

/usr/lib/cgi-bin/mapserv_602 -nh "QUERY_STRING=map=/home/gcorradini/mapserver_bugs/bad_hatch.map&BBOX=18785164.06875,6261721.35625,19411336.204375,6887893.491875&BUFFER=0&FORMAT=image%2Fpng&HEIGHT=256&LAYERS=dissolved_idl&REQUEST=GetMap&SERVICE=WMS&SRS=EPSG%3A900913&STYLES=&TRANSPARENT=true&VERSION=1.1.1&WIDTH=256" &

/usr/lib/cgi-bin/mapserv_602 -nh "QUERY_STRING=map=/home/gcorradini/mapserver_bugs/bad_hatch.map&BBOX=19411336.204375,6887893.491875,20037508.34,7514065.6275&BUFFER=0&FORMAT=image%2Fpng&HEIGHT=256&LAYERS=dissolved_idl&REQUEST=GetMap&SERVICE=WMS&SRS=EPSG%3A900913&STYLES=&TRANSPARENT=true&VERSION=1.1.1&WIDTH=256" &

/usr/lib/cgi-bin/mapserv_602 -nh "QUERY_STRING=map=/home/gcorradini/mapserver_bugs/bad_hatch.map&BBOX=18785164.06875,6887893.491875,19411336.204375,7514065.6275&BUFFER=0&FORMAT=image%2Fpng&HEIGHT=256&LAYERS=dissolved_idl&REQUEST=GetMap&SERVICE=WMS&SRS=EPSG%3A900913&STYLES=&TRANSPARENT=true&VERSION=

ranchodeluxe

dbh->do("update shapefile set x_min = ?, x_max = ?, y_min = ?, y_max = ? where shapefile_id = ?", undef, $xmin, $xmax, $ymin, $ymax, $shapefile_id);
 
+ dbh->do("CLUSTER shapefile_".$shapefile_id."_pkey ON shapefile_".$shapefile_id);
+
dbh->do("analyze shapefile_".$shapefile_id);

ranchodeluxe

[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1] mod_wsgi (pid=3118): Exception occurred processing WSGI script '/data2/greg.noaaerma.org/regional/arctic/django/layerquery/django.wsgi'.
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1] Traceback (most recent call last):
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1]   File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/handlers/wsgi.py", line 241, in __call__
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1]     response = self.get_response(request)
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1]   File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/handlers/base.py", line 179, in get_response
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1]     response = self.handle_uncaught_exception(request, resolver, sys.exc_info())
[Fri Jul 13 13:35:33 2012] [error] [client 127.0.0.1]   File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/pyth

ranchodeluxe

Updating cache with layer permissionsTraceback (most recent call last):
  File "/data2/greg.noaaerma.org/regional/arctic/django/layerquery/manage.py", line 23, in <module>
    execute_manager(settings)
  File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 459, in execute_manager
    utility.execute()
  File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/data2/greg.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/base.py", line 232, in execute

ranchodeluxe

update-rc.d: using dependency based boot sequencing
Restarting celery periodic task scheduler
Stopping celerybeat... OK
Starting celerybeat...
update-rc.d: using dependency based boot sequencing
Updating cache with layer permissions{}
Traceback (most recent call last):
  File "/data1/regional/atlantic/django/layerquery/manage.py", line 23, in <module>
    execute_manager(settings)
  File "/data1/regional/atlantic/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 459, in execute_manager

ranchodeluxe

gcorradini@long:/data1/regional/southwest/ERMA/conf$ git status
# On branch master
# Your branch is behind 'origin/master' by 26 commits, and can be fast-forwarded.
#
# Changed but not updated:
#   (use "git add <file>..." to update what will be committed)
#   (use "git checkout -- <file>..." to discard changes in working directory)
#
#	modified:   crons/install.sh
#	modified:   ../htdocs/css/erma.css

ranchodeluxe

gcorradini@long:/data1/regional/arctic/tests/data_layers$ git status
# On branch master
# Untracked files:
#   (use "git add <file>..." to include in what will be committed)
#
#	../../ERMA/bin/AutoConfigure.pl
#	../../ERMA/bin/ermabackup
#	../../ERMA/bin/ermaexec
#	../../ERMA/bin/ermarestore
#	../../ERMA/htdocs/OpenLayers-2.11/