Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Some title</title>
- <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet- 0.7.3/leaflet.css"/>
- <script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"> </script>
- <script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
- <script src="proj4.js"></script>
- <script src="proj4leaflet.js"></script>
- <style>
- #map{ height: 100% }
- </style>
- </head>
- <body>
- <div id="map"></div>
- <script>
- // initialize the map
- var map = L.map('map').setView([42.59, -111.99], 14);
- // load a tile layer
- L.tileLayer("http://{s}.mqcdn.com/tiles/1.0.0/osm/{z}/{x}/{y}.png",
- {
- maxZoom: 17,
- minZoom: 9,
- subdomains: ["otile1", "otile2", "otile3", "otile4"],
- }).addTo(map);
- //load GeoJSON from an external file
- $.getJSON("getdata1.php",function(tmData){
- L.geoJson( tmData, {
- style: function(feature){
- var fillColor,
- GIS_ACRES = feature.properties.GIS_ACRES;
- if ( GIS_ACRES > 20 ) fillColor = "#006837";
- else if ( GIS_ACRES > 10 ) fillColor = "#31a354";
- else if ( GIS_ACRES > 5 ) fillColor = "#78c679";
- else if ( GIS_ACRES > 2 ) fillColor = "#c2e699";
- else if ( GIS_ACRES > 0 ) fillColor = "#ffffcc";
- else fillColor = "#f7f7f7"; // no data
- return { color: "#999", weight: 1, fillColor: fillColor, fillOpacity: .6 };
- }
- }) .addTo(map);
- });
- </script>
- </body>
- <?php
- ini_set('display_errors', 1);
- //database login info
- $host = 'localhost';
- $port = '5432';
- $dbname = 'thndr';
- $user = 'postgres';
- $password = 'somepassword';
- $conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$somepassword");
- if (!$conn) {
- echo "Not connected : " . pg_error();
- exit;
- }
- $sql = "
- SELECT row_to_json(fc)
- FROM (SELECT 'FeatureCollection' AS type, array_to_json(array_agg(f)) As features
- FROM (SELECT 'Feature' AS type
- ,ST_AsGeoJSON(ST_Transform(lg.geom,4326))::json AS geometry -- lg.geom=geometry column
- ,row_to_json((SELECT l FROM (SELECT parcel_own, gis_acres) AS l )) AS properties FROM tm
- AS lg
- WHERE 1=1
- LIMIT 1
- ) AS f
- ) AS fc;
- ";
- //send the query
- if (!$response = pg_query($conn, $sql)) {
- echo "A query error occured.n";
- exit;
- }
- //echo "<pre>";
- //echo the data back to the DOM
- header('Content-Type: application/json');
- while ($row = pg_fetch_row($response)) {
- foreach ($row as $i => $attr){
- echo $attr;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement