Name: Meter Inventory
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Meter Inventory

A. SUMMARY Dataset has meter inventory. B. HOW THE DATASET IS CREATED Data is an extract from SFMTA Meter API process. C. UPDATE PROCESS Dataset is updated daily to reflect any changes in meter inventory. D. HOW TO USE THIS DATASET E. RELATED DATASETS Meter Policies Meter Revenue
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:58.035624

Tables

Table 1

@usgov.city_of_san_francisco_meter_inventory.table_1

2.12 MB
36432 rows
41 columns


CREATE TABLE table_1 (
  "revisiondate" TIMESTAMP,
  "postid" VARCHAR,
  "parkingspaceid" BIGINT,
  "mspaystationid" VARCHAR,
  "spacenumber" BIGINT,
  "sensorflag" VARCHAR,
  "onoffstreettype" VARCHAR,
  "jurisdiction" VARCHAR,
  "pmdistrictid" DOUBLE,
  "blockfaceid" BIGINT,
  "activemeterflag" VARCHAR,
  "reasoncode" VARCHAR,
  "smartmeterflag" VARCHAR,
  "metertype" VARCHAR,
  "metervendor" VARCHAR,
  "metermodel" VARCHAR,
  "capcolor" VARCHAR,
  "pcobeat" VARCHAR,
  "oldratearea" VARCHAR,
  "streetid" DOUBLE,
  "streetname" VARCHAR,
  "streetnumber" DOUBLE,
  "paritydigitposition" BIGINT,
  "streetsegmentctrlnid" BIGINT,
  "orientation" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "legislationref" DOUBLE,
  "workorder" DOUBLE,
  "collectionroute" VARCHAR,
  "collectionsubroute" VARCHAR,
  "pmrroute" VARCHAR,
  "nfckey" VARCHAR,
  "collectionroutedesc" VARCHAR,
  "collectionsubroutedesc" VARCHAR,
  "sideofstreet" VARCHAR,
  "spacetype" VARCHAR,
  "towflag" VARCHAR,
  "paxflag" VARCHAR,
  "commercialflag" VARCHAR,
  "zone" VARCHAR
);