units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, LABEL_NAME = "Neary Lagoon Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

DES_TP 1

ACCESS_TYP 1

  • Open Access · 2 ✖
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
2642 2642 2641 {"type": "Polygon", "coordinates": [[[-121.77036, 36.91276], [-121.76966, 36.91462], [-121.76892, 36.91543], [-121.7689, 36.91534], [-121.76866, 36.91515], [-121.76852, 36.91508], [-121.76829, 36.91459], [-121.76808, 36.91466], [-121.76782, 36.91477], [-121.76745, 36.91502], [-121.7671, 36.91554], [-121.7647, 36.91517], [-121.76472, 36.91506], [-121.765, 36.91488], [-121.76512, 36.91478], [-121.76522, 36.91467], [-121.76527, 36.91454], [-121.76553, 36.91449], [-121.76587, 36.91445], [-121.766, 36.91442], [-121.766, 36.9144], [-121.76584, 36.91429], [-121.766, 36.91417], [-121.76598, 36.91414], [-121.76635, 36.9138], [-121.76642, 36.91384], [-121.7669, 36.91348], [-121.76923, 36.91496], [-121.76958, 36.91459], [-121.76852, 36.91389], [-121.76951, 36.91258], [-121.77036, 36.91276]]]} Open Access 1 18092 Neary Lagoon Park 22681 1373 Watsonville, City of 13 City 2 City Agency 2 http://cityofwatsonville.org/parks-community-services City 2 1373 Watsonville, City of 13 City 2 City Agency 2   Santa Cruz 5 15.376 Neary Lagoon Park 0 Local Park 2 4
10295 10295 10294 {"type": "MultiPolygon", "coordinates": [[[[-122.03531, 36.96338], [-122.03531, 36.96359], [-122.03313, 36.96215], [-122.03324, 36.962], [-122.03531, 36.96338]]], [[[-122.03528, 36.96378], [-122.03526, 36.96405], [-122.03416, 36.96371], [-122.03415, 36.96372], [-122.03417, 36.96386], [-122.03416, 36.96406], [-122.03419, 36.96417], [-122.03422, 36.96421], [-122.03422, 36.96434], [-122.03426, 36.96446], [-122.03425, 36.96451], [-122.03421, 36.96456], [-122.03428, 36.9646], [-122.03438, 36.96459], [-122.03441, 36.96463], [-122.0344, 36.9647], [-122.03431, 36.96482], [-122.03426, 36.96494], [-122.03425, 36.96502], [-122.03427, 36.96512], [-122.03431, 36.9652], [-122.03437, 36.96529], [-122.03457, 36.96543], [-122.03465, 36.96552], [-122.03477, 36.9657], [-122.0348, 36.9658], [-122.03481, 36.96589], [-122.03478, 36.96601], [-122.03474, 36.96604], [-122.03469, 36.96605], [-122.03463, 36.96602], [-122.03449, 36.96592], [-122.0344, 36.96581], [-122.03433, 36.96577], [-122.0342, 36.96577], [-122.03414, 36.9658], [-122.03409, 36.96584], [-122.03406, 36.96596], [-122.03405, 36.96616], [-122.0341, 36.9662], [-122.03419, 36.96622], [-122.03421, 36.96624], [-122.03418, 36.96634], [-122.03411, 36.9664], [-122.03411, 36.96647], [-122.03413, 36.96653], [-122.03423, 36.96664], [-122.03429, 36.96674], [-122.03434, 36.96686], [-122.03434, 36.96695], [-122.03431, 36.96706], [-122.03423, 36.96716], [-122.03411, 36.96722], [-122.034, 36.96723], [-122.03386, 36.96721], [-122.03385, 36.96717], [-122.03369, 36.96714], [-122.03373, 36.96698], [-122.03367, 36.96648], [-122.03363, 36.96629], [-122.03361, 36.96598], [-122.03355, 36.9659], [-122.03355, 36.96563], [-122.03353, 36.96552], [-122.03358, 36.96539], [-122.03357, 36.96511], [-122.03364, 36.96505], [-122.03362, 36.96471], [-122.03311, 36.96443], [-122.03305, 36.96431], [-122.03251, 36.96408], [-122.0324, 36.96411], [-122.03209, 36.96394], [-122.03195, 36.96405], [-122.03157, 36.96414], [-122.03118, 36.96414], [-122.03073, 36.9655], [-122.03044, 36.96557], [-122.03041, 36.96549], [-122.03047, 36.96536], [-122.03046, 36.96523], [-122.03044, 36.96514], [-122.03034, 36.96505], [-122.03018, 36.96498], [-122.03003, 36.96497], [-122.02984, 36.96489], [-122.02967, 36.9648], [-122.0295, 36.96479], [-122.02935, 36.96475], [-122.02923, 36.96466], [-122.0291, 36.9645], [-122.0289, 36.96431], [-122.02876, 36.96423], [-122.02841, 36.96395], [-122.02805, 36.96355], [-122.02796, 36.96353], [-122.02789, 36.96354], [-122.02784, 36.96358], [-122.0278, 36.96366], [-122.02773, 36.9637], [-122.02767, 36.96347], [-122.0275, 36.96347], [-122.02762, 36.96289], [-122.02767, 36.96274], [-122.02812, 36.96176], [-122.02833, 36.96151], [-122.02862, 36.96125], [-122.02883, 36.96111], [-122.02911, 36.96098], [-122.02918, 36.96105], [-122.02904, 36.96118], [-122.02909, 36.96131], [-122.02909, 36.96137], [-122.02895, 36.96157], [-122.02899, 36.96167], [-122.02918, 36.96176], [-122.02938, 36.96165], [-122.02944, 36.96165], [-122.02947, 36.9617], [-122.02948, 36.9618], [-122.02954, 36.96186], [-122.02967, 36.9619], [-122.02986, 36.96204], [-122.03047, 36.96219], [-122.03077, 36.96231], [-122.03087, 36.96232], [-122.03126, 36.96248], [-122.03143, 36.96249], [-122.03162, 36.96237], [-122.03173, 36.96236], [-122.03183, 36.96238], [-122.03201, 36.96254], [-122.03213, 36.96258], [-122.03229, 36.96255], [-122.03245, 36.96243], [-122.03265, 36.96242], [-122.03279, 36.96252], [-122.03274, 36.96258], [-122.03275, 36.96259], [-122.03309, 36.96272], [-122.03319, 36.9628], [-122.03359, 36.96279], [-122.03375, 36.9628], [-122.03528, 36.96378]]]]} Open Access 1 18088 Neary Lagoon Park 22680 1320 Santa Cruz, City of 9 City 2 City Agency 2 http://www.cityofsantacruz.com/departments/parks-recreation City 2 1320 Santa Cruz, City of 9 City 2 City Agency 2   Santa Cruz 5 41.943 Neary Lagoon Park 0 Local Park 2 4

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]);