Tag Info

Hot answers tagged

3

I'm not by a computer where I can try this within ArcMap, but try: wf_expression = '"AGE_18_64"' + " >= " + str(wf_value) or, using str.format(): wf_expression = '"AGE_18_64" >= {0}'.format(wf_value) Try that if wf_value is supposed to be a number in the sql query (you don't generally need to enclose numeric values in quotes). If however it ...


2

Why not put your complex query in the database as a view? Technically your question is about M:N relations in QGIS, and it sounds like between your and GrantD71's comments you've concluded that it is not possible. So for your case, and as an answer to your actual question, I'm not sure that this is a better solution, it's just what I'd do. I would either ...


1

You don't need the API. If you want to be sure you run your query, just work from the table view. From some CartoDB documentation (without a direct link for some reason): SQL in CartoDB To perform an SQL query in CartoDB, first load the table from your Dashboard. Once you have opened your table, in the lower right corner of your table you will ...


1

It is possible to do a join and then select by attribute purely in QGIS (without accessing the DB Manager). Add both of the tables you want to join to QGIS. Right click on the layer with geometry and then go to Properties -> Joins -> click the plus sign to bring up the "Add vector join" dialog -> select the layer and field you want to join on. You ...



Only top voted, non community-wiki answers of a minimum length are eligible