Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Some title</title>
  4. <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet- 0.7.3/leaflet.css"/>
  5. <script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"> </script>
  6. <script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
  7. <script src="proj4.js"></script>
  8. <script src="proj4leaflet.js"></script>
  9. <style>
  10. #map{ height: 100% }
  11. </style>
  12. </head>
  13. <body>
  14.  
  15. <div id="map"></div>
  16.  
  17. <script>
  18. // initialize the map
  19. var map = L.map('map').setView([42.59, -111.99], 14);
  20.  
  21. // load a tile layer
  22. L.tileLayer("http://{s}.mqcdn.com/tiles/1.0.0/osm/{z}/{x}/{y}.png",
  23. {
  24. maxZoom: 17,
  25. minZoom: 9,
  26. subdomains: ["otile1", "otile2", "otile3", "otile4"],
  27. }).addTo(map);
  28.  
  29. //load GeoJSON from an external file
  30.  
  31. $.getJSON("getdata1.php",function(tmData){
  32. L.geoJson( tmData, {
  33. style: function(feature){
  34. var fillColor,
  35. GIS_ACRES = feature.properties.GIS_ACRES;
  36. if ( GIS_ACRES > 20 ) fillColor = "#006837";
  37. else if ( GIS_ACRES > 10 ) fillColor = "#31a354";
  38. else if ( GIS_ACRES > 5 ) fillColor = "#78c679";
  39. else if ( GIS_ACRES > 2 ) fillColor = "#c2e699";
  40. else if ( GIS_ACRES > 0 ) fillColor = "#ffffcc";
  41. else fillColor = "#f7f7f7"; // no data
  42. return { color: "#999", weight: 1, fillColor: fillColor, fillOpacity: .6 };
  43. }
  44. }) .addTo(map);
  45. });
  46. </script>
  47. </body>
  48.  
  49. <?php
  50. ini_set('display_errors', 1);
  51.  
  52. //database login info
  53. $host = 'localhost';
  54. $port = '5432';
  55. $dbname = 'thndr';
  56. $user = 'postgres';
  57. $password = 'somepassword';
  58.  
  59. $conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$somepassword");
  60. if (!$conn) {
  61. echo "Not connected : " . pg_error();
  62. exit;
  63. }
  64. $sql = "
  65. SELECT row_to_json(fc)
  66. FROM (SELECT 'FeatureCollection' AS type, array_to_json(array_agg(f)) As features
  67. FROM (SELECT 'Feature' AS type
  68. ,ST_AsGeoJSON(ST_Transform(lg.geom,4326))::json AS geometry -- lg.geom=geometry column
  69. ,row_to_json((SELECT l FROM (SELECT parcel_own, gis_acres) AS l )) AS properties FROM tm
  70. AS lg
  71. WHERE 1=1
  72. LIMIT 1
  73. ) AS f
  74. ) AS fc;
  75. ";
  76.  
  77. //send the query
  78. if (!$response = pg_query($conn, $sql)) {
  79. echo "A query error occured.n";
  80. exit;
  81. }
  82. //echo "<pre>";
  83. //echo the data back to the DOM
  84.  
  85. header('Content-Type: application/json');
  86. while ($row = pg_fetch_row($response)) {
  87. foreach ($row as $i => $attr){
  88. echo $attr;
  89. }
  90. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement