units_with_maps

Table actions

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

4 rows where DES_TP = 2 and LABEL_NAME = "John F. Kennedy Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 4 ✖

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
186 186 185 {"type": "Polygon", "coordinates": [[[-116.92039, 32.79828], [-116.92038, 32.80011], [-116.9183, 32.80011], [-116.91823, 32.80008], [-116.91822, 32.79828], [-116.92039, 32.79828]]]} Open Access 1 593 John F. Kennedy Park 20437 1092 El Cajon, City of 73 City 2 City Agency 2 http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html City 2 1092 El Cajon, City of 71 City 2 City Agency 2 http://www.ci.el-cajon.ca.us/your-government/departments/recreation/parks-playgrounds-sports-fields San Diego 4 10.159 John F. Kennedy Park 0 Local Park 2 4
3162 3162 3161 {"type": "Polygon", "coordinates": [[[-122.33239, 37.92644], [-122.33205, 37.92647], [-122.33205, 37.92789], [-122.33114, 37.92789], [-122.33104, 37.92786], [-122.33096, 37.9278], [-122.33089, 37.92772], [-122.33091, 37.92768], [-122.33076, 37.9271], [-122.33076, 37.92561], [-122.33167, 37.92558], [-122.33169, 37.92607], [-122.33239, 37.92608], [-122.33239, 37.92644]]]} Open Access 1 21938 John F. Kennedy Park 20439 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1274 Richmond, City of 20 City 2 City Agency 2   Contra Costa 12 6.812 John F. Kennedy Park 0 Local Park 2 4
9980 9980 9979 {"type": "MultiPolygon", "coordinates": [[[[-122.28084, 38.26895], [-122.28084, 38.27065], [-122.28078, 38.27066], [-122.28075, 38.27122], [-122.27676, 38.26949], [-122.27697, 38.26817], [-122.2763, 38.26736], [-122.27678, 38.26709], [-122.2782, 38.26902], [-122.28084, 38.26895]]], [[[-122.28633, 38.26048], [-122.28614, 38.2617], [-122.2858, 38.26258], [-122.2852, 38.26332], [-122.28333, 38.26476], [-122.28307, 38.26529], [-122.28421, 38.26589], [-122.28535, 38.26679], [-122.28569, 38.26761], [-122.28592, 38.26907], [-122.28652, 38.27045], [-122.28658, 38.27099], [-122.28632, 38.27184], [-122.28571, 38.27254], [-122.28367, 38.27364], [-122.2831, 38.27429], [-122.28261, 38.27516], [-122.28201, 38.27648], [-122.28188, 38.27691], [-122.28155, 38.27833], [-122.28202, 38.27914], [-122.28124, 38.28027], [-122.28108, 38.28014], [-122.28107, 38.2803], [-122.28091, 38.28017], [-122.2809, 38.27706], [-122.28092, 38.27665], [-122.28092, 38.27597], [-122.28089, 38.27503], [-122.28088, 38.27174], [-122.28091, 38.27156], [-122.28092, 38.27125], [-122.28093, 38.26712], [-122.28096, 38.26588], [-122.28097, 38.25989], [-122.28193, 38.25952], [-122.28176, 38.2591], [-122.28243, 38.25826], [-122.28334, 38.25722], [-122.28341, 38.2572], [-122.28344, 38.25727], [-122.2835, 38.25807], [-122.28363, 38.25841], [-122.28389, 38.25882], [-122.28427, 38.25916], [-122.28584, 38.25996], [-122.28633, 38.26048]]]]} Open Access 1 17175 John F. Kennedy Park 31350 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2 http://www.visitnapavalley.com/hiking_biking-kennedy_park_612.htm Napa 11 196.492 John F. Kennedy Park 1965 Local Park 2 4
14601 14601 14600 {"type": "Polygon", "coordinates": [[[-117.78764, 34.06767], [-117.78733, 34.06785], [-117.78491, 34.06836], [-117.78459, 34.06732], [-117.78755, 34.06674], [-117.78759, 34.06727], [-117.78764, 34.06767]]]} Open Access 1 44819 John F. Kennedy Park 20438 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2   Los Angeles 6 7.771 John F. Kennedy 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]);