units_with_maps

Table actions

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

37 rows where AGNCY_TYP = 2, DES_TP = 2 and MNG_AGENCY = 167

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

MNG_AGENCY 1

  • Davis, City of · 37 ✖

ACCESS_TYP 1

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
439 439 438 {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} Open Access 1 21013 Hacienda Park 19586 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 0.923 Hacienda Park 0 Local Park 2 4
3053 3053 3052 {"type": "Polygon", "coordinates": [[[-121.6994, 38.55535], [-121.69905, 38.55552], [-121.69885, 38.55568], [-121.69872, 38.55587], [-121.69905, 38.55598], [-121.699, 38.55612], [-121.69899, 38.55625], [-121.69911, 38.55765], [-121.69911, 38.5578], [-121.69908, 38.55781], [-121.69908, 38.55786], [-121.69905, 38.55789], [-121.69867, 38.55794], [-121.69827, 38.55803], [-121.69796, 38.55813], [-121.69769, 38.55824], [-121.69773, 38.55537], [-121.6994, 38.55535]]]} Open Access 1 20964 John Barovetto Park 20429 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 8.389 John Barovetto Park 0 Local Park 2 4
3055 3055 3054 {"type": "Polygon", "coordinates": [[[-121.78648, 38.54919], [-121.78648, 38.55007], [-121.78525, 38.55004], [-121.78525, 38.54902], [-121.78605, 38.54902], [-121.78606, 38.54919], [-121.78648, 38.54919]]]} Open Access 1 20984 West Manor Park 27367 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 2.883 West Manor Park 0 Local Park 2 4
5113 5113 5112 {"type": "Polygon", "coordinates": [[[-121.74523, 38.54626], [-121.74471, 38.54656], [-121.74447, 38.5466], [-121.7438, 38.54423], [-121.74462, 38.54409], [-121.74523, 38.54626]]]} Open Access 1 21023 Central Park 17052 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 4.734 Central Park 0 Local Park 2 4
8012 8012 8011 {"type": "Polygon", "coordinates": [[[-121.71434, 38.56981], [-121.71412, 38.56993], [-121.71347, 38.56998], [-121.71348, 38.56937], [-121.71412, 38.56937], [-121.71419, 38.56958], [-121.71434, 38.56981]]]} Open Access 1 20988 Wildhorse Mini Park 27515 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 1.015 Wildhorse MP 0 Local Park 2 4
10891 10891 10890 {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75124, 38.54744], [-121.75127, 38.54762]]]} Open Access 1 21022 College Park 17507 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 0.816 College Park 0 Local Park 2 4
10920 10920 10919 {"type": "Polygon", "coordinates": [[[-121.73627, 38.55082], [-121.73586, 38.55084], [-121.73586, 38.54976], [-121.73598, 38.55013], [-121.73622, 38.55068], [-121.73627, 38.55082]]]} Open Access 1 21006 Cedar Park 16997 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 0.504 Cedar Park 0 Local Park 2 4
10931 10931 10930 {"type": "Polygon", "coordinates": [[[-121.7307, 38.55559], [-121.73068, 38.55666], [-121.73065, 38.557], [-121.72907, 38.55708], [-121.72892, 38.55553], [-121.7307, 38.55559]]]} Open Access 1 20953 Chestnut Park 17181 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 5.973 Chestnut Park 0 Local Park 2 4
10932 10932 10931 {"type": "Polygon", "coordinates": [[[-121.7502, 38.56635], [-121.74882, 38.56689], [-121.74845, 38.56575], [-121.74862, 38.56571], [-121.74873, 38.56563], [-121.7488, 38.56567], [-121.74882, 38.56566], [-121.74864, 38.56511], [-121.74926, 38.56487], [-121.7502, 38.56635]]]} Open Access 1 20957 Covell Park 17723 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 4.726 Covell Park 0 Local Park 2 4
10934 10934 10933 {"type": "Polygon", "coordinates": [[[-121.7412, 38.54418], [-121.74079, 38.54425], [-121.74073, 38.54406], [-121.74114, 38.54399], [-121.7412, 38.54418]]]} Open Access 1 20959 E Street Plaza 18332 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 0.202 E Street Plaza 0 Local Park 2 4
10937 10937 10936 {"type": "Polygon", "coordinates": [[[-121.70625, 38.56117], [-121.70584, 38.5615], [-121.70564, 38.56159], [-121.7054, 38.56162], [-121.70517, 38.56161], [-121.70505, 38.5615], [-121.70508, 38.56146], [-121.70508, 38.56137], [-121.70504, 38.56131], [-121.705, 38.5613], [-121.70454, 38.56129], [-121.70447, 38.56125], [-121.70446, 38.56116], [-121.70454, 38.56043], [-121.70457, 38.56039], [-121.70461, 38.56038], [-121.70492, 38.5604], [-121.705, 38.56043], [-121.70504, 38.56049], [-121.70509, 38.56052], [-121.70525, 38.56054], [-121.70531, 38.56052], [-121.70533, 38.56049], [-121.70535, 38.56039], [-121.70531, 38.56034], [-121.70536, 38.56029], [-121.70552, 38.5597], [-121.70551, 38.55965], [-121.70556, 38.55964], [-121.70559, 38.55961], [-121.7056, 38.55951], [-121.7058, 38.55952], [-121.70594, 38.55976], [-121.70611, 38.56009], [-121.70586, 38.5602], [-121.70582, 38.56025], [-121.70582, 38.56032], [-121.70587, 38.5604], [-121.70608, 38.56093], [-121.70625, 38.56117]]]} Open Access 1 20965 La Playa Park 20791 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 4.871 La Playa Park 0 Local Park 2 4
10938 10938 10937 {"type": "Polygon", "coordinates": [[[-121.74467, 38.5606], [-121.74332, 38.56059], [-121.74294, 38.55937], [-121.74458, 38.55939], [-121.74465, 38.55962], [-121.74468, 38.55985], [-121.74467, 38.5606]]]} Open Access 1 20966 Little League Park 21347 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 4.447 Little League Park 0 Local Park 2 4
10939 10939 10938 {"type": "Polygon", "coordinates": [[[-121.7125, 38.55627], [-121.71249, 38.55712], [-121.71176, 38.55711], [-121.71159, 38.55713], [-121.7114, 38.55717], [-121.71121, 38.55725], [-121.71103, 38.55735], [-121.71088, 38.5575], [-121.71077, 38.55763], [-121.70966, 38.55707], [-121.70906, 38.55765], [-121.70724, 38.55854], [-121.70701, 38.55843], [-121.70733, 38.55668], [-121.70886, 38.55584], [-121.70871, 38.55491], [-121.70929, 38.55485], [-121.70937, 38.55528], [-121.71093, 38.55512], [-121.71103, 38.55531], [-121.71099, 38.55542], [-121.71122, 38.55563], [-121.71114, 38.55571], [-121.71107, 38.55582], [-121.71074, 38.55572], [-121.71068, 38.55591], [-121.71064, 38.55609], [-121.71063, 38.55628], [-121.71094, 38.55653], [-121.71137, 38.55652], [-121.71233, 38.55654], [-121.71234, 38.55626], [-121.7125, 38.55627]]]} Open Access 1 20967 Mace Ranch Park 21627 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 21.219 Mace Ranch Park 0 Local Park 2 4
10940 10940 10939 {"type": "Polygon", "coordinates": [[[-121.75437, 38.57126], [-121.75434, 38.57201], [-121.75417, 38.57211], [-121.75416, 38.57206], [-121.75411, 38.572], [-121.75405, 38.57196], [-121.75397, 38.57194], [-121.75099, 38.57192], [-121.75088, 38.572], [-121.75088, 38.57225], [-121.75078, 38.57229], [-121.75072, 38.57235], [-121.75037, 38.57235], [-121.75027, 38.57243], [-121.75027, 38.57253], [-121.74977, 38.57253], [-121.74938, 38.57259], [-121.74924, 38.57303], [-121.74858, 38.57314], [-121.74857, 38.57315], [-121.74759, 38.5733], [-121.74751, 38.57329], [-121.74751, 38.57327], [-121.74742, 38.57323], [-121.74736, 38.57317], [-121.74733, 38.57311], [-121.74697, 38.57196], [-121.74677, 38.57078], [-121.74671, 38.57055], [-121.74978, 38.56995], [-121.75015, 38.57109], [-121.75437, 38.57126]]]} Open Access 1 20970 Northstar Park 22893 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 29.24 Northstar Park 0 Local Park 2 4
10942 10942 10941 {"type": "Polygon", "coordinates": [[[-121.76656, 38.5479], [-121.76567, 38.54789], [-121.76516, 38.54781], [-121.76502, 38.54815], [-121.76448, 38.54798], [-121.76444, 38.54796], [-121.76443, 38.54793], [-121.76461, 38.54748], [-121.76465, 38.54747], [-121.76489, 38.54747], [-121.76495, 38.54745], [-121.765, 38.54741], [-121.76503, 38.54735], [-121.76504, 38.54722], [-121.76503, 38.54718], [-121.7657, 38.54695], [-121.7657, 38.54714], [-121.76625, 38.54714], [-121.76652, 38.54765], [-121.76645, 38.54771], [-121.76644, 38.54779], [-121.76646, 38.54782], [-121.76654, 38.54786], [-121.76656, 38.5479]]]} Open Access 1 20974 Oxford Circle Park 23280 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 3.34 Oxford Circle Park 0 Local Park 2 4
10943 10943 10942 {"type": "Polygon", "coordinates": [[[-121.71025, 38.54282], [-121.70863, 38.54241], [-121.70861, 38.54232], [-121.70916, 38.54214], [-121.71012, 38.54174], [-121.71025, 38.54282]]]} Open Access 1 20976 Putah Creek Park 24034 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 2.137 Putah Creek Park 0 Local Park 2 4
10944 10944 10943 {"type": "Polygon", "coordinates": [[[-121.7202, 38.56537], [-121.72018, 38.56551], [-121.71987, 38.56636], [-121.71943, 38.56628], [-121.71944, 38.56622], [-121.71942, 38.56618], [-121.71932, 38.56611], [-121.7192, 38.5661], [-121.7187, 38.566], [-121.71823, 38.56594], [-121.71818, 38.5659], [-121.71824, 38.56561], [-121.71829, 38.56551], [-121.71836, 38.56542], [-121.71878, 38.56499], [-121.71893, 38.56486], [-121.71917, 38.5647], [-121.71945, 38.56458], [-121.71967, 38.56492], [-121.71973, 38.56504], [-121.71977, 38.56507], [-121.71982, 38.56507], [-121.71993, 38.56533], [-121.7202, 38.56537]]]} Open Access 1 20977 Robert Arneson Park 24483 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 4.955 Robert Arneson Park 0 Local Park 2 4
10945 10945 10944 {"type": "Polygon", "coordinates": [[[-121.72868, 38.56856], [-121.72865, 38.56862], [-121.72737, 38.56958], [-121.72715, 38.56937], [-121.72692, 38.56907], [-121.72654, 38.56832], [-121.72653, 38.56822], [-121.72646, 38.56814], [-121.72675, 38.56798], [-121.72678, 38.56792], [-121.72686, 38.56792], [-121.72697, 38.56786], [-121.72699, 38.56783], [-121.72707, 38.56785], [-121.72761, 38.5677], [-121.7278, 38.56798], [-121.72806, 38.56823], [-121.72833, 38.56841], [-121.72868, 38.56856]]]} Open Access 1 20978 Sandy Motley Park 25026 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 5.251 Sandy Motley Park 0 Local Park 2 4
10946 10946 10945 {"type": "Polygon", "coordinates": [[[-121.71743, 38.56174], [-121.71741, 38.56177], [-121.71737, 38.56179], [-121.71547, 38.56196], [-121.71531, 38.56018], [-121.71557, 38.56015], [-121.7155, 38.55939], [-121.71732, 38.55928], [-121.71749, 38.56118], [-121.71748, 38.56135], [-121.71743, 38.56159], [-121.71743, 38.56174]]]} Open Access 1 20979 Slide Hill Park 25557 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 12.025 Slide Hill Park 0 Local Park 2 4
10947 10947 10946 {"type": "Polygon", "coordinates": [[[-121.73051, 38.54687], [-121.73035, 38.5469], [-121.73008, 38.54678], [-121.72995, 38.54676], [-121.72953, 38.54675], [-121.72911, 38.54675], [-121.72907, 38.54672], [-121.72877, 38.54679], [-121.72877, 38.54684], [-121.72873, 38.5469], [-121.72861, 38.54694], [-121.72851, 38.54693], [-121.72841, 38.54688], [-121.72781, 38.54701], [-121.72765, 38.54694], [-121.72759, 38.54688], [-121.72764, 38.54646], [-121.72756, 38.54626], [-121.72771, 38.54622], [-121.72773, 38.54643], [-121.7277, 38.54667], [-121.72771, 38.54683], [-121.72777, 38.5469], [-121.72784, 38.54691], [-121.72798, 38.54689], [-121.72798, 38.54681], [-121.72837, 38.54675], [-121.72845, 38.54667], [-121.72854, 38.54665], [-121.72867, 38.54667], [-121.72876, 38.54673], [-121.72905, 38.54663], [-121.72899, 38.5462], [-121.73041, 38.54597], [-121.73051, 38.54597], [-121.73051, 38.54687]]]} Open Access 1 20981 Toad Hollow Dog Park 26379 1081 Davis, City of 171 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 1081 Davis, City of 167 City 2 City Agency 2   Yolo 33 3.147 Toad Hollow Dog Park 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]);