sf_food_trucks's People
sf_food_trucks's Issues
Initialize project with phx.new
- initialize project with phx.new
- add versions to .tool-versions
Add padding to map bounds
Update database to require fields
The majority of the fields are required. Create a migration to update the table.
Deploy to web
Make map use full view
Currently the map view is pinned to h-96
. In order to make it fill the height, it needs parent views that also fill the available height.
Create schema for data
Call the schema Facility
/ facilities
, and the context Food
.
- rename fields to snake case.
- use naive date time for time fields
- convert enum fields to EnumType
- change schema to TypedEctoSchema
- remove the CUD views / routes
Generator
mix phx.gen.live Food Facility facilities location_id:integer applicant:string facility_type:string cnn:integer location_description:string address:string blocklot:string block:string lot:string permit:string status:string food_items:text x:float y:float latitude:float longitude:float schedule:text days_hours:text noi_sent:naive_datetime approved:naive_datetime received:naive_datetime prior_permit:boolean expiration_date:naive_datetime
Add field :geometry
manually to the migration and schema, as the generator won't know what to do with that.
Schema
https://data.sfgov.org/Economy-and-Community/Mobile-Food-Facility-Permit/rqzj-sfat
Original Name | Description | Type | Notes |
---|---|---|---|
locationid | Location id of facility | Number | |
Applicant | Name of permit holder | Plain Text | |
FacilityType | Type of facilty permitted: truck or push cart | Plain Text | Change to EnumType |
cnn | CNN of street segment or intersection location | Number | |
LocationDescription | Description of street segment or intersection location | Plain Text | |
Address | Address | Plain Text | |
blocklot | Block lot (parcel) number | Plain Text | |
block | Block number | Plain Text | |
lot | Lot number | Plain Text | |
permit | Permit number | Plain Text | |
Status | Status of permit: Approved or Requested | Plain Text | Change to EnumType |
FoodItems | A description of food items sold | Plain Text | |
X | CA State Plane III | Number | |
Y | CA State Plane III | Number | |
Latitude | WGS84 | Number | Use to create geometry field |
Longitude | WGS84 | Number | Use to create geometry field |
Schedule | URL link to Schedule for facility | Plain Text | |
dayshours | abbreviated text of schedule | Plain Text | |
NOISent | Date notice of intent sent | Date & Time | |
Approved | Date permit approved by DPW | Date & Time | |
Received | Date permit application received from applicant | Plain Text | |
PriorPermit | prior existing permit with SFFD | Number | |
ExpirationDate | Date permit expires | Date & Time | |
Location | Location formatted for mapping | Location | OMIT |
Original Data
Column Name | Description | Type
locationid | Location id of facility | Number |
Applicant | Name of permit holder | Plain Text |
FacilityType | Type of facilty permitted: truck or push cart | Plain Text |
cnn | CNN of street segment or intersection location | Number |
LocationDescription | Description of street segment or intersection location | Plain Text |
Address | Address | Plain Text |
blocklot | Block lot (parcel) number | Plain Text |
block | Block number | Plain Text |
lot | Lot number | Plain Text |
permit | Permit number | Plain Text |
Status | Status of permit: Approved or Requested | Plain Text |
FoodItems | A description of food items sold | Plain Text |
X | CA State Plane III | Number |
Y | CA State Plane III | Number |
Latitude | WGS84 | Number |
Longitude | WGS84 | Number |
Schedule | URL link to Schedule for facility | Plain Text |
dayshours | abbreviated text of schedule | Plain Text |
NOISent | Date notice of intent sent | Date & Time |
Approved | Date permit approved by DPW | Date & Time |
Received | Date permit application received from applicant | Plain Text |
PriorPermit | prior existing permit with SFFD | Number |
ExpirationDate | Date permit expires | Date & Time |
Location | Location formatted for mapping | Location
Add postgis extension migration
We'll need Postgis for queries related to lat/lng's.
- add postgis in migration
- add note in README about this requirement
Create map view
Add CI linting
- read versions from .tool-versions
- credo strict
- mix format
- mix audit
- mix hex.audit
- require checks to pass for CI
Create importer for CSV data
Add dependabot
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.