Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88964 | 88964 | 40469 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41554 | 5996794.30906624 | 2091457.62107189 | 37.722560639803795 | -122.453193843047 | (37.7225606398038, -122.453193843047) | ||
| 89579 | 89579 | 87862 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3944 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50815 | 6003369.0 | 2104810.4 | 37.7595989256918 | -122.431419361427 | (37.7595989256918, -122.431419361427) | ||
| 89617 | 89617 | 96689 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 89731 | 89731 | 40978 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 89775 | 89775 | 40981 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 90050 | 90050 | 40988 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 90184 | 90184 | 44408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1201 Naples St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.711715976255796 | -122.437852856075 | (37.7117159762558, -122.437852856075) | ||
| 90229 | 90229 | 40983 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 90296 | 90296 | 42178 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 540 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42463 | 6010231.08590939 | 2108722.60367253 | 37.770727467539295 | -122.40796262268299 | (37.7707274675393, -122.407962622683) | |||
| 90470 | 90470 | 42480 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092500.6250099998 | 37.7254416323021 | -122.452234471094 | (37.7254416323021, -122.452234471094) | ||
| 90818 | 90818 | 88609 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 90821 | 90821 | 44385 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 90897 | 90897 | 41408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 91276 | 91276 | 42420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 516 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42887 | 5998662.31867711 | 2095004.42234287 | 37.7324062134589 | -122.446991687536 | (37.7324062134589, -122.446991687536) | ||
| 91339 | 91339 | 64659 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 25 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1988 12:00:00 AM | Permit Number 25586 | 6007608.44744383 | 2099294.10346884 | 37.744691787676395 | -122.41636647215599 | (37.7446917876764, -122.416366472156) | |||
| 91647 | 91647 | 41393 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 91969 | 91969 | 33076 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1462 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.40742458550699 | (37.8002986697641, -122.407424585507) | ||
| 92070 | 92070 | 30864 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 265 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34702 | 6003455.83546905 | 2100949.65724805 | 37.7490031605747 | -122.430843516485 | (37.7490031605747, -122.430843516485) | |||
| 92091 | 92091 | 42492 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997101.20001 | 2092826.1460099998 | 37.7263358710664 | -122.45223169353999 | (37.7263358710664, -122.45223169354) | ||
| 92234 | 92234 | 43376 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43124 | 6001838.70393006 | 2103323.4801791 | 37.755429354087504 | -122.436605448479 | (37.7554293540875, -122.436605448479) | ||
| 92777 | 92777 | 42431 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 158 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687001 | (37.7283517896397, -122.44561415687) | ||
| 92994 | 92994 | 42314 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200X STAPLES AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998726.0 | 2093843.0 | 37.7292208591283 | -122.446687991949 | (37.7292208591283, -122.446687991949) | ||
| 93464 | 93464 | 42507 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 134 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42621 | 5999185.65268626 | 2093811.75019854 | 37.7291613007921 | -122.445096693184 | (37.7291613007921, -122.445096693184) | ||
| 93498 | 93498 | 40498 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 44 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.731292009719894 | -122.466191234844 | (37.7312920097199, -122.466191234844) | ||
| 93551 | 93551 | 42466 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 124 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47067 | 5998634.60353 | 2093230.01481651 | 37.727532524187495 | -122.446959862935 | (37.7275325241875, -122.446959862935) | ||
| 93654 | 93654 | 40976 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 93716 | 93716 | 93531 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 325 China Basin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 93871 | 93871 | 39805 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 94153 | 94153 | 42451 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 534 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42594 | 5997888.12500218 | 2095286.48921964 | 37.7331364399295 | -122.449688562745 | (37.7331364399295, -122.449688562745) | ||
| 94196 | 94196 | 93521 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 94211 | 94211 | 115199 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 363 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777367 | 6002146.7 | 2103751.7 | 37.756622640721204 | -122.43557093896001 | (37.7566226407212, -122.43557093896) | |||
| 94974 | 94974 | 31581 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1894 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35120 | 5988803.26989649 | 2102446.27193627 | 37.7522713821241 | -122.481621183041 | (37.7522713821241, -122.481621183041) | ||
| 95096 | 95096 | 41399 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 95179 | 95179 | 39842 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 95366 | 95366 | 41392 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 95450 | 95450 | 42270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 95606 | 95606 | 41001 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 95742 | 95742 | 34663 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2821 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38336 | 6003485.60145091 | 2118006.68224973 | 37.7958392495178 | -122.431958401499 | (37.7958392495178, -122.431958401499) | ||
| 95775 | 95775 | 33078 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1462 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.40742458550699 | (37.8002986697641, -122.407424585507) | ||
| 95813 | 95813 | 41043 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 96287 | 96287 | 45361 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 494 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2001 12:00:00 AM | Permit Number 44186 | 5993280.54401179 | 2090440.20724826 | 37.7195650519649 | -122.465266177702 | (37.7195650519649, -122.465266177702) | ||
| 96514 | 96514 | 42312 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 301 Edna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.729107090700396 | -122.44665415584801 | (37.7291070907004, -122.446654155848) | ||
| 96558 | 96558 | 42341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 136 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42546 | 5998127.62508278 | 2093912.27008524 | 37.729376858931296 | -122.44876160358999 | (37.7293768589313, -122.44876160359) | ||
| 96928 | 96928 | 43261 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 96941 | 96941 | 115180 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2019 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775162 | 5981635.3 | 2101323.4 | 37.7487688795742 | -122.50632546718799 | (37.7487688795742, -122.506325467188) | |||
| 96958 | 96958 | 96688 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 97459 | 97459 | 99754 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 590 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001368.0 | 2100878.0 | 37.7486878919362 | -122.43805811738301 | (37.7486878919362, -122.438058117383) | ||||
| 97480 | 97480 | 41398 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 97537 | 97537 | 42289 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42521 | 6000072.63936559 | 2095048.37890507 | 37.7326073822148 | -122.44211904743 | (37.7326073822148, -122.44211904743) | ||
| 97922 | 97922 | 42313 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200X STAPLES AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998726.0 | 2093843.0 | 37.7292208591283 | -122.446687991949 | (37.7292208591283, -122.446687991949) | ||
| 98258 | 98258 | 42272 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 98726 | 98726 | 41388 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 98793 | 98793 | 40994 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 98795 | 98795 | 32897 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1340 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37238 | 5993973.14143583 | 2106377.41166992 | 37.7633645395277 | -122.464028430515 | (37.7633645395277, -122.464028430515) | ||
| 99043 | 99043 | 98824 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2099x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008101.0 | 2119295.0 | 37.7996372188946 | -122.416079497811 | (37.7996372188946, -122.416079497811) | ||||
| 99136 | 99136 | 33349 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 130 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37486 | 5994450.45570684 | 2093633.46730363 | 37.7284003716329 | -122.46145362410101 | (37.7284003716329, -122.461453624101) | ||
| 99367 | 99367 | 35271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 249 Glenview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38754 | 5999067.6634639995 | 2100783.79548838 | 37.7482981400857 | -122.446005856491 | (37.7482981400857, -122.446005856491) | ||
| 99623 | 99623 | 33379 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.871562201 | 2093773.0831922002 | 37.72867362771839 | -122.46806524141199 | (37.7286736277184, -122.468065241412) | ||
| 100749 | 100749 | 42491 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997099.03001 | 2092901.0150099997 | 37.7265413193022 | -122.452244594961 | (37.7265413193022, -122.452244594961) | ||
| 100918 | 100918 | 36910 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 394 Diamond St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52286 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.43684307811701 | (37.7560694803843, -122.436843078117) | ||
| 101038 | 101038 | 43273 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 531 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43045 | 6010798.16682948 | 2092260.35598148 | 37.725557463887704 | -122.404841874666 | (37.7255574638877, -122.404841874666) | ||
| 101105 | 101105 | 41406 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 101310 | 101310 | 88610 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 101407 | 101407 | 43269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 101437 | 101437 | 115840 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1714 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5990668.9 | 2098425.6 | 37.741339969451204 | -122.47487615335501 | (37.7413399694512, -122.474876153355) | |||||
| 102055 | 102055 | 42269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 102191 | 102191 | 41403 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 102361 | 102361 | 65183 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 478 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 3x3 | Permit Number 27167 | 6000645.37294638 | 2101243.52850641 | 37.749650423015105 | -122.440583162993 | (37.7496504230151, -122.440583162993) | ||
| 102580 | 102580 | 32898 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1340 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37238 | 5993973.14143583 | 2106377.41166992 | 37.7633645395277 | -122.464028430515 | (37.7633645395277, -122.464028430515) | ||
| 102597 | 102597 | 40991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 102706 | 102706 | 34131 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 66 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 37985 | 5995146.89610617 | 2093043.97234253 | 37.7268218211365 | -122.459003347309 | (37.7268218211365, -122.459003347309) | ||
| 102727 | 102727 | 39850 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 102828 | 102828 | 41018 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 103133 | 103133 | 34108 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1398 Plymouth Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 103542 | 103542 | 95135 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 450@ Wayland Somerset St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010071.0 | 2092425.0 | 37.725968869436706 | -122.40736724249399 | (37.7259688694367, -122.407367242494) | ||||
| 103616 | 103616 | 92225 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2601x 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52663 | 6010359.7 | 2104530.1 | 37.7592230059201 | -122.407222156732 | (37.7592230059201, -122.407222156732) | ||
| 103858 | 103858 | 42010 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1265 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42338 | 5994087.78224082 | 2094315.91155995 | 37.7302533156885 | -122.4627568813 | (37.7302533156885, -122.4627568813) | ||
| 104088 | 104088 | 95662 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 298 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767424 | 6006728.0 | 2093095.0 | 37.7276208697995 | -122.41897129934999 | (37.7276208697995, -122.41897129935) | |
| 104173 | 104173 | 41011 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 104197 | 104197 | 42338 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 350 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42543 | 5998429.06201624 | 2094117.89739925 | 37.729958696023104 | -122.447734309496 | (37.7299586960231, -122.447734309496) | ||
| 104466 | 104466 | 41386 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 104615 | 104615 | 35430 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1501 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38876 | 6014234.60360095 | 2101971.010972 | 37.7524123965466 | -122.39364165826099 | (37.7524123965466, -122.393641658261) | ||
| 104733 | 104733 | 42009 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1265 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42338 | 5994087.78224082 | 2094315.91155995 | 37.7302533156885 | -122.4627568813 | (37.7302533156885, -122.4627568813) | ||
| 105218 | 105218 | 41402 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 105355 | 105355 | 34662 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2821 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38336 | 6003485.60145091 | 2118006.68224973 | 37.7958392495178 | -122.431958401499 | (37.7958392495178, -122.431958401499) | ||
| 105482 | 105482 | 33077 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1462 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.40742458550699 | (37.8002986697641, -122.407424585507) | ||
| 105604 | 105604 | 115254 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 20 Edgar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | |||
| 105723 | 105723 | 50424 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47077 | 5995672.60024173 | 2091512.71167993 | 37.7226475514283 | -122.45707529796101 | (37.7226475514283, -122.457075297961) | ||
| 105807 | 105807 | 42423 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 563 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42889 | 5998365.32323984 | 2094956.90403164 | 37.7322587668597 | -122.448015045806 | (37.7322587668597, -122.448015045806) | ||
| 105862 | 105862 | 95665 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 298 Cambridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767424 | 6006728.0 | 2093095.0 | 37.7276208697995 | -122.41897129934999 | (37.7276208697995, -122.41897129935) | |
| 105941 | 105941 | 42449 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 389 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42592 | 5998863.01478143 | 2095219.02170316 | 37.7330069168964 | -122.44631326890699 | (37.7330069168964, -122.446313268907) | ||
| 106014 | 106014 | 39837 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 106038 | 106038 | 39328 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 106047 | 106047 | 44443 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43774 | 6003431.81812286 | 2086404.88677332 | 37.7090651281705 | -122.429889231519 | (37.7090651281705, -122.429889231519) | ||
| 106048 | 106048 | 41042 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 106164 | 106164 | 93528 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 325 China Basin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 106227 | 106227 | 35306 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3559 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38774 | 6005168.14614512 | 2106017.92863581 | 37.763016316839206 | -122.425282938932 | (37.7630163168392, -122.425282938932) | ||
| 106317 | 106317 | 42290 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42521 | 6000072.63936559 | 2095048.37890507 | 37.7326073822148 | -122.44211904743 | (37.7326073822148, -122.44211904743) | ||
| 106481 | 106481 | 35267 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 986 Burnett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38751 | 5999359.18591782 | 2100369.19379422 | 37.7471763868061 | -122.444967982995 | (37.7471763868061, -122.444967982995) | ||
| 106696 | 106696 | 40386 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 345 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41497 | 5995822.38702259 | 2094822.88437106 | 37.7317450926451 | -122.45679680989299 | (37.7317450926451, -122.456796809893) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");