trees
930 rows where qSpecies_id = 65 sorted by qCareAssistant descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60112 | 66322 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) | 9 | 7 | 5 | 63 | 40 | ||
60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
61402 | 64790 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25786 | 6002754.53875379 | 2109297.20875 | 37.7718837652657 | -122.433865178188 | (37.7718837652657, -122.433865178188) | 15 | 5 | 11 | 29492 | 9 | ||
62771 | 62339 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.7360818148322 | -122.425411499586 | (37.7360818148322, -122.425411499586) | 2 | 7 | 5 | 28859 | 2 | ||
62808 | 67908 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.7283565792877 | -122.44478069728 | (37.7283565792877, -122.44478069728) | 9 | 7 | 4 | 28861 | 40 | ||
63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
65306 | 43793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 6 | Permit Number 43423 | 5989012.43621 | 2114211.91029 | 37.7845887590001 | -122.481759578125 | (37.7845887590001, -122.481759578125) | 11 | 6 | 2 | 55 | 26 | |
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 |
67978 | 67941 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.7346682618025 | -122.427968106929 | (37.7346682618025, -122.427968106929) | 2 | 7 | 5 | 28861 | 25 | ||
68583 | 38114 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | 1 | 8 | 3 | 56 | 35 | |
68631 | 68056 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | 1 | 8 | 4 | 56 | 12 | ||
68752 | 65658 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 72 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28578 | 5998676.92004406 | 2096648.99460169 | 37.7369226528823 | -122.44705951572 | (37.7369226528823, -122.44705951572) | 9 | 7 | 4 | 59 | 40 | ||
69147 | 33484 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.421068211473 | (37.741769825751, -122.421068211473) | 2 | 7 | 7 | 28859 | 2 |
69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
71288 | 53235 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31473 | 6004075.80842764 | 2102593.23401919 | 37.7535511453461 | -122.428816801411 | (37.7535511453461, -122.428816801411) | 2 | 4 | 5 | 28862 | 22 | ||
71957 | 95120 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54047 | 6002640 | 2094338 | 37.7308028218422 | -122.433192325631 | (37.7308028218422, -122.433192325631) | 9 | 7 | 5 | 28861 | 25 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
72103 | 40424 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.455589722394 | (37.7310042675093, -122.455589722394) | 9 | 7 | 4 | 28861 | 40 | |
72547 | 102082 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 577 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52510 | 5994678.1 | 2111611.2 | 37.7777757479831 | -122.461969778855 | (37.7777757479831, -122.461969778855) | 11 | 6 | 2 | 54 | 11 | |
73282 | 108847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.436297601751 | (37.7100901720951, -122.436297601751) | 9 | 7 | 6 | 28861 | 5 | |
74836 | 66622 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.7582514640983 | -122.407715901057 | (37.7582514640983, -122.407715901057) | 10 | 4 | 7 | 28859 | 19 | ||
75026 | 64105 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 531 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176 | 37.7433167168502 | -122.431798643811 | (37.7433167168502, -122.431798643811) | 2 | 7 | 5 | 63 | 22 | ||
76448 | 108926 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.7446927459132 | -122.417269529335 | (37.7446927459132, -122.417269529335) | 2 | 7 | 7 | 28859 | 2 |
76736 | 94821 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | 1 | 8 | 4 | 56 | 12 | |
77208 | 37072 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1426 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 14 | Permit Number 39847 | 5982799.9219 | 2105403.4894 | 37.7600401558558 | -122.502600230953 | (37.7600401558558, -122.502600230953) | 1 | 8 | 3 | 56 | 35 | |
77926 | 63770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 533 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24449 | 6003130.90758036 | 2110082.2752919 | 37.7740607150966 | -122.432619380335 | (37.7740607150966, -122.432619380335) | 15 | 9 | 11 | 29492 | 10 | ||
78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
79432 | 41233 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.8051663037497 | -122.435520011048 | (37.8051663037497, -122.435520011048) | 13 | 9 | 1 | 57 | 17 | |
80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
83501 | 66304 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 400 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | 3x50 | Permit Number 29418 | 6000123.45614997 | 2094964.38431909 | 37.732379648564 | -122.44193733537 | (37.732379648564, -122.44193733537) | 9 | 7 | 5 | 63 | 40 | |
83852 | 67386 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 725 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | Permit Number 30883 | 5991613.49950521 | 2110478.88524866 | 37.7744898098292 | -122.47248861667 | (37.7744898098292, -122.47248861667) | 11 | 6 | 2 | 54 | 26 | ||
83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
84530 | 62373 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 451 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | 2 | 7 | 5 | 63 | 7 | ||
84903 | 67260 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 596 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30727 | 5983830.17257963 | 2111769.87555254 | 37.7775809215722 | -122.499507644306 | (37.7775809215722, -122.499507644306) | 11 | 6 | 2 | 55 | 26 | ||
85395 | 64103 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | 11 | 8 | 11 | 56 | 12 | ||
85408 | 67245 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4738 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 15 | Permit Number 30709 | 5983942.53029 | 2111768.14196 | 37.7775827533368 | -122.499118839179 | (37.7775827533368, -122.499118839179) | 11 | 6 | 2 | 55 | 26 | |
85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
86106 | 66313 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.435659572604 | (37.7324561325978, -122.435659572604) | 9 | 7 | 5 | 63 | 40 | ||
86506 | 42268 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42509 | 5987415.8588 | 2105330.3292 | 37.7601094468303 | -122.486630755953 | (37.7601094468303, -122.486630755953) | 1 | 8 | 3 | 56 | 35 | |
87022 | 64145 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 447 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24920 | 6002941.41423586 | 2098582.0522051 | 37.7424731102471 | -122.432453304275 | (37.7424731102471, -122.432453304275) | 2 | 7 | 5 | 63 | 22 | ||
87243 | 109278 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.7560264628403 | -122.508644093874 | (37.7560264628403, -122.508644093874) | 1 | 8 | 3 | 56 | 35 |
88120 | 38113 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 9 | Permit Number 40278 | 5987108.7979 | 2106493.9222 | 37.7632864483052 | -122.487778208637 | (37.7632864483052, -122.487778208637) | 1 | 8 | 3 | 56 | 35 | |
88133 | 94732 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) | 11 | 6 | 1 | 54 | 31 |
89653 | 66234 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.458274198204 | (37.7221254446058, -122.458274198204) | 9 | 8 | 4 | 28861 | 24 | ||
89731 | 68540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 562 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 28 | Permit Number 32423 | 5982889.49723 | 2111962.75458 | 37.7780552740204 | -122.502775984008 | (37.7780552740204, -122.502775984008) | 11 | 6 | 2 | 55 | 26 | |
89825 | 67817 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 76 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31472 | 6004074.53693177 | 2102616.18239315 | 37.7536140842238 | -122.428822834401 | (37.7536140842238, -122.428822834401) | 2 | 4 | 5 | 28862 | 22 | ||
92074 | 109191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932 | 37.7614186014043 | -122.506913128145 | (37.7614186014043, -122.506913128145) | 1 | 8 | 3 | 56 | 35 |
93053 | 109277 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.507701279468 | (37.7531458375643, -122.507701279468) | 1 | 8 | 3 | 56 | 35 |
94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
95663 | 108501 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) | 11 | 8 | 11 | 56 | 12 |
95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
98307 | 64417 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25265 | 6003653.48603698 | 2098020.8724606 | 37.7409725927511 | -122.429951151332 | (37.7409725927511, -122.429951151332) | 2 | 7 | 5 | 63 | 7 | ||
98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
100080 | 67827 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31487 | 6004187.64685523 | 2101514.68763135 | 37.7505960386394 | -122.428353174015 | (37.7505960386394, -122.428353174015) | 2 | 4 | 5 | 28862 | 22 | ||
101142 | 65305 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3629 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28122 | 6005455.44263685 | 2104863.06150764 | 37.7598615508482 | -122.424207139046 | (37.7598615508482, -122.424207139046) | 2 | 4 | 5 | 28859 | 19 | ||
101694 | 94830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | 1 | 5 | 4 | 56 | 12 | |
102715 | 67506 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31036 | 5997894.54403764 | 2094074.0284741 | 37.7298076778319 | -122.449579034013 | (37.7298076778319, -122.449579034013) | 9 | 7 | 4 | 28861 | 40 | ||
103785 | 63866 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24569 | 6002490.08825783 | 2103093.39072976 | 37.7548345785172 | -122.434336316133 | (37.7548345785172, -122.434336316133) | 2 | 4 | 5 | 28862 | 22 | ||
103813 | 64171 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 610 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1987 12:00:00 AM | 21 | Permit Number 24952 | 5991942.3425 | 2111250.75611 | 37.7766281856646 | -122.471407349682 | (37.7766281856646, -122.471407349682) | 11 | 6 | 2 | 54 | 11 | |
104017 | 35736 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | 9 | 3 | 7 | 309 | 28 | |
104537 | 40196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 562 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 26 | Permit Number 41380 | 5983509.69459 | 2111981.18634 | 37.7781423109711 | -122.500631896768 | (37.7781423109711, -122.500631896768) | 11 | 6 | 2 | 55 | 26 | |
104709 | 66250 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | 9 | 8 | 4 | 28861 | 24 | ||
105309 | 35840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.14404 | 37.7196921382746 | -122.434176697315 | (37.7196921382746, -122.434176697315) | 9 | 7 | 6 | 28861 | 5 |
105607 | 95918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 682 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767617 | 5991324.67511 | 2110779.55477 | 37.7752986449747 | -122.473509641895 | (37.7752986449747, -122.473509641895) | 11 | 6 | 2 | 54 | 26 |
105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 | |
108472 | 109743 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.433953002704 | (37.7602597694278, -122.433953002704) | 2 | 4 | 5 | 28862 | 3 |
108513 | 254649 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 929 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781532 | 6000895.17385 | 2091578.90462 | 37.7231278434042 | -122.439026791536 | (37.7231278434042, -122.439026791536) | 9 | 7 | 6 | 28861 | 25 |
110025 | 255477 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2669 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780207 | 6000139.26098 | 2118831.12681 | 37.7979126806609 | -122.443596582177 | (37.7979126806609, -122.443596582177) | 13 | 9 | 1 | 57 | 17 | |
111637 | 37615 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 458 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 13 | Permit Number 40039 | 5990633.38312 | 2112269.25863 | 37.779348904808 | -122.476009778191 | (37.779348904808, -122.476009778191) | 11 | 6 | 2 | 54 | 26 | |
115535 | 94829 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.75996093558 | -122.462946257172 | (37.75996093558, -122.462946257172) | 1 | 5 | 4 | 56 | 12 | |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
118130 | 67911 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 66 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31614 | 5998875.49490681 | 2093226.9126308 | 37.7275377658836 | -122.446126879833 | (37.7275377658836, -122.446126879833) | 9 | 7 | 4 | 28861 | 40 | ||
120648 | 37604 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | 11 | 6 | 2 | 54 | 11 | |
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
122230 | 69299 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.983 | 2110939.1774 | 37.7762325313103 | -122.443691201885 | (37.7762325313103, -122.443691201885) | 15 | 5 | 11 | 29492 | 16 | |
124223 | 108505 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.41391 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) | 1 | 8 | 11 | 56 | 12 |
124672 | 94831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.462936786411 | (37.759825119308, -122.462936786411) | 1 | 5 | 4 | 56 | 12 | |
124927 | 114086 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5997489.0948 | 2113600.1035 | 37.783398187645 | -122.452389185424 | (37.783398187645, -122.452389185424) | 15 | 6 | 1 | 54 | 31 | |||
125569 | 109039 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2439 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773557 | 5985453.6 | 2098605.4 | 37.7415300428197 | -122.492921815189 | (37.7415300428197, -122.492921815189) | 1 | 8 | 3 | 29491 | 35 |
125993 | 47976 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1515 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | 2 | Permit Number 45710 | 5988978.856 | 2104994.3044 | 37.7592778047967 | -122.481200551177 | (37.7592778047967, -122.481200551177) | 1 | 8 | 3 | 56 | 35 | |
126015 | 109285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
127311 | 68456 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.79792 | 37.7860515606903 | -122.473303650104 | (37.7860515606903, -122.473303650104) | 11 | 6 | 2 | 54 | 26 | |
127600 | 39936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.33678 | 2088185.9421 | 37.7143129666441 | -122.408076686195 | (37.7143129666441, -122.408076686195) | 9 | 7 | 8 | 309 | 39 | |
128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
128743 | 47455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45361 | 5983102.34627 | 2110320.59838 | 37.7735588969863 | -122.501918137817 | (37.7735588969863, -122.501918137817) | 11 | 6 | 2 | 55 | 26 | |
129447 | 63292 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23858 | 6009183.06965006 | 2100534.27317896 | 37.7481854410784 | -122.411009292537 | (37.7481854410784, -122.411009292537) | 2 | 4 | 7 | 28859 | 2 | ||
129894 | 69204 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.411911217702 | (37.7518104876034, -122.411911217702) | 2 | 4 | 7 | 28859 | 19 | ||
132136 | 47448 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 714 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2016 12:00:00 AM | 3 | Permit Number 778519 | 5981684.9751 | 2110860.53049 | 37.7749580289324 | -122.506861007188 | (37.7749580289324, -122.506861007188) | 11 | 6 | 2 | 55 | 26 | |
132523 | 115548 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );