Hi Chandler,
Did you check projection system of the both Geometries? Just to make sure, use
ST_TRANSFORM as inner function.
regards
Muhammad Imran
--- On Fri, 8/3/12, CHANDLER DOUGLAS COLEMAN
wrote:
From: CHANDLER DOUGLAS COLEMAN
Subject: [postgis-users] area and distance
To: "po
n"
> Date: Tuesday, January 3, 2012, 4:16 PM
> Thanks Imran,
>
> That was also in my mind, but thought I could have less
> steps to
> complete the import.
>
>
> -Lauri
>
>
> On Tue, Jan 3, 2012 at 11:50 AM, Nithya lakshmi
>
> wrote:
> > how to
Hi Lauri,
1- Disable or remove unique key (UK) on table.
2- Import data using shp2pgsql
3- remove duplicate rows using SQL
DELETE
FROMsometable
WHERE someuniquekey NOT IN
(SELECT MAX(dup.someuniquekey)
FROMsometable As dup
GROUP BYdup.dupco
Hi Pierre,
You can try st_collectionextract(geometry, integer) to extract polygon
geometery by specifying (3 == POLYGON as integer), given your
GEOMETRYCOLLECTION of points, lines and polygons.
Regards,
Muhammad Imran
ITC, The Netherlands
--- On Thu, 11/24/11, Pierre Racine wrote:
> F
))
Regards,
Muhammad Imran
PhD Student
ITC, University of Twente
CREATE OR REPLACE FUNCTION "Burkina_Faso"."BF_NN_MARKET_CAL"() RETURNS boolean
AS'
DECLARE
i integer;
result text;
BEGIN
FOR i in (select gid from "Burkina_Faso"."BF_VILLAG
))
Regards,
Muhammad Imran
PhD Student
ITC, University of Twente
CREATE OR REPLACE FUNCTION "Burkina_Faso"."BF_NN_MARKET_CAL"() RETURNS boolean
AS'
DECLARE
i integer;
result text;
BEGIN
FOR i in (select gid from "Burkina_Faso"."BF_VILLAG
centroid on the shortest line e.g.
st_centroid(st_shortestline(geometry, geometry))
Regards,
Muhammad Imran
PhD Student
ITC, University of Twente
CREATE OR REPLACE FUNCTION "Burkina_Faso"."BF_NN_MARKET_CAL"() RETURNS boolean
AS'
DECLARE
i integer;
result text;
> might be first on my list to try:-)
>
> On 17 August 2011 17:58, muhammad imran
> wrote:
> > James, Geoserver is good option for the beginner
> (windows user), but presently it is less powerful as
> compared to the UMN mapserver. Geosever could also generate
> t
sktop
> > project is fast and easy. However, it only publishes
> WMS (not WFS).
> > Geoserver has the advantage that it is not only a WMS
> server, but also WFS
> > and data export/import. UMN is probably the fastest of
> all three, if speed
> > is an issue, but more c
Agreed with Bruce, Geoeserver or Openlayers are not merely to explore the data
stored in PostGIS. Rather, it is about exploring a theme that is interested for
a certain audience. Therefore, a logical flow is, conceptualize a theme,
conceptualize users, accordingly design database and construct
hi People,
I am trying to import *.tif files into PG. These tif images
are basically the MODIS data (three images covering the
whole study area, pixel size 500m). But, when I try to load
them I got the following error
Error: > Cannot load raster with different pixel size in the same
raster table
hi People,
I am trying to import *.tif files into PG. These tif images are basically the
MODIS data (three images covering the whole study area, pixel size 500m). But,
when I try to load them I got the following error
Error:
Cannot load raster with different pixel size in the same raster table
t; st_snaptogrid
>
> jaspa supports some postgis 1.5 functions: st_geomfromgml,
> st_geomfromkml, st_collectionextract,st_dumppoints.
> The geograpy type is not implemented (planned for next
> release) thats why we said postgis 1.4 compatibily and not
> postgis 1.5.
>
>
&
Dear All,
What are the advantages of JASPA over PostGIS. If anyone can compare both
spatial extensions?
regards,
Imran
--- On Fri, 7/23/10, Jose C. Martinez-Llario wrote:
> From: Jose C. Martinez-Llario
> Subject: [postgis-users] JASPA (JAva SPATial) for PostgreSQL and H2 released.
> HSQLDB
Dear PG community,
Is there any PG stored function or procedure for principle component analysis
on an image, stored in the PG database using WKT Raster extension?
Best regards,
Muhammad Imran
PhD student dept Geoinformation Processing ITC -- International Institute for
Geo-information
update table_name
set column_name= 100;
--- On Fri, 3/27/09, Zia Ahmed wrote:
From: Zia Ahmed
Subject: [postgis-users] Help: NULL to value
To: postgis-users@postgis.refractions.net
Date: Friday, March 27, 2009, 1:15 AM
Hi All,
I have a table where a column (type- numeric) contains severa
Hi John,
In the similar lines as oracle GeoRaster, Xing Lin developed a
raster model for PostGIS named PGRaster. Metadata is
stored as fields of PGRASTER METADATA type with spatial extent
(BBOX) and SRID. Raster value type refers to scale of measurement
that can be nominal, ordinal, interval or ra
Hi RJ,
PostGIS has CHIP data type for raster storage however its very simple and does
not support complex raster operations like oracle Georaster. also its does not
support R-tree, GIST index implicitly and you need to create the geometry
objects explicilty for such index support.
Xing Lin has
Hi Raster People,
Racine proposed model has very much potential to discuss from open source
raster community.
As a raster student I have some comments and I would like have further
comments...
Image manipulation is beyond just storing the band information, pyramid
information and BBOX in a well
Hi Raster People,
WKTRaster: Recine recently proposed to store raster tiles like WKT/WKB geometry
and support the same topological operators for raster and vector intersections
seamlessly. Each tile of image would be stored in tuple with WKTraster data
type just as geometry data type for vector
Pierre, your ideas are extremly valuable and is the ultimate requirement from
today image mining applications from the world of remote sensing and GIS as if
databases really want to provide the raster/vector support. The raster support
inside or outside is I think no more discussion topIc in the
ecision of your geometries.
Refer to this thread:
http://postgis.refractions.net/pipermail/postgis-users/2008-May/019651.html
In the future, I see us leaving this method, but adding an
ST_PrecisionReducer() method.
Cheers,
Kevin
muhammad imran wrote:
> Dear All,
> Can any body share
Dear All,
Can any body share any helping material e.g manual documents, notes, code ,
exampls etc for snapttogrid()function for postGIS. concepts of snaping,
limitations etc things to do for next version regarding snaping.
Kind Regards
imran
___
pos
23 matches
Mail list logo
