Comments (1)
What about something like this for the license table fields? I built on what openaddresses did based on what weve discussed and doing some light research on it. I found this example also helpful
https://datacatalog.worldbank.org/public-licenses
CREATE SEQUENCE IF NOT EXISTS licenses_sq START 10;
CREATE TABLE IF NOT EXISTS licenses (
licenses_id int PRIMARY KEY DEFAULT nextval('licenses_sq')
, attribution_entities_id int NOT NULL REFERENCES entities
, description text -- short descriptive summary
, url text -- link to the actual text/pdf/copy of license
, attribution_required boolean DEFAULT 't'
, share_alike_required boolean DEFAULT 't'
, commercial_use_allowed boolean DEFAULT 'f'
, redistribution_allowed boolean DEFAULT 'f'
, modification_allowed boolean DEFAULT 'f'
, metadata jsonb
);
https://github.com/openaq/openaq-db/blob/develop-native-partitions/openaqdb/tables/licenses.sql
from openaq-api-v2.
Related Issues (20)
- add /v3/sensors and v3/locations/{locations_id}/sensors
- db.py refactor for variable working memory HOT 1
- Is OpenAQ working on its own API wrapper for Python? HOT 3
- staging db.py error
- catch 408 timeouts HOT 1
- better parse pydantic validation errors
- AirGradient locations show as "Monitors"
- parameters spatial queries returns `500`
- providers spatial queries returns `500`
- Registering not possible HOT 1
- add rate limiting headers to responses
- Averages endpoint returns error 500, when using temporal as parameter HOT 2
- allow variable rate limiting
- Request to average endpoint times out HOT 3
- Returning string instead of JSON when error validating API parameters HOT 2
- Time window bug for `v2/averages`
- sensors trends endpoint HOT 1
- `v2/locations` frequently returning 500s HOT 1
- Rate limit headers HOT 3
- Filtering by country on ``/cities`` returns cities of unwanted countries
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openaq-api-v2.