DjangoCon 2015

Caso práctico del uso de Django en el sistema de datos abiertos del estado de Texas

Ryan Murphy  · 

Transcripción

Extracto de la transcripción automática del vídeo realizada por YouTube.

everybody um thank you for coming and joining us here in Austin today and kind of taken to using your labor day for for hanging out with a bunch of other of Django folk so yeah so I work at The Texas Tribune which is a start bouncing my science news outlet

here based out of Austin Texas we cover state-level politics and policy so we're really interested in anything that's going on at that big pink building just down the road we I'll be explaining in just a second what what news apps means and kind

of the bigger picture of the Texas Tribune and how our kind of technology groups are organized but just to touch a little bit on the Tribune itself we were founded in 2009 so still relatively young and far as news organizations go we launched on election night

in November of 2009 and we were kind of we were founded as intently as a non-profit and that was that you know is funded through membership so a little bit of the kind of PBS and NPR model we have foundation support we have events that we host that we charge

admissions for the Texas Tribune festival for example is one that's that's coming up here in October you have Tribune people back there yes October that is actually here at the UT campus and HTT conference center so if you're around you should

come check it out we have the largest state house news bureau in the United States so that means that we have more people who are covering state politics did any other organization in the US which has been was one of our initial kind of claims to fame in one

of our kind of goals when we were founded was to fill in the gap that we saw was kind of left open as a lot of the other other news bureaus kind of work were you know figuring out where everyone was going good news is is a lot of these these other organizations

have definitely rebuilt a lot of that team so good news for texts and good news for state coverage if you if you've never heard of The Texas Tribune are just maybe you may know a couple of these things but we've kind of a few different projects that

we've that that we tend to be known for the salaries Explorer which is 1 i'll touch on a little bit later is our one of our kind of biggest traffic draws and when our biggest actual data applications that we have currently has more than 350,000 state

employees within it and for more than 50 different agencies in the state this is something that we're constantly updating constantly adding new agencies and refreshing the data and the kind of goal or purpose of this project has always been to kind of

show the citizens of Texas where you know where their tax dollars are going you know it's it's been it's always been kind of a you know one of our kind of bread and butter experiences that we've always had at the Tribune just kind of carried

it through I think even think it was 2010 x is when we when that when the original version of this came out I mean this is one of our again I'll touching a little bit later but this is actually one of our Django apps that I'll be talking about in a

couple minutes the person errs Explorer same kind of idea we have data that we collect from the Texas Department of Criminal Justice which has danielle has this big database of everyone that's in the currently in the state prison system and we've taken

that data we've cleaned it up we presented based on on kind of crime breakdown by housing you know by the unit that they're located in this is updated month by month so as people leave the system they get removed from a rap as well but the kind of

goal this was originally to present you know make this something that was a lot more user friendly than what the state currently had and still has its it's very very lucky it's more kind of just a search box and hopefully you get lucky finding you

know looking for someone that you want so this is kind of a negative of a lot of the work that we do with the Tribune is taking these large datasets these large state government produce data sets and turning them into things that are more consumable and more

user-friendly one of the tribunes kind of maintenance has always been you know and it's kind of a you know a basic news journalism tenant is just kind of serving as like the translators of kind of the walk eNOS and turning into something that the people

of Texas can use and understand and and our work with with data is is a big part of that our other one of our other this is not necessarily a data project but definitely one of our other kind of claims to fame was our coverage of the abortion filibuster here

in Austin back in 2013 this is our last legislative session just it was almost by stroke of luck that we happen to be that session had got a agreement with the state to stream to live stream the House and Senate chambers and we you know they've always

had the ability for to do this but it was a horrible horrible realplayer powered monstrosity back in the one of the back rooms of the Capitol and we we got over to kind of organize with them to get it turn into something that could actually be on YouTube and

be streamed to YouTube which really opened up the audience and a bit in just the ability for people to actually see this stream and again just just kind of just so happened to be that that was a very good year to to have have that live feed and have that live

look into what was going on in the house and senate that was a very very long night but you know we've with this this was kind of our pushed us into doing something very similar this year as well and really kind of changed the dynamic there that it sits

now really understood and and understood that this is something that you know people will be able to watch all across the state so so today kind of what we're when i'm hoping to kind of get to kind of tell everyone about is like as a news organization

and as a pretty small one like how do we kind of go into our decision making about when and when not to use django for our projects and and when we if we do decide to use it like what what goes into making those decisions in terms of how we're going to

architect it and how we're going to choose what components are part of it and approach the deadlines and kind of turnaround for that how we make that that small team work in this capacity and i'll be kind of explaining the dynamic of that team here

just in a sec and then i'm going to talk about the a couple of these projects the salaries database will be one of them that i think are just kind of good representations of the processes that we we took in how we went from you know starting with starting

with kind of day one branstrom meeting and got to final product and of course we'll be saving some time for questions at the end so and I'll just kind of add this to if there's like I as I'll explain in a sec I'm there's a news app

steam and there's a platform team so if there's very technical questions I may not be able to address there are three of them right back there so if they so do not feel afraid to ask those questions because I'm sure one of us will be able to answer

so news apps what what what does that even mean so it was actually write the end of last session on the 2013 session that we decided that kind of the arrangement we had before is that we had a technology team that was responsible for a whole lot and still

are and do a great job but was getting spread very thin by kind of the editorial demands but also the demands of the business side the marketing side membership and kind of looking at how the rest of the industry was going where they were kind of making these

[ ... ]

Nota: se han omitido las otras 3.788 palabras de la transcripción completa para cumplir con las normas de «uso razonable» de YouTube.