superunits_with_maps

Table actions

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

64 rows where ACCESS_TYP = 1, MNG_AGENCY = 129 and MNG_AG_LEV = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 64 ✖
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
146 146 145 {"type": "MultiPolygon", "coordinates": [[[[-117.0469, 33.01993], [-117.04624, 33.01997], [-117.04608, 33.02002], [-117.04566, 33.0202], [-117.04544, 33.02023], [-117.04533, 33.02021], [-117.04531, 33.02017], [-117.04531, 33.01938], [-117.04538, 33.01905], [-117.0454, 33.01884], [-117.04545, 33.01881], [-117.04689, 33.01881], [-117.0469, 33.01993]]], [[[-117.04567, 33.02064], [-117.04531, 33.02064], [-117.04531, 33.02039], [-117.04566, 33.02036], [-117.04567, 33.02064]]]]} Open Access 1 Valle Verde Neighborhood Park http://poway.org/Facilities/Facility/Details/Valle-Verde-Neighborhood-Park-68 31837 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 5.212 Valle Verde Neighborhood Park  
535 535 534 {"type": "Polygon", "coordinates": [[[-117.06598, 32.98269], [-117.06585, 32.98274], [-117.06419, 32.9827], [-117.06299, 32.98277], [-117.06287, 32.98236], [-117.06594, 32.98244], [-117.06598, 32.98269]]]} Open Access 1 Adobe Ridge Neighborhood Park http://poway.org/Facilities/Facility/Details/Adobe-Ridge-Neighborhood-Park-51 15273 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 2.549 Adobe Ridge Neighborhood Park  
660 660 659 {"type": "Polygon", "coordinates": [[[-117.02024, 33.0132], [-117.01973, 33.01329], [-117.0196, 33.01327], [-117.01881, 33.01276], [-117.01799, 33.01241], [-117.01699, 33.01269], [-117.01603, 33.01335], [-117.0148, 33.01197], [-117.01092, 33.01197], [-117.01053, 33.01217], [-117.01035, 33.01452], [-117.00984, 33.01458], [-117.00983, 33.01471], [-117.00833, 33.01476], [-117.00624, 33.01481], [-117.00661, 33.00841], [-117.00447, 33.0083], [-117.0041, 33.00787], [-117.00411, 33.00748], [-117.0041, 33.00747], [-116.99613, 33.00752], [-116.99177, 33.00753], [-116.99176, 33.00755], [-116.9918, 33.01127], [-116.98319, 33.01121], [-116.98315, 33.01495], [-116.97885, 33.01493], [-116.97017, 33.01493], [-116.9702, 33.0112], [-116.97879, 33.01115], [-116.97875, 33.00754], [-116.9793, 33.00015], [-116.99639, 33.00024], [-117.00082, 33.0003], [-117.00071, 33.00386], [-117.00072, 33.00387], [-117.00323, 33.00388], [-117.00335, 33.00307], [-117.00395, 33.00205], [-117.00488, 33.00136], [-117.00515, 33.00128], [-117.0052, 33.00035], [-117.00982, 33.00045], [-117.01302, 33.00155], [-117.01301, 33.0022], [-117.01471, 33.00223], [-117.01512, 33.00498], [-117.01486, 33.00487], [-117.01466, 33.00484], [-117.01433, 33.00461], [-117.01428, 33.00438], [-117.01365, 33.00411], [-117.01328, 33.00425], [-117.01278, 33.00428], [-117.0125, 33.00436], [-117.01219, 33.00453], [-117.01208, 33.00455], [-117.0117, 33.00454], [-117.01147, 33.00478], [-117.01182, 33.00566], [-117.012, 33.006], [-117.01223, 33.00624], [-117.01252, 33.00648], [-117.01283, 33.00659], [-117.01299, 33.0066], [-117.01312, 33.00668], [-117.01322, 33.00686], [-117.01302, 33.00707], [-117.01262, 33.00736], [-117.01255, 33.00743], [-117.01259, 33.00747], [-117.01271, 33.00748], [-117.01322, 33.00711], [-117.01354, 33.0068], [-117.01373, 33.0068], [-117.01388, 33.00715], [-117.01392, 33.00721], [-117.01462, 33.00698], [-117.01499, 33.00722], [-117.01517, 33.0073], [-117.01536, 33.00733], [-117.01538, 33.00741], [-117.01711, 33.00742], [-117.01753, 33.00747], [-117.01811, 33.00749], [-117.01833, 33.00748], [-117.01751, 33.00817], [-117.01851, 33.00899], [-117.01915, 33.009], [-117.01873, 33.01011], [-117.0188, 33.01052], [-117.01946, 33.01161], [-117.01963, 33.01217], [-117.01992, 33.01273], [-117.02024, 33.0132]]]} Open Access 1 Lake Poway Recreation Area http://poway.org/401/Lake-Poway 8838 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 1034.222 Lake Poway Rec. Area  
661 661 660 {"type": "Polygon", "coordinates": [[[-116.9621, 32.96655], [-116.96206, 32.97747], [-116.95777, 32.97762], [-116.95777, 32.98135], [-116.95346, 32.98146], [-116.95344, 32.9887], [-116.94488, 32.98869], [-116.94483, 32.98514], [-116.94043, 32.9852], [-116.94037, 32.97069], [-116.94486, 32.97075], [-116.95347, 32.97048], [-116.95351, 32.96324], [-116.9578, 32.9631], [-116.95781, 32.9667], [-116.9621, 32.96655]]]} Open Access 1 Iron Mountain Open Space http://powaytrails.com/trails/IronMountainPeakTrail/index.html 8834 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 884.915 Iron Mtn. OS  
1657 1657 1656 {"type": "Polygon", "coordinates": [[[-117.03828, 32.97303], [-117.03824, 32.97304], [-117.03825, 32.97329], [-117.03774, 32.97329], [-117.03772, 32.9732], [-117.03628, 32.9732], [-117.03627, 32.97203], [-117.03699, 32.97202], [-117.03699, 32.97174], [-117.03723, 32.97173], [-117.03723, 32.97121], [-117.03822, 32.97121], [-117.03824, 32.97284], [-117.03827, 32.97286], [-117.03828, 32.97303]]]} Open Access 1 Aubrey Park http://poway.org/Facilities/Facility/Details/Aubrey-Park-58 15683 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 8.294 Aubrey Park  
1985 1985 1984 {"type": "Polygon", "coordinates": [[[-117.06676, 32.94232], [-117.06643, 32.94283], [-117.06594, 32.94275], [-117.06601, 32.94232], [-117.06676, 32.94232]]]} Open Access 1 Bette Bendixen Park http://poway.org/Facilities/Facility/Details/Bette-Bendixen-Park-60 16050 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 0.773 Bette Bendixen Park  
4489 4489 4488 {"type": "MultiPolygon", "coordinates": [[[[-117.01089, 32.95821], [-117.01062, 32.95821], [-117.01045, 32.95824], [-117.00995, 32.95767], [-117.00893, 32.95625], [-117.00912, 32.95625], [-117.00913, 32.95623], [-117.00912, 32.95621], [-117.01057, 32.95622], [-117.01055, 32.95793], [-117.01064, 32.95795], [-117.01089, 32.95821]]], [[[-117.01245, 32.95986], [-117.01195, 32.95986], [-117.01144, 32.95939], [-117.01055, 32.95838], [-117.01102, 32.95836], [-117.0117, 32.95914], [-117.01245, 32.95986]]]]} Open Access 1 Garden Road Neighborhood Park http://poway.org/Facilities/Facility/Details/Garden-Road-Neighborhood-Park-61 19203 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 6.745 Garden Road Neighborhood Park  
5159 5159 5158 {"type": "Polygon", "coordinates": [[[-117.04327, 32.96018], [-117.04305, 32.96054], [-117.0429, 32.96068], [-117.04276, 32.96076], [-117.04254, 32.96116], [-117.04239, 32.96125], [-117.04205, 32.96163], [-117.04186, 32.96179], [-117.04183, 32.96185], [-117.04171, 32.96187], [-117.04174, 32.96197], [-117.04159, 32.96217], [-117.04144, 32.9623], [-117.04115, 32.96273], [-117.04119, 32.96292], [-117.04117, 32.96301], [-117.041, 32.96314], [-117.04094, 32.96323], [-117.04088, 32.96365], [-117.04093, 32.96387], [-117.04068, 32.96386], [-117.04065, 32.96266], [-117.04069, 32.96108], [-117.04074, 32.96014], [-117.04327, 32.96018]]]} Open Access 1 Hilleary Park http://poway.org/Facilities/Facility/Details/Hilleary-Park-62 19972 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 11.023 Hilleary Park  
5795 5795 5794 {"type": "Polygon", "coordinates": [[[-117.05671, 32.95304], [-117.05614, 32.95389], [-117.05578, 32.95413], [-117.05577, 32.95408], [-117.05583, 32.954], [-117.05584, 32.95393], [-117.05578, 32.95385], [-117.05569, 32.95383], [-117.05559, 32.95385], [-117.05553, 32.95393], [-117.05553, 32.954], [-117.0556, 32.95414], [-117.05469, 32.95412], [-117.05472, 32.95331], [-117.05527, 32.95331], [-117.05529, 32.95302], [-117.05671, 32.95304]]]} Open Access 1 Kumeyaay-Ipai Interpretive Center http://poway.org/369/Kumeyaay-Ipai-Interpretive-Center-at-Pau 20730 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 3.979 Kumeyaay-Ipai Interpretive Ctr.  
5950 5950 5949 {"type": "Polygon", "coordinates": [[[-117.01594, 33.00726], [-117.01592, 33.0074], [-117.01518, 33.0073], [-117.01499, 33.00722], [-117.01462, 33.00698], [-117.01391, 33.00721], [-117.01373, 33.00681], [-117.01355, 33.0068], [-117.01322, 33.00711], [-117.01271, 33.00748], [-117.01258, 33.00747], [-117.01255, 33.00742], [-117.01302, 33.00707], [-117.01321, 33.00685], [-117.01312, 33.00668], [-117.013, 33.00661], [-117.01283, 33.00659], [-117.01252, 33.00648], [-117.01222, 33.00624], [-117.012, 33.006], [-117.01182, 33.00566], [-117.01165, 33.00521], [-117.01146, 33.00478], [-117.0117, 33.00453], [-117.01208, 33.00455], [-117.01219, 33.00453], [-117.0125, 33.00436], [-117.01277, 33.00428], [-117.01328, 33.00425], [-117.01365, 33.00411], [-117.01429, 33.00438], [-117.01433, 33.00461], [-117.01466, 33.00484], [-117.01486, 33.00487], [-117.01581, 33.00526], [-117.01583, 33.00551], [-117.01569, 33.00573], [-117.0159, 33.00639], [-117.01584, 33.00649], [-117.01594, 33.00726]]]} Open Access 1 Lake Poway Park http://poway.org/401/Lake-Poway 20962 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 24.584 Lake Poway Park  
7097 7097 7096 {"type": "Polygon", "coordinates": [[[-117.02379, 33.00511], [-117.02377, 33.00515], [-117.02368, 33.00518], [-117.02366, 33.00476], [-117.02327, 33.00289], [-117.02341, 33.00257], [-117.0234, 33.00228], [-117.02348, 33.00229], [-117.02352, 33.00233], [-117.02348, 33.00314], [-117.0235, 33.00363], [-117.02379, 33.00511]]]} Open Access 1 Poway holding 1   23932 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 0.739 Poway holding 1  
7267 7267 7266 {"type": "MultiPolygon", "coordinates": [[[[-117.00783, 32.9815], [-117.00555, 32.98149], [-117.001, 32.98141], [-117.00106, 32.98524], [-117.00045, 32.98523], [-117.00039, 32.98326], [-116.99861, 32.9819], [-116.99808, 32.9819], [-116.99806, 32.98292], [-116.99648, 32.98272], [-116.99645, 32.98134], [-117.00099, 32.9814], [-117.00094, 32.97758], [-117.00553, 32.97769], [-117.00565, 32.97649], [-117.00627, 32.97651], [-117.00623, 32.97771], [-117.00782, 32.97775], [-117.00783, 32.9815]]], [[[-117.00985, 32.97663], [-117.00979, 32.97779], [-117.00848, 32.97776], [-117.00855, 32.97659], [-117.00887, 32.97659], [-117.0089, 32.976], [-117.00956, 32.97602], [-117.00953, 32.97661], [-117.00985, 32.97663]]], [[[-117.01083, 32.97545], [-117.01082, 32.97665], [-117.01018, 32.97663], [-117.01024, 32.97543], [-117.01083, 32.97545]]], [[[-117.01212, 32.97608], [-117.01212, 32.97667], [-117.01147, 32.97666], [-117.01147, 32.97607], [-117.01212, 32.97608]]]]} Open Access 1 Rattlesnake Canyon Open Space http://powaytrails.com/trails/RattlesnakeCanyonTrail/ 24193 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 95.05 Rattlesnake Canyon OS  
7656 7656 7655 {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} Open Access 1 Old Poway Park and Railroad http://poway.org/452/Old-Poway-Park 23098 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 4.927 Old Poway Park and Railroad  
8338 8338 8337 {"type": "Polygon", "coordinates": [[[-117.03112, 33.0179], [-117.03112, 33.01828], [-117.03018, 33.0182], [-117.02981, 33.01779], [-117.03112, 33.0179]]]} Open Access 1 Poway holding 32   23957 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 1.1 Poway holding 32  
8339 8339 8338 {"type": "Polygon", "coordinates": [[[-117.04961, 32.95128], [-117.04959, 32.95259], [-117.0487, 32.95287], [-117.04862, 32.95274], [-117.04857, 32.9527], [-117.04834, 32.95276], [-117.0483, 32.95283], [-117.04836, 32.95299], [-117.04851, 32.95333], [-117.04861, 32.95344], [-117.04865, 32.95345], [-117.04875, 32.9534], [-117.04894, 32.95339], [-117.04899, 32.9534], [-117.04958, 32.95322], [-117.04955, 32.95486], [-117.04763, 32.95485], [-117.04716, 32.95525], [-117.04715, 32.95541], [-117.04684, 32.95541], [-117.04686, 32.95479], [-117.04733, 32.95477], [-117.04732, 32.95467], [-117.04737, 32.95287], [-117.04735, 32.95228], [-117.04717, 32.95207], [-117.04717, 32.95198], [-117.04733, 32.95189], [-117.04754, 32.95181], [-117.04772, 32.95176], [-117.04803, 32.95181], [-117.04818, 32.95178], [-117.0492, 32.95134], [-117.04961, 32.95128]]]} Open Access 1 Poway Community Park http://poway.org/307/Community-Park 23930 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 17.561 Poway Community Park  
8341 8341 8340 {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02736, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02719, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} Open Access 1 Poway holding 10   23933 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 4.581 Poway holding 10  
8342 8342 8341 {"type": "Polygon", "coordinates": [[[-117.05962, 32.93512], [-117.05625, 32.93698], [-117.05427, 32.93557], [-117.05391, 32.93515], [-117.05962, 32.93512]]]} Open Access 1 Poway holding 11   23934 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 13.922 Poway holding 11  
8343 8343 8342 {"type": "Polygon", "coordinates": [[[-117.02371, 33.00922], [-117.02368, 33.00986], [-117.02367, 33.01319], [-117.02363, 33.01325], [-117.02347, 33.01326], [-117.02353, 33.01299], [-117.02353, 33.01255], [-117.02357, 33.0112], [-117.02337, 33.01058], [-117.02331, 33.01021], [-117.02355, 33.00952], [-117.02355, 33.00938], [-117.02348, 33.00917], [-117.02366, 33.00918], [-117.02369, 33.00919], [-117.02371, 33.00922]]]} Open Access 1 Poway holding 12   23935 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 1.944 Poway holding 12  
8344 8344 8343 {"type": "Polygon", "coordinates": [[[-117.05278, 33.02232], [-117.05243, 33.02356], [-117.05042, 33.02282], [-117.05057, 33.02268], [-117.05073, 33.02259], [-117.05091, 33.02252], [-117.05125, 33.02246], [-117.05137, 33.02241], [-117.05151, 33.02232], [-117.05278, 33.02232]]]} Open Access 1 Poway holding 13   23936 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 4.432 Poway holding 13  
8345 8345 8344 {"type": "Polygon", "coordinates": [[[-117.02825, 33.0206], [-117.02825, 33.02204], [-117.02771, 33.02203], [-117.0277, 33.02191], [-117.02771, 33.02146], [-117.02758, 33.02145], [-117.02758, 33.02065], [-117.02643, 33.02023], [-117.02648, 33.01995], [-117.0274, 33.01995], [-117.02825, 33.0206]]]} Open Access 1 Poway holding 14   23937 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 4.091 Poway holding 14  

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