I would like to generate a buffer (within a limit of 3km ) where the user clicked point. In pgAdmin, select my database and open a query editor and create 2 PostGIS functions (UTM Zone Function and ST_Buffer_Meters Function)
Used following SQL command to create another column in to my table. my table is “schools” with lat and lon fields. ALTER TABLE schools ADD COLUMN geom_buffer geometry(POLYGON,4326);
but appear error: type modifier is not allowed for type 'geometry'
Why is that..??/ Pls. help me anyone. ..