Hot answers tagged postgresql
5
You have loaded your data with the wrong SRID. 4269 is lon/lat NAD 83. 4326 is lon/lat WGS 84. They are practically the same projection, and both geographic. Judging from your coordinates, the data is actually in some planar projection, though without knowing extra information (like where you are) I can't even take an informed guess as to which one.
5
My guess is that ST_MakePoint is fastest, but this is easy enough to benchmark with 100k random points.
create temp table points(geom geometry(Point, 4326));
-- repeat the remainder for each <POINT CONSTRUCTOR METHOD>
truncate points;
insert into points(geom)
select <POINT CONSTRUCTOR METHOD>
from generate_series(1,100000);
And here are some ...
4
Learning by doing is my preferred way. And when it comes to spatial statistics, R is getting seriously powerful tool. So if this is an option browse through some course materials, download the data and try it yourself.
Few starting points covering spatial autocorrelation (SA) (and generally speaking handling spatial stuff in R):
Center for Studies in ...
3
I don't believe the Shapefile loader will work in your case. However, PostGIS comes with a raster loading tool called raster2pgsql. This tool will load any GDAL supported raster format into PostGIS Raster. It is a command-line tool so to execute it you just need to run:
raster2pgsql raster_options schema.table_name > output.sql
So, the tool will take ...
3
That file is part of the libpq-dev package:
So try installing libpq-dev which is the development library for postgresql:
sudo apt-get install libpq-dev
3
I think I found my answer :
WITH poly_geom1 AS (SELECT way FROM planet_osm_polygon WHERE id=1),
poly_geom2 AS (SELECT way FROM planet_osm_polygon WHERE id=1),
points1 AS (SELECT (ST_DumpPoints(poly_geom1.way)).* FROM poly_geom1),
points2 AS (SELECT (ST_DumpPoints(poly_geom2.way)).* FROM poly_geom2)
SELECT DISTINCT ...
2
For Ubuntu
sudo apt_get install postgresql postgis postgresql-9.1-postgis
sudo -i -u postgres
createdb postgis
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
psql -d postgis -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql
2
This looks like more of a database install problem than a GIS issue. For that reason, a quick search on our sister Stackexchange site StackOverflow, turned up this question and series of answers:
Postgres could not load library unknown error 14001
Here is the answer that did the trick: http://stackoverflow.com/a/13513473/1388679
It boils down to an ...
2
You should use ST_GeomFromText.
The functions without the ST_ are the older functions, and are being phased out; They are deprecated, and shouldn't be used any more.
2
The && operator has a specific meaning, and the meaning is this: the bounding box of the left argument and the bounding box of the right argument overlap.
If you only want geometries that are fully contained in the envelope, use a function with that meaning, like ST_Contains:
SELECT bg_id, ST_AsGeoJSON(the_geom)
FROM bg
WHERE ...
1
I found the solution. The GeoJSON specification says that the coordinates of a polygon are an array of line strings. Therefore I had to wrap them with additional brackets.
{
"type":"Polygon",
"coordinates":
[
[
[-91.23046875,45.460130637921],
[-79.8046875,49.837982453085],
...
1
Try Vector > Reserch Tools > Then Slect features from the buildings layer that intersect with the base layer.
Then close. Right click on the buildings layer. Save selection as Comma Seperated Value. And that is it I think..
Hopefully on the point here. if not I will remove this as could confuse things.
1
Once again in G.S.exchange, it must be reiterated that the QGIS versions of KyngChaos (1.8.x) and Larry Shaffer (master version) use the standard Apple Python and not the MacPorts Python, nor the Homebrew Python, nor other Python distribution...
More, on Mountain Lion, the default version of Apple Python is 2.7 and not 2.6
You can install whatever you want ...
1
If I understand you correctly here is what you could do:
In the LineJoiner transformer there is a parameter where you can specify a List Name. If you do this then you will end up with list attributes that look like this:
MyList.gid source_author{}. So on a line that was joined where there was more than one author on the two segment you might have:
...
1
I think the only problem you will find are the ports on of the different PostgreSQL. Each instance must listen on a different port. And different installation directory, of course.
A good refence: Change port PostgreSQL
1
First, edit postgresql.conf file so that the server will listen to any address:
In pgAdmin (after connected to your server as postgres or any super user): select menu 'Tools -> Server Configuration -> postgresql.conf'
Double click on 'listen_addresses' line and change 'value' to '*'
Press the 'Save' button , then 'Reload Server to apply configuration ...
Only top voted, non community-wiki answers of a minimum length are eligible
