units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 526 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16562 | 16562 | 16561 | {"type": "Polygon", "coordinates": [[[-118.68988, 34.0683], [-118.68988, 34.06861], [-118.6898, 34.06857], [-118.68979, 34.06857], [-118.6898, 34.06859], [-118.68956, 34.0685], [-118.68902, 34.06837], [-118.689, 34.06726], [-118.68797, 34.06719], [-118.68796, 34.06733], [-118.68653, 34.06724], [-118.68653, 34.06684], [-118.68987, 34.06705], [-118.68988, 34.0683]]]} | No Public Access 3 | 12516 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 5.347 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16972 | 16972 | 16971 | {"type": "MultiPolygon", "coordinates": [[[[-118.67434, 34.03964], [-118.67429, 34.03977], [-118.67426, 34.03994], [-118.67425, 34.04043], [-118.67418, 34.04053], [-118.67404, 34.04067], [-118.67399, 34.04073], [-118.67394, 34.04093], [-118.67391, 34.04099], [-118.67372, 34.04118], [-118.67363, 34.04133], [-118.67354, 34.0416], [-118.67352, 34.04184], [-118.67346, 34.04201], [-118.6734, 34.04213], [-118.67323, 34.04235], [-118.6733, 34.04205], [-118.6733, 34.04199], [-118.67328, 34.04194], [-118.67375, 34.04068], [-118.67374, 34.04061], [-118.67368, 34.04054], [-118.67358, 34.0405], [-118.67252, 34.04064], [-118.67253, 34.04059], [-118.6735, 34.04045], [-118.67361, 34.04045], [-118.67371, 34.04048], [-118.67376, 34.04053], [-118.6738, 34.0406], [-118.67381, 34.04064], [-118.67382, 34.04065], [-118.67387, 34.04052], [-118.67402, 34.03978], [-118.67399, 34.03952], [-118.67425, 34.03936], [-118.67428, 34.03938], [-118.67432, 34.03946], [-118.67434, 34.03964]]], [[[-118.67508, 34.03923], [-118.6749, 34.04047], [-118.67444, 34.0432], [-118.67375, 34.04319], [-118.67367, 34.04274], [-118.67333, 34.04244], [-118.67355, 34.04212], [-118.67363, 34.04194], [-118.6742, 34.04205], [-118.67421, 34.04204], [-118.67431, 34.04138], [-118.67404, 34.04102], [-118.67408, 34.04094], [-118.67409, 34.04083], [-118.67413, 34.04074], [-118.67432, 34.04056], [-118.67438, 34.04045], [-118.67439, 34.03997], [-118.67448, 34.03958], [-118.67447, 34.03948], [-118.67442, 34.03937], [-118.67421, 34.03914], [-118.67418, 34.03908], [-118.67417, 34.03901], [-118.67421, 34.03884], [-118.6742, 34.03876], [-118.67416, 34.03867], [-118.67442, 34.03858], [-118.67464, 34.039], [-118.67508, 34.03923]]]]} | No Public Access 3 | 12520 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 9.545 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16520 | 16520 | 16519 | {"type": "Polygon", "coordinates": [[[-118.64775, 34.04924], [-118.64555, 34.04925], [-118.64555, 34.04925], [-118.64573, 34.0491], [-118.64588, 34.04894], [-118.64619, 34.04853], [-118.64631, 34.04842], [-118.64645, 34.04834], [-118.64775, 34.04924]]]} | No Public Access 3 | 12521 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 2.56 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16954 | 16954 | 16953 | {"type": "Polygon", "coordinates": [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]]} | No Public Access 3 | 12522 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.35 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
15805 | 15805 | 15804 | {"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]} | No Public Access 3 | 12523 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.266 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
15852 | 15852 | 15851 | {"type": "Polygon", "coordinates": [[[-118.65341, 34.04402], [-118.65239, 34.04383], [-118.65222, 34.04364], [-118.65222, 34.04358], [-118.65237, 34.0435], [-118.65252, 34.04337], [-118.65338, 34.04326], [-118.65341, 34.04402]]]} | Open Access 1 | 12524 | Mountains Restoration Trust Parkland | 22563 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.603 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
4129 | 4129 | 4128 | {"type": "Polygon", "coordinates": [[[-118.5962, 34.10228], [-118.59481, 34.10227], [-118.59481, 34.10169], [-118.59619, 34.1017], [-118.5962, 34.10228]]]} | No Public Access 3 | 12686 | Topanga Open Space | 29663 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 2.028 | Topanga OS | 0 | Private Recreation or Education 65 | 4 | |
12491 | 12491 | 12490 | {"type": "Polygon", "coordinates": [[[-118.59323, 34.10829], [-118.59283, 34.10826], [-118.59281, 34.10794], [-118.59295, 34.10796], [-118.59321, 34.10791], [-118.59323, 34.10829]]]} | No Public Access 3 | 12687 | Topanga Open Space | 29663 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.339 | Topanga OS | 0 | Private Recreation or Education 65 | 4 | |
4431 | 4431 | 4430 | {"type": "MultiPolygon", "coordinates": [[[[-118.65895, 34.08613], [-118.65894, 34.08891], [-118.65009, 34.08891], [-118.65013, 34.09267], [-118.64117, 34.09265], [-118.64112, 34.09636], [-118.64111, 34.09994], [-118.63052, 34.09992], [-118.62926, 34.09988], [-118.62816, 34.09988], [-118.62819, 34.09631], [-118.62815, 34.09264], [-118.63248, 34.09264], [-118.63251, 34.08892], [-118.64121, 34.08892], [-118.64122, 34.08788], [-118.63688, 34.0879], [-118.6369, 34.08542], [-118.64124, 34.08543], [-118.64125, 34.08199], [-118.65002, 34.08185], [-118.65002, 34.08278], [-118.65026, 34.08326], [-118.65034, 34.08338], [-118.65043, 34.08347], [-118.65061, 34.08358], [-118.65073, 34.08363], [-118.65125, 34.08371], [-118.65141, 34.08375], [-118.65157, 34.08382], [-118.65174, 34.08393], [-118.65177, 34.08397], [-118.65177, 34.084], [-118.65173, 34.08403], [-118.65147, 34.08398], [-118.65125, 34.08398], [-118.65108, 34.08401], [-118.65087, 34.08407], [-118.65078, 34.08408], [-118.6502, 34.08391], [-118.65004, 34.0839], [-118.65004, 34.08403], [-118.65016, 34.08405], [-118.65074, 34.08421], [-118.6509, 34.08421], [-118.65117, 34.08413], [-118.65131, 34.08411], [-118.65152, 34.08412], [-118.65166, 34.08415], [-118.65181, 34.08423], [-118.6519, 34.08432], [-118.65199, 34.08438], [-118.65212, 34.08442], [-118.65218, 34.08441], [-118.65268, 34.085], [-118.65282, 34.08511], [-118.65291, 34.08517], [-118.65317, 34.08528], [-118.65342, 34.08534], [-118.65366, 34.08535], [-118.65389, 34.08533], [-118.65408, 34.08528], [-118.65459, 34.08512], [-118.65496, 34.08505], [-118.65517, 34.08505], [-118.65535, 34.08509], [-118.65551, 34.0851], [-118.6557, 34.08507], [-118.65583, 34.08504], [-118.65648, 34.08502], [-118.65661, 34.08504], [-118.65672, 34.08507], [-118.65682, 34.08512], [-118.65691, 34.08519], [-118.657, 34.08532], [-118.657, 34.08535], [-118.65714, 34.08566], [-118.65709, 34.08574], [-118.65707, 34.08581], [-118.65706, 34.08589], [-118.65709, 34.086], [-118.65717, 34.08614], [-118.65726, 34.08621], [-118.65736, 34.08627], [-118.6575, 34.0863], [-118.65819, 34.08629], [-118.65847, 34.08625], [-118.65895, 34.08613]], [[-118.63535, 34.09172], [-118.63533, 34.09228], [-118.63659, 34.09228], [-118.6366, 34.09173], [-118.63535, 34.09172]], [[-118.64119, 34.09077], [-118.64118, 34.09076], [-118.63685, 34.09076], [-118.63683, 34.09263], [-118.64116, 34.09264], [-118.64119, 34.09077]], [[-118.63907, 34.08667], [-118.63906, 34.08666], [-118.63863, 34.08667], [-118.63863, 34.08688], [-118.63905, 34.08689], [-118.63907, 34.08667]], [[-118.63905, 34.08915], [-118.63905, 34.08937], [-118.63947, 34.08936], [-118.63946, 34.08914], [-118.63905, 34.08915]], [[-118.63934, 34.08713], [-118.6396, 34.08714], [-118.63961, 34.08679], [-118.63934, 34.08679], [-118.63934, 34.08713]], [[-118.63954, 34.08989], [-118.63954, 34.09005], [-118.63981, 34.09006], [-118.63982, 34.08973], [-118.63954, 34.08973], [-118.63954, 34.08989]]], [[[-118.65751, 34.08613], [-118.65745, 34.08612], [-118.65733, 34.08604], [-118.65728, 34.08597], [-118.65727, 34.0859], [-118.65734, 34.086], [-118.65751, 34.08613]]]]} | Restricted Access 2 | 46378 | Cold Creek Canyon Preserve | 17482 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 651.85 | Cold Creek Canyon Preserve | 0 | Private Conservation 16 | 2 | |
15290 | 15290 | 15289 | {"type": "Polygon", "coordinates": [[[-118.68355, 34.08327], [-118.68281, 34.08348], [-118.68266, 34.08354], [-118.68252, 34.08363], [-118.68239, 34.08374], [-118.68233, 34.08382], [-118.68227, 34.08395], [-118.68224, 34.08408], [-118.68224, 34.08427], [-118.68227, 34.08436], [-118.68227, 34.08455], [-118.68221, 34.08467], [-118.68215, 34.08475], [-118.68199, 34.08489], [-118.6819, 34.08505], [-118.68187, 34.08517], [-118.68187, 34.08541], [-118.68181, 34.08557], [-118.68174, 34.08565], [-118.68131, 34.08597], [-118.68121, 34.0861], [-118.68114, 34.08625], [-118.68112, 34.08636], [-118.68112, 34.08647], [-118.6811, 34.08655], [-118.68106, 34.08663], [-118.68061, 34.0871], [-118.68052, 34.08722], [-118.68045, 34.08737], [-118.68041, 34.08754], [-118.6804, 34.08858], [-118.68043, 34.08877], [-118.68052, 34.08893], [-118.68056, 34.08904], [-118.68064, 34.08973], [-118.68061, 34.0898], [-118.68054, 34.08991], [-118.68037, 34.09002], [-118.68028, 34.0901], [-118.68019, 34.09026], [-118.68017, 34.09038], [-118.68021, 34.09111], [-118.6802, 34.09118], [-118.68016, 34.09127], [-118.6799, 34.0916], [-118.67985, 34.09171], [-118.67981, 34.09183], [-118.67969, 34.09248], [-118.67966, 34.09258], [-118.67633, 34.09259], [-118.67632, 34.0948], [-118.67424, 34.09498], [-118.67355, 34.09552], [-118.67229, 34.09563], [-118.6716, 34.09647], [-118.67144, 34.0974], [-118.67055, 34.0975], [-118.67084, 34.0967], [-118.67027, 34.09597], [-118.67106, 34.09562], [-118.67124, 34.0953], [-118.67167, 34.09519], [-118.67167, 34.0948], [-118.67233, 34.09472], [-118.67236, 34.09258], [-118.67632, 34.09258], [-118.67632, 34.08531], [-118.68051, 34.08531], [-118.68052, 34.08326], [-118.68355, 34.08327]]]} | Open Access 1 | 46412 | Cold Creek Canyon Preserve | 7257 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 119.332 | Cold Creek Canyon Preserve | None 1350 |
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]);