{"id":54,"date":"2020-07-20T13:15:58","date_gmt":"2020-07-20T20:15:58","guid":{"rendered":"https:\/\/connectedgovcom.wordpress.com\/?page_id=54"},"modified":"2024-06-07T18:56:17","modified_gmt":"2024-06-07T18:56:17","slug":"data","status":"publish","type":"page","link":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/data\/","title":{"rendered":"Methodology"},"content":{"rendered":"\n<div class=\"wp-block-group alignfull has-background-background-color has-background\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wp-block-paragraph\" style=\"font-size:1em\">These files are databases we compiled of public agencies in California showing their adoption of different &#8220;smart city&#8221; technologies. Click on the bold links to download each database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:1em\"><strong><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/07\/transit.xlsx\">Transportation Agencies<\/a> <\/strong>&#8211; database of transit agencies showing adoption of GTFS or Granicus<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:1em\"><strong><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/07\/transit.xlsx\">P<\/a><a href=\"https:\/\/www.ocf.berkeley.edu\/~connectedgov\/wp-content\/uploads\/2021\/08\/transit_dataFINAL.xlsx.zip\">rivate Transportation<\/a> <\/strong>&#8211; database of private transportation technologies: Uber, micro-mobility, and EV chargers <br><br><strong><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/07\/security.xlsx\">Security<\/a><\/strong> &#8211; database of police and public safety departments showing adoption of shotspotter, crime mapping, Nixle, and FEMA<br><br><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/07\/water-units.xlsx\"><strong>Water<\/strong><\/a> &#8211; database of water units<br><br><strong><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/07\/granicus.xlsx\">Granicus<\/a><\/strong> &#8211; database of Granicus adoption by city<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-nv-c-1-color has-alpha-channel-opacity has-nv-c-1-background-color has-background is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" style=\"font-size:2em\"><strong>Data Collection<\/strong><\/h2>\n\n\n\n<p class=\"has-text-align-left wp-block-paragraph\" style=\"font-size:1em\">These files provide installation instructions and other resources for web scraping software designed to measure the uptake of &#8220;Smart City&#8221; technologies.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:1em\">Please refer to the <a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/readme.docx\">README file<\/a> first for detailed instructions on how to implement the web scraping software.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:1em\"><span style=\"text-decoration:underline;\">Program Files<\/span><br>Sources can be scraped all at once or one at a time. Download the program files by clicking on the links.<\/p>\n\n\n\n<ul class=\"wp-block-list\" style=\"font-size:1em\">\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/overall.zip\">All sources<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/granicus.zip\">Granicus<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/granicus_transit.zip\">Granicus (transit agencies)<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/nixle.zip\">Nixle<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/transitfeeds.zip\">Transit feeds<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/crime_mapping.zip\">Crime-mapping<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/shotspotter.zip\">Shotspotter<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/connectedgovcom.files.wordpress.com\/2020\/08\/fema.zip\">FEMA-authorized alerts<\/a><\/li>\n\n\n\n<li style=\"font-size:1em\"><a href=\"https:\/\/www.ocf.berkeley.edu\/~connectedgov\/wp-content\/uploads\/2021\/08\/Transit-Webscraping-Script.ipynb_.zip\">Private Transportation<\/a> <\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>These files are databases we compiled of public agencies in California showing their adoption of different &#8220;smart city&#8221; technologies. Click on the bold links to download each database. Transportation Agencies &#8211; database of transit agencies showing adoption of GTFS or Granicus Private Transportation &#8211; database of private transportation technologies: Uber, micro-mobility, and EV chargers Security&hellip;&nbsp;<a href=\"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/data\/\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Methodology<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":857,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","footnotes":""},"class_list":["post-54","page","type-page","status-publish","has-post-thumbnail","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/PfkBdy-S","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/pages\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":14,"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/pages\/54\/revisions"}],"predecessor-version":[{"id":935,"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/pages\/54\/revisions\/935"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/media\/857"}],"wp:attachment":[{"href":"https:\/\/connectedgov.studentorg.berkeley.edu\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}