superunits_with_maps

Table actions

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

9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 208

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Kerman, City of · 9 ✖

ACCESS_TYP 1

  • Open Access · 9 ✖
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
1703 1703 1702 {"type": "Polygon", "coordinates": [[[-120.04643, 36.72053], [-120.04643, 36.72129], [-120.04598, 36.72129], [-120.04591, 36.72124], [-120.04593, 36.72104], [-120.04591, 36.72098], [-120.04591, 36.72062], [-120.04643, 36.72053]]]} Open Access 1 B Street Park   15742 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 0.897 B Street Park  
2584 2584 2583 {"type": "Polygon", "coordinates": [[[-120.075, 36.73368], [-120.07496, 36.7337], [-120.07388, 36.73373], [-120.07379, 36.73366], [-120.07381, 36.73265], [-120.075, 36.73264], [-120.075, 36.73368]]]} Open Access 1 Katey's Kids Park http://cityofkerman.net/kateys-kids-park/ 33621 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 3.144 Katey's Kids Park  
5720 5720 5719 {"type": "Polygon", "coordinates": [[[-120.06265, 36.72517], [-120.06264, 36.72659], [-120.06093, 36.72657], [-120.06093, 36.72516], [-120.06265, 36.72517]]]} Open Access 1 Kerckhoff Park   20626 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 5.954 Kerckhoff Park  
5757 5757 5756 {"type": "Polygon", "coordinates": [[[-120.05598, 36.73356], [-120.05504, 36.73356], [-120.05503, 36.73333], [-120.05497, 36.73327], [-120.05501, 36.73319], [-120.05501, 36.73266], [-120.05504, 36.73263], [-120.05544, 36.73263], [-120.05559, 36.73272], [-120.05596, 36.73271], [-120.05598, 36.73356]]]} Open Access 1 Kiwanis Park   20681 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 2.081 Kiwanis Park  
6254 6254 6253 {"type": "Polygon", "coordinates": [[[-120.07377, 36.72311], [-120.07373, 36.72469], [-120.07369, 36.72471], [-120.07341, 36.72472], [-120.07339, 36.72438], [-120.07104, 36.7244], [-120.07054, 36.72434], [-120.07053, 36.72311], [-120.07377, 36.72311]]]} Open Access 1 Lions Park   21320 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 10.349 Lions Park  
8239 8239 8238 {"type": "Polygon", "coordinates": [[[-120.06046, 36.72073], [-120.06043, 36.72244], [-120.06028, 36.72262], [-120.0601, 36.72247], [-120.06012, 36.72077], [-120.06031, 36.72063], [-120.06046, 36.72073]]]} Open Access 1 Plaza Park   23786 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1.535 Plaza Park  
9014 9014 9013 {"type": "Polygon", "coordinates": [[[-120.05519, 36.72379], [-120.05511, 36.72552], [-120.05161, 36.72545], [-120.05158, 36.72542], [-120.05157, 36.72538], [-120.05158, 36.72372], [-120.05519, 36.72379]]]} Open Access 1 Rotary Park   24689 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 15.164 Rotary Park  
9782 9782 9781 {"type": "Polygon", "coordinates": [[[-120.07823, 36.72769], [-120.07822, 36.72856], [-120.07818, 36.7286], [-120.0773, 36.72861], [-120.07728, 36.72768], [-120.07818, 36.72766], [-120.07823, 36.72769]]]} Open Access 1 Soroptimist Park   25628 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 2.141 Soroptimist Park  
11415 11415 11414 {"type": "Polygon", "coordinates": [[[-120.06838, 36.72162], [-120.06839, 36.72165], [-120.06837, 36.72211], [-120.06833, 36.7223], [-120.06829, 36.72233], [-120.06748, 36.7223], [-120.06745, 36.72228], [-120.06744, 36.72226], [-120.06745, 36.7219], [-120.06741, 36.72176], [-120.06742, 36.72173], [-120.06747, 36.72171], [-120.06835, 36.72161], [-120.06838, 36.72162]]]} Open Access 1 Wooten Park   27753 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1.492 Wooten Park  

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