superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2 and PARK_NAME = "2800 Acre Water Bank"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

ACCESS_TYP 1

  • Restricted Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1374 1374 1373 {"type": "MultiPolygon", "coordinates": [[[[-119.25231, 35.30226], [-119.25231, 35.30309], [-119.25223, 35.30311], [-119.25222, 35.30376], [-119.25231, 35.30378], [-119.2523, 35.30706], [-119.24691, 35.30706], [-119.24689, 35.31068], [-119.24358, 35.31069], [-119.24355, 35.31431], [-119.23468, 35.3143], [-119.23463, 35.31794], [-119.23107, 35.31795], [-119.23105, 35.31986], [-119.21949, 35.32], [-119.21947, 35.32536], [-119.21638, 35.3254], [-119.21635, 35.32721], [-119.21203, 35.32722], [-119.21196, 35.3323], [-119.21237, 35.33267], [-119.19869, 35.33266], [-119.19417, 35.33263], [-119.19407, 35.33993], [-119.18532, 35.33986], [-119.18533, 35.34355], [-119.18091, 35.34353], [-119.18092, 35.34642], [-119.17282, 35.34638], [-119.17281, 35.34627], [-119.17216, 35.3462], [-119.17025, 35.34618], [-119.16994, 35.3462], [-119.16942, 35.34631], [-119.16923, 35.34633], [-119.16921, 35.34661], [-119.16335, 35.34659], [-119.16335, 35.34615], [-119.16317, 35.34614], [-119.16314, 35.34659], [-119.1549, 35.34666], [-119.15433, 35.34673], [-119.15381, 35.34673], [-119.1538, 35.34675], [-119.14748, 35.3468], [-119.14746, 35.34678], [-119.14733, 35.34678], [-119.14702, 35.34685], [-119.14677, 35.34695], [-119.14658, 35.34707], [-119.14631, 35.34729], [-119.14554, 35.3473], [-119.14553, 35.34797], [-119.145, 35.34843], [-119.14497, 35.34842], [-119.14437, 35.34892], [-119.14412, 35.34909], [-119.1438, 35.34925], [-119.14342, 35.34939], [-119.14313, 35.34947], [-119.14132, 35.34975], [-119.14085, 35.34986], [-119.14051, 35.34998], [-119.13735, 35.3512], [-119.13733, 35.35119], [-119.13699, 35.3513], [-119.1356, 35.35161], [-119.13549, 35.35161], [-119.13497, 35.3515], [-119.13484, 35.35151], [-119.133, 35.35189], [-119.13144, 35.35085], [-119.13213, 35.35018], [-119.13545, 35.34873], [-119.13659, 35.34848], [-119.13659, 35.34756], [-119.13714, 35.3473], [-119.14146, 35.34564], [-119.14337, 35.34493], [-119.14412, 35.34462], [-119.14552, 35.34446], [-119.14552, 35.34558], [-119.14554, 35.34559], [-119.14565, 35.34507], [-119.15013, 35.34469], [-119.15125, 35.34468], [-119.15439, 35.3431], [-119.16039, 35.34305], [-119.16326, 35.34385], [-119.16327, 35.34414], [-119.16498, 35.34432], [-119.16768, 35.34402], [-119.16837, 35.34363], [-119.16913, 35.34254], [-119.16938, 35.34184], [-119.1713, 35.33983], [-119.17208, 35.33982], [-119.17212, 35.33618], [-119.17651, 35.33617], [-119.17656, 35.33253], [-119.18096, 35.33252], [-119.18107, 35.32415], [-119.18682, 35.32194], [-119.18726, 35.32181], [-119.197, 35.32044], [-119.19726, 35.32038], [-119.19748, 35.32027], [-119.19882, 35.32142], [-119.20352, 35.32537], [-119.20396, 35.32537], [-119.20396, 35.32535], [-119.19775, 35.32011], [-119.21331, 35.31076], [-119.21743, 35.30838], [-119.21775, 35.30826], [-119.21817, 35.30814], [-119.21859, 35.30805], [-119.21894, 35.30799], [-119.23869, 35.30597], [-119.2387, 35.30595], [-119.23866, 35.3057], [-119.24602, 35.30491], [-119.24784, 35.30307], [-119.25231, 35.30226]]], [[[-119.26408, 35.30353], [-119.25462, 35.30346], [-119.25393, 35.30397], [-119.25258, 35.30426], [-119.25258, 35.30378], [-119.25266, 35.30376], [-119.25266, 35.30311], [-119.25258, 35.30309], [-119.25258, 35.30216], [-119.25321, 35.30159], [-119.25464, 35.30088], [-119.25577, 35.30059], [-119.25736, 35.30052], [-119.25921, 35.30106], [-119.26113, 35.30122], [-119.26408, 35.30353]]]]} Restricted Access 2 2800 Acre Water Bank   15189 1019 Bakersfield, City of 244 City 2 City Agency 2 http://www.bakersfieldcity.us/recreation/ City 2 3054.419 2800 Acre Water Bank  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);