units_with_maps

Table actions

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

9 rows where COUNTY = 9, MNG_AGENCY = 208 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 9 ✖

MNG_AGENCY 1

  • Kerman, City of · 9 ✖

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
569 569 568 {"type": "Polygon", "coordinates": [[[-120.07823, 36.72769], [-120.07822, 36.72856], [-120.07818, 36.7286], [-120.0773, 36.72861], [-120.07728, 36.72768], [-120.07819, 36.72766], [-120.07823, 36.72769]]]} Open Access 1 3343 Soroptimist Park 25628 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 2.141 Soroptimist Park 0 Local Park 2 4
654 654 653 {"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 3218 Plaza Park 23786 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 1.535 Plaza Park 0 Local Park 2 4
663 663 662 {"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 3276 Rotary Park 24689 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 15.165 Rotary Park 0 Local Park 2 4
812 812 811 {"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 48904 Katey's Kids Park 33621 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2 http://cityofkerman.net/kateys-kids-park/ Fresno 9 3.145 Katey's Kids Park 0 Local Park 2 4
5745 5745 5744 {"type": "Polygon", "coordinates": [[[-120.07377, 36.72311], [-120.07373, 36.72469], [-120.07369, 36.72471], [-120.07341, 36.72472], [-120.0734, 36.72438], [-120.07104, 36.7244], [-120.07054, 36.72434], [-120.07053, 36.72311], [-120.07377, 36.72311]]]} Open Access 1 3077 Lions Park 21320 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 10.346 Lions Park 0 Local Park 2 4
5746 5746 5745 {"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.72099], [-120.04591, 36.72062], [-120.04643, 36.72053]]]} Open Access 1 3182 B Street Park 15742 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 0.897 B Street Park 0 Local Park 2 4
6538 6538 6537 {"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 2965 Kerckhoff Park 20626 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 5.954 Kerckhoff Park 0 Local Park 2 4
6563 6563 6562 {"type": "Polygon", "coordinates": [[[-120.06838, 36.72162], [-120.06839, 36.72164], [-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 3436 Wooten Park 27753 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 1.493 Wooten Park 0 Local Park 2 4
11836 11836 11835 {"type": "Polygon", "coordinates": [[[-120.05598, 36.73356], [-120.05504, 36.73356], [-120.05503, 36.73332], [-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 24162 Kiwanis Park 20681 1151 Kerman, City of 212 City 2 City Agency 2 http://cityofkerman.net/parks-and-recreation-department/ City 2 1151 Kerman, City of 208 City 2 City Agency 2   Fresno 9 2.081 Kiwanis 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]);