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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 165139 | 165139 | 201526 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 740 Earl St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6020358.69967 | 2093703.87805 | 37.7300508614476 | -122.371891339508 | (37.7300508614476, -122.371891339508) | ||||
| 53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 163809 | 163809 | 201655 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 734 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6020157.476530001 | 2093804.76916 | 37.7303168341394 | -122.372593981633 | (37.7303168341394, -122.372593981633) | |||
| 67364 | 67364 | 201487 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 934 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6019005.827269999 | 2094664.79095 | 37.732614937414 | -122.37663506546801 | (37.732614937414, -122.376635065468) | |||
| 80072 | 80072 | 11492 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 85301 | 85301 | 11491 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 87201 | 87201 | 11504 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 102462 | 102462 | 11493 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 140516 | 140516 | 11495 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 78655 | 78655 | 41040 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 3 | 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) | |||
| 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) | |||
| 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) | |||
| 122197 | 122197 | 41039 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 4 | 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) | |||
| 124419 | 124419 | 41041 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 2 | 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) | |||
| 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) | ||
| 16675 | 16675 | 16465 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018666.35636 | 2097096.27558 | 37.7392726167438 | -122.37797742504 | (37.7392726167438, -122.37797742504) | |||
| 57459 | 57459 | 193632 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 200 Jennings St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6018633.93007 | 2096979.08345 | 37.738949043366794 | -122.37808140914 | (37.7389490433668, -122.37808140914) | |||
| 16833 | 16833 | 16463 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018612.88561 | 2097134.8000900003 | 37.7393754506279 | -122.378164978648 | (37.7393754506279, -122.378164978648) | |||
| 131263 | 131263 | 193633 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 200 Jennings St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6018603.8864400005 | 2096942.7454400002 | 37.73884761061421 | -122.378182765416 | (37.7388476106142, -122.378182765416) | |||
| 57591 | 57591 | 193634 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 200 Jennings St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6018590.822369999 | 2096922.8592400001 | 37.738792287028105 | -122.378226555236 | (37.7387922870281, -122.378226555236) | |||
| 180453 | 180453 | 193635 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 200 Jennings St | 9 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6018556.859730001 | 2096874.5912099998 | 37.7386578806661 | -122.378340633316 | (37.7386578806661, -122.378340633316) | |||
| 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) | ||
| 87861 | 87861 | 1990 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 118 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2004 12:00:00 AM | 3 | 3X4 | 6017898.3946760995 | 2094740.9470538998 | 37.73276300053679 | -122.380469061304 | (37.7327630005368, -122.380469061304) | ||
| 103134 | 103134 | 1983 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 102 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1996 12:00:00 AM | 12 | 3X4 | 6017840.507549 | 2094792.7784106003 | 37.732902124826104 | -122.38067279528299 | (37.7329021248261, -122.380672795283) | ||
| 20622 | 20622 | 1979 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 96 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 141322 | 141322 | 1975 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 81 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017802.667442501 | 2094895.5028312001 | 37.73318209752429 | -122.38081075812201 | (37.7331820975243, -122.380810758122) | ||
| 142105 | 142105 | 1974 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 75 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017781.0101898 | 2094915.5294804 | 37.7332358914551 | -122.380887025623 | (37.7332358914551, -122.380887025623) | ||
| 22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
| 83031 | 83031 | 1959 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 35 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3X4 | 6017662.293002901 | 2095057.1852268998 | 37.73361829711779 | -122.381307314085 | (37.7336182971178, -122.381307314085) | ||
| 99004 | 99004 | 1942 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017638.082631599 | 2095207.7846551002 | 37.7340304768318 | -122.381401486036 | (37.7340304768318, -122.381401486036) | ||
| 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) | ||
| 77963 | 77963 | 1947 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 12 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.733893179879104 | -122.38152697242501 | (37.7338931798791, -122.381526972425) | ||
| 98998 | 98998 | 1948 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 12 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2000 12:00:00 AM | 12 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.733893179879104 | -122.38152697242501 | (37.7338931798791, -122.381526972425) | ||
| 83637 | 83637 | 1956 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 28 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1995 12:00:00 AM | 12 | 3X3 | 6017599.7808961 | 2095067.264352 | 37.7336425212053 | -122.381524139501 | (37.7336425212053, -122.381524139501) | ||
| 102343 | 102343 | 1952 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 22 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/1999 12:00:00 AM | 6 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 117020 | 117020 | 1950 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 22 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/1995 12:00:00 AM | 12 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 9111 | 9111 | 10861 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9157 | 9157 | 10857 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 125436 | 125436 | 10854 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1299X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1998 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 67001 | 67001 | 193742 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6017172.8387400005 | 2094938.0801099997 | 37.73326422544871 | -122.382991229966 | (37.7332642254487, -122.382991229966) | |||
| 177282 | 177282 | 193741 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017141.893080001 | 2094930.29985 | 37.7332411524543 | -122.383097677329 | (37.7332411524543, -122.383097677329) | |||
| 148578 | 148578 | 193740 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017126.30838 | 2094926.52531 | 37.733229927126395 | -122.383151295797 | (37.7332299271264, -122.383151295797) | |||
| 55887 | 55887 | 193755 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1341 Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017108.32478 | 2095601.29953 | 37.7350817292465 | -122.38326042312401 | (37.7350817292465, -122.383260423124) | |||
| 159884 | 159884 | 193754 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1341 Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017078.90367 | 2095690.71977 | 37.735325633473 | -122.383368366053 | (37.735325633473, -122.383368366053) | |||
| 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) | |||
| 1995 | 1995 | 193739 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 4ft | 6016922.219330001 | 2094905.4243400001 | 37.7331607080971 | -122.383855425397 | (37.7331607080971, -122.383855425397) | |||
| 56228 | 56228 | 193738 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6016876.63395 | 2094918.1517400001 | 37.733193134938396 | -122.38401391381599 | (37.7331931349384, -122.384013913816) | |||
| 148546 | 148546 | 193737 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6016863.977080001 | 2094923.8572799999 | 37.733208101477 | -122.384058069641 | (37.733208101477, -122.384058069641) | |||
| 129994 | 129994 | 193736 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6016818.70639 | 2094940.8936 | 37.7332523768821 | -122.38421577024799 | (37.7332523768821, -122.384215770248) | |||
| 185037 | 185037 | 193575 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6016805.54039 | 2102635.7401099997 | 37.7543801281586 | -122.38479715317 | (37.7543801281586, -122.38479715317) | ||||
| 47688 | 47688 | 193735 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6016788.86532 | 2094953.98571 | 37.733286675233295 | -122.38431985147801 | (37.7332866752333, -122.384319851478) | |||
| 74266 | 74266 | 193576 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6016775.537380001 | 2102634.6197099998 | 37.7543753923365 | -122.384900834212 | (37.7543753923365, -122.384900834212) | ||||
| 174344 | 174344 | 193577 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016746.30136 | 2102631.89145 | 37.754366284000795 | -122.385001750754 | (37.7543662840008, -122.385001750754) | ||||
| 73562 | 73562 | 193578 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016715.48057 | 2102629.85839 | 37.7543589967884 | -122.385108196298 | (37.7543589967884, -122.385108196298) | ||||
| 14351 | 14351 | 24146 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 12 | 3x3 | 6016692.87185 | 2095191.38157 | 37.733933208639606 | -122.384668261453 | (37.7339332086396, -122.384668261453) | ||
| 69181 | 69181 | 193579 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016687.20636 | 2102628.57061 | 37.7543538967387 | -122.385205886941 | (37.7543538967387, -122.385205886941) | ||||
| 74867 | 74867 | 193580 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6016656.51597 | 2102626.40234 | 37.754346245297704 | -122.385311872064 | (37.7543462452977, -122.385311872064) | ||||
| 164911 | 164911 | 193743 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6016637.85786 | 2095631.9190900002 | 37.735139793969495 | -122.384889143935 | (37.7351397939695, -122.384889143935) | |||
| 14512 | 14512 | 24130 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016633.73992 | 2095504.76195 | 37.734790418140605 | -122.384894525455 | (37.7347904181406, -122.384894525455) | |||
| 176752 | 176752 | 193744 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016631.20601 | 2095628.7725799999 | 37.7351307863641 | -122.384911922862 | (37.7351307863641, -122.384911922862) | |||
| 26909 | 26909 | 193581 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016627.824130001 | 2102624.40575 | 37.754339175729704 | -122.38541095757 | (37.7543391757297, -122.38541095757) | ||||
| 13934 | 13934 | 24172 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 12 | 3x3 | 6016627.62077 | 2095425.11976 | 37.7345713981576 | -122.384910134993 | (37.7345713981576, -122.384910134993) | ||
| 181248 | 181248 | 193745 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6016619.65761 | 2095650.1794599998 | 37.7351889266095 | -122.38495334115 | (37.7351889266095, -122.38495334115) | |||
| 32468 | 32468 | 193582 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6016596.341630001 | 2102622.43103 | 37.7543320117256 | -122.385519695483 | (37.7543320117256, -122.385519695483) | ||||
| 168263 | 168263 | 193583 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6016566.8369 | 2102621.0686 | 37.7543266382749 | -122.38562163635 | (37.7543266382749, -122.38562163635) | ||||
| 26729 | 26729 | 193753 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 119 Lindsay Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016558.9112599995 | 2095642.3661200001 | 37.7351641125365 | -122.38516282111901 | (37.7351641125365, -122.385162821119) | |||
| 40619 | 40619 | 193584 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016537.00465 | 2102619.7128 | 37.7543212648174 | -122.385724710323 | (37.7543212648174, -122.385724710323) | ||||
| 177362 | 177362 | 193585 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6016477.60851 | 2102614.0606 | 37.754302458211995 | -122.38592972519501 | (37.754302458212, -122.385929725195) | |||
| 77154 | 77154 | 193746 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 122 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016471.52862 | 2095774.8405799998 | 37.735523026570895 | -122.385474166397 | (37.7355230265709, -122.385474166397) | |||
| 165636 | 165636 | 193752 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 123 Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6016460.5124699995 | 2095726.46941 | 37.7353895995422 | -122.38550888385001 | (37.7353895995422, -122.38550888385) | |||
| 160528 | 160528 | 193747 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 122 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016458.68095 | 2095791.2036099997 | 37.7355672453281 | -122.38551972606199 | (37.7355672453281, -122.385519726062) | |||
| 181398 | 181398 | 193586 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6016448.1037800005 | 2102612.69862 | 37.75429708564229 | -122.386031666023 | (37.7542970856423, -122.386031666023) | |||
| 172004 | 172004 | 193587 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6016422.18056 | 2102610.28551 | 37.754289025026104 | -122.38612114768499 | (37.7542890250261, -122.386121147685) | |||
| 60046 | 60046 | 193668 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016416.536169999 | 2108955.68127 | 37.7717118113759 | -122.386583100636 | (37.7717118113759, -122.386583100636) | |||
| 72507 | 72507 | 24170 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2004 12:00:00 AM | 8 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 92517 | 92517 | 24190 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 129196 | 129196 | 24175 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 6 | 4x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 138879 | 138879 | 24188 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 142562 | 142562 | 24187 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3x4 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 70538 | 70538 | 193669 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016408.23667 | 2108979.54137 | 37.7717768665387 | -122.386613473459 | (37.7717768665387, -122.386613473459) | |||
| 104772 | 104772 | 24069 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 187X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 6 | 3X3 | 6016398.9565531 | 2095907.2518992 | 37.7358825859465 | -122.38573430379101 | (37.7358825859465, -122.385734303791) | ||
| 9342 | 9342 | 24095 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 105X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1996 12:00:00 AM | 5 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 117807 | 117807 | 24078 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 161X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1996 12:00:00 AM | 6 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317004 | -122.385748008424 | (37.735990405317, -122.385748008424) | ||
| 63025 | 63025 | 193670 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6016394.5406 | 2109002.66427 | 37.7718395987389 | -122.3866624622 | (37.7718395987389, -122.3866624622) | |||
| 9276 | 9276 | 24081 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9378 | 9378 | 24087 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 141X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2000 12:00:00 AM | 9 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 30716 | 30716 | 193588 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6016388.406359999 | 2102608.3572299997 | 37.754281861036404 | -122.38623781404199 | (37.7542818610364, -122.386237814042) | |||
| 150587 | 150587 | 193748 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 130 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6016385.91828 | 2095926.8722599999 | 37.7359357380287 | -122.385780749793 | (37.7359357380287, -122.385780749793) | |||
| 131498 | 131498 | 193671 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6016385.34068 | 2109024.00386 | 37.77189768326 | -122.386695773996 | (37.77189768326, -122.386695773996) | |||
| 185613 | 185613 | 193751 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 123 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016384.6638400005 | 2095825.7901 | 37.735658117317705 | -122.38577804372 | (37.7356581173177, -122.38577804372) | |||
| 184846 | 184846 | 193672 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6016377.60752 | 2109047.85255 | 37.771962738417 | -122.38672418716699 | (37.771962738417, -122.386724187167) | |||
| 100947 | 100947 | 15006 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 600X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 3 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 143539 | 143539 | 15005 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 600X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1993 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 76221 | 76221 | 193673 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 255 Terry A Francois Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6016368.74181 | 2109071.72408 | 37.7720277935768 | -122.386756519596 | (37.7720277935768, -122.386756519596) | |||
| 134573 | 134573 | 193683 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 256 Terry A Francois Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6016363.57029 | 2108841.94978 | 37.771396597217105 | -122.386758382111 | (37.7713965972171, -122.386758382111) | |||
| 69303 | 69303 | 193749 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 129 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016363.16532 | 2096118.97513 | 37.736461954757 | -122.38587280260401 | (37.736461954757, -122.385872802604) |
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");