exchangebc / garbage-day Goto Github PK

Data contains multiple names for the same thing (e.g. difference in spelling, capitalization, etc).

Wiki needs to be updated with latest information on stack implementation and MVP. Wiki or repo also needs a component to house discussion related content. Somewhere to aggregate the results of discussion around this. IRC logs, Gitter, etc. So that others can see the entire process.

We need to determine where and how to host this application for the short term.

• Each email sent to user will include a unique link to unsubscribe that email address.
• A page will let the user know they have successfully unsubscribed.

• User can access a page describing the project, who developed it, who maintains it and that it uses the city data but is in no way affiliated with the city
• user will see a link from the main site to this new page

Project needs a short succinct sentence or two that explains who is driving it. We need to remove any implication the City of Kamloops is involved beyond simply providing access to the open data for two reasons: 1) users know who is collecting and storing their information and it is clear that it is not the city, 2) a poor service offering is associated with the project not with the City.

As soon as the city starts getting confused calls about how the notification on "their" app did not work this morning, or reports that some unknown group is taking personal information under the guise of being official city project, open data will dry up for us.

This disclosure or opt in, or ?? should have fuller text on a web page associated with the site, and a shorter version included in all notifications - linking the full version on the site.

Some googling may find some examples where open data has been used in other projects and this has been handled well.

Access the Rest API here: http://geoprodsvr.kamloops.ca:6080/arcgis/rest/services/BCDevExchange/GarbagePickup/MapServer

From there select the GIST_Garbage_Schedule link. Review the schema columns at the bottom of the page: ObjectId, Address, Zone. Select the Query link and enter the following values:

Where: ADDRESS = ‘348 TRANQUILLE RD’
Out Fields: Address, Zone

Select the Query (GET) button at the bottom of the page and see the Address and Zone displayed for that address. Do the same for GIST_Garbage_Zone except for the different column names.

This is how to do it through the interface – I don’t know how to do it programmatically however there’s help online here http://resources.arcgis.com/en/help/rest/apiref/ (Ps. we’re running AGS version 10.2.1 if that makes a difference).

Note that the Rest API url will undergo change likely Tue eve (if all goes well) - I will update the url in the docs.

Sorry, gone for the next 5 days.

Users need to receive an email notification 1 day before their garbage day reminding them that their garbage day is the following day.

• User will receive an email after subscribing
• User will see a unique link to confirm subscription
• User can confirm their subscription by clicking the provided link in the email
• User will see a description and link to the work from issue #12

• Provide a page where users can go by pasting a link to their address bar.
• Users will see a text field with a "Enter your address and click "Search"" text prompt beside a "Search" button making it clear the user needs to enter their address into the text field.
• Display a map that shows the zones on the page.

The code as is, has a race condition in which the first confirmation is selected. If someone is signing up for multiple addresses, they are never able to confirm the second subscription or beyond.

The raw mysql is a bit of a pain, swapping it our for peewee would be nice and allow a more complete SQL injection prevention plus model mapping.

The text box for searching for the address isn't rounded. It just needs some more in depth styling detail after the bootstrap typeahead was added.