bajar peso a geojson

crea_json.php

 <?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Crea conexion
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

lista_entidad( $conn, "tabla", "geojson");

$conn->close();
/*
 Crea un archivo geojson por cada entidad que se le envie
*/
function crea_json( $file, $tabla, $contenido){
 $myfile = fopen($file, "w") or die("Unable to open file!");
 fwrite($myfile, '{ "type": "MultiPolygon", "coordinates": [[['.$contenido.']]]}');
 fclose($myfile);
}


/*
 Recorre la tabla por cada entidad
*/
function lista_entidad( $conn, $tabla, $campo){
 $sql = "SELECT * FROM $tabla";
 $result = $conn->query($sql);

 if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
		crea_json( $row["id"].".json", "", $row[$campo] );
    }
 } else {
    echo "0 results";
 }
}
?> 

precision.sh

#!/bin/bash

echo "">departamentos.sql

for entry in *.json
do
  out=$entry"_o.json"
  echo ".bin/geojson-precision -p 7 $entry geojson/$entry" | bash
done

for entry in geojson/*.json
do
  json="$(cat $entry)"
  id="${entry##*/}"
  id="${id%.*}"
  echo " UPDATE tabla SET geojson_7 = '$json' WHERE id = $id; ">>departamentos.sql
done

mysql -u USER -pPASSWORD BASE < departamentos.sql