trees
930 rows where qSpecies_id = 65 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56987 | 63133 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | 2 | 7 | 7 | 28859 | 2 | ||
| 57235 | 125546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007858.97154 | 2118915.83985 | 37.798582528908 | -122.416890128576 | (37.798582528908, -122.416890128576) | 5 | 1 | 10 | 308 | 32 | |||
| 57703 | 64151 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24930 | 6003105.46054998 | 2099234.08620142 | 37.7442727453071 | -122.431932629736 | (37.7442727453071, -122.431932629736) | 2 | 7 | 5 | 63 | 22 | ||
| 58364 | 27336 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.35794 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | 9 | 7 | 5 | 63 | 40 | ||
| 58635 | 63004 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
| 58662 | 90802 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984840.95767 | 2110382.4709 | 37.7738307601846 | -122.495908677168 | (37.7738307601846, -122.495908677168) | 11 | 6 | 2 | 55 | 26 | ||
| 59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 | |||
| 59779 | 221868 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.7636595407827 | -122.45328544896 | (37.7636595407827, -122.45328544896) | 15 | 5 | 11 | 29492 | 12 | |||
| 59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
| 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 | ||
| 60476 | 90761 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4031 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 3x3 | 5983060.28234 | 2110318.76307 | 37.7735513866791 | -122.502063505002 | (37.7735513866791, -122.502063505002) | 11 | 6 | 2 | 55 | 26 | ||
| 60571 | 250774 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 261 32nd Ave | 1 | : | Tree | Private 2 | 30 | Width 3ft | 5985867.52173 | 2114167.09587 | 37.7842823263074 | -122.49263646502 | (37.7842823263074, -122.49263646502) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | ||
| 61694 | 26511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.7518298180943 | -122.411926215341 | (37.7518298180943, -122.411926215341) | 2 | 4 | 7 | 28859 | 19 | |||
| 62410 | 203526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2424 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.19197 | 2098908.13909 | 37.7427450799172 | -122.470121471754 | (37.7427450799172, -122.470121471754) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 63335 | 102588 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 222 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002344.3 | 2109244.2 | 37.7717149279992 | -122.435280428905 | (37.7717149279992, -122.435280428905) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 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 |
| 64032 | 221815 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008428.67762 | 2097499.17078 | 37.7398093887782 | -122.413403351802 | (37.7398093887782, -122.413403351802) | 2 | 7 | 7 | 28859 | 2 | |||
| 64228 | 114566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | 11 | 6 | 1 | 54 | 31 | |||
| 64528 | 90764 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3951X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983298.61127 | 2110327.61433 | 37.773589688119 | -122.501239757976 | (37.773589688119, -122.501239757976) | 11 | 6 | 2 | 55 | 26 | ||
| 64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 2 | 7 | 7 | 28859 | 2 | |||
| 65100 | 221877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.7455296507747 | -122.418615385312 | (37.7455296507747, -122.418615385312) | 2 | 7 | 7 | 28859 | 2 | |||
| 65253 | 114757 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | Permit Number 777137 | 6000857.2 | 2101959.2 | 37.7516275450509 | -122.439901966271 | (37.7516275450509, -122.439901966271) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |
| 65646 | 122045 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 207 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990216.73059 | 2113968.78837 | 37.783991172797 | -122.477575394407 | (37.783991172797, -122.477575394407) | 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 | |
| 66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
| 67738 | 221916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6004184.08219 | 2101438.38346 | 37.7503863234716 | -122.428360063075 | (37.7503863234716, -122.428360063075) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 |
| 69194 | 175204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 6005107.43376 | 2092594.03644 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | 9 | 7 | 6 | 28861 | 5 | ||||
| 69208 | 119901 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||
| 69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
| 69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
| 70357 | 221879 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | 2 | 7 | 7 | 28859 | 2 | |||
| 71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
| 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 | ||
| 71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
| 71659 | 221855 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 310 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000611.21677 | 2101947.64163 | 37.7515818030572 | -122.440751776575 | (37.7515818030572, -122.440751776575) | 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 | |
| 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 | |
| 72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 72559 | 221853 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002339.61262 | 2100938.00703 | 37.7489078650277 | -122.434702583968 | (37.7489078650277, -122.434702583968) | 2 | 4 | 5 | 28862 | 22 | |||
| 72768 | 90770 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3899X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983556.085422 | 2110343.567935 | 37.7736486085903 | -122.500350310129 | (37.7736486085903, -122.500350310129) | 11 | 6 | 2 | 55 | 26 | ||
| 72775 | 125543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 511 Webster St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | 7 | 9 | 11 | 29492 | 10 | |||
| 72933 | 221807 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004936.8002 | 2102544.12819 | 37.7534650059101 | -122.425835807291 | (37.7534650059101, -122.425835807291) | 2 | 4 | 5 | 28862 | 22 | |||
| 73034 | 94147 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.467590799812 | (37.7538665624087, -122.467590799812) | 1 | 8 | 4 | 56 | 12 | ||
| 73407 | 113205 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
| 73567 | 83915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1218 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50159 | 5982131.5385 | 2106775.0727 | 37.763766832166 | -122.505013452733 | (37.763766832166, -122.505013452733) | 1 | 8 | 3 | 56 | 35 | |
| 73676 | 102018 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 4252 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001333 | 2103370 | 37.7555283353782 | -122.438357655981 | (37.7555283353782, -122.438357655981) | 2 | 4 | 5 | 28862 | 3 | |||
| 73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
| 73986 | 221859 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000847.19345 | 2101982.10251 | 37.7516898602076 | -122.439938212095 | (37.7516898602076, -122.439938212095) | 2 | 4 | 5 | 28862 | 22 | |||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 75216 | 221785 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 69 Scott St | 1 | : | Tree | Private 2 | 19 | Width 3ft | 6002359.55948 | 2108655.68222 | 37.7700998701305 | -122.435185544178 | (37.7700998701305, -122.435185544178) | 15 | 5 | 5 | 29492 | 9 | |||
| 75795 | 118877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5981379.17338 | 2110733.6758 | 37.7745917102455 | -122.507909405784 | (37.7745917102455, -122.507909405784) | 11 | 6 | 2 | 55 | 26 | |||
| 76041 | 59441 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.9190799 | 2095333.58373446 | 37.7336281759245 | -122.42766636908 | (37.7336281759245, -122.42766636908) | 2 | 7 | 5 | 28861 | 25 | |||
| 76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |
| 76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
| 76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
| 77457 | 175216 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | 10 | 3 | 7 | 309 | 28 | |||
| 77808 | 104992 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.7412333126477 | -122.505795454359 | (37.7412333126477, -122.505795454359) | 1 | 8 | 3 | 29491 | 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 | ||
| 78891 | 115281 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | 1 | 8 | 3 | 29491 | 35 | |||
| 79042 | 95674 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1898X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x6 | 5989702.02326 | 2113382.65311 | 37.7823519280112 | -122.479313179938 | (37.7823519280112, -122.479313179938) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 79694 | 221813 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007573.94838 | 2095674.48731 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | 2 | 7 | 7 | 28859 | 2 | |||
| 80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
| 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 | ||
| 80295 | 175183 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003446.11855 | 2091231.22966 | 37.7223180210418 | -122.430183890869 | (37.7223180210418, -122.430183890869) | 9 | 7 | 6 | 28861 | 5 | |||
| 82437 | 90776 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3801X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983735.95053 | 2110343.42811 | 37.7736587806838 | -122.499728128689 | (37.7736587806838, -122.499728128689) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |
| 85505 | 221920 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | 4x4 | 6003802.10196 | 2102678.82151 | 37.7537706531042 | -122.429769441907 | (37.7537706531042, -122.429769441907) | 2 | 4 | 5 | 28862 | 22 | |||
| 85775 | 30579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 396 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | 2 | Permit Number 34554 | 6003425.76209 | 2108645.89167 | 37.7701334751172 | -122.43149686511 | (37.7701334751172, -122.43149686511) | 15 | 9 | 11 | 29492 | 10 | ||
| 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 |
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) );