units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 54 and DES_TP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6315 | 6315 | 6314 | {"type": "Polygon", "coordinates": [[[-117.86333, 33.59631], [-117.86331, 33.59648], [-117.86322, 33.59664], [-117.86301, 33.59672], [-117.8622, 33.59742], [-117.862, 33.5974], [-117.86195, 33.59745], [-117.86184, 33.59817], [-117.86171, 33.59828], [-117.86054, 33.59802], [-117.86026, 33.59798], [-117.85997, 33.59797], [-117.85969, 33.59799], [-117.85929, 33.59809], [-117.85902, 33.59821], [-117.85878, 33.59836], [-117.85858, 33.59854], [-117.85841, 33.59876], [-117.85829, 33.59899], [-117.85816, 33.5993], [-117.85804, 33.59964], [-117.85797, 33.6], [-117.8579, 33.60046], [-117.85785, 33.60065], [-117.85753, 33.60085], [-117.85708, 33.60101], [-117.8568, 33.60118], [-117.8566, 33.60138], [-117.85646, 33.60161], [-117.85571, 33.60347], [-117.85531, 33.60384], [-117.85515, 33.60418], [-117.85509, 33.60456], [-117.85498, 33.60455], [-117.85466, 33.60466], [-117.85427, 33.60512], [-117.85429, 33.60545], [-117.85432, 33.6056], [-117.8536, 33.60579], [-117.85335, 33.60584], [-117.85323, 33.6058], [-117.85308, 33.60582], [-117.85301, 33.60592], [-117.85262, 33.60599], [-117.85252, 33.60618], [-117.85207, 33.60608], [-117.85196, 33.60607], [-117.85151, 33.60622], [-117.85147, 33.60626], [-117.85146, 33.60623], [-117.8512, 33.60618], [-117.85119, 33.60616], [-117.85044, 33.606], [-117.85049, 33.60723], [-117.85047, 33.60728], [-117.85043, 33.6073], [-117.84976, 33.60737], [-117.84909, 33.60738], [-117.84843, 33.60733], [-117.84777, 33.60723], [-117.84512, 33.6066], [-117.84516, 33.60647], [-117.84502, 33.60636], [-117.84493, 33.60624], [-117.84472, 33.60583], [-117.84467, 33.60578], [-117.84459, 33.60574], [-117.84451, 33.60573], [-117.84443, 33.60575], [-117.84429, 33.60579], [-117.84411, 33.60589], [-117.84398, 33.60601], [-117.84397, 33.60618], [-117.84389, 33.6063], [-117.84318, 33.60614], [-117.84273, 33.60606], [-117.84273, 33.60594], [-117.84263, 33.60582], [-117.84242, 33.60576], [-117.84238, 33.60558], [-117.84232, 33.6055], [-117.84211, 33.60542], [-117.8416, 33.60541], [-117.84152, 33.60538], [-117.84139, 33.60529], [-117.84132, 33.60527], [-117.8412, 33.60528], [-117.84113, 33.60531], [-117.84084, 33.60551], [-117.84067, 33.60568], [-117.84054, 33.60575], [-117.84039, 33.60576], [-117.84029, 33.60573], [-117.83993, 33.60557], [-117.83967, 33.60539], [-117.83954, 33.60542], [-117.83942, 33.60564], [-117.8394, 33.60578], [-117.83941, 33.60594], [-117.83868, 33.60599], [-117.83795, 33.60609], [-117.83766, 33.60509], [-117.83684, 33.60506], [-117.83551, 33.60529], [-117.83537, 33.60568], [-117.83537, 33.60579], [-117.83523, 33.60576], [-117.83511, 33.60576], [-117.83482, 33.60584], [-117.83477, 33.60588], [-117.83458, 33.60583], [-117.83429, 33.60585], [-117.83385, 33.60603], [-117.83371, 33.60611], [-117.83355, 33.60636], [-117.83355, 33.60688], [-117.83359, 33.60704], [-117.83368, 33.60725], [-117.83373, 33.60751], [-117.83379, 33.60769], [-117.83335, 33.6079], [-117.83289, 33.60808], [-117.83218, 33.60831], [-117.83205, 33.60788], [-117.8321, 33.60755], [-117.83213, 33.60708], [-117.83212, 33.60695], [-117.83204, 33.60676], [-117.83195, 33.60665], [-117.83184, 33.60656], [-117.83171, 33.60649], [-117.83148, 33.60644], [-117.83128, 33.60643], [-117.83096, 33.60646], [-117.83074, 33.60623], [-117.83046, 33.60618], [-117.83021, 33.60581], [-117.82912, 33.60587], [-117.82852, 33.606], [-117.82813, 33.60577], [-117.82797, 33.60547], [-117.82803, 33.60521], [-117.82853, 33.60471], [-117.82896, 33.60501], [-117.83045, 33.60481], [-117.8308, 33.60484], [-117.83111, 33.60469], [-117.83219, 33.60489], [-117.83305, 33.60522], [-117.83409, 33.60471], [-117.83494, 33.604], [-117.83497, 33.60326], [-117.83459, 33.60296], [-117.83449, 33.60252], [-117.83459, 33.60233], [-117.83427, 33.60159], [-117.83416, 33.60148], [-117.83418, 33.60146], [-117.83445, 33.60161], [-117.83449, 33.60171], [-117.83459, 33.60179], [-117.83467, 33.60192], [-117.83482, 33.602], [-117.83489, 33.602], [-117.83493, 33.60201], [-117.83501, 33.60207], [-117.83514, 33.60221], [-117.8352, 33.60222], [-117.83559, 33.60213], [-117.83574, 33.60221], [-117.83586, 33.60243], [-117.83592, 33.6025], [-117.836, 33.60254], [-117.8362, 33.60262], [-117.83629, 33.60264], [-117.83647, 33.60265], [-117.83652, 33.60266], [-117.83655, 33.6027], [-117.83654, 33.60278], [-117.83659, 33.60283], [-117.83656, 33.60289], [-117.83646, 33.60298], [-117.83657, 33.60306], [-117.83659, 33.60312], [-117.83668, 33.6032], [-117.83693, 33.60309], [-117.83707, 33.60311], [-117.83745, 33.6031], [-117.83782, 33.60304], [-117.83821, 33.6029], [-117.83849, 33.60298], [-117.83849, 33.60304], [-117.83867, 33.60306], [-117.83869, 33.60299], [-117.83887, 33.60291], [-117.839, 33.60279], [-117.8403, 33.60307], [-117.8414, 33.60299], [-117.84173, 33.60255], [-117.84108, 33.60126], [-117.84079, 33.60099], [-117.84022, 33.601], [-117.84019, 33.60075], [-117.83968, 33.60044], [-117.83853, 33.60036], [-117.83858, 33.59984], [-117.8382, 33.5993], [-117.83822, 33.59921], [-117.838, 33.59902], [-117.83826, 33.59885], [-117.83826, 33.59848], [-117.83811, 33.59812], [-117.83856, 33.59785], [-117.83775, 33.59733], [-117.83782, 33.59708], [-117.83816, 33.59644], [-117.83733, 33.59575], [-117.83814, 33.59561], [-117.84057, 33.59836], [-117.84095, 33.59912], [-117.84207, 33.59924], [-117.84324, 33.59988], [-117.84293, 33.60052], [-117.84307, 33.60113], [-117.84356, 33.60152], [-117.84461, 33.60192], [-117.84643, 33.60227], [-117.8472, 33.60219], [-117.84809, 33.6035], [-117.85012, 33.60333], [-117.85103, 33.60263], [-117.85151, 33.60294], [-117.85268, 33.60294], [-117.85345, 33.60248], [-117.85391, 33.60229], [-117.85447, 33.60166], [-117.85477, 33.60109], [-117.85462, 33.60055], [-117.85405, 33.60038], [-117.85374, 33.60006], [-117.85507, 33.59976], [-117.85565, 33.59926], [-117.85591, 33.59886], [-117.85583, 33.5988], [-117.85631, 33.59819], [-117.86034, 33.59613], [-117.86035, 33.59616], [-117.86047, 33.59616], [-117.86052, 33.59612], [-117.86133, 33.59643], [-117.86231, 33.59614], [-117.86333, 33.59631]]]} | Open Access 1 | 47407 | Buck Gully Reserve | 31124 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 297.218 | Buck Gully Reserve | 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]);