units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 104, AGNCY_WEB = "http://www.sandiegocounty.gov/parks/" and MNG_AGENCY = 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 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]);