Advertisement
Guest User

Untitled

a guest
Mar 8th, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1. var map,
  2. fields = ["gid", "createdby", "featname", "feattype", "status", "acres"],
  3. autocomplete = [];
  4. function getData(){
  5. $.ajax("php/getData.php", {
  6. data: {
  7. table: "fracsandsites",
  8. fields: fields
  9. },
  10. success: function(data){
  11. mapData(data);
  12. }
  13. })
  14.  
  15. <?php
  16. ini_set('display_errors', 1);
  17.  
  18. //database login info
  19. $host = 'localhost';
  20. $port = '5432';
  21. $dbname = 'sandwikimap2';
  22. $user = 'postgres';
  23. $password = 'postgis';
  24.  
  25. $conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password");
  26. if (!$conn) {
  27. echo "Not connected : " . pg_error();
  28. exit;
  29. }
  30.  
  31. //get the table and fields data
  32. $table = $_GET['table'];
  33. $fields = $_GET['fields'];
  34.  
  35. //turn fields array into formatted string
  36. $fieldstr = "";
  37. foreach ($fields as $i => $field){
  38. $fieldstr = $fieldstr . "l.$field, ";
  39. }
  40.  
  41. //get the geometry as geojson in WGS84
  42. $fieldstr = $fieldstr . "ST_AsGeoJSON(ST_Transform(l.geom,4326))";
  43.  
  44. //create basic sql statement
  45. $sql = "SELECT $fieldstr FROM $table l";
  46.  
  47. //if a query, add those to the sql statement
  48. if (isset($_GET['featname'])){
  49. $featname = $_GET['featname'];
  50. $distance = $_GET['distance'] * 1000; //change km to meters
  51.  
  52. //join for spatial query - table geom is in EPSG:26916
  53. $sql = $sql . " LEFT JOIN $table r ON ST_DWithin(l.geom, r.geom, $distance) WHERE r.featname = '$featname';";
  54. }
  55.  
  56. <?php
  57.  
  58. //database login info
  59. $host = 'localhost';
  60. $port = '5432';
  61. $dbname = 'thndr';
  62. $user = 'postgres';
  63. $password = 'somepassword';
  64.  
  65. // connect to database
  66. $conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password");
  67. if (!$conn) {
  68. echo "Not connected : " . pg_error();
  69. exit;
  70. }
  71. //get the data
  72. $propBoundaries = $_GET['tm4326'];
  73. $flagPoints = $_GET['tmxy4326'];
  74.  
  75. //turn propertyBoundaries array into formatted string
  76. $propBoundaries = "";
  77. foreach ($propBoundaries as $i => $propBoundary){
  78. $propBoundaries = $propBoundaries . "l.$propBoundary, ";
  79. }
  80.  
  81. //get the geometry as geojson in WGS84
  82. $propBoundaryDatastr = $propBoundarystr . "ST_AsGeoJSON(ST_Transform(l.geom,4326))";
  83.  
  84. //turn PropertyPoints array into formatted string
  85. $flagPoints = "";
  86. foreach ($flagPoints as $i => $flagPoint){
  87. $flagPoints = $flagPoints . "l.$flagPoint, ";
  88. }
  89.  
  90. //get the geometry as geojson in WGS84
  91. $flagPoints = $flagPoints . "ST_AsGeoJSON(ST_Transform(l.geom,4326))";
  92.  
  93. //create basic sql statement
  94. $sql = "SELECT *
  95. from $propBoundaries.l
  96. inner join $flagPoints.l
  97. on $propBoundaries.gid=$flagPoints.gid";
  98.  
  99. echo $sql;
  100.  
  101. //send the query
  102. if (!$response = pg_query($conn, $sql)) {
  103. echo "A query error occured.n";
  104. exit;
  105. }
  106.  
  107. //echo the data back to the DOM
  108. while ($row = pg_fetch_row($response)) {
  109. foreach ($row as $i => $attr){
  110. echo $attr.", ";
  111. }
  112. echo ";";
  113. }
  114.  
  115. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement