trees
8,659 rows where qSpecies_id = 11 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78678 | 13325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 12 | 4x9 | 6004718.9472012 | 2089729.3577775 | 37.7182662183542 | -122.425677176757 | (37.7182662183542, -122.425677176757) | 9 | 7 | 6 | 309 | 18 | ||
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 | |
157055 | 173704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |||
63560 | 254930 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
93694 | 254933 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
107777 | 254932 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3 | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | ||
136261 | 254931 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
40390 | 3920 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
43569 | 3923 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2011 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
55615 | 3918 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
78619 | 3922 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2001 12:00:00 AM | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
81486 | 3924 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
89700 | 3927 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
101939 | 3917 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
111951 | 3913 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
126241 | 27764 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
139918 | 3926 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
147445 | 3916 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
158946 | 3919 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
172617 | 3928 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
187464 | 3921 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
40249 | 28930 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008789.5968147 | 2111229.2885306 | 37.7775294243446 | -122.413126052308 | (37.7775294243446, -122.413126052308) | 8 | 2 | 9 | 28853 | 34 | |
105575 | 95093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
122142 | 95091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
138911 | 95092 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
157098 | 31891 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 999 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2002 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||
98272 | 88425 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 999 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51391 | 6001075 | 2114514 | 37.7861122979784 | -122.440048944558 | (37.7861122979784, -122.440048944558) | 15 | 6 | 1 | 29490 | 27 | |||
8320 | 228169 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 998X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007884.41338 | 2097705.90914 | 37.7403464729105 | -122.41529982502 | (37.7403464729105, -122.41529982502) | 2 | 7 | 7 | 28859 | 2 | |||
54856 | 109630 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 998 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 1x1 | Permit Number 775136 | 6007840.9 | 2115211.2 | 37.7884094868041 | -122.416690077626 | (37.7884094868041, -122.416690077626) | 13 | 1 | 10 | 28858 | 21 | |
77489 | 10156 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 998 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6005679.7391 | 2103202.59116 | 37.7553149491356 | -122.423313367215 | (37.7553149491356, -122.423313367215) | 2 | 4 | 5 | 28859 | 19 | |||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
32890 | 9796 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
94516 | 9794 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
111531 | 9800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
132578 | 9791 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
139725 | 9793 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
147003 | 9799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 30 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
152187 | 9795 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
173276 | 9797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
175880 | 9790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
31456 | 229115 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 993 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007626.87309 | 2103909.38527 | 37.7573653431599 | -122.416629642654 | (37.7573653431599, -122.416629642654) | 2 | 4 | 7 | 28859 | 19 | |||
48914 | 61170 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 993 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21029 | 6007622.52723732 | 2103890.01374739 | 37.757311908984 | -122.416643300115 | (37.757311908984, -122.416643300115) | 2 | 4 | 7 | 28859 | 19 | ||
92444 | 129989 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005715.24248 | 2113129.59913 | 37.7825741432341 | -122.423896444476 | (37.7825741432341, -122.423896444476) | 7 | 9 | 11 | 28858 | 41 | |||
43584 | 29756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008576.3352 | 2120666.0433 | 37.8034284755503 | -122.414531731143 | (37.8034284755503, -122.414531731143) | 3 | 1 | 10 | 308 | 23 | |||
32029 | 19171 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003518.9611891 | 2107740.2951253 | 37.7676522094925 | -122.431109843922 | (37.7676522094925, -122.431109843922) | 7 | 9 | 5 | 28862 | 3 | |||
71297 | 228742 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003513.48044 | 2107768.5059 | 37.7677293588486 | -122.431130814934 | (37.7677293588486, -122.431130814934) | 7 | 9 | 5 | 28862 | 3 | |||
156276 | 19169 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003525.31054 | 2107757.1378 | 37.7676988151759 | -122.4310890846 | (37.7676988151759, -122.4310890846) | 7 | 9 | 5 | 28862 | 3 | |||
55758 | 177211 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011625.93165 | 2090639.99923 | 37.7211545303427 | -122.401866494246 | (37.7211545303427, -122.401866494246) | 10 | 7 | 8 | 309 | 28 | |||
170426 | 229063 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Jersey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004590.29695 | 2101605.09806 | 37.7508670605862 | -122.426967215575 | (37.7508670605862, -122.426967215575) | 2 | 4 | 5 | 28862 | 22 | |||
172588 | 229062 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004575.74144 | 2101603.27738 | 37.7508612383729 | -122.427017420239 | (37.7508612383729, -122.427017420239) | 2 | 4 | 5 | 28862 | 22 | |||
53396 | 228084 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 High St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999809.6462 | 2100695.27847 | 37.748097435553 | -122.443433750972 | (37.748097435553, -122.443433750972) | 2 | 4 | 5 | 63 | 22 | |||
92505 | 228693 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99 Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002925.07369 | 2107378.06142 | 37.7666239328727 | -122.433138139519 | (37.7666239328727, -122.433138139519) | 15 | 5 | 5 | 28862 | 3 | |||
194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194335 | 265024 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194338 | 265025 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194352 | 265022 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
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 | |||
29362 | 61169 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21028 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.416649165846 | (37.7573732040434, -122.416649165846) | 2 | 4 | 7 | 28859 | 19 | ||
48376 | 229116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007624.74229 | 2103931.25747 | 37.7574252793642 | -122.416638561219 | (37.7574252793642, -122.416638561219) | 2 | 4 | 7 | 28859 | 19 | |||
157985 | 173750 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.416649165846 | (37.7573732040434, -122.416649165846) | 2 | 4 | 7 | 28859 | 19 | ||||
166321 | 229117 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007623.6176 | 2103955.03494 | 37.757490503587 | -122.416644135225 | (37.757490503587, -122.416644135225) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
85735 | 228794 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005990.78553 | 2109283.51718 | 37.7720292873532 | -122.422669781809 | (37.7720292873532, -122.422669781809) | 8 | 2 | 9 | 28853 | 19 | |||
95312 | 228796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005989.39522 | 2109215.85357 | 37.771843420879 | -122.422669781778 | (37.771843420879, -122.422669781778) | 8 | 2 | 9 | 28853 | 19 | |||
102511 | 228793 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005988.17762 | 2109312.88612 | 37.7721097802775 | -122.42268089021 | (37.7721097802775, -122.42268089021) | 8 | 2 | 9 | 28853 | 19 | |||
136592 | 228795 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005988.80698 | 2109239.3182 | 37.7719078159348 | -122.422673484304 | (37.7719078159348, -122.422673484304) | 8 | 2 | 9 | 28853 | 19 | |||
162500 | 228797 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005990.13698 | 2109199.84825 | 37.7717995159593 | -122.422666078394 | (37.7717995159593, -122.422666078394) | 8 | 2 | 9 | 28853 | 19 | |||
112029 | 228963 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006388.37573 | 2107379.31526 | 37.7668232253363 | -122.421159248116 | (37.7668232253363, -122.421159248116) | 8 | 4 | 7 | 28853 | 19 | |||
87856 | 247193 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Broderick St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6001379.15483 | 2108959.66255 | 37.7708788026556 | -122.438598528898 | (37.7708788026556, -122.438598528898) | 15 | 5 | 11 | 29492 | 9 | |||
137678 | 247192 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 98 Broderick St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001382.44682 | 2108930.15672 | 37.7707979742631 | -122.438585027382 | (37.7707979742631, -122.438585027382) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
73775 | 77 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 97X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | 15 | 5 | 5 | 28862 | 3 | |||
49623 | 229118 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 977 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007622.26261 | 2103983.31117 | 37.7575680674189 | -122.416650824402 | (37.7575680674189, -122.416650824402) | 2 | 4 | 7 | 28859 | 19 | |||
39888 | 229142 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 976 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007554.34586 | 2103988.23351 | 37.7575777630208 | -122.416886057366 | (37.7575777630208, -122.416886057366) | 2 | 4 | 7 | 28859 | 19 | |||
90830 | 229141 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 976 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007553.60907 | 2104030.94246 | 37.7576949905453 | -122.416891631343 | (37.7576949905453, -122.416891631343) | 2 | 4 | 7 | 28859 | 19 | |||
92057 | 34167 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/1997 12:00:00 AM | Permit Number 37998 | 6007565.65364026 | 2103976.53229663 | 37.7575462702202 | -122.416846121387 | (37.7575462702202, -122.416846121387) | 2 | 4 | 7 | 28859 | 19 | ||
107702 | 34168 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 976 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/1997 12:00:00 AM | Permit Number 37998 | 6007565.65364026 | 2103976.53229663 | 37.7575462702202 | -122.416846121387 | (37.7575462702202, -122.416846121387) | 2 | 4 | 7 | 28859 | 19 | ||
19812 | 200419 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 975 Minna St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6007845.46701 | 2109984.51581 | 37.7740585275225 | -122.416303935197 | (37.7740585275225, -122.416303935197) | 8 | 2 | 9 | 28853 | 34 | |||
64702 | 200418 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 975 Minna St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6007829.74839 | 2109969.8332 | 37.7740173286603 | -122.416357268587 | (37.7740173286603, -122.416357268587) | 8 | 2 | 9 | 28853 | 34 | |||
72774 | 200420 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 975 Minna St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6007869.09874 | 2110009.15543 | 37.7741275109008 | -122.416223934192 | (37.7741275109008, -122.416223934192) | 8 | 2 | 9 | 28853 | 34 | |||
161202 | 23039 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 974 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1999 12:00:00 AM | 3 | 3X3 | 6006288.09528 | 2103940.95103 | 37.7573766296546 | -122.421261914723 | (37.7573766296546, -122.421261914723) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |
101071 | 4366 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 972 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1997 12:00:00 AM | 6 | 3x3 | 6001250.3703 | 2096084.7901 | 37.7355201753567 | -122.438121569403 | (37.7355201753567, -122.438121569403) | 2 | 7 | 5 | 63 | 7 | ||
104647 | 129892 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 97 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5996812.70207 | 2113910.24255 | 37.7842109731914 | -122.454751639797 | (37.7842109731914, -122.454751639797) | 11 | 6 | 1 | 54 | 31 | |||
92707 | 130254 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007628.28749 | 2120273.02795 | 37.8022960481814 | -122.417784622181 | (37.8022960481814, -122.417784622181) | 5 | 1 | 1 | 308 | 32 | |||
141362 | 130253 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007666.44506 | 2120279.02978 | 37.8023146749331 | -122.417653003691 | (37.8023146749331, -122.417653003691) | 5 | 1 | 1 | 308 | 32 | |||
128126 | 4707 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 09:15:00 PM | 3 | 5x5 | 6008654.9315 | 2120594.2013 | 37.8032356306012 | -122.414254658567 | (37.8032356306012, -122.414254658567) | 3 | 1 | 10 | 308 | 23 | ||
172473 | 4708 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/04/2017 05:46:00 AM | 3 | 5x5 | 6008638.9666 | 2120605.868 | 37.803266767654 | -122.414310731744 | (37.803266767654, -122.414310731744) | 3 | 1 | 10 | 308 | 23 | ||
56171 | 143015 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 968 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2016 07:32:00 AM | 16 | Width 0ft | 6008678.8788 | 2120570.254 | 37.8031712224349 | -122.414170092653 | (37.8031712224349, -122.414170092653) | 3 | 1 | 10 | 308 | 23 | ||
143446 | 61168 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 965 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21027 | 6007613.85907578 | 2104046.45562159 | 37.7577409749527 | -122.416684360488 | (37.7577409749527, -122.416684360488) | 2 | 4 | 7 | 28859 | 19 | ||
130834 | 23037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 963 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1992 12:00:00 AM | 25 | 3X3 | 6006343.28726 | 2103991.4173 | 37.7575183097436 | -122.421074621919 | (37.7575183097436, -122.421074621919) | 2 | 4 | 7 | 28859 | 19 | ||
28651 | 10347 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 962 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001436.23476 | 2109145.46871 | 37.7713922269598 | -122.438414402641 | (37.7713922269598, -122.438414402641) | 15 | 5 | 11 | 29492 | 9 | |||
87769 | 19168 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 96 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/1993 12:00:00 AM | 12 | 3X3 | 6003468.3495784 | 2107749.9495496 | 37.7676758500965 | -122.431285592248 | (37.7676758500965, -122.431285592248) | 15 | 9 | 5 | 28862 | 3 | ||
70581 | 23036 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 959 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1992 12:00:00 AM | 20 | 3X3 | 6006342.66021 | 2104018.5559 | 37.7575927906912 | -122.421078717432 | (37.7575927906912, -122.421078717432) | 2 | 4 | 7 | 28859 | 19 | ||
177150 | 111083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 959 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6008376.56974 | 2119291.97515 | 37.7996444034355 | -122.415125709103 | (37.7996444034355, -122.415125709103) | 5 | 1 | 10 | 308 | 32 | |||
21097 | 61167 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 959 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21026 | 6007612.00161276 | 2104079.97887736 | 37.7578329176461 | -122.4166931592 | (37.7578329176461, -122.4166931592) | 2 | 4 | 7 | 28859 | 19 | ||
51198 | 228190 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 958 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006285.66507 | 2103998.56863 | 37.7575346971956 | -122.421274410788 | (37.7575346971956, -122.421274410788) | 2 | 4 | 5 | 28859 | 19 | |||
107463 | 23035 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 956 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/1997 12:00:00 AM | 18 | 3X3 | 6006256.40031 | 2103986.38552 | 37.7574995952813 | -122.421374755124 | (37.7574995952813, -122.421374755124) | 2 | 4 | 5 | 28859 | 19 | ||
19510 | 70615 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 956 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007552.40866 | 2114767.26768 | 37.7871743274878 | -122.417656736796 | (37.7871743274878, -122.417656736796) | 13 | 1 | 10 | 28858 | 21 | |||
13670 | 82752 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 955 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52442 | 6008071.60927 | 2109939.40824 | 37.7739473865897 | -122.41551847362 | (37.7739473865897, -122.41551847362) | 8 | 2 | 9 | 28853 | 34 |
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) );