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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14235 | 14235 | 14234 | {"type": "Polygon", "coordinates": [[[-117.95912, 33.85653], [-117.95701, 33.85656], [-117.957, 33.85652], [-117.95681, 33.85652], [-117.95681, 33.85643], [-117.95683, 33.85632], [-117.95687, 33.85621], [-117.95692, 33.85617], [-117.95779, 33.85624], [-117.95908, 33.85624], [-117.95911, 33.85624], [-117.95912, 33.85626], [-117.95912, 33.85653]]]} | Restricted Access 2 | 44113 | Orangethorpe School Park | 31634 | 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.856 | Orangethorpe School Park | 0 | Local Park 2 | 4 | |
14186 | 14186 | 14185 | {"type": "MultiPolygon", "coordinates": [[[[-117.90223, 33.90123], [-117.90203, 33.90123], [-117.90195, 33.90126], [-117.90189, 33.90133], [-117.9019, 33.90164], [-117.90137, 33.90168], [-117.9013, 33.90184], [-117.90058, 33.90185], [-117.90057, 33.90126], [-117.90037, 33.90108], [-117.90105, 33.90102], [-117.90222, 33.90088], [-117.90223, 33.90123]]], [[[-117.90115, 33.90289], [-117.90087, 33.90313], [-117.90081, 33.90314], [-117.90073, 33.90276], [-117.90072, 33.90264], [-117.90113, 33.90261], [-117.90115, 33.90289]]]]} | Restricted Access 2 | 44001 | Rolling Hills School Park | 31645 | 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.343 | Rolling Hills School Park | 0 | Local Park 2 | 4 | |
12868 | 12868 | 12867 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | 30311 | Laguna Road School Park | 31597 | 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.908 | Laguna Road School 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 | |
12857 | 12857 | 12856 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92622, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | 30308 | Hermosa School Park | 31593 | 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.279 | Hermosa School Park | 0 | Local Park 2 | 4 | |
12856 | 12856 | 12855 | {"type": "Polygon", "coordinates": [[[-117.92264, 33.87229], [-117.9222, 33.87229], [-117.9222, 33.87199], [-117.92264, 33.87199], [-117.92264, 33.87229]]]} | Open Access 1 | 30307 | Plaza Park | 23783 | 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.337 | Plaza Park | 0 | Local Park 2 | 4 | |
11967 | 11967 | 11966 | {"type": "Polygon", "coordinates": [[[-117.97185, 33.86827], [-117.97115, 33.86828], [-117.97113, 33.86658], [-117.97184, 33.86657], [-117.97185, 33.86827]]]} | Open Access 1 | 24588 | Valencia Park | 26764 | 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.015 | Valencia Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
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 | |
9179 | 9179 | 9178 | {"type": "Polygon", "coordinates": [[[-117.95946, 33.89516], [-117.95944, 33.89529], [-117.95901, 33.89539], [-117.95876, 33.89578], [-117.9585, 33.89568], [-117.95824, 33.89563], [-117.95786, 33.8956], [-117.95761, 33.89562], [-117.9573, 33.89568], [-117.95708, 33.89575], [-117.95683, 33.89586], [-117.95665, 33.89597], [-117.95635, 33.89621], [-117.95581, 33.8969], [-117.95563, 33.89718], [-117.95534, 33.89782], [-117.95514, 33.89811], [-117.95482, 33.8979], [-117.95448, 33.89773], [-117.95423, 33.89768], [-117.95403, 33.89785], [-117.95392, 33.8978], [-117.95385, 33.89781], [-117.95378, 33.89783], [-117.9537, 33.8979], [-117.95333, 33.8979], [-117.95322, 33.89784], [-117.95337, 33.89767], [-117.95351, 33.89746], [-117.9536, 33.89728], [-117.95366, 33.89711], [-117.95371, 33.8969], [-117.95375, 33.89649], [-117.95446, 33.89655], [-117.9554, 33.89628], [-117.95557, 33.89572], [-117.95621, 33.89554], [-117.9588, 33.89553], [-117.95917, 33.89496], [-117.95946, 33.89516]]]} | Open Access 1 | 15239 | West Coyote Hills Tree Park | 27355 | 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.976 | West Coyote Hills Tree Park | 0 | Local Park 2 | 4 | |
9176 | 9176 | 9175 | {"type": "Polygon", "coordinates": [[[-117.96441, 33.89612], [-117.96506, 33.89619], [-117.96519, 33.89621], [-117.96549, 33.89621], [-117.96557, 33.89623], [-117.9656, 33.89629], [-117.96557, 33.89651], [-117.96545, 33.89728], [-117.96541, 33.89748], [-117.96538, 33.89752], [-117.96531, 33.89754], [-117.96504, 33.89748], [-117.96428, 33.89741], [-117.96414, 33.89738], [-117.96409, 33.89735], [-117.96408, 33.89729], [-117.96422, 33.89681], [-117.96426, 33.89675], [-117.96432, 33.8967], [-117.96433, 33.89666], [-117.96433, 33.89661], [-117.96429, 33.89655], [-117.96441, 33.89612]]]} | Open Access 1 | 15236 | West Cayote Hills Park | 27353 | 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.174 | West Cayote Hills Park | 0 | Local Park 2 | 4 | |
9123 | 9123 | 9122 | {"type": "Polygon", "coordinates": [[[-117.89392, 33.89797], [-117.89361, 33.8981], [-117.89352, 33.8982], [-117.892, 33.8977], [-117.89197, 33.89767], [-117.89201, 33.89714], [-117.89197, 33.89631], [-117.89214, 33.89632], [-117.8924, 33.89638], [-117.89265, 33.89641], [-117.89313, 33.89638], [-117.89324, 33.89639], [-117.89339, 33.89646], [-117.89353, 33.89664], [-117.89379, 33.89703], [-117.89396, 33.89743], [-117.894, 33.89775], [-117.89398, 33.89788], [-117.89392, 33.89797]]]} | Open Access 1 | 15125 | Vista Park | 27182 | 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 | 7.257 | Vista Park | 0 | Local Park 2 | 4 | |
9108 | 9108 | 9107 | {"type": "MultiPolygon", "coordinates": [[[[-117.9517, 33.89275], [-117.95168, 33.89324], [-117.95223, 33.8943], [-117.95231, 33.8947], [-117.95234, 33.89508], [-117.95216, 33.8959], [-117.95199, 33.89628], [-117.95173, 33.89662], [-117.95064, 33.89747], [-117.95085, 33.89781], [-117.95053, 33.89796], [-117.95044, 33.89771], [-117.95038, 33.89738], [-117.95046, 33.89736], [-117.9505, 33.89732], [-117.95052, 33.89725], [-117.95051, 33.89719], [-117.95072, 33.8971], [-117.95129, 33.89667], [-117.95134, 33.89644], [-117.95147, 33.89644], [-117.95157, 33.89638], [-117.95179, 33.89606], [-117.95185, 33.89593], [-117.95188, 33.89583], [-117.95191, 33.89559], [-117.95189, 33.89535], [-117.95183, 33.89517], [-117.95171, 33.89495], [-117.95167, 33.89484], [-117.95159, 33.89471], [-117.95153, 33.89466], [-117.9517, 33.89442], [-117.95159, 33.89435], [-117.95079, 33.89438], [-117.95056, 33.894], [-117.95024, 33.89392], [-117.95025, 33.89384], [-117.95063, 33.89382], [-117.95058, 33.89291], [-117.95037, 33.89275], [-117.95082, 33.89273], [-117.9517, 33.89275]]], [[[-117.95344, 33.8969], [-117.95336, 33.89724], [-117.95322, 33.8975], [-117.95297, 33.89739], [-117.95269, 33.89761], [-117.95269, 33.89765], [-117.95258, 33.89769], [-117.95231, 33.89794], [-117.9522, 33.89807], [-117.95213, 33.89818], [-117.95158, 33.89852], [-117.95157, 33.89855], [-117.95103, 33.89856], [-117.95076, 33.89859], [-117.95064, 33.89858], [-117.95051, 33.89815], [-117.95069, 33.89809], [-117.95083, 33.8985], [-117.95148, 33.89844], [-117.95344, 33.8969]]]]} | Open Access 1 | 15095 | Virgil Grissom Park | 27152 | 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.562 | Virgil Grissom Park | 0 | Local Park 2 | 4 | |
8990 | 8990 | 8989 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.86783], [-117.9174, 33.86783], [-117.91739, 33.86746], [-117.91753, 33.86746], [-117.91753, 33.86783]]]} | Open Access 1 | 14842 | Truslow Park | 26555 | 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.132 | Truslow Park | 0 | Local Park 2 | 4 | |
8975 | 8975 | 8974 | {"type": "Polygon", "coordinates": [[[-117.9141, 33.89576], [-117.9139, 33.89588], [-117.91379, 33.8961], [-117.91346, 33.8963], [-117.91289, 33.89645], [-117.91246, 33.89661], [-117.91214, 33.89641], [-117.91245, 33.89621], [-117.91262, 33.89613], [-117.91343, 33.89577], [-117.9141, 33.89576]]]} | Open Access 1 | 14807 | Trail Rest Park | 26508 | 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.793 | Trail Rest Park | 0 | Local Park 2 | 4 | |
7915 | 7915 | 7914 | {"type": "Polygon", "coordinates": [[[-117.90101, 33.90102], [-117.90037, 33.90108], [-117.90001, 33.90073], [-117.89952, 33.90038], [-117.89902, 33.90053], [-117.8984, 33.90065], [-117.8984, 33.89966], [-117.89885, 33.89971], [-117.89974, 33.89975], [-117.90096, 33.89975], [-117.90101, 33.90102]]]} | Open Access 1 | 10353 | Rolling Hills Park | 24578 | 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.439 | Rolling Hills Park | 0 | Local Park 2 | 4 | |
7626 | 7626 | 7625 | {"type": "MultiPolygon", "coordinates": [[[[-117.95498, 33.86699], [-117.95464, 33.867], [-117.95464, 33.86664], [-117.95492, 33.86664], [-117.95497, 33.86666], [-117.95498, 33.86699]]], [[[-117.95523, 33.86836], [-117.95465, 33.86837], [-117.95464, 33.86705], [-117.95498, 33.86704], [-117.95498, 33.86785], [-117.95494, 33.86792], [-117.95493, 33.86801], [-117.95496, 33.86806], [-117.95503, 33.8681], [-117.95511, 33.8681], [-117.9552, 33.86808], [-117.95523, 33.86836]]], [[[-117.9554, 33.86699], [-117.95517, 33.86699], [-117.95516, 33.86669], [-117.95518, 33.86665], [-117.95521, 33.86664], [-117.95539, 33.86664], [-117.9554, 33.86699]]]]} | Open Access 1 | 7408 | Pacific Drive Park | 23296 | 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.781 | Pacific Drive 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]);