units_with_maps

Table actions

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

54 rows where AGNCY_NAME = 43, MNG_AGENCY = 42 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL, YR_EST, GAP_STS

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 54 ✖

MNG_AGENCY 1

  • Encinitas, City of · 54 ✖
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
104 104 103 {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} Open Access 1 288 Encinitas Ranch Community Use Site 18665 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.497 Encinitas Ranch Community Use Site   None 12  
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
219 219 218 {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} Open Access 1 708 Swami's Bluff Parcels 26094 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 0.079 Swami's Bluff Parcels   None 23  
255 255 254 {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} Open Access 1 709 Swami's Bluff Parcels 26094 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 0.184 Swami's Bluff Parcels   None 27  
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
4932 4932 4931 {"type": "Polygon", "coordinates": [[[-117.25556, 33.02003], [-117.25123, 33.02002], [-117.25123, 33.0188], [-117.25221, 33.01809], [-117.2555, 33.01812], [-117.25556, 33.02003]]]} Open Access 1 730 San Elijo Lagoon Ecological Reserve 24879 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 20.255 San Elijo Lagoon ER 1983 Local Conservation Area 4 2
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
6149 6149 6148 {"type": "Polygon", "coordinates": [[[-117.31046, 33.07653], [-117.30964, 33.07651], [-117.30962, 33.07645], [-117.31043, 33.07647], [-117.31046, 33.07653]]]} Open Access 1 1160 Grandview 19428 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 0.131 Grandview   None 495  
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

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