car2go data
- 316 Vehicles
- One record for each car every ~15 minutes
- 18 Months of Data (June 2012 - December 2013)
- >10 million rows
Presented at
- Mar 17, 2014: PDX Tech Meetup
- Jan 12, 2013: MapCamp Portland
Raw Data
Note: All timestamps are in Pacific time.
Here is a script you can copy/paste to download and extract all the files
wget http://pin13.net/car2go/data/2012-06.txt.gz wget http://pin13.net/car2go/data/2012-07.txt.gz wget http://pin13.net/car2go/data/2012-08.txt.gz wget http://pin13.net/car2go/data/2012-09.txt.gz wget http://pin13.net/car2go/data/2012-10.txt.gz wget http://pin13.net/car2go/data/2012-12.txt.gz wget http://pin13.net/car2go/data/2013-01.txt.gz wget http://pin13.net/car2go/data/2013-02.txt.gz wget http://pin13.net/car2go/data/2013-03.txt.gz wget http://pin13.net/car2go/data/2013-04.txt.gz wget http://pin13.net/car2go/data/2013-05.txt.gz wget http://pin13.net/car2go/data/2013-06.txt.gz wget http://pin13.net/car2go/data/2013-07.txt.gz wget http://pin13.net/car2go/data/2013-08.txt.gz wget http://pin13.net/car2go/data/2013-09.txt.gz wget http://pin13.net/car2go/data/2013-10.txt.gz wget http://pin13.net/car2go/data/2013-11.txt.gz wget http://pin13.net/car2go/data/2013-12-01-one-day.txt.gz wget http://pin13.net/car2go/data/2013-12-01-one-day-with-hour.txt.gz wget http://pin13.net/car2go/data/2013-12-one-week.txt.gz wget http://pin13.net/car2go/data/2013-12.txt.gz wget http://pin13.net/car2go/data/sample.txt.gz gunzip *.gz
wget http://pin13.net/car2go/data/2012-06.sql.gz wget http://pin13.net/car2go/data/2012-07.sql.gz wget http://pin13.net/car2go/data/2012-08.sql.gz wget http://pin13.net/car2go/data/2012-09.sql.gz wget http://pin13.net/car2go/data/2012-10.sql.gz wget http://pin13.net/car2go/data/2012-12.sql.gz wget http://pin13.net/car2go/data/2013-01.sql.gz wget http://pin13.net/car2go/data/2013-02.sql.gz wget http://pin13.net/car2go/data/2013-03.sql.gz wget http://pin13.net/car2go/data/2013-04.sql.gz wget http://pin13.net/car2go/data/2013-05.sql.gz wget http://pin13.net/car2go/data/2013-06.sql.gz wget http://pin13.net/car2go/data/2013-07.sql.gz wget http://pin13.net/car2go/data/2013-08.sql.gz wget http://pin13.net/car2go/data/2013-09.sql.gz wget http://pin13.net/car2go/data/2013-10.sql.gz wget http://pin13.net/car2go/data/2013-11.sql.gz wget http://pin13.net/car2go/data/2013-12.sql.gz wget http://pin13.net/car2go/data/sample.sql.gz wget http://pin13.net/car2go/data/vehicles.sql.gz gunzip *.gz
postgres tables
CREATE TABLE "positions" (
"id" int4 NOT NULL,
"vehicle_id" int4,
"fuel_level" int2,
"interior_good" bool,
"exterior_good" bool,
"date" timestamp(6) NULL,
"location" "geography"
)
WITH (OIDS=FALSE);
CREATE INDEX "positions_pkey" ON positions" (id);
CREATE INDEX "position_gist" ON "positions" USING GIST (location);
CREATE INDEX "position_date" ON "positions" (date);
CREATE TABLE "vehicles" (
"id" int4,
"plate" varchar(6) COLLATE "default",
"vin" varchar(30) COLLATE "default"
)
WITH (OIDS=FALSE);
CREATE INDEX "vehicles_pkey" ON "vehicles" USING btree("id" ASC NULLS LAST);
