units_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

Suggested facets: GAP_STS

ACCESS_TYP

MNG_AG_TYP

MNG_AGENCY

  • Stockton, City of · 81
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
1645 1644 {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} Open Access 1 47779 Shady Forest 31579 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 4.969 Shady Forest 0 Local Resource Management Area 83 3
2196 2195 {"type": "Polygon", "coordinates": [[[-121.30277, 38.02613], [-121.30065, 38.02612], [-121.30063, 38.02519], [-121.30068, 38.02516], [-121.30275, 38.02517], [-121.30278, 38.02522], [-121.30277, 38.02613]]]} Open Access 1 17836 Cortez Park 17663 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 4.922 Cortez Park 0 Local Park 2 4
2226 2225 {"type": "Polygon", "coordinates": [[[-121.26759, 37.95177], [-121.26567, 37.95226], [-121.26566, 37.95227], [-121.2657, 37.95235], [-121.26318, 37.95299], [-121.26262, 37.95157], [-121.26601, 37.95053], [-121.26631, 37.95045], [-121.26724, 37.95031], [-121.26752, 37.95152], [-121.26759, 37.95177]]]} Open Access 1 17937 Stribley Park 25923 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 17.823 Stribley Park 0 Local Park 2 4
2553 2552 {"type": "Polygon", "coordinates": [[[-121.31057, 37.96761], [-121.3089, 37.96803], [-121.30876, 37.96808], [-121.30862, 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.96721], [-121.31041, 37.96718], [-121.31057, 37.96761]]]} Open Access 1 17808 American Legion Park 15451 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 20.625 American Legion Park 0 Local Park 2 4
2556 2555 {"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 17820 Buckley Cove Park 16475 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 63.792 Buckley Cove Park 0 Local Park 2 4
2559 2558 {"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 17832 Constitution Park 17599 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.112 Constitution Park 0 Local Park 2 4
2560 2559 {"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 17840 Angel Cruz Park 15490 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 7.137 Angel Cruz Park 0 Local Park 2 4
2569 2568 {"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 17852 Eden Square 18429 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.114 Eden Square 0 Local Park 2 4
2572 2571 {"type": "Polygon", "coordinates": [[[-121.28838, 37.95808], [-121.28734, 37.95826], [-121.28712, 37.95745], [-121.28814, 37.95727], [-121.28838, 37.95808]]]} Open Access 1 17856 Fremont Square 19103 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.102 Fremont Square 0 Local Park 2 4
2574 2573 {"type": "Polygon", "coordinates": [[[-121.33843, 38.02211], [-121.33576, 38.02212], [-121.33575, 38.02155], [-121.33596, 38.0216], [-121.3361, 38.02161], [-121.33628, 38.02159], [-121.33665, 38.02149], [-121.33684, 38.02146], [-121.33841, 38.02147], [-121.33843, 38.02211]]]} Open Access 1 17868 Gibbons Park 19286 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 3.95 Gibbons Park 0 Local Park 2 4
2576 2575 {"type": "Polygon", "coordinates": [[[-121.28336, 37.94962], [-121.28232, 37.9498], [-121.28209, 37.94898], [-121.28313, 37.9488], [-121.28336, 37.94962]]]} Open Access 1 17871 Gleason Park 19312 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.173 Gleason Park 0 Local Park 2 4
2578 2577 {"type": "Polygon", "coordinates": [[[-121.27912, 37.94406], [-121.27807, 37.94424], [-121.27785, 37.94344], [-121.2789, 37.94326], [-121.27912, 37.94406]]]} Open Access 1 17887 Liberty Square 21214 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.142 Liberty Square 0 Local Park 2 4
2580 2579 {"type": "Polygon", "coordinates": [[[-121.28996, 37.92752], [-121.28994, 37.92753], [-121.28844, 37.92785], [-121.2884, 37.92785], [-121.28833, 37.92758], [-121.28816, 37.92716], [-121.28809, 37.92717], [-121.28757, 37.92588], [-121.28923, 37.92551], [-121.28976, 37.92681], [-121.28969, 37.92684], [-121.28996, 37.92752]]]} Open Access 1 17902 Mattie Harrell Park 21958 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 8.493 Mattie Harrell Park 0 Local Park 2 4
2582 2581 {"type": "Polygon", "coordinates": [[[-121.25678, 37.92133], [-121.25525, 37.92171], [-121.25505, 37.92122], [-121.25658, 37.92084], [-121.25678, 37.92133]]]} Open Access 1 17914 Reverend Holmes Park 24304 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 1.993 Reverend Holmes Park 0 Local Park 2 4
2584 2583 {"type": "Polygon", "coordinates": [[[-121.27101, 37.92818], [-121.27075, 37.92822], [-121.27051, 37.92832], [-121.27041, 37.92831], [-121.27025, 37.92836], [-121.27013, 37.92796], [-121.26961, 37.92805], [-121.2695, 37.92765], [-121.26957, 37.92756], [-121.26957, 37.92749], [-121.26953, 37.92743], [-121.26943, 37.92738], [-121.26943, 37.92737], [-121.27073, 37.92715], [-121.27101, 37.92818]]]} Open Access 1 17917 Reverend Peterson Park 24305 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.931 Reverend Peterson Park 0 Local Park 2 4
2586 2585 {"type": "Polygon", "coordinates": [[[-121.31049, 37.99986], [-121.31053, 37.99986], [-121.31057, 37.99989], [-121.31087, 38.00067], [-121.31122, 38.00163], [-121.31118, 38.00167], [-121.31078, 38.00177], [-121.31001, 38.00203], [-121.30997, 38.00203], [-121.30991, 38.00199], [-121.30923, 38.00018], [-121.30927, 38.00014], [-121.31049, 37.99986]]]} Open Access 1 17924 Sherwood Forest Park 25398 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 6.435 Sherwood Forest Park 0 Local Park 2 4
2592 2591 {"type": "Polygon", "coordinates": [[[-121.25057, 37.95815], [-121.24988, 37.95834], [-121.24983, 37.95828], [-121.24975, 37.95823], [-121.24966, 37.95822], [-121.24957, 37.95823], [-121.24948, 37.95829], [-121.24943, 37.95839], [-121.24914, 37.95865], [-121.24876, 37.95839], [-121.24837, 37.95831], [-121.24836, 37.9582], [-121.24819, 37.95775], [-121.24824, 37.9577], [-121.24977, 37.9573], [-121.24993, 37.95724], [-121.25013, 37.95713], [-121.25057, 37.95815]]]} Open Access 1 17933 Sousa Park 25635 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 4.796 Sousa Park 0 Local Park 2 4
2595 2594 {"type": "Polygon", "coordinates": [[[-121.28536, 38.02967], [-121.28534, 38.02969], [-121.28486, 38.02975], [-121.28453, 38.02985], [-121.28421, 38.02999], [-121.28391, 38.03009], [-121.2836, 38.03014], [-121.28343, 38.03014], [-121.28342, 38.03011], [-121.2834, 38.02909], [-121.28344, 38.02886], [-121.2834, 38.02878], [-121.28329, 38.02871], [-121.28338, 38.02845], [-121.28526, 38.02844], [-121.28527, 38.02864], [-121.28535, 38.02916], [-121.28536, 38.02967]]]} Open Access 1 17948 Valverde Park 26816 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 6.85 Valverde Park 0 Local Park 2 4
2596 2595 {"type": "Polygon", "coordinates": [[[-121.29689, 37.91962], [-121.29622, 37.91967], [-121.29563, 37.91976], [-121.29481, 37.91994], [-121.29413, 37.92014], [-121.29298, 37.92035], [-121.29282, 37.92025], [-121.29246, 37.91942], [-121.29174, 37.9175], [-121.29183, 37.91739], [-121.29307, 37.91779], [-121.29447, 37.91827], [-121.29514, 37.91847], [-121.29566, 37.91859], [-121.29688, 37.91858], [-121.29689, 37.91962]]]} Open Access 1 17951 Van Buskirk Municipal Park 26822 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 19.859 Van Buskirk Municipal Park 0 Local Park 2 4
2599 2598 {"type": "Polygon", "coordinates": [[[-121.29933, 37.95829], [-121.29831, 37.95846], [-121.29808, 37.95766], [-121.29911, 37.95749], [-121.29933, 37.95829]]]} Open Access 1 17958 Weber Square 27327 1343 Stockton, City of 402 City 2 City Agency 2 http://www.stocktongov.com/services/parkRec/default.html City 2 1343 Stockton, City of 396 City 2 City Agency 2   San Joaquin 39 2.072 Weber Square 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 67.399ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette