units_with_maps

Table actions

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

12 rows where AGNCY_WEB = "http://www.ci.millbrae.ca.us/", DES_TP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 12 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Park · 12 ✖

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
1659 1659 1658 {"type": "Polygon", "coordinates": [[[-122.39721, 37.59372], [-122.39652, 37.59394], [-122.39638, 37.594], [-122.39628, 37.59398], [-122.39625, 37.59395], [-122.39607, 37.59348], [-122.39603, 37.59323], [-122.39648, 37.59325], [-122.39668, 37.59314], [-122.39721, 37.59372]]]} Open Access 1 14302 Rotary Park 24691 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 1.461 Rotary Park 1961 Local Park 2 4
8776 8776 8775 {"type": "Polygon", "coordinates": [[[-122.40194, 37.59953], [-122.4014, 37.59984], [-122.40143, 37.5999], [-122.40009, 37.60067], [-122.40003, 37.60074], [-122.40003, 37.60079], [-122.40005, 37.60083], [-122.4001, 37.6009], [-122.39917, 37.60143], [-122.39834, 37.60052], [-122.40124, 37.59884], [-122.40194, 37.59953]]]} Open Access 1 14300 Central Park 17054 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 8.686 Central Park 1969 Local Park 2 4
8787 8787 8786 {"type": "Polygon", "coordinates": [[[-122.40918, 37.59933], [-122.40913, 37.5994], [-122.4085, 37.59926], [-122.40864, 37.59886], [-122.40894, 37.59893], [-122.40893, 37.59904], [-122.40903, 37.59922], [-122.40907, 37.59925], [-122.40917, 37.59926], [-122.40918, 37.59933]]]} Open Access 1 14293 Bill Mitchell Lions Park 16107 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2 https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/lion-bill-mitchell-park San Mateo 15 0.477 Bill Mitchell Lions Park 1977 Local Park 2 4
8789 8789 8788 {"type": "Polygon", "coordinates": [[[-122.39939, 37.59473], [-122.39896, 37.59497], [-122.39849, 37.59447], [-122.3984, 37.59452], [-122.39831, 37.59442], [-122.39818, 37.59449], [-122.39802, 37.59432], [-122.39813, 37.59425], [-122.39814, 37.59423], [-122.398, 37.59416], [-122.39788, 37.59423], [-122.39757, 37.594], [-122.39778, 37.59388], [-122.39767, 37.59375], [-122.39738, 37.59391], [-122.3973, 37.59382], [-122.39765, 37.59372], [-122.39801, 37.59326], [-122.39939, 37.59473]]]} Open Access 1 14298 Josephine Waugh/Soroptimist Park 20502 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 2.83 Josephine Waugh/Soroptimist Park 1961 Local Park 2 4
8790 8790 8789 {"type": "Polygon", "coordinates": [[[-122.4033, 37.59547], [-122.4029, 37.59587], [-122.40284, 37.59606], [-122.40316, 37.59665], [-122.40287, 37.59671], [-122.40226, 37.59656], [-122.4017, 37.59595], [-122.40259, 37.59545], [-122.40301, 37.59571], [-122.40327, 37.59545], [-122.4033, 37.59547]]]} Open Access 1 14299 Schultz Park 25196 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 2.55 Schultz Park 1961 Local Park 2 4
8791 8791 8790 {"type": "MultiPolygon", "coordinates": [[[[-122.39528, 37.59394], [-122.38939, 37.59734], [-122.38915, 37.59707], [-122.39089, 37.59607], [-122.3911, 37.59626], [-122.39165, 37.59597], [-122.39165, 37.59595], [-122.39145, 37.59575], [-122.39305, 37.59482], [-122.39471, 37.59366], [-122.39481, 37.59358], [-122.39484, 37.59357], [-122.39494, 37.59351], [-122.39528, 37.59394]]], [[[-122.40184, 37.59691], [-122.40145, 37.59714], [-122.40141, 37.59713], [-122.40108, 37.59693], [-122.40089, 37.59671], [-122.40093, 37.59665], [-122.40068, 37.59652], [-122.40053, 37.59642], [-122.4005, 37.59644], [-122.40022, 37.5962], [-122.39966, 37.59584], [-122.39922, 37.59541], [-122.39908, 37.59509], [-122.39951, 37.59487], [-122.40018, 37.59558], [-122.4007, 37.59603], [-122.40076, 37.59601], [-122.40079, 37.59603], [-122.40093, 37.59596], [-122.40184, 37.59691]]], [[[-122.40762, 37.59812], [-122.40671, 37.59864], [-122.40508, 37.59828], [-122.40481, 37.59844], [-122.40388, 37.59818], [-122.4032, 37.59794], [-122.4025, 37.59763], [-122.40167, 37.59719], [-122.40196, 37.59703], [-122.40249, 37.59715], [-122.40297, 37.59737], [-122.40346, 37.59757], [-122.40377, 37.59739], [-122.4038, 37.59741], [-122.40346, 37.5976], [-122.40346, 37.59762], [-122.40434, 37.59789], [-122.40487, 37.59743], [-122.40752, 37.598], [-122.40762, 37.59812]]]]} Open Access 1 14301 Spur Trail Park 25755 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 18.129 Spur Trail Park 1975 Local Park 2 4
8792 8792 8791 {"type": "Polygon", "coordinates": [[[-122.3999, 37.58571], [-122.39987, 37.58599], [-122.3996, 37.58686], [-122.39943, 37.58705], [-122.39939, 37.58702], [-122.39902, 37.58728], [-122.39888, 37.58699], [-122.39867, 37.58671], [-122.39849, 37.58655], [-122.39799, 37.58618], [-122.39778, 37.58598], [-122.39862, 37.58586], [-122.39976, 37.58546], [-122.3999, 37.58571]]]} Open Access 1 14303 Mills Estates Park 32592 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2 https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/mills-estates-park San Mateo 15 4.612 Mills Estates Park 1968 Local Park 2 4
8793 8793 8792 {"type": "Polygon", "coordinates": [[[-122.41738, 37.60205], [-122.41705, 37.60239], [-122.4167, 37.60265], [-122.41569, 37.6017], [-122.41576, 37.60149], [-122.41603, 37.60143], [-122.41604, 37.60136], [-122.41629, 37.60156], [-122.41655, 37.60165], [-122.41692, 37.60183], [-122.41692, 37.60186], [-122.41706, 37.60191], [-122.41709, 37.60189], [-122.41738, 37.60205]]]} Open Access 1 14304 Meadows Park 22097 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 2.345 Meadows Park 1973 Local Park 2 4
8794 8794 8793 {"type": "Polygon", "coordinates": [[[-122.40243, 37.60703], [-122.40183, 37.60732], [-122.40179, 37.60732], [-122.40159, 37.60726], [-122.40126, 37.60708], [-122.40111, 37.60697], [-122.4009, 37.60677], [-122.4018, 37.60631], [-122.40243, 37.60703]]]} Open Access 1 14305 Green Hills Park 19463 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 2.016 Green Hills Park 1988 Local Park 2 4
8795 8795 8794 {"type": "Polygon", "coordinates": [[[-122.38728, 37.60488], [-122.3869, 37.60509], [-122.38641, 37.60455], [-122.38679, 37.60433], [-122.38728, 37.60488]]]} Open Access 1 14307 Bayside Manor Park 15895 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 0.76 Bayside Manor Park 2002 Local Park 2 4
8796 8796 8795 {"type": "Polygon", "coordinates": [[[-122.3781, 37.60526], [-122.37758, 37.60546], [-122.37701, 37.60546], [-122.37638, 37.60529], [-122.3761, 37.60514], [-122.37588, 37.60499], [-122.37578, 37.60487], [-122.37554, 37.60465], [-122.37534, 37.60452], [-122.37481, 37.60411], [-122.37457, 37.60399], [-122.37435, 37.60378], [-122.37438, 37.6037], [-122.37667, 37.60469], [-122.37747, 37.60502], [-122.37771, 37.60507], [-122.3781, 37.60526]]]} Open Access 1 14308 Bay Front Park 15872 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2   San Mateo 15 4.105 Bay Front Park 1962 Local Park 2 4
8799 8799 8798 {"type": "Polygon", "coordinates": [[[-122.39528, 37.61104], [-122.39513, 37.61115], [-122.39392, 37.61039], [-122.39406, 37.61024], [-122.39528, 37.61104]]]} Open Access 1 14319 Marina Vista Park 32591 1205 Millbrae, City of 404 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 1205 Millbrae, City of 398 City 2 City Agency 2 https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/marina-vista-park San Mateo 15 0.653 Marina Vista Park 1961 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]);