units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where GAP_STS = 2, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7684 | 7684 | 7683 | {"type": "Polygon", "coordinates": [[[-117.91483, 33.89333], [-117.91442, 33.89338], [-117.91416, 33.89346], [-117.91399, 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.91111, 33.89342], [-117.91016, 33.89373], [-117.91015, 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.9052, 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.90421, 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.8966, 33.89913], [-117.89639, 33.8991], [-117.89624, 33.89905], [-117.89612, 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.89625], [-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.89233, 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.89446, 33.89632], [-117.89501, 33.89592], [-117.8958, 33.89622], [-117.89596, 33.89582], [-117.89606, 33.89549], [-117.89626, 33.89519], [-117.89645, 33.89418], [-117.89652, 33.89371], [-117.89641, 33.89351], [-117.89617, 33.8933], [-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.89251, 33.8927], [-117.89258, 33.89285], [-117.89273, 33.89304], [-117.89274, 33.89343], [-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.89414, 33.89547], [-117.89352, 33.89522], [-117.89313, 33.89497], [-117.89271, 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.89436], [-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.89602], [-117.89673, 33.89591], [-117.89693, 33.89569], [-117.89726, 33.89542], [-117.89787, 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.90279, 33.89451], [-117.90339, 33.89425], [-117.90352, 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.90731, 33.89315], [-117.90744, 33.89308], [-117.90765, 33.89308], [-117.90787, 33.89303], [-117.9081, 33.89285], [-117.90815, 33.89267], [-117.90809, 33.89256], [-117.90786, 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 | 7631 | Panorama Nature Reserve | 4066 | 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 | 219.655 | Panorama Nature Reserve | 0 | Local Conservation Area 4 | 2 | |
| 7901 | 7901 | 7900 | {"type": "Polygon", "coordinates": [[[-117.95261, 33.89908], [-117.9526, 33.89956], [-117.95255, 33.89978], [-117.9525, 33.89992], [-117.9524, 33.90012], [-117.95175, 33.90019], [-117.95156, 33.90033], [-117.95142, 33.9005], [-117.95098, 33.90079], [-117.95065, 33.90125], [-117.94932, 33.90117], [-117.94926, 33.90118], [-117.94923, 33.90132], [-117.94933, 33.90169], [-117.94929, 33.90187], [-117.94909, 33.90193], [-117.94865, 33.90197], [-117.94839, 33.90209], [-117.94829, 33.90217], [-117.94816, 33.90222], [-117.94793, 33.90221], [-117.94787, 33.90219], [-117.94768, 33.90207], [-117.94752, 33.90206], [-117.94741, 33.90208], [-117.94732, 33.90212], [-117.94713, 33.90224], [-117.94706, 33.9025], [-117.94712, 33.90256], [-117.94724, 33.90274], [-117.94739, 33.90291], [-117.94764, 33.90304], [-117.94762, 33.90309], [-117.94765, 33.90311], [-117.94781, 33.90312], [-117.94828, 33.90377], [-117.94812, 33.90449], [-117.9478, 33.9046], [-117.94737, 33.9048], [-117.947, 33.9048], [-117.94651, 33.90469], [-117.94579, 33.90442], [-117.94503, 33.90436], [-117.94472, 33.90431], [-117.94389, 33.90395], [-117.94361, 33.90368], [-117.9433, 33.9033], [-117.943, 33.90278], [-117.943, 33.90266], [-117.94306, 33.9024], [-117.94319, 33.90219], [-117.94337, 33.90199], [-117.94355, 33.90164], [-117.94359, 33.90141], [-117.94359, 33.90134], [-117.94355, 33.90128], [-117.94347, 33.90126], [-117.94325, 33.90126], [-117.94321, 33.90133], [-117.94288, 33.90133], [-117.94227, 33.90126], [-117.94215, 33.90127], [-117.94187, 33.90119], [-117.94189, 33.8994], [-117.94205, 33.89918], [-117.94405, 33.89916], [-117.94737, 33.89917], [-117.94761, 33.89959], [-117.94784, 33.89974], [-117.94838, 33.90001], [-117.94866, 33.90023], [-117.94906, 33.90052], [-117.94931, 33.90064], [-117.94931, 33.90066], [-117.94943, 33.90075], [-117.9495, 33.90091], [-117.95016, 33.90099], [-117.9503, 33.90097], [-117.95054, 33.90086], [-117.95038, 33.90053], [-117.95046, 33.9005], [-117.95066, 33.90078], [-117.95092, 33.90069], [-117.95134, 33.90036], [-117.95204, 33.89996], [-117.95223, 33.89975], [-117.95244, 33.89927], [-117.9525, 33.89906], [-117.95261, 33.89908]]]} | Open Access 1 | 10158 | Robert E. Ward Nature Preserve | 24486 | 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 | 76.163 | Robert E. Ward Nature Preserve | 0 | Local Conservation Area 4 | 2 |
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]);