superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 113 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 470 | 470 | 469 | {"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.95469, 33.8721], [-117.9551, 33.8721], [-117.95512, 33.87268], [-117.95516, 33.87283], [-117.95528, 33.87307]]]} | Open Access 1 | Adlena Park | 15266 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.838 | Adlena Park | ||
| 580 | 580 | 579 | {"type": "Polygon", "coordinates": [[[-117.91483, 33.89333], [-117.91442, 33.89338], [-117.91416, 33.89346], [-117.914, 33.89343], [-117.91384, 33.89343], [-117.9137, 33.89351], [-117.91357, 33.89352], [-117.91304, 33.89344], [-117.91277, 33.89349], [-117.91253, 33.89355], [-117.91228, 33.89357], [-117.91183, 33.89357], [-117.91137, 33.89349], [-117.9111, 33.89342], [-117.91016, 33.89373], [-117.91016, 33.89435], [-117.91268, 33.89473], [-117.91311, 33.89535], [-117.91246, 33.8956], [-117.91168, 33.89579], [-117.90701, 33.89588], [-117.90698, 33.89935], [-117.90543, 33.89938], [-117.90536, 33.89937], [-117.9053, 33.89917], [-117.90536, 33.89896], [-117.90535, 33.89891], [-117.9053, 33.89884], [-117.90521, 33.89877], [-117.9051, 33.89874], [-117.90497, 33.89874], [-117.90492, 33.89868], [-117.90491, 33.89864], [-117.90467, 33.8984], [-117.90447, 33.89826], [-117.90432, 33.89803], [-117.9043, 33.89793], [-117.90431, 33.89785], [-117.90423, 33.89771], [-117.9042, 33.89769], [-117.90416, 33.8977], [-117.90414, 33.89774], [-117.90419, 33.8978], [-117.90419, 33.89787], [-117.9043, 33.89814], [-117.90488, 33.89871], [-117.90493, 33.89901], [-117.90497, 33.89906], [-117.90506, 33.89912], [-117.9051, 33.89918], [-117.90512, 33.89929], [-117.90512, 33.89938], [-117.90503, 33.89942], [-117.90171, 33.89948], [-117.89996, 33.89947], [-117.89942, 33.89948], [-117.89924, 33.89945], [-117.89878, 33.89943], [-117.89847, 33.89938], [-117.89795, 33.89934], [-117.89749, 33.89926], [-117.89717, 33.89924], [-117.89675, 33.89914], [-117.89639, 33.8991], [-117.89624, 33.89905], [-117.89604, 33.89903], [-117.89497, 33.89874], [-117.89466, 33.89864], [-117.89422, 33.89847], [-117.89365, 33.8983], [-117.89368, 33.89823], [-117.8938, 33.8982], [-117.89392, 33.89814], [-117.89406, 33.89804], [-117.89413, 33.89784], [-117.89413, 33.89766], [-117.89407, 33.89734], [-117.89359, 33.89642], [-117.89348, 33.89626], [-117.89321, 33.89624], [-117.8927, 33.89632], [-117.89217, 33.89622], [-117.89195, 33.89624], [-117.89188, 33.89534], [-117.89199, 33.89534], [-117.89234, 33.89561], [-117.89256, 33.89565], [-117.89281, 33.89564], [-117.89309, 33.89569], [-117.89341, 33.89578], [-117.89366, 33.89589], [-117.89397, 33.89607], [-117.89445, 33.89631], [-117.89501, 33.89592], [-117.8958, 33.89622], [-117.89596, 33.89582], [-117.89606, 33.8955], [-117.89626, 33.89519], [-117.89645, 33.89418], [-117.89652, 33.89371], [-117.89641, 33.89351], [-117.89618, 33.89331], [-117.89595, 33.8933], [-117.89563, 33.89325], [-117.89476, 33.8933], [-117.89453, 33.8933], [-117.89405, 33.89318], [-117.89386, 33.89317], [-117.89339, 33.89321], [-117.89325, 33.89315], [-117.89289, 33.89293], [-117.89269, 33.89277], [-117.89252, 33.89271], [-117.89258, 33.89285], [-117.89273, 33.89304], [-117.89274, 33.89344], [-117.89281, 33.89385], [-117.89296, 33.89416], [-117.89322, 33.89449], [-117.89344, 33.89468], [-117.89461, 33.89542], [-117.89453, 33.89555], [-117.89437, 33.89568], [-117.89411, 33.89579], [-117.89399, 33.89576], [-117.89413, 33.89547], [-117.89352, 33.89522], [-117.89313, 33.89497], [-117.89272, 33.8948], [-117.89225, 33.89466], [-117.89204, 33.89463], [-117.8919, 33.89463], [-117.89181, 33.89451], [-117.89174, 33.89398], [-117.89169, 33.89326], [-117.89176, 33.89243], [-117.8964, 33.89262], [-117.89706, 33.89319], [-117.89744, 33.89366], [-117.89752, 33.89385], [-117.89746, 33.89404], [-117.89735, 33.8942], [-117.89731, 33.89435], [-117.89734, 33.89447], [-117.89734, 33.89462], [-117.89733, 33.89482], [-117.89728, 33.89503], [-117.89717, 33.89523], [-117.89702, 33.89544], [-117.89673, 33.89569], [-117.89663, 33.89591], [-117.89666, 33.89601], [-117.89673, 33.89591], [-117.89693, 33.89569], [-117.89726, 33.89542], [-117.89786, 33.89515], [-117.89817, 33.89509], [-117.89861, 33.89498], [-117.8989, 33.89464], [-117.89943, 33.89496], [-117.89963, 33.89514], [-117.89999, 33.89532], [-117.90024, 33.89548], [-117.90041, 33.89547], [-117.90056, 33.89543], [-117.90069, 33.89515], [-117.90085, 33.89513], [-117.90154, 33.89519], [-117.90236, 33.89478], [-117.90264, 33.89443], [-117.9028, 33.8945], [-117.90339, 33.89425], [-117.90353, 33.89427], [-117.90381, 33.89402], [-117.90417, 33.89382], [-117.9043, 33.89386], [-117.90438, 33.89382], [-117.90439, 33.89345], [-117.90481, 33.89291], [-117.9049, 33.89281], [-117.9052, 33.89285], [-117.90531, 33.89293], [-117.90549, 33.89311], [-117.90572, 33.89319], [-117.90639, 33.89309], [-117.90679, 33.8931], [-117.90705, 33.89316], [-117.9073, 33.89315], [-117.90744, 33.89308], [-117.90766, 33.89308], [-117.90787, 33.89303], [-117.9081, 33.89285], [-117.90814, 33.89268], [-117.90809, 33.89256], [-117.90787, 33.89248], [-117.90767, 33.89246], [-117.90789, 33.89237], [-117.90812, 33.89241], [-117.90825, 33.89248], [-117.90837, 33.89258], [-117.90847, 33.89261], [-117.90861, 33.89255], [-117.90914, 33.8924], [-117.90959, 33.89236], [-117.91479, 33.89234], [-117.91483, 33.89333]]]} | Open Access 1 | Panorama Nature Reserve | 4066 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 219.715 | Panorama Nature Reserve | ||
| 1186 | 1186 | 1185 | {"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 | Amerige Park | 15457 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.176 | Amerige Park | ||
| 1397 | 1397 | 1396 | {"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.89356, 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 | Acacia Park | 15244 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.396 | Acacia Park | ||
| 1798 | 1798 | 1797 | {"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 | Bastanchury Greenbelt | 15858 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 13.538 | Bastanchury Greenbelt | ||
| 1799 | 1799 | 1798 | {"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.95785, 33.87682], [-117.95844, 33.87696], [-117.95884, 33.87703]]]} | Open Access 1 | Bastanchury Park | 15859 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.512 | Bastanchury Park | ||
| 2214 | 2214 | 2213 | {"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.89289], [-117.9268, 33.89344], [-117.92642, 33.89211], [-117.92591, 33.89215], [-117.92583, 33.89233], [-117.92558, 33.89252], [-117.92554, 33.89382], [-117.92547, 33.89384], [-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.92317, 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.89426], [-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.92192, 33.89024], [-117.92197, 33.89014], [-117.9221, 33.89001], [-117.92231, 33.88991], [-117.9221, 33.88951], [-117.92244, 33.88941], [-117.92227, 33.88891], [-117.92252, 33.88883], [-117.92242, 33.88814], [-117.92259, 33.88812], [-117.92256, 33.88756], [-117.92263, 33.88757], [-117.92277, 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.88642], [-117.92627, 33.88635], [-117.92729, 33.8893], [-117.92734, 33.88945], [-117.92738, 33.88967]]]} | Open Access 1 | Brea Dam Park | 16341 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 105.552 | Brea Dam Park | ||
| 2441 | 2441 | 2440 | {"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 | Byerrum Park | 16616 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.298 | Byerrum Park | ||
| 2554 | 2554 | 2553 | {"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 | Downtown Plaza | 18256 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.493 | Downtown Plaza | ||
| 2841 | 2841 | 2840 | {"type": "Polygon", "coordinates": [[[-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], [-117.88614, 33.87001]]]} | Open Access 1 | Chapman Park | 17133 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 5.937 | Chapman Park | ||
| 3869 | 3869 | 3868 | {"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.88902], [-117.95173, 33.88877], [-117.95141, 33.88884], [-117.95137, 33.88877], [-117.95131, 33.88873], [-117.95151, 33.88853], [-117.95151, 33.88851], [-117.95134, 33.88841], [-117.95094, 33.88829], [-117.95126, 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.95043, 33.88633], [-117.95026, 33.88641], [-117.95016, 33.88628], [-117.94984, 33.88607], [-117.94982, 33.88603], [-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 | Edward White II Park | 18458 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.785 | Edward White II Park | ||
| 3988 | 3988 | 3987 | {"type": "Polygon", "coordinates": [[[-117.97279, 33.88354], [-117.97261, 33.88413], [-117.972, 33.88412], [-117.9719, 33.88422], [-117.97193, 33.88435], [-117.97207, 33.88454], [-117.97217, 33.88471], [-117.97227, 33.88494], [-117.97225, 33.88493], [-117.97208, 33.88457], [-117.97193, 33.88437], [-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.97079, 33.88194], [-117.97065, 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.97006, 33.88193], [-117.97008, 33.88182], [-117.97133, 33.88179], [-117.97188, 33.88135], [-117.97186, 33.88058], [-117.97233, 33.88058], [-117.97235, 33.88309], [-117.97279, 33.88354]]]} | Open Access 1 | Emery Park | 18625 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 9.042 | Emery Park | ||
| 4191 | 4191 | 4190 | {"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 | Fern Drive Park | 18874 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.952 | Fern Drive Park | ||
| 4303 | 4303 | 4302 | {"type": "Polygon", "coordinates": [[[-117.93299, 33.87368], [-117.93293, 33.87371], [-117.93199, 33.87372], [-117.93199, 33.87369], [-117.93201, 33.87367], [-117.93199, 33.8724], [-117.93298, 33.87239], [-117.93299, 33.87368]]]} | Open Access 1 | Ford Park | 18986 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.29 | Ford Park | ||
| 4448 | 4448 | 4447 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89356, 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.88608], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.419 | Fullerton Creek Greenbelt | ||
| 4449 | 4449 | 4448 | {"type": "Polygon", "coordinates": [[[-117.92255, 33.8956], [-117.9225, 33.89563], [-117.92242, 33.89571], [-117.92243, 33.89577], [-117.92247, 33.89585], [-117.92248, 33.89597], [-117.92243, 33.89601], [-117.92237, 33.89602], [-117.92232, 33.89607], [-117.92237, 33.89629], [-117.92232, 33.89637], [-117.92231, 33.89644], [-117.9221, 33.89653], [-117.9219, 33.89663], [-117.92186, 33.8967], [-117.92184, 33.89681], [-117.92143, 33.89683], [-117.92143, 33.89749], [-117.92138, 33.89756], [-117.92093, 33.89803], [-117.92067, 33.89839], [-117.92067, 33.89869], [-117.92064, 33.89891], [-117.91996, 33.89895], [-117.91999, 33.89886], [-117.91999, 33.89877], [-117.91998, 33.89841], [-117.91998, 33.89699], [-117.91996, 33.89691], [-117.91994, 33.89687], [-117.91989, 33.89681], [-117.91965, 33.89665], [-117.91949, 33.89661], [-117.91868, 33.89667], [-117.91831, 33.89664], [-117.91795, 33.89652], [-117.91734, 33.89618], [-117.91705, 33.89615], [-117.91692, 33.89616], [-117.91683, 33.89619], [-117.91642, 33.89639], [-117.91623, 33.8966], [-117.91624, 33.89667], [-117.91621, 33.89679], [-117.91606, 33.89688], [-117.91597, 33.89698], [-117.91583, 33.8971], [-117.9157, 33.89717], [-117.91571, 33.89575], [-117.92006, 33.89558], [-117.92255, 33.8956]]]} | Open Access 1 | Fullerton Sports Complex | 19145 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 22.496 | Fullerton Sports Complex | ||
| 4562 | 4562 | 4561 | {"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 | Gilbert Park | 19293 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.329 | Gilbert Park | ||
| 4566 | 4566 | 4565 | {"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.87656, 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.90213], [-117.87825, 33.90189], [-117.87832, 33.90188], [-117.87836, 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 | Gilman Park | 19296 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 13.6 | Gilman Park | ||
| 5156 | 5156 | 5155 | {"type": "Polygon", "coordinates": [[[-117.92438, 33.88131], [-117.9245, 33.88276], [-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.88135], [-117.92088, 33.88149], [-117.92118, 33.88147], [-117.92117, 33.88135], [-117.92098, 33.88134], [-117.92098, 33.88128], [-117.92421, 33.88127], [-117.92423, 33.8813], [-117.92438, 33.88131]]]} | Open Access 1 | Hillcrest Park | 19969 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 33.011 | Hillcrest Park | ||
| 5184 | 5184 | 5183 | {"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.88691], [-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.93967, 33.88278], [-117.93914, 33.88273], [-117.93859, 33.88276], [-117.93839, 33.88284], [-117.93793, 33.88322], [-117.93777, 33.88347], [-117.93734, 33.88359], [-117.93704, 33.88372], [-117.93672, 33.88445], [-117.93656, 33.88441], [-117.93665, 33.88388], [-117.93654, 33.88381], [-117.93637, 33.8838], [-117.93618, 33.88387], [-117.936, 33.88401], [-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.88543], [-117.93422, 33.88514], [-117.9346, 33.88495], [-117.93478, 33.88471], [-117.93489, 33.88448], [-117.93504, 33.88431], [-117.93546, 33.88411], [-117.93563, 33.88398], [-117.93619, 33.88345], [-117.93624, 33.88336], [-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 | Hiltscher Park | 20000 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 13.274 | Hiltscher Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);