SEPTEMBER MASTER ISSUE

[NealHumphrey]

This is still a work in progress - I need to create some issues for bullet points here, as well as go through all open issues to add any additional ones that need to be addressed before launch.

Map View

• URL encoding finalizing (project in preview screen, 'summary' or 'matching' sidebar, fixing color coding on decode)
• List active filters in CSV modal (Additions to export functionality #499)
• Search and filter by many addresses and TOPA (Enhanced filtering for one-to-many sources #500) (needs Add nested json of proj_addre to the /api/filter endpoint and /api/project endpoint #510 on python side)
• Change map view to only have 2 colors (match/nomatch)
• Clear 'Selected Project' if not part of a newly run filter (Clear selected project #534)
• Add list of subsidies with start/end dates to the project preview Small mapview edits per user feedback #476
• Null checkbox conditional on presence of null data The include null values checkbox should be conditional on the presence of null values #454

Project View

• Revamping project view Revamping the Project View: new layout, new graphs #471
  • Add street view
  • Replace placeholder images with icons (ideally data-driven, can be static when needed)
  • Add any missing data fields per the Revamping the Project View: new layout, new graphs #471 issue.
• "Tabulate" as a D3 reusable chart (Tabulate as a d3 reusable chart #502)

Add data sources to filter sidebar:

• REAC Add 'Recent REAC Score' filter to map view #425
• Nearest metro Add 'Nearest Metro Station' and 'Number of Nearby Bus Routes' #424
• Topa Add 'TOPA notice type' filter to map view #420

Front end - If time

• Fix affordable housing nearby issues (Fix affordable housing nearby #487)
• Bar chart improvements (Bar Chart improvements #390)
• Reduce duplicated geoJSON (Reduce duplicated data in the geoJSON #433)

Data Processing

• Add nlihc_id using multiple addresses Add nlihc_id using multiple addresses #507. Mostly done but needs validation.
  • TOPA table (refer to Add nlihc_id to topa table #404 for reference)
  • DC tax
  • Address
• Write description of how we dedupe our sources of projects to share w/ office of planning
• Verify we don't accidentally lose rows base_project apiconn avoid accidental removals of rows #505
• Geocode all newly added projects so they can filter/display properly (Geocode newly added dchousing and DHCD projects #314)
• Update data documentation for all tables currently in the database, and meta.json entries
• Add ANC's to weighting; add ANC to zone facts.
• Add loan information from DHCD to the subsidy records being added from Quickbase
• Populate 'in_prescat', 'in_dchousing' and 'in_dhcd' fields to the project table
• Populate total unit counts at the project level DCHousing is missing total unit counts #495
• Fix calculation technique for total residential units in a zone CAMA data doesn't include "commercial" residential units #493
• Create calculated field - percent of zone that is subsidized units.

Server

• (Walt) Create a 'sources' class that checks an S3 bucket for new files and downloads them during get_api_data().
• Add row-level skipping when error occurs to all classes in the sources folder Add row-level skipping when error occurs to all classes in the sources folder #524
• Add row-level skipping to all classes in the cleaners (simple try-except in LoadData)
• Handle API connection errors - 104 error (Handle error 104 Connection reset #512), 503 error (add "503" error handling #479)
• Add nested json of proj_addre to filter and project endpoints Add nested json of proj_addre to the /api/filter endpoint and /api/project endpoint #510

General Website Stuff

• Add "?" links to all data fields linking to the appropriate data documentation page. (Add links to data documentation in each 'filter' or 'layer' selection section #360)ZoneFacts table will provide this for any calculated fields.
• Add a landing page (Create a Landing Page #504) and/or landing modal
• Add a joyride tour of key features: filtering, chloropleths, selecting buildings, null data.
• Add 3 saved analyses (using the url encoding) and use these to introduce the types of things the tool can do to new users; put these on the landing page.
• Add a the navbar from the whole site to the top of the tool
• Add Google Analytics
• Auto-population of data fields in Jekyll data documentation (still needs styling)

[ostermanj]

@NealHumphrey I can jump on the finalizing URL encoding stuff. What's the issue with color-coding on decode?

[NealHumphrey]

@ostermanj When I load a saved URL (i.e. refresh the page with a few filters activated), the filters apply correctly to the right hand side panel summary stats - therefore it seems like the filterData is working properly - but all of the dots on the map are orange. If I then select an additional filiter on the page, dot-coloring resumes as normal. It seems to happen with all filters in my browser (Chrome on Windows) - I can come up with specific scenarios if you are not able to recreate. I'm online working today (starting with reviewing your open pull requests) so let me know if you can't replicate the problem.

[ostermanj]

Got the color coding work locally. Will push after finishing the other decode tasks.

__
The filter decoding was happening too quickly after initialLayers were added, before they were fully rendered. Solutions uses mapBox's render event, checks against state of initialLayersAdded and !isFilterInitialized to setState initialProjectsRendered. router.initFilters subscribes to that stateChange and turns isFilterInitialized to true so that this stateChange fires only once