units_with_maps

Table actions

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

18 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 42

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Encinitas, City of · 18 ✖

DES_TP 1

  • Local Park · 18 ✖

ACCESS_TYP 1

  • Open Access · 18 ✖
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
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
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
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
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
8281 8281 8280 {"type": "Polygon", "coordinates": [[[-117.29747, 33.04483], [-117.29745, 33.04483], [-117.29732, 33.04423], [-117.29724, 33.04395], [-117.29724, 33.04372], [-117.29715, 33.04331], [-117.29707, 33.04312], [-117.29708, 33.0429], [-117.29704, 33.04258], [-117.29695, 33.04237], [-117.2969, 33.04217], [-117.29686, 33.04195], [-117.29686, 33.04186], [-117.29681, 33.0416], [-117.29663, 33.0408], [-117.29663, 33.04067], [-117.29658, 33.04052], [-117.29678, 33.04049], [-117.29678, 33.04048], [-117.29669, 33.04039], [-117.29652, 33.0404], [-117.2965, 33.04035], [-117.2965, 33.0402], [-117.29646, 33.03997], [-117.29646, 33.03974], [-117.29636, 33.03948], [-117.29629, 33.03938], [-117.29625, 33.0392], [-117.29635, 33.03919], [-117.29629, 33.03898], [-117.29631, 33.0389], [-117.29616, 33.0387], [-117.29608, 33.03852], [-117.29601, 33.03843], [-117.29595, 33.03831], [-117.29588, 33.03807], [-117.29583, 33.03793], [-117.29602, 33.03792], [-117.29602, 33.0379], [-117.29594, 33.0377], [-117.29584, 33.03771], [-117.29579, 33.03752], [-117.29551, 33.03684], [-117.29536, 33.03653], [-117.29517, 33.03633], [-117.29459, 33.03587], [-117.29451, 33.03574], [-117.29427, 33.03552], [-117.29399, 33.0353], [-117.29383, 33.03523], [-117.29343, 33.03521], [-117.29333, 33.03517], [-117.29321, 33.03511], [-117.29293, 33.03491], [-117.29268, 33.03479], [-117.29248, 33.03506], [-117.29227, 33.03498], [-117.29158, 33.03506], [-117.29142, 33.03477], [-117.29147, 33.03478], [-117.29154, 33.03464], [-117.29196, 33.03416], [-117.29216, 33.0343], [-117.2923, 33.03437], [-117.29249, 33.03444], [-117.29262, 33.03451], [-117.29284, 33.03458], [-117.29298, 33.03466], [-117.29315, 33.03479], [-117.29329, 33.03493], [-117.29348, 33.03502], [-117.29393, 33.03512], [-117.2942, 33.03524], [-117.29441, 33.03538], [-117.29458, 33.03561], [-117.29488, 33.03596], [-117.29503, 33.03609], [-117.29511, 33.0362], [-117.29545, 33.03645], [-117.29551, 33.03655], [-117.29561, 33.03663], [-117.29569, 33.03675], [-117.29572, 33.03686], [-117.29588, 33.0372], [-117.29602, 33.03737], [-117.29613, 33.03746], [-117.29626, 33.03766], [-117.29626, 33.03778], [-117.29631, 33.03789], [-117.29634, 33.03814], [-117.29642, 33.03826], [-117.29646, 33.03842], [-117.29652, 33.03856], [-117.29664, 33.03907], [-117.29684, 33.03977], [-117.2968, 33.04015], [-117.29692, 33.04064], [-117.29692, 33.04082], [-117.297, 33.04112], [-117.29725, 33.04237], [-117.29724, 33.04257], [-117.29727, 33.04284], [-117.29726, 33.04298], [-117.29727, 33.04302], [-117.29725, 33.04311], [-117.29747, 33.04483]]]} Open Access 1 12670 Swami's Beach 26093 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 8.916 Swami's Beach 0 Local Park 2 4
8379 8379 8378 {"type": "Polygon", "coordinates": [[[-117.29408, 33.07322], [-117.2938, 33.07333], [-117.29357, 33.07338], [-117.2929, 33.0736], [-117.29243, 33.0734], [-117.29146, 33.07338], [-117.29145, 33.07319], [-117.29139, 33.07298], [-117.29241, 33.07275], [-117.29248, 33.07295], [-117.29268, 33.07316], [-117.29396, 33.07285], [-117.29408, 33.07322]]]} Open Access 1 12973 Standard Pacific Park Site 25781 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 3.163 Standard Pacific Park Site 0 Local Park 2 4
9275 9275 9274 {"type": "Polygon", "coordinates": [[[-117.23595, 33.05083], [-117.23587, 33.05124], [-117.23545, 33.05139], [-117.23553, 33.05113], [-117.23514, 33.05103], [-117.23532, 33.05054], [-117.23565, 33.05063], [-117.23571, 33.05071], [-117.23576, 33.05074], [-117.2359, 33.05074], [-117.23595, 33.05083]]]} Open Access 1 15445 Wiro Park 27660 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.035 Wiro Park 0 Local Park 2 4
12549 12549 12548 {"type": "Polygon", "coordinates": [[[-117.27771, 33.05534], [-117.27694, 33.05549], [-117.27667, 33.05524], [-117.27649, 33.05488], [-117.27664, 33.05484], [-117.27689, 33.05484], [-117.27712, 33.0549], [-117.27729, 33.05498], [-117.27753, 33.05517], [-117.27771, 33.05526], [-117.27771, 33.05534]]]} Open Access 1 36585 Las Verdes Park 28588 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.212 Las Verdes Park 0 Local Park 2 4

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