units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where YR_EST = 2004
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
267 | 267 | 266 | {"type": "Polygon", "coordinates": [[[-119.02915, 36.43551], [-119.02072, 36.43543], [-119.02065, 36.42818], [-119.02892, 36.42826], [-119.02825, 36.43122], [-119.02828, 36.43212], [-119.02856, 36.43284], [-119.02907, 36.43388], [-119.02921, 36.43451], [-119.02915, 36.43551]]]} | Restricted Access 2 | 907 | Dry Creek Preserve | 18285 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 142.711 | Dry Creek Preserve | 2004 | Private Conservation 16 | 2 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123]]]} | Open Access 1 | 8894 | Classico Park | 17392 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.476 | Classico Park | 2004 | Local Park 2 | 4 | |
1232 | 1232 | 1231 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76237, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76217, 37.30689], [-121.76213, 37.30674], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30636], [-121.762, 37.3062], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30582], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76199, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30793], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30762], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76358, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30932], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76318, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | 8918 | Falls Creek Linear Park | 18837 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.266 | Falls Creek Linear Park | 2004 | Local Park 2 | 4 | |
1234 | 1234 | 1233 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76446, 37.31478], [-121.7643, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | 8930 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 12.449 | Fowler Creek Community Park | 2004 | Local Park 2 | 4 | |
1242 | 1242 | 1241 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32367], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | 9136 | Pocket Park No. 4 | 23834 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.527 | PP No. 4 | 2004 | Local Park 2 | 4 | |
1405 | 1405 | 1404 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | 9014 | Pocket Park No. 11 | 23822 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.329 | PP No. 11 | 2004 | Local Park 2 | 4 | |
1415 | 1415 | 1414 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76657, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31238], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77227, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31318], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77537, 37.31301], [-121.77534, 37.31303], [-121.77515, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77412, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297], [-121.77537, 37.31301]]]]} | Open Access 1 | 8906 | Cortona Park | 17666 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.315 | Cortona Park | 2004 | Local Park 2 | 4 | |
1427 | 1427 | 1426 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | 9084 | Pocket Park No. 18 | 23827 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
6076 | 6076 | 6075 | {"type": "Polygon", "coordinates": [[[-120.39007, 41.37396], [-120.39007, 41.38447], [-120.37028, 41.38456], [-120.36042, 41.38458], [-120.36045, 41.37011], [-120.36049, 41.36649], [-120.36544, 41.36645], [-120.36551, 41.35922], [-120.3655, 41.35921], [-120.36056, 41.35925], [-120.3606, 41.35563], [-120.35766, 41.35565], [-120.35773, 41.3446], [-120.36898, 41.3446], [-120.3685, 41.34107], [-120.38303, 41.34101], [-120.38536, 41.35548], [-120.38041, 41.35551], [-120.38031, 41.36275], [-120.38525, 41.36274], [-120.38515, 41.36999], [-120.38514, 41.37388], [-120.39007, 41.37396]], [[-120.37529, 41.37003], [-120.38021, 41.37001], [-120.38026, 41.36639], [-120.36544, 41.36646], [-120.3654, 41.37008], [-120.36538, 41.3736], [-120.37527, 41.37375], [-120.37529, 41.37003]]]} | Open Access 1 | 843 | Fitzhugh Creek Wildlife Area | 30440 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fitzhugh-Creek-WA | Modoc 56 | 2188.951 | Fitzhugh Creek Wildlife Area | 2004 | State Conservation Area 8 | 2 |
6090 | 6090 | 6089 | {"type": "Polygon", "coordinates": [[[-119.02697, 36.46477], [-119.02697, 36.46493], [-119.02691, 36.46506], [-119.02644, 36.46568], [-119.02592, 36.4662], [-119.02541, 36.46726], [-119.0252, 36.46797], [-119.02491, 36.46849], [-119.02474, 36.46887], [-119.02446, 36.46936], [-119.02444, 36.46972], [-119.02412, 36.47055], [-119.02398, 36.47096], [-119.02397, 36.47141], [-119.02358, 36.47224], [-119.02351, 36.47244], [-119.02322, 36.47339], [-119.02322, 36.47365], [-119.02287, 36.47441], [-119.02257, 36.47535], [-119.02234, 36.4759], [-119.0222, 36.47611], [-119.02194, 36.47631], [-119.02181, 36.47648], [-119.02168, 36.47669], [-119.02151, 36.47704], [-119.02129, 36.47814], [-119.02112, 36.47885], [-119.02106, 36.47896], [-119.02104, 36.47916], [-119.02078, 36.47988], [-119.0206, 36.48032], [-119.02037, 36.48069], [-119.0201, 36.48105], [-119.01972, 36.4814], [-119.01949, 36.48157], [-119.01892, 36.48195], [-119.01818, 36.48238], [-119.01716, 36.4829], [-119.01673, 36.4835], [-119.01673, 36.48449], [-119.01679, 36.48509], [-119.01649, 36.48545], [-119.01617, 36.4858], [-119.00088, 36.48581], [-118.993, 36.48616], [-118.99273, 36.47198], [-118.99229, 36.45684], [-119.00901, 36.45746], [-119.00902, 36.46474], [-119.02697, 36.46477]], [[-119.00902, 36.46854], [-119.00077, 36.46833], [-119.00081, 36.47213], [-119.00901, 36.47227], [-119.00902, 36.46854]]]} | Restricted Access 2 | 912 | Homer Ranch | 20061 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 1751.685 | Homer Ranch | 2004 | Private Conservation 16 | 2 | |
7043 | 7043 | 7042 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69162], [-120.44841, 34.69135], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | 29179 | Burton Mesa Ecological Reserve | 32070 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 10.747 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
7207 | 7207 | 7206 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | 9025 | Evergreen Village Park | 18768 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.806 | Evergreen Village Park | 2004 | Local Park 2 | 4 | |
7299 | 7299 | 7298 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12055, 33.76183], [-118.11972, 33.76246], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11947, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11859, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76165], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | 6583 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.22 | Jack Dunster Marine Biological Reserve | 2004 | Local Conservation Area 4 | 2 | |
7529 | 7529 | 7528 | {"type": "Polygon", "coordinates": [[[-121.77462, 37.32204], [-121.77446, 37.3223], [-121.77438, 37.32256], [-121.77431, 37.32259], [-121.77427, 37.32264], [-121.77426, 37.32269], [-121.7743, 37.32281], [-121.77426, 37.32325], [-121.77424, 37.32328], [-121.77419, 37.32331], [-121.77412, 37.32332], [-121.77382, 37.32324], [-121.77363, 37.32317], [-121.7736, 37.3231], [-121.77361, 37.32305], [-121.77423, 37.32204], [-121.77429, 37.322], [-121.77435, 37.32198], [-121.77462, 37.32204]]]} | Open Access 1 | 9172 | Pocket Park No. 7 | 23837 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.501 | PP No. 7 | 2004 | Local Park 2 | 4 | |
7786 | 7786 | 7785 | {"type": "Polygon", "coordinates": [[[-122.16655, 37.98899], [-122.16265, 37.98898], [-122.15791, 37.98903], [-122.15779, 37.98345], [-122.15833, 37.98316], [-122.1587, 37.98292], [-122.16049, 37.98141], [-122.16149, 37.98051], [-122.16254, 37.9801], [-122.16254, 37.98177], [-122.1665, 37.98176], [-122.16655, 37.98899]]]} | Open Access 1 | 8784 | Dutra Ranch | 18325 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 152.166 | Dutra Ranch | 2004 | Private Conservation 16 | 2 | |
7790 | 7790 | 7789 | {"type": "Polygon", "coordinates": [[[-121.76995, 37.32073], [-121.76992, 37.32078], [-121.76987, 37.3208], [-121.76953, 37.32076], [-121.76868, 37.31766], [-121.76873, 37.31765], [-121.76879, 37.31791], [-121.76891, 37.31796], [-121.76892, 37.31801], [-121.76897, 37.31805], [-121.76902, 37.31824], [-121.76906, 37.31824], [-121.76911, 37.31845], [-121.76908, 37.31848], [-121.76906, 37.31853], [-121.76908, 37.31857], [-121.76911, 37.31861], [-121.76909, 37.31889], [-121.7692, 37.31889], [-121.76921, 37.31914], [-121.76928, 37.31919], [-121.76927, 37.31925], [-121.7693, 37.3193], [-121.76921, 37.31936], [-121.76936, 37.31991], [-121.76944, 37.31997], [-121.76944, 37.32001], [-121.76947, 37.32005], [-121.76953, 37.32009], [-121.7695, 37.32033], [-121.76958, 37.32035], [-121.76957, 37.32068], [-121.76995, 37.32073]]]} | Open Access 1 | 9002 | Pocket Park No. 10 | 23821 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.008 | PP No. 10 | 2004 | Local Park 2 | 4 | |
7812 | 7812 | 7811 | {"type": "Polygon", "coordinates": [[[-121.75822, 37.31075], [-121.75822, 37.31063], [-121.75835, 37.31052], [-121.75835, 37.3102], [-121.75832, 37.3101], [-121.75788, 37.30937], [-121.75761, 37.30857], [-121.75794, 37.30839], [-121.7582, 37.30916], [-121.75845, 37.30964], [-121.75856, 37.31004], [-121.75856, 37.31025], [-121.75855, 37.31038], [-121.75849, 37.31059], [-121.75843, 37.31072], [-121.75837, 37.31075], [-121.75822, 37.31075]]]} | Open Access 1 | 8990 | Pocket Park No.1 | 23840 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.827 | PP No.1 | 2004 | Local Park 2 | 4 | |
7813 | 7813 | 7812 | {"type": "MultiPolygon", "coordinates": [[[[-121.76927, 37.32324], [-121.76939, 37.32349], [-121.76936, 37.32353], [-121.76865, 37.32383], [-121.76826, 37.32394], [-121.76774, 37.32406], [-121.76759, 37.32411], [-121.7674, 37.32423], [-121.76718, 37.3245], [-121.76702, 37.32457], [-121.76698, 37.32457], [-121.76694, 37.32454], [-121.76682, 37.32403], [-121.76707, 37.32399], [-121.76783, 37.32372], [-121.76826, 37.32364], [-121.76848, 37.32357], [-121.76904, 37.32333], [-121.76927, 37.32324]]], [[[-121.77079, 37.32274], [-121.77061, 37.32286], [-121.77054, 37.32288], [-121.77044, 37.32302], [-121.77031, 37.32307], [-121.77009, 37.32311], [-121.77006, 37.32317], [-121.76992, 37.32325], [-121.76995, 37.32336], [-121.76965, 37.32342], [-121.76959, 37.32342], [-121.76956, 37.32339], [-121.76944, 37.32314], [-121.77044, 37.32257], [-121.77065, 37.32248], [-121.77073, 37.32247], [-121.77079, 37.32274]]], [[[-121.77416, 37.32174], [-121.77415, 37.32176], [-121.77392, 37.32178], [-121.77272, 37.32219], [-121.77251, 37.32219], [-121.77244, 37.32224], [-121.77186, 37.32238], [-121.77178, 37.32242], [-121.77123, 37.32252], [-121.77105, 37.32259], [-121.77096, 37.32267], [-121.77094, 37.32268], [-121.77092, 37.3226], [-121.7709, 37.32248], [-121.77089, 37.32235], [-121.77091, 37.32231], [-121.77095, 37.32228], [-121.77159, 37.32216], [-121.77171, 37.3221], [-121.77291, 37.3218], [-121.77338, 37.32163], [-121.77344, 37.32125], [-121.77417, 37.32113], [-121.77422, 37.32113], [-121.77427, 37.32115], [-121.77444, 37.32135], [-121.77446, 37.32142], [-121.77425, 37.32171], [-121.77416, 37.32174]]], [[[-121.7751, 37.32159], [-121.77483, 37.32161], [-121.77464, 37.32159], [-121.77469, 37.32154], [-121.77476, 37.32153], [-121.77494, 37.32155], [-121.77509, 37.32154], [-121.7751, 37.32159]]]]} | Open Access 1 | 8967 | Murillo Park | 22605 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.821 | Murillo Park | 2004 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);