trees
8,659 rows where qSpecies_id = 11 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54 | 216739 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 11 Brighton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 3ft | 5996185.57101 | 2089978.26988 | 37.7184637821573 | -122.4551912491 | (37.7184637821573, -122.4551912491) | 9 | 8 | 6 | 28861 | 24 | ||
506 | 264804 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
1006 | 258081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:01:00 PM | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | ||
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
1473 | 170691 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000619.24687 | 2092677.737 | 37.7261292822292 | -122.440059368765 | (37.7261292822292, -122.440059368765) | 9 | 7 | 6 | 28861 | 25 | ||
1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1731 | 261128 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6003092 | 2092654 | 37.7262045674713 | -122.431509515778 | (37.7262045674713, -122.431509515778) | 9 | 7 | 6 | 28861 | 5 | ||
2023 | 264805 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
2379 | 27111 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 497 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x4 | 6004667.95957 | 2093529.09628 | 37.7286965849625 | -122.426123777405 | (37.7286965849625, -122.426123777405) | 9 | 7 | 6 | 28861 | 5 | |||
2611 | 52930 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 36 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48915 | 5999971.05699015 | 2092944.44477133 | 37.7268246780096 | -122.442319255194 | (37.7268246780096, -122.442319255194) | 9 | 7 | 6 | 28861 | 25 | ||
2903 | 251423 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/2020 12:00:00 AM | 3 | 3x3 | 5999946 | 2089791 | 37.7181646124566 | -122.4421796072 | (37.7181646124566, -122.4421796072) | 9 | 7 | 6 | 28861 | 25 | ||
2919 | 208356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4998 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990631.22914 | 2093445.14336 | 37.7276627189546 | -122.474642998593 | (37.7276627189546, -122.474642998593) | 9 | 8 | 4 | 64 | 40 | |||
2975 | 171289 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 319 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003630.58529 | 2092759.63292 | 37.726525123318 | -122.429655186657 | (37.726525123318, -122.429655186657) | 9 | 7 | 6 | 28861 | 5 | ||
3244 | 208266 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | 9 | 7 | 4 | 59 | 40 | |||
3256 | 256623 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 162 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/10/2019 02:37:00 PM | 3 | 3x3 | 5994333.67195 | 2093080.20894 | 37.7268745363156 | -122.461817248026 | (37.7268745363156, -122.461817248026) | 9 | 8 | 4 | 28861 | 40 | ||
3830 | 91437 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 02/22/2012 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
3958 | 29691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | 9 | 7 | 8 | 309 | 39 | ||
4425 | 262436 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000647.76831 | 2092657.8797 | 37.7260763822942 | -122.439959348864 | (37.7260763822942, -122.439959348864) | 9 | 7 | 6 | 28861 | 25 | ||
4525 | 162657 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 187 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 09:54:00 AM | 3 | Width 0ft | 5996501.58023 | 2091123.57415 | 37.7216266438259 | -122.454181619811 | (37.7216266438259, -122.454181619811) | 9 | 8 | 6 | 28861 | 24 | ||
4628 | 6858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2865X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1992 12:00:00 AM | 15 | 3X3 | 5997253 | 2087738 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | 9 | 7 | 6 | 28861 | 25 | ||
4691 | 179399 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 218 Congdon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2018 11:42:00 AM | 3 | Width 3ft | 6004674.78225 | 2093970.68086 | 37.7299094637318 | -122.426131615003 | (37.7299094637318, -122.426131615003) | 9 | 7 | 6 | 28861 | 5 | ||
5131 | 172199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003534.5249 | 2091291.61932 | 37.7224888445726 | -122.429882596429 | (37.7224888445726, -122.429882596429) | 9 | 7 | 6 | 28861 | 5 | |||
5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
5749 | 214100 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:56:00 PM | 3 | Width 3ft | 5996085.5249 | 2091194.13993 | 37.7217965338776 | -122.455624901296 | (37.7217965338776, -122.455624901296) | 9 | 8 | 6 | 28861 | 24 | ||
6372 | 160064 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:44:00 PM | 3 | Width 0ft | 6000438.16193 | 2090795.67407 | 37.7209512565735 | -122.440550438153 | (37.7209512565735, -122.440550438153) | 9 | 7 | 6 | 28861 | 25 | ||
7044 | 70398 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 153 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | Permit Number 775403 | 6006428.67416 | 2093189.72166 | 37.7278640951339 | -122.420012793267 | (37.7278640951339, -122.420012793267) | 9 | 7 | 7 | 309 | 5 | |
7353 | 16291 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 710 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/31/2001 12:00:00 AM | 3 | 3x3 | 5997353.28432 | 2094748.65298 | 37.7316290565338 | -122.451498861191 | (37.7316290565338, -122.451498861191) | 9 | 7 | 4 | 59 | 40 | ||
7582 | 170693 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2020 12:00:00 AM | 3 | Width 3ft | 6000671.26628 | 2092639.51564 | 37.726027296415 | -122.4398768019 | (37.726027296415, -122.4398768019) | 9 | 7 | 6 | 28861 | 25 | ||
7678 | 171106 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1830 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6001167.19025 | 2091451.63812 | 37.7227938721177 | -122.438077374487 | (37.7227938721177, -122.438077374487) | 9 | 7 | 6 | 28861 | 25 | |||
8669 | 262474 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
8998 | 208278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 20 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 5995821.66146 | 2098283.49942 | 37.7412470549149 | -122.457049545217 | (37.7412470549149, -122.457049545217) | 9 | 7 | 4 | 59 | 40 | |||
9536 | 1292 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5992119.08452 | 2087279.95314 | 37.710820711192 | -122.469051013205 | (37.710820711192, -122.469051013205) | 9 | 8 | 4 | 64 | 24 | |||
9693 | 177161 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007505.03845 | 2087315.42394 | 37.7117951032216 | -122.415875970325 | (37.7117951032216, -122.415875970325) | 9 | 7 | 8 | 309 | 39 | |||
10195 | 16208 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 520 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/1990 12:00:00 AM | 12 | 3X3 | 5998621.53802 | 2094731.71409 | 37.7316550910103 | -122.447113056433 | (37.7316550910103, -122.447113056433) | 9 | 7 | 4 | 59 | 40 | ||
10239 | 117493 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 156 DORADO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994380 | 2093088 | 37.7268985955584 | -122.461657658843 | (37.7268985955584, -122.461657658843) | 9 | 8 | 4 | 28861 | 40 | ||||
11356 | 208342 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990572.11827 | 2092496.71048 | 37.7250551346827 | -122.474778147818 | (37.7250551346827, -122.474778147818) | 9 | 8 | 4 | 64 | 40 | |||
12402 | 67521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 424 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31057 | 5997342.043029 | 2093839.69948247 | 37.7291326429008 | -122.451472187982 | (37.7291326429008, -122.451472187982) | 9 | 7 | 4 | 28861 | 40 | ||
12508 | 62227 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 228 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22352 | 6001110.06412505 | 2093217.52334826 | 37.7276393417973 | -122.438401301148 | (37.7276393417973, -122.438401301148) | 9 | 7 | 6 | 28861 | 25 | ||
12740 | 170692 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000647.76831 | 2092657.8797 | 37.7260763822942 | -122.439959348864 | (37.7260763822942, -122.439959348864) | 9 | 7 | 6 | 28861 | 25 | ||
12913 | 253113 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:52:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
13151 | 68243 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 493 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 10 | Permit Number 32043 | 6007581.69224 | 2091476.68313 | 37.7232253533521 | -122.415905517524 | (37.7232253533521, -122.415905517524) | 9 | 3 | 7 | 309 | 28 | |
13227 | 70595 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 9 | 6004399.02118 | 2091228.09004 | 37.7223633261893 | -122.426889705722 | (37.7223633261893, -122.426889705722) | 9 | 7 | 6 | 28861 | 5 | ||
14188 | 172200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003544.90457 | 2091306.45225 | 37.7225301603163 | -122.429847773766 | (37.7225301603163, -122.429847773766) | 9 | 7 | 6 | 28861 | 5 | |||
14329 | 208448 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 79 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5994592.56957 | 2093111.81863 | 37.7269762295662 | -122.46092454135 | (37.7269762295662, -122.46092454135) | 9 | 8 | 4 | 28861 | 40 | |||
14402 | 208305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 6 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6002233.89157 | 2095386.08451 | 37.7336575763338 | -122.434671221913 | (37.7336575763338, -122.434671221913) | 9 | 7 | 5 | 63 | 40 | |||
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 | ||
14511 | 208454 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 314 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994351.80863 | 2093010.71485 | 37.7266847664821 | -122.461749513755 | (37.7266847664821, -122.461749513755) | 9 | 8 | 4 | 28861 | 40 | |||
14723 | 256851 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001446 | 2091921 | 37.7240984859228 | -122.437147179411 | (37.7240984859228, -122.437147179411) | 9 | 7 | 6 | 28861 | 25 | ||||
14772 | 208283 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 26 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995702.36182 | 2098208.09954 | 37.7410331736343 | -122.457456584654 | (37.7410331736343, -122.457456584654) | 9 | 7 | 4 | 59 | 40 | |||
14780 | 262330 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
16732 | 262211 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999946 | 2089791 | 37.7181646124566 | -122.4421796072 | (37.7181646124566, -122.4421796072) | 9 | 7 | 6 | 28861 | 25 | ||||
17005 | 101474 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | |||
17325 | 208354 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990627.1725 | 2093396.83669 | 37.7275298459097 | -122.474653498173 | (37.7275298459097, -122.474653498173) | 9 | 8 | 4 | 64 | 40 | |||
17562 | 160058 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:47:00 AM | 3 | Width 0ft | 6000597.86618 | 2091098.27715 | 37.7217912287713 | -122.440020076466 | (37.7217912287713, -122.440020076466) | 9 | 7 | 6 | 28861 | 25 | ||
18100 | 94592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2428 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:36:00 AM | 3 | 3x3 | 6010911.88561 | 2086922.4145 | 37.7109069219836 | -122.404073263263 | (37.7109069219836, -122.404073263263) | 9 | 7 | 8 | 309 | 39 | ||
18240 | 208338 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3660 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5990543.735 | 2092084.7933 | 37.7239224682242 | -122.474846212085 | (37.7239224682242, -122.474846212085) | 9 | 8 | 4 | 64 | 40 | |||
18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
18755 | 16138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 370 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999754.91061 | 2094714.13801 | 37.7316715225246 | -122.443193512388 | (37.7316715225246, -122.443193512388) | 9 | 7 | 4 | 63 | 40 | |||
19589 | 208385 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 180 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992853.23651 | 2095546.10769 | 37.733559947723 | -122.467114242228 | (37.733559947723, -122.467114242228) | 9 | 8 | 4 | 59 | 40 | |||
19611 | 171230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003563.26251 | 2092861.65993 | 37.7268014543988 | -122.429895193205 | (37.7268014543988, -122.429895193205) | 9 | 7 | 6 | 28861 | 5 | ||
20464 | 208353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990626.63647 | 2093347.44726 | 37.727394203873 | -122.474651748098 | (37.727394203873, -122.474651748098) | 9 | 8 | 4 | 64 | 40 | |||
20473 | 208314 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001504.4065 | 2095542.47222 | 37.7340455402682 | -122.437204453845 | (37.7340455402682, -122.437204453845) | 9 | 7 | 5 | 63 | 40 | |||
20582 | 16190 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 463 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1998 12:00:00 AM | 3 | 3X3 | 5999017.68694 | 2094650.2633 | 37.7314540727285 | -122.445737640473 | (37.7314540727285, -122.445737640473) | 9 | 7 | 4 | 59 | 40 | ||
21376 | 418 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3870 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 2X4 | 5990907.498 | 2090050.47073 | 37.7183577952661 | -122.473440442237 | (37.7183577952661, -122.473440442237) | 9 | 8 | 4 | 64 | 40 | ||
21804 | 16274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 675 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5997598.29075 | 2094676.61172 | 37.7314452755764 | -122.450646637547 | (37.7314452755764, -122.450646637547) | 9 | 7 | 4 | 59 | 40 | |||
21894 | 208286 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 215 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994478.59231 | 2092821.26982 | 37.7261718938956 | -122.461297502801 | (37.7261718938956, -122.461297502801) | 9 | 8 | 4 | 28861 | 40 | |||
22430 | 16257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997866.75715 | 2094667.34056 | 37.7314351824697 | -122.449717834828 | (37.7314351824697, -122.449717834828) | 9 | 7 | 4 | 59 | 40 | |||
22518 | 177228 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000372.02782 | 2092644.30994 | 37.7260234221226 | -122.440911591502 | (37.7260234221226, -122.440911591502) | 9 | 7 | 6 | 28861 | 25 | |||
23257 | 177158 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007422.75752 | 2087173.92491 | 37.7114019502079 | -122.416150341778 | (37.7114019502079, -122.416150341778) | 9 | 7 | 8 | 309 | 39 | |||
23295 | 2152 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1109 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000977.95547 | 2095707.30973 | 37.734468205445 | -122.439036363859 | (37.734468205445, -122.439036363859) | 9 | 7 | 5 | 63 | 40 | |||
23498 | 76685 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
23573 | 60472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |
24208 | 76687 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
24317 | 216490 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800x Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6001788.93125 | 2095501.57158 | 37.7339494063362 | -122.436217839104 | (37.7339494063362, -122.436217839104) | 9 | 7 | 5 | 63 | 40 | |||
24399 | 62832 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2017 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/2005 12:00:00 AM | Permit Number 23197 | 5999678.92885006 | 2092144.34740146 | 37.7246111411292 | -122.443271689799 | (37.7246111411292, -122.443271689799) | 9 | 7 | 6 | 28861 | 25 | ||
24807 | 208317 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 295 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995337.94079 | 2092045.98107 | 37.7240925570223 | -122.458270713016 | (37.7240925570223, -122.458270713016) | 9 | 8 | 4 | 28861 | 24 | |||
25190 | 208460 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 545 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998994.59253 | 2097295.1297 | 37.7387149309567 | -122.446007644855 | (37.7387149309567, -122.446007644855) | 9 | 7 | 4 | 59 | 40 | |||
25288 | 208320 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 590 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994793.28143 | 2092164.99071 | 37.724388015769 | -122.46016212219 | (37.724388015769, -122.46016212219) | 9 | 8 | 4 | 28861 | 24 | |||
25324 | 29368 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 10 | 3X3 | 5992911.10359 | 2087617.08951 | 37.7117921381675 | -122.466338121928 | (37.7117921381675, -122.466338121928) | 9 | 8 | 4 | 64 | 24 | ||
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 | ||
25575 | 334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2008 12:00:00 AM | 3 | 2 | 5990580.28082 | 2092709.64357 | 37.7256402686825 | -122.474765465576 | (37.7256402686825, -122.474765465576) | 9 | 8 | 4 | 64 | 40 | ||
25996 | 208315 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 691 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997570.14701 | 2094675.72422 | 37.7314412277316 | -122.450743871345 | (37.7314412277316, -122.450743871345) | 9 | 7 | 4 | 59 | 40 | |||
26154 | 160072 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:34:00 AM | 3 | Width 0ft | 6000153.57644 | 2090420.29754 | 37.7199043485999 | -122.441507239468 | (37.7199043485999, -122.441507239468) | 9 | 7 | 6 | 28861 | 25 | ||
26197 | 177217 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 6 | : | Tree | Private 2 | 8 | Width 3ft | 5993336.53195 | 2087626.25376 | 37.7118418391946 | -122.464868401251 | (37.7118418391946, -122.464868401251) | 9 | 8 | 4 | 64 | 24 | |||
26857 | 161557 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 11:09:00 AM | 3 | Width 0ft | 6001350.49803 | 2088073.55411 | 37.7135288333539 | -122.437201966314 | (37.7135288333539, -122.437201966314) | 9 | 7 | 6 | 28861 | 5 | ||
26969 | 87572 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3250 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2008 12:00:00 AM | 3 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.474535101923 | (37.7294662695904, -122.474535101923) | 9 | 8 | 4 | 64 | 40 | |||
27569 | 86819 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1010 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49755 | 5995086.4 | 2090661.6 | 37.7202769199461 | -122.45904005327 | (37.7202769199461, -122.45904005327) | 9 | 8 | 6 | 28861 | 24 | ||||
27629 | 208201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 109 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992876.13857 | 2095935.50628 | 37.7346304611167 | -122.467063364902 | (37.7346304611167, -122.467063364902) | 9 | 8 | 4 | 59 | 40 | |||
27875 | 56612 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 139 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31089 | 5996720.86601097 | 2098424.62291363 | 37.7416861435861 | -122.453950621575 | (37.7416861435861, -122.453950621575) | 9 | 7 | 4 | 59 | 40 | ||
28095 | 29690 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | 9 | 7 | 8 | 309 | 39 | ||
28984 | 253115 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:57:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |
29940 | 67983 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31707 | 5996243.31807004 | 2090478.67458978 | 37.7198410887436 | -122.455027781571 | (37.7198410887436, -122.455027781571) | 9 | 8 | 6 | 28861 | 24 | ||
30036 | 1873 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2566 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2016 12:00:00 AM | 3 | 3X3 | 6010639.8141 | 2086443.56694 | 37.7095768975302 | -122.404979917507 | (37.7095768975302, -122.404979917507) | 9 | 7 | 8 | 309 | 39 | ||
30073 | 113257 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 45 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994580 | 2092875 | 37.7263252596904 | -122.46095083712 | (37.7263252596904, -122.46095083712) | 9 | 8 | 4 | 28861 | 40 | ||||
30221 | 95757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:33:00 PM | 3 | 3x3 | Permit Number 767495 | 6003435.4103 | 2092233.16774 | 37.7250685138993 | -122.430292354528 | (37.7250685138993, -122.430292354528) | 9 | 7 | 6 | 28861 | 5 |
31222 | 2032 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 645 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002168.04388 | 2095363.4286 | 37.7335916299421 | -122.434897256628 | (37.7335916299421, -122.434897256628) | 9 | 7 | 5 | 63 | 40 | |||
31792 | 87688 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2610 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010514.44412 | 2086115.57881 | 37.7086692990048 | -122.40539013695 | (37.7086692990048, -122.40539013695) | 9 | 7 | 8 | 309 | 39 | |||
32107 | 16122 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 313 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/05/2012 12:00:00 AM | 3 | 3X3 | 5999967.48728 | 2094632.53487 | 37.7314595783841 | -122.442452738108 | (37.7314595783841, -122.442452738108) | 9 | 7 | 4 | 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) );