Closed mikemanalo closed 7 years ago
@mikemanalo absolutely. The reason the prototype only has a few fields was simply so we could save some time while we figured out some of the challenges on the back end. We are currently working on finalizing the database structure as well as the web form and we will be send you the form for your approval when it's finished. I think @colinmcdaniel actually had a couple of questions about some inconsistencies in the data set that we received. @colinmcdaniel maybe you could post those here?
I had a couple questions/comments when looking at the funded and unfunded lines SQL tables:
1) A couple fields that were listed on the TranspoDB Word doc were missing from the actual SQL databases sent to us (for instance, Project_Desc is missing from the funded lines table, and Accessibility is missing from the unfunded lines table). 2) Do we want Contact_info to be an object with the properties "name", "phone", and "email"? (This is what the Word document suggests, since it is listed as one field.) 3) Which fields should be required to fill out when adding a new project? 4) From the TranspoDB Word doc, what do some of the Proj_Ty options mean (such as "8. Idea Project")?
@colinmcdaniel
1. I check with Jacqui regarding the databases. However, the Word Doc show what fields we need. So create those fields as necessary.
2. Yes/
3. All fields listed in Word Doc
4. See below: 1) Bike only - Bicycle project 2) Ped Only - Pedestrian project 3) Safety - Safety Infrastructure project 4) People St (make this change) - projects related to People St (more info: peoplest.lacity.org) 5) SRTS - projects related to Safe Routes to School LA (more info: saferoutes.lacity.org) 6) First mile and last mile - as is 7) Bike/ped - Combined Bike and Ped Projects 8) Idea Project - projects that proposed but not approved from entities yet.
Thanks for the response! So even fields such as "More Info" should require a response from the user in order for the form to submit?
Common Project Attributes should be required. For now, fields in the Unfunded and Funded should be included but not be required. (Let's test this)
However, the field 'Fund_St' should determines which set of fields of Unfunded or Funded should appear.
Ok, sounds good
Status check on this issue? How are we progressing.
Our prototype has been updated since this issue was created. As of now, when you click "Add Project", all of the fields that will be stored into the database show up in the form. So this aspect of the issue has been solved. We are now beginning to work on form validation and saving the form information into the database for later retrieval
@colinmcdaniel Great. I'm closing this issue and opening one for validation.
In the prototype, when you Export Features - is this how you access the webform for data entry? If so can you include the fields from the Unfunded and Funded database samples?