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

59 rows where MNG_AGENCY = 57

View and edit SQL

Suggested facets: YR_EST

MNG_AG_TYP

MNG_AGENCY

  • Anaheim, City of · 59

ACCESS_TYP

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
149 148 {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77421, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77384, 33.85862], [-117.77368, 33.85847], [-117.77332, 33.85794], [-117.77303, 33.85744], [-117.77303, 33.85684], [-117.77418, 33.8563], [-117.77437, 33.85656], [-117.77436, 33.85678], [-117.77438, 33.8569], [-117.77443, 33.85701], [-117.77465, 33.85731], [-117.77471, 33.85734], [-117.77478, 33.85736], [-117.7749, 33.85735], [-117.77568, 33.85853]]]} Open Access 1 381 Eucalyptus Park 18740 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 9.905 Eucalyptus Park 0 Local Park 2 4
634 633 {"type": "Polygon", "coordinates": [[[-117.9554, 33.84805], [-117.95368, 33.84806], [-117.95368, 33.8491], [-117.95233, 33.8491], [-117.95213, 33.8491], [-117.95203, 33.84908], [-117.95185, 33.84902], [-117.95176, 33.84896], [-117.95128, 33.84856], [-117.95129, 33.84853], [-117.95147, 33.84836], [-117.95159, 33.84822], [-117.95174, 33.84797], [-117.95186, 33.84769], [-117.95191, 33.84749], [-117.95192, 33.84719], [-117.95194, 33.84716], [-117.95198, 33.84715], [-117.95536, 33.84711], [-117.95538, 33.84713], [-117.95539, 33.84716], [-117.9554, 33.84805]]]} Open Access 1 2521 John Marshall Park 20457 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 13.948 John Marshall Park 0 Local Park 2 4
646 645 {"type": "Polygon", "coordinates": [[[-117.92364, 33.84736], [-117.92392, 33.8483], [-117.92397, 33.84862], [-117.924, 33.84983], [-117.92398, 33.84989], [-117.92393, 33.84991], [-117.92388, 33.8499], [-117.92081, 33.84838], [-117.9201, 33.84805], [-117.91997, 33.84795], [-117.91993, 33.84787], [-117.91994, 33.84743], [-117.91996, 33.84738], [-117.92002, 33.84735], [-117.92356, 33.84733], [-117.92364, 33.84736]]]} Open Access 1 3194 La Palma Park 20780 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 16.03 La Palma Park 0 Local Park 2 4
794 793 {"type": "Polygon", "coordinates": [[[-117.98034, 33.82842], [-117.97815, 33.82845], [-117.97813, 33.82675], [-117.9773, 33.82676], [-117.97729, 33.82592], [-117.97784, 33.8259], [-117.97784, 33.82578], [-117.97812, 33.82576], [-117.97812, 33.8256], [-117.97826, 33.82558], [-117.97827, 33.82525], [-117.97837, 33.82523], [-117.97838, 33.825], [-117.97961, 33.82499], [-117.97962, 33.82579], [-117.9803, 33.82579], [-117.98034, 33.82842]]]} Open Access 1 5169 Maxwell Park 21970 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 19.293 Maxwell Park 0 Local Park 2 4
868 867 {"type": "Polygon", "coordinates": [[[-117.90715, 33.83743], [-117.90706, 33.83744], [-117.90704, 33.8374], [-117.90695, 33.83742], [-117.90686, 33.83739], [-117.90676, 33.83739], [-117.90674, 33.83733], [-117.90666, 33.83734], [-117.90666, 33.8374], [-117.90662, 33.83743], [-117.90654, 33.83742], [-117.90641, 33.83707], [-117.90577, 33.83514], [-117.90619, 33.83504], [-117.90682, 33.83698], [-117.90702, 33.83706], [-117.90715, 33.83743]]]} Open Access 1 5616 Citrus Park 17283 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 2.785 Citrus Park 0 Local Park 2 4
883 882 {"type": "Polygon", "coordinates": [[[-117.92915, 33.8519], [-117.92914, 33.85374], [-117.92542, 33.85307], [-117.92542, 33.85294], [-117.92772, 33.85294], [-117.92915, 33.8519]]]} Open Access 1 5707 Manzanita Park 21768 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 6.245 Manzanita Park 0 Local Park 2 4
1202 1201 {"type": "Polygon", "coordinates": [[[-117.97826, 33.84135], [-117.97825, 33.84136], [-117.97826, 33.84163], [-117.97826, 33.84221], [-117.97824, 33.84225], [-117.97636, 33.84226], [-117.9763, 33.84225], [-117.97627, 33.84222], [-117.97626, 33.84138], [-117.97826, 33.84133], [-117.97826, 33.84135]]]} Open Access 1 8374 Peter Marshall Park 23627 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 4.555 Peter Marshall Park 0 Local Park 2 4
1262 1261 {"type": "MultiPolygon", "coordinates": [[[[-117.89776, 33.83845], [-117.89744, 33.83852], [-117.8974, 33.83843], [-117.89723, 33.83847], [-117.89726, 33.83856], [-117.89642, 33.83876], [-117.89596, 33.83739], [-117.89613, 33.83735], [-117.89625, 33.83769], [-117.89741, 33.83742], [-117.89776, 33.83845]]], [[[-117.89914, 33.83875], [-117.89831, 33.83894], [-117.89807, 33.83828], [-117.89891, 33.83808], [-117.89914, 33.83875]]]]} Open Access 1 5693 Lincoln Park 21261 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 5.389 Lincoln Park 0 Local Park 2 4
1363 1362 {"type": "Polygon", "coordinates": [[[-117.92015, 33.83653], [-117.9208, 33.83845], [-117.92079, 33.83849], [-117.91739, 33.83929], [-117.91733, 33.83928], [-117.91671, 33.83737], [-117.91673, 33.83732], [-117.91696, 33.83724], [-117.92011, 33.83652], [-117.92015, 33.83653]]]} Open Access 1 8146 Pearson Park 23549 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 18.827 Pearson Park 0 Local Park 2 4
1399 1398 {"type": "Polygon", "coordinates": [[[-117.90621, 33.79599], [-117.90614, 33.79601], [-117.90421, 33.79601], [-117.90418, 33.79433], [-117.90616, 33.79433], [-117.90621, 33.79493], [-117.90621, 33.79599]]]} Open Access 1 8773 Ponderosa Park 23887 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.563 Ponderosa Park 0 Local Park 2 4
2480 2479 {"type": "Polygon", "coordinates": [[[-117.81994, 33.85368], [-117.8184, 33.85415], [-117.81795, 33.85199], [-117.81887, 33.85177], [-117.8195, 33.85168], [-117.81994, 33.85368]]]} Open Access 1 18993 Riverdale Park 24440 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.669 Riverdale Park 0 Local Park 2 4
2901 2900 {"type": "Polygon", "coordinates": [[[-117.89577, 33.85049], [-117.8937, 33.85049], [-117.89367, 33.84909], [-117.89575, 33.84909], [-117.89577, 33.85049]]]} Open Access 1 18953 Edison Park 18445 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 7.389 Edison Park 0 Local Park 2 4
2912 2911 {"type": "Polygon", "coordinates": [[[-117.91594, 33.84882], [-117.9159, 33.84886], [-117.91549, 33.84886], [-117.91544, 33.84887], [-117.91541, 33.84891], [-117.91534, 33.8489], [-117.91524, 33.84892], [-117.91517, 33.84896], [-117.91513, 33.84903], [-117.91488, 33.84904], [-117.91487, 33.84867], [-117.91533, 33.84867], [-117.91542, 33.84868], [-117.91544, 33.84872], [-117.91594, 33.84872], [-117.91594, 33.84882]]]} Open Access 1 18988 Julianna Park 20520 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 0.607 Julianna Park 0 Local Park 2 4
2913 2912 {"type": "Polygon", "coordinates": [[[-117.88266, 33.82743], [-117.88261, 33.82743], [-117.88253, 33.82748], [-117.88251, 33.82752], [-117.8825, 33.82758], [-117.88256, 33.8277], [-117.88256, 33.82834], [-117.88256, 33.82847], [-117.8825, 33.82858], [-117.8825, 33.82862], [-117.8825, 33.82866], [-117.88254, 33.82871], [-117.88263, 33.82874], [-117.88263, 33.82903], [-117.88064, 33.82904], [-117.88065, 33.82721], [-117.88266, 33.82721], [-117.88266, 33.82743]]]} Open Access 1 18989 Juarez Park 20515 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.975 Juarez Park 0 Local Park 2 4
3192 3191 {"type": "Polygon", "coordinates": [[[-117.79028, 33.84384], [-117.79035, 33.84383], [-117.79041, 33.84386], [-117.79042, 33.8439], [-117.79042, 33.844], [-117.79036, 33.84435], [-117.79019, 33.84484], [-117.7899, 33.8448], [-117.78946, 33.84472], [-117.78895, 33.84457], [-117.78843, 33.84461], [-117.7881, 33.84458], [-117.78783, 33.8445], [-117.78761, 33.84446], [-117.78755, 33.84562], [-117.78626, 33.84563], [-117.78627, 33.84548], [-117.78631, 33.84538], [-117.78653, 33.84498], [-117.78658, 33.8448], [-117.78659, 33.84467], [-117.78657, 33.84451], [-117.78645, 33.84425], [-117.78646, 33.84421], [-117.78666, 33.84415], [-117.78687, 33.8441], [-117.7873, 33.84408], [-117.78763, 33.84412], [-117.78765, 33.8441], [-117.78775, 33.84414], [-117.7882, 33.8442], [-117.78851, 33.84421], [-117.78875, 33.8442], [-117.7889, 33.84418], [-117.78998, 33.84393], [-117.79027, 33.84386], [-117.79028, 33.84384]]]} Open Access 1 22115 Imperial Park 20180 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.207 Imperial Park 0 Local Park 2 4
3430 3429 {"type": "Polygon", "coordinates": [[[-117.91342, 33.83503], [-117.91294, 33.83515], [-117.91282, 33.83479], [-117.91293, 33.83476], [-117.91288, 33.83459], [-117.91329, 33.8345], [-117.9133, 33.83457], [-117.91331, 33.83469], [-117.91342, 33.83503]]]} Open Access 1 48740 Friendship Plaza 33466 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2 https://www.anaheim.net/facilities/facility/details/Friendship-Plaza-86 Orange 3 0.663 Friendship Plaza 0 Local Park 2 4
3447 3446 {"type": "Polygon", "coordinates": [[[-117.93509, 33.80131], [-117.93497, 33.80155], [-117.93486, 33.80182], [-117.93485, 33.80146], [-117.93281, 33.80149], [-117.93277, 33.79962], [-117.9344, 33.7996], [-117.93441, 33.79927], [-117.93463, 33.79924], [-117.93474, 33.79916], [-117.93476, 33.7992], [-117.93482, 33.79925], [-117.93494, 33.79927], [-117.93468, 33.79958], [-117.93481, 33.79959], [-117.93485, 33.80119], [-117.93509, 33.80131]]]} Open Access 1 25269 Stoddard Park 25863 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 10.242 Stoddard Park 0 Local Park 2 4
3560 3559 {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} Open Access 1 36526 Anaheim holding 3 15468 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 3.956 Anaheim holding 3 0 Local Other or Unknown 14 4
3655 3654 {"type": "Polygon", "coordinates": [[[-118.01025, 33.8141], [-118.00963, 33.8145], [-118.00962, 33.81458], [-118.00903, 33.81457], [-118.00903, 33.81504], [-118.00862, 33.81504], [-118.00641, 33.81368], [-118.00641, 33.81364], [-118.00708, 33.81363], [-118.00708, 33.81327], [-118.00725, 33.81327], [-118.00727, 33.81363], [-118.00876, 33.81362], [-118.00878, 33.81408], [-118.01021, 33.81405], [-118.01025, 33.8141]]]} Open Access 1 29596 Hansen Park 19648 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 6.605 Hansen Park 0 Local Park 2 4
3781 3780 {"type": "Polygon", "coordinates": [[[-117.93457, 33.80691], [-117.93442, 33.80719], [-117.93423, 33.80745], [-117.93415, 33.80743], [-117.93406, 33.80742], [-117.93397, 33.80743], [-117.9339, 33.8074], [-117.93378, 33.8074], [-117.93373, 33.80741], [-117.93365, 33.80747], [-117.93366, 33.80767], [-117.93284, 33.80768], [-117.93284, 33.80692], [-117.93457, 33.80691]]]} Open Access 1 8684 Energy Field Park 18673 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 2.549 Energy Field Park 0 Local Recreation Area 3 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]);