superunits_with_maps

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

81 rows where MNG_AGENCY = 396

View and edit SQL

ACCESS_TYP

MNG_AG_TYP

MNG_AGENCY

  • Stockton, City of · 81
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
1179 1178 {"type": "Polygon", "coordinates": [[[-121.31092, 38.00933], [-121.31092, 38.00963], [-121.31022, 38.00964], [-121.3102, 38.01179], [-121.30897, 38.01178], [-121.30893, 38.01177], [-121.30892, 38.01174], [-121.30893, 38.00949], [-121.30949, 38.00948], [-121.3095, 38.00894], [-121.31055, 38.00895], [-121.31055, 38.00933], [-121.31092, 38.00933]]]} Open Access 1 Anderson Park   15479 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 8.921 Anderson Park  
1325 1324 {"type": "Polygon", "coordinates": [[[-121.34589, 38.0487], [-121.34578, 38.04902], [-121.3457, 38.04939], [-121.34566, 38.04976], [-121.34565, 38.0503], [-121.34558, 38.05035], [-121.3447, 38.05036], [-121.34443, 38.05038], [-121.34418, 38.05044], [-121.34393, 38.05052], [-121.34367, 38.05063], [-121.3434, 38.0508], [-121.34319, 38.05098], [-121.34309, 38.051], [-121.34245, 38.05072], [-121.34236, 38.0507], [-121.34188, 38.05044], [-121.34185, 38.05006], [-121.34456, 38.05007], [-121.34459, 38.04833], [-121.34587, 38.04866], [-121.34589, 38.0487]]]} Open Access 1 Baxter Park   15869 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 9.115 Baxter Park  
1425 1424 {"type": "Polygon", "coordinates": [[[-121.33169, 38.03669], [-121.33167, 38.03673], [-121.33162, 38.03675], [-121.33058, 38.03674], [-121.33054, 38.03672], [-121.33052, 38.03669], [-121.33052, 38.03595], [-121.33045, 38.03589], [-121.33039, 38.03588], [-121.33033, 38.03589], [-121.33033, 38.03552], [-121.33043, 38.0355], [-121.33044, 38.03391], [-121.33101, 38.03362], [-121.33159, 38.03362], [-121.33163, 38.03364], [-121.33169, 38.03669]]]} Open Access 1 Aj Bart Detoni Park   15306 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 8.937 Aj Bart Detoni Park  
1479 1478 {"type": "Polygon", "coordinates": [[[-121.31057, 37.96761], [-121.3089, 37.96803], [-121.30876, 37.96808], [-121.30863, 37.96818], [-121.30856, 37.96822], [-121.30762, 37.96844], [-121.30743, 37.96844], [-121.30734, 37.96843], [-121.30631, 37.96816], [-121.3062, 37.96813], [-121.30602, 37.96801], [-121.3059, 37.96786], [-121.30587, 37.96777], [-121.30562, 37.96686], [-121.30561, 37.9667], [-121.30563, 37.96662], [-121.30872, 37.9661], [-121.31008, 37.96585], [-121.31016, 37.96617], [-121.30984, 37.96623], [-121.30987, 37.96638], [-121.31004, 37.96636], [-121.31026, 37.9672], [-121.31041, 37.96718], [-121.31057, 37.96761]]]} Open Access 1 American Legion Park   15451 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 20.63 American Legion Park  
1496 1495 {"type": "Polygon", "coordinates": [[[-121.31395, 38.01764], [-121.31393, 38.01767], [-121.31188, 38.019], [-121.31064, 38.01784], [-121.31128, 38.01783], [-121.31152, 38.01779], [-121.31174, 38.0177], [-121.31195, 38.01759], [-121.31213, 38.01746], [-121.31227, 38.0173], [-121.31238, 38.01711], [-121.31246, 38.01706], [-121.31282, 38.01707], [-121.313, 38.0171], [-121.31318, 38.01716], [-121.3134, 38.01726], [-121.31371, 38.01743], [-121.31394, 38.0176], [-121.31395, 38.01764]]]} Open Access 1 Angel Cruz Park   15490 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 7.137 Angel Cruz Park  
1584 1583 {"type": "Polygon", "coordinates": [[[-121.28708, 37.99347], [-121.28675, 37.99352], [-121.28606, 37.99371], [-121.28534, 37.99376], [-121.28547, 37.99414], [-121.28515, 37.99423], [-121.28504, 37.99413], [-121.28495, 37.99411], [-121.28488, 37.99411], [-121.28464, 37.99419], [-121.28354, 37.99448], [-121.28329, 37.99451], [-121.28319, 37.99457], [-121.28291, 37.99438], [-121.28261, 37.99453], [-121.28239, 37.99399], [-121.28293, 37.99369], [-121.28409, 37.9933], [-121.28514, 37.99319], [-121.28651, 37.99308], [-121.28687, 37.99299], [-121.28703, 37.99344], [-121.28707, 37.99345], [-121.28708, 37.99347]]]} Open Access 1 Arnold Rue Park   15604 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 8.532 Arnold Rue Park  
1643 1642 {"type": "Polygon", "coordinates": [[[-121.33522, 37.99548], [-121.33521, 37.9955], [-121.33481, 37.99563], [-121.33433, 37.99586], [-121.3339, 37.99615], [-121.33368, 37.99633], [-121.33248, 37.99445], [-121.33309, 37.99375], [-121.33327, 37.99359], [-121.33345, 37.99347], [-121.33348, 37.99346], [-121.33481, 37.99472], [-121.33496, 37.9949], [-121.33508, 37.9951], [-121.33514, 37.99523], [-121.33522, 37.99548]]]} Open Access 1 Atherton Park   15667 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 9.8 Atherton Park  
1764 1763 {"type": "Polygon", "coordinates": [[[-121.34974, 37.99512], [-121.34936, 37.99513], [-121.34921, 37.99498], [-121.34906, 37.99488], [-121.34854, 37.99465], [-121.34831, 37.99453], [-121.34808, 37.99433], [-121.34972, 37.99431], [-121.34974, 37.99512]]]} Open Access 1 Barkleyville Dog Park   15818 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1.985 Barkleyville Dog Park  
2281 2280 {"type": "Polygon", "coordinates": [[[-121.30992, 37.99079], [-121.3096, 37.99094], [-121.3092, 37.991], [-121.30891, 37.9912], [-121.3086, 37.99132], [-121.30829, 37.99114], [-121.30829, 37.99107], [-121.30824, 37.991], [-121.30861, 37.99074], [-121.3089, 37.99012], [-121.30939, 37.99], [-121.30959, 37.98988], [-121.30979, 37.98999], [-121.30985, 37.99025], [-121.30972, 37.99029], [-121.30969, 37.99036], [-121.30971, 37.99042], [-121.30978, 37.9905], [-121.30992, 37.99079]]]} Open Access 1 Brooking Park   16424 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 3.031 Brooking Park  
2328 2327 {"type": "Polygon", "coordinates": [[[-121.37991, 37.97763], [-121.37336, 37.9769], [-121.37042, 37.97837], [-121.37205, 37.97398], [-121.37356, 37.9716], [-121.37991, 37.97763]]]} Open Access 1 Buckley Cove Park   16475 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 63.794 Buckley Cove Park  
2485 2484 {"type": "Polygon", "coordinates": [[[-121.30608, 37.9781], [-121.30536, 37.97719], [-121.30527, 37.97715], [-121.30518, 37.97716], [-121.30485, 37.97732], [-121.30438, 37.97671], [-121.30466, 37.97657], [-121.30476, 37.9766], [-121.30485, 37.97658], [-121.3049, 37.97655], [-121.30497, 37.97646], [-121.30503, 37.97643], [-121.30562, 37.97629], [-121.30568, 37.9763], [-121.30616, 37.97749], [-121.3062, 37.97761], [-121.30621, 37.97774], [-121.30619, 37.97787], [-121.30615, 37.97799], [-121.30608, 37.9781]]]} Open Access 1 Caldwell Park   16676 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 3.404 Caldwell Park  
2787 2786 {"type": "Polygon", "coordinates": [[[-121.27664, 38.03557], [-121.27664, 38.03661], [-121.27655, 38.03688], [-121.2724, 38.03689], [-121.2723, 38.03682], [-121.27228, 38.03675], [-121.27225, 38.03654], [-121.27227, 38.03634], [-121.27231, 38.03621], [-121.27236, 38.03611], [-121.27247, 38.03599], [-121.27259, 38.0359], [-121.27448, 38.03519], [-121.27664, 38.03557]]]} Open Access 1 Matt Equinoa Park   32973 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 14.515 Matt Equinoa Park  
3125 3124 {"type": "Polygon", "coordinates": [[[-121.29528, 37.94336], [-121.29425, 37.94354], [-121.29402, 37.94272], [-121.29506, 37.94255], [-121.29528, 37.94336]]]} Open Access 1 Columbus Square   17552 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 2.132 Columbus Square  
3163 3162 {"type": "Polygon", "coordinates": [[[-121.27796, 37.95986], [-121.27692, 37.96003], [-121.2767, 37.95923], [-121.27774, 37.95905], [-121.27796, 37.95986]]]} Open Access 1 Constitution Park   17599 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 2.112 Constitution Park  
3186 3185 {"type": "Polygon", "coordinates": [[[-121.35774, 38.04766], [-121.35702, 38.04778], [-121.35683, 38.04716], [-121.35755, 38.04706], [-121.35774, 38.04766]]]} Open Access 1 Corren Park   17656 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1.098 Corren Park  
3201 3200 {"type": "Polygon", "coordinates": [[[-121.30278, 38.02522], [-121.30277, 38.02613], [-121.30065, 38.02612], [-121.30063, 38.02519], [-121.30068, 38.02516], [-121.30275, 38.02517], [-121.30278, 38.02522]]]} Open Access 1 Cortez Park   17663 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 4.922 Cortez Park  
3493 3492 {"type": "Polygon", "coordinates": [[[-121.29144, 37.95434], [-121.29041, 37.95452], [-121.29024, 37.95388], [-121.29126, 37.95371], [-121.29144, 37.95434]]]} Open Access 1 DeCarli Waterfront   17984 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1.637 DeCarli Waterfront  
3586 3585 {"type": "Polygon", "coordinates": [[[-121.2634, 38.04678], [-121.25918, 38.04681], [-121.25898, 38.04416], [-121.25901, 38.04388], [-121.2591, 38.04355], [-121.25911, 38.04302], [-121.26311, 38.04296], [-121.2634, 38.04678]]]} Open Access 1 Detention Basin Soccer Complex   18118 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 38.289 Detention Basin Soccer Complex  
3667 3666 {"type": "Polygon", "coordinates": [[[-121.32358, 38.0547], [-121.32333, 38.05496], [-121.3228, 38.05477], [-121.32161, 38.05457], [-121.32162, 38.05455], [-121.32168, 38.05455], [-121.32174, 38.05453], [-121.32179, 38.0545], [-121.32182, 38.05445], [-121.32182, 38.0544], [-121.3218, 38.05435], [-121.32176, 38.05431], [-121.3217, 38.05429], [-121.3216, 38.05429], [-121.32148, 38.05435], [-121.32139, 38.05437], [-121.32061, 38.05424], [-121.32001, 38.05422], [-121.32003, 38.05355], [-121.32033, 38.05349], [-121.32063, 38.05341], [-121.3217, 38.05304], [-121.32192, 38.053], [-121.322, 38.05294], [-121.3225, 38.05277], [-121.32358, 38.0547]]]} Open Access 1 Dortha May Pitts Park   18224 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 9.994 Dortha May Pitts Park  
3843 3842 {"type": "Polygon", "coordinates": [[[-121.29231, 37.96254], [-121.29129, 37.96272], [-121.29107, 37.9619], [-121.29209, 37.96173], [-121.29231, 37.96254]]]} Open Access 1 Eden Square   18429 1343 Stockton, City of 396 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 2.114 Eden Square  

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 44.904ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette