units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "861.224" and MNG_AGENCY = 164
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16320 | 16320 | 16319 | {"type": "Polygon", "coordinates": [[[-117.48255, 34.04201], [-117.48225, 34.04222], [-117.48102, 34.04261], [-117.47982, 34.04316], [-117.47905, 34.04381], [-117.47778, 34.04344], [-117.47681, 34.04324], [-117.47581, 34.04327], [-117.47538, 34.04332], [-117.47494, 34.04325], [-117.47451, 34.04313], [-117.47409, 34.0428], [-117.47362, 34.0425], [-117.47313, 34.04233], [-117.47285, 34.04225], [-117.47216, 34.04102], [-117.47198, 34.04055], [-117.47174, 34.0404], [-117.4712, 34.04016], [-117.471, 34.04003], [-117.47077, 34.03945], [-117.47026, 34.03901], [-117.4703, 34.03866], [-117.46954, 34.03806], [-117.46915, 34.03767], [-117.46892, 34.03693], [-117.46877, 34.03619], [-117.46849, 34.03524], [-117.4681, 34.03473], [-117.46774, 34.03438], [-117.46693, 34.03431], [-117.46589, 34.0341], [-117.465, 34.03401], [-117.46449, 34.03408], [-117.46349, 34.03413], [-117.46298, 34.03426], [-117.46255, 34.03475], [-117.4622, 34.03531], [-117.46186, 34.0359], [-117.46144, 34.03655], [-117.4611, 34.03679], [-117.46042, 34.03706], [-117.46053, 34.03875], [-117.461, 34.03915], [-117.46069, 34.03968], [-117.4602, 34.04037], [-117.45983, 34.04078], [-117.45929, 34.04119], [-117.45821, 34.04189], [-117.45778, 34.04236], [-117.45755, 34.04282], [-117.45721, 34.04315], [-117.45681, 34.04339], [-117.45624, 34.04361], [-117.45517, 34.04357], [-117.45481, 34.04373], [-117.45437, 34.04395], [-117.45406, 34.04424], [-117.45384, 34.0446], [-117.45346, 34.04448], [-117.45248, 34.04446], [-117.45211, 34.04436], [-117.45105, 34.04373], [-117.45076, 34.04367], [-117.45047, 34.04366], [-117.45007, 34.04373], [-117.44967, 34.04397], [-117.44939, 34.04421], [-117.44915, 34.0443], [-117.44626, 34.04438], [-117.44575, 34.04436], [-117.4452, 34.04441], [-117.44469, 34.04458], [-117.44449, 34.04487], [-117.44435, 34.04523], [-117.44441, 34.04565], [-117.44441, 34.04616], [-117.44424, 34.047], [-117.43576, 34.04703], [-117.43563, 34.0429], [-117.43555, 34.04242], [-117.43534, 34.0418], [-117.43514, 34.04135], [-117.43285, 34.0414], [-117.4328, 34.04255], [-117.43162, 34.04265], [-117.43099, 34.04284], [-117.42979, 34.04289], [-117.42944, 34.04308], [-117.42927, 34.04347], [-117.43019, 34.04396], [-117.42926, 34.04583], [-117.42886, 34.04633], [-117.42826, 34.04719], [-117.42697, 34.04716], [-117.42683, 34.04376], [-117.42864, 34.04375], [-117.4286, 34.04227], [-117.4315, 34.04222], [-117.43147, 34.04115], [-117.43504, 34.04106], [-117.43478, 34.04044], [-117.43453, 34.03963], [-117.4344, 34.03911], [-117.45379, 34.03462], [-117.45379, 34.03362], [-117.46445, 34.0336], [-117.47876, 34.03362], [-117.47768, 34.03443], [-117.47699, 34.03499], [-117.47668, 34.03568], [-117.47629, 34.03691], [-117.47664, 34.0374], [-117.47752, 34.03699], [-117.47836, 34.03716], [-117.47924, 34.03724], [-117.48181, 34.03822], [-117.48184, 34.03841], [-117.48189, 34.03859], [-117.48232, 34.0396], [-117.48244, 34.03997], [-117.48253, 34.04034], [-117.4826, 34.0408], [-117.48262, 34.04118], [-117.48261, 34.04155], [-117.48255, 34.04201]]]} | Open Access 1 | 5156 | Martin Tudor Jurupa Hills Regional Park | 3750 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | https://www.fontana.org/Facilities.aspx?Page=detail&RID=17 | San Bernardino 22 | 861.224 | Martin Tudor Jurupa Hills 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]);