Well, it would be good to know in which direction you are moving... :)
Spatial databases have spatial columns and spatial functions. So, how
would we go about making the following postgis examples into a DAL-
able form without slipping to _execute ? How do we insert a geometry ?
How do we use validators with geometry columns ? The basic selects
themselves should not be that problematic (a few of the simplest
postgresql examples from
http://www.spatial.cs.umn.edu/Book/labs/vania/spatialQueries.html
):
create table city (gid int4 , AREA float8, PERIMETER float8, CITIES_
numeric(38,9), CITIES_ID numeric(38,9), CITY_NAME varchar, GMI_ADMIN
varchar, ADMIN_NAME varchar, FIPS_CNTRY varchar, CNTRY_NAME varchar,
STATUS varchar, POP_RANK int4, POP_CLASS varchar, PORT_ID int4);
select AddGeometryColumn('vbogorny','city','the_geom','-1','POINT',2);
create table river (gid int4 , NAME varchar, DIAK_CDE varchar, NAME2
varchar, DIAK_CDE2 varchar, TYPE varchar, STATUS varchar, NAVIG
varchar);
select AddGeometryColumn
('vbogorny','river','the_geom','-1','MULTILINESTRING',2);
insert into city values
('0','0.000','0.000','20.000000000','53.000000000','Bismarck','USA-
NDA','North Dakota','US','United States','Provincial
capital','7','Less than 50,000','0',GeometryFromText('POINT
(-100.7833025517 46.79999918311)',-1) );
insert into river values
('0','Manistee',NULL,NULL,NULL,'stream','secondary','nonnavigable',GeometryFromText
('MULTILINESTRING ((-86.350807 44.252991 ,-86.179604
44.221001 ,-86.079018 44.244381 ,-85.914146 44.22971 ,-85.908544
44.229205 ))',-1) );
insert into river values
('1','Muskegon',NULL,NULL,NULL,'stream','secondary','nonnavigable',GeometryFromText
('MULTILINESTRING ((-86.28698 43.12772 ,-86.141327
43.159142 ,-85.908544 43.219171 ))',-1) );
select c1.cntry_name as USA_Neighbors from country c1, country c2
where touches(c1.the_geom,c2.the_geom)='T' and c2.cntry_name='United
States';
select r.name,c.cntry_name from river r, country c where crosses
(r.the_geom,c.the_geom)='T' ;
select c1.city_name,r1.name from city c1, river r1 where distance
(c1.the_geom,r1.the_geom) > 100
select c.cntry_name,c.pop_cntry , area(c.the_geom) as area from
country c;
select r.name, c.cntry_name, length(intersection
(r.the_geom,c.the_geom)) from river r, country c where crosses
(r.the_geom,c.the_geom)='T';
On May 29, 2:56 pm, mdipierro <[email protected]> wrote:
> I am rewriting the DAL so any suggestion in this direction is welcome.
> I think we do not need a geoweb2py fork, I think we should be able to
> make the DAL extensible so that it can be subclassed.
>
> On May 29, 5:01 am, haftish21 <[email protected]> wrote:
>
> > Right - you need to pay USD 10 for it:http://www.lulu.com/content/4968879
>
> > >>'ll get as soon as possible, full version is what I need.
>
> > It's not a fully-qualified domain, won't ever work outside your
> > campus...
>
> > >>Then let me get another help from u to broaden it, take it out of my
> > >>campus. How could I fully qualify its domain?
>
> > If spatial database consistency is new 2 web2py, then it calls a lot
> > of assignments 4 me to fill the gap.
>
> > Let us talk how to realize "geoweb2py", I'm really getting the
> > interest 2 write a proposal on this demand and show it 2 my professor.
> > What do u think?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
