superunits_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

73 rows where MNG_AGENCY = 390

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Tracy, City of · 73

ACCESS_TYP

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
776 775 {"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 Busch Park   16537 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 27.01 Busch Park  
1127 1126 {"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.73576], [-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.43984, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} Open Access 1 Alden Park   15345 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 4.929 Alden Park  
1145 1144 {"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 American Legion Park   15452 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 1.257 American Legion Park  
1723 1722 {"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 Bailor Hennan Park   15762 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 0.478 Bailor Hennan Park  
1758 1757 {"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.7235], [-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.72302], [-121.4435, 37.72287], [-121.44384, 37.72283], [-121.44384, 37.72334]]]]} Open Access 1 Barbozo Park   15810 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 2.773 Barbozo Park  
2022 2021 {"type": "Polygon", "coordinates": [[[-121.44968, 37.70208], [-121.44961, 37.70213], [-121.44886, 37.70212], [-121.44856, 37.70204], [-121.44814, 37.70186], [-121.44825, 37.70166], [-121.44851, 37.70147], [-121.44851, 37.70092], [-121.44895, 37.70092], [-121.44912, 37.70094], [-121.44934, 37.70102], [-121.44951, 37.70115], [-121.44961, 37.70128], [-121.44967, 37.70144], [-121.44968, 37.70208]]]} Open Access 1 Bill Schwartz Park   16113 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 3.391 Bill Schwartz Park  
2722 2721 {"type": "Polygon", "coordinates": [[[-121.44704, 37.73359], [-121.44559, 37.7336], [-121.44554, 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.73359]]]} Open Access 1 Ceciliani Park   16992 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 10.932 Ceciliani Park  
3050 3049 {"type": "Polygon", "coordinates": [[[-121.42023, 37.71427], [-121.42012, 37.71451], [-121.41982, 37.71452], [-121.41974, 37.71457], [-121.41934, 37.71457], [-121.41934, 37.71428], [-121.42023, 37.71427]]]} Open Access 1 Clyde Abbott Park   17449 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 0.541 Clyde Abbott Park  
3051 3050 {"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 Clyde Bland Park   17450 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 8.606 Clyde Bland Park  
3338 3337 {"type": "Polygon", "coordinates": [[[-121.43453, 37.73346], [-121.43448, 37.7335], [-121.43393, 37.73351], [-121.43393, 37.73297], [-121.43387, 37.73292], [-121.43389, 37.73287], [-121.43388, 37.7328], [-121.43394, 37.73272], [-121.43393, 37.73241], [-121.43383, 37.73217], [-121.43401, 37.73213], [-121.43417, 37.73211], [-121.43444, 37.73211], [-121.43449, 37.73215], [-121.43453, 37.73346]]]} Open Access 1 Fisher Park   18920 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 2.005 Fisher Park  
3435 3434 {"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 Daniel Busch Park   17919 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 2.397 Daniel Busch Park  
3649 3648 {"type": "Polygon", "coordinates": [[[-121.45011, 37.69731], [-121.44977, 37.69731], [-121.44981, 37.69723], [-121.4498, 37.69714], [-121.44974, 37.69707], [-121.44965, 37.69702], [-121.44954, 37.69701], [-121.44937, 37.69705], [-121.44896, 37.69705], [-121.44877, 37.69703], [-121.44853, 37.69697], [-121.44813, 37.69681], [-121.44781, 37.69675], [-121.44781, 37.69634], [-121.4501, 37.69634], [-121.45011, 37.69731]]]} Open Access 1 Don Close Park   18200 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 3.749 Don Close Park  
3663 3662 {"type": "Polygon", "coordinates": [[[-121.45657, 37.74687], [-121.45652, 37.74691], [-121.45595, 37.74691], [-121.45599, 37.74617], [-121.45652, 37.74613], [-121.45659, 37.74647], [-121.45657, 37.74687]]]} Open Access 1 Dorlane Thrasher Park   18220 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 1.095 Dorlane Thrasher Park  
3700 3699 {"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 Dr Powers Park   18264 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 11.137 Dr Powers Park  
3701 3700 {"type": "Polygon", "coordinates": [[[-121.46131, 37.74542], [-121.4613, 37.74549], [-121.46114, 37.74564], [-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 Dr Ralph Allen Park   18265 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 0.812 Dr Ralph Allen Park  
3764 3763 {"type": "Polygon", "coordinates": [[[-121.46771, 37.7481], [-121.46753, 37.74837], [-121.46693, 37.74811], [-121.46713, 37.74782], [-121.46771, 37.7481]]]} Open Access 1 Eagan Family Park   18335 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 0.526 Eagan Family Park  
3849 3848 {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42952, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} Open Access 1 El Pescadero Park   18528 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 13.777 El Pescadero Park  
3978 3977 {"type": "Polygon", "coordinates": [[[-121.4577, 37.74148], [-121.45743, 37.74151], [-121.45714, 37.74151], [-121.45707, 37.74146], [-121.45704, 37.74121], [-121.45704, 37.74086], [-121.45711, 37.74081], [-121.45721, 37.74081], [-121.45736, 37.74082], [-121.45766, 37.74088], [-121.45766, 37.74117], [-121.4577, 37.74148]]]} Open Access 1 Fabian Park   18781 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 1.012 Fabian Park  
3989 3988 {"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 Emhoff Park   18626 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 0.475 Emhoff Park  
4094 4093 {"type": "MultiPolygon", "coordinates": [[[[-121.44523, 37.72254], [-121.44517, 37.72262], [-121.445, 37.72265], [-121.44446, 37.72266], [-121.44442, 37.72263], [-121.44514, 37.72238], [-121.44523, 37.72254]]], [[[-121.44617, 37.72219], [-121.44613, 37.72226], [-121.4455, 37.72251], [-121.44541, 37.72249], [-121.44532, 37.72231], [-121.44608, 37.72203], [-121.44617, 37.72219]]], [[[-121.44722, 37.72187], [-121.44718, 37.72194], [-121.44644, 37.72215], [-121.44635, 37.72213], [-121.44625, 37.72197], [-121.447, 37.72173], [-121.44715, 37.72179], [-121.44722, 37.72187]]], [[[-121.44868, 37.72149], [-121.44837, 37.72155], [-121.44748, 37.72184], [-121.44739, 37.72181], [-121.44724, 37.72154], [-121.44719, 37.72151], [-121.44711, 37.72149], [-121.44868, 37.72149]]]]} Open Access 1 Evans Park   18754 1357 Tracy, City of 390 City 2 City Agency 2 http://www.ci.tracy.ca.us/?navid=52 City 2 1.873 Evans Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
                ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
                ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
                ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
                ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
                ON [superunits_with_maps] ([ACCESS_TYP]);
Powered by Datasette · Query took 43.223ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette