units_with_maps

Table actions

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

6 rows where COUNTY = 4, DES_TP = 3, MNG_AGENCY = 42 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Encinitas, City of · 6 ✖

DES_TP 1

  • Local Recreation Area · 6 ✖
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
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
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
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
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
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
15652 15652 15651 {"type": "Polygon", "coordinates": [[[-117.28127, 33.07733], [-117.28113, 33.07742], [-117.2812, 33.07751], [-117.28126, 33.0776], [-117.28122, 33.07759], [-117.28117, 33.07759], [-117.28101, 33.07767], [-117.28079, 33.07775], [-117.28049, 33.0778], [-117.27999, 33.07785], [-117.27981, 33.07785], [-117.27954, 33.07782], [-117.27921, 33.07775], [-117.27907, 33.0777], [-117.27887, 33.07762], [-117.27868, 33.07752], [-117.27847, 33.07738], [-117.27806, 33.07706], [-117.27777, 33.07676], [-117.27755, 33.07699], [-117.27683, 33.0771], [-117.27543, 33.07714], [-117.27537, 33.0771], [-117.27536, 33.07715], [-117.27528, 33.07707], [-117.27512, 33.07701], [-117.275, 33.07701], [-117.27489, 33.07697], [-117.27485, 33.07693], [-117.27477, 33.07693], [-117.27462, 33.0771], [-117.27461, 33.07716], [-117.27447, 33.07719], [-117.2744, 33.07717], [-117.27431, 33.07721], [-117.27412, 33.07735], [-117.27414, 33.07739], [-117.27395, 33.07748], [-117.27383, 33.07751], [-117.27377, 33.07755], [-117.27375, 33.0777], [-117.27369, 33.07779], [-117.27362, 33.07787], [-117.27344, 33.07789], [-117.27327, 33.07787], [-117.27318, 33.07782], [-117.27313, 33.07775], [-117.2731, 33.07766], [-117.27303, 33.07755], [-117.27303, 33.07747], [-117.27307, 33.07736], [-117.27316, 33.07726], [-117.27309, 33.07701], [-117.27312, 33.07693], [-117.27317, 33.07689], [-117.27332, 33.07686], [-117.2734, 33.07692], [-117.27353, 33.07688], [-117.27355, 33.07684], [-117.27362, 33.0769], [-117.27375, 33.07696], [-117.27389, 33.077], [-117.27397, 33.077], [-117.274, 33.07698], [-117.27402, 33.07691], [-117.27412, 33.07687], [-117.27424, 33.07686], [-117.27428, 33.07683], [-117.27429, 33.07673], [-117.27424, 33.07661], [-117.27445, 33.07661], [-117.27465, 33.07655], [-117.27476, 33.07648], [-117.27478, 33.07651], [-117.27484, 33.07652], [-117.27492, 33.07647], [-117.27493, 33.07644], [-117.27505, 33.07639], [-117.27511, 33.07639], [-117.27527, 33.07631], [-117.27529, 33.07623], [-117.27536, 33.07621], [-117.27538, 33.07616], [-117.27546, 33.07608], [-117.27545, 33.07606], [-117.27539, 33.07607], [-117.2753, 33.07601], [-117.27528, 33.07584], [-117.27515, 33.07582], [-117.27493, 33.07572], [-117.27478, 33.07577], [-117.27469, 33.07578], [-117.27468, 33.0758], [-117.27471, 33.07582], [-117.27465, 33.07588], [-117.2745, 33.07596], [-117.27442, 33.07597], [-117.27433, 33.07603], [-117.27427, 33.07603], [-117.27425, 33.07612], [-117.27402, 33.07611], [-117.27399, 33.07628], [-117.2742, 33.07632], [-117.27418, 33.07636], [-117.27409, 33.0764], [-117.27402, 33.07647], [-117.27397, 33.07647], [-117.274, 33.07643], [-117.27398, 33.07637], [-117.27392, 33.07632], [-117.27392, 33.07615], [-117.274, 33.076], [-117.27409, 33.07593], [-117.27422, 33.07595], [-117.27444, 33.07577], [-117.27444, 33.07564], [-117.27436, 33.07557], [-117.27437, 33.07548], [-117.27448, 33.07527], [-117.27447, 33.07511], [-117.2745, 33.07508], [-117.27448, 33.07501], [-117.27451, 33.07484], [-117.27449, 33.07474], [-117.2745, 33.07469], [-117.27446, 33.07459], [-117.27448, 33.07455], [-117.27446, 33.07441], [-117.2745, 33.07435], [-117.27451, 33.07417], [-117.27455, 33.07407], [-117.27457, 33.07379], [-117.27455, 33.07375], [-117.27472, 33.07359], [-117.27471, 33.07358], [-117.2743, 33.07358], [-117.27436, 33.07356], [-117.27453, 33.07355], [-117.27471, 33.0735], [-117.27492, 33.07356], [-117.27502, 33.07356], [-117.27568, 33.07363], [-117.27583, 33.07362], [-117.27616, 33.07369], [-117.27626, 33.07344], [-117.27611, 33.07339], [-117.27601, 33.07345], [-117.27564, 33.07349], [-117.27554, 33.07346], [-117.2752, 33.07345], [-117.27511, 33.07345], [-117.27505, 33.07348], [-117.27498, 33.07347], [-117.27497, 33.07344], [-117.275, 33.07336], [-117.27484, 33.07331], [-117.27414, 33.07327], [-117.27415, 33.07233], [-117.27332, 33.07232], [-117.27348, 33.07201], [-117.2734, 33.07184], [-117.27328, 33.07169], [-117.27311, 33.07142], [-117.27301, 33.07114], [-117.27299, 33.07086], [-117.27299, 33.07059], [-117.27311, 33.07004], [-117.27328, 33.069], [-117.27336, 33.06887], [-117.27371, 33.06865], [-117.27414, 33.06833], [-117.27425, 33.06821], [-117.27403, 33.06799], [-117.27387, 33.06809], [-117.27353, 33.06828], [-117.27318, 33.06843], [-117.27299, 33.06807], [-117.27241, 33.06761], [-117.27232, 33.06729], [-117.27239, 33.067], [-117.27251, 33.06679], [-117.27376, 33.06567], [-117.27404, 33.06528], [-117.27431, 33.06509], [-117.27505, 33.06466], [-117.27495, 33.06452], [-117.27434, 33.06226], [-117.27434, 33.06213], [-117.27451, 33.06091], [-117.2738, 33.06058], [-117.27372, 33.05965], [-117.2742, 33.0583], [-117.27433, 33.0579], [-117.27468, 33.05752], [-117.27469, 33.05732], [-117.27476, 33.05729], [-117.27506, 33.05724], [-117.27538, 33.05724], [-117.27618, 33.05732], [-117.27658, 33.05731], [-117.27636, 33.06206], [-117.27807, 33.06204], [-117.27864, 33.06209], [-117.27938, 33.06239], [-117.28001, 33.06237], [-117.2801, 33.06245], [-117.28037, 33.06257], [-117.28027, 33.06273], [-117.28011, 33.06289], [-117.2801, 33.06292], [-117.27902, 33.06371], [-117.27885, 33.06386], [-117.27866, 33.0641], [-117.2785, 33.06445], [-117.27845, 33.06463], [-117.27836, 33.06567], [-117.27833, 33.06584], [-117.27826, 33.06603], [-117.27824, 33.06606], [-117.27813, 33.06605], [-117.27812, 33.06607], [-117.27785, 33.06654], [-117.27785, 33.06677], [-117.27672, 33.06872], [-117.27656, 33.06872], [-117.27682, 33.07143], [-117.27661, 33.07143], [-117.27664, 33.07259], [-117.27661, 33.07278], [-117.27657, 33.07293], [-117.27628, 33.07368], [-117.27619, 33.07408], [-117.27619, 33.07442], [-117.27626, 33.07508], [-117.27629, 33.07526], [-117.27718, 33.07519], [-117.27737, 33.07523], [-117.27791, 33.07524], [-117.27891, 33.07545], [-117.2797, 33.07532], [-117.28044, 33.07595], [-117.28045, 33.07622], [-117.28065, 33.0762], [-117.28077, 33.07631], [-117.28072, 33.0766], [-117.28055, 33.07686], [-117.28029, 33.07696], [-117.28049, 33.07732], [-117.28104, 33.07718], [-117.28127, 33.07733]]]} Restricted Access 2 292 Encinitas Ranch Golf Course 32986 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.jcgolf.com/courses-encinitas.php San Diego 4 184.589 Encinitas Ranch GC 0 Local Recreation Area 3 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]);