• Ivy Seo
    • Mar 20, 2020

Geometry point - postgis



// add geom column
cmd.CommandText = "alter table m7_data_table add column geom geometry(point,4326)";
 cmd.ExecuteNonQuery();
// update geom column -- combine lon and lat
cmd.CommandText = "UPDATE m7_data_table SET geom = ST_SetSRID(ST_Makepoint(Lat,Lon),4326) where geom isnull";
cmd.ExecuteNonQuery();


** to use geometry:

> CREATE EXTENSION IF NOT EXISTS postgis;";

0 comments

Recent Posts

See All

Generate unique filename: UUID, Path

A: using UUID let my_uuid = Uuid::new_v4(); let file_created = File::create(my_uuid.to_string()).expect("create file failed");     println!("uuid: {}", my_uuid); //  buffer write let mut file_ge

0

JSON - write .txt file in Rust

pub fn serialize_writeFile(data : &full_data ) -> Result<bool, modbus::Error> { // 1) takes data  // this function takes the m7_data object and serializes the contents and saves the results to a text

0

Serialize/Deserialize JSON in Rust

This README has some good examples. To deserialize in Rust: use serde::{Deserialize, Serialize}; use serde_json::Result; #[derive(Serialize, Deserialize)] struct Person {     name: String,     age: u

0