calands: units_with_maps: 46 rows where GAP_STS = 4 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

46 rows where GAP_STS = 4 and MNG_AGENCY = 42

Search:

descending

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	DES_TP	GAP_STS
110	110	109	{"type": "Polygon", "coordinates": [[[-117.29125, 33.04677], [-117.29115, 33.04685], [-117.29116, 33.04711], [-117.29104, 33.04713], [-117.29093, 33.0472], [-117.29088, 33.04731], [-117.29089, 33.04741], [-117.29079, 33.04744], [-117.29081, 33.04755], [-117.29009, 33.04705], [-117.29007, 33.04643], [-117.29016, 33.04643], [-117.29017, 33.04645], [-117.29118, 33.04635], [-117.29125, 33.04677]]]}	Open Access 1	297	Encinitas Viewpoint Park	18667	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	2.45	Encinitas Viewpoint Park	Local Park 2	4
266	266	265	{"type": "Polygon", "coordinates": [[[-117.28081, 33.05885], [-117.28072, 33.06063], [-117.27954, 33.06063], [-117.27953, 33.06014], [-117.27857, 33.06014], [-117.27858, 33.05993], [-117.27819, 33.05883], [-117.28081, 33.05885]]]}	Open Access 1	744	Quail Gardens Undeveloped Park	24040	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2		San Diego 4	9.379	Quail Gardens Undeveloped Park	Local Park 2	4
301	301	300	{"type": "Polygon", "coordinates": [[[-117.2813, 33.01875], [-117.28074, 33.01904], [-117.28068, 33.01906], [-117.28053, 33.01907], [-117.28027, 33.01903], [-117.28002, 33.01906], [-117.27986, 33.01914], [-117.2798, 33.01919], [-117.27976, 33.01926], [-117.27965, 33.01933], [-117.2796, 33.01935], [-117.2795, 33.01935], [-117.27944, 33.01933], [-117.27935, 33.01927], [-117.27932, 33.01921], [-117.27927, 33.01904], [-117.27927, 33.01893], [-117.27929, 33.01887], [-117.27934, 33.01882], [-117.2794, 33.01878], [-117.27944, 33.01868], [-117.27943, 33.01853], [-117.27938, 33.01846], [-117.27929, 33.01839], [-117.27928, 33.01833], [-117.27929, 33.01831], [-117.27943, 33.01819], [-117.27953, 33.01814], [-117.27967, 33.01811], [-117.27998, 33.01812], [-117.28015, 33.01814], [-117.28044, 33.01822], [-117.28055, 33.01822], [-117.28074, 33.01816], [-117.28091, 33.018], [-117.28097, 33.018], [-117.28102, 33.01804], [-117.2811, 33.01824], [-117.28128, 33.01869], [-117.2813, 33.01875]]]}	Open Access 1	1037	Glen Park	19323	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	4.507	Glen Park	Local Park 2	4
604	604	603	{"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]}	Open Access 1	2084	Indian Head Canyon	20201	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2		San Diego 4	55.677	Indian Head Canyon	Local Recreation Area 3	4
706	706	705	{"type": "Polygon", "coordinates": [[[-117.30499, 33.07463], [-117.30401, 33.07487], [-117.30385, 33.0744], [-117.30375, 33.07426], [-117.30364, 33.0739], [-117.30366, 33.07387], [-117.3037, 33.07385], [-117.30399, 33.07382], [-117.30463, 33.07368], [-117.30468, 33.07371], [-117.30499, 33.07463]]]}	Open Access 1	4023	Leucadia Oaks Park	21186	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	2.7	Leucadia Oaks Park	Local Park 2	4
1158	1158	1157	{"type": "Polygon", "coordinates": [[[-117.29614, 33.0581], [-117.2955, 33.0581], [-117.29432, 33.0581], [-117.29458, 33.05748], [-117.29524, 33.05748], [-117.29525, 33.05731], [-117.29581, 33.05731], [-117.29614, 33.0581]]]}	Open Access 1	7357	Orpheus Park	23224	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	2.741	Orpheus Park	Local Park 2	4
1921	1921	1920	{"type": "Polygon", "coordinates": [[[-117.25318, 33.05161], [-117.253, 33.05162], [-117.25266, 33.05167], [-117.25237, 33.05103], [-117.2519, 33.05104], [-117.2519, 33.05092], [-117.25227, 33.05079], [-117.24994, 33.04553], [-117.25052, 33.04565], [-117.25318, 33.05161]]]}	Open Access 1	14888	Undeveloped Community Park	26652	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2		San Diego 4	8.458	Undeveloped Community Park	Local Park 2	4
2174	2174	2173	{"type": "Polygon", "coordinates": [[[-117.30158, 33.05598], [-117.30134, 33.05605], [-117.30127, 33.05586], [-117.30122, 33.05575], [-117.30097, 33.05535], [-117.30078, 33.05482], [-117.30076, 33.05468], [-117.30103, 33.05461], [-117.30138, 33.05554], [-117.30158, 33.05598]]]}	Open Access 1	16270	Stone Steps Beach	25877	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches	San Diego 4	1.07	Stone Steps Beach	Local Park 2	4
2321	2321	2320	{"type": "Polygon", "coordinates": [[[-117.30275, 33.06426], [-117.30274, 33.0643], [-117.3027, 33.06432], [-117.30238, 33.06438], [-117.30234, 33.06435], [-117.30232, 33.06423], [-117.30268, 33.06416], [-117.30273, 33.06419], [-117.30275, 33.06426]]]}	Open Access 1	17033	Leucadia Roadside Park	21187	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	0.165	Leucadia Roadside Park	Local Park 2	4
4596	4596	4595	{"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]}	Open Access 1	35531	Unknown park - Encinitas, City of	28635	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2		San Diego 4	0.21		Local Other or Unknown 14	4
5076	5076	5075	{"type": "Polygon", "coordinates": [[[-117.22622, 33.05283], [-117.22608, 33.05351], [-117.22591, 33.05411], [-117.22568, 33.05481], [-117.22537, 33.05473], [-117.22596, 33.05276], [-117.22622, 33.05283]]]}	Open Access 1	4282	Little Oaks Equestrian Park	21350	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	1.691	Little Oaks Equestrian Park	Local Recreation Area 3	4
5445	5445	5444	{"type": "Polygon", "coordinates": [[[-117.25804, 33.06686], [-117.25751, 33.06687], [-117.2568, 33.0669], [-117.25684, 33.06657], [-117.25692, 33.06651], [-117.25694, 33.06643], [-117.25702, 33.06636], [-117.25717, 33.06634], [-117.25721, 33.06619], [-117.2573, 33.06607], [-117.258, 33.0662], [-117.25802, 33.06622], [-117.25804, 33.06631], [-117.25804, 33.06686]]]}	Open Access 1	11954	Scott Valley Park	25206	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	2.043	Scott Valley Park	Local Park 2	4
6025	6025	6024	{"type": "Polygon", "coordinates": [[[-117.29297, 33.04963], [-117.29251, 33.0497], [-117.29256, 33.05011], [-117.29002, 33.05036], [-117.29001, 33.05135], [-117.29006, 33.05415], [-117.29006, 33.05493], [-117.29008, 33.05508], [-117.29009, 33.05583], [-117.28965, 33.05454], [-117.2897, 33.05432], [-117.28964, 33.05402], [-117.28925, 33.05362], [-117.28921, 33.05306], [-117.28932, 33.05287], [-117.28921, 33.05239], [-117.2886, 33.05116], [-117.28851, 33.05081], [-117.28865, 33.05081], [-117.29003, 33.0502], [-117.29008, 33.04901], [-117.29036, 33.04898], [-117.29059, 33.04906], [-117.29095, 33.04912], [-117.29277, 33.04901], [-117.29282, 33.04903], [-117.29283, 33.04906], [-117.29288, 33.04931], [-117.29297, 33.04963]]]}	Open Access 1	705	Cottonwood Creek Park	17685	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	18.276	Cottonwood Creek Park	Local Park 2	4
6031	6031	6030	{"type": "Polygon", "coordinates": [[[-117.2663, 33.02641], [-117.26626, 33.029], [-117.26557, 33.02899], [-117.26557, 33.02818], [-117.26429, 33.02817], [-117.26427, 33.02813], [-117.2643, 33.02639], [-117.2648, 33.0264], [-117.26482, 33.02544], [-117.26486, 33.02544], [-117.26486, 33.0264], [-117.2663, 33.02641]]]}	Open Access 1	725	Cardiff Sports Park	16846	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	10.684	Cardiff Sports Park	Local Recreation Area 3	4
6155	6155	6154	{"type": "Polygon", "coordinates": [[[-117.28164, 33.08023], [-117.2816, 33.08029], [-117.28142, 33.08032], [-117.28123, 33.08035], [-117.28097, 33.08036], [-117.28097, 33.08033], [-117.28106, 33.0802], [-117.28111, 33.08009], [-117.28111, 33.07999], [-117.28121, 33.07988], [-117.28118, 33.0797], [-117.2811, 33.07952], [-117.28102, 33.07943], [-117.28086, 33.07934], [-117.28062, 33.07935], [-117.2804, 33.07952], [-117.28004, 33.07923], [-117.27999, 33.07862], [-117.28148, 33.07862], [-117.28156, 33.07913], [-117.28164, 33.08023]]]}	Open Access 1	1549	Hawk View Park	19746	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	4.182	Hawk View Park	Local Park 2	4
6249	6249	6248	{"type": "MultiPolygon", "coordinates": [[[[-117.28398, 33.03442], [-117.28166, 33.03455], [-117.28165, 33.03474], [-117.28129, 33.03475], [-117.28081, 33.03422], [-117.28023, 33.03329], [-117.27949, 33.03238], [-117.2791, 33.03201], [-117.27911, 33.03199], [-117.27912, 33.03168], [-117.27912, 33.0313], [-117.27856, 33.03131], [-117.27778, 33.03006], [-117.27734, 33.02908], [-117.27734, 33.02899], [-117.2791, 33.02898], [-117.27911, 33.02902], [-117.27912, 33.02989], [-117.28088, 33.02986], [-117.28107, 33.02987], [-117.28164, 33.03032], [-117.28164, 33.03258], [-117.28272, 33.03258], [-117.28276, 33.03281], [-117.28378, 33.03278], [-117.28377, 33.03312], [-117.28378, 33.03345], [-117.28398, 33.03442]]], [[[-117.28379, 33.0324], [-117.28271, 33.03241], [-117.28264, 33.03161], [-117.28377, 33.0316], [-117.28379, 33.03181], [-117.28379, 33.0324]]]]}	Open Access 1	1338	Encinitas Community Park	29087	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	43.17	Encinitas Community Park	Local Park 2	4
6586	6586	6585	{"type": "Polygon", "coordinates": [[[-117.26461, 33.06108], [-117.26455, 33.06117], [-117.26448, 33.0613], [-117.26387, 33.06304], [-117.26366, 33.06348], [-117.26361, 33.0636], [-117.26311, 33.06359], [-117.26311, 33.06351], [-117.2632, 33.06304], [-117.2632, 33.0629], [-117.26317, 33.06286], [-117.2635, 33.06179], [-117.26335, 33.06149], [-117.26332, 33.06135], [-117.26342, 33.06107], [-117.26368, 33.06107], [-117.26368, 33.06086], [-117.26372, 33.06078], [-117.26379, 33.06074], [-117.26391, 33.06092], [-117.2641, 33.06086], [-117.26461, 33.06108]]]}	Open Access 1	3993	Leo Mullen Sports Park	29090	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	5.639	Leo Mullen Sports Park	Local Recreation Area 3	4
6681	6681	6680	{"type": "Polygon", "coordinates": [[[-117.29165, 33.03944], [-117.29132, 33.03948], [-117.29118, 33.03833], [-117.29147, 33.03831], [-117.29165, 33.03944]]]}	Open Access 1	4957	Mildred Macpherson Mini-Park	22214	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	0.914	Mildred Macpherson Mini-Park	Local Park 2	4
7095	7095	7094	{"type": "Polygon", "coordinates": [[[-117.267, 33.04596], [-117.26684, 33.046], [-117.2666, 33.04603], [-117.26623, 33.04604], [-117.26454, 33.04597], [-117.26402, 33.04593], [-117.26407, 33.04381], [-117.26554, 33.04382], [-117.26554, 33.04419], [-117.26595, 33.0442], [-117.267, 33.04596]]]}	Open Access 1	6161	Oakcrest Park	23021	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	12.712	Oakcrest Park	Local Park 2	4
7383	7383	7382	{"type": "Polygon", "coordinates": [[[-117.28854, 33.05442], [-117.28768, 33.05441], [-117.28768, 33.05453], [-117.28561, 33.05452], [-117.28569, 33.05184], [-117.28762, 33.05184], [-117.28819, 33.05336], [-117.28839, 33.05414], [-117.28854, 33.05442]]]}	Open Access 1	8114	Paul Ecke Sports Park	23530	1100	Encinitas, City of 43	City 2	City Agency 2	http://www.cityofencinitas.org/index.aspx?page=49	City 2	1100	Encinitas, City of 42	City 2	City Agency 2	http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks	San Diego 4	16.607	Paul Ecke Sports Park	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]);