Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement check on lat lon #13

Open
falkirks opened this issue Mar 20, 2018 · 2 comments
Open

Implement check on lat lon #13

falkirks opened this issue Mar 20, 2018 · 2 comments

Comments

@falkirks
Copy link
Member

No description provided.

@agottardo
Copy link
Contributor

Should also be added to the CREATE TABLE syntax we will attach to the submission, so not closing for now.

@agottardo
Copy link
Contributor

@iandelrio remember to add this at the end of the final .sql when submitting:

ALTER TABLE locations ADD CHECK (longitude>=-123.27 AND longitude <= -123.22 AND latitude >= 49.241 AND latitude <= 49.283);

In PHP:

$longitude >= -123.27 && $longitude <= -123.22 && $latitude >= 49.241 && $latitude <= 49.283;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants