Tag Info

New answers tagged

0

If the sql command: Select uri_placeinst, ST_AsText(coord_placeinst) as coord_place_inst From public."NewInfoGeometric" where uri_contesto = %urlcont% and GeometryType(ST_AsText(coord_placeinst)) = %typegeom% and tipofeature=%typefeat% The expression GeometryType(ST_AsText(coord_placeinst)) returns a string perhaps you need ...


0

So it was as simple as checking the list resulting from the split. I hadn't noticed the empty string at the end of the list. That's my 'non existant SQL statement'. Changed sql_llist = sqlFile.split(";") to sql_llist= sqlFile.rstrip(';').split(';') and voilĂ ! Everyday we learn something new. This is what I learned today: Why are empty strings returned ...


1

I have an example here that uses window.open: You can enable the description column in your infowindows in order to retrieve the data from there and avoid the SQL query. layer.on('featureClick', function(e, pos, latlng, data) { cartodb.log.log(e, pos, latlng, data); window.open(data.url); });


0

A registered (non-spatial) view will be of great benefit to solve this problem: Create an Oracle view definition (preferably in the schema where the spatial data are stored) which identifies the distinct dates and ranks them (likely earliest to latest.) CREATE or REPLACE view AB_MINERAL_SALE_DATES_V as SELECT SALE_DATE, row_number() OVER (order ...


1

You can use the following query to union the geometry, find all nodes and split the lines: SELECT row_number() OVER() new_id, geom FROM (SELECT (ST_Dump(ST_Node(ST_Union(the_geom)))).geom geom FROM multilines) a Then you must play a little bit to retrieve the original attributes by joining the previous table on "contains" or "within".


0

Using the Summary Statistics option on the SLID field with "High" values for the Date_ field gave me the most recent records. You can then create concatenated fields on which to base a join, and join the original table to the summary statistics table, thus bringing in all the other relevant fields for the records.


4

I'm having difficulty with the classification of "search by attribute" as a "language". To understand an answer to this startlingly broad question requires understanding of the meanings of a number of computer terms, including: Application software, programming language, data format, user interface, and access paradigm. ArcGIS is application software. It ...


1

I see what you are asking for. Unfortunately the MapInfo SQL syntax doesn't support "tableA.*". You can only select all columns from both tables or specific columns. I see three workarounds Select all columns and then modify the table structure afterwards where you can remove the extra columns you don't want If your table structure is somewhat static, you ...


0

CartoDB doesn't allow by default direct connections to the user databases to external databases. If you're not an enterprise customer, perhaps the Foreign Data Wrappers that CartoDB offers, as said in the comment, are not interesting to you. The best approach would be connecting your database with the CartoDB SQL API so that you're able to maintain both ...


1

The problem here is you are converted the FID (objectID field type) value to string which should be a numeric value within the expression, try this: with arcpy.da.UpdateCursor('Sales_lyr', ["BOROUGH", "FID", "COUNT"]) as cursor: for row in cursor: expression = '"FID" = {}'.format(row[1]) ...



Top 50 recent answers are included