I'm quite new to the GIS world and I currently have some technical questions for which I have no answers yet.
I'd like to know the good way to store the attributes for a feature using the PostgreSQL database and its PostGIS extension. For example, a point can be a house located in a street with a name and a number.
I know that applications like MapServer or GeoServer are exactly about doing this, but I'm looking for a simpler solution.
Ideally I'd like to have everything in my database where for each feature I can list the associated attributes. But I would also like to know from a specific attribute, the list of features matching.
Is there any standard/best practice out there to store GIS attributes within a SQL database?
Plus, what about the attributes name themselves? Is there any list of standard attributes that can be associated to a feature. I don't want to re-invent the wheel so where to find the common used terms to define a feature (street, country, zip code, ...)?