units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 390 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 69 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10261 | 10261 | 10260 | {"type": "Polygon", "coordinates": [[[-121.44704, 37.7336], [-121.44559, 37.7336], [-121.44555, 37.73245], [-121.44403, 37.73247], [-121.4439, 37.73253], [-121.44375, 37.73255], [-121.44368, 37.73219], [-121.44367, 37.73171], [-121.44369, 37.73154], [-121.44484, 37.73154], [-121.44513, 37.73156], [-121.44546, 37.73164], [-121.44566, 37.73167], [-121.44593, 37.73168], [-121.44703, 37.7317], [-121.44704, 37.7336]]]} | Open Access 1 | 17981 | Ceciliani Park | 16992 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 10.923 | Ceciliani Park | 0 | Local Park 2 | 4 | |
10264 | 10264 | 10263 | {"type": "Polygon", "coordinates": [[[-121.43981, 37.74807], [-121.43977, 37.74811], [-121.43934, 37.74813], [-121.43852, 37.74809], [-121.43803, 37.74802], [-121.4365, 37.74774], [-121.43583, 37.74769], [-121.43517, 37.74768], [-121.43516, 37.74692], [-121.4398, 37.74691], [-121.43981, 37.74807]]]} | Open Access 1 | 17985 | Dr Powers Park | 18264 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 11.137 | Dr Powers Park | 0 | Local Park 2 | 4 | |
2609 | 2609 | 2608 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42953, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | 17988 | El Pescadero Park | 18528 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 13.77 | El Pescadero Park | 0 | Local Park 2 | 4 | |
2614 | 2614 | 2613 | {"type": "Polygon", "coordinates": [[[-121.41719, 37.74334], [-121.41718, 37.74344], [-121.41714, 37.74354], [-121.41656, 37.74356], [-121.41656, 37.74296], [-121.41681, 37.74296], [-121.41712, 37.74322], [-121.41717, 37.74327], [-121.41719, 37.74334]]]} | Open Access 1 | 17991 | Fine Park | 18901 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.743 | Fine Park | 0 | Local Park 2 | 4 | |
2610 | 2610 | 2609 | {"type": "Polygon", "coordinates": [[[-121.45642, 37.74867], [-121.45604, 37.74868], [-121.45603, 37.74858], [-121.45565, 37.74858], [-121.45565, 37.74832], [-121.45593, 37.74833], [-121.45636, 37.74841], [-121.45642, 37.74845], [-121.45642, 37.74867]]]} | Open Access 1 | 17995 | Kelly Park | 20589 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.502 | Kelly Park | 0 | Local Park 2 | 4 | |
2620 | 2620 | 2619 | {"type": "Polygon", "coordinates": [[[-121.45063, 37.75672], [-121.45057, 37.75678], [-121.45031, 37.75683], [-121.45007, 37.75691], [-121.44987, 37.757], [-121.44955, 37.75719], [-121.44932, 37.75727], [-121.44902, 37.75734], [-121.44873, 37.75737], [-121.44873, 37.75595], [-121.44894, 37.75595], [-121.44894, 37.75568], [-121.44929, 37.75568], [-121.44929, 37.75575], [-121.44942, 37.75585], [-121.44972, 37.75589], [-121.45019, 37.75569], [-121.45061, 37.75569], [-121.45063, 37.75672]]]} | Open Access 1 | 17999 | Kenner Park | 20607 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 6.011 | Kenner Park | 0 | Local Park 2 | 4 | |
10274 | 10274 | 10273 | {"type": "Polygon", "coordinates": [[[-121.43013, 37.72105], [-121.42976, 37.72105], [-121.42963, 37.72102], [-121.42947, 37.72103], [-121.4282, 37.72103], [-121.42812, 37.72097], [-121.42811, 37.71999], [-121.43012, 37.71998], [-121.43013, 37.72105]]]} | Open Access 1 | 18003 | Larson Park | 21038 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 5.105 | Larson Park | 0 | Local Park 2 | 4 | |
2242 | 2242 | 2241 | {"type": "Polygon", "coordinates": [[[-121.42572, 37.74329], [-121.42566, 37.7433], [-121.42566, 37.74341], [-121.42126, 37.74341], [-121.42125, 37.74213], [-121.42571, 37.74214], [-121.42572, 37.74329]]]} | Open Access 1 | 18006 | Lincoln Park | 21273 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 13.731 | Lincoln Park | 0 | Local Park 2 | 4 | |
2611 | 2611 | 2610 | {"type": "MultiPolygon", "coordinates": [[[[-121.44227, 37.72363], [-121.44223, 37.7237], [-121.44136, 37.72401], [-121.44088, 37.72409], [-121.4408, 37.72405], [-121.44072, 37.7238], [-121.44073, 37.72376], [-121.44075, 37.72375], [-121.44091, 37.72373], [-121.44135, 37.72373], [-121.44149, 37.72378], [-121.44161, 37.72377], [-121.44167, 37.72374], [-121.4417, 37.72369], [-121.44171, 37.72362], [-121.44167, 37.72356], [-121.44179, 37.72351], [-121.44179, 37.72335], [-121.44221, 37.72335], [-121.44223, 37.7235], [-121.44227, 37.72363]]], [[[-121.44384, 37.72334], [-121.44325, 37.72335], [-121.44255, 37.72359], [-121.44246, 37.72355], [-121.44243, 37.72347], [-121.44242, 37.72313], [-121.44247, 37.72308], [-121.44285, 37.72303], [-121.4435, 37.72286], [-121.44384, 37.72283], [-121.44384, 37.72334]]]]} | Open Access 1 | 18010 | Barbozo Park | 15810 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 2.772 | Barbozo Park | 0 | Local Park 2 | 4 | |
10277 | 10277 | 10276 | {"type": "MultiPolygon", "coordinates": [[[[-121.42658, 37.73042], [-121.42564, 37.73045], [-121.42563, 37.73015], [-121.42657, 37.73015], [-121.42658, 37.73042]]], [[[-121.42659, 37.7308], [-121.42566, 37.73083], [-121.42564, 37.73051], [-121.42658, 37.73048], [-121.42659, 37.7308]]]]} | Open Access 1 | 18014 | McDonald Park | 22023 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 1.386 | McDonald Park | 0 | Local Park 2 | 4 | |
12013 | 12013 | 12012 | {"type": "Polygon", "coordinates": [[[-121.4577, 37.74148], [-121.45744, 37.74151], [-121.45714, 37.74152], [-121.45707, 37.74146], [-121.45704, 37.74121], [-121.45704, 37.74086], [-121.45711, 37.74081], [-121.45722, 37.74081], [-121.45736, 37.74082], [-121.45766, 37.74088], [-121.45766, 37.74117], [-121.4577, 37.74148]]]} | Open Access 1 | 24696 | Fabian Park | 18781 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 1.012 | Fabian Park | 0 | Local Park 2 | 4 | |
12014 | 12014 | 12013 | {"type": "Polygon", "coordinates": [[[-121.41891, 37.73385], [-121.41881, 37.73389], [-121.41869, 37.73384], [-121.41869, 37.7338], [-121.41866, 37.73375], [-121.41862, 37.73372], [-121.41855, 37.7337], [-121.41831, 37.7333], [-121.41862, 37.73318], [-121.41887, 37.73359], [-121.41886, 37.73365], [-121.41887, 37.73369], [-121.41891, 37.73374], [-121.41891, 37.73385]]]} | Open Access 1 | 24697 | Huck Park | 20131 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.517 | Huck Park | 0 | Local Park 2 | 4 | |
5392 | 5392 | 5391 | {"type": "Polygon", "coordinates": [[[-121.44216, 37.75628], [-121.44188, 37.75628], [-121.44187, 37.75654], [-121.44171, 37.75654], [-121.44171, 37.75628], [-121.44157, 37.75627], [-121.44157, 37.75601], [-121.44216, 37.75601], [-121.44216, 37.75628]]]} | Open Access 1 | 24698 | Slayter Park | 25556 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.493 | Slayter Park | 0 | Local Park 2 | 4 | |
12038 | 12038 | 12037 | {"type": "Polygon", "coordinates": [[[-121.42023, 37.71427], [-121.42012, 37.71451], [-121.41981, 37.71452], [-121.41974, 37.71457], [-121.41934, 37.71457], [-121.41934, 37.71428], [-121.42023, 37.71427]]]} | Open Access 1 | 24714 | Clyde Abbott Park | 17449 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.541 | Clyde Abbott Park | 0 | Local Park 2 | 4 | |
12039 | 12039 | 12038 | {"type": "Polygon", "coordinates": [[[-121.46131, 37.74542], [-121.4613, 37.74549], [-121.46114, 37.74565], [-121.46104, 37.7458], [-121.46064, 37.74569], [-121.46063, 37.74505], [-121.46067, 37.74505], [-121.4607, 37.74513], [-121.46077, 37.74517], [-121.46087, 37.74518], [-121.46098, 37.74516], [-121.46107, 37.74517], [-121.46118, 37.74526], [-121.46131, 37.74542]]]} | Open Access 1 | 24715 | Dr Ralph Allen Park | 18265 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.812 | Dr Ralph Allen Park | 0 | Local Park 2 | 4 | |
4882 | 4882 | 4881 | {"type": "Polygon", "coordinates": [[[-121.45134, 37.72705], [-121.45081, 37.72706], [-121.45079, 37.72676], [-121.45114, 37.72663], [-121.45128, 37.72666], [-121.45134, 37.72686], [-121.45134, 37.72705]]]} | Open Access 1 | 24716 | Bailor Hennan Park | 15762 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.479 | Bailor Hennan Park | 0 | Local Park 2 | 4 | |
1626 | 1626 | 1625 | {"type": "Polygon", "coordinates": [[[-121.4747, 37.74883], [-121.47108, 37.75046], [-121.47055, 37.74971], [-121.4706, 37.7496], [-121.47262, 37.74865], [-121.47268, 37.74866], [-121.47276, 37.74864], [-121.47341, 37.74834], [-121.4747, 37.74883]]]} | Open Access 1 | 24718 | Clyde Bland Park | 17450 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 8.607 | Clyde Bland Park | 0 | Local Park 2 | 4 | |
2077 | 2077 | 2076 | {"type": "Polygon", "coordinates": [[[-121.46933, 37.73897], [-121.46926, 37.73902], [-121.46447, 37.73903], [-121.4644, 37.73898], [-121.4644, 37.73676], [-121.46924, 37.73675], [-121.4693, 37.73708], [-121.46932, 37.73731], [-121.46933, 37.73897]]]} | Open Access 1 | 24719 | Busch Park | 16537 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 27.011 | Busch Park | 0 | Local Park 2 | 4 | |
12040 | 12040 | 12039 | {"type": "Polygon", "coordinates": [[[-121.44278, 37.71963], [-121.44271, 37.7197], [-121.4427, 37.71975], [-121.44272, 37.7198], [-121.44263, 37.71983], [-121.44257, 37.71994], [-121.44224, 37.71989], [-121.4423, 37.71951], [-121.44235, 37.7194], [-121.4424, 37.71932], [-121.44264, 37.71944], [-121.44278, 37.71963]]]} | Open Access 1 | 24720 | Evelyn Costa Park | 18758 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.529 | Evelyn Costa Park | 0 | Local Park 2 | 4 | |
12041 | 12041 | 12040 | {"type": "Polygon", "coordinates": [[[-121.44256, 37.70544], [-121.44256, 37.70571], [-121.44184, 37.70571], [-121.44184, 37.70543], [-121.44256, 37.70544]]]} | Open Access 1 | 24721 | Emhoff Park | 18626 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.475 | Emhoff 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]);