units_with_maps

Table actions

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

44 rows where ACCESS_TYP = 1, COUNTY = 4, MNG_AGENCY = 42 and YR_EST = 0

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 44 ✖
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
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 0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 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   0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 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 0 Local Recreation Area 3 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);