trees
8,659 rows where qSpecies_id = 11 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8373 | 16614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | 15 | 5 | 5 | 28862 | 3 | ||
31609 | 16684 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 262 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1998 12:00:00 AM | 3 | 4x4 | privately planted on DPW street; unpermitted | 6002878.0000942 | 2106783.4724174 | 37.7649886658228 | -122.4332584684 | (37.7649886658228, -122.4332584684) | 15 | 5 | 5 | 28862 | 3 | |
57073 | 86829 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2009 12:00:00 AM | 3 | 3x3 | privately planted on DPW street; unpermitted | 6002882.169263 | 2106798.606637 | 37.7650304572247 | -122.433245129787 | (37.7650304572247, -122.433245129787) | 15 | 5 | 5 | 28862 | 3 | |
146966 | 110456 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200X Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | next to cross walk | 5998971.77907 | 2112109.89902 | 37.7793913048339 | -122.447152418644 | (37.7793913048339, -122.447152418644) | 15 | 5 | 1 | 54 | 16 | |||
152608 | 13294 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2680X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2001 12:00:00 AM | 8 | 3X3 | Tree located adjacent to 3000 Baker | 5999556.3855 | 2119169.40502 | 37.7988082423603 | -122.445637828136 | (37.7988082423603, -122.445637828136) | 13 | 9 | 1 | 57 | 17 | |
114047 | 93863 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree 3 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | |||
103086 | 93862 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree 2 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | |||
15015 | 127892 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 623 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133535 | (37.7994012851886, -122.40934133535) | 3 | 1 | 10 | 308 | 4 | |
51816 | 53975 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 568 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 9691 | 6011465.5040552 | 2109667.69940903 | 37.773391518391 | -122.403759236878 | (37.773391518391, -122.403759236878) | 14 | 2 | 9 | 28853 | 34 | ||
128633 | 53857 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 720 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2002 12:00:00 AM | Permit Number 9566 | 6015422.17631644 | 2105692.8193858 | 37.7626976065973 | -122.38979473959 | (37.7626976065973, -122.38979473959) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | ||||
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 | ||
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 | ||
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 | ||
9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
10513 | 208259 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 7 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | Permit Number 784463 | 5993794.93642 | 2097790.46819 | 37.7397767164315 | -122.464021405387 | (37.7397767164315, -122.464021405387) | 1 | 8 | 4 | 59 | 40 | ||
14866 | 259322 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1721 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783194 | 5990247 | 2103661 | 37.7556905489205 | -122.476717329726 | (37.7556905489205, -122.476717329726) | 1 | 8 | 3 | 56 | 35 | |
7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
13211 | 262230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
16663 | 262231 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
93574 | 27384 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2200 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782612 | 6007162.48532 | 2119880.42159 | 37.8011918263885 | -122.419368660151 | (37.8011918263885, -122.419368660151) | 5 | 1 | 1 | 28858 | 32 |
14578 | 252915 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782602 | 6007321 | 2118975 | 37.7987146929528 | -122.418755881393 | (37.7987146929528, -122.418755881393) | 5 | 1 | 10 | 28858 | 32 | |
8544 | 256668 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1835 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782601 | |||||||||||
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 | |
62641 | 130232 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2013 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782588 | 6007201.62912 | 2119237.06192 | 37.7994275274066 | -122.419187542977 | (37.7994275274066, -122.419187542977) | 5 | 1 | 1 | 28858 | 32 |
154181 | 223790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 190x Storrie St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782422 | 6000695.90206 | 2105313.46128 | 37.7608283472609 | -122.440700329057 | (37.7608283472609, -122.440700329057) | 15 | 4 | 5 | 28862 | 3 | |
73284 | 13119 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782191 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.428567078189 | (37.8007111944994, -122.428567078189) | 13 | 9 | 1 | 57 | 17 | |
152694 | 255719 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
159737 | 255720 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
166990 | 255718 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1439 Egbert Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782102 | 6014162.95189 | 2091220.54477 | 37.7228898540298 | -122.393137282048 | (37.7228898540298, -122.393137282048) | 10 | 3 | 8 | 58 | 1 | |
164067 | 255486 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1145 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781956 | 6007615.88792 | 2116302.6982 | 37.7913938147597 | -122.417545974724 | (37.7913938147597, -122.417545974724) | 5 | 1 | 10 | 28858 | 21 | |
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 | |
22472 | 228598 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2130 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781848 | 6008719.47717 | 2105938.46018 | 37.7629981083047 | -122.412994436344 | (37.7629981083047, -122.412994436344) | 8 | 4 | 7 | 28859 | 19 | |
4844 | 228872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 4x7 | Permit Number 781830 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.429273464001 | (37.7698314611737, -122.429273464001) | 7 | 9 | 5 | 29492 | 10 | |
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 | |||||||||||
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 | |||||||||||
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 | |
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 | |
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 | |||||||||||
47572 | 70297 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | Permit Number 781520 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856 | (37.7316793628021, -122.43083747856) | 9 | 7 | 5 | 28861 | 25 | |
90520 | 218792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1259 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781518 | 5995767.3383 | 2106956.01161 | 37.7650564658073 | -122.457864799536 | (37.7650564658073, -122.457864799536) | 15 | 5 | 11 | 56 | 12 | |
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
17749 | 13265 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000636.2224 | 2119294.0135 | 37.7992119752158 | -122.441910200363 | (37.7992119752158, -122.441910200363) | 13 | 9 | 1 | 57 | 17 | |
148306 | 96613 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2018 12:00:00 AM | 3 | Permit Number 780998 | 5997328.97921 | 2115415.06267 | 37.7883724097142 | -122.453074178449 | (37.7883724097142, -122.453074178449) | 11 | 6 | 1 | 54 | 31 | ||
112660 | 169518 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1783 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780948 | 6003426.12868 | 2097901.04069 | 37.7406306838602 | -122.430728719953 | (37.7406306838602, -122.430728719953) | 2 | 7 | 5 | 63 | 7 | |
134723 | 253522 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429 | 2110577 | 37.7757181448456 | -122.414327317098 | (37.7757181448456, -122.414327317098) | 8 | 2 | 9 | 28853 | 34 | |
179645 | 253523 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429 | 2110577 | 37.7757181448456 | -122.414327317098 | (37.7757181448456, -122.414327317098) | 8 | 2 | 9 | 28853 | 34 | |
29350 | 25362 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 974 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780532 | 6000558.35356 | 2088917.09573 | 37.7157999479938 | -122.440000340863 | (37.7157999479938, -122.440000340863) | 9 | 7 | 6 | 28861 | 5 | |
14409 | 177162 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.7117866217183 | -122.415851310014 | (37.7117866217183, -122.415851310014) | 9 | 7 | 8 | 309 | 39 | ||
84012 | 177160 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | 9 | 7 | 8 | 309 | 39 | ||
6806 | 105051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.7696337718916 | -122.445015457708 | (37.7696337718916, -122.445015457708) | 15 | 5 | 11 | 29492 | 9 | ||
150231 | 202415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779903 | 6014884.87723 | 2114997.01321 | 37.7882150346369 | -122.39230385636 | (37.7882150346369, -122.39230385636) | 6 | 2 | 9 | 28855 | 6 | |
57656 | 23112 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.39627 | 2101132.22455 | 37.7496728724239 | -122.420549657939 | (37.7496728724239, -122.420549657939) | 2 | 4 | 5 | 28859 | 19 | |
11295 | 202609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 779780 | 6011126.85654 | 2109894.99849 | 37.7739967054258 | -122.404946679448 | (37.7739967054258, -122.404946679448) | 14 | 2 | 9 | 28853 | 34 | |
16708 | 202611 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 779780 | 6011168.27337 | 2109934.33837 | 37.7741070387293 | -122.404806181057 | (37.7741070387293, -122.404806181057) | 14 | 2 | 9 | 28853 | 34 | |
19502 | 202610 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 779780 | 6011146.73396 | 2109912.71541 | 37.774046463106 | -122.404879167343 | (37.774046463106, -122.404879167343) | 14 | 2 | 9 | 28853 | 34 | |
144018 | 59196 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 272 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1980 12:00:00 AM | 8 | Permit Number 779761 | 6009046.37885 | 2109959.18695 | 37.7740564365968 | -122.41214796835 | (37.7740564365968, -122.41214796835) | 8 | 2 | 9 | 28853 | 34 | ||
22154 | 253153 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.7639151913093 | -122.388942967508 | (37.7639151913093, -122.388942967508) | 14 | 3 | 8 | 28856 | 29 | |||
76599 | 21893 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2017 12:00:00 AM | 3 | 3xe | Permit Number 779475 | 6015620.28579 | 2106039.25281 | 37.7636598220322 | -122.389133734093 | (37.7636598220322, -122.389133734093) | 14 | 3 | 8 | 28856 | 29 | |
95058 | 46773 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.436130989761 | (37.7243489150655, -122.436130989761) | 9 | 7 | 6 | 28861 | 25 | |
46452 | 251696 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779453 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | |||
57393 | 32292 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 33 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779433 | 6003387.91451 | 2105627.26072 | 37.7618429012603 | -122.431412258663 | (37.7618429012603, -122.431412258663) | 15 | 4 | 5 | 28862 | 3 | ||
157861 | 73645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779343 | 6007472.09297 | 2115109.13151 | 37.7881084820636 | -122.417958855918 | (37.7881084820636, -122.417958855918) | 13 | 1 | 10 | 28858 | 21 |
4975 | 251136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
46801 | 251137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828 | 2094364 | 37.7312793503434 | -122.408343985354 | (37.7312793503434, -122.408343985354) | 10 | 3 | 7 | 309 | 28 | |
92468 | 251135 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
190359 | 251134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1x Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558 | 2094169 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | 10 | 3 | 7 | 309 | 28 | |
22422 | 122907 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Mint St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779214 | 6010498.83979 | 2112905.93981 | 37.7822289213752 | -122.40733140902 | (37.7822289213752, -122.40733140902) | 14 | 2 | 9 | 28853 | 34 | |
26732 | 9905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1801 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779094 | 6005234.1394 | 2115947.34634 | 37.790283803614 | -122.425761478317 | (37.790283803614, -122.425761478317) | 13 | 9 | 1 | 28858 | 27 | |
82397 | 32254 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | 3x3 | Permit Number 779058 | 6007188.44453353 | 2109602.50556833 | 37.7729726509951 | -122.41854960025 | (37.7729726509951, -122.41854960025) | 8 | 2 | 9 | 28853 | 19 | ||
25361 | 113722 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 57 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 779057 | 5994581 | 2092950 | 37.7265312490745 | -122.460952813642 | (37.7265312490745, -122.460952813642) | 9 | 8 | 4 | 28861 | 40 | ||
119319 | 52913 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 150X Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2006 12:00:00 AM | 18 | 3x3 | Permit Number 778999 | 6011566 | 2120807 | 37.8039830121097 | -122.404195745182 | (37.8039830121097, -122.404195745182) | 3 | 1 | 10 | 28860 | 6 | |
2310 | 91800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
25456 | 102816 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
43634 | 102815 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
84396 | 102817 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
4484 | 16615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | 15 | 5 | 5 | 28862 | 3 | |
48983 | 47569 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 6 | 3x4 | Permit Number 778941 | 6014634.6306 | 2115001.8072 | 37.7882142990953 | -122.393170009935 | (37.7882142990953, -122.393170009935) | 6 | 2 | 9 | 28855 | 6 | |
76335 | 253038 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778941 | 6013839 | 2114264 | 37.7861442195908 | -122.395871057304 | (37.7861442195908, -122.395871057304) | 6 | 2 | 9 | 28856 | 6 | |||
85881 | 111820 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 545 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778766 | 6008367.33453 | 2114375.58093 | 37.7861446738875 | -122.41480952996 | (37.7861446738875, -122.41480952996) | 13 | 10 | 9 | 28858 | 36 | |
30240 | 243370 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.22799 | 2103449.78821 | 37.7560258191488 | -122.421361454386 | (37.7560258191488, -122.421361454386) | 2 | 4 | 5 | 28859 | 19 | |
52242 | 243372 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1050 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006308.99467 | 2103436.4955 | 37.7559926899263 | -122.42115381712 | (37.7559926899263, -122.42115381712) | 2 | 4 | 5 | 28859 | 19 | |
63824 | 120132 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006324.60427 | 2103454.53368 | 37.7560430985606 | -122.421101114609 | (37.7560430985606, -122.421101114609) | 2 | 4 | 5 | 28859 | 19 | |
124974 | 243371 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006273.47273 | 2103450.37091 | 37.7560287860041 | -122.42127764924 | (37.7560287860041, -122.42127764924) | 2 | 4 | 5 | 28859 | 19 | |
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
147853 | 64697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006319.44787647 | 2103419.18592492 | 37.7559457511246 | -122.421116437378 | (37.7559457511246, -122.421116437378) | 2 | 4 | 5 | 28859 | 19 | |
168129 | 23050 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1058 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006261.27662 | 2103419.73409 | 37.7559439767922 | -122.421317651992 | (37.7559439767922, -122.421317651992) | 2 | 4 | 5 | 28859 | 19 | |
25217 | 121314 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 124 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
49990 | 121312 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
85996 | 121315 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 124 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
112039 | 121311 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
152518 | 121313 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
172818 | 121310 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
189160 | 254475 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Lomita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778588 | 5991535.17619 | 2104896.94918 | 37.7591587755992 | -122.472352546427 | (37.7591587755992, -122.472352546427) | 1 | 8 | 4 | 56 | 12 |
106913 | 43102 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 83-91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3 | Permit Number 778528 | 6008702.80382356 | 2112449.61405419 | 37.7808752749976 | -122.413512627921 | (37.7808752749976, -122.413512627921) | 7 | 10 | 9 | 28852 | 36 | ||
108221 | 117311 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 83-91 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778528 | 6008750.6 | 2112418.1 | 37.7807914285565 | -122.413345047685 | (37.7807914285565, -122.413345047685) | 7 | 10 | 9 | 28852 | 36 | ||
49810 | 117326 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1220 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778499 | 6003838.3 | 2101166.5 | 37.7496202226391 | -122.429536414457 | (37.7496202226391, -122.429536414457) | 2 | 4 | 5 | 28862 | 22 | |||
173661 | 117344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 723 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778486 | 5985034.9 | 2110919.2 | 37.7753158216394 | -122.49527739893 | (37.7753158216394, -122.49527739893) | 11 | 6 | 2 | 55 | 26 |
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) );