Re: [SLUG] A question of databases

From: Maureen (res1ydl9@verizon.net)
Date: Fri Apr 09 2004 - 02:18:24 EDT


Ronan Heffernan wrote:

>>
>>
>>> Ronan,
>>> Didn't I see that GRASS can do layers and it can also read SHP files?
>>> I also believe that it can use the TIGRE data, in which case all of the
>>> street data is in there, you just have to find the street data and
>>> display it.
>>>
>>>
>>
> I have used TIGER (census) data with GRASS, and it can display street
> maps (for that matter, you are supposed to be able to scan-in raster
> maps and use a GRASS tool to calibrate them (click on three known
> points on the map, and tell GRASS their coordinates)). I just wanted
> to make it clear that GRASS will not tell you the street address, it
> will only display a graphic of the street map with the desired point
> plotted (not exactly what a 911 operator wants?)

Basically that is what the cell phone companies are telling us. The
three coordinates would then give a location (within 50 yards) of where
the caller is. With cell phones, unless they are using a cell phone
from there home as there main line, you would not get an address but a
location of where they are in lats and longs, then you could plug the
lats and longs into a database that would put a spot on the map so you
know where they are. It's not perfect but right now we can't even do
that. It's in its infancy here so it would be better than what we have
which is nothing. Moe

>
>>> I am going to have to get GRASS going on a machine and start playing
>>> with it.
>>>
>>> By way I installed RH 9 told it to install the db stuff which is said
>>> it did but then when I try to start either MySQL or PostrgreSQL, using
>>> WebMin (I am remote from the machine that has the db stuff on it) it
>>> comes back saying that it appears that the db has not been installed.
>>>
>>>
>>
> With postgres, you must run 'initdb' to set-up the data directory (and
> the postmaster CANNOT be started as 'root' (it will fail); you
> traditionally start postgres as the user named 'postgres', who must
> also own the database files):
>
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su -c "/usr/local/pgsql/bin/initdb -D/usr/local/pgsql/data" postgres
> su -c "/usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data -i"
> postgres
>
> To open 'psql' (the interactive SQL tool):
> /usr/local/pgsql/bin/psql -Upostgres template1
>
> Note that template1 is the default database. From inside psql, you
> would want to create a new database to work with:
>
> CREATE DATABASE utilpart;
> \c utilpart
> CREATE TABLE trucks (id serial, name text);
> ...
>
>>> This is all new to mew getting a db up and running so I am going to
>>> have to figure out what is going on there.
>>> Chuck Hast
>>>
>>
>
>
> -----------------------------------------------------------------------
> This list is provided as an unmoderated internet service by Networked
> Knowledge Systems (NKS). Views and opinions expressed in messages
> posted are those of the author and do not necessarily reflect the
> official policy or position of NKS or any of its employees.
>

-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:18:03 EDT