units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3 and AGNCY_NAME = 883
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7957 | 7957 | 7956 | {"type": "MultiPolygon", "coordinates": [[[[-117.26235, 32.97049], [-117.26211, 32.97088], [-117.26009, 32.96991], [-117.25848, 32.97116], [-117.25599, 32.97118], [-117.25596, 32.9703], [-117.25172, 32.97117], [-117.25111, 32.97119], [-117.25033, 32.97051], [-117.24968, 32.96839], [-117.24944, 32.96746], [-117.25596, 32.96753], [-117.25598, 32.96812], [-117.25807, 32.96814], [-117.25841, 32.96814], [-117.25888, 32.96806], [-117.25973, 32.9678], [-117.26055, 32.96864], [-117.26088, 32.96904], [-117.26112, 32.96943], [-117.26155, 32.96979], [-117.26146, 32.9699], [-117.26137, 32.96987], [-117.26132, 32.96997], [-117.26152, 32.9701], [-117.26186, 32.97027], [-117.26235, 32.97049]]], [[[-117.24735, 32.97286], [-117.24305, 32.97281], [-117.24305, 32.97158], [-117.24317, 32.97158], [-117.24315, 32.97208], [-117.24328, 32.97225], [-117.24361, 32.97234], [-117.24382, 32.97234], [-117.24398, 32.97218], [-117.24405, 32.97187], [-117.24405, 32.97166], [-117.24394, 32.97137], [-117.24371, 32.97114], [-117.2437, 32.97056], [-117.2445, 32.96992], [-117.24637, 32.96993], [-117.24591, 32.96921], [-117.24734, 32.96922], [-117.24734, 32.97169], [-117.24735, 32.97286]]], [[[-117.2474, 32.97836], [-117.24168, 32.97829], [-117.24007, 32.97858], [-117.23873, 32.97897], [-117.23872, 32.9777], [-117.23589, 32.97769], [-117.23589, 32.97824], [-117.23054, 32.97821], [-117.23052, 32.97748], [-117.23055, 32.9772], [-117.23063, 32.97688], [-117.23075, 32.97656], [-117.23089, 32.97626], [-117.23099, 32.97611], [-117.23119, 32.97583], [-117.23144, 32.97557], [-117.2317, 32.97533], [-117.23211, 32.97505], [-117.23268, 32.97477], [-117.23304, 32.97465], [-117.2334, 32.97456], [-117.23688, 32.97409], [-117.23729, 32.97401], [-117.23762, 32.97391], [-117.23784, 32.97383], [-117.2382, 32.97365], [-117.23858, 32.9734], [-117.23889, 32.97314], [-117.23904, 32.97297], [-117.2392, 32.97277], [-117.23934, 32.97257], [-117.23948, 32.97231], [-117.23958, 32.97204], [-117.23966, 32.97176], [-117.24045, 32.97176], [-117.24045, 32.97462], [-117.24175, 32.97464], [-117.24175, 32.9743], [-117.24287, 32.97407], [-117.24306, 32.97398], [-117.24305, 32.97482], [-117.24306, 32.97483], [-117.24737, 32.97395], [-117.2474, 32.97836]]], [[[-117.12723, 33.03666], [-117.1267, 33.03665], [-117.1267, 33.03659], [-117.12721, 33.03658], [-117.12723, 33.03666]]], [[[-117.13947, 33.04016], [-117.13513, 33.04016], [-117.13512, 33.04084], [-117.13399, 33.04103], [-117.13276, 33.0414], [-117.13197, 33.0423], [-117.13159, 33.04282], [-117.13122, 33.04321], [-117.13101, 33.04348], [-117.13078, 33.04382], [-117.12669, 33.04383], [-117.12669, 33.03929], [-117.13097, 33.0393], [-117.13098, 33.03878], [-117.13276, 33.03877], [-117.13276, 33.03653], [-117.13453, 33.03651], [-117.13946, 33.03649], [-117.13947, 33.04016]]], [[[-117.0431, 33.0404], [-117.04234, 33.04173], [-117.04209, 33.04158], [-117.04186, 33.04141], [-117.04138, 33.0416], [-117.04066, 33.04105], [-117.04019, 33.04144], [-117.04051, 33.04183], [-117.04078, 33.04227], [-117.04082, 33.04235], [-117.04078, 33.04269], [-117.04076, 33.04278], [-117.04079, 33.04288], [-117.04083, 33.0429], [-117.04157, 33.04309], [-117.04105, 33.04401], [-117.03222, 33.04407], [-117.03187, 33.03647], [-117.03625, 33.0365], [-117.03626, 33.03787], [-117.03772, 33.03788], [-117.03774, 33.03944], [-117.03736, 33.03944], [-117.03735, 33.03946], [-117.03746, 33.03948], [-117.0376, 33.03953], [-117.03769, 33.03958], [-117.03771, 33.03962], [-117.03777, 33.03965], [-117.03823, 33.03999], [-117.03825, 33.04003], [-117.03828, 33.04003], [-117.03872, 33.04036], [-117.03891, 33.04044], [-117.03915, 33.04002], [-117.03915, 33.03946], [-117.04057, 33.03948], [-117.04058, 33.04037], [-117.0431, 33.0404]], [[-117.03526, 33.04034], [-117.03408, 33.04031], [-117.03407, 33.0424], [-117.03523, 33.04239], [-117.03526, 33.04034]], [[-117.04019, 33.04144], [-117.04003, 33.04122], [-117.03946, 33.0408], [-117.0386, 33.04165], [-117.03827, 33.042], [-117.03952, 33.04203], [-117.04001, 33.04161], [-117.04019, 33.04144]]], [[[-117.03205, 33.04178], [-117.02982, 33.0424], [-117.02925, 33.04297], [-117.02937, 33.04402], [-117.02816, 33.04403], [-117.02819, 33.04383], [-117.02815, 33.04362], [-117.02825, 33.04325], [-117.02852, 33.0431], [-117.02857, 33.04285], [-117.02888, 33.0425], [-117.02865, 33.04161], [-117.02863, 33.04105], [-117.02873, 33.04095], [-117.02876, 33.04048], [-117.02901, 33.03959], [-117.02902, 33.03946], [-117.02898, 33.03928], [-117.02916, 33.03901], [-117.02917, 33.03852], [-117.02989, 33.03839], [-117.03039, 33.03864], [-117.03073, 33.0387], [-117.03191, 33.03867], [-117.03205, 33.04178]]], [[[-116.96257, 33.06565], [-116.95798, 33.06557], [-116.95791, 33.06161], [-116.96238, 33.06154], [-116.96257, 33.06565]]], [[[-117.08807, 33.07148], [-117.08733, 33.07483], [-117.08719, 33.07507], [-117.08712, 33.07514], [-117.08674, 33.07532], [-117.08707, 33.07476], [-117.08715, 33.07449], [-117.08715, 33.0743], [-117.08712, 33.07423], [-117.08682, 33.07349], [-117.0868, 33.07337], [-117.08681, 33.07317], [-117.08687, 33.07304], [-117.08698, 33.07287], [-117.0871, 33.07278], [-117.08712, 33.0728], [-117.08726, 33.07272], [-117.08724, 33.07269], [-117.08738, 33.07195], [-117.08607, 33.0716], [-117.08608, 33.07132], [-117.08807, 33.07148]]], [[[-117.01587, 33.10181], [-117.00721, 33.10173], [-117.00723, 33.09846], [-117.01352, 33.09829], [-117.01389, 33.09866], [-117.01411, 33.09881], [-117.01437, 33.09892], [-117.01466, 33.09898], [-117.01494, 33.09899], [-117.01505, 33.09902], [-117.01527, 33.09906], [-117.01554, 33.09906], [-117.01564, 33.09904], [-117.01586, 33.09905], [-117.01585, 33.09912], [-117.01587, 33.10181]]], [[[-116.74109, 33.1079], [-116.74108, 33.10916], [-116.73672, 33.10922], [-116.73671, 33.10849], [-116.739, 33.10849], [-116.73919, 33.10866], [-116.73938, 33.10856], [-116.73993, 33.10789], [-116.74109, 33.1079]]], [[[-116.60366, 33.11132], [-116.60366, 33.11148], [-116.60362, 33.11165], [-116.60351, 33.11184], [-116.60341, 33.11194], [-116.60332, 33.112], [-116.6032, 33.11203], [-116.60284, 33.11208], [-116.60256, 33.11216], [-116.60257, 33.10898], [-116.60291, 33.1097], [-116.60295, 33.10986], [-116.60299, 33.11018], [-116.60304, 33.11034], [-116.60329, 33.11073], [-116.60356, 33.11107], [-116.60364, 33.11122], [-116.60366, 33.11132]]], [[[-116.61024, 33.11223], [-116.60655, 33.11585], [-116.60292, 33.11583], [-116.60304, 33.1155], [-116.60306, 33.11537], [-116.60306, 33.11514], [-116.60273, 33.11376], [-116.60264, 33.11354], [-116.60255, 33.11339], [-116.60216, 33.11299], [-116.6021, 33.11295], [-116.60206, 33.11289], [-116.60201, 33.11275], [-116.60204, 33.11268], [-116.60214, 33.11256], [-116.60234, 33.11244], [-116.60259, 33.11233], [-116.60271, 33.11228], [-116.60296, 33.11222], [-116.60328, 33.11219], [-116.60345, 33.11212], [-116.60351, 33.11209], [-116.60365, 33.11196], [-116.60378, 33.11176], [-116.60385, 33.11152], [-116.60385, 33.11129], [-116.60381, 33.11113], [-116.60375, 33.11101], [-116.6034, 33.11055], [-116.60321, 33.11025], [-116.60315, 33.10998], [-116.60314, 33.10982], [-116.6031, 33.10966], [-116.603, 33.10943], [-116.60286, 33.10916], [-116.60263, 33.10865], [-116.6069, 33.10865], [-116.60691, 33.11222], [-116.61024, 33.11223]]], [[[-116.77148, 33.11263], [-116.76714, 33.11269], [-116.76717, 33.12036], [-116.76283, 33.12035], [-116.76285, 33.1242], [-116.74993, 33.12419], [-116.74983, 33.11661], [-116.7628, 33.1166], [-116.76278, 33.11275], [-116.76713, 33.11269], [-116.76713, 33.11085], [-116.77147, 33.11083], [-116.77148, 33.11263]]], [[[-116.56364, 33.11825], [-116.55962, 33.1184], [-116.55967, 33.12184], [-116.55915, 33.12187], [-116.55924, 33.12381], [-116.55473, 33.12403], [-116.55462, 33.12208], [-116.55564, 33.12202], [-116.55545, 33.1078], [-116.55541, 33.10779], [-116.55544, 33.10415], [-116.55533, 33.10051], [-116.55939, 33.10043], [-116.5595, 33.10399], [-116.56342, 33.10381], [-116.56349, 33.10731], [-116.56364, 33.11825]]], [[[-116.71987, 33.10558], [-116.72399, 33.10562], [-116.72398, 33.10933], [-116.7282, 33.10929], [-116.72829, 33.11298], [-116.73253, 33.11295], [-116.73266, 33.11669], [-116.72837, 33.11669], [-116.72845, 33.12039], [-116.73275, 33.1204], [-116.73282, 33.12416], [-116.72863, 33.12404], [-116.71994, 33.12392], [-116.71989, 33.12778], [-116.71994, 33.13029], [-116.71894, 33.12855], [-116.71794, 33.12675], [-116.71666, 33.12415], [-116.71148, 33.11444], [-116.71153, 33.11315], [-116.71147, 33.11126], [-116.71146, 33.10951], [-116.7114, 33.10578], [-116.71987, 33.10558]], [[-116.71786, 33.11216], [-116.7199, 33.11215], [-116.7199, 33.1112], [-116.71568, 33.11125], [-116.7157, 33.11216], [-116.71786, 33.11216]]], [[[-116.59542, 33.15573], [-116.58232, 33.15643], [-116.58105, 33.15221], [-116.58537, 33.15193], [-116.58535, 33.14991], [-116.58968, 33.14953], [-116.5897, 33.15165], [-116.59408, 33.15137], [-116.59542, 33.15573]]]]} | No Public Access 3 | 10844 | San Dieguito River Park | 24869 | 2134 | San Dieguito River Park Joint Powers Authority 883 | Special District 4 | Open Space District 6 | http://www.sdrp.org/ | Special District 4 | 2134 | San Dieguito River Park Joint Powers Authority 859 | Special District 4 | Open Space District 6 | San Diego 4 | 2520.958 | San Dieguito River 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]);