units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
152 rows where DES_TP = 14 and MNG_AGENCY = 27 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 132 ✖
DES_TP 1
- Local Other or Unknown · 132 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4706 | 4706 | 4705 | {"type": "MultiPolygon", "coordinates": [[[[-118.36306, 34.69952], [-118.36255, 34.69995], [-118.36134, 34.69907], [-118.36169, 34.69893], [-118.36161, 34.69877], [-118.36177, 34.69869], [-118.36191, 34.69859], [-118.36306, 34.69952]]], [[[-118.36395, 34.67891], [-118.36285, 34.67895], [-118.36284, 34.67803], [-118.36394, 34.67799], [-118.36395, 34.67891]]], [[[-118.37499, 34.69955], [-118.37457, 34.70039], [-118.37355, 34.70004], [-118.37398, 34.6992], [-118.37499, 34.69955]]]]} | Unknown Access 4 | 46179 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 7.563 | 0 | Local Other or Unknown 14 | 4 | ||
4707 | 4707 | 4706 | {"type": "MultiPolygon", "coordinates": [[[[-118.45404, 34.80937], [-118.45382, 34.80958], [-118.45366, 34.80984], [-118.45293, 34.8096], [-118.45239, 34.80907], [-118.45318, 34.80853], [-118.45404, 34.80937]]], [[[-118.45543, 34.8084], [-118.45473, 34.80888], [-118.45388, 34.80805], [-118.45371, 34.80815], [-118.45285, 34.80731], [-118.45357, 34.80682], [-118.45442, 34.80765], [-118.45457, 34.80756], [-118.45543, 34.8084]]], [[[-118.47005, 34.80115], [-118.46989, 34.80117], [-118.46966, 34.80115], [-118.4695, 34.80111], [-118.46935, 34.80105], [-118.46916, 34.80091], [-118.46881, 34.80053], [-118.47004, 34.79978], [-118.47005, 34.80115]]]]} | Unknown Access 4 | 46180 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.506 | 0 | Local Other or Unknown 14 | 4 | ||
4708 | 4708 | 4707 | {"type": "MultiPolygon", "coordinates": [[[[-118.22898, 34.11301], [-118.22892, 34.11313], [-118.22861, 34.11303], [-118.22866, 34.11291], [-118.22866, 34.1126], [-118.22868, 34.11254], [-118.22894, 34.11265], [-118.22877, 34.11291], [-118.22898, 34.11301]]], [[[-118.23051, 34.11336], [-118.23045, 34.11346], [-118.23005, 34.11334], [-118.23022, 34.11324], [-118.23051, 34.11336]]]]} | Unknown Access 4 | 46182 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.409 | 0 | Local Other or Unknown 14 | 4 | ||
4709 | 4709 | 4708 | {"type": "Polygon", "coordinates": [[[-118.38733, 34.76821], [-118.38594, 34.76821], [-118.38593, 34.76763], [-118.38732, 34.76764], [-118.38733, 34.76821]]]} | Unknown Access 4 | 46187 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.001 | 0 | Local Other or Unknown 14 | 4 | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.35225, 34.27148], [-118.35164, 34.27143], [-118.35019, 34.27137], [-118.35132, 34.27105], [-118.3521, 34.27136], [-118.35225, 34.27148]]]} | Unknown Access 4 | 46188 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.997 | 0 | Local Other or Unknown 14 | 4 | ||
4711 | 4711 | 4710 | {"type": "MultiPolygon", "coordinates": [[[[-118.33135, 34.47091], [-118.32554, 34.47086], [-118.32558, 34.46797], [-118.32824, 34.46768], [-118.33024, 34.46772], [-118.33048, 34.4682], [-118.33059, 34.46854], [-118.33064, 34.46882], [-118.33072, 34.46952], [-118.33081, 34.46994], [-118.33098, 34.47034], [-118.33128, 34.47084], [-118.33135, 34.47091]]], [[[-118.33088, 34.46918], [-118.33082, 34.46867], [-118.33072, 34.46827], [-118.33058, 34.46795], [-118.33022, 34.46727], [-118.33055, 34.4672], [-118.33063, 34.46781], [-118.33069, 34.46804], [-118.33084, 34.46849], [-118.33088, 34.46866], [-118.3309, 34.46885], [-118.33088, 34.46918]]], [[[-118.33212, 34.46786], [-118.33139, 34.46786], [-118.33163, 34.46853], [-118.33145, 34.46989], [-118.33165, 34.47052], [-118.3317, 34.471], [-118.33167, 34.471], [-118.33139, 34.47067], [-118.33125, 34.47046], [-118.3311, 34.47014], [-118.33104, 34.46994], [-118.33101, 34.46965], [-118.33107, 34.46887], [-118.33105, 34.46866], [-118.33101, 34.46846], [-118.33081, 34.46789], [-118.33076, 34.46757], [-118.33072, 34.46757], [-118.33068, 34.46717], [-118.33089, 34.46713], [-118.33138, 34.46749], [-118.33211, 34.4674], [-118.33212, 34.46786]]]]} | Unknown Access 4 | 46210 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 46.474 | 0 | Local Other or Unknown 14 | 4 | ||
4713 | 4713 | 4712 | {"type": "MultiPolygon", "coordinates": [[[[-118.22834, 34.46304], [-118.21967, 34.46267], [-118.21965, 34.45974], [-118.22184, 34.4597], [-118.22185, 34.46123], [-118.22399, 34.46126], [-118.224, 34.46125], [-118.22399, 34.45966], [-118.22834, 34.45957], [-118.22834, 34.46304]]], [[[-118.25353, 34.4727], [-118.25349, 34.47452], [-118.24931, 34.47452], [-118.24936, 34.47271], [-118.25353, 34.4727]]], [[[-118.26253, 34.47437], [-118.26244, 34.47625], [-118.26019, 34.47627], [-118.26027, 34.47441], [-118.26253, 34.47437]]]]} | Unknown Access 4 | 46220 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 91.095 | 0 | Local Other or Unknown 14 | 4 | ||
4714 | 4714 | 4713 | {"type": "MultiPolygon", "coordinates": [[[[-117.70087, 34.64609], [-117.7008, 34.64792], [-117.70025, 34.64792], [-117.70031, 34.64609], [-117.70087, 34.64609]]], [[[-117.77844, 34.67386], [-117.77404, 34.67393], [-117.77402, 34.67208], [-117.77843, 34.67202], [-117.77844, 34.67386]]], [[[-117.78112, 34.66184], [-117.78056, 34.66185], [-117.78056, 34.66092], [-117.78111, 34.66092], [-117.78112, 34.66184]]]]} | Unknown Access 4 | 46223 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 24.238 | 0 | Local Other or Unknown 14 | 4 | ||
4715 | 4715 | 4714 | {"type": "Polygon", "coordinates": [[[-118.23063, 34.61645], [-118.23009, 34.61744], [-118.22997, 34.6177], [-118.22994, 34.6177], [-118.22981, 34.61794], [-118.22977, 34.61793], [-118.22965, 34.61815], [-118.22951, 34.61845], [-118.22939, 34.61843], [-118.2291, 34.6188], [-118.22877, 34.6188], [-118.22856, 34.61872], [-118.22848, 34.61873], [-118.22842, 34.61876], [-118.22838, 34.61883], [-118.22773, 34.61926], [-118.22752, 34.61926], [-118.22751, 34.61704], [-118.22832, 34.61645], [-118.23063, 34.61645]]]} | Unknown Access 4 | 46225 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.389 | 0 | Local Other or Unknown 14 | 4 | ||
4716 | 4716 | 4715 | {"type": "Polygon", "coordinates": [[[-118.40496, 34.77529], [-118.39615, 34.77542], [-118.39603, 34.76097], [-118.39596, 34.75394], [-118.3961, 34.75369], [-118.4048, 34.75357], [-118.40496, 34.77529]]]} | Unknown Access 4 | 46228 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 480.911 | 0 | Local Other or Unknown 14 | 4 | ||
4721 | 4721 | 4720 | {"type": "Polygon", "coordinates": [[[-118.601, 34.12191], [-118.60099, 34.12209], [-118.60081, 34.12214], [-118.60084, 34.12191], [-118.60091, 34.12192], [-118.601, 34.12191]]]} | Unknown Access 4 | 46346 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.085 | 0 | Local Other or Unknown 14 | 4 | ||
4722 | 4722 | 4721 | {"type": "Polygon", "coordinates": [[[-118.31733, 34.27955], [-118.31732, 34.28397], [-118.31513, 34.28396], [-118.31513, 34.28339], [-118.31655, 34.28231], [-118.31632, 34.2815], [-118.31277, 34.28366], [-118.31278, 34.28092], [-118.31618, 34.27996], [-118.31613, 34.28034], [-118.31633, 34.28036], [-118.31643, 34.28035], [-118.31696, 34.28014], [-118.31714, 34.28002], [-118.31723, 34.27991], [-118.31728, 34.27979], [-118.31733, 34.27955]]]} | Unknown Access 4 | 46313 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 31.653 | 0 | Local Other or Unknown 14 | 4 | ||
4723 | 4723 | 4722 | {"type": "Polygon", "coordinates": [[[-118.50663, 34.13797], [-118.50613, 34.13864], [-118.50518, 34.14064], [-118.50475, 34.14069], [-118.50477, 34.14017], [-118.50488, 34.13984], [-118.50491, 34.13986], [-118.50492, 34.1399], [-118.50499, 34.13992], [-118.50503, 34.13989], [-118.50508, 34.13988], [-118.50511, 34.13978], [-118.50507, 34.13976], [-118.50532, 34.1393], [-118.50484, 34.13897], [-118.5051, 34.13819], [-118.50408, 34.13792], [-118.50474, 34.13618], [-118.50489, 34.13538], [-118.50493, 34.13376], [-118.5059, 34.13377], [-118.50663, 34.13351], [-118.50663, 34.13797]]]} | Unknown Access 4 | 46323 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 27.007 | 0 | Local Other or Unknown 14 | 4 | ||
4724 | 4724 | 4723 | {"type": "Polygon", "coordinates": [[[-118.37172, 34.10321], [-118.37135, 34.10341], [-118.37119, 34.10336], [-118.37126, 34.10321], [-118.37172, 34.10321]]]} | Unknown Access 4 | 46333 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.149 | 0 | Local Other or Unknown 14 | 4 | ||
4725 | 4725 | 4724 | {"type": "MultiPolygon", "coordinates": [[[[-118.60336, 34.12324], [-118.60346, 34.12329], [-118.60347, 34.12333], [-118.60345, 34.12337], [-118.60339, 34.12342], [-118.60315, 34.12351], [-118.6031, 34.1234], [-118.60319, 34.12337], [-118.60321, 34.12333], [-118.60336, 34.12324]]], [[[-118.60346, 34.12362], [-118.6033, 34.12361], [-118.6033, 34.12348], [-118.60346, 34.1234], [-118.60346, 34.12362]]]]} | Unknown Access 4 | 46335 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.199 | 0 | Local Other or Unknown 14 | 4 | ||
4726 | 4726 | 4725 | {"type": "Polygon", "coordinates": [[[-118.65258, 34.04922], [-118.6499, 34.04923], [-118.64991, 34.04831], [-118.65058, 34.04838], [-118.65108, 34.04823], [-118.65161, 34.04825], [-118.65227, 34.04848], [-118.65258, 34.04922]]]} | Unknown Access 4 | 46336 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 5.712 | 0 | Local Other or Unknown 14 | 4 | ||
4727 | 4727 | 4726 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.09732], [-118.50364, 34.09732], [-118.50363, 34.09721], [-118.50366, 34.09721], [-118.50367, 34.09732]]]} | Unknown Access 4 | 46347 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.009 | 0 | Local Other or Unknown 14 | 4 | ||
4728 | 4728 | 4727 | {"type": "Polygon", "coordinates": [[[-118.54246, 34.04096], [-118.54234, 34.04122], [-118.5418, 34.0411], [-118.54183, 34.04106], [-118.54202, 34.04093], [-118.54209, 34.04083], [-118.54246, 34.04096]]]} | Unknown Access 4 | 46350 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.365 | 0 | Local Other or Unknown 14 | 4 | ||
4729 | 4729 | 4728 | {"type": "Polygon", "coordinates": [[[-118.37521, 34.10697], [-118.37511, 34.107], [-118.37498, 34.10675], [-118.37508, 34.10672], [-118.37521, 34.10697]]]} | Unknown Access 4 | 46361 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.069 | 0 | Local Other or Unknown 14 | 4 | ||
4730 | 4730 | 4729 | {"type": "Polygon", "coordinates": [[[-118.37023, 34.10885], [-118.37007, 34.10885], [-118.37006, 34.10858], [-118.37022, 34.10857], [-118.37023, 34.10885]]]} | Unknown Access 4 | 46364 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.114 | 0 | Local Other or Unknown 14 | 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]);