units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where SUID_NMA = 17314
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
7290 | 7290 | 7289 | {"type": "Polygon", "coordinates": [[[-117.97673, 33.90641], [-117.9767, 33.90644], [-117.97664, 33.90637], [-117.9765, 33.90631], [-117.97642, 33.90626], [-117.97638, 33.90594], [-117.97628, 33.90577], [-117.97605, 33.90575], [-117.97595, 33.90571], [-117.97586, 33.90562], [-117.97578, 33.90546], [-117.97571, 33.90524], [-117.97566, 33.90504], [-117.97543, 33.90475], [-117.97542, 33.90466], [-117.97549, 33.90455], [-117.97559, 33.90451], [-117.97572, 33.9045], [-117.97604, 33.90473], [-117.97616, 33.9049], [-117.97628, 33.90511], [-117.97632, 33.90524], [-117.97632, 33.90533], [-117.97635, 33.9054], [-117.97645, 33.90557], [-117.97649, 33.90575], [-117.97673, 33.90641]]]} | Open Access 1 | 7134 | 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 | 2.106 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7367 | 7367 | 7366 | {"type": "Polygon", "coordinates": [[[-117.97195, 33.89573], [-117.97185, 33.89613], [-117.97161, 33.89675], [-117.97149, 33.89687], [-117.97084, 33.89835], [-117.9703, 33.89888], [-117.97025, 33.89903], [-117.97009, 33.89903], [-117.97175, 33.89609], [-117.97178, 33.89573], [-117.97195, 33.89573]]]} | Open Access 1 | 6764 | 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.863 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7416 | 7416 | 7415 | {"type": "Polygon", "coordinates": [[[-117.88318, 33.90438], [-117.88315, 33.90461], [-117.88307, 33.90489], [-117.88292, 33.90527], [-117.88271, 33.90571], [-117.88257, 33.90604], [-117.88244, 33.90628], [-117.88215, 33.90665], [-117.8818, 33.90626], [-117.88176, 33.90592], [-117.88318, 33.90438]]]} | Open Access 1 | 6991 | 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 | 2.815 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
16049 | 16049 | 16048 | {"type": "Polygon", "coordinates": [[[-117.98213, 33.89964], [-117.98201, 33.89994], [-117.9816, 33.90037], [-117.98186, 33.90053], [-117.98179, 33.90061], [-117.9815, 33.90046], [-117.98131, 33.90082], [-117.98106, 33.90164], [-117.98108, 33.90177], [-117.98124, 33.90184], [-117.98118, 33.90188], [-117.98106, 33.90183], [-117.9807, 33.9019], [-117.98061, 33.90176], [-117.98098, 33.90167], [-117.98103, 33.90155], [-117.98112, 33.90128], [-117.98115, 33.90098], [-117.98077, 33.90095], [-117.98063, 33.90112], [-117.98056, 33.90106], [-117.98036, 33.90105], [-117.9805, 33.90077], [-117.9805, 33.90075], [-117.98034, 33.90071], [-117.98029, 33.90071], [-117.98009, 33.90061], [-117.97983, 33.9006], [-117.97978, 33.90057], [-117.97953, 33.90058], [-117.97948, 33.90056], [-117.97928, 33.90062], [-117.97921, 33.9006], [-117.97904, 33.90069], [-117.979, 33.90068], [-117.97878, 33.90079], [-117.97859, 33.9009], [-117.97855, 33.90091], [-117.97842, 33.90106], [-117.9784, 33.90107], [-117.9783, 33.90121], [-117.97803, 33.90179], [-117.97828, 33.90196], [-117.97798, 33.90224], [-117.97789, 33.90228], [-117.97783, 33.90236], [-117.97773, 33.90242], [-117.97759, 33.90283], [-117.97662, 33.90283], [-117.97661, 33.90027], [-117.97673, 33.90028], [-117.97672, 33.90056], [-117.97714, 33.90057], [-117.97733, 33.90051], [-117.97736, 33.90052], [-117.97757, 33.90046], [-117.97775, 33.9004], [-117.97789, 33.90031], [-117.97792, 33.90031], [-117.97804, 33.9002], [-117.97808, 33.9002], [-117.97818, 33.90008], [-117.97823, 33.90005], [-117.97827, 33.90005], [-117.97841, 33.89998], [-117.97868, 33.89993], [-117.97868, 33.89984], [-117.97874, 33.89966], [-117.97888, 33.89947], [-117.97894, 33.89943], [-117.97896, 33.89927], [-117.97901, 33.89928], [-117.97908, 33.89915], [-117.97915, 33.89914], [-117.97929, 33.89906], [-117.97936, 33.89906], [-117.97943, 33.89901], [-117.97963, 33.89902], [-117.97977, 33.89886], [-117.9796, 33.8987], [-117.97979, 33.89877], [-117.9803, 33.89908], [-117.9803, 33.89912], [-117.98011, 33.89926], [-117.98009, 33.89928], [-117.97999, 33.89928], [-117.97994, 33.8993], [-117.97988, 33.89937], [-117.97989, 33.89946], [-117.97994, 33.89951], [-117.97984, 33.89974], [-117.98009, 33.89994], [-117.98043, 33.89981], [-117.98068, 33.8996], [-117.98075, 33.89941], [-117.98046, 33.89925], [-117.98047, 33.89922], [-117.98053, 33.89922], [-117.98078, 33.8993], [-117.98109, 33.89933], [-117.98106, 33.8995], [-117.98094, 33.89964], [-117.98073, 33.89971], [-117.98062, 33.89984], [-117.98098, 33.90006], [-117.98103, 33.90013], [-117.9811, 33.90016], [-117.98108, 33.9003], [-117.98139, 33.90049], [-117.98152, 33.90039], [-117.98165, 33.90025], [-117.98169, 33.90012], [-117.98198, 33.8997], [-117.98168, 33.8995], [-117.98172, 33.89949], [-117.98213, 33.89964]]]} | Open Access 1 | 6735 | 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 | 19.452 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
16061 | 16061 | 16060 | {"type": "Polygon", "coordinates": [[[-117.97023, 33.89917], [-117.97021, 33.89933], [-117.96963, 33.89958], [-117.96963, 33.89989], [-117.96957, 33.89995], [-117.96904, 33.90024], [-117.96849, 33.90017], [-117.96744, 33.89986], [-117.96725, 33.89995], [-117.96756, 33.90066], [-117.96714, 33.90117], [-117.96635, 33.9012], [-117.96579, 33.90102], [-117.9654, 33.90083], [-117.9654, 33.90054], [-117.96535, 33.90033], [-117.96484, 33.90015], [-117.96465, 33.90027], [-117.96412, 33.90014], [-117.96316, 33.89986], [-117.96307, 33.8998], [-117.96295, 33.8998], [-117.96294, 33.89954], [-117.96284, 33.8995], [-117.96283, 33.89946], [-117.96323, 33.89943], [-117.96365, 33.89935], [-117.96366, 33.89936], [-117.96353, 33.89951], [-117.96373, 33.89956], [-117.96383, 33.89961], [-117.9642, 33.89992], [-117.96457, 33.90005], [-117.9648, 33.90009], [-117.96496, 33.90007], [-117.96506, 33.90008], [-117.96518, 33.90012], [-117.9653, 33.90019], [-117.96543, 33.9003], [-117.96556, 33.90049], [-117.96554, 33.90065], [-117.9656, 33.90076], [-117.96565, 33.90079], [-117.96574, 33.9008], [-117.96644, 33.90074], [-117.96644, 33.90068], [-117.96672, 33.90064], [-117.9668, 33.90061], [-117.96685, 33.90057], [-117.9669, 33.9005], [-117.96693, 33.90042], [-117.96693, 33.90028], [-117.96682, 33.89988], [-117.96682, 33.89976], [-117.96684, 33.89967], [-117.96691, 33.89953], [-117.96729, 33.89906], [-117.96767, 33.8992], [-117.96803, 33.89924], [-117.97023, 33.89917]]]} | Open Access 1 | 6922 | 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 | 11.203 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
16066 | 16066 | 16065 | {"type": "Polygon", "coordinates": [[[-117.98464, 33.89987], [-117.98274, 33.90258], [-117.98262, 33.9026], [-117.98228, 33.90251], [-117.98194, 33.90248], [-117.98182, 33.90243], [-117.9817, 33.90245], [-117.98157, 33.90245], [-117.98153, 33.90239], [-117.98158, 33.90208], [-117.98162, 33.90205], [-117.9816, 33.90232], [-117.98229, 33.90238], [-117.98258, 33.90233], [-117.9828, 33.90217], [-117.98331, 33.90152], [-117.98301, 33.90136], [-117.9832, 33.90111], [-117.98353, 33.90126], [-117.98425, 33.90027], [-117.98434, 33.89998], [-117.984, 33.89981], [-117.98401, 33.89972], [-117.98397, 33.89964], [-117.98401, 33.8996], [-117.984, 33.89931], [-117.98295, 33.89932], [-117.98278, 33.89925], [-117.98273, 33.89925], [-117.98263, 33.8992], [-117.98212, 33.89921], [-117.98215, 33.89914], [-117.98222, 33.89916], [-117.98426, 33.89914], [-117.98427, 33.89969], [-117.98464, 33.89987]]]} | Open Access 1 | 7034 | 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 | 3.083 | City of Fullerton OS | 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]);