![]() This should be written for a new audience and should demonstrate the writing skills you have learned in your other classes. It should include:Ī clear and direct lede that tells us why we should keep reading, and what the main points of your work are. This should be written so that someone with no prior knowledge of your project can understand why this is interesting as well as what you have done. In bCourses, submit a full write-up of your project. Please submit your final data journalism project by Tuesday May 1 at 8pm. CREATE TABLE car_breakins (Įvent_time TIME WITHOUT TIME ZONE NOT NULL,īonus questions: where is this data from? Who compiled it? Can you sniff anything out from the Socrata metadata? Assigment I did use csvsql to generate a CREATE statement for you. Do you remember the function you need to make WKT point out of latitude and longitude values?.Import the data into a PostGIS database.San Francisco publishes car break in data. Start by writing down the steps you need to take, then … take them. Find all the zipcodes in San Francisco county? What about Fresno county? You can load the smaller, California only file from the week 13 data file - it’s counties.sql. Very large integer (> 2.1B or counties.sql, and then pruned it by loading it into Postgres and running: DELETE FROM counties WHERE statefp != '06' formatĪny number - this is the preferable format but some systems default to FLOAT if you don’t specify NUMERICĪ decimal number, synonymous with DOUBLE PRECISION- if you plan to do any math on the number, NUMERIC is preferable You’re almost always going to be using one of only a few: numeric, float, integer, text, char, varchar, and geometry. You can see the full list of data types that Postgres supports in the Postgres documentation. Floating point arithmetic is no exception. The short answer is “it has something to do with how computers store data” - As for almost any arcane topic in mathematics and computing there is a wikipedia article that goes deep on the finer points. Quick follow up to a conversation we had two weeks ago about why FLOAT is a synonym for DOUBLE PRECISION, and what that means to begin with. Please complete this survey: so we can get a handle on the problem. Use these instructions to find some basic information about your computer. My suspicion is that you could load it if you use the command line tools, but Postico wasn’t able to load the whole thing into its preview window - queueing it up so you can scroll around in it takes more memory than just loading it. I was surprised to discover that quite a few of you couldn’t actually load the US zipcode file into postgres via Postico. This command exports or “sets” a new PATH by concatenating the new directory ( /Applications/Postgres.app/Contents/Versions/10/bin/) that you want to include, with the existing values stored in PATH. PATH is the shell variable that contains the array of directories that bash looks in to find executable programs, and we print the contents of that variable with $PATH. profile, to add a line like: export PATH=/Applications/Postgres.app/Contents/Versions/10/bin/:$PATH ![]() To do that, you’re going to edit a hidden file in your home directory (probably /Users/yourname/) called. To add shp2pgsql so you can access it easily, you want to tell your shell that it needs to look in /Applications/Postgres.app/Contents/Versions/10/bin/ for programs. Alternatively, you can edit your PATH to include the path to the directory that includes that program. If you want to run a program that isn’t in your PATH variable, you have to use the “absolute path” - the full path to the program, starting with / for the root directory. Note that I manually added a few paths there: /usr/local/heroku/bin lets me run a handful of specialized heroku commands, and /opt/venvs/vdirsyncer-latest/bin/ lets me run vidirsyncer, which I’m super happy to talk about but is kind of a rabbit hole in this context. usr/ local/sbin:/usr/ local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/ local/games:/snap/bin:/usr/ local/heroku/bin:/opt/venvs/vdirsyncer-latest/bin/ Yours is probably different from mine, but on my primary laptop (which runs Ubuntu, not OSX), my path looks like this: echo $PATH If you run echo $PATH at the command line, you can see a list of all the directories your shell looks in for executable programs. Roughly, your command line interpreter, bash, uses a variable called PATH to decide where to look for programs to run. This is a good explanation of the command path issues we were navigating last time we worked in the terminal: Instructor: Amanda Hickman Fixing your path
0 Comments
Leave a Reply. |