units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where DES_TP = 4, LABEL_NAME = "Upper Newport Bay Nature Preserve" and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2737 | 2737 | 2736 | {"type": "MultiPolygon", "coordinates": [[[[-117.88993, 33.65132], [-117.88915, 33.65163], [-117.88901, 33.65178], [-117.88892, 33.65213], [-117.88878, 33.6524], [-117.88858, 33.6525], [-117.88842, 33.65252], [-117.88878, 33.65161], [-117.88869, 33.65158], [-117.88957, 33.65102], [-117.88975, 33.65122], [-117.88993, 33.65132]]], [[[-117.89068, 33.65184], [-117.89057, 33.65202], [-117.89045, 33.65216], [-117.88972, 33.6529], [-117.88932, 33.65262], [-117.88889, 33.65246], [-117.88867, 33.65249], [-117.88881, 33.65241], [-117.88895, 33.65214], [-117.88904, 33.65178], [-117.88917, 33.65166], [-117.88993, 33.65135], [-117.88998, 33.65135], [-117.89031, 33.65154], [-117.89043, 33.65169], [-117.89061, 33.65181], [-117.89068, 33.65184]]]]} | Open Access 1 | 18389 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.762 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10400 | 10400 | 10399 | {"type": "Polygon", "coordinates": [[[-117.88536, 33.64086], [-117.88519, 33.64097], [-117.88485, 33.64127], [-117.88427, 33.64172], [-117.88345, 33.64241], [-117.88291, 33.64282], [-117.88256, 33.64313], [-117.88233, 33.6434], [-117.88221, 33.64362], [-117.8821, 33.64402], [-117.88208, 33.64435], [-117.88216, 33.64517], [-117.88212, 33.64546], [-117.88197, 33.64574], [-117.88185, 33.64587], [-117.88177, 33.64595], [-117.88137, 33.6462], [-117.8809, 33.64632], [-117.87895, 33.64644], [-117.87853, 33.64644], [-117.87817, 33.64626], [-117.87799, 33.64614], [-117.87779, 33.64607], [-117.87661, 33.6457], [-117.87624, 33.64562], [-117.87588, 33.64556], [-117.87472, 33.64547], [-117.87401, 33.64551], [-117.87283, 33.64533], [-117.87265, 33.64533], [-117.87246, 33.64535], [-117.87244, 33.64534], [-117.87177, 33.64537], [-117.87116, 33.64511], [-117.87158, 33.6452], [-117.87178, 33.64521], [-117.87191, 33.6452], [-117.87256, 33.64508], [-117.87274, 33.64508], [-117.87339, 33.64517], [-117.87432, 33.64536], [-117.87441, 33.64536], [-117.87465, 33.64531], [-117.87484, 33.6453], [-117.87506, 33.64535], [-117.87571, 33.64536], [-117.87589, 33.64537], [-117.87689, 33.64562], [-117.87736, 33.64565], [-117.87757, 33.64569], [-117.87787, 33.64588], [-117.87801, 33.64593], [-117.87842, 33.64602], [-117.87878, 33.64602], [-117.8813, 33.64536], [-117.88168, 33.64514], [-117.88189, 33.64483], [-117.88195, 33.64456], [-117.88204, 33.64288], [-117.88185, 33.64287], [-117.88185, 33.64279], [-117.88204, 33.64279], [-117.88209, 33.64277], [-117.88232, 33.64202], [-117.88236, 33.64196], [-117.88288, 33.64139], [-117.88295, 33.64145], [-117.88319, 33.6413], [-117.88345, 33.64116], [-117.88358, 33.64112], [-117.8842, 33.64098], [-117.88536, 33.64086]]]} | Open Access 1 | 18395 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 18.576 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-117.87426, 33.65171], [-117.87411, 33.65186], [-117.87368, 33.65165], [-117.87349, 33.65159], [-117.87309, 33.65154], [-117.87287, 33.65155], [-117.87262, 33.6516], [-117.87254, 33.65162], [-117.87253, 33.65194], [-117.87219, 33.65186], [-117.87188, 33.65195], [-117.87143, 33.65239], [-117.87108, 33.65252], [-117.87085, 33.65215], [-117.87074, 33.65219], [-117.8706, 33.65196], [-117.8698, 33.65217], [-117.87, 33.65204], [-117.87103, 33.65164], [-117.87218, 33.65124], [-117.8725, 33.65115], [-117.87249, 33.6511], [-117.87303, 33.65086], [-117.87426, 33.65171]]]} | Open Access 1 | 18396 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.536 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10404 | 10404 | 10403 | {"type": "Polygon", "coordinates": [[[-117.87074, 33.65219], [-117.87051, 33.65232], [-117.87072, 33.65266], [-117.86908, 33.6533], [-117.86899, 33.65299], [-117.86823, 33.65312], [-117.86746, 33.65307], [-117.86756, 33.65296], [-117.86713, 33.65287], [-117.86698, 33.65266], [-117.86703, 33.65232], [-117.86752, 33.65236], [-117.86794, 33.65237], [-117.86852, 33.65235], [-117.86896, 33.65231], [-117.8698, 33.65217], [-117.87037, 33.65203], [-117.8706, 33.65196], [-117.87074, 33.65219]]]} | Open Access 1 | 18397 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.01 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10405 | 10405 | 10404 | {"type": "Polygon", "coordinates": [[[-117.8834, 33.65287], [-117.88279, 33.65322], [-117.88239, 33.6535], [-117.88162, 33.65407], [-117.88134, 33.65422], [-117.88214, 33.65355], [-117.88214, 33.65353], [-117.8818, 33.65332], [-117.88142, 33.65315], [-117.88102, 33.65301], [-117.8796, 33.65272], [-117.87919, 33.65258], [-117.87899, 33.65248], [-117.87849, 33.65219], [-117.87799, 33.65203], [-117.87759, 33.65187], [-117.87644, 33.65108], [-117.87585, 33.65094], [-117.87545, 33.65088], [-117.87483, 33.65085], [-117.8742, 33.65087], [-117.87418, 33.65155], [-117.87412, 33.65161], [-117.87303, 33.65086], [-117.87424, 33.65054], [-117.87548, 33.65047], [-117.87553, 33.65046], [-117.87556, 33.65047], [-117.87636, 33.65059], [-117.87714, 33.65077], [-117.87817, 33.65111], [-117.87883, 33.65136], [-117.87933, 33.65162], [-117.87978, 33.65172], [-117.88007, 33.65181], [-117.88053, 33.65186], [-117.8834, 33.65287]]]} | Open Access 1 | 18398 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 19.731 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-117.88675, 33.63629], [-117.88676, 33.63671], [-117.88656, 33.63756], [-117.88651, 33.63789], [-117.88644, 33.63864], [-117.88628, 33.63944], [-117.88624, 33.64024], [-117.88617, 33.64049], [-117.88615, 33.64054], [-117.88604, 33.64067], [-117.88588, 33.64072], [-117.88507, 33.64081], [-117.88518, 33.64074], [-117.88577, 33.64058], [-117.88601, 33.64014], [-117.88595, 33.63961], [-117.88605, 33.63868], [-117.8862, 33.638], [-117.88625, 33.63711], [-117.88644, 33.63657], [-117.88657, 33.63646], [-117.88649, 33.63611], [-117.88598, 33.63572], [-117.88576, 33.63561], [-117.88532, 33.63466], [-117.88467, 33.63416], [-117.88461, 33.63407], [-117.88479, 33.63397], [-117.88534, 33.63446], [-117.88542, 33.63454], [-117.88552, 33.63478], [-117.88576, 33.63522], [-117.88604, 33.63554], [-117.88649, 33.63592], [-117.88675, 33.63629]]]} | Open Access 1 | 18399 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.179 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10407 | 10407 | 10406 | {"type": "Polygon", "coordinates": [[[-117.8934, 33.64575], [-117.89286, 33.64631], [-117.89283, 33.64533], [-117.89242, 33.64479], [-117.89224, 33.64469], [-117.89142, 33.64576], [-117.89221, 33.64468], [-117.892, 33.64456], [-117.89199, 33.64287], [-117.89123, 33.64185], [-117.89134, 33.64175], [-117.89186, 33.64225], [-117.89251, 33.64306], [-117.89296, 33.64373], [-117.89312, 33.64423], [-117.89324, 33.64457], [-117.89335, 33.64553], [-117.8934, 33.64575]]]} | Open Access 1 | 18400 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.201 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10409 | 10409 | 10408 | {"type": "Polygon", "coordinates": [[[-117.8945, 33.64271], [-117.89399, 33.64322], [-117.89392, 33.64333], [-117.89379, 33.64355], [-117.89373, 33.64375], [-117.89371, 33.64388], [-117.89372, 33.6441], [-117.8938, 33.64442], [-117.89385, 33.64455], [-117.8939, 33.64478], [-117.89389, 33.64513], [-117.89384, 33.64535], [-117.89379, 33.64547], [-117.89367, 33.64567], [-117.89359, 33.64578], [-117.89251, 33.64687], [-117.89238, 33.64703], [-117.89231, 33.64717], [-117.89224, 33.64738], [-117.89224, 33.64756], [-117.89226, 33.6477], [-117.8923, 33.64784], [-117.89244, 33.64813], [-117.89249, 33.64839], [-117.89248, 33.64875], [-117.89241, 33.64901], [-117.89223, 33.64934], [-117.89157, 33.65003], [-117.89146, 33.65016], [-117.89132, 33.6504], [-117.89119, 33.6507], [-117.89101, 33.65145], [-117.89086, 33.65185], [-117.89068, 33.65213], [-117.89053, 33.65231], [-117.88773, 33.65511], [-117.8874, 33.65553], [-117.8871, 33.65583], [-117.88433, 33.6539], [-117.88384, 33.65362], [-117.88331, 33.65339], [-117.88314, 33.65333], [-117.8833, 33.65323], [-117.88392, 33.65293], [-117.88473, 33.65264], [-117.88618, 33.65226], [-117.88784, 33.65191], [-117.88811, 33.65188], [-117.88869, 33.65158], [-117.88878, 33.65161], [-117.88842, 33.65251], [-117.88843, 33.65252], [-117.88858, 33.6525], [-117.88878, 33.6524], [-117.88892, 33.65213], [-117.88901, 33.65178], [-117.88915, 33.65163], [-117.88993, 33.65133], [-117.88998, 33.65135], [-117.88993, 33.65135], [-117.88917, 33.65166], [-117.88904, 33.65178], [-117.88895, 33.65214], [-117.88881, 33.65242], [-117.88872, 33.65247], [-117.88873, 33.65248], [-117.88889, 33.65246], [-117.88932, 33.65262], [-117.88973, 33.65289], [-117.89045, 33.65216], [-117.89057, 33.65202], [-117.89068, 33.65184], [-117.89043, 33.65169], [-117.8901, 33.6513], [-117.88975, 33.65122], [-117.88957, 33.65102], [-117.88978, 33.65087], [-117.8898, 33.65087], [-117.89017, 33.65045], [-117.89054, 33.64966], [-117.89062, 33.64945], [-117.89083, 33.64873], [-117.89091, 33.64809], [-117.89093, 33.64785], [-117.89089, 33.64759], [-117.89084, 33.64753], [-117.89083, 33.64719], [-117.89089, 33.64677], [-117.89113, 33.64628], [-117.89142, 33.64576], [-117.89224, 33.64469], [-117.89242, 33.64479], [-117.89283, 33.64534], [-117.89283, 33.64575], [-117.89286, 33.64629], [-117.89319, 33.64598], [-117.8934, 33.64575], [-117.89335, 33.64553], [-117.89324, 33.64457], [-117.89312, 33.64423], [-117.89296, 33.64373], [-117.89251, 33.64306], [-117.89186, 33.64225], [-117.89135, 33.64175], [-117.89166, 33.64148], [-117.89184, 33.64155], [-117.89228, 33.64157], [-117.89231, 33.64166], [-117.89249, 33.6416], [-117.89262, 33.6415], [-117.89268, 33.64144], [-117.8945, 33.64271]]]} | Open Access 1 | 18405 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 71.487 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 |
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]);