units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, ACRES = "789.666" and MNG_AG_TYP = 7

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
5921 5921 5920 {"type": "MultiPolygon", "coordinates": [[[[-122.276, 37.30183], [-122.27573, 37.30217], [-122.2755, 37.30251], [-122.27542, 37.30257], [-122.27533, 37.3026], [-122.27518, 37.30259], [-122.27496, 37.3025], [-122.27478, 37.30245], [-122.2746, 37.30242], [-122.27433, 37.3024], [-122.27406, 37.30231], [-122.27392, 37.30228], [-122.27372, 37.30228], [-122.27341, 37.30236], [-122.27322, 37.30237], [-122.27286, 37.30233], [-122.27273, 37.30229], [-122.27265, 37.30225], [-122.27252, 37.30213], [-122.27211, 37.30152], [-122.27205, 37.3014], [-122.27195, 37.30111], [-122.27184, 37.30093], [-122.27103, 37.30005], [-122.27092, 37.29985], [-122.27081, 37.29972], [-122.2707, 37.29965], [-122.27058, 37.2996], [-122.27044, 37.29957], [-122.2703, 37.29956], [-122.27015, 37.29957], [-122.27002, 37.29961], [-122.26993, 37.29966], [-122.26976, 37.29977], [-122.26969, 37.29977], [-122.26962, 37.29976], [-122.26956, 37.2997], [-122.26946, 37.29948], [-122.26933, 37.29936], [-122.26919, 37.29929], [-122.26898, 37.29924], [-122.26881, 37.29916], [-122.26783, 37.29855], [-122.26774, 37.29843], [-122.26755, 37.29803], [-122.26745, 37.2979], [-122.26734, 37.2978], [-122.26712, 37.29767], [-122.26697, 37.29762], [-122.26673, 37.29756], [-122.26659, 37.29747], [-122.26653, 37.2974], [-122.26651, 37.29731], [-122.26648, 37.29635], [-122.26643, 37.29621], [-122.26634, 37.29606], [-122.26617, 37.2959], [-122.266, 37.2958], [-122.2658, 37.29573], [-122.26565, 37.2957], [-122.26545, 37.29569], [-122.26511, 37.29573], [-122.26484, 37.29583], [-122.26472, 37.29591], [-122.26459, 37.29601], [-122.26454, 37.29608], [-122.26452, 37.29615], [-122.26441, 37.29678], [-122.26441, 37.2969], [-122.26444, 37.297], [-122.26448, 37.29709], [-122.26456, 37.29719], [-122.26501, 37.29761], [-122.26535, 37.29785], [-122.26571, 37.29804], [-122.26582, 37.29814], [-122.2659, 37.29822], [-122.26707, 37.3001], [-122.26732, 37.3004], [-122.26762, 37.30066], [-122.26763, 37.30072], [-122.26762, 37.30077], [-122.26758, 37.30082], [-122.26752, 37.30086], [-122.26742, 37.30087], [-122.26733, 37.30084], [-122.26716, 37.3006], [-122.26707, 37.30051], [-122.26696, 37.30044], [-122.26663, 37.30027], [-122.26643, 37.2998], [-122.26635, 37.29973], [-122.26605, 37.29984], [-122.26575, 37.29961], [-122.26605, 37.29946], [-122.26586, 37.29933], [-122.26564, 37.29952], [-122.26546, 37.29939], [-122.26527, 37.29931], [-122.26508, 37.29928], [-122.26484, 37.29929], [-122.26494, 37.2992], [-122.2648, 37.29881], [-122.2646, 37.29865], [-122.26457, 37.29856], [-122.26511, 37.29829], [-122.26512, 37.2984], [-122.26524, 37.29849], [-122.26536, 37.29843], [-122.26538, 37.29841], [-122.26552, 37.29853], [-122.26542, 37.29864], [-122.26552, 37.29873], [-122.26549, 37.29885], [-122.26578, 37.29871], [-122.26576, 37.29841], [-122.26545, 37.29827], [-122.26549, 37.29817], [-122.26531, 37.29806], [-122.26509, 37.29827], [-122.26502, 37.2982], [-122.26452, 37.29841], [-122.26451, 37.2984], [-122.26428, 37.29861], [-122.2641, 37.29869], [-122.26409, 37.29861], [-122.26399, 37.29841], [-122.264, 37.29835], [-122.26365, 37.29842], [-122.26363, 37.29845], [-122.26366, 37.29853], [-122.26356, 37.29863], [-122.2635, 37.29861], [-122.26339, 37.29861], [-122.26332, 37.29858], [-122.26338, 37.29851], [-122.26362, 37.29841], [-122.26362, 37.29837], [-122.26346, 37.29842], [-122.2631, 37.29842], [-122.2632, 37.29869], [-122.26287, 37.29853], [-122.26285, 37.2985], [-122.26301, 37.29838], [-122.2631, 37.29841], [-122.26314, 37.29835], [-122.26323, 37.29811], [-122.26312, 37.29801], [-122.2625, 37.29782], [-122.26242, 37.29774], [-122.26248, 37.29757], [-122.26238, 37.29751], [-122.26201, 37.29712], [-122.26192, 37.29694], [-122.26173, 37.2969], [-122.26147, 37.29705], [-122.26152, 37.29714], [-122.26132, 37.29721], [-122.26133, 37.29738], [-122.26106, 37.29744], [-122.26076, 37.29736], [-122.26044, 37.29692], [-122.26001, 37.29684], [-122.26003, 37.2967], [-122.25968, 37.29659], [-122.25966, 37.29614], [-122.25948, 37.29613], [-122.25946, 37.29662], [-122.25915, 37.29688], [-122.25911, 37.29689], [-122.25912, 37.29698], [-122.259, 37.297], [-122.25866, 37.29689], [-122.25833, 37.29657], [-122.25771, 37.29717], [-122.25695, 37.29701], [-122.25652, 37.29649], [-122.2557, 37.29688], [-122.25544, 37.29738], [-122.25534, 37.29737], [-122.25516, 37.29744], [-122.25405, 37.29753], [-122.25319, 37.29749], [-122.25287, 37.2975], [-122.25207, 37.29762], [-122.25205, 37.2976], [-122.25191, 37.29765], [-122.25171, 37.29764], [-122.25152, 37.29751], [-122.25126, 37.29746], [-122.25111, 37.29736], [-122.25091, 37.29732], [-122.25091, 37.29727], [-122.2505, 37.2972], [-122.25047, 37.29726], [-122.24989, 37.29712], [-122.24974, 37.29711], [-122.24963, 37.29708], [-122.24951, 37.29703], [-122.2494, 37.29696], [-122.24935, 37.29699], [-122.24893, 37.29666], [-122.24891, 37.29666], [-122.2489, 37.29678], [-122.2486, 37.29655], [-122.2482, 37.29664], [-122.2478, 37.29637], [-122.24705, 37.29631], [-122.24651, 37.29648], [-122.24502, 37.29565], [-122.24481, 37.29526], [-122.24422, 37.29492], [-122.24422, 37.29408], [-122.2465, 37.29406], [-122.24645, 37.29052], [-122.25513, 37.29051], [-122.25515, 37.28688], [-122.25967, 37.28689], [-122.2596, 37.2905], [-122.26854, 37.29052], [-122.26856, 37.29412], [-122.27296, 37.29416], [-122.27302, 37.30144], [-122.276, 37.30183]], [[-122.26419, 37.29782], [-122.26444, 37.29761], [-122.26397, 37.29726], [-122.26368, 37.29711], [-122.26382, 37.29698], [-122.26356, 37.2968], [-122.26346, 37.29666], [-122.26323, 37.29678], [-122.26326, 37.29685], [-122.26292, 37.29702], [-122.263, 37.29717], [-122.26316, 37.29715], [-122.26322, 37.29728], [-122.26357, 37.29731], [-122.26382, 37.29726], [-122.26358, 37.29762], [-122.26276, 37.29731], [-122.26248, 37.29756], [-122.26316, 37.29796], [-122.26353, 37.29807], [-122.26368, 37.29809], [-122.26392, 37.29817], [-122.2642, 37.29784], [-122.26419, 37.29782]]], [[[-122.28634, 37.31308], [-122.28624, 37.3131], [-122.28603, 37.31318], [-122.2859, 37.31314], [-122.28573, 37.31314], [-122.28556, 37.31308], [-122.28543, 37.31299], [-122.28521, 37.31291], [-122.28465, 37.31286], [-122.2848, 37.31252], [-122.28474, 37.31228], [-122.28474, 37.31218], [-122.28285, 37.31128], [-122.28258, 37.31141], [-122.28224, 37.31141], [-122.28222, 37.31128], [-122.28219, 37.31117], [-122.28207, 37.31099], [-122.28189, 37.31083], [-122.28166, 37.31072], [-122.28142, 37.31066], [-122.28118, 37.31066], [-122.28098, 37.31069], [-122.28071, 37.31078], [-122.28091, 37.31066], [-122.28046, 37.3101], [-122.27966, 37.30991], [-122.27918, 37.30966], [-122.27827, 37.30967], [-122.27792, 37.30949], [-122.27759, 37.30941], [-122.27746, 37.30911], [-122.27744, 37.30912], [-122.27743, 37.30972], [-122.2774, 37.30972], [-122.27738, 37.30987], [-122.27734, 37.30999], [-122.27745, 37.31015], [-122.27745, 37.31025], [-122.27724, 37.31026], [-122.27713, 37.31029], [-122.27719, 37.31045], [-122.27717, 37.31053], [-122.27703, 37.31061], [-122.27677, 37.31065], [-122.27657, 37.31055], [-122.27647, 37.31031], [-122.27633, 37.31035], [-122.27636, 37.31001], [-122.27642, 37.30983], [-122.27659, 37.30956], [-122.27692, 37.3093], [-122.2765, 37.30906], [-122.2764, 37.3091], [-122.27639, 37.30899], [-122.2762, 37.30892], [-122.27609, 37.30876], [-122.27616, 37.30876], [-122.27617, 37.30875], [-122.27601, 37.30837], [-122.27578, 37.30846], [-122.2756, 37.30845], [-122.27564, 37.30837], [-122.27563, 37.30836], [-122.27526, 37.30839], [-122.27489, 37.30865], [-122.275, 37.3089], [-122.27482, 37.30912], [-122.27475, 37.30882], [-122.27465, 37.3089], [-122.27426, 37.30874], [-122.27405, 37.30834], [-122.27422, 37.30785], [-122.27401, 37.30738], [-122.27376, 37.3074], [-122.27372, 37.30781], [-122.27345, 37.30794], [-122.27319, 37.30788], [-122.27291, 37.30736], [-122.273, 37.30719], [-122.2727, 37.30692], [-122.27282, 37.30666], [-122.27246, 37.30663], [-122.27231, 37.30707], [-122.27182, 37.30683], [-122.27124, 37.30705], [-122.27107, 37.30663], [-122.27116, 37.30646], [-122.27147, 37.30639], [-122.27154, 37.30601], [-122.27115, 37.30582], [-122.27079, 37.30571], [-122.27051, 37.30615], [-122.27032, 37.30623], [-122.27009, 37.30611], [-122.26971, 37.30637], [-122.26965, 37.30637], [-122.26942, 37.3062], [-122.26928, 37.30605], [-122.2693, 37.30579], [-122.26926, 37.30576], [-122.2696, 37.30551], [-122.26916, 37.30456], [-122.26874, 37.30466], [-122.26866, 37.30459], [-122.26868, 37.30457], [-122.26829, 37.30418], [-122.26838, 37.30383], [-122.26829, 37.30381], [-122.26844, 37.30341], [-122.26833, 37.30317], [-122.26838, 37.30308], [-122.26806, 37.30291], [-122.2677, 37.30306], [-122.26745, 37.30279], [-122.26752, 37.30254], [-122.26776, 37.30191], [-122.26761, 37.30177], [-122.26661, 37.30158], [-122.26646, 37.30136], [-122.26651, 37.30129], [-122.2667, 37.30132], [-122.26691, 37.30125], [-122.26726, 37.30095], [-122.26737, 37.30099], [-122.26747, 37.301], [-122.26759, 37.30098], [-122.26768, 37.30094], [-122.26776, 37.30087], [-122.26781, 37.3008], [-122.26784, 37.30071], [-122.26782, 37.30061], [-122.26773, 37.30051], [-122.26751, 37.30037], [-122.26746, 37.30031], [-122.26722, 37.30003], [-122.26675, 37.29926], [-122.26606, 37.29818], [-122.26599, 37.29809], [-122.26577, 37.29791], [-122.2655, 37.29777], [-122.26518, 37.29755], [-122.26465, 37.29705], [-122.26459, 37.29693], [-122.26458, 37.29681], [-122.26468, 37.29622], [-122.26473, 37.29611], [-122.26485, 37.296], [-122.26502, 37.29591], [-122.26522, 37.29585], [-122.26539, 37.29583], [-122.26559, 37.29583], [-122.26576, 37.29586], [-122.26592, 37.29592], [-122.26607, 37.29602], [-122.26622, 37.29617], [-122.26631, 37.29637], [-122.26632, 37.29733], [-122.26635, 37.29746], [-122.26645, 37.29759], [-122.26663, 37.2977], [-122.26696, 37.29779], [-122.26717, 37.29791], [-122.26729, 37.298], [-122.26736, 37.29809], [-122.26755, 37.29851], [-122.26769, 37.29867], [-122.26869, 37.2993], [-122.26886, 37.29937], [-122.26911, 37.29944], [-122.26918, 37.29947], [-122.26924, 37.29952], [-122.26939, 37.29976], [-122.26956, 37.29991], [-122.26966, 37.29994], [-122.26977, 37.29994], [-122.27001, 37.29985], [-122.27015, 37.29977], [-122.2703, 37.29974], [-122.27051, 37.29977], [-122.27067, 37.29985], [-122.27075, 37.29992], [-122.27084, 37.30009], [-122.27093, 37.30021], [-122.27174, 37.30107], [-122.27184, 37.30127], [-122.27189, 37.30146], [-122.27231, 37.30217], [-122.27244, 37.3023], [-122.27264, 37.30241], [-122.27282, 37.30247], [-122.27324, 37.3025], [-122.2734, 37.30249], [-122.27367, 37.30243], [-122.27387, 37.30243], [-122.27427, 37.30253], [-122.27472, 37.30259], [-122.27492, 37.30266], [-122.27514, 37.30275], [-122.27535, 37.30277], [-122.27552, 37.30273], [-122.27565, 37.30263], [-122.27618, 37.30196], [-122.27623, 37.30187], [-122.27717, 37.30201], [-122.28619, 37.30551], [-122.28634, 37.31308]]]]} Open Access 1 353 Sam McDonald Park 11486 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7 http://www.co.sanmateo.ca.us/portal/site/parks/ County 3 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7 https://parks.smcgov.org/sam-mcdonald-park San Mateo 15 789.666 Sam McDonald Park 2000 Local Park 2 4

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]);