New answers tagged

2

CartoDB doesn't currently have polygons for city regions, so if you have the city boundaries available you will have to import the boundaries to your CartoDB account and merge them with your current data. You have two options: to use the Merge Datasets option in CartoDB or to run a SQL query. Let me explain the solution in both of them. If you want to use ...


1

The result being returned is the string 'EQUAL', not 'TRUE'. So this query returns the correct result : select a.g3e_fid , b.g3e_fid , SDO_GEOM.RELATE( SDO_CS.MAKE_2D( a.g3e_geometry), 'DETERMINE', SDO_CS.MAKE_2D( b.g3e_geometry), 0.1) "Relation" from gc_fbranch_s a, gc_fsplice_s b where a.g3e_fid = 53455168 and b.g3e_fid = 38274644 ...


1

To find the points distance (buffer) of another point there are two methods that could work: (note my data is stored in Colorado State Plane (feet) EPSG:2877 so I can use 5280 as the buffer distance) Use STIntersects: select points2.* from points1 as p1 , points2 as p2 where p2.shape.STIntersects(p1.shape.STBuffer(5280)) = 1 or STWithin: select ...


1

The solution for this problem was to create a table in oracle with the NULL value and 'No_elements' for tax_type field. I then add an extra ogr2ogr line in my batch file that appends the NULL observation into the existing file geodatabase that is exported in the previous line.


0

The first requirement to speed up the search code is to make sure that the feature class has an attribute index on any fields that are searched by the Query Filter or Definition Query. Anytime you use a LIKE statement with wildcards at both the beginning and the end of a string it will be slow. My queries only use wildcards at the end of the string, which ...


-1

You can use a local db create from a .shp using tile format stored in db called .mbtiles and for spatial querys still use spatialite. You can use ESRI sdk for android for maps visibility.


1

Partitioning is most beneficial when you can couple it with a constraint that will allow the planner to exclude certain child tables entirely from most queries. Unfortunately, this currently isn't possible to do with a spatial constraint, but you might be able to take advantage of it by partitioning roads by country or state, and including the state or ...


1

One other hint is to look at the logfiles for temporary files as spatial queries are sometimes very large memory wise. You can log queries that run longer than for example 2seconds (log_min_duration_statement = 2000ms) and check if there are temporary files generated (log_temp_files =0). If you see any temporary files you can set your working memory higher. ...


4

There are an extremely large number of approaches to clustering, and your question is not answerable, short of writing a textbook describing all possible methods. Therefore, the question I will answer is What information would help me select a clustering method? What is your problem domain? Or, to put it another way, what do the points represent? It could ...



Top 50 recent answers are included