Reputation
5,686
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
15 39
Impact
~143k people reached

1d
comment Isochrones for public transport
@Spacedman I didn't catch that... thanks.
1d
comment How can I strip spaces from a moustache template field in CartoDB infowindow?
Perhaps you can create a new column and use SQL to do this? postgresql.org/docs/current/static/functions-string.html
Feb
5
comment Field calculator if and elseif statement with <Null> values in ArcGis 10.1
Another great reason to learn PostGIS...so python doesn't have to do the job that SQL was meant to do...
Jan
30
comment Adding more than one legend in QGIS Print Composer?
@hilldawg-co do you have any data you can share?
Jan
28
comment Adding more than one legend in QGIS Print Composer?
how are you displaying 2 different maps with 2 different renderings on the same layer? That sounds like it wouldn't work though...
Jan
27
comment Alternatives to pgRouting
@dassouki all GIS data is essentially nodes and links, and tools like osm2pgrouting, and other pgRouting scripts in general, convert existing GIS / spatial data into the necessary nodes and links and edges that are used in pgRouting...
Jan
26
comment Converting OSGB easting and northing to geometry on the fly in SQL Server 2008 R2
this saved the DAY!
Jan
25
comment Upgrading from Qgis 2.4 to 2.12 on Ubuntu 15.04
What version do you have in your repository? I do a 'sudo apt-get update && sudo apt-get upgrade' and I get the newest version from the QGIS repository (vs. the UBUNTUGIS repo...)
Jan
22
comment How to handle large amounts of points
@bcollins Interesting - how customizable is that? And - are the pixels generated by analyzing the data on the client?
Jan
22
comment Unable to install pgrouting for postgres 9.3.5/postgis 2.1.7
Try these instructions - but they are for v9.4 trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt
Jan
22
comment Import Large Shapefile to Postgres
What tool are you using to do this? have you tried shp2pgsql? What server type are you using?
Jan
20
comment How to cast geometry to varbinary in PostGIS / PostgreSQL
well I had to live with another solution, but thanks for posting this info!
Jan
20
comment How to cast geometry to varbinary in PostGIS / PostgreSQL
gotcha... thanks!!!
Jan
20
comment How to cast geometry to varbinary in PostGIS / PostgreSQL
A feature in postgres binary gives: "\x01010000000bdb8621a8415ac049c02725b1d64340" while the same feature in MSSQL gives: "0x3D0B0000010C6019954006E8474180E2C554F4823941" ... hmmm...
Jan
20
comment How to cast geometry to varbinary in PostGIS / PostgreSQL
Almost the same, isn't it...? Seems the \ in the postgres version replaces the 0 in the MSSQL Version? Going to test this out -and figure out how to replace the \ with 0 - thank you!!!
Jan
16
comment Adding more information to a PostGIS table via QGIS
oh you're talking about copying features into a similar table rather than adding columns ... you're right then, that's the GUI method in QGIS - you can use the same method I described above and use an INSERT statement in PGAdmin...
Jan
16
comment How to install QGIS on Ubuntu 12.04?
The instructions on the QGIS website work well: qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu just pick your Ubuntu release name...
Jan
15
comment How to convert from SQL Server geometry BLOB to something else?
@Peter did you ever find any of these a solution for your issue?
Jan
15
comment Moving labels manually using expression in QGIS?
@Pie_Staff just a reminder to mark this as your answer if you could... thanks!!!
Jan
14
comment Adding Excel file with degrees to map with CRS in QGIS?
give an example of what your X,Y looks like in Excel... if they're already in decimal degrees, you can save your Excel to a CSV and add it easily...