trees
8,659 rows where qSpecies_id = 11 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194481 | 256359 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2655 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 48401 | 6005661 | 2119519 | 37.8001147748179 | -122.424538736295 | (37.8001147748179, -122.424538736295) | 13 | 9 | 1 | 57 | 17 | ||
194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
194400 | 265055 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194393 | 254878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3156 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:28:00 AM | 3 | 3x6 | 5995145 | 2086533 | 37.708944125162 | -122.458538785751 | (37.708944125162, -122.458538785751) | 9 | 8 | 6 | 28861 | 25 | ||
194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194386 | 73728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2020 11:22:00 AM | 3 | Permit Number 782600 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | 3 | 1 | 10 | 308 | 23 | |
194385 | 115926 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:25:00 AM | 3 | 3x3 | 6014797.50176 | 2113407.35792 | 37.7838453529251 | -122.392494926324 | (37.7838453529251, -122.392494926324) | 6 | 2 | 9 | 28856 | 6 | ||
194357 | 265018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 303 Goettingen St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
194352 | 265022 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194338 | 265025 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194335 | 265024 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |
194286 | 171103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001233.28844 | 2091580.94986 | 37.7231526917255 | -122.437858144945 | (37.7231526917255, -122.437858144945) | 9 | 7 | 6 | 28861 | 25 | ||
194285 | 171104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001222.88972 | 2091557.90636 | 37.7230888281699 | -122.437892441496 | (37.7230888281699, -122.437892441496) | 9 | 7 | 6 | 28861 | 25 | ||
194280 | 171105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001198.95061 | 2091509.82624 | 37.7229554497111 | -122.437971751813 | (37.7229554497111, -122.437971751813) | 9 | 7 | 6 | 28861 | 25 | ||
194276 | 262536 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
194272 | 177230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | |||
194247 | 208416 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 41 San Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993629.26632 | 2097570.14805 | 37.7391622231523 | -122.464578224227 | (37.7391622231523, -122.464578224227) | 1 | 8 | 4 | 59 | 40 | |||
194230 | 251520 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | 7 | 9 | 5 | 28862 | 3 | ||||
194228 | 112094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6019767.42453 | 2093316.76888 | 37.7289554377256 | -122.373908674444 | (37.7289554377256, -122.373908674444) | 10 | 3 | 8 | 58 | 1 | |||
194225 | 21968 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2580 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/1995 12:00:00 AM | 3 | 3x3 | 6015815.49965 | 2103569.56022 | 37.7568893941329 | -122.38828616762 | (37.7568893941329, -122.38828616762) | 10 | 3 | 8 | 28856 | 29 | ||
194212 | 102173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
194208 | 64728 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1007 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25684 | 6001310.25667313 | 2108993.45457351 | 37.7709676675547 | -122.438839270723 | (37.7709676675547, -122.438839270723) | 15 | 5 | 11 | 29492 | 9 | ||
194194 | 255691 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
194193 | 108718 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1103 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||||
194174 | 7713 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2005 12:00:00 AM | 3 | 3x3 | 6006483.35851 | 2110441.04443 | 37.7752353575277 | -122.421048133036 | (37.7752353575277, -122.421048133036) | 7 | 9 | 11 | 28852 | 10 | ||
194161 | 23222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 655X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6006626.36739 | 2112726.37233 | 37.7815183756303 | -122.420715704793 | (37.7815183756303, -122.420715704793) | 7 | 9 | 11 | 28852 | 41 | |||
194131 | 130355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 52 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010894.64423 | 2121412.40566 | 37.805607771039 | -122.406561715266 | (37.805607771039, -122.406561715266) | 3 | 1 | 10 | 308 | 23 | |||
194077 | 103149 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2013 12:00:00 AM | 11 | Permit Number 770156 | 6009026.54065 | 2110070.43459 | 37.7743607833574 | -122.412224456604 | (37.7743607833574, -122.412224456604) | 8 | 2 | 9 | 28853 | 34 | ||
194072 | 29516 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016223.32775 | 2092631.55928 | 37.7268784667079 | -122.386113243292 | (37.7268784667079, -122.386113243292) | 10 | 3 | 8 | 58 | 1 | ||
194060 | 208352 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990623.6066 | 2093323.81913 | 37.7273291513948 | -122.474660498502 | (37.7273291513948, -122.474660498502) | 9 | 8 | 4 | 64 | 40 | |||
194054 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
194049 | 228938 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 380 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008897.05782 | 2106480.01475 | 37.7644950595124 | -122.412418524916 | (37.7644950595124, -122.412418524916) | 8 | 4 | 7 | 28859 | 19 | |||
194027 | 202599 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701 Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6011831.82376 | 2108412.95713 | 37.7699667390041 | -122.402403834675 | (37.7699667390041, -122.402403834675) | 14 | 2 | 8 | 28856 | 20 | |||
194023 | 202816 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014819.05 | 2108728.31157 | 37.7709989385684 | -122.392093047168 | (37.7709989385684, -122.392093047168) | 14 | 3 | 9 | 310 | 20 | |||
193996 | 91442 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 7 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
193983 | 37505 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 844 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 5 | Permit Number 39966 | 6008738.78411 | 2115522.43215 | 37.7893145134135 | -122.41360555267 | (37.7893145134135, -122.41360555267) | 5 | 1 | 10 | 28858 | 21 | |
193940 | 99081 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 511 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2012 12:00:00 AM | 3 | 3x3 | 6006244.53682 | 2106614.02725 | 37.7647138154977 | -122.421602404791 | (37.7647138154977, -122.421602404791) | 8 | 4 | 7 | 28859 | 19 | ||
193829 | 46439 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 801 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | Permit Number 44657 | 6009047.36226192 | 2120070.50682291 | 37.8018197316674 | -122.41285958718 | (37.8018197316674, -122.41285958718) | 3 | 1 | 10 | 308 | 32 | |||
193788 | 201170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 33 | : | Tree | Private 2 | 10 | Width 4ft | 6015271.48555 | 2098760.70975 | 37.7436551425697 | -122.389831700987 | (37.7436551425697, -122.389831700987) | 10 | 3 | 8 | 58 | 1 | |||
193780 | 11487 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018880.35523 | 2097308.40588 | 37.7398668752499 | -122.37725221891 | (37.7398668752499, -122.37725221891) | 10 | 3 | 8 | 58 | 1 | |||
193763 | 102139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769373 | 6015359.41153 | 2114501.84584 | 37.7868817564363 | -122.390627418428 | (37.7868817564363, -122.390627418428) | 6 | 2 | 9 | 28855 | 6 | |
193751 | 228173 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 790 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009281.09383 | 2104597.48375 | 37.7593476027269 | -122.410957270477 | (37.7593476027269, -122.410957270477) | 2 | 4 | 7 | 28859 | 19 | |||
193750 | 208415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 41 San Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993617.72192 | 2097562.94497 | 37.7391417797728 | -122.46461761633 | (37.7391417797728, -122.46461761633) | 1 | 8 | 4 | 59 | 40 | |||
193736 | 63753 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 714 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/1993 12:00:00 AM | Permit Number 24426 | 6003137.88940085 | 2109646.80433687 | 37.7728654152301 | -122.432564117591 | (37.7728654152301, -122.432564117591) | 15 | 5 | 11 | 29492 | 9 | ||
193723 | 64802 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 164 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25801 | 6004840.80279914 | 2099324.03629974 | 37.744617952474 | -122.425938585487 | (37.744617952474, -122.425938585487) | 2 | 7 | 5 | 63 | 22 | ||
193711 | 160060 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:55:00 AM | 3 | Width 0ft | 6000567.25094 | 2091038.34873 | 37.7216249360359 | -122.440121609938 | (37.7216249360359, -122.440121609938) | 9 | 7 | 6 | 28861 | 25 | ||
193708 | 177243 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Vienna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003782.67112 | 2091175.85705 | 37.7221850364957 | -122.429016561859 | (37.7221850364957, -122.429016561859) | 9 | 7 | 6 | 28861 | 5 | |||
193691 | 130248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2347 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007517.09362 | 2120471.36361 | 37.802834369771 | -122.418183477782 | (37.802834369771, -122.418183477782) | 5 | 1 | 1 | 28858 | 32 | |||
193660 | 59455 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 443 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31623 | 6003271.74004842 | 2095168.91222267 | 37.733120135626 | -122.431067583223 | (37.733120135626, -122.431067583223) | 9 | 7 | 5 | 28861 | 25 | ||
193628 | 129872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977331 | -122.443006850904 | (37.803723977331, -122.443006850904) | 13 | 9 | 1 | 57 | 17 | ||
193616 | 249385 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Leavenworth St | 1 | : | Tree | Private 2 | 19 | Width 3ft | 6008571.97895 | 2113231.13563 | 37.7830137992946 | -122.414020520533 | (37.7830137992946, -122.414020520533) | 7 | 10 | 9 | 28852 | 36 | |||
193569 | 253745 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
193539 | 250066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6005808.20486 | 2115684.74438 | 37.7895951873257 | -122.423756571109 | (37.7895951873257, -122.423756571109) | 13 | 9 | 1 | 28858 | 41 | |||
193523 | 23584 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/25/1990 12:00:00 AM | 18 | 3X3 | 6005448.93118 | 2121362.59765 | 37.8051648419518 | -122.425403847517 | (37.8051648419518, -122.425403847517) | 13 | 1 | 1 | 28858 | 17 | ||
193512 | 228860 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 280 Valencia St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6006056.35469 | 2108012.98149 | 37.768544399132 | -122.422352683528 | (37.768544399132, -122.422352683528) | 8 | 4 | 5 | 28853 | 19 | |||
193493 | 24949 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2546 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/25/1995 12:00:00 AM | 8 | 3x3 | 6015784.41472 | 2103697.39561 | 37.7572386805017 | -122.388402594091 | (37.7572386805017, -122.388402594091) | 10 | 3 | 8 | 28856 | 29 | ||
193401 | 16304 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 750 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3X3 | 5997121.6948006 | 2094756.564309 | 37.7316375145123 | -122.452300078462 | (37.7316375145123, -122.452300078462) | 9 | 7 | 4 | 59 | 40 | |||
193396 | 201594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.85351 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | 10 | 3 | 8 | 58 | 1 | |
193389 | 39001 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2180 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | 8 | 4 | 7 | 28859 | 19 | ||
193354 | 15210 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1142 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1995 12:00:00 AM | 12 | 3X3 | 6009135.951727 | 2111577.9227488 | 37.7785061292027 | -122.411952533595 | (37.7785061292027, -122.411952533595) | 8 | 2 | 9 | 28853 | 34 | ||
193322 | 191632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 55 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011199.76473 | 2113970.42096 | 37.785190941053 | -122.404981482304 | (37.785190941053, -122.404981482304) | 12 | 2 | 9 | 28853 | 6 | |||
193298 | 202467 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015388.12532 | 2113970.91678 | 37.7854255390959 | -122.390490962491 | (37.7854255390959, -122.390490962491) | 6 | 2 | 9 | 28856 | 6 | |||
193287 | 47626 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Anza St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
193229 | 202755 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 89 Long Bridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014173.05581 | 2108781.60884 | 37.7711093933122 | -122.39433130954 | (37.7711093933122, -122.39433130954) | 14 | 3 | 9 | 310 | 20 | |||
193168 | 192588 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008076.99245 | 2110569.93969 | 37.7756789790456 | -122.415544502703 | (37.7756789790456, -122.415544502703) | 8 | 2 | 9 | 28853 | 34 | |||
193148 | 202437 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015405.21153 | 2113203.46676 | 37.783319243218 | -122.390378208203 | (37.783319243218, -122.390378208203) | 6 | 2 | 9 | 28856 | 6 | |||
193107 | 41361 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 78 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 42009 | 6001390.89348952 | 2091809.60482018 | 37.7237894873823 | -122.437329701172 | (37.7237894873823, -122.437329701172) | 9 | 7 | 6 | 28861 | 25 | |||
193096 | 130256 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2314 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007576.57707 | 2120386.8429 | 37.8026056451813 | -122.417971638875 | (37.8026056451813, -122.417971638875) | 5 | 1 | 1 | 308 | 32 | |||
193076 | 116525 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 371 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5988056.07752 | 2113501.15126 | 37.7825815558183 | -122.485016050979 | (37.7825815558183, -122.485016050979) | 11 | 6 | 2 | 55 | 26 | |||
193070 | 130043 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 575 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008564.13112 | 2114167.37929 | 37.7855840580976 | -122.414113928634 | (37.7855840580976, -122.414113928634) | 7 | 10 | 9 | 28852 | 36 | |||
193065 | 10476 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1647 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2007 12:00:00 AM | 3 | 3X3 | 5998254.75195 | 2108533.65792 | 37.7695308729212 | -122.449375167067 | (37.7695308729212, -122.449375167067) | 15 | 5 | 11 | 29492 | 9 | ||
193048 | 208468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 32 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001918.10531 | 2094813.51371 | 37.732067495808 | -122.435722034761 | (37.732067495808, -122.435722034761) | 9 | 7 | 4 | 63 | 40 | |||
193042 | 7738 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 325 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2011 12:00:00 AM | 1 | 3x3 | 6006374.72821 | 2111215.69184 | 37.7773562281519 | -122.421478937302 | (37.7773562281519, -122.421478937302) | 7 | 9 | 11 | 28852 | 10 | ||
193025 | 192683 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6017532.94915 | 2095576.52883 | 37.7350371705259 | -122.381790607154 | (37.7350371705259, -122.381790607154) | 10 | 3 | 8 | 58 | 1 | |||
193019 | 19215 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6002312.42329 | 2110152.97949 | 37.7742084006424 | -122.435455713503 | (37.7742084006424, -122.435455713503) | 15 | 5 | 11 | 29492 | 10 | ||
192987 | 130364 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011804.63165 | 2121081.32693 | 37.8047495777032 | -122.403389250627 | (37.8047495777032, -122.403389250627) | 3 | 1 | 10 | 28860 | 6 | |||
192918 | 29325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 14 | Median : Cutout | Tree | DPW 1 | 02/22/2012 12:00:00 AM | 3 | 3X3 | 5993890.85963 | 2097870.98199 | 37.7400033149961 | -122.463695588204 | (37.7400033149961, -122.463695588204) | 1 | 8 | 4 | 59 | 40 | ||
192900 | 22218 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4250X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2016 02:07:00 PM | 3 | 3X3 | 6015384.98643 | 2097123.18461 | 37.7391651289337 | -122.389324913037 | (37.7391651289337, -122.389324913037) | 10 | 3 | 8 | 58 | 1 | ||
192898 | 84423 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 802 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50605 | 6007510.38620129 | 2104974.28835226 | 37.7602827696642 | -122.41710795615 | (37.7602827696642, -122.41710795615) | 2 | 4 | 7 | 28859 | 19 | ||
192859 | 123073 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992276.88042 | 2110588.11512 | 37.7748280997984 | -122.470201831217 | (37.7748280997984, -122.470201831217) | 11 | 6 | 2 | 54 | 11 | |||
192849 | 87323 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50324 | 6009422.52318 | 2116071.79921 | 37.7908613122503 | -122.41127871064 | (37.7908613122503, -122.41127871064) | 5 | 1 | 10 | 28857 | 21 | |
192837 | 208345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3594 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990578.14128 | 2092637.23298 | 37.7254413233411 | -122.474767578959 | (37.7254413233411, -122.474767578959) | 9 | 8 | 4 | 64 | 40 | |||
192827 | 202556 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 310 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013885.5617 | 2110879.85713 | 37.7768547265894 | -122.395472792051 | (37.7768547265894, -122.395472792051) | 6 | 2 | 9 | 28856 | 34 | |||
192820 | 247189 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1071 Haight St | 1 | : | Tree | Private 2 | 9 | Width 6ft | 6001018.37543 | 2108954.40537 | 37.7708438378908 | -122.439846093626 | (37.7708438378908, -122.439846093626) | 15 | 5 | 11 | 29492 | 9 | |||
192815 | 2105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/1990 12:00:00 AM | 6 | 3x3 | 6001357.51702 | 2095581.20199 | 37.7341435321789 | -122.437715068207 | (37.7341435321789, -122.437715068207) | 9 | 7 | 5 | 63 | 40 | ||
192808 | 228187 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1120 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006333.78844 | 2103042.74756 | 37.7549129467905 | -122.421040115804 | (37.7549129467905, -122.421040115804) | 2 | 4 | 5 | 28859 | 19 | |||
192793 | 29340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 6 | Median : Cutout | Tree | DPW 1 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992236.5627249 | 2096694.9403025 | 37.7366787380665 | -122.469329833584 | (37.7366787380665, -122.469329833584) | 1 | 8 | 4 | 59 | 40 | ||
192767 | 60594 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 631 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/1983 12:00:00 AM | Permit Number 20214 | 6000545.1111582 | 2111104.98335416 | 37.7767218316587 | -122.441637479652 | (37.7767218316587, -122.441637479652) | 15 | 5 | 11 | 29492 | 16 | ||
192748 | 16136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 367 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:10:00 AM | 3 | 3X3 | 5999657.2002909 | 2094637.0228616 | 37.7314542103197 | -122.443525777946 | (37.7314542103197, -122.443525777946) | 9 | 7 | 4 | 63 | 40 | ||
192744 | 87690 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2630 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010490.11707 | 2086047.16098 | 37.7084800771634 | -122.405469399602 | (37.7084800771634, -122.405469399602) | 9 | 7 | 8 | 309 | 39 | |||
192715 | 121509 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
192699 | 202365 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015689.10604 | 2115286.99254 | 37.7890558755877 | -122.389541595868 | (37.7890558755877, -122.389541595868) | 6 | 2 | 9 | 28855 | 6 | |||
192672 | 26251 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1489 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005923.4465 | 2100309.78833 | 37.7473857291771 | -122.422265034722 | (37.7473857291771, -122.422265034722) | 2 | 7 | 7 | 28859 | 22 | |||
192642 | 16812 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2097X O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999009.37837 | 2112716.355 | 37.7810586242256 | -122.447066002739 | (37.7810586242256, -122.447066002739) | 15 | 5 | 1 | 54 | 16 | |||
192631 | 18116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 5994256.15058 | 2097914.09085 | 37.7401427234041 | -122.46243569826 | (37.7401427234041, -122.46243569826) | 1 | 8 | 4 | 59 | 40 | |||
192624 | 202406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6015438.73605 | 2114895.41936 | 37.7879668199458 | -122.390380480784 | (37.7879668199458, -122.390380480784) | 6 | 2 | 9 | 28855 | 6 |
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) );