units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
153 rows where ACCESS_TYP = 1 and MNG_AGENCY = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 153 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8322 | 8322 | 8321 | {"type": "Polygon", "coordinates": [[[-118.60332, 34.08036], [-118.60312, 34.08066], [-118.60292, 34.08071], [-118.60319, 34.08034], [-118.60332, 34.08036]]]} | Open Access 1 | 12773 | Los Angeles County Open Space | 21481 | 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.131 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 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/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 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/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | 45847 | San Dimas Staging Area | 28895 | 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/San_Dimas_Staging_Area | Los Angeles 6 | 0.247 | San Dimas Staging Area | None 334 | ||
16106 | 16106 | 16105 | {"type": "Polygon", "coordinates": [[[-118.60065, 34.08186], [-118.60046, 34.08215], [-118.60015, 34.08199], [-118.60027, 34.08183], [-118.60041, 34.08174], [-118.60065, 34.08186]]]} | Open Access 1 | 12772 | Los Angeles County Open Space | 21481 | 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.276 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
7178 | 7178 | 7177 | {"type": "Polygon", "coordinates": [[[-118.45957, 33.97626], [-118.45923, 33.97627], [-118.4592, 33.97624], [-118.4591, 33.97585], [-118.45895, 33.97554], [-118.45957, 33.97626]]]} | Open Access 1 | 6321 | Marina del Rey pocket park | 21821 | 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.299 | Marina del Rey pocket park | None 586 | |||
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | 35562 | Los Angeles holding 5 | 21492 | 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.502 | Los Angeles holding 5 | 0 | Local Other or Unknown 14 | 4 | |
14937 | 14937 | 14936 | {"type": "Polygon", "coordinates": [[[-118.24398, 33.98243], [-118.24382, 33.9825], [-118.24369, 33.98261], [-118.24358, 33.98273], [-118.24352, 33.98286], [-118.24352, 33.98212], [-118.24397, 33.98212], [-118.24398, 33.98243]]]} | Open Access 1 | 45533 | El Parque Nuestro | 28364 | 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/El_Parque_Nuestro | Los Angeles 6 | 0.536 | El Parque Nuestro | None 1288 | ||
13481 | 13481 | 13480 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | 35765 | Los Angeles holding 11 | 21486 | 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.54 | Los Angeles holding 11 | 0 | Local Other or Unknown 14 | 4 | |
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60322, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60305, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.60229, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | 6423 | Canyon Oaks Open Space Access | 16820 | 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.571 | Canyon Oaks OS Access | 0 | Local Recreation Area 3 | 4 | |
6057 | 6057 | 6056 | {"type": "MultiPolygon", "coordinates": [[[[-118.63961, 34.08679], [-118.63961, 34.08715], [-118.63934, 34.08714], [-118.63934, 34.08678], [-118.63961, 34.08679]]], [[[-118.63982, 34.08972], [-118.63981, 34.08989], [-118.63954, 34.08989], [-118.63954, 34.08973], [-118.63982, 34.08972]]], [[[-118.65158, 34.11324], [-118.65137, 34.11354], [-118.65114, 34.11342], [-118.65135, 34.11313], [-118.65158, 34.11324]]]]} | Open Access 1 | 12781 | Santa Monica Mountains National Recreation Area | 6093 | 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.nps.gov/samo/index.htm | Los Angeles 6 | 0.591 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
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 | |
12113 | 12113 | 12112 | {"type": "Polygon", "coordinates": [[[-118.33769, 33.99873], [-118.33749, 33.99926], [-118.33744, 33.99931], [-118.33736, 33.99931], [-118.3369, 33.99912], [-118.33688, 33.99909], [-118.3369, 33.99905], [-118.33762, 33.99869], [-118.33767, 33.99869], [-118.33769, 33.99873]]]} | Open Access 1 | 25041 | Monteith Parkway | 29043 | 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.64 | Monteith Parkway | 0 | Local Recreation Area 3 | 4 | |
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
7179 | 7179 | 7178 | {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} | Open Access 1 | 6323 | Aubrey E. Austin Jr. Park and North Jetty | 15682 | 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 | https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty | Los Angeles 6 | 0.966 | Aubrey E. Austin Jr. Park and North Jetty | None 587 | ||
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 | |
13480 | 13480 | 13479 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | 35764 | Los Angeles holding 10 | 21485 | 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.032 | Los Angeles holding 10 | 0 | Local Other or Unknown 14 | 4 | |
15081 | 15081 | 15080 | {"type": "MultiPolygon", "coordinates": [[[[-118.18119, 34.01648], [-118.18066, 34.01648], [-118.18065, 34.01554], [-118.18118, 34.01554], [-118.18119, 34.01648]]], [[[-118.1819, 34.01593], [-118.18139, 34.01594], [-118.18139, 34.01566], [-118.1819, 34.01566], [-118.1819, 34.01593]]]]} | Open Access 1 | 45861 | Parque de los Suenos | 28908 | 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/Parque_de_los_Suenos | Los Angeles 6 | 1.61 | Parque de los Suenos | None 1307 | ||
13458 | 13458 | 13457 | {"type": "Polygon", "coordinates": [[[-118.16322, 34.20967], [-118.16308, 34.21031], [-118.16183, 34.21032], [-118.1618, 34.20908], [-118.16226, 34.2091], [-118.16218, 34.20921], [-118.16211, 34.20936], [-118.16205, 34.20959], [-118.16203, 34.20973], [-118.16203, 34.21], [-118.16209, 34.2101], [-118.1622, 34.21018], [-118.16229, 34.2102], [-118.1624, 34.2102], [-118.16254, 34.21015], [-118.16284, 34.20986], [-118.16294, 34.20972], [-118.16298, 34.20963], [-118.16322, 34.20967]]]} | Open Access 1 | 35757 | Los Angeles holding 7 | 21494 | 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.731 | Los Angeles holding 7 | 0 | Local Other or Unknown 14 | 4 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]);