units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 390, MNG_AG_LEV = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 69
- Local Recreation Area 2
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 73 ✖
MNG_AGENCY 1
- Tracy, City of · 73 ✖
ACCESS_TYP 1
- Open Access 73
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
3400 | 3400 | 3399 | {"type": "Polygon", "coordinates": [[[-121.43665, 37.7036], [-121.43664, 37.70422], [-121.43636, 37.70421], [-121.43629, 37.70416], [-121.4363, 37.70365], [-121.43637, 37.7036], [-121.43665, 37.7036]]]} | Open Access 1 | 24733 | Kimball Park | 20645 | 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.515 | Kimball Park | 0 | Local Park 2 | 4 | |
3401 | 3401 | 3400 | {"type": "Polygon", "coordinates": [[[-121.43761, 37.72738], [-121.43729, 37.72752], [-121.43714, 37.72747], [-121.43714, 37.72742], [-121.43712, 37.72738], [-121.43703, 37.72732], [-121.4369, 37.72732], [-121.43682, 37.72737], [-121.43673, 37.72722], [-121.43721, 37.72702], [-121.43741, 37.72722], [-121.43761, 37.72738]]]} | Open Access 1 | 24740 | Sister Cities Park | 25522 | 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.505 | Sister Cities Park | 0 | Local Park 2 | 4 | |
3515 | 3515 | 3514 | {"type": "Polygon", "coordinates": [[[-121.45599, 37.72415], [-121.45592, 37.72421], [-121.45585, 37.7244], [-121.4558, 37.72465], [-121.45552, 37.72465], [-121.45527, 37.72461], [-121.45507, 37.72452], [-121.45491, 37.72438], [-121.45483, 37.72427], [-121.45479, 37.72415], [-121.45513, 37.72411], [-121.45513, 37.72397], [-121.45531, 37.72375], [-121.45558, 37.72365], [-121.45579, 37.72399], [-121.45599, 37.72415]]]} | Open Access 1 | 26546 | Kingsley Chadeayne Park | 20670 | 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.717 | Kingsley Chadeayne Park | 0 | Local Park 2 | 4 | |
3537 | 3537 | 3536 | {"type": "Polygon", "coordinates": [[[-121.44091, 37.7344], [-121.44095, 37.73455], [-121.44096, 37.73472], [-121.44085, 37.73529], [-121.44084, 37.73547], [-121.44084, 37.73572], [-121.44051, 37.73575], [-121.44056, 37.73608], [-121.44064, 37.7364], [-121.44069, 37.73664], [-121.44071, 37.73705], [-121.44062, 37.73748], [-121.44047, 37.73784], [-121.44019, 37.73776], [-121.44033, 37.73739], [-121.44036, 37.7372], [-121.44039, 37.73693], [-121.44038, 37.73674], [-121.44035, 37.73659], [-121.44036, 37.73657], [-121.44023, 37.73603], [-121.4402, 37.73581], [-121.44021, 37.73574], [-121.43998, 37.73566], [-121.43988, 37.7356], [-121.43976, 37.7355], [-121.43968, 37.73539], [-121.43963, 37.73527], [-121.43962, 37.73509], [-121.43966, 37.73494], [-121.43974, 37.7348], [-121.43985, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} | Open Access 1 | 28133 | Alden Park | 15345 | 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 | 4.924 | Alden Park | 0 | Local Park 2 | 4 | |
3708 | 3708 | 3707 | {"type": "Polygon", "coordinates": [[[-121.42033, 37.73804], [-121.42004, 37.73828], [-121.41973, 37.73803], [-121.42002, 37.7378], [-121.42033, 37.73804]]]} | Open Access 1 | 44513 | Civic Center Plaza | 17369 | 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.348 | Civic Ctr. Plaza | 0 | Local Park 2 | 4 | |
4079 | 4079 | 4078 | {"type": "Polygon", "coordinates": [[[-121.43653, 37.68873], [-121.43601, 37.68921], [-121.43568, 37.68937], [-121.43565, 37.68851], [-121.43653, 37.6885], [-121.43653, 37.68873]]]} | Open Access 1 | 44482 | American Legion Park | 15452 | 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.258 | American Legion 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 | |
5154 | 5154 | 5153 | {"type": "Polygon", "coordinates": [[[-121.43885, 37.72484], [-121.43881, 37.72486], [-121.43877, 37.72509], [-121.43829, 37.72499], [-121.43822, 37.72492], [-121.43821, 37.72477], [-121.43877, 37.72458], [-121.43884, 37.72471], [-121.43883, 37.72477], [-121.43885, 37.72484]]]} | Open Access 1 | 24744 | Tracy Press Park | 26505 | 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.518 | Tracy Press Park | 0 | Local Park 2 | 4 | |
5196 | 5196 | 5195 | {"type": "Polygon", "coordinates": [[[-121.44705, 37.7373], [-121.44705, 37.73738], [-121.44679, 37.73756], [-121.44636, 37.73713], [-121.44658, 37.73699], [-121.44668, 37.73699], [-121.44705, 37.7373]]]} | Open Access 1 | 24737 | Patzer Park | 23527 | 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.498 | Patzer Park | 0 | Local Park 2 | 4 | |
5201 | 5201 | 5200 | {"type": "Polygon", "coordinates": [[[-121.46404, 37.74007], [-121.46402, 37.7402], [-121.46398, 37.74035], [-121.4638, 37.74082], [-121.46369, 37.74103], [-121.46354, 37.74122], [-121.46326, 37.74106], [-121.46298, 37.74106], [-121.46297, 37.74002], [-121.46397, 37.74002], [-121.46404, 37.74007]]]} | Open Access 1 | 24745 | Daniel Busch Park | 17919 | 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.397 | Daniel Busch Park | 0 | Local Park 2 | 4 | |
5204 | 5204 | 5203 | {"type": "Polygon", "coordinates": [[[-121.44241, 37.7118], [-121.44234, 37.71184], [-121.44231, 37.71192], [-121.44216, 37.71192], [-121.44215, 37.71185], [-121.44207, 37.71179], [-121.44207, 37.71125], [-121.44241, 37.71124], [-121.44241, 37.7118]]]} | Open Access 1 | 24746 | Westside Pioneer | 27430 | 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.516 | Westside Pioneer | None 421 | |||
5210 | 5210 | 5209 | {"type": "Polygon", "coordinates": [[[-121.42156, 37.70578], [-121.42154, 37.70599], [-121.42146, 37.70623], [-121.42133, 37.70643], [-121.42117, 37.70658], [-121.42097, 37.70673], [-121.42071, 37.70685], [-121.42045, 37.70691], [-121.42018, 37.70694], [-121.42016, 37.70659], [-121.42016, 37.70596], [-121.42012, 37.70596], [-121.42012, 37.70576], [-121.42156, 37.70578]]]} | Open Access 1 | 24747 | Yasui Park | 27764 | 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 | 3.133 | Yasui 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]);