last day (142 days later) » 

10:38 PM
Hi!
 
Hello! So, as Art asked, what data do you have, what format is it in, and what do you want to do with it?
 
Hang on, my computer is up.
Almost there...
 
I think I'll edit a link into the pinned message in the TL.
 
Good lord.
OK. So what I have is a list of people with addresses that are manually geocoded and an urgency level and notes.
What they need is 1. a way to not crash into each other with edits.
 
In a google sheet? Where/how is it stored?
 
10:47 PM
@thesecretmaster Yes, Google Sheets with a form in front.
Maybe.
 
@KitZ.Fox define "manually geocoded" for me? What format?
 
I'm not sure about the format.
@ArtOfCode It's lat long coordinates.
 
@KitZ.Fox Would row locking help the problem?
 
Cool
 
What's the workflow for people editing it?
 
10:48 PM
@thesecretmaster Some, yes, but they also need 2. maps for rescuers. and 3. preferably an easier way to enter the geocoding.
@thesecretmaster I don't know. I think it's a free-for-all at the moment.
I'm on my personal computer and haven't done contract work in a while so everything keeps popping up at me. Bear with me.
I'm trying to get back into Facebook and Google Drive and all that stuff so I can answer your questions.
 
In theory, you could do revisions like SE does - when someone starts editing a row, remember the revision when they started editing. If any new revisions turn up before they submit their edit, get them to review the newer revision and adjust their changes before re-submitting.
 
What I'm think of is a searchable list of people, then you can go into a person page and edit that persons page. Plus what Art said.
 
I was thinking a map. You find the location, select it, and add a record with person info and urgency.
 
OK. What about editing?
 
10:52 PM
@KitZ.Fox Where do you need help here? You mentioned a server - I'm probably not gonna be able to help with that, but @Undo might, potentially.
 
I'm checking...I think they only need to edit to update status.
@ArtOfCode I thought I would need a web host.
 
I can. I'd be happy to use my AWS instance.
 
I don't know what capabilities that gives us.
 
Or my home computers, which are up 24/7, but are on a residential internet connection, which isn't totally reliable.
 
Can it interface with a map service?
 
10:54 PM
Yeah, it can run pretty much any webapp
 
@KitZ.Fox AWS gives you virtual private servers. Basically, do anything you like with them, including setting up web servers.
 
OK that sounds good.
 
I'm looking at OpenStreet Map right now.
 
So you want a map with the capabilities to add pins and make pins link places.
 
10:57 PM
Basically. I think?
 
29
Q: google map api: open url by clicking at marker

idobrI want to open a new window by clicking at marker using google map api 3. unfortunately, there are not so many examples at google api. I found out this code: google.maps.event.addListener(marker, 'click', function() { window.location.href = marker.url; }); How to use it, when I create markers...

This sounds very doable.
 
What I'm picturing is typing in an address on Google Maps, it finds the location, you click the location, it enters both the address and the coordinates to the record.
 
I think what it'd have to be is a map with clickable pins and a form at the bottom for adding a new pin
 
how would the pins get added?
I mean, yeah a form, but how would that work?
 
@KitZ.Fox why "you click the location"? If you know the address, you can look up lat/long automatically, without further user intervention.
 
11:01 PM
What if you don't know it with that much precision?
@KitZ.Fox ajax send to server and add pin to map with JS.
 
What if it's "the roof of the garage next to the barn in the northern field"?
@thesecretmaster OK.
Is that something you can do?
 
@KitZ.Fox Yep, fair
 
I mean you particularly. Are you volunteering?
 
I'd be happy to try :)
I've got a couple hours tonight.
 
I sound abrupt. I'm just feeling urgency.
What can I do to support your efforts?
Here, I can give you the fields that they want to track.
 
11:04 PM
Also, the big pain will be importing data from the sheet, unless there's a google sheets API.
I'll be eating for about the next half hour, then I can get started. If @ArtOfCode has time, help would be great.
 
@thesecretmaster I'd love to, but it's 12:05 AM here. If you make a start and detail what you've done, what's left to do, and chuck it all in a GH repo, then I can pick it up in the morning.
@thesecretmaster you can export to CSV from Sheets, and from there it's easy to go to a DB
 
OK. I'll get a start tonight, and leave details in here.
 
They want:
autoassigned Incident Number
Timestamp
Priority*
Status*
Name
Street Address
Lat/Long
Phone Number
Twitter handle
Number of people needing rescue
Special comments (how many children, elderly, disabled, etc)
Pets
Additional comments (where you got the information)
* are picklists.
Priority - Immediate, Emergent, Urgent, Semi-Urgent, Standard
 
I'm going to work on getting the maps API to work first, then add the everything else.
 
Status - Pending, Hold for Info, Rescued, In transit
 
11:09 PM
But thanks for putting this here
 
@thesecretmaster I might be able to help, or I might get in the way. Let me know.
 
@KitZ.Fox Are you a developer?
 
If I have access to data, I can write views for feeds, if that's something we can do.
@thesecretmaster Yes. I'm microsoft stack mostly though. ages since I've done javascript.
Or anything else.
 
@KitZ.Fox Are you planning to do the backend work on this?
 
I can do data work though, lots of it.
I could, if you point me to where.
 
11:11 PM
If you're not, I can do that tomorrow afternoon in Rails
 
I don't know Rails.
 
@ArtOfCode Also, if I get a start on backend, I'll be writing it in sinatra. You'd have to port it to rails.
Because I don't really do rails.
 
@thesecretmaster Sinatra... still Ruby, right?
 
I can work with that
 
11:12 PM
So I think I'm not going to be useful here...
I can still do BA work though! That's my job anyway nowadays.
 
You're making this happen by bringing it here :) And by working with the others to convey what is needed.
 
@thesecretmaster In any case, chuck it in a repo when you're done with some sort of todo-list, and I should be able to pick something up.
 
OK, great. I'll do that.
OK, got maps API up and running and clickable points.
 
Sweet.
 
11:36 PM
And now a funtion to add points from lat+long. Now looking into getting lat and long from words.
Oh, nevermind, you have lat/long
I guess I'll start backend then.
 
I have it now, but what about new entries?
 
Working on it. I'll let you know when I have testable stuff.
 
i.e. get lat/long from clicked point, as opposed to get point from lat/long
 
Yeah, trying to sort that out. I'm sure there's an API for it.
 
what map are you using?
 
11:43 PM
Google maps
 
Ah, there you go.
That's all you need, right?
 
But no input.
 
Contact them?
 
They are the ones asking for help.
They didn't mention they had a map already though.
 
11:45 PM
Oh
 
Looks like the map pulls data from the google sheet.
And you can't interact with the map to update it.
 
Well, I can do that.
I'll keep going, until you tell me not to :)
Plus, I'm having fun
 
I would like you to keep at it.
I bet it would be helpful if we could superimpose a flood map on the base map.
 
Maybe possible?
IDK about that.
 
I'm looking for data.
 
11:51 PM
Is the sheet publicly accessable?
 
If yes, linky?
Egad, so many sheets. Which one is the important one?
 
Harvey SOS form data and WASO form data
Don't read too closely, it will hurt.
 
OK. I'll take a snapshot and build a web interface around that.
 
NOAA has flood gauge data, but I don't think that would be useful. Really I was thinking of something that would help show which roads are passible or impassible.
 
11:55 PM
Hmmm. I can do markers in google maps, not sure about road indicators.
 
Don't worry about it.
If I can find the data, I can make a layer for you to add.
 
OK. I'll deal with people for now
 
that's the most important
 
Writing a script to import the data from the CSV now.
 

  last day (142 days later) »