{ "info": { "author": "Texas Tribune", "author_email": "tech@texastribune.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Web Environment", "Framework :: Django", "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Operating System :: OS Independent", "Programming Language :: Python", "Topic :: Other/Nonlisted Topic" ], "description": "The Texas Higher Education Data Project\n---------------------------------------\n[![Build Status](https://travis-ci.org/texastribune/the-dp.svg)](https://travis-ci.org/texastribune/the-dp)\n\n## A very rough guide to starting development\n\n### Example `.env` file for environment variables:\n\n```\nDJANGO_SETTINGS_MODULE=exampleproject.settings.dev\nDATABASE_URL=postgis:///tx_highered\n```\n\nComplete guide to getting started (remove steps to suit you):\n\n```bash\n# install postgresql libpq-dev\n\ngit clone $REPOSITORY && cd $PATH\nmkvirtualenv tx_higher_ed\nsetvirtualenvproject\nadd2virtualenv .\npip install -r requirements.txt\n\n# if you need to create a database:\n# `postdoc` greatly simplifies connecting to Docker databases\npip install postdoc\nphd createdb --encoding=UTF8 -T template0\necho \"CREATE EXTENSION postgis;\" | phd psql\necho \"CREATE EXTENSION postgis_topology;\" | phd psql\n\n# or if you need to reset your database:\nmake resetdb\n\n# syncdb and load fixtures\nmake syncdb\n\n#######################################################################\n# You can stop at this point if you're just playing with the project. #\n#######################################################################\n\n# if using 2012 data, bump it up to 2014 standards\npython tx_highered/scripts/2014_update.py\n\n# get ipeds data, requires https://github.com/texastribune/ipeds_reporter\n../ipeds_reporter/csv_downloader/csv_downloader.py \\\n --uid data/ipeds/ipeds_institutions.uid --mvl data/ipeds\nmv ~/Downloads/Data_*.csv data/ipeds\n# get thecb data\ncd data && make all\n# load data\n# timing: 10m25.069s\nmake load\n# post-process the data\npython exampleproject/manage.py tx_highered_process\n\n\n####################################\n# placeholder for post-2014 update #\n####################################\n# the 2012->2014 specific stuff can go out and the above importing\n# instructions can get updated\n```\n\n### Database\n\nThis project currently requires a PostGIS database (hopefully not for long):\n\n```bash\n$ phd createdb\n$ phd psql\n\nCREATE EXTENSION postgis;\nCREATE EXTENSION postgis_topology;\n```\n\n#### Moving data between databases\n\nYou can do a sql dump to move data from one postgres database to another\n(excluding geo info):\n\n```bash\n$ phd SOURCE_DATABASE_URL pg_dump --no-owner --no-acl --table=tx_highered* --clean > tx_highered.sql\n$ phd DEST_DATABASE_URL psql -f tx_highered.sql\n```\n\n#### After deploy\n\n1. Freeze the current data in a fixture\n 1. Edit the tx_highered_YYYY.json.gz make task\n 2. Run the task to save the data\n2. Adjust the loading scripts to reference the new fixture\n3. Deprecate (or delete) any one-time data migration scripts, e.g.\n 2014_update.py won't be necessary after 2015\n\n\nGetting Data from the IPEDS Data Center\n-----------------\nWhen it asks you for an Institution, enter a list of UnitIDs generated by:\n\n\tlist(Institution.objects.filter(ipeds_id__isnull=False).values_list('ipeds_id', flat=True))\n\nGetting Data from the Texas Higher Education Coordinating Board\n------------------\nIf you want to regrab data from THECB's web site, first find the data file that you want to re-grab.\nIt will be named something like \"top_10_percent.html\". There will also be a file called \"top_10_percent.POST\". From that file you can recreate the report with the command:\n\n curl -X POST -d @top_10_percent.POST http://www.txhighereddata.org/interactive/accountability/InteractiveGenerate.cfm -s -v > blahblahblah.html\n\nIf you need to modify the report, you can reverse engineer it from the POST data and the form markup.\n\n\n\n\n(c) 2012 The Texas Tribune\n", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/texastribune/tx_highered/", "keywords": null, "license": "Apache Software License", "maintainer": null, "maintainer_email": null, "name": "tx_highered", "package_url": "https://pypi.org/project/tx_highered/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/tx_highered/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://github.com/texastribune/tx_highered/" }, "release_url": "https://pypi.org/project/tx_highered/0.3.5/", "requires_dist": null, "requires_python": null, "summary": "Django app for Texas higher education data", "version": "0.3.5" }, "last_serial": 1466074, "releases": { "0.3.0": [ { "comment_text": "", "digests": { "md5": "3b01113cd430a01a418d7db4437e1ea0", "sha256": "ca7c742d1fd32c74341db44790136e46c7a4e2101de6b0ed49db93c4a7bb0571" }, "downloads": -1, "filename": "tx_highered-0.3.0-py2-none-any.whl", "has_sig": false, "md5_digest": "3b01113cd430a01a418d7db4437e1ea0", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 920995, "upload_time": "2015-02-06T22:58:15", "url": "https://files.pythonhosted.org/packages/11/a0/71f8ce1bef32972470c9b243e41bdcfc444fbf5d368d6c483f1dbacc6b77/tx_highered-0.3.0-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4e74a7474befcfdb75b95d16b4e3cb26", "sha256": "f88e8a06ae48d43f1df5914c54484d2a07e19d5e319ce5af3c0e7ffb23fa1e5c" }, "downloads": -1, "filename": "tx_highered-0.3.0.tar.gz", "has_sig": false, "md5_digest": "4e74a7474befcfdb75b95d16b4e3cb26", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 826233, "upload_time": "2015-02-06T22:58:11", "url": "https://files.pythonhosted.org/packages/40/3f/c6bcf1f20ac6ee9c8492c3e02587f56a5bd832177eb9de2a7f501b0805bb/tx_highered-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "79278e434605f995da8fd2d7f500e586", "sha256": "a81c5f2aae329df9e1fe00641199ccb3bb2cb093cce4d6594d8ee857500d07fc" }, "downloads": -1, "filename": "tx_highered-0.3.1-py2-none-any.whl", "has_sig": false, "md5_digest": "79278e434605f995da8fd2d7f500e586", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 661078, "upload_time": "2015-02-09T19:03:41", "url": "https://files.pythonhosted.org/packages/61/e0/4c371f750e97babdd31f197abf900d945b79c22a7ff8273c437dda53981e/tx_highered-0.3.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "13919ff93c9cb91c3fa149ae447cc477", "sha256": "b3bdcc173fa5e624109a481c2d23d442465c5a967503affc5be99a847c2b4246" }, "downloads": -1, "filename": "tx_highered-0.3.1.tar.gz", "has_sig": false, "md5_digest": "13919ff93c9cb91c3fa149ae447cc477", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 619677, "upload_time": "2015-02-09T19:03:37", "url": "https://files.pythonhosted.org/packages/64/92/b0c6c14b543de983415a91ec83181dafc15d19894a69e34f04fe94bb2734/tx_highered-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "6aab55a070b52e1f83d20f8b455fe920", "sha256": "b16c07c21e2104b0cea00a370c65d91874321128ac4d1d46d0d5f1ee2479b7bf" }, "downloads": -1, "filename": "tx_highered-0.3.2-py2-none-any.whl", "has_sig": false, "md5_digest": "6aab55a070b52e1f83d20f8b455fe920", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 660097, "upload_time": "2015-02-11T00:38:13", "url": "https://files.pythonhosted.org/packages/38/d2/a8e7747d0400d6c376d9e0fb03dd9cf609498830fcc2ee4c0eda35530150/tx_highered-0.3.2-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9e2b137bd6ac118f95927b818f708660", "sha256": "2046851ba0a4d459a3743623c12445bf680f3ee985bb3f0aeedc5b4f3e5d8603" }, "downloads": -1, "filename": "tx_highered-0.3.2.tar.gz", "has_sig": false, "md5_digest": "9e2b137bd6ac118f95927b818f708660", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 618371, "upload_time": "2015-02-11T00:38:10", "url": "https://files.pythonhosted.org/packages/37/87/fb5c458259a595bdba52824e78157fbb3fca8b40ef832f0dee22ff2f8658/tx_highered-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "", "digests": { "md5": "467753067c60bdbf6904844a0051be70", "sha256": "a3d77bb9b332efe5ad112184c6dd879ae58da8445dd29c5d7a8060f2e7aa85fc" }, "downloads": -1, "filename": "tx_highered-0.3.3-py2-none-any.whl", "has_sig": false, "md5_digest": "467753067c60bdbf6904844a0051be70", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 660054, "upload_time": "2015-02-11T21:46:16", "url": "https://files.pythonhosted.org/packages/31/b0/20ab3d4b9fc76235041b107a0cda5dd56fad9b2089be36dd4f0c98f51201/tx_highered-0.3.3-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8a727074f678d15a5c8da30e1f2f64eb", "sha256": "0793090df59aa2c34b2da8eec994db22a209694dad4a5a18684f83e737a82ecd" }, "downloads": -1, "filename": "tx_highered-0.3.3.tar.gz", "has_sig": false, "md5_digest": "8a727074f678d15a5c8da30e1f2f64eb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 618340, "upload_time": "2015-02-11T21:46:14", "url": "https://files.pythonhosted.org/packages/af/94/3802a27ae071c7e21dfaf5df411e46286359aa272b7fe127be3a2b5da3e6/tx_highered-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "1047d0bd4e6cd54a6d92459bc185821d", "sha256": "4c2c1f4a8ca7b1298d8488630cc32d2350025d8f94d940e8f377a3b325a946a2" }, "downloads": -1, "filename": "tx_highered-0.3.4-py2-none-any.whl", "has_sig": false, "md5_digest": "1047d0bd4e6cd54a6d92459bc185821d", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 681023, "upload_time": "2015-02-16T19:41:37", "url": "https://files.pythonhosted.org/packages/d1/e0/c3aae62ad70f2c64c866770f6552a458a9c1ace6f63a62a0786f69738eba/tx_highered-0.3.4-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0820e6ee888f4496dc2c5d562b32dc63", "sha256": "ff7f5db9a7aa909be9fe6daa8ef68f753af6928e5a13591744721ac2da2a58ac" }, "downloads": -1, "filename": "tx_highered-0.3.4.tar.gz", "has_sig": false, "md5_digest": "0820e6ee888f4496dc2c5d562b32dc63", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633683, "upload_time": "2015-02-16T19:41:34", "url": "https://files.pythonhosted.org/packages/e9/ff/3bcc14ba59a94972345c0960d8c7fca6a8c1e36009795706c046eaaecc00/tx_highered-0.3.4.tar.gz" } ], "0.3.5": [ { "comment_text": "", "digests": { "md5": "f12a5e533c418aedbb39331517ee8edc", "sha256": "ebbb453e0ecf2689b2774cc41a51ad296a73944ddd0012454506625f8f7a7e6b" }, "downloads": -1, "filename": "tx_highered-0.3.5-py2-none-any.whl", "has_sig": false, "md5_digest": "f12a5e533c418aedbb39331517ee8edc", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 848374, "upload_time": "2015-03-17T21:27:46", "url": "https://files.pythonhosted.org/packages/78/fb/48d6da2cd03842742601eaa3e456a8c55b95c8929716c82d8b9d10b8acdd/tx_highered-0.3.5-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "74b5bcc0e3baa5b7229cc891ef2c038a", "sha256": "e237278c1606d088d675177a1d9e32212a0e038370dbed7a164ee28b1175a7ae" }, "downloads": -1, "filename": "tx_highered-0.3.5.tar.gz", "has_sig": false, "md5_digest": "74b5bcc0e3baa5b7229cc891ef2c038a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 783273, "upload_time": "2015-03-17T21:27:42", "url": "https://files.pythonhosted.org/packages/16/ab/7cf2006915f7ecad73a2172ec7e9760f6d4d92107e09bfbeadd0a3174283/tx_highered-0.3.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "f12a5e533c418aedbb39331517ee8edc", "sha256": "ebbb453e0ecf2689b2774cc41a51ad296a73944ddd0012454506625f8f7a7e6b" }, "downloads": -1, "filename": "tx_highered-0.3.5-py2-none-any.whl", "has_sig": false, "md5_digest": "f12a5e533c418aedbb39331517ee8edc", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 848374, "upload_time": "2015-03-17T21:27:46", "url": "https://files.pythonhosted.org/packages/78/fb/48d6da2cd03842742601eaa3e456a8c55b95c8929716c82d8b9d10b8acdd/tx_highered-0.3.5-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "74b5bcc0e3baa5b7229cc891ef2c038a", "sha256": "e237278c1606d088d675177a1d9e32212a0e038370dbed7a164ee28b1175a7ae" }, "downloads": -1, "filename": "tx_highered-0.3.5.tar.gz", "has_sig": false, "md5_digest": "74b5bcc0e3baa5b7229cc891ef2c038a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 783273, "upload_time": "2015-03-17T21:27:42", "url": "https://files.pythonhosted.org/packages/16/ab/7cf2006915f7ecad73a2172ec7e9760f6d4d92107e09bfbeadd0a3174283/tx_highered-0.3.5.tar.gz" } ] }