superunits_with_maps

Table actions

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

20 rows where ACCESS_TYP = 2, LAYER = 2 and MNG_AGENCY = 287

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Whittier, City of · 20 ✖

ACCESS_TYP 1

  • Restricted Access · 20 ✖
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  
11245 11245 11244 {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97832], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} Restricted Access 2 Whittier Dog Park   29862 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 0.85 Whittier Dog Park  
12705 12705 12704 {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} Restricted Access 2 Bailey Ranch House and Park   29859 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 0.382 Bailey Ranch House and Park  
14232 14232 14231 {"type": "Polygon", "coordinates": [[[-118.02929, 33.94516], [-118.02862, 33.94584], [-118.02768, 33.94519], [-118.02852, 33.94479], [-118.02852, 33.94477], [-118.02849, 33.94475], [-118.02862, 33.94468], [-118.02929, 33.94516]]]} Restricted Access 2 Mulberry Elementary School Park   31917 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 2.31 Mulberry Elementary School Park  

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