units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where COUNTY = 36, DES_TP = 2 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 7
- North of the River Recreation and Park District 24
- Tehachapi Valley Recreation and Parks District 4
- Shafter Recreation and Park District 3
- Wasco Recreation and Park District 3
- West Side Recreation and Park District 3
- McFarland Recreation and Park District 3
- Bear Mountain Recreation and Park District 2
MNG_AG_TYP 1
- Recreation/Parks District · 42 ✖
DES_TP 1
- Local Park · 42 ✖
ACCESS_TYP 1
- Open Access 42
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1569 | 1569 | 1568 | {"type": "Polygon", "coordinates": [[[-119.03325, 35.4423], [-119.03318, 35.445], [-119.03099, 35.44499], [-119.031, 35.44318], [-119.03103, 35.44277], [-119.03106, 35.44272], [-119.03106, 35.44265], [-119.03103, 35.4426], [-119.03096, 35.44256], [-119.03092, 35.4423], [-119.03325, 35.4423]]]} | Open Access 1 | 13234 | North Highland Park | 22822 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 14.884 | North Highland Park | 0 | Local Park 2 | 4 | |
1766 | 1766 | 1765 | {"type": "Polygon", "coordinates": [[[-119.10684, 35.36219], [-119.1064, 35.36249], [-119.10628, 35.36247], [-119.1062, 35.36252], [-119.10617, 35.36259], [-119.10618, 35.36266], [-119.10622, 35.36272], [-119.10623, 35.36359], [-119.10405, 35.36358], [-119.10402, 35.36351], [-119.10397, 35.36345], [-119.10389, 35.36343], [-119.1038, 35.36345], [-119.10374, 35.36351], [-119.10352, 35.36355], [-119.10352, 35.36371], [-119.10311, 35.36371], [-119.10311, 35.36282], [-119.10313, 35.36265], [-119.10311, 35.36259], [-119.10302, 35.36248], [-119.10389, 35.36248], [-119.10389, 35.36255], [-119.10563, 35.36255], [-119.10564, 35.36218], [-119.10684, 35.36219]]]} | Open Access 1 | 13184 | Mondavi Park | 22368 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.983 | Mondavi Park | 0 | Local Park 2 | 4 | |
1792 | 1792 | 1791 | {"type": "Polygon", "coordinates": [[[-119.02987, 35.40131], [-119.02821, 35.40131], [-119.02822, 35.40213], [-119.02791, 35.4021], [-119.02791, 35.40263], [-119.0276, 35.40263], [-119.02758, 35.40338], [-119.02754, 35.40312], [-119.02753, 35.40284], [-119.02712, 35.40285], [-119.02711, 35.40337], [-119.02688, 35.40337], [-119.02688, 35.40299], [-119.02672, 35.40298], [-119.02672, 35.40131], [-119.02623, 35.4013], [-119.02651, 35.40111], [-119.02658, 35.40101], [-119.02666, 35.40086], [-119.02669, 35.40048], [-119.02662, 35.39998], [-119.0267, 35.39991], [-119.02983, 35.39908], [-119.02987, 35.40131]]]} | Open Access 1 | 13492 | Riverview Park | 24467 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.963 | Riverview Park | 0 | Local Park 2 | 4 | |
1862 | 1862 | 1861 | {"type": "Polygon", "coordinates": [[[-119.28173, 35.49267], [-119.2817, 35.49523], [-119.28068, 35.49522], [-119.28072, 35.49266], [-119.28173, 35.49267]]]} | Open Access 1 | 14207 | Rodriguez Park | 24555 | 2149 | Shafter Recreation and Park District 436 | Special District 4 | Recreation/Parks District 4 | http://shafterrecreation.com/ | Special District 4 | 2149 | Shafter Recreation and Park District 430 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 6.455 | Rodriguez Park | 0 | Local Park 2 | 4 | |
1980 | 1980 | 1979 | {"type": "Polygon", "coordinates": [[[-119.34363, 35.59497], [-119.34362, 35.59606], [-119.34157, 35.59606], [-119.34158, 35.59496], [-119.34363, 35.59497]]]} | Open Access 1 | 15152 | Cormack Park | 17638 | 2175 | Wasco Recreation and Park District 465 | Special District 4 | Recreation/Parks District 4 | http://www.wascoparks.com/ | Special District 4 | 2175 | Wasco Recreation and Park District 458 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 5.609 | Cormack Park | 0 | Local Park 2 | 4 | |
2002 | 2002 | 2001 | {"type": "MultiPolygon", "coordinates": [[[[-119.21208, 34.85022], [-119.21204, 34.855], [-119.21179, 34.8556], [-119.21179, 34.85575], [-119.21177, 34.85589], [-119.21178, 34.85606], [-119.21176, 34.85645], [-119.21168, 34.85661], [-119.21156, 34.8568], [-119.21132, 34.85712], [-119.21077, 34.85763], [-119.208, 34.85771], [-119.20798, 34.85387], [-119.20347, 34.85379], [-119.20325, 34.8428], [-119.20756, 34.84279], [-119.20798, 34.85028], [-119.21208, 34.85022]]], [[[-119.21201, 34.8565], [-119.21199, 34.8576], [-119.21114, 34.85762], [-119.21153, 34.85726], [-119.21168, 34.85707], [-119.21192, 34.85669], [-119.21201, 34.8565]]]]} | Open Access 1 | 15343 | Westside Mountain Park | 27422 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 197.583 | Westside Mtn. Park | 0 | Local Park 2 | 4 | |
2812 | 2812 | 2811 | {"type": "MultiPolygon", "coordinates": [[[[-119.22941, 35.67311], [-119.22913, 35.67312], [-119.22913, 35.67358], [-119.22923, 35.67359], [-119.22923, 35.67373], [-119.22912, 35.67374], [-119.22912, 35.67385], [-119.22897, 35.67375], [-119.22887, 35.67372], [-119.22875, 35.6737], [-119.22825, 35.67369], [-119.22816, 35.67366], [-119.22806, 35.67345], [-119.2279, 35.67321], [-119.22781, 35.67312], [-119.22763, 35.67299], [-119.22755, 35.67296], [-119.22737, 35.67286], [-119.22682, 35.67274], [-119.22666, 35.67268], [-119.22653, 35.67252], [-119.22634, 35.67196], [-119.22801, 35.67193], [-119.22821, 35.67195], [-119.2294, 35.67193], [-119.22941, 35.67311]]], [[[-119.22712, 35.67297], [-119.2266, 35.673], [-119.22648, 35.67275], [-119.22661, 35.67283], [-119.22677, 35.67289], [-119.22712, 35.67297]]]]} | Open Access 1 | 12861 | McFarland Park | 22031 | 2075 | McFarland Recreation and Park District 557 | Special District 4 | Recreation/Parks District 4 | http://www.mcfarlandrpd.com/ | Special District 4 | 2075 | McFarland Recreation and Park District 550 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.421 | McFarland Park | 0 | Local Park 2 | 4 | |
3406 | 3406 | 3405 | {"type": "Polygon", "coordinates": [[[-119.01684, 35.41888], [-119.01475, 35.41888], [-119.01468, 35.41594], [-119.01679, 35.41595], [-119.01684, 35.41888]]]} | Open Access 1 | 24875 | Standard Park | 25782 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 15.335 | Standard Park | 0 | Local Park 2 | 4 | |
3407 | 3407 | 3406 | {"type": "Polygon", "coordinates": [[[-119.02999, 35.42808], [-119.02794, 35.42807], [-119.02794, 35.42719], [-119.02991, 35.42721], [-119.02998, 35.42726], [-119.02999, 35.42808]]]} | Open Access 1 | 24877 | NOR Park | 22786 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 4.468 | NOR Park | 0 | Local Park 2 | 4 | |
3460 | 3460 | 3459 | {"type": "Polygon", "coordinates": [[[-119.08491, 35.40132], [-119.08461, 35.40134], [-119.08421, 35.40131], [-119.08354, 35.40131], [-119.08346, 35.40125], [-119.08344, 35.39843], [-119.08349, 35.39838], [-119.08459, 35.39842], [-119.08461, 35.39892], [-119.08458, 35.39901], [-119.08458, 35.39909], [-119.08463, 35.39919], [-119.08475, 35.39924], [-119.08485, 35.39927], [-119.0849, 35.39975], [-119.08491, 35.40132]]]} | Open Access 1 | 25362 | Emerald Cove Park | 18613 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.921 | Emerald Cove Park | 0 | Local Park 2 | 4 | |
3473 | 3473 | 3472 | {"type": "Polygon", "coordinates": [[[-119.03006, 35.43544], [-119.03004, 35.43691], [-119.02772, 35.4369], [-119.02772, 35.43538], [-119.02999, 35.43538], [-119.03006, 35.43544]]]} | Open Access 1 | 25789 | North Meadows Park | 22830 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.835 | North Meadows Park | 0 | Local Park 2 | 4 | |
3702 | 3702 | 3701 | {"type": "Polygon", "coordinates": [[[-119.13655, 35.40159], [-119.13653, 35.4041], [-119.1365, 35.40501], [-119.13643, 35.40507], [-119.13224, 35.40508], [-119.13226, 35.40158], [-119.13655, 35.40159]]]} | Open Access 1 | 44485 | Polo Community Park | 23874 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 37.231 | Polo Community Park | 0 | Local Park 2 | 4 | |
4254 | 4254 | 4253 | {"type": "Polygon", "coordinates": [[[-118.54882, 35.10774], [-118.54759, 35.10772], [-118.54761, 35.10932], [-118.54171, 35.10939], [-118.53673, 35.10941], [-118.53685, 35.10216], [-118.53715, 35.10216], [-118.53733, 35.10211], [-118.53737, 35.10207], [-118.54645, 35.102], [-118.54871, 35.10379], [-118.54882, 35.10774]]]} | Open Access 1 | 14364 | Brite Lake Park | 3488 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 2164 | Tehachapi Valley Recreation and Parks District 723 | Special District 4 | Recreation/Parks District 4 | http://www.tvrpd.org/parks-facilities/brite-lake.html | Kern 36 | 209.835 | Brite Lake Park | 0 | Local Park 2 | 4 |
5537 | 5537 | 5536 | {"type": "Polygon", "coordinates": [[[-119.03334, 35.42147], [-119.03333, 35.4215], [-119.03271, 35.422], [-119.0325, 35.4221], [-119.03228, 35.42217], [-119.03222, 35.42214], [-119.03209, 35.42194], [-119.03198, 35.42173], [-119.03188, 35.42147], [-119.03188, 35.42144], [-119.03194, 35.4214], [-119.03328, 35.4214], [-119.03332, 35.42141], [-119.03334, 35.42144], [-119.03334, 35.42147]]]} | Open Access 1 | 24876 | McCray Park | 22013 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 1.756 | McCray Park | 0 | Local Park 2 | 4 | |
5554 | 5554 | 5553 | {"type": "MultiPolygon", "coordinates": [[[[-119.07261, 35.39748], [-119.07261, 35.3977], [-119.07254, 35.39775], [-119.06568, 35.39772], [-119.06561, 35.39766], [-119.06561, 35.39719], [-119.06564, 35.39694], [-119.06564, 35.39639], [-119.0657, 35.39634], [-119.06671, 35.39634], [-119.06671, 35.39745], [-119.07261, 35.39748]]], [[[-119.07323, 35.39748], [-119.07323, 35.39776], [-119.07288, 35.39775], [-119.07281, 35.3977], [-119.07282, 35.39748], [-119.07323, 35.39748]]]]} | Open Access 1 | 25351 | San Lauren Park | 24922 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 8.032 | San Lauren Park | 0 | Local Park 2 | 4 | |
5555 | 5555 | 5554 | {"type": "Polygon", "coordinates": [[[-119.09045, 35.40647], [-119.09044, 35.40738], [-119.08934, 35.40737], [-119.08934, 35.40647], [-119.08974, 35.40647], [-119.08981, 35.40644], [-119.0899, 35.40646], [-119.09002, 35.40645], [-119.09045, 35.40647]]]} | Open Access 1 | 25353 | Olive Park West | 23129 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.515 | Olive Park West | 0 | Local Park 2 | 4 | |
5556 | 5556 | 5555 | {"type": "Polygon", "coordinates": [[[-119.08621, 35.40729], [-119.0851, 35.40731], [-119.08511, 35.40685], [-119.0851, 35.40638], [-119.08555, 35.40636], [-119.08621, 35.40638], [-119.08621, 35.40729]]]} | Open Access 1 | 25354 | Olive Park East | 23128 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.554 | Olive Park East | 0 | Local Park 2 | 4 | |
5557 | 5557 | 5556 | {"type": "Polygon", "coordinates": [[[-119.04068, 35.41591], [-119.03921, 35.41592], [-119.0392, 35.4141], [-119.04065, 35.4141], [-119.04068, 35.41591]]]} | Open Access 1 | 25356 | North Beardsley Park | 22808 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 6.595 | North Beardsley Park | 0 | Local Park 2 | 4 | |
5558 | 5558 | 5557 | {"type": "Polygon", "coordinates": [[[-119.12778, 35.3653], [-119.12778, 35.36639], [-119.12774, 35.36742], [-119.12773, 35.36865], [-119.12763, 35.36873], [-119.12648, 35.36873], [-119.12549, 35.36876], [-119.12548, 35.36746], [-119.1255, 35.3653], [-119.12742, 35.36529], [-119.12778, 35.3653]]]} | Open Access 1 | 25359 | LibertyPark | 21215 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.487 | LibertyPark | 0 | Local Park 2 | 4 | |
8318 | 8318 | 8317 | {"type": "Polygon", "coordinates": [[[-119.22302, 35.68355], [-119.22301, 35.68532], [-119.22076, 35.68534], [-119.22077, 35.68358], [-119.22302, 35.68355]]]} | Open Access 1 | 12792 | Browning Road Park | 16444 | 2075 | McFarland Recreation and Park District 557 | Special District 4 | Recreation/Parks District 4 | http://www.mcfarlandrpd.com/ | Special District 4 | 2075 | McFarland Recreation and Park District 550 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.879 | Browning Road Park | 0 | 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]);