units_with_maps

Table actions

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

17 rows where DES_TP = 2, MNG_AGENCY = 223 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

  • City Agency · 17 ✖

DES_TP 1

  • Local Park · 17 ✖

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
637 637 636 {"type": "Polygon", "coordinates": [[[-122.56171, 37.90549], [-122.56153, 37.90597], [-122.56084, 37.90597], [-122.56053, 37.90588], [-122.5609, 37.9053], [-122.56144, 37.905], [-122.56164, 37.90502], [-122.56165, 37.90534], [-122.56171, 37.90549]]]} Open Access 1 4911 Earnscliff Canyon Park 18357 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.834 Earnscliff Canyon Park 0 Local Park 2 4
767 767 766 {"type": "Polygon", "coordinates": [[[-122.56127, 37.90272], [-122.56111, 37.90294], [-122.56104, 37.90321], [-122.56096, 37.90329], [-122.56054, 37.90341], [-122.56012, 37.90317], [-122.55964, 37.90307], [-122.55927, 37.90288], [-122.559, 37.9024], [-122.55868, 37.90221], [-122.55918, 37.90164], [-122.55976, 37.90179], [-122.55993, 37.90166], [-122.5605, 37.90225], [-122.56127, 37.90272]]]} Open Access 1 5001 Edgewood Park 18441 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 5.983 Edgewood Park 0 Local Park 2 4
769 769 768 {"type": "Polygon", "coordinates": [[[-122.54807, 37.9076], [-122.5477, 37.9077], [-122.54767, 37.90763], [-122.54751, 37.90744], [-122.54733, 37.90731], [-122.54718, 37.90725], [-122.54716, 37.90719], [-122.54716, 37.90716], [-122.54723, 37.90719], [-122.5476, 37.90693], [-122.54792, 37.90723], [-122.54807, 37.9076]]]} Open Access 1 5019 Mill Velley City Park 22237 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.821 Mill Velley City Park 0 Local Park 2 4
842 842 841 {"type": "MultiPolygon", "coordinates": [[[[-122.54096, 37.90615], [-122.54093, 37.90638], [-122.54083, 37.90634], [-122.54085, 37.90616], [-122.54069, 37.90599], [-122.54027, 37.90594], [-122.54011, 37.90602], [-122.54012, 37.90627], [-122.53975, 37.9063], [-122.53916, 37.9065], [-122.53892, 37.90674], [-122.53856, 37.90649], [-122.53811, 37.90567], [-122.53785, 37.90537], [-122.53769, 37.90537], [-122.5378, 37.905], [-122.53838, 37.90496], [-122.53828, 37.90534], [-122.53841, 37.90535], [-122.53885, 37.90385], [-122.53915, 37.90385], [-122.53881, 37.90491], [-122.53912, 37.90581], [-122.5396, 37.90603], [-122.54025, 37.90584], [-122.54057, 37.90586], [-122.54058, 37.90588], [-122.54068, 37.90591], [-122.54079, 37.90589], [-122.54096, 37.90615]]], [[[-122.5387, 37.90385], [-122.53841, 37.90484], [-122.53787, 37.90489], [-122.53792, 37.90474], [-122.53795, 37.90454], [-122.53776, 37.90455], [-122.53771, 37.90435], [-122.53773, 37.90434], [-122.53778, 37.90453], [-122.53808, 37.9045], [-122.53808, 37.9044], [-122.53811, 37.90439], [-122.53807, 37.90384], [-122.5387, 37.90385]]]]} Open Access 1 4948 Boyle Park 16317 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 6.861 Boyle Park 0 Local Park 2 4
847 847 846 {"type": "Polygon", "coordinates": [[[-122.53111, 37.89916], [-122.53088, 37.89927], [-122.53057, 37.89945], [-122.53032, 37.89967], [-122.5302, 37.89979], [-122.53006, 37.89974], [-122.53013, 37.89958], [-122.53076, 37.89894], [-122.53111, 37.89916]]]} Open Access 1 4979 Freeman Park 19092 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.66 Freeman Park 0 Local Park 2 4
898 898 897 {"type": "Polygon", "coordinates": [[[-122.55026, 37.90193], [-122.54988, 37.90234], [-122.54978, 37.90226], [-122.54932, 37.90212], [-122.54961, 37.90158], [-122.5498, 37.90167], [-122.55001, 37.90147], [-122.55005, 37.90145], [-122.55026, 37.90161], [-122.55026, 37.90193]]]} Open Access 1 5020 Kathleen Norris Memorial Park 20558 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.194 Kathleen Norris Memorial Park 0 Local Park 2 4
5515 5515 5514 {"type": "Polygon", "coordinates": [[[-122.54264, 37.89884], [-122.54239, 37.89959], [-122.54216, 37.89953], [-122.54189, 37.89917], [-122.54212, 37.89887], [-122.54206, 37.89874], [-122.54264, 37.89884]]]} Open Access 1 4991 Molino Park 22360 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.923 Molino Park 0 Local Park 2 4
6694 6694 6693 {"type": "MultiPolygon", "coordinates": [[[[-122.55408, 37.91812], [-122.55387, 37.9183], [-122.55387, 37.9182], [-122.55379, 37.91811], [-122.55369, 37.91795], [-122.55386, 37.91791], [-122.55387, 37.91797], [-122.55401, 37.91809], [-122.55408, 37.91812]]], [[[-122.55539, 37.92078], [-122.55526, 37.9209], [-122.55508, 37.92087], [-122.55475, 37.9206], [-122.55401, 37.92017], [-122.55393, 37.91995], [-122.55397, 37.91965], [-122.55396, 37.91921], [-122.55388, 37.91897], [-122.55385, 37.91896], [-122.55382, 37.91857], [-122.55384, 37.91856], [-122.55385, 37.91851], [-122.55419, 37.91817], [-122.55482, 37.91817], [-122.55468, 37.91825], [-122.5543, 37.91858], [-122.55431, 37.9186], [-122.55414, 37.91865], [-122.55407, 37.91894], [-122.55428, 37.91927], [-122.5542, 37.91983], [-122.55434, 37.92002], [-122.55539, 37.92078]]], [[[-122.55877, 37.91814], [-122.5586, 37.91827], [-122.55788, 37.91849], [-122.5578, 37.91855], [-122.55786, 37.9186], [-122.558, 37.91884], [-122.55811, 37.91896], [-122.55874, 37.91908], [-122.55867, 37.91971], [-122.55764, 37.91982], [-122.55766, 37.91976], [-122.55757, 37.91972], [-122.55799, 37.91951], [-122.55799, 37.91949], [-122.55758, 37.91924], [-122.55675, 37.91848], [-122.55574, 37.91806], [-122.55507, 37.91807], [-122.55505, 37.91802], [-122.55424, 37.91805], [-122.55414, 37.91803], [-122.55399, 37.91791], [-122.55575, 37.91788], [-122.55628, 37.91792], [-122.55699, 37.91815], [-122.55796, 37.91773], [-122.55829, 37.91782], [-122.55818, 37.91793], [-122.55848, 37.91814], [-122.55877, 37.91814]]]]} Open Access 1 4974 Blithedale Canyon Park 16160 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 9.165 Blithedale Canyon Park 0 Local Park 2 4
6698 6698 6697 {"type": "MultiPolygon", "coordinates": [[[[-122.5344, 37.89556], [-122.53396, 37.89601], [-122.53375, 37.89591], [-122.53361, 37.89611], [-122.53349, 37.89606], [-122.53363, 37.89585], [-122.53227, 37.89517], [-122.53196, 37.89507], [-122.53173, 37.89503], [-122.53152, 37.895], [-122.53118, 37.89501], [-122.531, 37.89503], [-122.53086, 37.89505], [-122.53044, 37.89524], [-122.53025, 37.89529], [-122.53024, 37.89515], [-122.53066, 37.89496], [-122.53085, 37.8949], [-122.5312, 37.89486], [-122.53158, 37.89486], [-122.53183, 37.8949], [-122.53226, 37.89501], [-122.53375, 37.89573], [-122.53418, 37.89542], [-122.5344, 37.89556]]], [[[-122.53434, 37.8965], [-122.53379, 37.89724], [-122.53403, 37.89746], [-122.53432, 37.89757], [-122.53415, 37.89771], [-122.53339, 37.89737], [-122.5336, 37.89711], [-122.53368, 37.89713], [-122.53367, 37.89674], [-122.53434, 37.8965]]], [[[-122.53605, 37.89687], [-122.53568, 37.89713], [-122.53549, 37.89697], [-122.5355, 37.89695], [-122.5354, 37.89687], [-122.53527, 37.89696], [-122.53552, 37.89725], [-122.53545, 37.89731], [-122.53548, 37.89735], [-122.5355, 37.89735], [-122.53575, 37.89764], [-122.53571, 37.89767], [-122.5347, 37.89651], [-122.53454, 37.89643], [-122.53478, 37.89635], [-122.53541, 37.89677], [-122.53548, 37.89681], [-122.53576, 37.89661], [-122.53605, 37.89687]]]]} Open Access 1 4983 Sycamore Park 26136 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 4.005 Sycamore Park 0 Local Park 2 4
6701 6701 6700 {"type": "Polygon", "coordinates": [[[-122.56647, 37.91441], [-122.56646, 37.91444], [-122.56619, 37.91437], [-122.56597, 37.91439], [-122.56581, 37.91452], [-122.56554, 37.9153], [-122.56551, 37.91531], [-122.56544, 37.91507], [-122.56532, 37.91502], [-122.56538, 37.91479], [-122.56531, 37.9145], [-122.56531, 37.91435], [-122.56558, 37.91403], [-122.56538, 37.91366], [-122.56502, 37.9133], [-122.56466, 37.91326], [-122.56417, 37.9131], [-122.56358, 37.91219], [-122.56333, 37.91182], [-122.56367, 37.91199], [-122.56407, 37.91182], [-122.56432, 37.9118], [-122.56457, 37.9119], [-122.56457, 37.91204], [-122.56463, 37.91223], [-122.56549, 37.91275], [-122.56565, 37.9128], [-122.56571, 37.91277], [-122.56594, 37.913], [-122.56591, 37.91321], [-122.56607, 37.91357], [-122.56614, 37.91414], [-122.56647, 37.91441]]]} Open Access 1 4986 Cascade Park 16935 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 7.421 Cascade Park 0 Local Park 2 4
6711 6711 6710 {"type": "Polygon", "coordinates": [[[-122.54893, 37.90997], [-122.54852, 37.9102], [-122.54769, 37.90923], [-122.5476, 37.90906], [-122.54817, 37.90886], [-122.54825, 37.90904], [-122.54847, 37.90938], [-122.54893, 37.90997]]]} Open Access 1 5029 Miller Grove Park 22239 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.741 Miller Grove Park 0 Local Park 2 4
6715 6715 6714 {"type": "Polygon", "coordinates": [[[-122.54817, 37.90616], [-122.54774, 37.90648], [-122.54744, 37.90574], [-122.54781, 37.90566], [-122.54814, 37.90606], [-122.54817, 37.90616]]]} Open Access 1 5016 Mill Valley Town Center City Park 22235 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.801 Mill Valley Town Ctr. City Park 0 Local Park 2 4
9536 9536 9535 {"type": "MultiPolygon", "coordinates": [[[[-122.55383, 37.90498], [-122.55372, 37.90503], [-122.5533, 37.90506], [-122.55292, 37.90514], [-122.55252, 37.90529], [-122.55191, 37.90498], [-122.55254, 37.9042], [-122.55278, 37.90446], [-122.5534, 37.90481], [-122.55383, 37.90498]]], [[[-122.55503, 37.90567], [-122.55451, 37.90629], [-122.55269, 37.90537], [-122.55295, 37.90527], [-122.55327, 37.9052], [-122.55377, 37.90516], [-122.55387, 37.90513], [-122.554, 37.90505], [-122.55453, 37.90527], [-122.55461, 37.90554], [-122.55503, 37.90567]]], [[[-122.5538, 37.90436], [-122.55353, 37.90472], [-122.55293, 37.90438], [-122.55271, 37.90415], [-122.55288, 37.90392], [-122.5538, 37.90436]]]]} Open Access 1 16071 Old Mill Park 23093 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 6.496 Old Mill Park 0 Local Park 2 4
9540 9540 9539 {"type": "Polygon", "coordinates": [[[-122.52423, 37.89784], [-122.52413, 37.89789], [-122.52349, 37.89839], [-122.52311, 37.89842], [-122.5229, 37.89837], [-122.52279, 37.8986], [-122.52268, 37.89853], [-122.52264, 37.89848], [-122.52265, 37.89828], [-122.52263, 37.89811], [-122.52257, 37.89794], [-122.52247, 37.89779], [-122.52235, 37.89766], [-122.52182, 37.89719], [-122.52174, 37.89708], [-122.52172, 37.89708], [-122.52164, 37.897], [-122.52157, 37.89695], [-122.52154, 37.89674], [-122.52155, 37.89656], [-122.52183, 37.89572], [-122.52182, 37.89571], [-122.52174, 37.89571], [-122.52183, 37.89544], [-122.52148, 37.89506], [-122.5212, 37.89519], [-122.52087, 37.89557], [-122.52033, 37.89571], [-122.52032, 37.89566], [-122.52083, 37.89552], [-122.52115, 37.89515], [-122.52151, 37.89498], [-122.52179, 37.89529], [-122.52203, 37.89526], [-122.52203, 37.89538], [-122.522, 37.8955], [-122.52295, 37.89549], [-122.52381, 37.89714], [-122.52423, 37.89784]]]} Open Access 1 16014 Enchanted Knolls Park 18640 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 12.109 Enchanted Knolls Park 0 Local Park 2 4
9546 9546 9545 {"type": "MultiPolygon", "coordinates": [[[[-122.52609, 37.89696], [-122.52576, 37.89699], [-122.52582, 37.89737], [-122.52564, 37.89734], [-122.5255, 37.89727], [-122.5254, 37.89717], [-122.52534, 37.89702], [-122.52381, 37.89714], [-122.52296, 37.89549], [-122.52199, 37.8955], [-122.52203, 37.89538], [-122.52203, 37.89526], [-122.52238, 37.89524], [-122.52216, 37.89442], [-122.52258, 37.89429], [-122.5227, 37.89396], [-122.52285, 37.89383], [-122.5232, 37.89357], [-122.52328, 37.8934], [-122.52325, 37.89321], [-122.52285, 37.89287], [-122.52233, 37.89263], [-122.52279, 37.89235], [-122.52338, 37.89292], [-122.52331, 37.89235], [-122.52343, 37.89179], [-122.52328, 37.89164], [-122.52519, 37.89195], [-122.52583, 37.89527], [-122.52609, 37.89696]]], [[[-122.53, 37.89643], [-122.52999, 37.89671], [-122.5284, 37.89653], [-122.5282, 37.89652], [-122.52626, 37.89672], [-122.52597, 37.89483], [-122.52545, 37.89192], [-122.52679, 37.89232], [-122.52705, 37.89201], [-122.52712, 37.89202], [-122.52743, 37.89168], [-122.52849, 37.8923], [-122.52843, 37.89266], [-122.52836, 37.89272], [-122.52834, 37.89272], [-122.5283, 37.89269], [-122.5283, 37.89263], [-122.52825, 37.8926], [-122.52811, 37.89265], [-122.52792, 37.89265], [-122.52827, 37.89276], [-122.52818, 37.89325], [-122.52833, 37.89328], [-122.52832, 37.89337], [-122.52814, 37.89335], [-122.52789, 37.89437], [-122.52798, 37.89488], [-122.52808, 37.89495], [-122.52832, 37.89646], [-122.52836, 37.8965], [-122.5284, 37.89653], [-122.52891, 37.89641], [-122.52947, 37.89644], [-122.5296, 37.89648], [-122.52973, 37.89646], [-122.52982, 37.89641], [-122.53, 37.89643]], [[-122.52724, 37.89215], [-122.52724, 37.89206], [-122.52723, 37.89205], [-122.52698, 37.89237], [-122.52761, 37.89256], [-122.52761, 37.89254], [-122.52735, 37.89244], [-122.52718, 37.89234], [-122.52724, 37.89215]]]]} Open Access 1 16073 Bayfront Park 15886 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 60.395 Bayfront Park 0 Local Park 2 4
9632 9632 9631 {"type": "Polygon", "coordinates": [[[-122.56097, 37.90679], [-122.56094, 37.90682], [-122.56065, 37.90675], [-122.56067, 37.90669], [-122.56095, 37.90677], [-122.56097, 37.90679]]]} Open Access 1 16234 Earnscliffe Park 18358 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.038 Earnscliffe Park 0 Local Park 2 4
9678 9678 9677 {"type": "Polygon", "coordinates": [[[-122.56367, 37.91183], [-122.56365, 37.91184], [-122.56336, 37.91171], [-122.56277, 37.91139], [-122.56236, 37.91144], [-122.56193, 37.91113], [-122.56174, 37.91067], [-122.56227, 37.91039], [-122.56252, 37.9103], [-122.56328, 37.91095], [-122.56285, 37.91133], [-122.5631, 37.91147], [-122.56315, 37.91148], [-122.56318, 37.91155], [-122.56329, 37.91163], [-122.56356, 37.91171], [-122.56361, 37.91179], [-122.56367, 37.91183]]]} Open Access 1 16334 Three Wells Park 26335 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 2.706 Three Wells Park 0 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]);