units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 164 sorted by COUNTY
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency 15
MNG_AGENCY 1
- Fontana, City of · 15 ✖
ACCESS_TYP 1
- Open Access 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8177 | 8177 | 8176 | {"type": "Polygon", "coordinates": [[[-117.49514, 34.04543], [-117.49513, 34.04629], [-117.49346, 34.04629], [-117.49346, 34.04568], [-117.49412, 34.04568], [-117.49412, 34.04426], [-117.49495, 34.04426], [-117.49502, 34.04431], [-117.49502, 34.04512], [-117.49499, 34.04527], [-117.49504, 34.04537], [-117.49514, 34.04543]]]} | Open Access 1 | 12381 | Shadow Park | 25340 | 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 | San Bernardino 22 | 5.903 | Shadow Park | 0 | Local Park 2 | 4 | |
8276 | 8276 | 8275 | {"type": "Polygon", "coordinates": [[[-117.49063, 34.0335], [-117.49062, 34.03354], [-117.48958, 34.03402], [-117.48708, 34.0347], [-117.48662, 34.03406], [-117.48481, 34.03406], [-117.48481, 34.03351], [-117.49063, 34.0335]]]} | Open Access 1 | 12875 | Jurupa Hills Open Space | 20536 | 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 | San Bernardino 22 | 9.652 | Jurupa Hills OS | 0 | Local Recreation Area 3 | 4 | |
10830 | 10830 | 10829 | {"type": "MultiPolygon", "coordinates": [[[[-117.47469, 34.14318], [-117.47284, 34.14489], [-117.47226, 34.14447], [-117.47195, 34.14431], [-117.47176, 34.14425], [-117.47164, 34.14422], [-117.4716, 34.14415], [-117.47153, 34.14409], [-117.47091, 34.14402], [-117.47071, 34.14395], [-117.47041, 34.1438], [-117.47044, 34.14377], [-117.47042, 34.14369], [-117.47046, 34.14364], [-117.47055, 34.14358], [-117.47069, 34.14342], [-117.47072, 34.14332], [-117.47083, 34.14314], [-117.47093, 34.14294], [-117.47094, 34.14315], [-117.47469, 34.14318]]], [[[-117.47614, 34.14539], [-117.47552, 34.1459], [-117.47542, 34.14597], [-117.47535, 34.14597], [-117.47502, 34.14573], [-117.47492, 34.14561], [-117.47485, 34.14558], [-117.47476, 34.14557], [-117.47475, 34.14552], [-117.47442, 34.14528], [-117.47518, 34.14457], [-117.47555, 34.14484], [-117.47557, 34.14492], [-117.47561, 34.14497], [-117.47577, 34.14505], [-117.47614, 34.14532], [-117.47614, 34.14539]]]]} | Open Access 1 | 20542 | Rosena Park | 24625 | 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 | San Bernardino 22 | 13.578 | Rosena Park | 0 | Local Park 2 | 4 | |
12021 | 12021 | 12020 | {"type": "Polygon", "coordinates": [[[-117.43146, 34.04431], [-117.43139, 34.04433], [-117.43134, 34.04437], [-117.43113, 34.04479], [-117.43114, 34.04514], [-117.43066, 34.04517], [-117.43045, 34.04515], [-117.43032, 34.04512], [-117.43028, 34.04505], [-117.43055, 34.0446], [-117.43084, 34.04473], [-117.43106, 34.04439], [-117.43119, 34.04425], [-117.43134, 34.04412], [-117.43146, 34.04431]]]} | Open Access 1 | 24690 | Fiesta Park | 18893 | 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 | San Bernardino 22 | 1.285 | Fiesta Park | 0 | Local Park 2 | 4 | |
12338 | 12338 | 12337 | {"type": "Polygon", "coordinates": [[[-117.42992, 34.05372], [-117.42991, 34.05376], [-117.42985, 34.0538], [-117.42973, 34.05386], [-117.42961, 34.05389], [-117.42948, 34.05391], [-117.42894, 34.05391], [-117.42898, 34.05387], [-117.42897, 34.05243], [-117.4289, 34.05238], [-117.42967, 34.05236], [-117.42973, 34.05241], [-117.42975, 34.05333], [-117.42981, 34.05354], [-117.42992, 34.05372]]]} | Open Access 1 | 26030 | Sycamore Hills Park | 26130 | 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 | San Bernardino 22 | 3.081 | Sycamore Hills Park | 0 | Local Park 2 | 4 | |
12915 | 12915 | 12914 | {"type": "Polygon", "coordinates": [[[-117.46226, 34.04585], [-117.46226, 34.04666], [-117.45697, 34.0467], [-117.45696, 34.04589], [-117.45786, 34.04588], [-117.45786, 34.04525], [-117.45828, 34.04525], [-117.45825, 34.04531], [-117.45826, 34.04538], [-117.45832, 34.04544], [-117.45839, 34.04546], [-117.45848, 34.04546], [-117.45853, 34.04543], [-117.45857, 34.04538], [-117.45858, 34.04533], [-117.4586, 34.04588], [-117.46226, 34.04585]]]} | Open Access 1 | 30369 | Catawba Park | 16971 | 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 | San Bernardino 22 | 11.892 | Catawba Park | 0 | Local Park 2 | 4 | |
12916 | 12916 | 12915 | {"type": "Polygon", "coordinates": [[[-117.4623, 34.12153], [-117.46228, 34.12319], [-117.46027, 34.12319], [-117.46027, 34.12167], [-117.4606, 34.12166], [-117.4606, 34.12153], [-117.4623, 34.12153]]]} | Open Access 1 | 30370 | Almeria Park | 15396 | 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 | San Bernardino 22 | 8.389 | Almeria Park | 0 | Local Park 2 | 4 | |
12917 | 12917 | 12916 | {"type": "Polygon", "coordinates": [[[-117.41151, 34.1144], [-117.41136, 34.11441], [-117.41135, 34.11491], [-117.40981, 34.11491], [-117.40981, 34.11451], [-117.40978, 34.1145], [-117.40977, 34.11418], [-117.40982, 34.11413], [-117.41151, 34.11412], [-117.41151, 34.1144]]]} | Open Access 1 | 30371 | Fernandez Park | 18877 | 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 | San Bernardino 22 | 3.207 | Fernandez Park | 0 | Local Park 2 | 4 | |
12918 | 12918 | 12917 | {"type": "Polygon", "coordinates": [[[-117.46729, 34.1606], [-117.46712, 34.16076], [-117.46692, 34.16098], [-117.46675, 34.16121], [-117.46662, 34.16141], [-117.46643, 34.16182], [-117.46635, 34.16207], [-117.46629, 34.16233], [-117.46626, 34.1627], [-117.46628, 34.16314], [-117.46654, 34.16431], [-117.46662, 34.16427], [-117.46662, 34.16461], [-117.46632, 34.16481], [-117.46408, 34.16482], [-117.4637, 34.16478], [-117.4636, 34.16474], [-117.46356, 34.16467], [-117.46357, 34.1646], [-117.46393, 34.16396], [-117.46427, 34.16346], [-117.46474, 34.16288], [-117.46506, 34.16255], [-117.46539, 34.16223], [-117.46729, 34.1606]]]} | Open Access 1 | 30372 | Coyote Canyon Park | 17733 | 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 | San Bernardino 22 | 15.023 | Coyote Canyon Park | 0 | Local Park 2 | 4 | |
12919 | 12919 | 12918 | {"type": "Polygon", "coordinates": [[[-117.46649, 34.15405], [-117.46272, 34.15406], [-117.46282, 34.1538], [-117.46288, 34.15353], [-117.46291, 34.15325], [-117.46289, 34.15301], [-117.46285, 34.15277], [-117.46278, 34.15254], [-117.46268, 34.15231], [-117.46247, 34.15195], [-117.46235, 34.1516], [-117.46231, 34.15127], [-117.46231, 34.1506], [-117.46239, 34.15053], [-117.46375, 34.15053], [-117.46408, 34.15057], [-117.46436, 34.15057], [-117.46437, 34.15053], [-117.46456, 34.15054], [-117.46548, 34.15055], [-117.4659, 34.15058], [-117.46631, 34.15058], [-117.46639, 34.15066], [-117.4664, 34.15126], [-117.46645, 34.15123], [-117.46649, 34.15405]]]} | Open Access 1 | 30373 | Fontana Park | 18972 | 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 | San Bernardino 22 | 34.034 | Fontana Park | 0 | Local Park 2 | 4 | |
12920 | 12920 | 12919 | {"type": "Polygon", "coordinates": [[[-117.45335, 34.14633], [-117.45335, 34.1474], [-117.45228, 34.1474], [-117.45197, 34.14791], [-117.45211, 34.14817], [-117.4518, 34.14826], [-117.45166, 34.14804], [-117.45156, 34.14793], [-117.45145, 34.14784], [-117.45121, 34.14771], [-117.45087, 34.14761], [-117.45086, 34.14754], [-117.45103, 34.14714], [-117.45168, 34.14733], [-117.45202, 34.14728], [-117.45251, 34.14637], [-117.45249, 34.14631], [-117.45219, 34.14619], [-117.45222, 34.14615], [-117.45273, 34.14633], [-117.45335, 34.14633]]]} | Open Access 1 | 30374 | Patricia Marrujo Park | 23509 | 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 | San Bernardino 22 | 5.049 | Patricia Marrujo Park | 0 | Local Park 2 | 4 | |
12921 | 12921 | 12920 | {"type": "Polygon", "coordinates": [[[-117.51325, 34.10711], [-117.51312, 34.10776], [-117.51302, 34.10801], [-117.51285, 34.10804], [-117.51257, 34.10776], [-117.51241, 34.10757], [-117.51227, 34.10733], [-117.51221, 34.10714], [-117.51228, 34.10705], [-117.51247, 34.10703], [-117.51316, 34.10703], [-117.51325, 34.10711]]]} | Open Access 1 | 30375 | Patricia Murray Park | 23510 | 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 | San Bernardino 22 | 1.804 | Patricia Murray Park | 0 | Local Park 2 | 4 | |
13898 | 13898 | 13897 | {"type": "Polygon", "coordinates": [[[-117.46674, 34.043], [-117.46672, 34.04303], [-117.46669, 34.04305], [-117.46278, 34.04309], [-117.46319, 34.0409], [-117.4649, 34.04089], [-117.46493, 34.04226], [-117.46673, 34.04225], [-117.46674, 34.043]]]} | Open Access 1 | 36508 | Fontana holding 1 | 18971 | 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 | San Bernardino 22 | 14.384 | Fontana holding 1 | 0 | Local Other or Unknown 14 | 4 | |
14312 | 14312 | 14311 | {"type": "Polygon", "coordinates": [[[-117.50464, 34.12099], [-117.50442, 34.121], [-117.50442, 34.1212], [-117.49962, 34.12119], [-117.50229, 34.11894], [-117.50274, 34.11906], [-117.50322, 34.11924], [-117.50361, 34.11945], [-117.50395, 34.1197], [-117.50412, 34.11987], [-117.50414, 34.11992], [-117.50412, 34.11996], [-117.50351, 34.1203], [-117.50346, 34.12031], [-117.50332, 34.12043], [-117.50344, 34.12052], [-117.50352, 34.12054], [-117.50361, 34.12053], [-117.50369, 34.12049], [-117.50378, 34.12041], [-117.50423, 34.12017], [-117.50427, 34.12015], [-117.50433, 34.12016], [-117.50437, 34.12019], [-117.50442, 34.12028], [-117.50454, 34.12054], [-117.50461, 34.12077], [-117.50464, 34.12099]], [[-117.49993, 34.12104], [-117.50009, 34.12105], [-117.5001, 34.12101], [-117.49994, 34.121], [-117.49993, 34.12104]]]} | Open Access 1 | 44269 | Heritage Neighborhood Center | 19837 | 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 | San Bernardino 22 | 16.905 | Heritage Neighborhood Ctr. | 0 | Local Recreation Area 3 | 4 | |
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]);