superunits_with_maps

Table actions

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

48 rows where LAYER = 2, MNG_AGENCY = 287 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 48 ✖

MNG_AGENCY 1

  • Whittier, City of · 48 ✖
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
267 267 266 {"type": "Polygon", "coordinates": [[[-118.00234, 33.92712], [-118.00162, 33.92729], [-118.0016, 33.92713], [-118.0015, 33.92688], [-118.00137, 33.92672], [-118.00117, 33.92657], [-118.00098, 33.92647], [-118.00074, 33.92575], [-118.0018, 33.92549], [-118.00234, 33.92712]]]} Restricted Access 2 Scott Avenue Elementary School Park   31906 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 4.025 Scott Avenue Elementary School Park  
268 268 267 {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95723], [-117.99805, 33.95742], [-117.99797, 33.95761], [-117.99795, 33.95761], [-117.99766, 33.9579], [-117.99726, 33.95842], [-117.99394, 33.95658], [-117.99393, 33.95522], [-117.99456, 33.95479], [-117.9948, 33.95469], [-117.99819, 33.95654]]]} Restricted Access 2 La Serna High School Park   31907 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 22.497 La Serna High School Park  
269 269 268 {"type": "Polygon", "coordinates": [[[-118.02225, 33.94131], [-118.02046, 33.94359], [-118.01735, 33.94146], [-118.01943, 33.93937], [-118.02225, 33.94131]]]} Restricted Access 2 California High School Park   31908 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 26.419 California High School Park  
270 270 269 {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04711, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95263], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95256], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} Restricted Access 2 Sierra Vista Adult School Park   31909 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 16.347 Sierra Vista Adult School Park  
271 271 270 {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04542, 33.98097], [-118.04661, 33.98098]]]} Restricted Access 2 Whittier High School Park   31910 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 14.027 Whittier High School Park  
272 272 271 {"type": "Polygon", "coordinates": [[[-118.05409, 33.98997], [-118.05257, 33.98997], [-118.05256, 33.98818], [-118.05247, 33.98816], [-118.05247, 33.98725], [-118.05276, 33.98725], [-118.05365, 33.98816], [-118.05359, 33.98816], [-118.05358, 33.98817], [-118.05408, 33.98868], [-118.05409, 33.98997]]]} Restricted Access 2 Dexter Middle School Park   31911 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 8.328 Dexter Middle School Park  
273 273 272 {"type": "Polygon", "coordinates": [[[-118.00458, 33.9266], [-118.00234, 33.92712], [-118.00169, 33.92516], [-118.00393, 33.92463], [-118.00458, 33.9266]]]} Restricted Access 2 Granada Middle School Park   31912 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 12.036 Granada Middle School Park  
276 276 275 {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.0151, 33.95486], [-118.01456, 33.95557], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} Restricted Access 2 East Whittier Middle School Park   31913 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 10.472 East Whittier Middle School Park  
277 277 276 {"type": "Polygon", "coordinates": [[[-118.03804, 33.95602], [-118.03719, 33.95686], [-118.03667, 33.9565], [-118.03649, 33.95641], [-118.03662, 33.95617], [-118.0367, 33.9562], [-118.03678, 33.95608], [-118.03691, 33.95609], [-118.03698, 33.95594], [-118.03709, 33.95597], [-118.03725, 33.95565], [-118.03687, 33.95551], [-118.03656, 33.95547], [-118.03544, 33.95494], [-118.03587, 33.95451], [-118.03804, 33.95602]]]} Restricted Access 2 Laurel Elementary School Park   31914 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 4.346 Laurel Elementary School Park  
278 278 277 {"type": "Polygon", "coordinates": [[[-118.00903, 33.93231], [-118.00901, 33.93505], [-118.00717, 33.93505], [-118.00717, 33.93475], [-118.00684, 33.93474], [-118.00684, 33.93436], [-118.00787, 33.93436], [-118.00787, 33.93381], [-118.00782, 33.9337], [-118.00791, 33.93347], [-118.00798, 33.93313], [-118.00801, 33.93308], [-118.00808, 33.93307], [-118.00826, 33.93307], [-118.00832, 33.93305], [-118.00837, 33.93301], [-118.00852, 33.93231], [-118.00903, 33.93231]]]} Restricted Access 2 Hillview Middle School Park   31915 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 8.357 Hillview Middle School Park  
279 279 278 {"type": "Polygon", "coordinates": [[[-118.0221, 33.92802], [-118.02161, 33.92867], [-118.02021, 33.92797], [-118.02072, 33.92729], [-118.0221, 33.92802]]]} Restricted Access 2 La Colima Elementary School Park   31916 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 3.235 La Colima Elementary School Park  
280 280 279 {"type": "Polygon", "coordinates": [[[-117.99673, 33.93815], [-117.99599, 33.93932], [-117.99462, 33.93932], [-117.9946, 33.93877], [-117.99468, 33.93871], [-117.99477, 33.93872], [-117.99483, 33.93869], [-117.99485, 33.93866], [-117.99484, 33.93805], [-117.99631, 33.93805], [-117.99648, 33.93807], [-117.99673, 33.93815]]]} Restricted Access 2 Leffingwell Elementary School Park   31918 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 5.264 Leffingwell Elementary School Park  
281 281 280 {"type": "Polygon", "coordinates": [[[-117.98787, 33.94757], [-117.98771, 33.94783], [-117.98755, 33.94804], [-117.98742, 33.94817], [-117.98728, 33.94827], [-117.98705, 33.9484], [-117.9864, 33.94818], [-117.98619, 33.94749], [-117.98701, 33.94731], [-117.98787, 33.94757]]]} Restricted Access 2 Murphy Ranch Elementary School Park   31919 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 3.01 Murphy Ranch Elementary School Park  
282 282 281 {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} Restricted Access 2 Ocean View Elementary School Park   31920 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 5.332 Ocean View Elementary School Park  
283 283 282 {"type": "Polygon", "coordinates": [[[-118.00906, 33.93605], [-118.00905, 33.93665], [-118.00888, 33.93669], [-118.00796, 33.93701], [-118.00794, 33.93695], [-118.0074, 33.93695], [-118.00741, 33.93658], [-118.00719, 33.93652], [-118.00733, 33.93606], [-118.00706, 33.936], [-118.00713, 33.93579], [-118.0072, 33.93576], [-118.00718, 33.9357], [-118.00732, 33.93569], [-118.00731, 33.93533], [-118.0077, 33.93533], [-118.00906, 33.93605]]]} Restricted Access 2 Orchard Dale Elementary School Park   31921 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 5.707 Orchard Dale Elementary School Park  
284 284 283 {"type": "Polygon", "coordinates": [[[-118.07089, 33.98277], [-118.07034, 33.98332], [-118.07025, 33.98332], [-118.07024, 33.98291], [-118.06916, 33.98298], [-118.06903, 33.98295], [-118.06895, 33.98284], [-118.06879, 33.9828], [-118.06867, 33.98281], [-118.06848, 33.98289], [-118.06761, 33.98287], [-118.06732, 33.98319], [-118.06592, 33.98222], [-118.0659, 33.98218], [-118.06677, 33.98141], [-118.0679, 33.98218], [-118.06876, 33.9813], [-118.07089, 33.98277]]]} Restricted Access 2 Katherine Edwards Middle School Park   31922 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 12.458 Katherine Edwards Middle School Park  
285 285 284 {"type": "Polygon", "coordinates": [[[-118.06214, 33.99624], [-118.06143, 33.99697], [-118.06026, 33.99618], [-118.06023, 33.99613], [-118.06024, 33.99609], [-118.06036, 33.99591], [-118.06036, 33.99586], [-118.06034, 33.99581], [-118.06029, 33.99577], [-118.06042, 33.99562], [-118.06025, 33.99551], [-118.06031, 33.99544], [-118.06043, 33.99551], [-118.06068, 33.99526], [-118.06125, 33.99569], [-118.06164, 33.99594], [-118.06214, 33.99624]]]} Restricted Access 2 Orange Grove Elementary School Park   31923 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 4.115 Orange Grove Elementary School Park  
1060 1060 1059 {"type": "Polygon", "coordinates": [[[-118.02482, 33.98022], [-118.02407, 33.9806], [-118.02376, 33.98114], [-118.02378, 33.98121], [-118.02382, 33.98124], [-118.02386, 33.98126], [-118.02393, 33.98125], [-118.02374, 33.98136], [-118.02358, 33.98126], [-118.02323, 33.98115], [-118.0225, 33.98121], [-118.0216, 33.98166], [-118.01997, 33.98163], [-118.01995, 33.98253], [-118.01677, 33.98248], [-118.01673, 33.98326], [-118.01617, 33.98356], [-118.01558, 33.98377], [-118.01406, 33.98404], [-118.01334, 33.98402], [-118.0129, 33.9839], [-118.01238, 33.98365], [-118.01159, 33.98351], [-118.01098, 33.98353], [-118.01011, 33.98279], [-118.00999, 33.982], [-118.01028, 33.98102], [-118.01084, 33.98063], [-118.01287, 33.9814], [-118.01311, 33.98104], [-118.01375, 33.98062], [-118.01378, 33.98056], [-118.01378, 33.9805], [-118.01371, 33.98042], [-118.01361, 33.9804], [-118.01256, 33.98079], [-118.01267, 33.98046], [-118.01485, 33.97894], [-118.01564, 33.97894], [-118.01564, 33.97709], [-118.01907, 33.97712], [-118.01997, 33.97662], [-118.01998, 33.97533], [-118.0235, 33.97537], [-118.0214, 33.97828], [-118.02166, 33.9793], [-118.02168, 33.97931], [-118.02173, 33.97925], [-118.02178, 33.97918], [-118.02178, 33.97915], [-118.02303, 33.97958], [-118.02325, 33.97977], [-118.02331, 33.97974], [-118.02366, 33.98006], [-118.02415, 33.97987], [-118.02482, 33.98022]]]} Open Access 1 Worsham Canyon Open Space   14873 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 154.404 Worsham Canyon OS  
1236 1236 1235 {"type": "Polygon", "coordinates": [[[-118.01451, 33.95008], [-118.01401, 33.9514], [-118.01308, 33.95088], [-118.01304, 33.95089], [-118.01275, 33.95073], [-118.01441, 33.95002], [-118.01451, 33.95008]]]} Open Access 1 Anaconda Park   15464 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 2.702 Anaconda Park  
1378 1378 1377 {"type": "MultiPolygon", "coordinates": [[[[-118.03213, 33.99081], [-118.03186, 33.9908], [-118.03187, 33.99053], [-118.03212, 33.99053], [-118.03213, 33.99081]]], [[[-118.03399, 33.98995], [-118.03398, 33.99019], [-118.0325, 33.99019], [-118.03251, 33.98994], [-118.03399, 33.98995]]], [[[-118.03322, 33.98945], [-118.03321, 33.98986], [-118.03274, 33.98986], [-118.03275, 33.98944], [-118.03322, 33.98945]]], [[[-118.03607, 33.99067], [-118.03607, 33.99067], [-118.03508, 33.99066], [-118.03587, 33.99044], [-118.03606, 33.99043], [-118.03607, 33.99067]]], [[[-118.03783, 33.99604], [-118.03756, 33.99644], [-118.03728, 33.99647], [-118.03727, 33.99604], [-118.03757, 33.99584], [-118.03783, 33.99604]]], [[[-118.0374, 33.99507], [-118.03728, 33.99507], [-118.03728, 33.99483], [-118.03734, 33.99483], [-118.0374, 33.99507]]], [[[-118.03924, 33.99587], [-118.0392, 33.99627], [-118.0389, 33.9963], [-118.03892, 33.99616], [-118.03906, 33.99613], [-118.03913, 33.99609], [-118.03915, 33.99604], [-118.03917, 33.99586], [-118.03924, 33.99587]]], [[[-118.04615, 34.00015], [-118.04611, 34.00027], [-118.04606, 34.00029], [-118.046, 34.00034], [-118.04595, 34.00041], [-118.04595, 34.00044], [-118.04593, 34.00044], [-118.04593, 34.00008], [-118.04615, 34.00015]]]]} Open Access 1 Hellman Park http://www.lamountains.com/parks.asp?parkid=633 14853 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 2.86 Hellman 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]);