gothos.info
Gothos » Blog Archive » Creating Reports with SQLite, Python, and prettytable
http://gothos.info/2013/02/creating-reports-with-sqlite-python-and-prettytable-2
A Geospatial Librarian's World. Links – Data. Links – Resources. Laquo; Altering Tables in SQLite / Spatialite. The Geography of US Public Libraries. Creating Reports with SQLite, Python, and prettytable. Python has a built-in module, sqlite3, that you can use to work with SQLite databases. This is pretty well documented – do a search and you’ll find a ton of brief tutorials. Take a look at this great post. For a comprehensive intro. For generating reports I gave prettytable. Under “The Harder Way&...
gothos.info
Gothos » Blog Archive » Creating Reports with SQLite, Python, Jinja2, and LaTeX
http://gothos.info/2015/03/creating-reports-with-sqlite-python-jinja2-and-latex
A Geospatial Librarian's World. Links – Data. Links – Resources. Laquo; Census Proposes to Cut 3-year ACS in Fiscal 2016. Inserting Data into Templates with Python and Jinja. Creating Reports with SQLite, Python, Jinja2, and LaTeX. And routinely use it for writing reports, articles, and hand-outs. Figuring Out What the Pieces Are. Was something I’ve used for generating basic text-file reports. Luckily I found this post. I started looking for a template engine that would work well with both LaTeX and Pyth...
gothos.info
Gothos » Blog Archive » Looping Through a Database to Create Reports
http://gothos.info/2015/07/looping-through-a-database-to-create-reports
A Geospatial Librarian's World. Links – Data. Links – Resources. Laquo; Inserting Data into Templates with Python and Jinja. Writing Functions and Building a Jinja Template. Looping Through a Database to Create Reports. I’ve got a lot of ground to cover, picking up where I left off several months ago. In earlier posts I presented the concept for creating reports. From sqlite databases using Python, Jinja, and LaTeX, and looked at different methods for passing data from the database to the template. Conne...
gothos.info
Gothos » Blog Archive » Writing Functions and Building a Jinja Template
http://gothos.info/2015/08/writing-functions-and-building-a-jinja-template
A Geospatial Librarian's World. Links – Data. Links – Resources. Laquo; Looping Through a Database to Create Reports. Update Your Links to the New Baruch Geoportal. Writing Functions and Building a Jinja Template. Later in the script, as we’re looping through all the geographies and gathering the necessary data into dictionaries that represent each data table, we call the function. In this example we’re combining household income brackets so that we don’t have so many categories:. For geog in geodict....
gothos.info
Gothos » jinja2
http://gothos.info/tag/jinja2
A Geospatial Librarian's World. Links – Data. Links – Resources. Posts Tagged ‘jinja2’. Writing Functions and Building a Jinja Template. Thursday, August 6th, 2015. Later in the script, as we’re looping through all the geographies and gathering the necessary data into dictionaries that represent each data table, we call the function. In this example we’re combining household income brackets so that we don’t have so many categories:. For geog in geodict.keys(): name=geodict.get(geog) filename='zzp...Def c...
gothos.info
Gothos » Links – Data
http://gothos.info/links-data
A Geospatial Librarian's World. Links – Data. Links – Resources. Links – Data. A short list of sites with free GIS data layers, from global to local. 8211; a growing collaborative of university and government organizations that are providing access to their repositories through a shared, community-built and governed portal. 8211; an extensive on-line catalog of websites that provide publicly accessible geospatial data. United Nations Environment Program. 8211; GIS data from Canada’s census agency . 8211;...
gothos.info
Gothos » data
http://gothos.info/tag/data
A Geospatial Librarian's World. Links – Data. Links – Resources. Posts Tagged ‘data’. Laquo; Older Entries. Update Your Links to the New Baruch Geoportal. Thursday, August 13th, 2015. Since it’s a new site with a new address, many of the links to projects I’ve referred to throughout the years on this blog are no longer valid. Redirects are in place, but they won’t last forever. Some notable links to update:. The homepage for the portal. The GIS Practicum manual. Friday, April 3rd, 2015. As my test case.
gothos.info
Gothos » latex
http://gothos.info/tag/latex
A Geospatial Librarian's World. Links – Data. Links – Resources. Posts Tagged ‘latex’. Looping Through a Database to Create Reports. Tuesday, July 28th, 2015. I’ve got a lot of ground to cover, picking up where I left off several months ago. In earlier posts I presented the concept for creating reports. From sqlite databases using Python, Jinja, and LaTeX, and looked at different methods for passing data from the database to the template. Connect to database and create dictionary of all geographies conn ...
gothos.info
Gothos » Blog Archive » Inserting Data into Templates with Python and Jinja
http://gothos.info/2015/04/inserting-data-into-templates-with-python-and-jinja
A Geospatial Librarian's World. Links – Data. Links – Resources. Laquo; Creating Reports with SQLite, Python, Jinja2, and LaTeX. Looping Through a Database to Create Reports. Inserting Data into Templates with Python and Jinja. In this post, I’m picking up where I left off. And will cover the different methods I experimented with to get data out of a SQLite database and into a Jinja LaTeX template using Python. I’m using the NYC Geodatabase. As my test case. Standard Elements – Used Each Time. First Iter...
gothos.info
Gothos » report generation
http://gothos.info/tag/report-generation
A Geospatial Librarian's World. Links – Data. Links – Resources. Posts Tagged ‘report generation’. Writing Functions and Building a Jinja Template. Thursday, August 6th, 2015. Later in the script, as we’re looping through all the geographies and gathering the necessary data into dictionaries that represent each data table, we call the function. In this example we’re combining household income brackets so that we don’t have so many categories:. For geog in geodict.keys(): name=geodict.get(geog) fi...Def c...
SOCIAL ENGAGEMENT