terpolate_point
>
> HTH
> r.b.
> On Friday, August 17, 2012, James David Smith wrote:
>>
>> Hi everyone,
>>
>> I'm flirted around this problem for a while, so I hope I'm not bein
>> annoying by being repetative, but I've been tearing my
Hi everyone,
I'm flirted around this problem for a while, so I hope I'm not bein
annoying by being repetative, but I've been tearing my hair out trying to
do it. The problem is that I have a file of lines (geometry). in a table
called temp4 The format of the table is, simplified,
line
start_time
erate the output in the Openlayers format (some basic
> functionality). But, if you need some extra interactivity (client side
> functionality) with the maps, you have to enrich the generated output with
> extra coding ...
>
> Imran
>
> --- On Wed, 8/17/11, James David Smith
ore about how WMS, WFS, WCS worked and how
>>> different http request formats could be tested so installed
>>> Geoserver. But I then needed sample data in the background
>>> on which Geoserver could operate so downloaded PostGIS.
>>> Getting that up and running is
Dear all,
Bit of a geneal question this rather than something specific, but I've
been following a few of the other queries on here talking about Open
Layers, Geoserver and Google Maps, and it's reminded me that I really
want to try and learn how to connect/convert my local PostGIS database
into so
Hey Vishal,
I guess really you should just re-project on the fly so that you don't
have the same data in two columns, but like you I have created another
column in the project I'm working on at the moment for convenience. I
did it like this:
SELECT AddGeometryColumn ('wards', 'geom_utm','32643','
Hey Nicholas,
I'm a newbie, but just to say that I've used the 'Spit' tool within
QGIS to load shapefiles into PostGIS - mght be worth a look. You can
also then load the table into QGIS once it is in the system to see if
it has stored it correctly?
James
On 30 July 2011 15:17, Nicolas ( cse )
w
Dear pvaldes,
Have you tried to do this with type 'geometry' instead of 'geography' ?
James
On 21 July 2011 13:42, p valdes wrote:
> Hi,
> I'm trying to calculate the area of a polygon, with strange results...
>
> First a description of the problem, the ugly details at the end of the post
>
>
store... though I guess you've seen it
already...
http://postgis.refractions.net/docs/ch04.html
Cheers
James
On 20 July 2011 20:27, Mats Taraldsvik wrote:
> Hi,
>
> On 07/20/2011 08:53 PM, James David Smith wrote:
>>
>> Hey Mats,
>>
>> I'm just a new
Hey Mats,
I'm just a newbie, so don't really have an answer for you I'm afraid,
but if a Polygon has a curved line, then it isn't a Polygon I don't
think. Polygons have only straight lines.
Am quite curious what the answer is to your query though... ! Good luck.
James
On 20 July 2011 19:48, Mat
YJ,
I'm a beginner, so take with a pinch of salt, but first I'd question
why you want/need to separate the latitude & longitude?
I would keep them together and store them as a point in a new column.
First create a column to store the Lat & Long in with something like
this:
SYNTAX:SELECT AddG
hank you!
> Yes I do have both of those datasets. I'll run the spatial join that way and
> see what happens.
> *fingers crossed*
>
>
>
> On Jul 11, 2011, at 5:20 AM, James David Smith
> wrote:
>
>> Hey Rich,
>>
>> I'm a newbie myself, but it seems
Hey Rich,
I'm a newbie myself, but it seems to me that you either need a table
that defines the geometry of the continents (so that you can do a
spatial join with the points), or the points table itself needs a
column which tells you in which continent that point is located. Do
you have either of
El Domingo 03 Julio 2011, James David Smith escribió:
> > Dear all,
> >
> > I have a table of GPS points which are the locations of vehicles every
> > 15 seconds. Each journey that a car makes has an ID. For example a
> > taxi is on 'job 1' and has 50 points w
Dear all,
I have a table of GPS points which are the locations of vehicles every
15 seconds. Each journey that a car makes has an ID. For example a
taxi is on 'job 1' and has 50 points while it does this job, and then
another 50 or 60 when it is on 'job 2' etc. What I would like to do
however is i
Hi,
I'm a novice, but shouldn't it be something like this... ?
UPDATE table SET geom = ST_SetSRID(geom, 4326)
Cheers
James
On 16 June 2011 09:23, Andreas Forø Tollefsen wrote:
> Hi,
>
> I have merged 4 tables with line geometry. In total 1028110 rows.
> However, when i had unionized the table
prove that you would consider using it?
>
> Thanks,
> Andreas
>
> On Thu, 16 Jun 2011 12:23:13 +0100, James David Smith wrote:
>>
>> Dear all,
>>
>> Thank you so much for your help.
>>
>> shp2pgsql - I didn't realise it automaticaly renamed co
zing-postgis-queries-in-qgis-using-rt-sql-layer-plugin/
>
> No need to buy a $10,000 proprietary desktop GIS...
>
> David.
>
> On Wed, Jun 15, 2011 at 1:33 PM, James David Smith
> wrote:
>> Dear Cristian & David,
>>
>> Thanks alot for your responses.
>
ediate'
> AND date_time_of_arrival - date_time_unit_assigned > '00:12:00'
>
> Note: you will need to specify the names of the columns that you are
> interested in.
>
>
> On Wed, Jun 15, 2011 at 12:58 PM, James David Smith
> wrote:
>> Dear all,
>
Dear all,
I appreciate that this is more of a QGIS query, but I think that the
route of the problem might be in PostGIS, so... I have opened QGIS and
ran the query on my PostGIS table as below:
SELECT * FROM incidents
WHERE urgency = 'Immediate'
AND date_time_of_arrival - date_time_unit_assigned
Dear Paolo,
Can you give me more information about the 'RT SQL layer plugin' you
mention please? I use GQIS to visualise my data from PostGIS
sometimes, but do find the query tool a bit limited and wonder whether
this might be the solution...?
Thanks
James
On 15 June 2011 10:04, Paolo Cavallini
Hi all,
Would love some help with this update query please. I have two tables
with three columns...
Table: vehicles
Columns: date, incident, incident_link
Table: incident
Columns: date, incident, key
What I would like to do is when the columns 'incident.date' AND
'incident.incident' match both
22 matches
Mail list logo
