units_with_maps

Table actions

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

13 rows where COUNTY = 11, DES_TP = 2 and MNG_AGENCY = 428

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • American Canyon, City of · 13 ✖

DES_TP 1

  • Local Park · 13 ✖

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
1860 1860 1859 {"type": "Polygon", "coordinates": [[[-122.25881, 38.16563], [-122.25708, 38.16557], [-122.25695, 38.16477], [-122.25719, 38.16478], [-122.25771, 38.16491], [-122.25778, 38.16488], [-122.25793, 38.16467], [-122.25798, 38.16468], [-122.25862, 38.16504], [-122.25843, 38.16526], [-122.25881, 38.16563]]]} Open Access 1 14200 Northampton Park 22865 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 2.9 Northampton Park 0 Local Park 2 4
8535 8535 8534 {"type": "MultiPolygon", "coordinates": [[[[-122.26479, 38.15542], [-122.26477, 38.15543], [-122.26472, 38.16056], [-122.26232, 38.16079], [-122.26209, 38.16108], [-122.26201, 38.16106], [-122.26202, 38.16082], [-122.2616, 38.16088], [-122.26148, 38.16121], [-122.26164, 38.16149], [-122.26183, 38.16156], [-122.26204, 38.16188], [-122.26173, 38.16192], [-122.26173, 38.16174], [-122.26152, 38.16152], [-122.26146, 38.16132], [-122.26122, 38.16131], [-122.26114, 38.16137], [-122.26104, 38.16132], [-122.26093, 38.16133], [-122.26087, 38.16122], [-122.26066, 38.16125], [-122.26044, 38.16134], [-122.2605, 38.16165], [-122.26027, 38.16173], [-122.26027, 38.1606], [-122.26068, 38.16062], [-122.26068, 38.15862], [-122.26228, 38.15844], [-122.2636, 38.15841], [-122.2636, 38.15877], [-122.26386, 38.15894], [-122.26447, 38.15892], [-122.26462, 38.15867], [-122.26466, 38.15538], [-122.26479, 38.15538], [-122.26479, 38.15542]]], [[[-122.26005, 38.16085], [-122.26004, 38.16086], [-122.26002, 38.1619], [-122.25998, 38.16193], [-122.25982, 38.16197], [-122.25968, 38.16202], [-122.25949, 38.16215], [-122.25948, 38.16197], [-122.25919, 38.16194], [-122.25919, 38.16188], [-122.25915, 38.16183], [-122.2591, 38.1618], [-122.25903, 38.16178], [-122.25894, 38.1618], [-122.25887, 38.16185], [-122.25872, 38.16178], [-122.25856, 38.16177], [-122.25834, 38.16182], [-122.25821, 38.16189], [-122.25818, 38.16196], [-122.25807, 38.16197], [-122.25798, 38.16202], [-122.25785, 38.16195], [-122.25748, 38.16197], [-122.25615, 38.16194], [-122.25619, 38.16129], [-122.25767, 38.1613], [-122.25861, 38.16121], [-122.2596, 38.16103], [-122.2598, 38.16092], [-122.25989, 38.1608], [-122.26001, 38.1608], [-122.26004, 38.16082], [-122.26005, 38.16085]]], [[[-122.25595, 38.16129], [-122.25592, 38.1614], [-122.25591, 38.16211], [-122.25546, 38.162], [-122.25522, 38.16205], [-122.25514, 38.16217], [-122.25503, 38.16215], [-122.25493, 38.16219], [-122.25489, 38.16225], [-122.25488, 38.1623], [-122.2549, 38.16235], [-122.25496, 38.16243], [-122.25477, 38.16243], [-122.25469, 38.16248], [-122.25446, 38.16273], [-122.25445, 38.16285], [-122.25438, 38.16286], [-122.25432, 38.16289], [-122.25429, 38.16293], [-122.25427, 38.16299], [-122.25415, 38.16299], [-122.25382, 38.16331], [-122.25366, 38.16341], [-122.25366, 38.16359], [-122.25359, 38.16356], [-122.25352, 38.16355], [-122.25345, 38.16357], [-122.25339, 38.16361], [-122.25337, 38.16367], [-122.25337, 38.16372], [-122.2534, 38.16377], [-122.25345, 38.16381], [-122.25343, 38.16408], [-122.25318, 38.16407], [-122.25339, 38.16132], [-122.25397, 38.16134], [-122.25399, 38.16127], [-122.25595, 38.16129]]]]} Open Access 1 13421 Kimberly Park 20648 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 39.792 Kimberly Park 0 Local Park 2 4
8745 8745 8744 {"type": "Polygon", "coordinates": [[[-122.26381, 38.16293], [-122.26252, 38.16345], [-122.26264, 38.16365], [-122.26255, 38.1637], [-122.26252, 38.16376], [-122.26253, 38.16382], [-122.26259, 38.16389], [-122.26266, 38.16391], [-122.26266, 38.1641], [-122.26273, 38.16422], [-122.26319, 38.16423], [-122.26317, 38.16429], [-122.26289, 38.16436], [-122.26289, 38.16451], [-122.26264, 38.16468], [-122.26261, 38.16464], [-122.26264, 38.16454], [-122.26258, 38.1643], [-122.26259, 38.16413], [-122.26236, 38.16404], [-122.26238, 38.164], [-122.26237, 38.16393], [-122.26233, 38.16387], [-122.26228, 38.16385], [-122.26231, 38.16364], [-122.2622, 38.1636], [-122.26122, 38.16399], [-122.26118, 38.16408], [-122.26112, 38.16399], [-122.26094, 38.16407], [-122.26094, 38.16408], [-122.261, 38.16415], [-122.26088, 38.16412], [-122.26026, 38.16437], [-122.26017, 38.16457], [-122.26029, 38.16463], [-122.26027, 38.16469], [-122.26028, 38.16473], [-122.26032, 38.16479], [-122.26024, 38.16484], [-122.26014, 38.16486], [-122.26011, 38.1648], [-122.26, 38.16474], [-122.26004, 38.16457], [-122.25984, 38.1645], [-122.25975, 38.16449], [-122.25901, 38.1648], [-122.25887, 38.16495], [-122.2584, 38.16471], [-122.25929, 38.16434], [-122.25919, 38.16431], [-122.2592, 38.16426], [-122.25912, 38.16413], [-122.25905, 38.1641], [-122.25907, 38.16402], [-122.25905, 38.16398], [-122.25897, 38.16392], [-122.25889, 38.1639], [-122.25871, 38.16368], [-122.2586, 38.1635], [-122.25868, 38.16346], [-122.25887, 38.16359], [-122.25902, 38.16376], [-122.25919, 38.16378], [-122.25919, 38.16383], [-122.25922, 38.16389], [-122.25936, 38.16395], [-122.25936, 38.16412], [-122.25945, 38.1642], [-122.26059, 38.16367], [-122.26063, 38.16358], [-122.26075, 38.16375], [-122.26092, 38.16368], [-122.26083, 38.1635], [-122.26095, 38.16353], [-122.26168, 38.16324], [-122.26202, 38.16317], [-122.26244, 38.163], [-122.26245, 38.16286], [-122.26218, 38.16277], [-122.2622, 38.16271], [-122.26217, 38.16264], [-122.26214, 38.1626], [-122.26203, 38.16257], [-122.26192, 38.1623], [-122.26187, 38.16206], [-122.26198, 38.16204], [-122.26204, 38.16223], [-122.26226, 38.1624], [-122.26245, 38.16248], [-122.26244, 38.16254], [-122.26246, 38.1626], [-122.26251, 38.16265], [-122.2625, 38.16279], [-122.26256, 38.16286], [-122.26269, 38.1629], [-122.26369, 38.16249], [-122.26373, 38.16254], [-122.26373, 38.16272], [-122.26381, 38.16293]]]} Open Access 1 14202 Elliott Park 18590 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 8.099 Elliott Park 0 Local Park 2 4
8747 8747 8746 {"type": "Polygon", "coordinates": [[[-122.25601, 38.17428], [-122.25487, 38.17441], [-122.25486, 38.17432], [-122.25496, 38.17431], [-122.25493, 38.17412], [-122.25596, 38.17401], [-122.25601, 38.17428]]]} Open Access 1 14209 Melvin Park 22114 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 0.72 Melvin Park 0 Local Park 2 4
8748 8748 8747 {"type": "Polygon", "coordinates": [[[-122.23545, 38.1614], [-122.23492, 38.16177], [-122.23451, 38.16159], [-122.23496, 38.16096], [-122.23508, 38.1609], [-122.23525, 38.16116], [-122.23545, 38.1614]]]} Open Access 1 14211 Via Bellagio Park 27064 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 0.994 Via Bellagio Park 2002 Local Park 2 4
8749 8749 8748 {"type": "Polygon", "coordinates": [[[-122.23961, 38.16213], [-122.23949, 38.16217], [-122.23924, 38.16215], [-122.23903, 38.161], [-122.23897, 38.16087], [-122.23885, 38.16084], [-122.2387, 38.1609], [-122.23836, 38.16091], [-122.23805, 38.16085], [-122.23818, 38.16039], [-122.23853, 38.16034], [-122.23912, 38.15992], [-122.23936, 38.16091], [-122.23961, 38.16213]]]} Open Access 1 14213 Montecarlo Park 22408 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 2.979 Montecarlo Park 2002 Local Park 2 4
9688 9688 9687 {"type": "Polygon", "coordinates": [[[-122.25145, 38.17329], [-122.25132, 38.17587], [-122.24971, 38.17597], [-122.24975, 38.17328], [-122.25145, 38.17329]]]} Open Access 1 16361 Main Street Park 21690 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 10.509 Main Street Park 2006 Local Park 2 4
9689 9689 9688 {"type": "Polygon", "coordinates": [[[-122.23537, 38.15763], [-122.23535, 38.15768], [-122.23501, 38.15794], [-122.23444, 38.15748], [-122.23484, 38.15717], [-122.23501, 38.15708], [-122.23509, 38.1571], [-122.23537, 38.15763]]]} Open Access 1 16362 Pelleria Park 23569 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 1.052 Pelleria Park 2004 Local Park 2 4
10121 10121 10120 {"type": "Polygon", "coordinates": [[[-122.25007, 38.16579], [-122.25006, 38.16611], [-122.24926, 38.16618], [-122.24901, 38.16619], [-122.24855, 38.16624], [-122.24795, 38.16628], [-122.24767, 38.16632], [-122.24714, 38.16636], [-122.24707, 38.16634], [-122.24676, 38.16635], [-122.24673, 38.16638], [-122.24666, 38.16636], [-122.2466, 38.16636], [-122.24648, 38.16624], [-122.24617, 38.16623], [-122.24613, 38.16637], [-122.2461, 38.16692], [-122.24607, 38.16705], [-122.24567, 38.16833], [-122.24481, 38.16833], [-122.24437, 38.16835], [-122.24436, 38.16612], [-122.24297, 38.1657], [-122.24259, 38.16565], [-122.2424, 38.16566], [-122.24223, 38.16562], [-122.24167, 38.16545], [-122.24143, 38.16543], [-122.24137, 38.16545], [-122.24127, 38.16537], [-122.24113, 38.16538], [-122.24109, 38.16533], [-122.24066, 38.16533], [-122.24065, 38.16534], [-122.24096, 38.16671], [-122.24044, 38.16609], [-122.24015, 38.16562], [-122.24004, 38.16511], [-122.24004, 38.16489], [-122.24005, 38.16481], [-122.24015, 38.16476], [-122.24066, 38.16488], [-122.24128, 38.16496], [-122.24386, 38.16536], [-122.24448, 38.16579], [-122.24464, 38.16579], [-122.2447, 38.16598], [-122.24471, 38.16623], [-122.24684, 38.16591], [-122.2472, 38.16605], [-122.24759, 38.16583], [-122.24809, 38.16587], [-122.24906, 38.16569], [-122.24923, 38.16559], [-122.24923, 38.16557], [-122.24991, 38.16564], [-122.25007, 38.16579]]]} Open Access 1 17590 Silver Oak Park 25492 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 19.202 Silver Oak Park 2006 Local Park 2 4
10122 10122 10121 {"type": "Polygon", "coordinates": [[[-122.24673, 38.1727], [-122.24652, 38.17245], [-122.24632, 38.17212], [-122.24572, 38.17098], [-122.24564, 38.171], [-122.24564, 38.17095], [-122.24509, 38.1698], [-122.24504, 38.16965], [-122.24502, 38.16951], [-122.24501, 38.16921], [-122.24495, 38.16856], [-122.24502, 38.16856], [-122.24511, 38.16849], [-122.24562, 38.1685], [-122.24562, 38.16866], [-122.24567, 38.16893], [-122.24569, 38.16921], [-122.24593, 38.16921], [-122.24604, 38.16925], [-122.24617, 38.16922], [-122.24652, 38.16923], [-122.24659, 38.16931], [-122.24659, 38.17036], [-122.2467, 38.17036], [-122.2467, 38.1719], [-122.24663, 38.17192], [-122.24673, 38.1727]]]} Open Access 1 17591 Shenandoah Park 25389 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 9.048 Shenandoah Park 2008 Local Park 2 4
10123 10123 10122 {"type": "Polygon", "coordinates": [[[-122.25278, 38.15531], [-122.2528, 38.15702], [-122.25268, 38.15846], [-122.25237, 38.163], [-122.25231, 38.16505], [-122.25224, 38.16546], [-122.25214, 38.16545], [-122.25221, 38.16497], [-122.2521, 38.16423], [-122.25216, 38.16415], [-122.2522, 38.16406], [-122.25222, 38.16397], [-122.25221, 38.16386], [-122.25211, 38.16342], [-122.25154, 38.15991], [-122.25208, 38.15779], [-122.25215, 38.15755], [-122.25227, 38.15533], [-122.25278, 38.15531]]]} Open Access 1 17592 Veterans Memorial Park 27024 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 13.899 Veterans Memorial Park 2008 Local Park 2 4
10126 10126 10125 {"type": "Polygon", "coordinates": [[[-122.25487, 38.17441], [-122.25417, 38.17448], [-122.25406, 38.17387], [-122.2547, 38.1738], [-122.25475, 38.17413], [-122.25483, 38.17413], [-122.25487, 38.17441]]]} Open Access 1 17596 Melvin Park 22114 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 1.001 Melvin Park 0 Local Park 2 4
10128 10128 10127 {"type": "Polygon", "coordinates": [[[-122.26963, 38.18034], [-122.26953, 38.18042], [-122.26821, 38.18041], [-122.26821, 38.18035], [-122.26832, 38.18031], [-122.26835, 38.18027], [-122.26837, 38.18022], [-122.26833, 38.18013], [-122.26822, 38.18005], [-122.2687, 38.18], [-122.26866, 38.17971], [-122.26953, 38.17962], [-122.26963, 38.18022], [-122.26963, 38.18034]]]} Open Access 1 17598 Gadwell Park 19168 1005 American Canyon, City of 434 City 2 City Agency 2 http://cityofamericancanyon.org/city-departments/parks-recreation City 2 1005 American Canyon, City of 428 City 2 City Agency 2   Napa 11 2.013 Gadwell Park 2004 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]);