librelist archives

« back to archive

Creating new tables in development.db

Creating new tables in development.db

From:
Smitha V
Date:
2011-02-11 @ 03:00
We want to customize GeoNode to our organization's specifications. We want
to categorize data. Also while displaying, we want to group it into folders
based on the category. So, i want to add a field to the layer table which
specifies the category (like agriculture, population etc). But i am not able
to add a new column to the table. Can someone help me out which this?

We want to customize search. We want to perform search based on edit
distances. To achieve this, i need to add a new table(containing a list of
words) with which the search is performed. I am facing problem in adding a
new table to the database. Can i get some guidance on this?

-- 
Regards
Smitha V
MT2009149
IIITB

Re: [geonode] Creating new tables in development.db

From:
David Winslow
Date:
2011-02-11 @ 15:21
On Thu, Feb 10, 2011 at 10:00 PM, Smitha V <smitha.v@iiitb.net> wrote:

> We want to customize GeoNode to our organization's specifications. We want
> to categorize data. Also while displaying, we want to group it into folders
> based on the category. So, i want to add a field to the layer table which
> specifies the category (like agriculture, population etc). But i am not able
> to add a new column to the table. Can someone help me out which this?
>

GeoNode uses Django's "model" framework to interact with databases.  I'd
recommend working your way through this tutorial:
http://docs.djangoproject.com/en/1.2/intro/ to learn about using it.  The
tutorial should take less than an hour if you are familiar with Python
already, and it will also help you to learn about adding and customizing
pages in Django/GeoNode.

There is already a 'category' field on Layers which you may be able to adapt
to your needs.  I know the folks at Harvard Worldmap have done so already so
they may be able to provide some pointers (or you can peruse their code on
github.)


> We want to customize search. We want to perform search based on edit
> distances. To achieve this, i need to add a new table(containing a list of
> words) with which the search is performed. I am facing problem in adding a
> new table to the database. Can i get some guidance on this?


The tutorial I linked above will also help you to add new tables.  Currently
data search is delegated out to the CSW service in GeoNode so you will
either need to reimplement the search code in Python/Django or customize
GeoNetwork to use edit distance for search.


>
> --
> Regards
> Smitha V
> MT2009149
> IIITB
>
>
--
David Winslow
OpenGeo - http://opengeo.org/

Re: [geonode] Creating new tables in development.db

From:
Spanring, Christian
Date:
2011-02-11 @ 15:30
FYI. Data categories are also on our roadmap and I'll definitely check out
Harvard's code once I get to it, which should be within the next 2-3 weeks
I assume. Maybe there is some opportunity to share resources among GeoNode
users?

Christian

From: geonode@librelist.com [mailto:geonode@librelist.com] On Behalf Of 
David Winslow
Sent: Friday, February 11, 2011 10:22 AM
To: geonode@librelist.com
Subject: Re: [geonode] Creating new tables in development.db

On Thu, Feb 10, 2011 at 10:00 PM, Smitha V <smitha.v@iiitb.net> wrote:
We want to customize GeoNode to our organization's specifications. We want
to categorize data. Also while displaying, we want to group it into 
folders based on the category. So, i want to add a field to the layer 
table which specifies the category (like agriculture, population etc). But
i am not able to add a new column to the table. Can someone help me out 
which this?

GeoNode uses Django's "model" framework to interact with databases.  I'd 
recommend working your way through this tutorial: 
http://docs.djangoproject.com/en/1.2/intro/ to learn about using it.  The 
tutorial should take less than an hour if you are familiar with Python 
already, and it will also help you to learn about adding and customizing 
pages in Django/GeoNode.

There is already a 'category' field on Layers which you may be able to 
adapt to your needs.  I know the folks at Harvard Worldmap have done so 
already so they may be able to provide some pointers (or you can peruse 
their code on github.)

We want to customize search. We want to perform search based on edit 
distances. To achieve this, i need to add a new table(containing a list of
words) with which the search is performed. I am facing problem in adding a
new table to the database. Can i get some guidance on this?

The tutorial I linked above will also help you to add new tables.  
Currently data search is delegated out to the CSW service in GeoNode so 
you will either need to reimplement the search code in Python/Django or 
customize GeoNetwork to use edit distance for search.


--
Regards
Smitha V
MT2009149
IIITB

--
David Winslow
OpenGeo - http://opengeo.org/


Please be advised that the Massachusetts Secretary of State considers 
e-mail to be a public record, and therefore subject to the Massachusetts 
Public Records Law, M.G.L. c. 66 § 10.

Re: [geonode] Creating new tables in development.db

From:
Matt Bertrand
Date:
2011-02-11 @ 17:28
Feel free to use the layer code from worldmap.   I'd be happy to help 
you out if you have any questions about it.  There's a new LayerCategory 
model, and the Layer model's category field was changed to be a foreign 
key to that.  Users can also change the layer's category name within a 
map, which is saved in the MapLayer's 'group' field.


-Matt


On 2/11/11 10:30 AM, Spanring, Christian wrote:
> FYI. Data categories are also on our roadmap and I'll definitely check 
out Harvard's code once I get to it, which should be within the next 2-3 
weeks I assume. Maybe there is some opportunity to share resources among 
GeoNode users?
>
> Christian
>
> From: geonode@librelist.com [mailto:geonode@librelist.com] On Behalf Of 
David Winslow
> Sent: Friday, February 11, 2011 10:22 AM
> To: geonode@librelist.com
> Subject: Re: [geonode] Creating new tables in development.db
>
> On Thu, Feb 10, 2011 at 10:00 PM, Smitha V<smitha.v@iiitb.net>  wrote:
> We want to customize GeoNode to our organization's specifications. We 
want to categorize data. Also while displaying, we want to group it into 
folders based on the category. So, i want to add a field to the layer 
table which specifies the category (like agriculture, population etc). But
i am not able to add a new column to the table. Can someone help me out 
which this?
>
> GeoNode uses Django's "model" framework to interact with databases.  I'd
recommend working your way through this tutorial: 
http://docs.djangoproject.com/en/1.2/intro/ to learn about using it.  The 
tutorial should take less than an hour if you are familiar with Python 
already, and it will also help you to learn about adding and customizing 
pages in Django/GeoNode.
>
> There is already a 'category' field on Layers which you may be able to 
adapt to your needs.  I know the folks at Harvard Worldmap have done so 
already so they may be able to provide some pointers (or you can peruse 
their code on github.)
>
> We want to customize search. We want to perform search based on edit 
distances. To achieve this, i need to add a new table(containing a list of
words) with which the search is performed. I am facing problem in adding a
new table to the database. Can i get some guidance on this?
>
> The tutorial I linked above will also help you to add new tables.  
Currently data search is delegated out to the CSW service in GeoNode so 
you will either need to reimplement the search code in Python/Django or 
customize GeoNetwork to use edit distance for search.
>
>
> --
> Regards
> Smitha V
> MT2009149
> IIITB
>
> --
> David Winslow
> OpenGeo - http://opengeo.org/
>
>
> Please be advised that the Massachusetts Secretary of State considers 
e-mail to be a public record, and therefore subject to the Massachusetts 
Public Records Law, M.G.L. c. 66 § 10.

Re: [geonode] Creating new tables in development.db

From:
Smitha V
Date:
2011-02-14 @ 04:26
Thanks Matt.

I downloaded the code from https://github.com/cga-harvard/cga-worldmap. Do i
have to make any changes in any of the files to get it up and running?
Geoserver isn't running on localhost:8001. So, i am getting a 404 error when
i try browsing maps or try to upload new data.

On Fri, Feb 11, 2011 at 10:58 PM, Matt Bertrand
<mbertrand@cga.harvard.edu>wrote:

> Feel free to use the layer code from worldmap.   I'd be happy to help
> you out if you have any questions about it.  There's a new LayerCategory
> model, and the Layer model's category field was changed to be a foreign
> key to that.  Users can also change the layer's category name within a
> map, which is saved in the MapLayer's 'group' field.
>
>
> -Matt
>
>
> On 2/11/11 10:30 AM, Spanring, Christian wrote:
> > FYI. Data categories are also on our roadmap and I'll definitely check
> out Harvard's code once I get to it, which should be within the next 2-3
> weeks I assume. Maybe there is some opportunity to share resources among
> GeoNode users?
> >
> > Christian
> >
> > From: geonode@librelist.com [mailto:geonode@librelist.com] On Behalf Of
> David Winslow
> > Sent: Friday, February 11, 2011 10:22 AM
> > To: geonode@librelist.com
> > Subject: Re: [geonode] Creating new tables in development.db
> >
> > On Thu, Feb 10, 2011 at 10:00 PM, Smitha V<smitha.v@iiitb.net>  wrote:
> > We want to customize GeoNode to our organization's specifications. We
> want to categorize data. Also while displaying, we want to group it into
> folders based on the category. So, i want to add a field to the layer table
> which specifies the category (like agriculture, population etc). But i am
> not able to add a new column to the table. Can someone help me out which
> this?
> >
> > GeoNode uses Django's "model" framework to interact with databases.  I'd
> recommend working your way through this tutorial:
> http://docs.djangoproject.com/en/1.2/intro/ to learn about using it.  The
> tutorial should take less than an hour if you are familiar with Python
> already, and it will also help you to learn about adding and customizing
> pages in Django/GeoNode.
> >
> > There is already a 'category' field on Layers which you may be able to
> adapt to your needs.  I know the folks at Harvard Worldmap have done so
> already so they may be able to provide some pointers (or you can peruse
> their code on github.)
> >
> > We want to customize search. We want to perform search based on edit
> distances. To achieve this, i need to add a new table(containing a list of
> words) with which the search is performed. I am facing problem in adding a
>  new table to the database. Can i get some guidance on this?
> >
> > The tutorial I linked above will also help you to add new tables.
>  Currently data search is delegated out to the CSW service in GeoNode so you
> will either need to reimplement the search code in Python/Django or
> customize GeoNetwork to use edit distance for search.
> >
> >
> > --
> > Regards
> > Smitha V
> > MT2009149
> > IIITB
> >
> > --
> > David Winslow
> > OpenGeo - http://opengeo.org/
> >
> >
> > Please be advised that the Massachusetts Secretary of State considers
> e-mail to be a public record, and therefore subject to the Massachusetts
> Public Records Law, M.G.L. c. 66 § 10.
>
>


-- 
Regards
Smitha V
MT2009149
IIITB