{
    "info": {
        "author": "Alexander Gude",
        "author_email": "alex.public.account@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Science/Research",
            "License :: OSI Approved :: GNU General Public License v3 or later (GPLv3+)",
            "Natural Language :: English",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7",
            "Topic :: Utilities"
        ],
        "description": "SWITRS-to-SQLite\n================\n\n|Build Status|\n\nSWITRS-to-SQLite is a Python3 script that will convert the CSV files\nprovided by the California Highway Patrol's `Statewide Integrated\nTraffic Records System\n(SWITRS) <http://iswitrs.chp.ca.gov/Reports/jsp/userLogin.jsp>`__ and\nconvert them to an `SQLite3 <https://www.sqlite.org/>`__ database.\n\nInstructions to **download the SWITRS data** can be found\n`here <requesting_data.md>`__.\n\nInstallation\n------------\n\nThe best way to install SWITRS-to-SQLite is with ``pip``:\n\n.. code:: bash\n\n    pip install switrs-to-sqlite\n\nThis will give you access to the script simply by calling:\n\n.. code:: bash\n\n    switrs_to_sqlite --help\n\nYou can also clone this repository:\n\n.. code:: bash\n\n    git clone https://github.com/agude/SWITRS-to-SQLite.git\n    cd SWITRS-to-SQLite\n    ./switrs_to_sqlite/switrs_to_sqlite --help\n\nIf you clone the repository, SWITRS-to-SQLite can be installed as a\nlocal application using the ``setup.py`` script:\n\n.. code:: bash\n\n    git clone https://github.com/agude/SWITRS-to-SQLite.git\n    cd SWITRS-to-SQLite\n    ./setup.py install\n\nWhich, like using ``pip``, will give you access to the script by calling\n``switrs_to_sqlite``.\n\nSWITRS-to-SQLite requires only Python3.\n\nUsage\n-----\n\nUsing SWITRS-to-SQLite is simple, just point it to the unzipped files\nfrom SWITRS and it will run the conversion:\n\n.. code:: bash\n\n    switrs_to_sqlite \\\n    CollisionRecords.txt \\\n    PartyRecords.txt \\\n    VictimRecords.txt\n\nThe script also supports reading ``gzip``\\ ed records files:\n\n.. code:: bash\n\n    switrs_to_sqlite \\\n    CollisionRecords.txt.gz \\\n    PartyRecords.txt.gz \\\n    VictimRecords.txt.gz\n\nThe conversion process will take about an hour to write the database,\nwhich by default is saved to a file named ``switrs.sqlite3``. The output\nfile can be changed as follows:\n\n.. code:: bash\n\n    switrs_to_sqlite \\\n    CollisionRecords.txt \\\n    PartyRecords.txt \\\n    VictimRecords.txt \\\n    -o new_db_file.sql\n\nThe program provides the following help menu when called with\n``--help``:\n\n.. code:: bash\n\n    usage: switrs_to_sqlite [-h] [-o OUTPUT_FILE]\n                                 collision_record party_record victim_record\n\n    Convert SWITRS text files to a SQLite database\n\n    positional arguments:\n      collision_record      the CollisionRecords.txt file or the same file gzipped\n      party_record          the PartyRecords.txt file or the same file gzipped\n      victim_record         the VictimRecords.txt file or the same file gzipped\n\n    optional arguments:\n      -h, --help            show this help message and exit\n      -o OUTPUT_FILE, --output-file OUTPUT_FILE\n                            file to save the database to\n\nUnit Tests\n----------\n\nSWITRS-to-SQLite uses ``pytest`` to run unit tests (contained in the\n``tests`` folders). To run the tests, run this command from the base\ndirectory:\n\n.. code:: bash\n\n    python3 -m pytest -v\n\n.. |Build Status| image:: https://travis-ci.org/agude/SWITRS-to-SQLite.svg?branch=master\n   :target: https://travis-ci.org/agude/SWITRS-to-SQLite",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/agude/SWITRS-to-SQLite",
        "keywords": "switrs,sqlite,data",
        "license": "GPLv3+",
        "maintainer": "",
        "maintainer_email": "",
        "name": "switrs-to-sqlite",
        "package_url": "https://pypi.org/project/switrs-to-sqlite/",
        "platform": "any",
        "project_url": "https://pypi.org/project/switrs-to-sqlite/",
        "project_urls": {
            "Homepage": "https://github.com/agude/SWITRS-to-SQLite"
        },
        "release_url": "https://pypi.org/project/switrs-to-sqlite/2.3.1/",
        "requires_dist": null,
        "requires_python": ">=3.5, <4",
        "summary": "Script for converting SWITRS reports to SQLite.",
        "version": "2.3.1"
    },
    "last_serial": 5317853,
    "releases": {
        "0.9.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b1683b12826213a4e6a283b8555142a0",
                    "sha256": "314794975b09d12ad125b3d1c1daf50befb9620bb4d775ac937a4ea6d1a4cd54"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-0.9.0.tar.gz",
                "has_sig": false,
                "md5_digest": "b1683b12826213a4e6a283b8555142a0",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6878,
                "upload_time": "2016-10-31T00:09:15",
                "url": "https://files.pythonhosted.org/packages/54/b0/b024968e9f04ddb758b9ffcd647c0a369c7abb87fe0f9dc498f06103a8ac/switrs-to-sqlite-0.9.0.tar.gz"
            }
        ],
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "76e252141a865021e8d1abb208faf68a",
                    "sha256": "642c0775629e3923c404458f118f8f407b5ef8d4ee653c2a319cf379b2394107"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-1.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "76e252141a865021e8d1abb208faf68a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8023,
                "upload_time": "2016-10-31T04:13:06",
                "url": "https://files.pythonhosted.org/packages/f4/f7/d5edad23a48793a8438b085eb88ec4d436db66db6a71370f5a54a7e50a89/switrs-to-sqlite-1.0.0.tar.gz"
            }
        ],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1526f62f5c41bf3ba026db69f9facd53",
                    "sha256": "8209496c36de749cf644d6d9c372ba17935cf42c30c44e6dee6ec2c255e5f468"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "1526f62f5c41bf3ba026db69f9facd53",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8507,
                "upload_time": "2019-03-01T06:11:54",
                "url": "https://files.pythonhosted.org/packages/6f/d4/795d80ffdc91fc67e546979dede75df2b797d42971ee148ed8b7af59ac45/switrs-to-sqlite-1.1.0.tar.gz"
            }
        ],
        "2.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c83aacd63d2c650341d63807974fa116",
                    "sha256": "58444ae3c98e5d0e1cf46db8b6691d917919861605b69cd1878124cda3b12c03"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c83aacd63d2c650341d63807974fa116",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8439,
                "upload_time": "2019-03-04T04:57:23",
                "url": "https://files.pythonhosted.org/packages/23/75/7027808a03adc746050bef0fafd9601a9933fae2079cfb0094ea6a91ce78/switrs-to-sqlite-2.0.0.tar.gz"
            }
        ],
        "2.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "aeab549da688e7096b6fdd53587e3332",
                    "sha256": "19fed24e1fb69f1afe39cacd82ad69b237635e9730eaad759436148c8782cf82"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "aeab549da688e7096b6fdd53587e3332",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10127,
                "upload_time": "2019-03-04T05:39:10",
                "url": "https://files.pythonhosted.org/packages/0c/23/76fe230ebf899384048744a68b8bfddd663f4234e0b5660246f8b3914747/switrs-to-sqlite-2.0.1.tar.gz"
            }
        ],
        "2.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "893a871be87a5759a420e36afb01817f",
                    "sha256": "7296251626d1f7161e0d087cd80927b6670c58717ebffaf6766b6a508fb1e4cc"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "893a871be87a5759a420e36afb01817f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10120,
                "upload_time": "2019-03-04T06:38:04",
                "url": "https://files.pythonhosted.org/packages/47/84/2f3fe810a0a8fcfde613f8af18c7f6c8a7e7862d6d9231ddff35d1d4a68f/switrs-to-sqlite-2.0.2.tar.gz"
            }
        ],
        "2.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ca9a1e9693c5a077bae215a7a69a9741",
                    "sha256": "57547363c9659d4bd08c32c1570ca807fd3bff2d791ae13368ef4a149a1998ac"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "ca9a1e9693c5a077bae215a7a69a9741",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11107,
                "upload_time": "2019-03-05T05:19:43",
                "url": "https://files.pythonhosted.org/packages/fe/b5/0ba11460a446fe608e93820e0f72a8f6a7e86b773ccc908ca671cdf65a26/switrs-to-sqlite-2.1.0.tar.gz"
            }
        ],
        "2.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae24f560e5ec7b705eb308ea56888d2b",
                    "sha256": "7274642916814e3cef9fd27b94675d9797a952f9fb3776604f414f5281c27744"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "ae24f560e5ec7b705eb308ea56888d2b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11847,
                "upload_time": "2019-03-06T04:54:35",
                "url": "https://files.pythonhosted.org/packages/ef/09/a123b6e767467ad594b5746b8387b634d4b8b11c85872b3fd47402513108/switrs-to-sqlite-2.2.0.tar.gz"
            }
        ],
        "2.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6061faf43ccbbaa6f2c9291a9d3b0b05",
                    "sha256": "5400116fd2fcdf6ee7a59459e52cef6842e3d2a0e557011cd98e057e8820da57"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "6061faf43ccbbaa6f2c9291a9d3b0b05",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12102,
                "upload_time": "2019-05-19T05:13:34",
                "url": "https://files.pythonhosted.org/packages/c8/fe/323f824310080584f477cd71b53c2ffba9ee19f2bea225d6d6a4cbb9a20c/switrs-to-sqlite-2.3.0.tar.gz"
            }
        ],
        "2.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "513f3b52bc91e6502058ee441af3cf56",
                    "sha256": "41ad494d73a2d3b9b16b66da6a5616de92c51da01c44516892b8c51928ffed05"
                },
                "downloads": -1,
                "filename": "switrs-to-sqlite-2.3.1.tar.gz",
                "has_sig": false,
                "md5_digest": "513f3b52bc91e6502058ee441af3cf56",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5, <4",
                "size": 12040,
                "upload_time": "2019-05-26T04:28:27",
                "url": "https://files.pythonhosted.org/packages/2b/23/9412c8763ce6626c362565665abb1ccb295f54fc00b4bb007e2c273f45cd/switrs-to-sqlite-2.3.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "513f3b52bc91e6502058ee441af3cf56",
                "sha256": "41ad494d73a2d3b9b16b66da6a5616de92c51da01c44516892b8c51928ffed05"
            },
            "downloads": -1,
            "filename": "switrs-to-sqlite-2.3.1.tar.gz",
            "has_sig": false,
            "md5_digest": "513f3b52bc91e6502058ee441af3cf56",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.5, <4",
            "size": 12040,
            "upload_time": "2019-05-26T04:28:27",
            "url": "https://files.pythonhosted.org/packages/2b/23/9412c8763ce6626c362565665abb1ccb295f54fc00b4bb007e2c273f45cd/switrs-to-sqlite-2.3.1.tar.gz"
        }
    ]
}