meta user
network profile
|
Jan 4 |
comment |
How to add more events like Control.Click and Handler.Point for a single variable in OpenLayers Please clarify more your question. I could not understand what you want. Your sample could looks like truncated. |
|
Jan 4 |
answered | Modify existing library from OpenLayers (ZoomToMaxExtent) |
|
Dec 28 |
comment |
Update a newly added column of a table using ST_Intersection as a filter Please report the count of rows into your roads table: select count(*) from roads to know if it is too many roads the problem. Could you delete road outside country named 'Sudan'? Also how did you loaded the countries into database? Did you used the shp2pgsql to create sql file ? |
|
Dec 27 |
comment |
Chart inside pop up window in Javascript So the openPopup() is asynchronous? Because Javascript interpreter will not execute the next statement until the previous return except for callbacks that are executed later on time. An alternative if no event would be execute pooling for the existance of that "div" in a window.setTimeout loop. The event callback would be much more fast. |
|
Dec 27 |
awarded | Editor |
|
Dec 27 |
comment |
Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function) OK so I replaced the st_centroid with the && boundbox operator. I not pretty sure this is completely right but if there is one or two geometries that has boundbox intersects so they are the closer one choices. But in case of no boudbox intersections do not this should be excluded due to this filter? |
|
Dec 27 |
revised |
Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function) deleted 74 characters in body |
|
Dec 27 |
awarded | Commentator |
|
Dec 27 |
comment |
Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function) So, do you agree that the top query is not equivalent to bottom query? Since the order will change because the operator <-> will ORDER BY st_centroid and the st_distance will give you a differente value? Different order can bring a different query as the first row to pass on DISTINCT ON clause? The valid query would be bottom one that needs speed improvement? |
|
Dec 27 |
comment |
ShapeFile or feature class to json I guess you write on language name avenue. |
|
Dec 27 |
comment |
Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function) But the postgis manual for the operator <-> states that it uses centroid for non point geometries. So my solution would give you similar results. It should give you same results as your top query. Please check that results with the operator <-> are correct also. It reported me zero length geometries on my test data so the results of it could be broken and this solution given more accurate data. If you able to post some sample records showing errors at some pastie site we could discover flaws on solution. |
|
Dec 27 |
answered | ShapeFile or feature class to json |
|
Dec 27 |
answered | Chart inside pop up window in Javascript |
|
Dec 27 |
comment |
Spring and Openlayer conflicts on label rendering? You ca use the "value" of attribute name as the label with the following as already explained on answer: 'label': '${name}'. This will make OpenLayers search for the property name into feature been drawed. |
|
Dec 27 |
comment |
vehicle tracking system in postgresql performance 10.000 rows should be nothing to Postresql to scan. In trigger you should put all the logic to make data entry and dependencies resolved in function of the new data arrived. If the new row at given table would change a distance value at another table them this should be put in trigger. Take care that something wrong at any trigger function will abort all operations. So do validation at very begin to avoid undoing lots of stuff. Function names also define trigger calling order. |
|
Dec 26 |
answered | What in-depth spatial database systems tutorials exist? |
|
Dec 26 |
comment |
vehicle tracking system in postgresql performance 1 - Trigger MUST run fast. To do a distance update you only need calculate the distance from latest point and store the sum into distance field. Very simple if you have the last point at latest_information table. That should all be done inside the trigger. 2 - PHP will be slower since it will need to call database and wait it to process then send another statement wait. So use PHP to unpack data from client into fields and call the database to do the calculations with the field data. |
|
Dec 26 |
comment |
How to work with GDAL/OGR in Tomcat? I think is not needed to add thsoe directories to the PATH environment variable. You could try inspect Tomcat log files to see if it logged some additional exception details about why it could not lod the library. Also Tomcat is like any other Java application. You can simulate the class loading by creating a simple java program that make a call to a gdal function. |
|
Dec 25 |
comment |
How to work with GDAL/OGR in Tomcat? You need the equivalent of those files in Windows. They are *.dll. |
|
Dec 24 |
answered | Creating a vector based design from a raster database |
