Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117539 | 117539 | 92270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1650 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 143017 | 143017 | 92269 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1650 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 21548 | 21548 | 31364 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2295 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779235 | 5991014.76631 | 2099859.25307 | 37.745296448467 | -122.47378484391001 | (37.745296448467, -122.47378484391) | |
| 104720 | 104720 | 108666 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 687 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.6776799997 | 37.7755749935311 | -122.50598122863501 | (37.7755749935311, -122.505981228635) | |
| 36735 | 36735 | 39593 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 4 | Permit Number 41001 | 6012273.08907 | 2104003.23751 | 37.7578832555154 | -122.400567684363 | (37.7578832555154, -122.400567684363) | ||
| 124944 | 124944 | 39591 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | Permit Number 41001 | 6012325.10844747 | 2103966.01708403 | 37.7577839574034 | -122.400385164113 | (37.7577839574034, -122.400385164113) | |||
| 129755 | 129755 | 39590 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 41001 | 6012223.72591 | 2104034.00699 | 37.7579649886172 | -122.400740565528 | (37.7579649886172, -122.400740565528) | ||
| 133578 | 133578 | 39592 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 45 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 41001 | 6012253.42141 | 2104014.73236 | 37.757913720955 | -122.400636511287 | (37.757913720955, -122.400636511287) | ||
| 25208 | 25208 | 66447 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.1903099995 | 2119198.2009799997 | 37.7994303674837 | -122.41244205838001 | (37.7994303674837, -122.41244205838) | |
| 9769 | 9769 | 159355 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.882680001 | 2087558.1907400002 | 37.7119518775514 | -122.44698304145001 | (37.7119518775514, -122.44698304145) | |
| 85478 | 85478 | 52487 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 349@ ANDOVER Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 14 | Permit Number 48597 | 6006928.39742445 | 2096056.46353797 | 37.735763683776604 | -122.418488426042 | (37.7357636837766, -122.418488426042) | |
| 42929 | 42929 | 39524 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40968 | 6012453.7413 | 2107068.2011 | 37.7663090393741 | -122.400158161944 | (37.7663090393741, -122.400158161944) | |
| 45210 | 45210 | 39519 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40968 | 6012430.9158 | 2107067.2501 | 37.7663051554079 | -122.40023704474301 | (37.7663051554079, -122.400237044743) | |
| 49895 | 49895 | 39520 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40968 | 6012360.5372 | 2107063.4458 | 37.766290785060605 | -122.400480205309 | (37.7662907850606, -122.400480205309) | |
| 72165 | 72165 | 39522 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | 3x3 | Permit Number 40968 | 6012383.3627 | 2107064.3969 | 37.7662946694641 | -122.400401322544 | (37.7662946694641, -122.400401322544) |
| 146452 | 146452 | 39525 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40968 | 6012506.0497 | 2107071.0543 | 37.7663197901014 | -122.399977436283 | (37.7663197901014, -122.399977436283) | |
| 156355 | 156355 | 39523 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1330 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 9 | Permit Number 40968 | 6012401.4328 | 2107065.348 | 37.7662982886386 | -122.40033888790501 | (37.7662982886386, -122.400338887905) | |
| 87587 | 87587 | 33801 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1411 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/1996 12:00:00 AM | Permit Number 37822 | 5989260.68046067 | 2105731.95209097 | 37.761319566555 | -122.480279867052 | (37.761319566555, -122.480279867052) | |||
| 143734 | 143734 | 33802 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1411 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/1996 12:00:00 AM | Permit Number 37822 | 5989260.68046067 | 2105731.95209097 | 37.761319566555 | -122.480279867052 | (37.761319566555, -122.480279867052) | |||
| 15112 | 15112 | 11554 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018972.44427 | 2097338.24769 | 37.7399538873755 | -122.37693587968398 | (37.7399538873755, -122.376935879684) | ||
| 78194 | 78194 | 11543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018704.60401 | 2097015.07701 | 37.7390517691962 | -122.377839546083 | (37.7390517691962, -122.377839546083) | ||
| 109551 | 109551 | 11514 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018414.23901 | 2096612.7330099999 | 37.7379310078681 | -122.378815574261 | (37.7379310078681, -122.378815574261) | ||
| 104667 | 104667 | 33538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 255 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776070 | 6007060.588217501 | 2097537.31528523 | 37.739837216106295 | -122.41813634278799 | (37.7398372161063, -122.418136342788) | |
| 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) | |||
| 126642 | 126642 | 39330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 3 | 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) | |||
| 145158 | 145158 | 39329 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 2 | 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) | |||
| 11211 | 11211 | 85907 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2246 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988262.6758 | 2100024.3615 | 37.7455900114068 | -122.48331310017299 | (37.7455900114068, -122.483313100173) | ||
| 12056 | 12056 | 85925 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1730 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103504.7685 | 37.7551394419513 | -122.483974450282 | (37.7551394419513, -122.483974450282) | ||
| 12495 | 12495 | 85911 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2226 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988257.1282 | 2100144.275 | 37.745918939271604 | -122.483341071389 | (37.7459189392716, -122.483341071389) | ||
| 12995 | 12995 | 85903 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2270 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988266.5164 | 2099871.5891 | 37.745170762324705 | -122.483288623432 | (37.7451707623247, -122.483288623432) | ||
| 13195 | 13195 | 85902 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2278 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099821.6607 | 37.7450337963146 | -122.483277586342 | (37.7450337963146, -122.483277586342) | ||
| 121887 | 121887 | 85928 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1714 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988136.4457290005 | 2103626.592871 | 37.7554734287439 | -122.484013683245 | (37.7554734287439, -122.484013683245) | ||
| 124032 | 124032 | 85910 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988256.502181 | 2100122.915005 | 37.7458602539478 | -122.483341670527 | (37.7458602539478, -122.483341670527) | ||
| 10393 | 10393 | 85922 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1750 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988150.1283 | 2103379.9075 | 37.754796893765395 | -122.483948277297 | (37.7547968937654, -122.483948277297) | ||
| 10566 | 10566 | 85914 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1882 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988180.9701 | 2102501.3004 | 37.7523862701891 | -122.483777202176 | (37.7523862701891, -122.483777202176) | ||
| 10576 | 10576 | 85916 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1838 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988170.1375 | 2102775.399 | 37.753138240815204 | -122.48383475868201 | (37.7531382408152, -122.483834758682) | ||
| 11050 | 11050 | 86410 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1823 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988122.3065 | 2102871.1988 | 37.7533984968143 | -122.484007190165 | (37.7533984968143, -122.484007190165) | ||
| 11245 | 11245 | 85919 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1792 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988158.7855 | 2103127.4828 | 37.7541043074668 | -122.483899830474 | (37.7541043074668, -122.483899830474) | ||
| 11561 | 11561 | 85917 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1830 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988168.9979 | 2102827.2497 | 37.7532805425745 | -122.48384250118299 | (37.7532805425745, -122.483842501183) | ||
| 11661 | 11661 | 86405 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1751 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.9893 | 2103387.0665 | 37.7548137478444 | -122.48411527814501 | (37.7548137478444, -122.484115278145) | ||
| 11892 | 11892 | 86407 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1767 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988104.9226 | 2103286.9146 | 37.7545389284857 | -122.48409779006599 | (37.7545389284857, -122.484097790066) | ||
| 12222 | 12222 | 85921 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1754 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988153.7734 | 2103347.5571 | 37.754708280483605 | -122.483933299665 | (37.7547082804836, -122.483933299665) | ||
| 12264 | 12264 | 86408 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1801X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 6 | 3x3 | 5988118.8805 | 2102991.671 | 37.753729081636 | -122.484027871479 | (37.753729081636, -122.484027871479) | ||
| 12405 | 12405 | 86416 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2227 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988214.8811 | 2100128.059 | 37.74587195560729 | -122.483485965678 | (37.7458719556073, -122.483485965678) | ||
| 43165 | 43165 | 86404 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1739 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988101.813015 | 2103468.563864 | 37.755037507379 | -122.48412186397499 | (37.755037507379, -122.484121863975) | ||
| 78412 | 78412 | 85913 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1898X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988178.281547 | 2102398.705021 | 37.7521044142719 | -122.48377897775299 | (37.7521044142719, -122.483778977753) | ||
| 89198 | 89198 | 86417 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2243 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988219.183677 | 2100043.4529810003 | 37.7456399003067 | -122.48346488679701 | (37.7456399003067, -122.483464886797) | ||
| 116801 | 116801 | 85923 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1750 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988144.461781 | 2103391.5948240003 | 37.754828654122 | -122.483968730406 | (37.754828654122, -122.483968730406) | ||
| 125048 | 125048 | 86412 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1837X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988124.549971 | 2102801.454812 | 37.7532071291716 | -122.483994317971 | (37.7532071291716, -122.483994317971) | ||
| 125595 | 125595 | 86411 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1827 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | 5988122.3314660005 | 2102866.63393 | 37.75338596436129 | -122.48400676911301 | (37.7533859643613, -122.484006769113) | ||
| 12678 | 12678 | 108261 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.43328956378201 | (37.7223123355393, -122.433289563782) | |
| 104238 | 104238 | 1943 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 6 | 3X4 | 6017638.082631599 | 2095207.7846551002 | 37.7340304768318 | -122.381401486036 | (37.7340304768318, -122.381401486036) | ||
| 32765 | 32765 | 70201 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | ||
| 145321 | 145321 | 52397 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 24@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48518 | 6005766.44533291 | 2097758.87496961 | 37.7403726422988 | -122.422626691285 | (37.7403726422988, -122.422626691285) | ||
| 82758 | 82758 | 43112 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200 Appleton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 140335 | 140335 | 43114 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200 Appleton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 143901 | 143901 | 43113 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 10185 | 10185 | 86271 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 10186 | 10186 | 86272 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1498X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988421.0 | 2105155.0 | 37.7596865840953 | -122.48314164268601 | (37.7596865840953, -122.483141642686) | ||
| 10504 | 10504 | 86267 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1562 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988412.0307 | 2104673.7348 | 37.7583646382457 | -122.483137386721 | (37.7583646382457, -122.483137386721) | ||
| 10552 | 10552 | 86314 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1563 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988370.7453 | 2104668.8777 | 37.758348899365394 | -122.483279812102 | (37.7583488993654, -122.483279812102) | ||
| 10583 | 10583 | 86264 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1694 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988441.0116 | 2103811.0505 | 37.755997626406206 | -122.482973932182 | (37.7559976264062, -122.482973932182) | ||
| 10916 | 10916 | 86279 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1370 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988367.4417 | 2105985.7022 | 37.761964349683396 | -122.48338776877199 | (37.7619643496834, -122.483387768772) | ||
| 10918 | 10918 | 86319 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1687 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988396.6413 | 2103838.6204 | 37.756070744005605 | -122.483129398253 | (37.7560707440056, -122.483129398253) | ||
| 11063 | 11063 | 86318 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1659 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988389.7488 | 2104019.117 | 37.7565659379204 | -122.48316646418999 | (37.7565659379204, -122.48316646419) | ||
| 11255 | 11255 | 86284 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1330 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988359.3252 | 2106249.2195 | 37.762687423978 | -122.483435159107 | (37.762687423978, -122.483435159107) | ||
| 11263 | 11263 | 86266 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1650 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988431.5344 | 2104067.7951 | 37.75670202642571 | -122.483025524044 | (37.7567020264257, -122.483025524044) | ||
| 11299 | 11299 | 86306 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1483 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988351.387999999 | 2105239.4954 | 37.7599145343681 | -122.483388587245 | (37.7599145343681, -122.483388587245) | ||
| 11342 | 11342 | 86268 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1554 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988410.0879 | 2104736.3916 | 37.7585365638092 | -122.483148698285 | (37.7585365638092, -122.483148698285) | ||
| 11405 | 11405 | 86274 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1470 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988390.8371 | 2105304.6829 | 37.7600958174171 | -122.48325693207899 | (37.7600958174171, -122.483256932079) | ||
| 11485 | 11485 | 86280 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1366 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988366.3595 | 2106019.7917 | 37.7620578871803 | -122.483394010737 | (37.7620578871803, -122.483394010737) | ||
| 11502 | 11502 | 86307 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1491 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988352.2197 | 2105195.8317 | 37.7597946941019 | -122.483382509952 | (37.7597946941019, -122.483382509952) | ||
| 11583 | 11583 | 86277 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1390 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988371.7706 | 2105858.0017 | 37.761613970822 | -122.48336343539101 | (37.761613970822, -122.483363435391) | ||
| 11676 | 11676 | 86269 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1514 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988401.8308 | 2104975.3617 | 37.7591922304865 | -122.48319477105301 | (37.7591922304865, -122.483194771053) | ||
| 11830 | 11830 | 86278 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1386 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988372.3117 | 2105874.2348 | 37.761658573987496 | -122.483362753995 | (37.7616585739875, -122.483362753995) | ||
| 11857 | 11857 | 86285 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1326 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.7019 | 2106271.4048 | 37.762748244281795 | -122.483442399915 | (37.7627482442818, -122.483442399915) | ||
| 11872 | 11872 | 86305 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1475 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988348.892999999 | 2105280.6641 | 37.7600274272341 | -122.483400234139 | (37.7600274272341, -122.483400234139) | ||
| 11961 | 11961 | 86303 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1467 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988346.8137 | 2105325.1594 | 37.7601494782311 | -122.48341068724599 | (37.7601494782311, -122.483410687246) | ||
| 12535 | 12535 | 86270 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1506 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988399.8879 | 2105026.8471 | 37.7593334823774 | -122.483205264351 | (37.7593334823774, -122.483205264351) | ||
| 12691 | 12691 | 86301 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1459 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988345.5662 | 2105396.6847 | 37.7603457946748 | -122.48342024517 | (37.7603457946748, -122.48342024517) | ||
| 12692 | 12692 | 86310 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1523 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988361.5167 | 2104922.9048 | 37.759045851915396 | -122.48333034952499 | (37.7590458519154, -122.483330349525) | ||
| 12891 | 12891 | 86300 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1443 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988341.8236 | 2105477.7745 | 37.760568227410495 | -122.483439133627 | (37.7605682274105, -122.483439133627) | ||
| 12941 | 12941 | 86283 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988360.9485 | 2106155.0675 | 37.7624290027378 | -122.48342264230301 | (37.7624290027378, -122.483422642303) | ||
| 12950 | 12950 | 86281 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1350 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.654 | 2106078.2308 | 37.7622181875649 | -122.483407652112 | (37.7622181875649, -122.483407652112) | ||
| 13054 | 13054 | 86311 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1527 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988363.4596 | 2104894.2478 | 37.758967280631 | -122.483321529451 | (37.758967280631, -122.483321529451) | ||
| 82756 | 82756 | 86302 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988347.658031 | 2105360.5890470003 | 37.7602468075616 | -122.48341036445 | (37.7602468075616, -122.48341036445) | ||
| 89989 | 89989 | 86316 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1599X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988379.131198 | 2104445.743891 | 37.7577367222966 | -122.48323445447599 | (37.7577367222966, -122.483234454476) | ||
| 109439 | 109439 | 86298 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1419 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988337.768852 | 2105648.043099 | 37.7610355026995 | -122.48346563960199 | (37.7610355026995, -122.483465639602) | ||
| 114557 | 114557 | 86317 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1611 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988382.64724 | 2104340.049698 | 37.757446719218294 | -122.48321454739201 | (37.7574467192183, -122.483214547392) | ||
| 128851 | 128851 | 86286 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1300 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988350.35796 | 2106445.496749 | 37.763225825829004 | -122.483480563078 | (37.763225825829, -122.483480563078) | ||
| 141427 | 141427 | 86299 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1429 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988340.016392 | 2105582.712636 | 37.760856253825395 | -122.483453076967 | (37.7608562538254, -122.483453076967) | ||
| 144478 | 144478 | 86304 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1471 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988349.456064 | 2105308.324648 | 37.7601034083602 | -122.48340031454501 | (37.7601034083602, -122.483400314545) | ||
| 87381 | 87381 | 22633 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1171 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1990 12:00:00 AM | 10 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | ||
| 16411 | 16411 | 27537 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.088719999 | 2102884.43561 | 37.755026000570105 | -122.38712619673599 | (37.7550260005701, -122.387126196736) | ||
| 16646 | 16646 | 27538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.38711827459998 | (37.7549212799101, -122.3871182746) | ||
| 76132 | 76132 | 27559 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 95538 | 95538 | 27564 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 96943 | 96943 | 27557 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 97959 | 97959 | 27560 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 106917 | 106917 | 27562 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) |
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");