trees
8,659 rows where qSpecies_id = 11 sorted by Neighborhoods (old) 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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138200 | 10358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1061 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1992 12:00:00 AM | 30 | 3X3 | 6001062.65732 | 2108960.15475 | 37.7708621447883 | -122.439693334178 | (37.7708621447883, -122.439693334178) | 15 | 5 | 11 | 29492 | 9 | ||
| 139009 | 63745 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 310 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24417 | 6002763.44292245 | 2109611.97406957 | 37.772748538391 | -122.433856880294 | (37.772748538391, -122.433856880294) | 15 | 5 | 11 | 29492 | 9 | ||
| 139947 | 228922 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 198 Scott St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6002348.58311 | 2109105.39486 | 37.7713340466556 | -122.435255683197 | (37.7713340466556, -122.435255683197) | 15 | 5 | 11 | 29492 | 9 | |||
| 143046 | 247190 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1059 Haight St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6001069.31267 | 2108960.36551 | 37.7708631022897 | -122.439670328333 | (37.7708631022897, -122.439670328333) | 15 | 5 | 11 | 29492 | 9 | |||
| 145148 | 10430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2003 12:00:00 AM | 12 | 3X3 | 5999234.911 | 2108753.3373 | 37.7701900752827 | -122.446000650118 | (37.7701900752827, -122.446000650118) | 15 | 5 | 11 | 29492 | 9 | ||
| 145462 | 229067 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 133 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997810.53317 | 2107122.53439 | 37.7656308672826 | -122.450809934642 | (37.7656308672826, -122.450809934642) | 15 | 5 | 11 | 29492 | 9 | |||
| 145981 | 103003 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
| 147832 | 229077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 929 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999180.96008 | 2106954.82814 | 37.7652487417517 | -122.446057883667 | (37.7652487417517, -122.446057883667) | 15 | 5 | 11 | 29492 | 9 | |||
| 148324 | 100175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099 | 2109378.2 | 37.772012061027 | -122.439597598173 | (37.772012061027, -122.439597598173) | 15 | 5 | 11 | 29492 | 9 | ||
| 148826 | 2479 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1081 HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/1996 12:00:00 AM | 10 | 3X3 | 6000997 | 2108925 | 37.7707618813266 | -122.439917922829 | (37.7707618813266, -122.439917922829) | 15 | 5 | 11 | 29492 | 9 | ||
| 149915 | 66197 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 575 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1990 12:00:00 AM | 3x3 | Permit Number 29280 | 5997973.69250609 | 2108644.65485494 | 37.7698195609286 | -122.450355338753 | (37.7698195609286, -122.450355338753) | 15 | 5 | 11 | 29492 | 9 | ||
| 150222 | 5796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 714 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002276.86705 | 2108309.9286 | 37.7691458198527 | -122.435446838626 | (37.7691458198527, -122.435446838626) | 15 | 5 | 5 | 29492 | 9 | |||
| 151134 | 46112 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 798 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | |||
| 152939 | 10439 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1476 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2007 12:00:00 AM | 3 | 3X3 | 5999040.95838 | 2108750.58629 | 37.7701714445079 | -122.446671330132 | (37.7701714445079, -122.446671330132) | 15 | 5 | 11 | 29492 | 9 | ||
| 154423 | 10355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1035 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2010 12:00:00 AM | 3 | 3X3 | 6001185.9741 | 2108962.09932 | 37.7708745022666 | -122.439266918906 | (37.7708745022666, -122.439266918906) | 15 | 5 | 11 | 29492 | 9 | ||
| 156683 | 64822 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 135 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25831 | 6002320.66507006 | 2108936.38828601 | 37.7708684109456 | -122.435340161562 | (37.7708684109456, -122.435340161562) | 15 | 5 | 11 | 29492 | 9 | ||
| 157863 | 228134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1128 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998921.71577 | 2106043.96232 | 37.7627329252129 | -122.446888994834 | (37.7627329252129, -122.446888994834) | 15 | 5 | 5 | 29492 | 9 | |||
| 164428 | 102743 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 291 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001237 | 2109672 | 37.7728266156527 | -122.439141307468 | (37.7728266156527, -122.439141307468) | 15 | 5 | 11 | 29492 | 9 | ||||
| 169875 | 41574 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 55 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1979 12:00:00 AM | Permit Number 42088 | 5998325.41103245 | 2106529.75873016 | 37.7640327153601 | -122.448986388528 | (37.7640327153601, -122.448986388528) | 15 | 5 | 11 | 29492 | 9 | |||
| 174296 | 61132 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 101 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1988 12:00:00 AM | Permit Number 25713 | 6001321.35179784 | 2109031.62910548 | 37.7710731165305 | -122.438803628455 | (37.7710731165305, -122.438803628455) | 15 | 5 | 11 | 29492 | 9 | ||
| 174514 | 248422 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997181.0094 | 2108075.4611 | 37.7682113033765 | -122.453056101342 | (37.7682113033765, -122.453056101342) | 15 | 5 | 11 | 29492 | 9 | |||
| 179211 | 10479 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1654 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2007 12:00:00 AM | 12 | 3X3 | 5998226.2278 | 2108614.4223 | 37.7697509996198 | -122.449479650766 | (37.7697509996198, -122.449479650766) | 15 | 5 | 11 | 29492 | 9 | ||
| 179438 | 228136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1554 Masonic Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5999802.13747 | 2107141.60658 | 37.7657970413272 | -122.443922806786 | (37.7657970413272, -122.443922806786) | 15 | 5 | 5 | 29492 | 9 | |||
| 180286 | 10518 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:10:00 AM | 3 | 3X3 | 5997390.93431 | 2108451.11585 | 37.7692547835584 | -122.452357106487 | (37.7692547835584, -122.452357106487) | 15 | 5 | 11 | 29492 | 9 | ||
| 180722 | 122502 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 575 Cole St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997973.69250609 | 2108644.65485494 | 37.7698195609286 | -122.450355338753 | (37.7698195609286, -122.450355338753) | 15 | 5 | 11 | 29492 | 9 | ||||
| 180888 | 229066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997997.2787 | 2107452.11895 | 37.7665465111465 | -122.450187784559 | (37.7665465111465, -122.450187784559) | 15 | 5 | 11 | 29492 | 9 | |||
| 181089 | 81451 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 730 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49733 | 5997103.70386372 | 2108221.85987986 | 37.768608846124 | -122.453334062784 | (37.768608846124, -122.453334062784) | 15 | 5 | 11 | 29492 | 9 | ||
| 185210 | 5797 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 714 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6002261.11506 | 2108308.56173 | 37.7691411721422 | -122.435501225997 | (37.7691411721422, -122.435501225997) | 15 | 5 | 5 | 29492 | 9 | |||
| 185580 | 17036 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1173 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2007 12:00:00 AM | 3 | 3X3 | 6001412.67181 | 2109625.06847 | 37.7727077478791 | -122.438530276524 | (37.7727077478791, -122.438530276524) | 15 | 5 | 11 | 29492 | 9 | ||
| 187116 | 228139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997551.58712 | 2105899.50072 | 37.7622579005946 | -122.45161733879 | (37.7622579005946, -122.45161733879) | 15 | 5 | 11 | 29492 | 9 | |||
| 187908 | 247163 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 989 Haight St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001405.34003 | 2109008.25318 | 37.7710137099557 | -122.438511435848 | (37.7710137099557, -122.438511435848) | 15 | 5 | 11 | 29492 | 9 | |||
| 189287 | 98413 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 790 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002783 | 2109590 | 37.7726893128067 | -122.433787659392 | (37.7726893128067, -122.433787659392) | 15 | 5 | 11 | 29492 | 9 | ||||
| 189410 | 71765 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1988 12:00:00 AM | 12 | 6001257.27264987 | 2109038.60953757 | 37.7710886372624 | -122.439025780225 | (37.7710886372624, -122.439025780225) | 15 | 5 | 11 | 29492 | 9 | |||
| 192227 | 56793 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1284 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25783 | 6000421.78044647 | 2109269.7505474 | 37.7716757187634 | -122.441932360781 | (37.7716757187634, -122.441932360781) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 12898 | 246897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Frederick St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 5996851.54862 | 2107390.70797 | 37.7663122602365 | -122.454146203593 | (37.7663122602365, -122.454146203593) | 15 | 5 | 11 | 29492 | 8 | |||
| 29515 | 217725 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 5995229.43414 | 2107380.16691 | 37.766190168267 | -122.459755990171 | (37.766190168267, -122.459755990171) | 15 | 5 | 11 | 29492 | 8 | |||
| 31467 | 217724 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5995249.55673 | 2107377.513 | 37.7661840384824 | -122.459686198267 | (37.7661840384824, -122.459686198267) | 15 | 5 | 11 | 29492 | 8 | |||
| 43325 | 48840 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.7662509163514 | -122.464348446646 | (37.7662509163514, -122.464348446646) | 11 | 6 | 11 | 29492 | 8 | ||||
| 46330 | 217728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995225.13962 | 2107407.04812 | 37.766263730121 | -122.459772791289 | (37.766263730121, -122.459772791289) | 15 | 5 | 11 | 29492 | 8 | |||
| 62906 | 20507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 69001 | 246895 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Frederick St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 5996881.3506 | 2107395.29501 | 37.7663265639355 | -122.454043456049 | (37.7663265639355, -122.454043456049) | 15 | 5 | 11 | 29492 | 8 | |||
| 82684 | 246888 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 811 Stanyan St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5997111.16957 | 2107712.02155 | 37.7672093888359 | -122.453271427639 | (37.7672093888359, -122.453271427639) | 15 | 5 | 11 | 29492 | 8 | |||
| 111440 | 20508 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 115303 | 217726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 3 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 5995207.72446 | 2107378.38914 | 37.7661840384968 | -122.459830950441 | (37.7661840384968, -122.459830950441) | 15 | 5 | 11 | 29492 | 8 | |||
| 120532 | 87140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 188 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50108 | 5997118 | 2107743 | 37.7672948392131 | -122.45325003899 | (37.7672948392131, -122.45325003899) | 15 | 5 | 11 | 29492 | 8 | ||
| 125423 | 246899 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Frederick St | 6 | : | Tree | Private 2 | 10 | Width 3ft | 5996816.52138 | 2107386.41612 | 37.7662984673195 | -122.454267045507 | (37.7662984673195, -122.454267045507) | 15 | 5 | 11 | 29492 | 8 | |||
| 151415 | 20509 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 154422 | 217727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5995261.12778 | 2107394.75932 | 37.7662320577801 | -122.45964742579 | (37.7662320577801, -122.45964742579) | 15 | 5 | 11 | 29492 | 8 | |||
| 159415 | 246901 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Frederick St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 5996782.41992 | 2107381.73291 | 37.7662836527971 | -122.454384657023 | (37.7662836527971, -122.454384657023) | 15 | 5 | 11 | 29492 | 8 | |||
| 172591 | 246891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 811 Stanyan St | 4 | : | Tree | Private 2 | 13 | Width 3ft | 5997133.63999 | 2107540.82684 | 37.7667406199093 | -122.453181346145 | (37.7667406199093, -122.453181346145) | 15 | 5 | 11 | 29492 | 8 | |||
| 173140 | 114305 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997118 | 2107743 | 37.7672948392131 | -122.45325003899 | (37.7672948392131, -122.45325003899) | 15 | 5 | 11 | 29492 | 8 | ||||
| 188429 | 48842 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.7662509163514 | -122.464348446646 | (37.7662509163514, -122.464348446646) | 11 | 6 | 11 | 29492 | 8 | ||||
| 192583 | 48841 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2002 12:00:00 AM | Permit Number 46057 | 5993902.71442412 | 2107430.11074384 | 37.7662509163514 | -122.464348446646 | (37.7662509163514, -122.464348446646) | 11 | 6 | 11 | 29492 | 8 | ||||
| 547 | 228103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 1704 | 29288 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998060.68791 | 2099984.96724 | 37.7460471998142 | -122.449430386304 | (37.7460471998142, -122.449430386304) | 2 | 7 | 5 | 63 | 7 | ||
| 2202 | 29373 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |
| 5896 | 68729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32645 | 5998785.51386128 | 2099959.35584866 | 37.7460183133905 | -122.446922200801 | (37.7460183133905, -122.446922200801) | 2 | 7 | 5 | 63 | 7 | |||
| 8418 | 64139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 523 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24910 | 6003239.38144538 | 2098311.93722578 | 37.7417483289476 | -122.431403744863 | (37.7417483289476, -122.431403744863) | 2 | 7 | 5 | 63 | 7 | ||
| 11164 | 64419 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 111 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25267 | 6003583.64860345 | 2097735.92139782 | 37.740186227283 | -122.430172299864 | (37.740186227283, -122.430172299864) | 2 | 7 | 5 | 63 | 7 | ||
| 11524 | 64282 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25086 | 6003895.1200055 | 2098341.81687307 | 37.7418675138214 | -122.429138548404 | (37.7418675138214, -122.429138548404) | 2 | 7 | 5 | 63 | 7 | ||
| 12177 | 228104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 21556 | 64289 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 357 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25094 | 6004221.28750393 | 2098359.956664 | 37.7419357800281 | -122.428012059642 | (37.7419357800281, -122.428012059642) | 2 | 7 | 5 | 63 | 7 | ||
| 23070 | 29278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 22 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998653.8721 | 2100156.73057 | 37.7465527348295 | -122.447391602559 | (37.7465527348295, -122.447391602559) | 2 | 7 | 5 | 63 | 7 | ||
| 24457 | 29294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 15 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997840.39461 | 2099954.53533 | 37.7459510371212 | -122.450189934828 | (37.7459510371212, -122.450189934828) | 2 | 7 | 5 | 63 | 7 | ||
| 24834 | 60616 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20240 | 6004848.50630576 | 2097410.92341249 | 37.7393654155838 | -122.425775803338 | (37.7393654155838, -122.425775803338) | 2 | 7 | 5 | 63 | 7 | ||
| 25488 | 29296 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997789.65443 | 2099947.60504 | 37.7459291044398 | -122.450364887145 | (37.7459291044398, -122.450364887145) | 2 | 7 | 5 | 63 | 7 | ||
| 27822 | 29295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 16 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997814.38842 | 2099950.16176 | 37.7459375400967 | -122.450279545065 | (37.7459375400967, -122.450279545065) | 2 | 7 | 5 | 63 | 7 | ||
| 27863 | 2123 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1100X Bosworth St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2014 11:05:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
| 28694 | 60656 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 159 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20290 | 6004348.70731442 | 2097373.30443411 | 37.7392338661268 | -122.427501208362 | (37.7392338661268, -122.427501208362) | 2 | 7 | 5 | 63 | 7 | ||
| 30558 | 29374 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 3 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |
| 31922 | 228107 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001296.21258 | 2096174.59578 | 37.7357693679469 | -122.437969506208 | (37.7357693679469, -122.437969506208) | 2 | 7 | 5 | 63 | 7 | |||
| 34263 | 2124 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1100X Bosworth St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2005 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
| 36480 | 60609 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 44 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20233 | 6004854.74181998 | 2098042.44150378 | 37.7410997733275 | -122.425799182451 | (37.7410997733275, -122.425799182451) | 2 | 7 | 5 | 63 | 7 | ||
| 37564 | 29375 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 4 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | ||
| 40548 | 101065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 380X Beacon St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6002433 | 2098186.8 | 37.7413589965156 | -122.434182997537 | (37.7413589965156, -122.434182997537) | 2 | 7 | 5 | 63 | 7 | |||
| 42189 | 2126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1100X Bosworth St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2014 11:02:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
| 42876 | 228108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 Thor Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002351.95923 | 2095764.31658 | 37.7347028169825 | -122.434290059548 | (37.7347028169825, -122.434290059548) | 2 | 7 | 5 | 63 | 7 | |||
| 43069 | 29282 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998248.67682 | 2100034.50687 | 37.7461939754832 | -122.448783915857 | (37.7461939754832, -122.448783915857) | 2 | 7 | 5 | 63 | 7 | ||
| 45284 | 22804 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2X2 | 5998839.86741 | 2099858.18057 | 37.7457436156711 | -122.446726975686 | (37.7457436156711, -122.446726975686) | 2 | 7 | 5 | 63 | 7 | |||
| 46706 | 2041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/1994 12:00:00 AM | 6 | 3X3 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | ||
| 47346 | 228983 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6003399.16662 | 2095595.26226 | 37.7342980159353 | -122.430657448703 | (37.7342980159353, -122.430657448703) | 2 | 7 | 5 | 63 | 7 | ||||
| 51416 | 228077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Elk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000783.15268 | 2096402.95546 | 37.7363672003848 | -122.439759717347 | (37.7363672003848, -122.439759717347) | 2 | 7 | 5 | 63 | 7 | |||
| 55238 | 9323 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 118 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1992 12:00:00 AM | 12 | 3x3 | 6001258.58704 | 2098719.9184 | 37.742756088519 | -122.438281882105 | (37.742756088519, -122.438281882105) | 2 | 7 | 5 | 63 | 7 | ||
| 61059 | 228068 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Elk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000790.11801 | 2096625.46266 | 37.7369785496099 | -122.439751582996 | (37.7369785496099, -122.439751582996) | 2 | 7 | 5 | 63 | 7 | |||
| 62781 | 29281 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 5998275.9673 | 2100041.3119 | 37.7462142210054 | -122.448690039237 | (37.7462142210054, -122.448690039237) | 2 | 7 | 5 | 63 | 7 | ||
| 64638 | 29287 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 8 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998091.10088 | 2099993.55039 | 37.7460725067453 | -122.449325841021 | (37.7460725067453, -122.449325841021) | 2 | 7 | 5 | 63 | 7 | ||
| 64661 | 29289 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 10 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998035.9028 | 2099979.9539 | 37.7460320165688 | -122.449515728391 | (37.7460320165688, -122.449515728391) | 2 | 7 | 5 | 63 | 7 | ||
| 65464 | 228072 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Elk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000784.47358 | 2096514.86914 | 37.7366745643822 | -122.439763171637 | (37.7366745643822, -122.439763171637) | 2 | 7 | 5 | 63 | 7 | |||
| 66147 | 111283 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 98X THOR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 | |||
| 66753 | 208296 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 820 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001783.81829 | 2095538.15309 | 37.7340495602325 | -122.436238133196 | (37.7340495602325, -122.436238133196) | 2 | 7 | 5 | 63 | 7 | |||
| 67759 | 2075 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Bosworth St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001652.8683328 | 2095576.0345147 | 37.7341461328318 | -122.436693577752 | (37.7341461328318, -122.436693577752) | 2 | 7 | 5 | 63 | 7 | |||
| 73144 | 60641 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 190 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20268 | 6004415.33313047 | 2097263.31005397 | 37.7389356147311 | -122.427263012961 | (37.7389356147311, -122.427263012961) | 2 | 7 | 5 | 63 | 7 | ||
| 75716 | 228076 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Elk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000784.68359 | 2096420.41581 | 37.7364152295663 | -122.439755675794 | (37.7364152295663, -122.439755675794) | 2 | 7 | 5 | 63 | 7 | |||
| 75823 | 208295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 720 Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/1994 12:00:00 AM | 7 | Width 3ft | 6001977.00756 | 2095485.36799 | 37.7339155990291 | -122.435566443955 | (37.7339155990291, -122.435566443955) | 2 | 7 | 5 | 63 | 7 | ||
| 76381 | 208298 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 920 Bosworth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001505.93461 | 2095612.4888 | 37.7342378764845 | -122.437204182222 | (37.7342378764845, -122.437204182222) | 9 | 7 | 5 | 63 | 7 | |||
| 85160 | 60650 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20281 | 6004224.5992404 | 2097501.35410357 | 37.7395784409352 | -122.427939440626 | (37.7395784409352, -122.427939440626) | 2 | 7 | 5 | 63 | 7 |
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) );