units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where GAP_STS = 4, MNG_AGENCY = 113 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-117.92419, 33.88391], [-117.92408, 33.88412], [-117.92397, 33.88429], [-117.92354, 33.88397], [-117.92333, 33.88404], [-117.92297, 33.88442], [-117.92231, 33.88498], [-117.92231, 33.88499], [-117.92279, 33.88538], [-117.92229, 33.8858], [-117.92197, 33.88601], [-117.92171, 33.88614], [-117.92123, 33.88634], [-117.92078, 33.8865], [-117.92073, 33.8865], [-117.92066, 33.88644], [-117.9205, 33.88616], [-117.92054, 33.88613], [-117.92028, 33.88566], [-117.92023, 33.88566], [-117.92021, 33.88554], [-117.92022, 33.88548], [-117.92027, 33.88542], [-117.9204, 33.88533], [-117.92058, 33.88525], [-117.92067, 33.88517], [-117.92073, 33.88504], [-117.92073, 33.88495], [-117.92071, 33.88487], [-117.92063, 33.88477], [-117.91997, 33.88433], [-117.91994, 33.8843], [-117.91993, 33.88424], [-117.92209, 33.88471], [-117.92255, 33.88401], [-117.9228, 33.8839], [-117.92419, 33.88391]]]} | Open Access 1 | 4247 | Lions Field | 21314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 10.364 | Lions Field | 0 | Local Recreation Area 3 | 4 | |
873 | 873 | 872 | {"type": "Polygon", "coordinates": [[[-117.93298, 33.87239], [-117.93299, 33.87368], [-117.93293, 33.87371], [-117.93199, 33.87372], [-117.93199, 33.87369], [-117.93201, 33.87368], [-117.93199, 33.8724], [-117.93298, 33.87239]]]} | Open Access 1 | 5644 | Ford Park | 18986 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.29 | Ford Park | 0 | Local Park 2 | 4 | |
889 | 889 | 888 | {"type": "Polygon", "coordinates": [[[-117.94313, 33.86297], [-117.94253, 33.86297], [-117.94252, 33.86266], [-117.94195, 33.86267], [-117.94195, 33.862], [-117.94199, 33.86199], [-117.94204, 33.86196], [-117.94216, 33.86195], [-117.94235, 33.8619], [-117.94244, 33.86185], [-117.94267, 33.86168], [-117.94313, 33.86205], [-117.94313, 33.86297]]]} | Open Access 1 | 5733 | Nicolas Park | 22752 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.839 | Nicolas Park | 0 | Local Park 2 | 4 | |
998 | 998 | 997 | {"type": "Polygon", "coordinates": [[[-117.983, 33.89971], [-117.983, 33.89998], [-117.98289, 33.90017], [-117.98289, 33.90029], [-117.98284, 33.90035], [-117.98284, 33.90042], [-117.98281, 33.90043], [-117.98264, 33.90066], [-117.98257, 33.90091], [-117.98247, 33.90093], [-117.98244, 33.90096], [-117.98241, 33.90106], [-117.98208, 33.90151], [-117.98207, 33.90158], [-117.98217, 33.90163], [-117.98217, 33.90165], [-117.98242, 33.90178], [-117.98243, 33.90186], [-117.98236, 33.90194], [-117.9823, 33.90195], [-117.98238, 33.90183], [-117.98225, 33.90171], [-117.98219, 33.90169], [-117.98212, 33.90172], [-117.9821, 33.90194], [-117.98194, 33.90193], [-117.98198, 33.90164], [-117.98192, 33.90163], [-117.98199, 33.90149], [-117.98215, 33.90097], [-117.98217, 33.90082], [-117.98195, 33.90069], [-117.98205, 33.90059], [-117.98233, 33.90075], [-117.98264, 33.90041], [-117.98274, 33.90027], [-117.9829, 33.89994], [-117.98291, 33.89979], [-117.98259, 33.89973], [-117.98263, 33.89969], [-117.983, 33.89971]]]} | Open Access 1 | 6747 | City of Fullerton Open Space | 17314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 1.259 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
1098 | 1098 | 1097 | {"type": "Polygon", "coordinates": [[[-117.92986, 33.86435], [-117.92876, 33.86437], [-117.92876, 33.86349], [-117.92985, 33.86348], [-117.92986, 33.86435]]]} | Open Access 1 | 9922 | Richman Park | 24338 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.446 | Richman Park | 0 | Local Park 2 | 4 | |
1131 | 1131 | 1130 | {"type": "Polygon", "coordinates": [[[-117.95528, 33.87307], [-117.95525, 33.87309], [-117.95481, 33.87321], [-117.95455, 33.87326], [-117.95425, 33.87328], [-117.95421, 33.87325], [-117.9542, 33.87238], [-117.95425, 33.87232], [-117.95425, 33.87207], [-117.95433, 33.87204], [-117.95437, 33.87199], [-117.95437, 33.87193], [-117.95435, 33.8719], [-117.95467, 33.8719], [-117.95468, 33.8721], [-117.9551, 33.8721], [-117.95512, 33.87268], [-117.95516, 33.87283], [-117.95528, 33.87307]]]} | Open Access 1 | 6622 | Adlena Park | 15266 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.836 | Adlena Park | 0 | Local Park 2 | 4 | |
1260 | 1260 | 1259 | {"type": "Polygon", "coordinates": [[[-117.94028, 33.86813], [-117.93751, 33.86817], [-117.93748, 33.86675], [-117.93903, 33.86673], [-117.93904, 33.86678], [-117.94015, 33.86677], [-117.94014, 33.86701], [-117.94015, 33.86728], [-117.94017, 33.86737], [-117.94023, 33.8675], [-117.94026, 33.86761], [-117.94028, 33.86813]]]} | Open Access 1 | 5674 | Independence Park | 20191 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 9.627 | Independence Park | 0 | Local Park 2 | 4 | |
1533 | 1533 | 1532 | {"type": "Polygon", "coordinates": [[[-117.92836, 33.90467], [-117.92815, 33.9048], [-117.9281, 33.90476], [-117.92804, 33.90473], [-117.92797, 33.90475], [-117.92791, 33.9048], [-117.92753, 33.90466], [-117.92763, 33.90412], [-117.92794, 33.90402], [-117.92836, 33.90467]]]} | Open Access 1 | 11140 | San Juan Park | 24919 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 1.044 | San Juan Park | 0 | Local Park 2 | 4 | |
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-117.90873, 33.87477], [-117.90712, 33.87478], [-117.90712, 33.87424], [-117.90716, 33.8742], [-117.90749, 33.8742], [-117.90757, 33.87422], [-117.90872, 33.8742], [-117.90873, 33.87477]]]} | Open Access 1 | 13081 | Byerrum Park | 16616 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.299 | Byerrum Park | 0 | Local Park 2 | 4 | |
3711 | 3711 | 3710 | {"type": "Polygon", "coordinates": [[[-117.92322, 33.87248], [-117.92321, 33.87287], [-117.92272, 33.87287], [-117.92272, 33.87248], [-117.92322, 33.87248]]]} | Open Access 1 | 30310 | Downtown Plaza | 18256 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 0.493 | Downtown Plaza | 0 | Local Park 2 | 4 | |
4013 | 4013 | 4012 | {"type": "Polygon", "coordinates": [[[-117.95468, 33.86909], [-117.95385, 33.86908], [-117.95384, 33.86891], [-117.95335, 33.8689], [-117.95334, 33.86852], [-117.95468, 33.86851], [-117.95468, 33.86909]]]} | Open Access 1 | 20676 | Pooch Park | 23890 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 1.697 | Pooch Park | 0 | Local Park 2 | 4 | |
4377 | 4377 | 4376 | {"type": "Polygon", "coordinates": [[[-117.95103, 33.89252], [-117.95065, 33.89253], [-117.95003, 33.89257], [-117.94996, 33.89212], [-117.94981, 33.89213], [-117.94979, 33.89207], [-117.94994, 33.892], [-117.9499, 33.89172], [-117.95102, 33.89171], [-117.95103, 33.89252]]]} | Open Access 1 | 10296 | Roger Chaffee Park | 24558 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.259 | Roger Chaffee Park | 0 | Local Park 2 | 4 | |
4959 | 4959 | 4958 | {"type": "Polygon", "coordinates": [[[-117.88353, 33.89776], [-117.88331, 33.89827], [-117.88238, 33.89767], [-117.88239, 33.89693], [-117.88353, 33.89776]]]} | Open Access 1 | 7009 | City of Fullerton Open Space | 17314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 1.864 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
5192 | 5192 | 5191 | {"type": "Polygon", "coordinates": [[[-117.94549, 33.87542], [-117.94548, 33.8764], [-117.94546, 33.87698], [-117.94376, 33.87684], [-117.94367, 33.87682], [-117.94362, 33.87677], [-117.94347, 33.87634], [-117.9434, 33.87595], [-117.94312, 33.8753], [-117.94359, 33.8752], [-117.94542, 33.87532], [-117.94545, 33.87534], [-117.94546, 33.87542], [-117.94549, 33.87542]]]} | Open Access 1 | 5550 | Muckenthaler Cultural Center | 22582 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 8.615 | Muckenthaler Cultural Ctr. | 0 | Local Recreation Area 3 | 4 | |
5514 | 5514 | 5513 | {"type": "Polygon", "coordinates": [[[-117.92438, 33.88131], [-117.9245, 33.88275], [-117.92433, 33.88354], [-117.92419, 33.88391], [-117.9228, 33.8839], [-117.92255, 33.88401], [-117.9221, 33.88471], [-117.91993, 33.88424], [-117.92016, 33.88335], [-117.92017, 33.88322], [-117.92013, 33.88308], [-117.9198, 33.88233], [-117.91977, 33.88218], [-117.92002, 33.88129], [-117.92093, 33.88128], [-117.92093, 33.88133], [-117.92086, 33.88134], [-117.92087, 33.88149], [-117.92118, 33.88148], [-117.92118, 33.88134], [-117.92098, 33.88134], [-117.92098, 33.88128], [-117.92421, 33.88127], [-117.92422, 33.8813], [-117.92438, 33.88131]]]} | Open Access 1 | 1833 | Hillcrest Park | 19969 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 33.004 | Hillcrest Park | 0 | Local Park 2 | 4 | |
5732 | 5732 | 5731 | {"type": "MultiPolygon", "coordinates": [[[[-117.9492, 33.88555], [-117.94863, 33.88611], [-117.94801, 33.88656], [-117.94717, 33.88705], [-117.94643, 33.88751], [-117.94463, 33.88859], [-117.94422, 33.88811], [-117.9452, 33.88758], [-117.94735, 33.88646], [-117.94757, 33.88633], [-117.94798, 33.88599], [-117.94822, 33.88574], [-117.94851, 33.88532], [-117.94855, 33.8853], [-117.94864, 33.88531], [-117.9492, 33.88555]]], [[[-117.95502, 33.87975], [-117.95351, 33.8803], [-117.95296, 33.88059], [-117.9523, 33.88103], [-117.9521, 33.88121], [-117.95184, 33.88145], [-117.95135, 33.88206], [-117.95073, 33.88206], [-117.95066, 33.88201], [-117.95065, 33.88199], [-117.95068, 33.88195], [-117.95101, 33.88158], [-117.95154, 33.88105], [-117.95192, 33.88074], [-117.95246, 33.88034], [-117.95308, 33.87995], [-117.95454, 33.87916], [-117.95502, 33.87975]]]]} | Open Access 1 | 2262 | Bastanchury Greenbelt | 15858 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 13.539 | Bastanchury Greenbelt | 0 | Local Recreation Area 3 | 4 | |
5879 | 5879 | 5878 | {"type": "Polygon", "coordinates": [[[-117.97279, 33.88354], [-117.97261, 33.88413], [-117.972, 33.88412], [-117.9719, 33.88422], [-117.97193, 33.88435], [-117.97208, 33.88454], [-117.97217, 33.88471], [-117.97227, 33.88494], [-117.97225, 33.88493], [-117.97208, 33.88457], [-117.97193, 33.88438], [-117.97164, 33.88404], [-117.97158, 33.88394], [-117.97147, 33.88371], [-117.9714, 33.88344], [-117.97137, 33.88329], [-117.97136, 33.88245], [-117.97132, 33.88232], [-117.97128, 33.88225], [-117.97113, 33.88209], [-117.97093, 33.88198], [-117.9708, 33.88194], [-117.97064, 33.88192], [-117.97006, 33.88198], [-117.96907, 33.88205], [-117.96901, 33.88204], [-117.96899, 33.88201], [-117.96903, 33.882], [-117.96904, 33.88195], [-117.97007, 33.88193], [-117.97008, 33.88182], [-117.97133, 33.8818], [-117.97188, 33.88135], [-117.97186, 33.88058], [-117.97233, 33.88058], [-117.97235, 33.8831], [-117.97279, 33.88354]]]} | Open Access 1 | 270 | Emery Park | 18625 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 9.034 | Emery Park | 0 | Local Park 2 | 4 | |
5936 | 5936 | 5935 | {"type": "Polygon", "coordinates": [[[-117.9531, 33.87725], [-117.953, 33.87735], [-117.95292, 33.87747], [-117.95288, 33.87762], [-117.95287, 33.87779], [-117.95084, 33.87777], [-117.95078, 33.87775], [-117.95077, 33.87723], [-117.9531, 33.87725]]]} | Open Access 1 | 509 | Fern Drive Park | 18874 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.953 | Fern Drive Park | 0 | Local Park 2 | 4 | |
6003 | 6003 | 6002 | {"type": "Polygon", "coordinates": [[[-117.9268, 33.89343], [-117.92673, 33.89381], [-117.92554, 33.89382], [-117.92558, 33.89251], [-117.92583, 33.89233], [-117.9259, 33.89215], [-117.92642, 33.8921], [-117.9268, 33.89343]]]} | Open Access 1 | 770 | Fullerton Tennis Center | 33372 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.416 | Fullerton Tennis Ctr. | 0 | Local Recreation Area 3 | 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]);