units_with_maps

Table actions

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

222 rows where AGNCY_TYP = 3 and AGNCY_WEB = "http://parks.lacounty.gov"

This data as json, copyable, CSV (advanced)

Suggested facets: MNG_AG_ID, MNG_AG_LEV, YR_EST

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
24 24 23 {"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.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} Open Access 1 62 Atlantic Avenue Park 15674 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.951 Atlantic Avenue Park 0 Local Park 2 4
279 279 278 {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} Open Access 1 948 George Lane Park 19270 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 13.666 George Lane Park 0 Local Park 2 4
472 472 471 {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} Open Access 1 35762 Los Angeles holding 8 21495 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.024 Los Angeles holding 8 0 Local Other or Unknown 14 4
518 518 517 {"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 2142 Bassett Park 15856 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 9.789 Bassett Park 0 Local Park 2 4
695 695 694 {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} Open Access 1 5236 McNees Park 22064 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 0.604 McNees Park 0 Local Park 2 4
742 742 741 {"type": "Polygon", "coordinates": [[[-117.98692, 34.00896], [-117.98596, 34.01059], [-117.98499, 34.01019], [-117.98594, 34.00856], [-117.98692, 34.00896]]]} Open Access 1 4789 Los Robles County Park 21532 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov/wps/portal/dpr/Parks/Los_Robles_Park Los Angeles 6 4.992 Los Robles County Park 0 Local Park 2 4
881 881 880 {"type": "MultiPolygon", "coordinates": [[[[-118.36105, 33.98786], [-118.35981, 33.98824], [-118.35975, 33.98824], [-118.3597, 33.98821], [-118.35964, 33.9879], [-118.35959, 33.98773], [-118.35831, 33.98481], [-118.35827, 33.98459], [-118.35827, 33.98439], [-118.35831, 33.98418], [-118.35836, 33.98403], [-118.35839, 33.98399], [-118.35847, 33.98397], [-118.35977, 33.98425], [-118.35986, 33.98504], [-118.35999, 33.98544], [-118.36105, 33.98786]]], [[[-118.35973, 33.98401], [-118.35883, 33.98382], [-118.35904, 33.98312], [-118.35965, 33.98323], [-118.35973, 33.98401]]]]} Open Access 1 6296 Ladera Park 32637 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 381 Los Angeles - Department of Parks and Recreation, County of 273 County 3 County Agency - Parks 7 http://parks.lacounty.gov/wps/portal/dpr/Parks/Ladera_Park Los Angeles 6 15.808 Ladera Park 0 Local Park 2 4
894 894 893 {"type": "Polygon", "coordinates": [[[-118.45532, 33.98607], [-118.45487, 33.98636], [-118.44863, 33.98473], [-118.44775, 33.98454], [-118.44312, 33.98366], [-118.44321, 33.98333], [-118.44803, 33.98424], [-118.44917, 33.9845], [-118.45221, 33.9853], [-118.45214, 33.98546], [-118.45234, 33.98552], [-118.4525, 33.98563], [-118.45259, 33.98566], [-118.45286, 33.98571], [-118.45306, 33.98569], [-118.4532, 33.9857], [-118.45343, 33.98581], [-118.45394, 33.98591], [-118.45469, 33.98616], [-118.45488, 33.98616], [-118.45515, 33.98606], [-118.45532, 33.98607]]]} Open Access 1 6328 Yvonne B. Burke Park 29027 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3 http://beaches.lacounty.gov/wps/portal/dbh/!ut/p/c4/04_SB8K8xLLM9MSSzPy8xBz9CP0os3hXAwMDd3-3YCN_ExNjA09PE88w9xAPQwMTc_2CbEdFAHGUBn8!/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/marina+del+rey/parks/yvonne+b.+burke+park Los Angeles 6 9.459 Yvonne B. Burke Park 0 Local Park 2 4
896 896 895 {"type": "Polygon", "coordinates": [[[-118.44648, 33.97594], [-118.44644, 33.97736], [-118.44573, 33.9777], [-118.4455, 33.97733], [-118.44394, 33.97806], [-118.44347, 33.97739], [-118.44648, 33.97594]]]} Open Access 1 6331 Burton W. Chace Park 16535 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3 http://www.chacepark.com/index.htm Los Angeles 6 7.375 Burton W. Chace Park 0 Local Park 2 4
918 918 917 {"type": "Polygon", "coordinates": [[[-118.35077, 33.78399], [-118.3503, 33.78418], [-118.34983, 33.78429], [-118.34641, 33.78478], [-118.34588, 33.7849], [-118.34539, 33.78507], [-118.34502, 33.78526], [-118.34483, 33.78538], [-118.34389, 33.78604], [-118.3408, 33.78344], [-118.34089, 33.78324], [-118.34097, 33.78308], [-118.34187, 33.78168], [-118.342, 33.78134], [-118.34244, 33.77986], [-118.34689, 33.78115], [-118.35035, 33.78358], [-118.35033, 33.78362], [-118.35077, 33.78399]]]} Open Access 1 5879 South Coast Botanic Garden 25642 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 81.712 South Coast Botanic Garden 0 Local Park 2 4
930 930 929 {"type": "Polygon", "coordinates": [[[-118.35399, 33.79067], [-118.35035, 33.79268], [-118.35001, 33.7929], [-118.34972, 33.79315], [-118.34952, 33.79335], [-118.34927, 33.7937], [-118.34853, 33.79307], [-118.34875, 33.79282], [-118.34783, 33.79205], [-118.34783, 33.79015], [-118.34362, 33.78659], [-118.34517, 33.78551], [-118.34559, 33.7853], [-118.34583, 33.7852], [-118.34609, 33.78513], [-118.34641, 33.78506], [-118.34996, 33.78455], [-118.35025, 33.78449], [-118.35084, 33.78427], [-118.35136, 33.78464], [-118.35157, 33.78445], [-118.3532, 33.7856], [-118.35399, 33.79067]]]} No Public Access 3 5917 South Coast Park/Peter Weber Equestrian Center 29016 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 141.298 South Coast Park/Peter Weber Equestrian Ctr. 0 Local Recreation Area 3 4
931 931 930 {"type": "Polygon", "coordinates": [[[-118.0711, 34.1307], [-118.0711, 34.13084], [-118.07107, 34.13097], [-118.07101, 34.13109], [-118.0709, 34.13121], [-118.07078, 34.1313], [-118.07065, 34.13137], [-118.07052, 34.13141], [-118.07035, 34.13143], [-118.07018, 34.13143], [-118.07004, 34.1314], [-118.06991, 34.13135], [-118.06977, 34.13128], [-118.06965, 34.13117], [-118.06958, 34.13108], [-118.06952, 34.13097], [-118.06949, 34.13082], [-118.0711, 34.1307]]]} Open Access 1 5345 Michillinda Park 22201 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 2.162 Michillinda Park 0 Local Park 2 4
995 995 994 {"type": "Polygon", "coordinates": [[[-118.29344, 33.91692], [-118.29343, 33.91878], [-118.29194, 33.91879], [-118.29196, 33.91698], [-118.29227, 33.91697], [-118.29228, 33.91692], [-118.29344, 33.91692]]]} Open Access 1 6205 Helen Keller Park 19797 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 6.993 Helen Keller Park 0 Local Park 2 4
996 996 995 {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91875], [-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 6206 Athens Park 15666 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 18.724 Athens Park 0 Local Park 2 4
1004 1004 1003 {"type": "Polygon", "coordinates": [[[-118.24421, 33.95332], [-118.24419, 33.9549], [-118.24417, 33.96001], [-118.24345, 33.96001], [-118.24343, 33.95332], [-118.24421, 33.95332]]]} Open Access 1 6224 Colonel Leon H. Washington Park 17527 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 12.642 Colonel Leon H. Washington Park 0 Local Park 2 4
1005 1005 1004 {"type": "Polygon", "coordinates": [[[-118.23173, 33.92156], [-118.23172, 33.92262], [-118.23157, 33.92263], [-118.23157, 33.9232], [-118.2314, 33.9232], [-118.2314, 33.92262], [-118.22893, 33.92262], [-118.22868, 33.92156], [-118.23173, 33.92156]]]} Open Access 1 6231 Mona Park 22363 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 8.091 Mona Park 0 Local Park 2 4
1006 1006 1005 {"type": "Polygon", "coordinates": [[[-118.26118, 33.89904], [-118.25907, 33.89909], [-118.25871, 33.89754], [-118.25875, 33.89751], [-118.25878, 33.89744], [-118.25874, 33.89721], [-118.26074, 33.89717], [-118.26118, 33.89904]]]} Open Access 1 6234 Roy Campanella Park 24710 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 10.033 Roy Campanella Park 0 Local Park 2 4
1068 1068 1067 {"type": "Polygon", "coordinates": [[[-118.1536, 34.18804], [-118.1534, 34.18862], [-118.15355, 34.18868], [-118.15335, 34.18924], [-118.15158, 34.18867], [-118.15198, 34.18752], [-118.1536, 34.18804]]]} Open Access 1 6964 Charles White Park 17143 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 5.474 Charles White Park 0 Local Park 2 4
1070 1070 1069 {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} Restricted Access 2 6971 Altadena Golf Course 33022 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 57.739 Altadena GC 0 Local Recreation Area 3 4
1088 1088 1087 {"type": "Polygon", "coordinates": [[[-118.66774, 34.09258], [-118.6677, 34.09531], [-118.66548, 34.0953], [-118.66549, 34.09463], [-118.66547, 34.09257], [-118.66774, 34.09258]]]} Open Access 1 6487 Cold Creek Canyon 29017 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 15.438 Cold Creek Canyon   None 99  

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