API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
253
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.33 KB | None | 0 0
raw download clone embed print report
  1. ERROR: relation "placex" does not exist at character 152
  2. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.53065333333,10.7641),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.53065333333,10.7641),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.53065333333,10.7641),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  3. ERROR: relation "placex" does not exist at character 160
  4. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93838333333,10.633383333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93838333333,10.633383333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93838333333,10.633383333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  5. ERROR: relation "placex" does not exist at character 155
  6. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.567595,10.739673333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.567595,10.739673333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.567595,10.739673333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  7. ERROR: relation "placex" does not exist at character 160
  8. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  9. ERROR: relation "placex" does not exist at character 160
  10. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  11. ERROR: relation "placex" does not exist at character 160
  12. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(120.99722433333,14.522810166667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  13. ERROR: relation "placex" does not exist at character 153
  14. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54139833333,10.74367),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54139833333,10.74367),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54139833333,10.74367),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  15. ERROR: relation "placex" does not exist at character 154
  16. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93969666667,10.676625),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93969666667,10.676625),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93969666667,10.676625),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  17. ERROR: relation "placex" does not exist at character 154
  18. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  19. ERROR: relation "placex" does not exist at character 154
  20. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33906,11.632648333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  21. ERROR: relation "placex" does not exist at character 155
  22. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  23. ERROR: relation "placex" does not exist at character 155
  24. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  25. ERROR: relation "placex" does not exist at character 155
  26. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(124.672545,8.4797633333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  27. ERROR: relation "placex" does not exist at character 153
  28. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.67000166667,11.31277),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.67000166667,11.31277),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.67000166667,11.31277),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  29. ERROR: relation "placex" does not exist at character 160
  30. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  31. ERROR: relation "placex" does not exist at character 160
  32. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33847333333,11.633491666667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  33. ERROR: relation "placex" does not exist at character 154
  34. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.58120833333,10.698575),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.58120833333,10.698575),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.58120833333,10.698575),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  35. ERROR: relation "placex" does not exist at character 160
  36. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.52400833333,10.783211666667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.52400833333,10.783211666667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.52400833333,10.783211666667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  37. ERROR: relation "placex" does not exist at character 160
  38. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  39. ERROR: relation "placex" does not exist at character 160
  40. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  41. ERROR: relation "placex" does not exist at character 160
  42. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54139166667,10.743503333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  43. ERROR: relation "placex" does not exist at character 160
  44. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.52184166667,10.713528333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.52184166667,10.713528333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.52184166667,10.713528333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  45. ERROR: relation "placex" does not exist at character 160
  46. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  47. ERROR: relation "placex" does not exist at character 160
  48. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93623333333,10.634068333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  49. ERROR: relation "placex" does not exist at character 154
  50. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(123.95681333333,10.314465),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(123.95681333333,10.314465),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(123.95681333333,10.314465),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  51. ERROR: relation "placex" does not exist at character 160
  52. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.52609166667,10.757228333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.52609166667,10.757228333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.52609166667,10.757228333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  53. ERROR: relation "placex" does not exist at character 155
  54. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(120.823425,13.926223333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(120.823425,13.926223333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(120.823425,13.926223333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  55. ERROR: relation "placex" does not exist at character 154
  56. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  57. ERROR: relation "placex" does not exist at character 154
  58. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.33705,11.635708333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  59. ERROR: relation "placex" does not exist at character 160
  60. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.53079833333,10.763668333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.53079833333,10.763668333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.53079833333,10.763668333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  61. ERROR: relation "placex" does not exist at character 160
  62. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(121.00540333333,14.704911666667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(121.00540333333,14.704911666667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(121.00540333333,14.704911666667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  63. ERROR: relation "placex" does not exist at character 160
  64. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(120.81920833333,13.925183333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(120.81920833333,13.925183333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(120.81920833333,13.925183333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  65. ERROR: relation "placex" does not exist at character 155
  66. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(121.950835,11.926428333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(121.950835,11.926428333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(121.950835,11.926428333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  67. ERROR: relation "placex" does not exist at character 160
  68. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(123.92702166667,10.321608333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(123.92702166667,10.321608333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(123.92702166667,10.321608333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  69. ERROR: relation "placex" does not exist at character 153
  70. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  71. ERROR: relation "placex" does not exist at character 153
  72. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93495166667,10.63453),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  73. ERROR: relation "placex" does not exist at character 154
  74. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(123.95647,10.314276666667),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(123.95647,10.314276666667),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(123.95647,10.314276666667),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  75. ERROR: relation "placex" does not exist at character 154
  76. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.52576166667,10.757455),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.52576166667,10.757455),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.52576166667,10.757455),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  77. ERROR: relation "placex" does not exist at character 160
  78. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.76260333333,11.589613333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.76260333333,11.589613333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.76260333333,11.589613333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  79. ERROR: relation "placex" does not exist at character 153
  80. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  81. ERROR: relation "placex" does not exist at character 153
  82. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.54142166667,10.74314),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  83. ERROR: relation "placex" does not exist at character 155
  84. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.567565,10.739753333333),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.567565,10.739753333333),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.567565,10.739753333333),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  85. ERROR: relation "placex" does not exist at character 153
  86. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  87. ERROR: relation "placex" does not exist at character 153
  88. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.93485333333,10.63459),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  89. ERROR: relation "placex" does not exist at character 149
  90. STATEMENT: select place_id,parent_place_id,rank_search,country_code, ST_distance(ST_SetSRID(ST_Point(122.364265,11.706355),4326), geometry) as distance FROM placex WHERE ST_DWithin(ST_SetSRID(ST_Point(122.364265,11.706355),4326), geometry, 0.0008) AND rank_search != 28 and rank_search >= 28 and (name is not null or housenumber is not null or rank_search between 26 and 27) and class not in ('waterway','railway','tunnel','bridge','man_made') and indexed_status = 0 and linked_place_id is null and (ST_GeometryType(geometry) not in ('ST_Polygon','ST_MultiPolygon') OR ST_DWithin(ST_SetSRID(ST_Point(122.364265,11.706355),4326), centroid, 0.0008)) ORDER BY distance ASC limit 1
  91. ERROR: index "idx_osm_id" does not exist
  92. STATEMENT: DROP INDEX public.idx_osm_id;
  93.  
  94. ERROR: constraint "pagelinks_pkey" of relation "wikipedia_article" does not exist
  95. STATEMENT: ALTER TABLE ONLY public.wikipedia_article DROP CONSTRAINT pagelinks_pkey;
  96.  
  97. ERROR: role "brian" does not exist
  98. STATEMENT: ALTER TABLE public.wikipedia_article OWNER TO brian;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!