units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where DES_TP = 2, MNG_AGENCY = 113 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 41 ✖
MNG_AGENCY 1
- Fullerton, City of · 41 ✖
DES_TP 1
- Local Park · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10769 | 10769 | 10768 | {"type": "Polygon", "coordinates": [[[-117.89644, 33.88277], [-117.89637, 33.88279], [-117.89628, 33.88283], [-117.89623, 33.88291], [-117.89625, 33.88327], [-117.89626, 33.88408], [-117.89611, 33.88409], [-117.89606, 33.88412], [-117.89496, 33.88413], [-117.89485, 33.88415], [-117.89369, 33.88447], [-117.89359, 33.88452], [-117.89353, 33.88459], [-117.89351, 33.88466], [-117.89352, 33.88472], [-117.89365, 33.8849], [-117.89386, 33.88528], [-117.8939, 33.88543], [-117.89391, 33.88553], [-117.8938, 33.88607], [-117.89338, 33.88584], [-117.89344, 33.88574], [-117.89349, 33.88562], [-117.8935, 33.88549], [-117.89347, 33.88533], [-117.8932, 33.88483], [-117.89313, 33.88452], [-117.8931, 33.88445], [-117.89301, 33.88432], [-117.89297, 33.88427], [-117.89321, 33.88385], [-117.89337, 33.88391], [-117.89343, 33.88381], [-117.89355, 33.88368], [-117.89393, 33.88339], [-117.89406, 33.88333], [-117.89456, 33.88315], [-117.89485, 33.88297], [-117.89509, 33.8828], [-117.89644, 33.88277]]]} | Open Access 1 | 20128 | Acacia Park | 15244 | 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.397 | Acacia 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 | |
9971 | 9971 | 9970 | {"type": "Polygon", "coordinates": [[[-117.93066, 33.87017], [-117.9288, 33.87019], [-117.92878, 33.86888], [-117.93064, 33.86886], [-117.93066, 33.87017]]]} | Open Access 1 | 17149 | Amerige Park | 15457 | 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 | 6.178 | Amerige Park | 0 | Local Park 2 | 4 | |
6497 | 6497 | 6496 | {"type": "Polygon", "coordinates": [[[-117.95884, 33.87703], [-117.95875, 33.87723], [-117.95842, 33.87775], [-117.95824, 33.87799], [-117.95802, 33.87823], [-117.95757, 33.87863], [-117.95706, 33.87897], [-117.95666, 33.87917], [-117.95521, 33.87968], [-117.95472, 33.87906], [-117.95661, 33.87804], [-117.95699, 33.87779], [-117.95739, 33.8774], [-117.95757, 33.87717], [-117.95776, 33.87685], [-117.9578, 33.87682], [-117.95784, 33.87682], [-117.95844, 33.87696], [-117.95884, 33.87703]]]} | Open Access 1 | 2369 | Bastanchury Park | 15859 | 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.512 | Bastanchury Park | 0 | Local Park 2 | 4 | |
12867 | 12867 | 12866 | {"type": "Polygon", "coordinates": [[[-117.92738, 33.88967], [-117.92683, 33.89063], [-117.9268, 33.89078], [-117.9268, 33.89083], [-117.92692, 33.89116], [-117.92694, 33.89128], [-117.92694, 33.8914], [-117.92694, 33.89153], [-117.92689, 33.89177], [-117.92688, 33.8929], [-117.9268, 33.89344], [-117.92642, 33.89211], [-117.9259, 33.89215], [-117.92583, 33.89233], [-117.92558, 33.89252], [-117.92554, 33.89382], [-117.92547, 33.89383], [-117.92548, 33.89448], [-117.92588, 33.89544], [-117.92617, 33.89571], [-117.92624, 33.89575], [-117.92629, 33.89584], [-117.92626, 33.89589], [-117.92608, 33.89602], [-117.9256, 33.89626], [-117.92524, 33.89651], [-117.92482, 33.89689], [-117.9246, 33.89687], [-117.92444, 33.89697], [-117.92431, 33.89691], [-117.92412, 33.89678], [-117.92401, 33.89662], [-117.92404, 33.89652], [-117.92401, 33.89637], [-117.9239, 33.89627], [-117.92377, 33.89618], [-117.92352, 33.89606], [-117.92318, 33.89582], [-117.92284, 33.89563], [-117.92272, 33.8956], [-117.92096, 33.89558], [-117.91994, 33.89559], [-117.91993, 33.89534], [-117.92275, 33.89432], [-117.92279, 33.89429], [-117.92282, 33.89425], [-117.9228, 33.8942], [-117.92274, 33.89416], [-117.92228, 33.89399], [-117.92209, 33.89397], [-117.92168, 33.89381], [-117.92178, 33.89266], [-117.92176, 33.8926], [-117.92172, 33.89256], [-117.92144, 33.89244], [-117.92184, 33.89187], [-117.92212, 33.89201], [-117.92275, 33.89172], [-117.9226, 33.89125], [-117.92258, 33.89109], [-117.92259, 33.89081], [-117.922, 33.89084], [-117.9218, 33.89086], [-117.92189, 33.89034], [-117.92192, 33.89024], [-117.92197, 33.89014], [-117.9221, 33.89001], [-117.92232, 33.88991], [-117.9221, 33.88951], [-117.92244, 33.88941], [-117.92227, 33.88891], [-117.92253, 33.88884], [-117.92242, 33.88814], [-117.92259, 33.88812], [-117.92256, 33.88756], [-117.92263, 33.88757], [-117.92278, 33.88765], [-117.92279, 33.88765], [-117.92283, 33.88749], [-117.92291, 33.88685], [-117.92298, 33.88687], [-117.92322, 33.88686], [-117.92433, 33.88686], [-117.92433, 33.88691], [-117.92435, 33.88692], [-117.92591, 33.8861], [-117.92602, 33.88643], [-117.92627, 33.88635], [-117.92729, 33.8893], [-117.92734, 33.88945], [-117.92738, 33.88967]]]} | Open Access 1 | 30309 | Brea Dam Park | 16341 | 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 | 105.528 | Brea Dam 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 | |
9248 | 9248 | 9247 | {"type": "Polygon", "coordinates": [[[-117.88612, 33.86867], [-117.88614, 33.87001], [-117.88563, 33.87027], [-117.88535, 33.87045], [-117.88496, 33.87077], [-117.8849, 33.87078], [-117.88488, 33.87076], [-117.88484, 33.87065], [-117.88479, 33.87045], [-117.88478, 33.86881], [-117.88479, 33.86868], [-117.88482, 33.86866], [-117.88603, 33.86865], [-117.88608, 33.86865], [-117.88612, 33.86867]]]} | Open Access 1 | 15401 | Chapman Park | 17133 | 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 | 5.937 | Chapman 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 | |
10648 | 10648 | 10647 | {"type": "MultiPolygon", "coordinates": [[[[-117.94976, 33.88576], [-117.94976, 33.8858], [-117.94964, 33.88596], [-117.94929, 33.88575], [-117.94942, 33.88558], [-117.94976, 33.88576]]], [[[-117.95294, 33.88975], [-117.95255, 33.89002], [-117.95104, 33.89003], [-117.95181, 33.88903], [-117.95173, 33.88877], [-117.95141, 33.88884], [-117.95137, 33.88877], [-117.95131, 33.88873], [-117.95152, 33.88853], [-117.95152, 33.88851], [-117.95135, 33.88841], [-117.95094, 33.88829], [-117.95127, 33.88828], [-117.95122, 33.88789], [-117.95099, 33.88758], [-117.95097, 33.88744], [-117.95083, 33.88713], [-117.9508, 33.88698], [-117.95065, 33.88657], [-117.95056, 33.88645], [-117.95042, 33.88633], [-117.95026, 33.88641], [-117.95016, 33.88628], [-117.94984, 33.88607], [-117.94982, 33.88604], [-117.94982, 33.88601], [-117.9499, 33.88592], [-117.94994, 33.88589], [-117.95, 33.8859], [-117.95028, 33.88609], [-117.95073, 33.88647], [-117.95101, 33.88677], [-117.95114, 33.88694], [-117.95138, 33.88731], [-117.95187, 33.88828], [-117.95203, 33.88864], [-117.95224, 33.88899], [-117.9524, 33.88919], [-117.95294, 33.88975]]]]} | Open Access 1 | 18978 | Edward White II Park | 18458 | 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 | 6.771 | Edward White II Park | 0 | Local Park 2 | 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 | |
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 | |
6097 | 6097 | 6096 | {"type": "Polygon", "coordinates": [[[-117.96739, 33.85816], [-117.96643, 33.85817], [-117.96643, 33.85902], [-117.96532, 33.85904], [-117.96531, 33.85817], [-117.96617, 33.85817], [-117.96618, 33.85792], [-117.96625, 33.85787], [-117.96627, 33.85779], [-117.96642, 33.85778], [-117.9664, 33.85667], [-117.96737, 33.85666], [-117.96739, 33.85816]]]} | Open Access 1 | 981 | Gilbert Park | 19293 | 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 | 6.318 | Gilbert Park | 0 | Local Park 2 | 4 | |
6101 | 6101 | 6100 | {"type": "Polygon", "coordinates": [[[-117.88013, 33.9014], [-117.87992, 33.90138], [-117.87889, 33.90192], [-117.87821, 33.90262], [-117.87678, 33.90264], [-117.87678, 33.90346], [-117.87599, 33.90349], [-117.87476, 33.90351], [-117.87464, 33.90299], [-117.87518, 33.90251], [-117.87546, 33.90226], [-117.87602, 33.90224], [-117.87657, 33.902], [-117.87661, 33.90177], [-117.87676, 33.90176], [-117.87675, 33.90086], [-117.87806, 33.90084], [-117.87767, 33.90164], [-117.87761, 33.90169], [-117.87782, 33.90193], [-117.87806, 33.90214], [-117.87825, 33.90189], [-117.87832, 33.90188], [-117.87837, 33.90184], [-117.87839, 33.90164], [-117.87842, 33.9016], [-117.87852, 33.90155], [-117.87906, 33.90146], [-117.87922, 33.90142], [-117.87939, 33.90136], [-117.88001, 33.90121], [-117.88007, 33.90122], [-117.88013, 33.90126], [-117.88013, 33.9014]]]} | Open Access 1 | 990 | Gilman Park | 19296 | 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.583 | Gilman Park | 0 | Local Park 2 | 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 | |
6318 | 6318 | 6317 | {"type": "MultiPolygon", "coordinates": [[[[-117.93357, 33.88633], [-117.933, 33.88668], [-117.93288, 33.88682], [-117.93263, 33.88739], [-117.93256, 33.88797], [-117.93253, 33.88836], [-117.93208, 33.88914], [-117.93207, 33.88926], [-117.93201, 33.88928], [-117.93188, 33.88889], [-117.93216, 33.88861], [-117.93231, 33.88829], [-117.9323, 33.88737], [-117.93246, 33.88709], [-117.93252, 33.88692], [-117.93257, 33.88672], [-117.93266, 33.88657], [-117.93324, 33.88623], [-117.93326, 33.88615], [-117.93357, 33.88633]]], [[[-117.94181, 33.88152], [-117.94161, 33.88282], [-117.94161, 33.88254], [-117.94157, 33.88235], [-117.94147, 33.88222], [-117.94133, 33.8822], [-117.94118, 33.88226], [-117.94091, 33.88248], [-117.94065, 33.88265], [-117.94039, 33.88276], [-117.94007, 33.88284], [-117.93997, 33.88292], [-117.93994, 33.88307], [-117.93983, 33.88311], [-117.93968, 33.88278], [-117.93914, 33.88273], [-117.93859, 33.88276], [-117.93839, 33.88284], [-117.93792, 33.88322], [-117.93777, 33.88347], [-117.93734, 33.88359], [-117.93704, 33.88372], [-117.93672, 33.88445], [-117.93656, 33.88441], [-117.93666, 33.88388], [-117.93654, 33.88381], [-117.93637, 33.8838], [-117.93618, 33.88387], [-117.936, 33.88402], [-117.93568, 33.88435], [-117.93526, 33.88471], [-117.93464, 33.88541], [-117.93404, 33.886], [-117.93402, 33.88612], [-117.93409, 33.88648], [-117.93342, 33.88608], [-117.93418, 33.88542], [-117.93422, 33.88514], [-117.9346, 33.88495], [-117.93478, 33.88471], [-117.93489, 33.88448], [-117.93504, 33.88431], [-117.93547, 33.88411], [-117.93563, 33.88398], [-117.93619, 33.88345], [-117.93624, 33.88337], [-117.93615, 33.88324], [-117.9362, 33.88317], [-117.9364, 33.88319], [-117.93665, 33.88329], [-117.93698, 33.88336], [-117.93722, 33.88332], [-117.9375, 33.8832], [-117.93761, 33.88304], [-117.93768, 33.88286], [-117.93758, 33.88273], [-117.93701, 33.88248], [-117.93706, 33.8824], [-117.93803, 33.88257], [-117.9383, 33.88238], [-117.93858, 33.88251], [-117.93931, 33.88238], [-117.93972, 33.88222], [-117.9399, 33.8824], [-117.94011, 33.88247], [-117.94038, 33.88243], [-117.94058, 33.88236], [-117.94076, 33.88224], [-117.94108, 33.88186], [-117.9414, 33.88159], [-117.94181, 33.88152]]]]} | Open Access 1 | 1849 | Hiltscher Park | 20000 | 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.257 | Hiltscher 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 | |
6552 | 6552 | 6551 | {"type": "MultiPolygon", "coordinates": [[[[-117.93379, 33.90928], [-117.93391, 33.90963], [-117.93398, 33.90978], [-117.93413, 33.90997], [-117.93418, 33.91008], [-117.93417, 33.91012], [-117.93399, 33.9101], [-117.93328, 33.90984], [-117.93359, 33.90947], [-117.93379, 33.90928]]], [[[-117.94081, 33.90403], [-117.93976, 33.9047], [-117.93907, 33.90515], [-117.93884, 33.90539], [-117.93874, 33.90552], [-117.9385, 33.90594], [-117.9384, 33.90601], [-117.93829, 33.90606], [-117.93802, 33.90612], [-117.93803, 33.90614], [-117.93824, 33.90617], [-117.93832, 33.90622], [-117.93839, 33.9063], [-117.93844, 33.90643], [-117.93835, 33.90644], [-117.93834, 33.90652], [-117.93824, 33.9067], [-117.93783, 33.90713], [-117.93774, 33.9073], [-117.93768, 33.90752], [-117.93771, 33.90793], [-117.9377, 33.90799], [-117.93766, 33.90808], [-117.93762, 33.90812], [-117.93753, 33.90818], [-117.93708, 33.9083], [-117.93702, 33.90833], [-117.93689, 33.90841], [-117.93675, 33.90856], [-117.93657, 33.90895], [-117.93652, 33.90917], [-117.93652, 33.9094], [-117.93656, 33.90952], [-117.93661, 33.9096], [-117.93643, 33.9096], [-117.93622, 33.90966], [-117.93639, 33.90893], [-117.93636, 33.90882], [-117.93608, 33.90877], [-117.93575, 33.90881], [-117.93538, 33.90899], [-117.93507, 33.90918], [-117.93483, 33.90937], [-117.93456, 33.9097], [-117.93445, 33.90992], [-117.93449, 33.91007], [-117.93444, 33.91009], [-117.93437, 33.91007], [-117.9343, 33.90988], [-117.93411, 33.90963], [-117.93391, 33.90902], [-117.93405, 33.909], [-117.93425, 33.90875], [-117.9345, 33.90871], [-117.93467, 33.90862], [-117.93485, 33.90847], [-117.93511, 33.90834], [-117.93526, 33.90821], [-117.93557, 33.90811], [-117.9358, 33.9078], [-117.93561, 33.9075], [-117.93567, 33.90747], [-117.93612, 33.90771], [-117.93649, 33.90768], [-117.93669, 33.90757], [-117.93762, 33.90653], [-117.93752, 33.90611], [-117.93758, 33.9061], [-117.93758, 33.90572], [-117.93821, 33.90537], [-117.93828, 33.90485], [-117.93848, 33.90405], [-117.93896, 33.90335], [-117.93907, 33.90294], [-117.93927, 33.90245], [-117.93922, 33.9019], [-117.93948, 33.9012], [-117.93972, 33.90042], [-117.94006, 33.90052], [-117.94043, 33.90067], [-117.94048, 33.90069], [-117.9405, 33.90072], [-117.94051, 33.90077], [-117.94032, 33.90117], [-117.94024, 33.90142], [-117.94018, 33.90173], [-117.94016, 33.90201], [-117.94015, 33.90233], [-117.94023, 33.90284], [-117.94035, 33.90319], [-117.94041, 33.90336], [-117.94056, 33.90365], [-117.94081, 33.90403]]]]} | Open Access 1 | 3298 | Laguna Lake Park | 20860 | 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 | 29.596 | Laguna Lake Park | 0 | Local Park 2 | 4 | |
6585 | 6585 | 6584 | {"type": "Polygon", "coordinates": [[[-117.92101, 33.86512], [-117.92095, 33.86512], [-117.92094, 33.86453], [-117.91992, 33.86453], [-117.91989, 33.86315], [-117.92099, 33.86315], [-117.92101, 33.86512]]]} | Open Access 1 | 3944 | Lemon Park | 21154 | 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.918 | Lemon Park | 0 | Local Park 2 | 4 | |
16893 | 16893 | 16892 | {"type": "Polygon", "coordinates": [[[-117.89308, 33.89872], [-117.8929, 33.89901], [-117.89256, 33.89889], [-117.89241, 33.89892], [-117.89234, 33.89889], [-117.89224, 33.89888], [-117.89218, 33.8989], [-117.89213, 33.89894], [-117.8921, 33.899], [-117.89212, 33.89906], [-117.89205, 33.89908], [-117.89187, 33.89897], [-117.89149, 33.89883], [-117.89171, 33.89851], [-117.89187, 33.89809], [-117.89196, 33.89806], [-117.89221, 33.89813], [-117.89235, 33.89821], [-117.89255, 33.89827], [-117.89269, 33.89829], [-117.89292, 33.89837], [-117.89287, 33.89861], [-117.89308, 33.89872]]]} | Open Access 1 | 5728 | Mountain View Park | 22555 | 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.4 | Mtn. View 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]);