superunits_with_maps

Table actions

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

56 rows where MNG_AGENCY = 42 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 56 ✖

MNG_AGENCY 1

  • Encinitas, City of · 56 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
2622 2622 2621 {"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.02812], [-117.2643, 33.02639], [-117.2648, 33.02639], [-117.26482, 33.02544], [-117.26486, 33.02544], [-117.26486, 33.0264], [-117.2663, 33.02641]]]} Open Access 1 Cardiff Sports Park http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks 16846 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 10.703 Cardiff Sports Park  
3158 3158 3157 {"type": "Polygon", "coordinates": [[[-117.2641, 33.06086], [-117.26391, 33.06092], [-117.26379, 33.06074], [-117.26376, 33.06074], [-117.26372, 33.06078], [-117.26368, 33.06086], [-117.26368, 33.06107], [-117.26343, 33.06107], [-117.26332, 33.06134], [-117.26335, 33.06149], [-117.2635, 33.06179], [-117.26317, 33.06286], [-117.2632, 33.0629], [-117.2632, 33.06304], [-117.26311, 33.0635], [-117.26312, 33.06388], [-117.2631, 33.064], [-117.2631, 33.0642], [-117.26314, 33.06445], [-117.26328, 33.06493], [-117.26308, 33.06497], [-117.26266, 33.06499], [-117.2626, 33.06493], [-117.26263, 33.06455], [-117.2629, 33.0626], [-117.26295, 33.06202], [-117.26296, 33.05866], [-117.26298, 33.05863], [-117.26301, 33.05861], [-117.26329, 33.05861], [-117.26358, 33.05865], [-117.26386, 33.05873], [-117.26404, 33.05881], [-117.26382, 33.05976], [-117.2641, 33.06086]]]} Open Access 1 Encinitas holding 20   18651 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 10.234 Encinitas holding 20  
3223 3223 3222 {"type": "Polygon", "coordinates": [[[-117.29297, 33.04963], [-117.29251, 33.0497], [-117.29256, 33.05011], [-117.29002, 33.05037], [-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.05286], [-117.28921, 33.05239], [-117.2886, 33.05116], [-117.28851, 33.05081], [-117.28865, 33.05081], [-117.29002, 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 Cottonwood Creek Park http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks 17685 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 18.303 Cottonwood Creek Park  
3993 3993 3992 {"type": "Polygon", "coordinates": [[[-117.26321, 33.06745], [-117.26292, 33.06743], [-117.2629, 33.06741], [-117.26254, 33.06741], [-117.26246, 33.06737], [-117.26249, 33.06552], [-117.26252, 33.0653], [-117.26255, 33.06527], [-117.26304, 33.06525], [-117.26303, 33.06536], [-117.26294, 33.06558], [-117.26288, 33.06689], [-117.26294, 33.0671], [-117.26302, 33.06728], [-117.26306, 33.06732], [-117.26317, 33.06736], [-117.26321, 33.06745]]]} Open Access 1 Encinitas holding 1   18645 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 2.584 Encinitas holding 1  
4006 4006 4005 {"type": "Polygon", "coordinates": [[[-117.2513, 33.02732], [-117.25128, 33.02869], [-117.25071, 33.02869], [-117.25069, 33.02864], [-117.25071, 33.02859], [-117.25095, 33.02831], [-117.25101, 33.0282], [-117.25103, 33.02811], [-117.251, 33.02801], [-117.25087, 33.02786], [-117.25082, 33.02777], [-117.25085, 33.02767], [-117.25083, 33.02746], [-117.25096, 33.0274], [-117.2513, 33.02732]]]} Open Access 1 Encinitas holding 11   18646 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1.4 Encinitas holding 11  
4007 4007 4006 {"type": "Polygon", "coordinates": [[[-117.25554, 33.03255], [-117.25419, 33.03259], [-117.25425, 33.03238], [-117.25435, 33.0322], [-117.25409, 33.03203], [-117.25412, 33.03199], [-117.25439, 33.03212], [-117.25449, 33.03196], [-117.25455, 33.03175], [-117.25454, 33.03156], [-117.2545, 33.03127], [-117.25453, 33.03099], [-117.25448, 33.03085], [-117.2544, 33.03057], [-117.25438, 33.03034], [-117.25454, 33.03041], [-117.25463, 33.03047], [-117.25475, 33.03058], [-117.25485, 33.03073], [-117.25491, 33.03087], [-117.25501, 33.03152], [-117.25508, 33.03166], [-117.25522, 33.0318], [-117.2553, 33.03184], [-117.25546, 33.03189], [-117.25554, 33.03189], [-117.25554, 33.03255]]]} Open Access 1 Encinitas holding 12   18647 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 3.899 Encinitas holding 12  
4008 4008 4007 {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28543, 33.07582], [-117.28549, 33.07638]]]} Open Access 1 Encinitas holding 17   18648 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 0.091 Encinitas holding 17  
4009 4009 4008 {"type": "Polygon", "coordinates": [[[-117.25074, 33.0247], [-117.25039, 33.02472], [-117.25041, 33.02454], [-117.25054, 33.02417], [-117.25072, 33.02415], [-117.25075, 33.02464], [-117.25074, 33.0247]]]} Open Access 1 Encinitas holding 18   18649 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 0.403 Encinitas holding 18  
4010 4010 4009 {"type": "Polygon", "coordinates": [[[-117.25536, 33.02438], [-117.25535, 33.02541], [-117.25342, 33.02542], [-117.25342, 33.02439], [-117.25362, 33.02439], [-117.25364, 33.02473], [-117.25402, 33.02473], [-117.2542, 33.02486], [-117.25429, 33.02485], [-117.25449, 33.02468], [-117.25468, 33.02484], [-117.25469, 33.02535], [-117.25501, 33.02536], [-117.25504, 33.02527], [-117.2549, 33.0252], [-117.25481, 33.02506], [-117.25478, 33.02493], [-117.25484, 33.02488], [-117.25499, 33.02488], [-117.25511, 33.02493], [-117.25512, 33.02466], [-117.25501, 33.02445], [-117.25501, 33.02442], [-117.25504, 33.02438], [-117.25536, 33.02438]]]} Open Access 1 Encinitas holding 19   18650 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 3.345 Encinitas holding 19  
4011 4011 4010 {"type": "Polygon", "coordinates": [[[-117.2873, 33.08409], [-117.28675, 33.08409], [-117.28637, 33.08148], [-117.28631, 33.08126], [-117.28621, 33.08103], [-117.28589, 33.08046], [-117.28723, 33.08045], [-117.2873, 33.08409]]]} Open Access 1 Encinitas holding 25   18652 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 7.637 Encinitas holding 25  
4012 4012 4011 {"type": "Polygon", "coordinates": [[[-117.25555, 33.03156], [-117.25554, 33.03171], [-117.25551, 33.03172], [-117.25538, 33.03169], [-117.25524, 33.03157], [-117.25521, 33.03149], [-117.25511, 33.03088], [-117.25506, 33.03072], [-117.25492, 33.03051], [-117.25482, 33.0304], [-117.25463, 33.03026], [-117.25451, 33.03021], [-117.2546, 33.03006], [-117.25456, 33.02982], [-117.25446, 33.02964], [-117.25431, 33.0296], [-117.2542, 33.02922], [-117.25408, 33.02918], [-117.25351, 33.02933], [-117.25342, 33.02945], [-117.25328, 33.02971], [-117.25345, 33.0299], [-117.25259, 33.02999], [-117.25136, 33.03006], [-117.25134, 33.03033], [-117.25132, 33.03034], [-117.25131, 33.03042], [-117.25128, 33.02906], [-117.25534, 33.02898], [-117.25534, 33.02966], [-117.25539, 33.03042], [-117.25547, 33.03115], [-117.25555, 33.03156]]]} Open Access 1 Encinitas holding 26   18653 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 10.137 Encinitas holding 26  
4013 4013 4012 {"type": "Polygon", "coordinates": [[[-117.25124, 33.02661], [-117.2512, 33.02671], [-117.25099, 33.02698], [-117.25086, 33.02705], [-117.25075, 33.02708], [-117.25046, 33.02687], [-117.25028, 33.0268], [-117.25038, 33.0265], [-117.25079, 33.02648], [-117.2509, 33.02644], [-117.25108, 33.02634], [-117.25123, 33.02631], [-117.25125, 33.02646], [-117.25124, 33.02661]]]} Open Access 1 Encinitas holding 27   18654 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1.158 Encinitas holding 27  
4014 4014 4013 {"type": "Polygon", "coordinates": [[[-117.25009, 33.02695], [-117.24992, 33.02756], [-117.24973, 33.02758], [-117.24966, 33.0277], [-117.2497, 33.02792], [-117.24915, 33.02826], [-117.24915, 33.02722], [-117.24995, 33.02692], [-117.25009, 33.02695]]]} Open Access 1 Encinitas holding 28   18655 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1.843 Encinitas holding 28  
4015 4015 4014 {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} Open Access 1 Encinitas holding 29   18656 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 17.435 Encinitas holding 29  
4016 4016 4015 {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07543], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} Open Access 1 Encinitas holding 31   18657 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 0.384 Encinitas holding 31  
4017 4017 4016 {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} Open Access 1 Encinitas holding 36   18658 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 0.044 Encinitas holding 36  
4018 4018 4017 {"type": "Polygon", "coordinates": [[[-117.25343, 33.02661], [-117.25336, 33.02656], [-117.2531, 33.02647], [-117.25296, 33.02647], [-117.25283, 33.0265], [-117.25274, 33.02655], [-117.25272, 33.0266], [-117.25209, 33.0266], [-117.25196, 33.02644], [-117.25185, 33.02624], [-117.25185, 33.02612], [-117.25194, 33.02595], [-117.25198, 33.02582], [-117.25197, 33.02575], [-117.25188, 33.02556], [-117.25181, 33.02549], [-117.2517, 33.02546], [-117.25128, 33.02546], [-117.25121, 33.02543], [-117.25113, 33.02537], [-117.25112, 33.02528], [-117.25114, 33.02519], [-117.25114, 33.02506], [-117.2511, 33.02499], [-117.25105, 33.02485], [-117.25097, 33.02475], [-117.25096, 33.02471], [-117.25104, 33.02463], [-117.25107, 33.02457], [-117.25116, 33.02444], [-117.25121, 33.02433], [-117.25121, 33.02425], [-117.25113, 33.02409], [-117.25124, 33.02378], [-117.25119, 33.02362], [-117.25121, 33.02353], [-117.25123, 33.02351], [-117.25127, 33.0235], [-117.25127, 33.02542], [-117.25342, 33.02542], [-117.25343, 33.02661]]]} Open Access 1 Encinitas holding 37   18659 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 5.077 Encinitas holding 37  
4019 4019 4018 {"type": "Polygon", "coordinates": [[[-117.25303, 33.03045], [-117.25301, 33.031], [-117.25251, 33.03099], [-117.25221, 33.03096], [-117.25225, 33.0308], [-117.25224, 33.03072], [-117.25259, 33.03069], [-117.25258, 33.03044], [-117.25299, 33.03041], [-117.25303, 33.03045]]]} Open Access 1 Encinitas holding 40   18660 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 0.882 Encinitas holding 40  
4020 4020 4019 {"type": "Polygon", "coordinates": [[[-117.25097, 33.02595], [-117.25082, 33.02602], [-117.25066, 33.02604], [-117.25034, 33.02612], [-117.24989, 33.02611], [-117.24981, 33.02614], [-117.24939, 33.02641], [-117.24938, 33.02662], [-117.24941, 33.02672], [-117.24949, 33.02681], [-117.24953, 33.02685], [-117.24963, 33.02688], [-117.24997, 33.02692], [-117.24915, 33.02723], [-117.24916, 33.0291], [-117.24825, 33.02912], [-117.24825, 33.02901], [-117.24853, 33.02901], [-117.24852, 33.02874], [-117.24826, 33.02832], [-117.24789, 33.0283], [-117.24788, 33.02811], [-117.24859, 33.0281], [-117.24858, 33.02778], [-117.24844, 33.02778], [-117.24805, 33.0273], [-117.2485, 33.02721], [-117.24848, 33.02711], [-117.2487, 33.02709], [-117.2487, 33.02682], [-117.24777, 33.02649], [-117.24794, 33.02642], [-117.24793, 33.02623], [-117.24817, 33.02577], [-117.24817, 33.0257], [-117.24807, 33.02552], [-117.24913, 33.02551], [-117.24913, 33.02413], [-117.24932, 33.02414], [-117.24939, 33.02417], [-117.24926, 33.02428], [-117.24928, 33.02435], [-117.24945, 33.02447], [-117.24962, 33.02455], [-117.24967, 33.02455], [-117.24973, 33.02449], [-117.24978, 33.02449], [-117.24999, 33.02457], [-117.25006, 33.02469], [-117.25007, 33.02474], [-117.2501, 33.02514], [-117.25033, 33.02514], [-117.25038, 33.02475], [-117.25075, 33.02474], [-117.25077, 33.02476], [-117.25076, 33.02488], [-117.25073, 33.02495], [-117.25067, 33.02503], [-117.25052, 33.02515], [-117.2505, 33.0252], [-117.25053, 33.02524], [-117.25087, 33.02546], [-117.25094, 33.02554], [-117.25097, 33.02574], [-117.25097, 33.02595]]]} Open Access 1 Encinitas holding 41   18661 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 15.344 Encinitas holding 41  
4021 4021 4020 {"type": "Polygon", "coordinates": [[[-117.25127, 33.02194], [-117.25127, 33.02345], [-117.25103, 33.02344], [-117.2509, 33.02335], [-117.2507, 33.0233], [-117.25061, 33.02326], [-117.25046, 33.02314], [-117.25039, 33.02299], [-117.25041, 33.02262], [-117.25034, 33.02248], [-117.25025, 33.02238], [-117.2504, 33.02227], [-117.25071, 33.0221], [-117.25109, 33.02196], [-117.25123, 33.02192], [-117.25126, 33.02192], [-117.25127, 33.02194]]]} Open Access 1 Encinitas holding 42   18662 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 2.872 Encinitas holding 42  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);