units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where AGNCY_NAME = 31, DES_TP = 474 and MNG_AGENCY = 30

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Francisco - Public Utilities Commission, City and County of · 1 ✖

DES_TP 1

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
5925 5925 5924 {"type": "Polygon", "coordinates": [[[-122.44138, 37.61408], [-122.44117, 37.61412], [-122.44069, 37.61392], [-122.44002, 37.61339], [-122.43948, 37.61261], [-122.43864, 37.61177], [-122.43763, 37.61092], [-122.43671, 37.61028], [-122.43634, 37.60975], [-122.43625, 37.60948], [-122.43585, 37.6092], [-122.43502, 37.60891], [-122.43444, 37.60826], [-122.43427, 37.60785], [-122.43386, 37.60742], [-122.43315, 37.60696], [-122.433, 37.60668], [-122.43269, 37.60643], [-122.43245, 37.60595], [-122.43182, 37.60556], [-122.43113, 37.60494], [-122.43007, 37.60428], [-122.429, 37.60304], [-122.42866, 37.60291], [-122.42866, 37.60265], [-122.42805, 37.60208], [-122.42785, 37.60169], [-122.42702, 37.60087], [-122.42702, 37.60064], [-122.42725, 37.60053], [-122.4273, 37.60029], [-122.42656, 37.59972], [-122.4263, 37.59931], [-122.4259, 37.59895], [-122.42521, 37.59867], [-122.42492, 37.59842], [-122.42474, 37.59792], [-122.42394, 37.59723], [-122.42377, 37.59698], [-122.42371, 37.59661], [-122.42328, 37.59636], [-122.42239, 37.59643], [-122.42224, 37.59631], [-122.42218, 37.59526], [-122.42167, 37.59434], [-122.41931, 37.59171], [-122.41899, 37.59171], [-122.41879, 37.5918], [-122.41859, 37.59207], [-122.41859, 37.59288], [-122.41844, 37.59299], [-122.41819, 37.59299], [-122.41781, 37.5926], [-122.41764, 37.59228], [-122.41761, 37.59203], [-122.41793, 37.5915], [-122.41796, 37.59125], [-122.41784, 37.59111], [-122.41727, 37.59093], [-122.41727, 37.59073], [-122.41752, 37.59036], [-122.41764, 37.58917], [-122.41689, 37.58837], [-122.41661, 37.58784], [-122.41638, 37.58773], [-122.41637, 37.58752], [-122.41597, 37.58718], [-122.41505, 37.58692], [-122.41502, 37.58608], [-122.41416, 37.58534], [-122.41381, 37.58532], [-122.41347, 37.58553], [-122.4131, 37.58562], [-122.41298, 37.58553], [-122.41307, 37.5851], [-122.41295, 37.58495], [-122.41269, 37.58493], [-122.41238, 37.58502], [-122.4122, 37.58496], [-122.41154, 37.58502], [-122.4114, 37.58493], [-122.41143, 37.58452], [-122.41238, 37.58431], [-122.41261, 37.58418], [-122.41261, 37.58397], [-122.412, 37.58335], [-122.4114, 37.58305], [-122.41117, 37.58267], [-122.41082, 37.58262], [-122.41054, 37.58271], [-122.41016, 37.58271], [-122.40996, 37.58234], [-122.41008, 37.58209], [-122.41054, 37.58179], [-122.41057, 37.58127], [-122.41045, 37.58074], [-122.41085, 37.58049], [-122.41224, 37.58006], [-122.41246, 37.5801], [-122.41284, 37.58042], [-122.41341, 37.58063], [-122.4141, 37.58076], [-122.41482, 37.58061], [-122.41689, 37.58061], [-122.41741, 37.58068], [-122.41738, 37.58088], [-122.41707, 37.58104], [-122.41675, 37.58109], [-122.41517, 37.582], [-122.41506, 37.58221], [-122.41548, 37.58267], [-122.41563, 37.58301], [-122.41615, 37.58329], [-122.41661, 37.58365], [-122.41713, 37.58381], [-122.41902, 37.58388], [-122.41899, 37.58404], [-122.41856, 37.58443], [-122.4183, 37.58503], [-122.41836, 37.58534], [-122.41845, 37.58557], [-122.41905, 37.58617], [-122.41946, 37.58672], [-122.41974, 37.5869], [-122.42037, 37.587], [-122.42063, 37.58713], [-122.42075, 37.58745], [-122.42101, 37.5877], [-122.42196, 37.58796], [-122.42262, 37.58802], [-122.42382, 37.58789], [-122.42432, 37.58761], [-122.4246, 37.58764], [-122.42414, 37.58853], [-122.42417, 37.58871], [-122.42472, 37.58892], [-122.42742, 37.58853], [-122.42794, 37.58862], [-122.42788, 37.58876], [-122.42742, 37.58894], [-122.42711, 37.58917], [-122.42636, 37.58949], [-122.42575, 37.59011], [-122.42552, 37.59057], [-122.42564, 37.59086], [-122.42587, 37.59112], [-122.42584, 37.5913], [-122.42558, 37.59148], [-122.42549, 37.59171], [-122.42552, 37.59247], [-122.42567, 37.59279], [-122.42587, 37.59297], [-122.42595, 37.59322], [-122.42633, 37.59354], [-122.42742, 37.59402], [-122.42805, 37.59439], [-122.42857, 37.5945], [-122.43027, 37.59432], [-122.43061, 37.5945], [-122.43044, 37.59494], [-122.43047, 37.59526], [-122.43099, 37.59567], [-122.43102, 37.59599], [-122.43093, 37.59613], [-122.43038, 37.59631], [-122.42926, 37.59638], [-122.42906, 37.59652], [-122.42895, 37.59691], [-122.42906, 37.59716], [-122.4305, 37.59796], [-122.43119, 37.59812], [-122.43277, 37.59881], [-122.4343, 37.59993], [-122.43427, 37.60014], [-122.43378, 37.60073], [-122.43378, 37.60119], [-122.43401, 37.60158], [-122.43424, 37.60169], [-122.43556, 37.60183], [-122.43594, 37.60201], [-122.43628, 37.6024], [-122.43634, 37.60286], [-122.43651, 37.60304], [-122.43692, 37.60298], [-122.43738, 37.60302], [-122.43801, 37.6033], [-122.43893, 37.60321], [-122.43953, 37.60353], [-122.43979, 37.60387], [-122.43994, 37.60426], [-122.44066, 37.6052], [-122.44109, 37.60561], [-122.44117, 37.60579], [-122.44115, 37.60632], [-122.44103, 37.60662], [-122.44022, 37.60728], [-122.44002, 37.60735], [-122.43942, 37.60694], [-122.43801, 37.60659], [-122.43754, 37.60625], [-122.43712, 37.60623], [-122.43654, 37.60654], [-122.43643, 37.60696], [-122.4366, 37.60737], [-122.4372, 37.60797], [-122.43781, 37.60831], [-122.43795, 37.60865], [-122.43821, 37.609], [-122.43844, 37.60994], [-122.44025, 37.61158], [-122.44083, 37.61243], [-122.44137, 37.61362], [-122.44138, 37.61408]]]} Restricted Access 2 408 San Francisco Watershed Lands 24889 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   San Mateo 15 478.92 San Francisco Watershed Lands   None 474  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);