superunits_with_maps

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

171 rows where MNG_AGENCY = 16

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Los Angeles, County of · 171
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
93 92 {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04258, 34.13198], [-118.04251, 34.13189], [-118.04241, 34.13199], [-118.04249, 34.13207], [-118.04258, 34.13198]]]} Restricted Access 2 Santa Anita Golf Course   33023 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 130.966 Santa Anita GC  
127 126 {"type": "Polygon", "coordinates": [[[-118.29278, 34.22166], [-118.2774, 34.22176], [-118.27738, 34.21871], [-118.2773, 34.21531], [-118.27833, 34.21531], [-118.27835, 34.21456], [-118.28057, 34.21456], [-118.28668, 34.2146], [-118.29156, 34.2202], [-118.29278, 34.22166]], [[-118.28164, 34.21534], [-118.28164, 34.21531], [-118.28095, 34.21457], [-118.27956, 34.21495], [-118.27872, 34.21549], [-118.27971, 34.21654], [-118.28164, 34.21534]]]} Open Access 1 Henderson Canyon Open Space   19812 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 214.089 Henderson Canyon OS  
138 137 {"type": "Polygon", "coordinates": [[[-118.63703, 34.45246], [-118.63701, 34.45251], [-118.63659, 34.45296], [-118.63652, 34.45292], [-118.63652, 34.45288], [-118.63643, 34.45278], [-118.63616, 34.45261], [-118.63601, 34.45258], [-118.63597, 34.45263], [-118.63589, 34.4526], [-118.63582, 34.45248], [-118.63576, 34.45241], [-118.63541, 34.45209], [-118.63522, 34.45196], [-118.63509, 34.45188], [-118.63491, 34.45173], [-118.63482, 34.45162], [-118.63482, 34.45156], [-118.63493, 34.45143], [-118.63508, 34.45129], [-118.63542, 34.45113], [-118.63578, 34.45131], [-118.63605, 34.45148], [-118.63627, 34.45166], [-118.63652, 34.45162], [-118.63658, 34.45164], [-118.63659, 34.45166], [-118.63663, 34.45196], [-118.63675, 34.45213], [-118.63683, 34.45227], [-118.63697, 34.45233], [-118.63702, 34.45237], [-118.63703, 34.45246]]]} Open Access 1 Hasley Canyon Equestrian Park http://parks.lacounty.gov/hasley-canyon-equestrian-park/ 31829 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 4.749 Hasley Canyon Equestrian Park  
145 144 {"type": "Polygon", "coordinates": [[[-118.32848, 33.72943], [-118.32671, 33.73239], [-118.32526, 33.73476], [-118.31854, 33.73477], [-118.31852, 33.73479], [-118.31769, 33.73479], [-118.31759, 33.73502], [-118.31794, 33.73542], [-118.31779, 33.7355], [-118.31769, 33.73519], [-118.31743, 33.73524], [-118.31733, 33.73494], [-118.31728, 33.73465], [-118.31685, 33.73415], [-118.3168, 33.73389], [-118.31671, 33.7336], [-118.31656, 33.73327], [-118.31645, 33.73309], [-118.31625, 33.73283], [-118.31524, 33.73163], [-118.31697, 33.73061], [-118.3163, 33.72979], [-118.3163, 33.72938], [-118.31855, 33.72939], [-118.31854, 33.73106], [-118.31856, 33.73198], [-118.31984, 33.73199], [-118.31986, 33.73185], [-118.31991, 33.7317], [-118.31997, 33.73159], [-118.32008, 33.73147], [-118.32022, 33.73136], [-118.3203, 33.73132], [-118.3208, 33.73113], [-118.32094, 33.73103], [-118.32102, 33.73089], [-118.32101, 33.7294], [-118.32848, 33.72943]]]} Open Access 1 Deane Dana Friendship Natural Area http://parks.lacounty.gov/deane-dana-friendship-natural-area/ 31836 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 129.634 Deane Dana Friendship Natural Area  
516 515 {"type": "Polygon", "coordinates": [[[-118.52638, 34.34108], [-118.52584, 34.34096], [-118.52536, 34.34088], [-118.52304, 34.34055], [-118.52197, 34.34042], [-118.52208, 34.33992], [-118.523, 34.33996], [-118.5235, 34.33945], [-118.52521, 34.3407], [-118.52551, 34.34042], [-118.52601, 34.34081], [-118.5261, 34.34068], [-118.52638, 34.34073], [-118.52638, 34.34108]]]} Open Access 1 Michael D Antonovich Open Space http://www.lamountains.com/parks.asp?parkid=8 6049 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 6.271 Michael D Antonovich OS  
606 605 {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03777, 33.94223]]]} Open Access 1 Adventure Park   15277 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 14.562 Adventure Park  
651 650 {"type": "Polygon", "coordinates": [[[-118.46707, 34.3301], [-118.46689, 34.33699], [-118.44933, 34.3374], [-118.44942, 34.32994], [-118.46482, 34.33008], [-118.46481, 34.33011], [-118.46429, 34.3302], [-118.46422, 34.33041], [-118.46386, 34.33059], [-118.46412, 34.33168], [-118.46384, 34.33173], [-118.46383, 34.33175], [-118.46393, 34.33219], [-118.46417, 34.33245], [-118.46391, 34.3328], [-118.46431, 34.33309], [-118.46458, 34.33243], [-118.46458, 34.332], [-118.46516, 34.33138], [-118.46517, 34.33076], [-118.46563, 34.33072], [-118.46564, 34.33048], [-118.46525, 34.33044], [-118.46531, 34.33009], [-118.46707, 34.3301]]]} Open Access 1 Rim of the Valley County Parkland   6072 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 311.913 Rim of the Valley County Parkland  
655 654 {"type": "Polygon", "coordinates": [[[-118.21741, 34.23745], [-118.21722, 34.24452], [-118.21284, 34.2442], [-118.21294, 34.24101], [-118.21292, 34.241], [-118.20853, 34.24092], [-118.20841, 34.24387], [-118.20398, 34.24355], [-118.20426, 34.23723], [-118.20431, 34.23366], [-118.2065, 34.23369], [-118.2083, 34.23106], [-118.20982, 34.22811], [-118.21083, 34.22869], [-118.21091, 34.22868], [-118.21098, 34.22864], [-118.21133, 34.22834], [-118.21139, 34.22827], [-118.21146, 34.22812], [-118.21187, 34.22837], [-118.21208, 34.22824], [-118.21233, 34.22814], [-118.21242, 34.22809], [-118.21258, 34.22789], [-118.21276, 34.22776], [-118.2129, 34.22771], [-118.21311, 34.22768], [-118.21319, 34.22762], [-118.21328, 34.22765], [-118.21332, 34.22758], [-118.21332, 34.22747], [-118.21328, 34.2274], [-118.21321, 34.22733], [-118.21319, 34.22729], [-118.21321, 34.22707], [-118.21362, 34.22719], [-118.21387, 34.22687], [-118.21432, 34.22655], [-118.21681, 34.22656], [-118.21613, 34.22701], [-118.21663, 34.22744], [-118.21527, 34.22884], [-118.21313, 34.23019], [-118.2131, 34.23379], [-118.21162, 34.23378], [-118.21159, 34.23733], [-118.21741, 34.23745]]]} Open Access 1 Winery Canyon Open Space   6117 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 343.012 Winery Canyon OS  
665 664 {"type": "Polygon", "coordinates": [[[-118.44648, 33.97594], [-118.44644, 33.97736], [-118.44573, 33.9777], [-118.44549, 33.97734], [-118.44394, 33.97806], [-118.44347, 33.97739], [-118.44648, 33.97594]]]} Open Access 1 Burton W. Chace Park http://www.chacepark.com/index.htm 16535 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 7.377 Burton W. Chace Park  
685 684 {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} Open Access 1 Alondra Community Regional Park   15402 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 15.212 Alondra Community RP  
1224 1223 {"type": "Polygon", "coordinates": [[[-117.96354, 34.0398], [-117.96255, 34.04072], [-117.96092, 34.03957], [-117.96193, 34.03862], [-117.96354, 34.0398]]]} Open Access 1 Allen J Martin Park   15378 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 6.796 Allen J Martin Park  
1249 1248 {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} Open Access 1 Aubrey E. Austin Jr. Park and North Jetty https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty 15682 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 0.965 Aubrey E. Austin Jr. Park and North Jetty  
1466 1465 {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70526, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69944, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69916, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69837, 34.03173], [-118.69826, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.6972, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70227, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70589, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} Open Access 1 Amarillo Beach   15438 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 5.783 Amarillo Beach  
1474 1473 {"type": "Polygon", "coordinates": [[[-118.05172, 33.93163], [-118.05126, 33.93164], [-118.05124, 33.93161], [-118.0496, 33.93161], [-118.04959, 33.92815], [-118.05097, 33.92917], [-118.05171, 33.92968], [-118.05172, 33.93163]]]} Open Access 1 Amelia Mayberry Park   15446 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 14.436 Amelia Mayberry Park  
1498 1497 {"type": "Polygon", "coordinates": [[[-118.08333, 34.20101], [-118.0833, 34.20282], [-118.0787, 34.20281], [-118.07873, 34.201], [-118.08333, 34.20101]]]} Open Access 1 Angeles National Forest   15491 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 21.075 Angeles NF 1908
1553 1552 {"type": "MultiPolygon", "coordinates": [[[[-118.0383, 34.1366], [-118.03704, 34.13795], [-118.03692, 34.1379], [-118.03674, 34.1381], [-118.03674, 34.13812], [-118.03683, 34.13817], [-118.03527, 34.13986], [-118.0351, 34.13987], [-118.03504, 34.13992], [-118.0316, 34.13997], [-118.03151, 34.13565], [-118.03198, 34.13576], [-118.03227, 34.13601], [-118.03259, 34.13624], [-118.03292, 34.13634], [-118.03343, 34.13635], [-118.03405, 34.13627], [-118.0349, 34.13614], [-118.03571, 34.13614], [-118.03624, 34.13619], [-118.03681, 34.13613], [-118.03775, 34.13635], [-118.0383, 34.1366]]], [[[-118.04112, 34.13356], [-118.04112, 34.13356], [-118.04099, 34.1337], [-118.04109, 34.13358], [-118.04112, 34.13356]]]]} Open Access 1 Arcadia Community Regional Park   15565 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 50.673 Arcadia Community RP  
1642 1641 {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91876], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} Open Access 1 Athens Park   15666 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 18.721 Athens Park  
1649 1648 {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15502, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} Open Access 1 Atlantic Avenue Park   15674 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 1.951 Atlantic Avenue Park  
1796 1795 {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} Open Access 1 Bassett Park   15856 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 9.79 Bassett Park  
1945 1944 {"type": "Polygon", "coordinates": [[[-118.15988, 34.03624], [-118.15906, 34.03626], [-118.15743, 34.03622], [-118.15728, 34.03626], [-118.15722, 34.03384], [-118.15715, 34.03383], [-118.15715, 34.03355], [-118.15977, 34.03352], [-118.15977, 34.03385], [-118.15987, 34.03386], [-118.15988, 34.03624]]]} Open Access 1 Belvedere Park Lake   16000 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 17.955 Belvedere Park Lake  

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]);
Powered by Datasette · Query took 54.904ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette