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

59 rows where MNG_AGENCY = 57

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Anaheim, City of · 59

ACCESS_TYP

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
2 1 {"type": "Polygon", "coordinates": [[[-117.76165, 33.86608], [-117.76134, 33.8665], [-117.76099, 33.86678], [-117.76044, 33.86699], [-117.75997, 33.86736], [-117.75959, 33.86755], [-117.7591, 33.86766], [-117.75773, 33.86767], [-117.75736, 33.86769], [-117.75638, 33.86789], [-117.75598, 33.868], [-117.75557, 33.86803], [-117.75557, 33.86773], [-117.75555, 33.86772], [-117.75275, 33.86818], [-117.7545, 33.86471], [-117.75434, 33.86164], [-117.75405, 33.86148], [-117.75317, 33.86103], [-117.75291, 33.86085], [-117.75259, 33.86073], [-117.75223, 33.86065], [-117.75184, 33.8606], [-117.75135, 33.86059], [-117.75148, 33.86042], [-117.75152, 33.86008], [-117.75124, 33.85984], [-117.75101, 33.85984], [-117.75082, 33.85989], [-117.75034, 33.85989], [-117.75015, 33.86015], [-117.75007, 33.86015], [-117.74998, 33.86019], [-117.74956, 33.8602], [-117.74955, 33.8597], [-117.75288, 33.85971], [-117.7532, 33.85848], [-117.75327, 33.8585], [-117.75334, 33.85849], [-117.75339, 33.85845], [-117.75342, 33.8584], [-117.75342, 33.85836], [-117.75337, 33.85825], [-117.75333, 33.85806], [-117.75445, 33.8579], [-117.75486, 33.85754], [-117.75408, 33.857], [-117.75407, 33.85678], [-117.75414, 33.85612], [-117.75405, 33.85598], [-117.75404, 33.85479], [-117.75353, 33.85504], [-117.75329, 33.85472], [-117.75308, 33.8545], [-117.75282, 33.85435], [-117.75243, 33.85469], [-117.75227, 33.85464], [-117.75224, 33.85462], [-117.75219, 33.85452], [-117.75209, 33.85448], [-117.75202, 33.8545], [-117.75192, 33.85454], [-117.75183, 33.85454], [-117.7523, 33.85425], [-117.75258, 33.85411], [-117.75266, 33.85397], [-117.75251, 33.85264], [-117.75263, 33.85212], [-117.75262, 33.85122], [-117.75275, 33.85119], [-117.75232, 33.84957], [-117.75166, 33.84849], [-117.75082, 33.84817], [-117.75065, 33.84817], [-117.75054, 33.84828], [-117.7489, 33.84894], [-117.74869, 33.84889], [-117.74854, 33.84892], [-117.74821, 33.8489], [-117.74721, 33.84933], [-117.74668, 33.84977], [-117.7462, 33.85002], [-117.7458, 33.85035], [-117.74536, 33.85046], [-117.74508, 33.85036], [-117.74475, 33.85061], [-117.74384, 33.85085], [-117.74385, 33.85087], [-117.74492, 33.85126], [-117.7452, 33.85131], [-117.74528, 33.85136], [-117.74539, 33.85137], [-117.74545, 33.8514], [-117.74548, 33.85143], [-117.74527, 33.85174], [-117.74486, 33.85158], [-117.74459, 33.8515], [-117.7435, 33.85136], [-117.74302, 33.85123], [-117.74242, 33.85102], [-117.74256, 33.85085], [-117.74257, 33.85075], [-117.74255, 33.85053], [-117.74258, 33.85011], [-117.74266, 33.84987], [-117.74276, 33.84968], [-117.74304, 33.84939], [-117.74327, 33.84922], [-117.74416, 33.84919], [-117.74421, 33.84907], [-117.74381, 33.84893], [-117.74381, 33.84886], [-117.74365, 33.8487], [-117.74349, 33.84848], [-117.74339, 33.8483], [-117.74325, 33.84824], [-117.74324, 33.84785], [-117.74321, 33.84774], [-117.74308, 33.84763], [-117.7431, 33.84761], [-117.74312, 33.84756], [-117.7433, 33.84766], [-117.74335, 33.84764], [-117.7435, 33.84742], [-117.74379, 33.84709], [-117.74385, 33.84697], [-117.74391, 33.84678], [-117.74391, 33.84659], [-117.74385, 33.84628], [-117.74383, 33.84614], [-117.74387, 33.84592], [-117.74391, 33.84581], [-117.74392, 33.84573], [-117.74391, 33.84562], [-117.7438, 33.84535], [-117.74361, 33.8451], [-117.74366, 33.84506], [-117.74371, 33.84505], [-117.74385, 33.84513], [-117.74388, 33.84517], [-117.74391, 33.84523], [-117.74389, 33.84534], [-117.7439, 33.84541], [-117.74395, 33.84545], [-117.744, 33.84547], [-117.74412, 33.84545], [-117.74418, 33.8454], [-117.74441, 33.84536], [-117.74448, 33.84531], [-117.74442, 33.84515], [-117.74433, 33.84502], [-117.74431, 33.84491], [-117.74411, 33.84468], [-117.74394, 33.84459], [-117.74399, 33.84447], [-117.74405, 33.84415], [-117.7443, 33.84412], [-117.74426, 33.84392], [-117.74437, 33.84399], [-117.74444, 33.84401], [-117.74451, 33.84416], [-117.74467, 33.84444], [-117.74535, 33.84514], [-117.74544, 33.84521], [-117.7464, 33.84704], [-117.74718, 33.8471], [-117.74749, 33.84634], [-117.74927, 33.84739], [-117.75017, 33.84739], [-117.75017, 33.84673], [-117.75037, 33.84653], [-117.75048, 33.84638], [-117.75055, 33.84631], [-117.75062, 33.84626], [-117.75077, 33.8462], [-117.75091, 33.84616], [-117.75134, 33.84613], [-117.75162, 33.84627], [-117.75163, 33.8466], [-117.75215, 33.84713], [-117.75235, 33.84739], [-117.75269, 33.84739], [-117.75282, 33.84727], [-117.75289, 33.84726], [-117.75291, 33.84718], [-117.75342, 33.84667], [-117.75395, 33.84664], [-117.75418, 33.8466], [-117.7543, 33.84663], [-117.75436, 33.84669], [-117.75445, 33.84718], [-117.75326, 33.84851], [-117.75353, 33.84861], [-117.7546, 33.8491], [-117.75372, 33.8497], [-117.75379, 33.8504], [-117.75416, 33.85079], [-117.75739, 33.84813], [-117.75745, 33.84842], [-117.75751, 33.84858], [-117.75762, 33.84878], [-117.75776, 33.84898], [-117.75791, 33.84913], [-117.75809, 33.84927], [-117.75836, 33.84944], [-117.75855, 33.84952], [-117.75644, 33.85073], [-117.75489, 33.85167], [-117.75527, 33.85288], [-117.75557, 33.85402], [-117.75511, 33.85425], [-117.75571, 33.85594], [-117.7559, 33.85658], [-117.75669, 33.85816], [-117.75716, 33.85972], [-117.75758, 33.86043], [-117.75872, 33.8604], [-117.7589, 33.86054], [-117.75915, 33.86112], [-117.75867, 33.86113], [-117.75861, 33.86107], [-117.75827, 33.86127], [-117.75844, 33.86147], [-117.75864, 33.86137], [-117.75896, 33.86181], [-117.75946, 33.8618], [-117.75964, 33.86208], [-117.76001, 33.86241], [-117.75965, 33.86262], [-117.76042, 33.86425], [-117.76056, 33.86463], [-117.76069, 33.8655], [-117.76093, 33.86573], [-117.76144, 33.86572], [-117.76134, 33.86606], [-117.76165, 33.86608]]]} Open Access 1 Deer Canyon Park http://www.anaheim.net/comm_svc/parks/parkDetail.asp?dir=park_deer_canyon_preserve 129 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 287.621 Deer Canyon Park  
1308 1307 {"type": "Polygon", "coordinates": [[[-117.87341, 33.82129], [-117.87227, 33.82329], [-117.87158, 33.82441], [-117.87159, 33.82526], [-117.87155, 33.82545], [-117.87154, 33.82901], [-117.86945, 33.82901], [-117.86949, 33.82941], [-117.86947, 33.83085], [-117.86906, 33.83254], [-117.86714, 33.83252], [-117.86853, 33.82927], [-117.86873, 33.8287], [-117.86935, 33.82841], [-117.87049, 33.82854], [-117.87093, 33.82834], [-117.87094, 33.82811], [-117.87059, 33.82753], [-117.87062, 33.82706], [-117.87077, 33.82658], [-117.87092, 33.82626], [-117.87085, 33.82545], [-117.87105, 33.82527], [-117.87118, 33.82505], [-117.87069, 33.82502], [-117.8712, 33.82417], [-117.87138, 33.82369], [-117.87165, 33.82305], [-117.872, 33.82273], [-117.87245, 33.82211], [-117.87272, 33.82158], [-117.87341, 33.82129]]]} Open Access 1 Anaheim Coves   15465 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 29.091 Anaheim Coves  
1318 1317 {"type": "Polygon", "coordinates": [[[-117.76209, 33.85038], [-117.76198, 33.85034], [-117.76192, 33.85035], [-117.76201, 33.85075], [-117.76133, 33.85022], [-117.76105, 33.85004], [-117.76077, 33.8499], [-117.76053, 33.84979], [-117.76024, 33.84969], [-117.75984, 33.84959], [-117.75914, 33.84946], [-117.759, 33.84933], [-117.75885, 33.84913], [-117.75933, 33.84883], [-117.75951, 33.84902], [-117.76021, 33.84861], [-117.76209, 33.85038]]]} Open Access 1 Anaheim holding 1   15466 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 5.206 Anaheim holding 1  
1319 1318 {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74527, 33.84244], [-117.74511, 33.84249], [-117.74493, 33.84267], [-117.74482, 33.8429], [-117.74482, 33.84306], [-117.74493, 33.84329], [-117.74499, 33.84337], [-117.7443, 33.84341], [-117.74474, 33.84199], [-117.74489, 33.84174], [-117.74538, 33.84107], [-117.74549, 33.84113], [-117.7455, 33.84239]]]} Open Access 1 Anaheim holding 2   15467 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 3.08 Anaheim holding 2  
1322 1321 {"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 Anaheim holding 3   15468 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 3.955 Anaheim holding 3  
1332 1331 {"type": "Polygon", "coordinates": [[[-117.78356, 33.84518], [-117.78356, 33.84564], [-117.78066, 33.84564], [-117.78019, 33.84566], [-117.78021, 33.84548], [-117.78026, 33.84543], [-117.78065, 33.84536], [-117.78158, 33.84505], [-117.78172, 33.84502], [-117.78206, 33.84499], [-117.7823, 33.845], [-117.78248, 33.84499], [-117.78356, 33.84518]]]} Open Access 1 Anaheim holding 4   15469 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 4.264 Anaheim holding 4  
1786 1785 {"type": "Polygon", "coordinates": [[[-117.95235, 33.82235], [-117.95064, 33.82235], [-117.95063, 33.8223], [-117.95024, 33.8223], [-117.95024, 33.82151], [-117.95235, 33.82148], [-117.95235, 33.82235]]]} Open Access 1 Barton Park   15844 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 4.502 Barton Park  
2193 2192 {"type": "Polygon", "coordinates": [[[-117.89318, 33.82458], [-117.89252, 33.82475], [-117.89284, 33.82572], [-117.89126, 33.82609], [-117.89164, 33.82725], [-117.88952, 33.82775], [-117.88943, 33.82773], [-117.88941, 33.82765], [-117.88941, 33.82731], [-117.8894, 33.82549], [-117.88941, 33.82447], [-117.89102, 33.82409], [-117.89289, 33.82367], [-117.89318, 33.82458]]]} Open Access 1 Boysen Park   16318 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 24.4 Boysen Park  
2280 2279 {"type": "Polygon", "coordinates": [[[-117.96637, 33.84338], [-117.96522, 33.84339], [-117.96505, 33.84338], [-117.96434, 33.84339], [-117.96128, 33.84344], [-117.96128, 33.84194], [-117.96123, 33.83994], [-117.96283, 33.83992], [-117.96287, 33.83993], [-117.9629, 33.83997], [-117.963, 33.84154], [-117.9631, 33.8417], [-117.96324, 33.84183], [-117.96353, 33.84201], [-117.96386, 33.8421], [-117.96457, 33.8421], [-117.96567, 33.84206], [-117.96602, 33.84198], [-117.96637, 33.84197], [-117.96637, 33.84338]]]} Open Access 1 Brookhurst Park   16423 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 26.893 Brookhurst Park  
2436 2435 {"type": "Polygon", "coordinates": [[[-117.91223, 33.83697], [-117.91193, 33.83704], [-117.91187, 33.83683], [-117.91216, 33.83677], [-117.91223, 33.83697]]]} Open Access 1 Colony Square   17539 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.163 Colony Square  
2602 2601 {"type": "Polygon", "coordinates": [[[-117.7439, 33.84407], [-117.74384, 33.84445], [-117.74376, 33.84462], [-117.74352, 33.84499], [-117.74343, 33.84507], [-117.74313, 33.84529], [-117.74284, 33.84545], [-117.74194, 33.84571], [-117.74176, 33.84578], [-117.74156, 33.84549], [-117.74225, 33.84517], [-117.74237, 33.84503], [-117.74221, 33.84457], [-117.74111, 33.84381], [-117.74171, 33.84336], [-117.74186, 33.84323], [-117.74193, 33.8432], [-117.742, 33.84323], [-117.74224, 33.84341], [-117.74252, 33.84356], [-117.74293, 33.84373], [-117.74317, 33.84379], [-117.74389, 33.84388], [-117.74387, 33.84405], [-117.7439, 33.84407]]]} Open Access 1 Canyon Rim Park   16825 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 8.985 Canyon Rim Park  
2834 2833 {"type": "Polygon", "coordinates": [[[-117.94529, 33.82876], [-117.94366, 33.82873], [-117.94365, 33.82642], [-117.94527, 33.8264], [-117.94529, 33.82876]]]} Open Access 1 Chaparral Park   17125 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 9.618 Chaparral Park  
2959 2958 {"type": "Polygon", "coordinates": [[[-117.90715, 33.83743], [-117.90706, 33.83744], [-117.90704, 33.8374], [-117.90695, 33.83742], [-117.90685, 33.83739], [-117.90676, 33.83739], [-117.90674, 33.83733], [-117.90667, 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.83697], [-117.90702, 33.83706], [-117.90715, 33.83743]]]} Open Access 1 Citrus Park   17283 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 2.787 Citrus Park  
3109 3108 {"type": "Polygon", "coordinates": [[[-117.90684, 33.83022], [-117.90683, 33.83026], [-117.90596, 33.83046], [-117.90591, 33.83044], [-117.90591, 33.83039], [-117.90594, 33.83034], [-117.90592, 33.83019], [-117.90585, 33.83018], [-117.9058, 33.83014], [-117.9058, 33.8301], [-117.90582, 33.83006], [-117.90674, 33.82985], [-117.90677, 33.82996], [-117.90673, 33.83006], [-117.90674, 33.83011], [-117.90684, 33.83022]]]} Open Access 1 Colony Park   17534 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.953 Colony Park  
3224 3223 {"type": "Polygon", "coordinates": [[[-117.92104, 33.8216], [-117.92098, 33.82164], [-117.92092, 33.82159], [-117.92078, 33.82154], [-117.92025, 33.82105], [-117.92021, 33.82099], [-117.92044, 33.82094], [-117.92052, 33.82104], [-117.92104, 33.8216]]]} Open Access 1 Cottonwood Park   17687 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.387 Cottonwood Park  
3859 3858 {"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 Edison Park   18445 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 7.387 Edison Park  
4030 4029 {"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.93389, 33.8074], [-117.93377, 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 Energy Field Park   18673 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 2.55 Energy Field Park  
4083 4082 {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77422, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77383, 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.85679], [-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 Eucalyptus Park   18740 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 9.906 Eucalyptus Park  
4548 4547 {"type": "Polygon", "coordinates": [[[-117.91259, 33.83804], [-117.91258, 33.83808], [-117.91185, 33.83823], [-117.91182, 33.83819], [-117.91156, 33.83744], [-117.91234, 33.83726], [-117.91259, 33.83804]]]} Open Access 1 George Washington Park   19275 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1.678 George Washington Park  
4880 4879 {"type": "Polygon", "coordinates": [[[-118.01025, 33.8141], [-118.00963, 33.8145], [-118.00962, 33.81458], [-118.00903, 33.81458], [-118.00903, 33.81504], [-118.00862, 33.81504], [-118.00641, 33.81368], [-118.00641, 33.81364], [-118.00707, 33.81363], [-118.00708, 33.81327], [-118.00725, 33.81327], [-118.00728, 33.81363], [-118.00876, 33.81362], [-118.00878, 33.81408], [-118.01021, 33.81405], [-118.01025, 33.8141]]]} Open Access 1 Hansen Park   19648 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 6.621 Hansen Park  

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