calands: units_with_maps: 1 row where LABEL_NAME = "Modesto Reservoir RP", MNG_AGENCY = 497 and MNG_AG

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

1 row where LABEL_NAME = "Modesto Reservoir RP", MNG_AGENCY = 497 and MNG_AG_TYP = 3

Search:

descending

This data as json, copyable, CSV (advanced)

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
10323	10323	10322	{"type": "Polygon", "coordinates": [[[-120.68205, 37.67455], [-120.67736, 37.67455], [-120.67736, 37.67558], [-120.67741, 37.67825], [-120.67518, 37.67824], [-120.67519, 37.68188], [-120.67398, 37.68188], [-120.67398, 37.6819], [-120.67442, 37.68218], [-120.6745, 37.68229], [-120.67451, 37.68242], [-120.6744, 37.68258], [-120.6739, 37.68288], [-120.67352, 37.68299], [-120.67323, 37.68311], [-120.67298, 37.68325], [-120.67203, 37.68433], [-120.6718, 37.6847], [-120.67146, 37.68535], [-120.67122, 37.68569], [-120.67116, 37.68596], [-120.6712, 37.68672], [-120.67114, 37.6872], [-120.67099, 37.68754], [-120.67084, 37.68774], [-120.67035, 37.68814], [-120.67004, 37.68846], [-120.66972, 37.6889], [-120.66958, 37.68918], [-120.66956, 37.6897], [-120.66994, 37.6903], [-120.67004, 37.69055], [-120.67008, 37.69083], [-120.67001, 37.69099], [-120.66928, 37.69167], [-120.66808, 37.69174], [-120.66739, 37.69174], [-120.66739, 37.69278], [-120.66397, 37.69277], [-120.66393, 37.68879], [-120.66371, 37.68866], [-120.66305, 37.68848], [-120.6632, 37.68837], [-120.66359, 37.68821], [-120.66374, 37.68803], [-120.66379, 37.68778], [-120.66389, 37.68761], [-120.66385, 37.6826], [-120.66356, 37.68259], [-120.66329, 37.68255], [-120.66318, 37.68244], [-120.66308, 37.68227], [-120.66309, 37.68213], [-120.66316, 37.68193], [-120.66312, 37.68184], [-120.64583, 37.68186], [-120.62523, 37.68184], [-120.62513, 37.67646], [-120.62923, 37.67646], [-120.62966, 37.67644], [-120.62967, 37.67462], [-120.63536, 37.67461], [-120.63539, 37.67456], [-120.63558, 37.67452], [-120.63612, 37.67433], [-120.6364, 37.67404], [-120.63649, 37.6737], [-120.63597, 37.67359], [-120.63565, 37.67361], [-120.63512, 37.67373], [-120.63473, 37.67379], [-120.63456, 37.67374], [-120.63445, 37.67365], [-120.63451, 37.67358], [-120.63468, 37.67357], [-120.63506, 37.67344], [-120.63513, 37.67339], [-120.6353, 37.67319], [-120.63526, 37.67255], [-120.63553, 37.67214], [-120.63552, 37.67191], [-120.63565, 37.67176], [-120.63585, 37.67192], [-120.63585, 37.67207], [-120.63591, 37.67229], [-120.63604, 37.67245], [-120.63626, 37.67257], [-120.63661, 37.67262], [-120.63676, 37.67267], [-120.63711, 37.67267], [-120.63751, 37.67263], [-120.63818, 37.67226], [-120.63828, 37.67216], [-120.63833, 37.67201], [-120.63832, 37.67184], [-120.63827, 37.67172], [-120.63815, 37.67156], [-120.63775, 37.67121], [-120.63769, 37.67107], [-120.63776, 37.67098], [-120.63788, 37.67092], [-120.63803, 37.67095], [-120.63831, 37.67106], [-120.63907, 37.67097], [-120.63962, 37.67123], [-120.64021, 37.67127], [-120.6403, 37.67124], [-120.6405, 37.6711], [-120.64054, 37.67096], [-120.64052, 37.67071], [-120.64011, 37.67022], [-120.63979, 37.66988], [-120.63962, 37.66977], [-120.63933, 37.6697], [-120.63903, 37.66975], [-120.63874, 37.66975], [-120.63865, 37.66971], [-120.63861, 37.66964], [-120.63863, 37.66954], [-120.63874, 37.66933], [-120.63884, 37.66908], [-120.63891, 37.66883], [-120.63893, 37.66831], [-120.63904, 37.66798], [-120.63915, 37.66779], [-120.63949, 37.66761], [-120.64009, 37.66747], [-120.64045, 37.66729], [-120.64079, 37.66717], [-120.64104, 37.66722], [-120.64116, 37.66727], [-120.64129, 37.66744], [-120.64142, 37.66769], [-120.64159, 37.66776], [-120.64177, 37.66775], [-120.64203, 37.6675], [-120.6423, 37.66737], [-120.64308, 37.6673], [-120.6438, 37.66702], [-120.64434, 37.6671], [-120.64479, 37.66706], [-120.64505, 37.6667], [-120.64533, 37.66664], [-120.64519, 37.66601], [-120.64523, 37.66595], [-120.6456, 37.66584], [-120.64575, 37.66586], [-120.64576, 37.66585], [-120.64575, 37.66196], [-120.64545, 37.66188], [-120.6451, 37.66184], [-120.64502, 37.66186], [-120.64478, 37.66202], [-120.64469, 37.66205], [-120.64386, 37.6619], [-120.64382, 37.66185], [-120.6438, 37.66179], [-120.64414, 37.66152], [-120.64473, 37.6611], [-120.64502, 37.66076], [-120.64507, 37.66059], [-120.64507, 37.66048], [-120.64479, 37.66018], [-120.64431, 37.65999], [-120.64292, 37.65998], [-120.64218, 37.66017], [-120.64208, 37.66025], [-120.64183, 37.66063], [-120.64104, 37.6611], [-120.64054, 37.66201], [-120.63997, 37.66228], [-120.63928, 37.6622], [-120.63886, 37.66223], [-120.6388, 37.66219], [-120.6388, 37.66211], [-120.63947, 37.66158], [-120.63969, 37.66113], [-120.63971, 37.66072], [-120.64049, 37.65999], [-120.6407, 37.65997], [-120.64083, 37.65987], [-120.64085, 37.65968], [-120.64103, 37.65937], [-120.63633, 37.65935], [-120.63635, 37.65899], [-120.63617, 37.65893], [-120.63524, 37.65842], [-120.6346, 37.65819], [-120.63388, 37.65827], [-120.6337, 37.65832], [-120.63321, 37.65859], [-120.63296, 37.65881], [-120.63246, 37.65943], [-120.63237, 37.65993], [-120.63239, 37.6602], [-120.6323, 37.66023], [-120.63169, 37.66015], [-120.6306, 37.66049], [-120.62969, 37.66069], [-120.6291, 37.66093], [-120.62875, 37.66135], [-120.62874, 37.66178], [-120.62909, 37.66273], [-120.62961, 37.66336], [-120.62973, 37.66374], [-120.63013, 37.66411], [-120.63026, 37.66429], [-120.63031, 37.66445], [-120.63014, 37.66462], [-120.62988, 37.66477], [-120.62965, 37.66444], [-120.6295, 37.66406], [-120.62842, 37.66289], [-120.62825, 37.6621], [-120.62823, 37.66196], [-120.62808, 37.66155], [-120.62777, 37.66123], [-120.62758, 37.66111], [-120.62712, 37.66094], [-120.62695, 37.6609], [-120.6266, 37.6609], [-120.62611, 37.66077], [-120.62578, 37.66066], [-120.62557, 37.66062], [-120.62487, 37.66056], [-120.62484, 37.65895], [-120.6252, 37.65899], [-120.62536, 37.65895], [-120.62534, 37.65817], [-120.62576, 37.65816], [-120.62652, 37.65558], [-120.62642, 37.6547], [-120.62656, 37.65397], [-120.62701, 37.65325], [-120.6278, 37.65274], [-120.63563, 37.65274], [-120.63565, 37.65266], [-120.63587, 37.6523], [-120.63583, 37.65199], [-120.63559, 37.65167], [-120.63529, 37.65151], [-120.63504, 37.65126], [-120.63484, 37.65113], [-120.63467, 37.65115], [-120.63461, 37.65118], [-120.63456, 37.65126], [-120.63452, 37.65143], [-120.63442, 37.65153], [-120.63409, 37.65162], [-120.63379, 37.65179], [-120.63364, 37.65189], [-120.63333, 37.65235], [-120.63327, 37.65242], [-120.63315, 37.65249], [-120.63312, 37.65242], [-120.63319, 37.65222], [-120.63316, 37.65195], [-120.63303, 37.65153], [-120.63291, 37.65134], [-120.6328, 37.65125], [-120.63267, 37.65117], [-120.63225, 37.65122], [-120.63217, 37.65126], [-120.63202, 37.65138], [-120.63159, 37.65165], [-120.63152, 37.65154], [-120.63132, 37.65134], [-120.63115, 37.65124], [-120.63084, 37.65114], [-120.63062, 37.65113], [-120.62993, 37.6512], [-120.6294, 37.65139], [-120.62901, 37.65157], [-120.6283, 37.65204], [-120.62817, 37.65209], [-120.628, 37.65213], [-120.62794, 37.65206], [-120.62796, 37.65191], [-120.6281, 37.65161], [-120.62811, 37.65117], [-120.62838, 37.65114], [-120.62848, 37.65106], [-120.6286, 37.65091], [-120.62863, 37.65078], [-120.6286, 37.65038], [-120.62842, 37.64975], [-120.62828, 37.64952], [-120.62823, 37.64947], [-120.62804, 37.64907], [-120.62768, 37.64815], [-120.62737, 37.64684], [-120.62724, 37.64661], [-120.62711, 37.64645], [-120.62692, 37.64631], [-120.62657, 37.64623], [-120.62639, 37.64622], [-120.62527, 37.64661], [-120.62499, 37.64665], [-120.62406, 37.6467], [-120.62367, 37.64661], [-120.62318, 37.64655], [-120.62206, 37.64661], [-120.62142, 37.64659], [-120.62059, 37.64653], [-120.62031, 37.64649], [-120.6198, 37.64617], [-120.61938, 37.64595], [-120.61914, 37.6459], [-120.61487, 37.64591], [-120.61426, 37.64599], [-120.61394, 37.64606], [-120.6136, 37.64618], [-120.61218, 37.64685], [-120.61116, 37.64745], [-120.6112, 37.64689], [-120.61189, 37.6465], [-120.61308, 37.64595], [-120.61368, 37.64482], [-120.61423, 37.64411], [-120.61519, 37.64354], [-120.6161, 37.64334], [-120.61796, 37.64328], [-120.63792, 37.64247], [-120.63921, 37.64228], [-120.64255, 37.6421], [-120.64258, 37.64218], [-120.64355, 37.64213], [-120.64392, 37.64216], [-120.64425, 37.64219], [-120.64456, 37.64226], [-120.64474, 37.64233], [-120.64568, 37.64273], [-120.64549, 37.64313], [-120.64509, 37.64302], [-120.64424, 37.64266], [-120.64346, 37.64258], [-120.6162, 37.64377], [-120.61547, 37.64389], [-120.61463, 37.64438], [-120.61418, 37.64496], [-120.61391, 37.64551], [-120.61933, 37.64553], [-120.61959, 37.64563], [-120.62046, 37.64607], [-120.62074, 37.64615], [-120.62256, 37.64624], [-120.62287, 37.64624], [-120.62354, 37.64617], [-120.62373, 37.64621], [-120.62399, 37.64631], [-120.62443, 37.64636], [-120.62477, 37.6463], [-120.62521, 37.64616], [-120.62565, 37.64609], [-120.62644, 37.64578], [-120.62674, 37.64577], [-120.62694, 37.64584], [-120.62725, 37.64602], [-120.62746, 37.64621], [-120.6276, 37.64638], [-120.62789, 37.64698], [-120.62794, 37.64723], [-120.6293, 37.64723], [-120.62931, 37.64722], [-120.62927, 37.64553], [-120.63062, 37.64552], [-120.63107, 37.64654], [-120.63451, 37.64645], [-120.6372, 37.64707], [-120.63756, 37.64724], [-120.63861, 37.64829], [-120.63992, 37.64885], [-120.63994, 37.64965], [-120.64045, 37.64965], [-120.64068, 37.64968], [-120.64176, 37.64992], [-120.64244, 37.65021], [-120.6427, 37.65034], [-120.64288, 37.65047], [-120.64329, 37.65082], [-120.64394, 37.65172], [-120.64422, 37.65199], [-120.6444, 37.65212], [-120.64456, 37.65219], [-120.64478, 37.65219], [-120.64542, 37.65213], [-120.64585, 37.65201], [-120.64603, 37.65207], [-120.64611, 37.65228], [-120.6465, 37.65252], [-120.64673, 37.65269], [-120.64688, 37.6529], [-120.64691, 37.65304], [-120.64689, 37.65321], [-120.64691, 37.65341], [-120.64679, 37.65381], [-120.64677, 37.65414], [-120.64689, 37.65429], [-120.64708, 37.65437], [-120.64722, 37.65436], [-120.64784, 37.65421], [-120.64793, 37.65421], [-120.64804, 37.65426], [-120.64809, 37.65433], [-120.64803, 37.65443], [-120.64765, 37.65468], [-120.64766, 37.65477], [-120.64928, 37.65562], [-120.65001, 37.65742], [-120.65099, 37.65745], [-120.65179, 37.65599], [-120.65273, 37.65664], [-120.6509, 37.65802], [-120.65102, 37.65813], [-120.65274, 37.65683], [-120.654, 37.65761], [-120.65903, 37.6576], [-120.65901, 37.65789], [-120.65918, 37.65796], [-120.65934, 37.65814], [-120.65943, 37.65818], [-120.65967, 37.65815], [-120.65981, 37.65808], [-120.66, 37.65789], [-120.6601, 37.65784], [-120.66021, 37.65787], [-120.66025, 37.65791], [-120.66026, 37.65821], [-120.66044, 37.65834], [-120.66099, 37.65832], [-120.66107, 37.65836], [-120.6611, 37.65844], [-120.66103, 37.65862], [-120.66096, 37.65868], [-120.66091, 37.65883], [-120.66094, 37.65891], [-120.66107, 37.65904], [-120.66123, 37.65908], [-120.66183, 37.65903], [-120.66219, 37.65905], [-120.66244, 37.65908], [-120.6628, 37.65921], [-120.66318, 37.65927], [-120.66388, 37.6592], [-120.66416, 37.65913], [-120.66457, 37.65893], [-120.66477, 37.65878], [-120.66503, 37.65867], [-120.6652, 37.65876], [-120.66525, 37.6589], [-120.66533, 37.65903], [-120.66551, 37.659], [-120.66564, 37.65883], [-120.66564, 37.65865], [-120.66574, 37.6585], [-120.66613, 37.65827], [-120.66668, 37.65806], [-120.66683, 37.65802], [-120.66719, 37.65807], [-120.66792, 37.65837], [-120.66819, 37.65837], [-120.66827, 37.65823], [-120.66817, 37.65804], [-120.6679, 37.6578], [-120.66782, 37.65767], [-120.6678, 37.65755], [-120.66787, 37.65747], [-120.66925, 37.65657], [-120.66944, 37.65654], [-120.66959, 37.65662], [-120.66989, 37.65694], [-120.66998, 37.65695], [-120.67009, 37.65692], [-120.67033, 37.65681], [-120.67045, 37.6567], [-120.67046, 37.65661], [-120.67013, 37.65631], [-120.67009, 37.65625], [-120.67009, 37.65607], [-120.67039, 37.65607], [-120.67052, 37.65609], [-120.67118, 37.65636], [-120.67247, 37.65658], [-120.67277, 37.65654], [-120.67379, 37.65631], [-120.67511, 37.65649], [-120.67543, 37.6565], [-120.67585, 37.65658], [-120.67669, 37.65696], [-120.6769, 37.65696], [-120.67709, 37.65685], [-120.67736, 37.65659], [-120.67746, 37.65655], [-120.67766, 37.65656], [-120.67778, 37.65662], [-120.67817, 37.65689], [-120.67855, 37.65737], [-120.67899, 37.65777], [-120.67962, 37.65854], [-120.6799, 37.6591], [-120.68006, 37.65964], [-120.68008, 37.65991], [-120.68028, 37.66064], [-120.68022, 37.66103], [-120.68023, 37.66164], [-120.68032, 37.66215], [-120.68023, 37.66232], [-120.67999, 37.66251], [-120.67973, 37.66251], [-120.67939, 37.66228], [-120.67901, 37.6621], [-120.67871, 37.66209], [-120.67842, 37.66218], [-120.67798, 37.66244], [-120.67783, 37.66251], [-120.67758, 37.66252], [-120.67742, 37.66246], [-120.67694, 37.66245], [-120.67684, 37.66247], [-120.67667, 37.66256], [-120.67656, 37.66268], [-120.67642, 37.66303], [-120.67641, 37.66314], [-120.67646, 37.66325], [-120.67646, 37.66361], [-120.67649, 37.66369], [-120.67663, 37.66386], [-120.67683, 37.66394], [-120.67763, 37.66393], [-120.67887, 37.66357], [-120.67913, 37.66357], [-120.67944, 37.66361], [-120.67955, 37.66369], [-120.67944, 37.66389], [-120.67857, 37.66408], [-120.67796, 37.66432], [-120.67771, 37.66439], [-120.67731, 37.6644], [-120.677, 37.66443], [-120.6769, 37.66448], [-120.67675, 37.66467], [-120.67668, 37.66487], [-120.67669, 37.66513], [-120.67681, 37.66535], [-120.67692, 37.66551], [-120.68197, 37.66549], [-120.68205, 37.67455]], [[-120.64976, 37.6629], [-120.64966, 37.66284], [-120.64943, 37.6629], [-120.64926, 37.66292], [-120.6493, 37.66369], [-120.64965, 37.66348], [-120.64977, 37.66333], [-120.64988, 37.66305], [-120.64986, 37.66297], [-120.64976, 37.6629]], [[-120.65143, 37.66108], [-120.65141, 37.66104], [-120.65134, 37.66099], [-120.65104, 37.66091], [-120.6511, 37.66069], [-120.65109, 37.66028], [-120.65105, 37.66018], [-120.65089, 37.65998], [-120.64992, 37.65998], [-120.64995, 37.66202], [-120.6501, 37.66198], [-120.65023, 37.66193], [-120.65032, 37.66185], [-120.65036, 37.66177], [-120.65037, 37.66163], [-120.65045, 37.66152], [-120.65059, 37.66148], [-120.65126, 37.66142], [-120.65136, 37.66139], [-120.65144, 37.66129], [-120.65145, 37.66116], [-120.65143, 37.66108]], [[-120.6353, 37.64885], [-120.63538, 37.64896], [-120.63585, 37.6494], [-120.63625, 37.6497], [-120.63621, 37.64725], [-120.63504, 37.64727], [-120.63507, 37.64851], [-120.63524, 37.64872], [-120.6353, 37.64885]]]}	Open Access 1	18182	Modesto Reservoir Regional Park	29282	329	Stanislaus, County of 505	County 3	County Agency 3	http://www.stancounty.com/er/parks/	County 3	329	Stanislaus, County of 497	County 3	County Agency 3	http://www.stancounty.com/ER/PARKS/reservoir.shtm	Stanislaus 2	3240.209	Modesto Reservoir RP	0	Local Park 2	4

Advanced export

JSON shape: default, array, newline-delimited

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