search

OpenCLTBrigade / adopt-a-street

Adopt A Street
1 stars 8 forks source link

Research the current app's database structure #31

Open tannerhodges opened 9 years ago

tannerhodges commented 9 years ago

This is the biggest unknown of the project:

@TraceyK14 @derekrail89 If y'all can take this on, that'll be amazing.

TraceyK14 commented 9 years ago

Sorry about the late response, I actually spoke with the lady and she said she would get me the data, and then I never heard from her again

SundayFunday commented 9 years ago

The adopted street data is housed on an ESRI server. It is in GIS-compatible format but query-able in JSON and AMF:

http://maps.ci.charlotte.nc.us/arcgis/rest/services/NBS

I also have access to the adopters database for when the time comes to port that data over.

tannerhodges commented 9 years ago

@SundayFunday Does this include data for available streets as well? I'm thinking we're going to need to store all the possible street selections in a database. That way we can mark them as being available, adopted, etc. Helps avoid overlapping selections too.

SundayFunday commented 9 years ago

If you look at the website link I posted, I get the feeling only the adopted streets are in a separate database. Then all streets are in another. Maybe the "adopted" trumps the "available". That's was one thing the City wanted to change. The current site shows all streets as available except what is adopted. But in reality NCDOT owns a lot of streets and there are some private roads too. The City wants to show NCDOT and private roads as unavailable. I think there's a GIS "Layer" for that as well.

TraceyK14 commented 9 years ago

are you making a call to that link? When I click on the link I get an error.

SundayFunday commented 9 years ago

Not sure why the error is suddenly popping up. The link has been working for about 9 months.

I found it by inspecting the map here: http://aacs.charmeck.org/

TraceyK14 commented 9 years ago

Are you getting the error as well?

The map's are not even showing up for me. It's like the server that is hosting the maps is down.

Also found this, I guess you could just visit him.

Esri Office

Regional Manager: Mike Dyer [manager-chr@esri.com]

3325 Springbank Lane, Suite 200 Charlotte, NC [PDF] 28226-3343 704-541-9810 • Fax: 704-541-7620

SundayFunday commented 9 years ago

Here's where the street and Adopt-a-Street data is located on Charlotte's Open Data Portal. http://clt.charlotte.opendata.arcgis.com/datasets?q=neighborhoods

Maybe we'll have more luck avoiding errors here.