trees
8,659 rows where qSpecies_id = 11 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31657 | 3663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 99 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/12/1990 12:00:00 AM | 3 | 3X3 | 6017184.0839 | 2098879.25737 | 37.744086528482 | -122.383226584333 | (37.744086528482, -122.383226584333) | 10 | 3 | 8 | 58 | 1 | ||
185865 | 3655 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 91 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017319.27606 | 2098771.24223 | 37.7437974108278 | -122.382751600221 | (37.7437974108278, -122.382751600221) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |||
2242 | 122950 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
4353 | 6174 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | ||
4834 | 255234 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
5871 | 75838 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6011420.31077 | 2107843.20731 | 37.7683793546411 | -122.403787161967 | (37.7683793546411, -122.403787161967) | 8 | 2 | 8 | 28853 | 20 | |||
6978 | 253743 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
10482 | 22011 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2700 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/1995 12:00:00 AM | 6 | 3X3 | 6015860.87394 | 2102711.85412 | 37.754536828734 | -122.388069392194 | (37.754536828734, -122.388069392194) | 10 | 3 | 8 | 28856 | 29 | ||
10969 | 228599 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2128 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008713.06185 | 2105976.62248 | 37.7631025330823 | -122.413019323281 | (37.7631025330823, -122.413019323281) | 8 | 4 | 7 | 28859 | 19 | |||
11437 | 192684 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017502.05989 | 2095577.15005 | 37.7350371705351 | -122.38189744662 | (37.7350371705351, -122.38189744662) | 10 | 3 | 8 | 58 | 1 | |||
11595 | 21943 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2400 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1995 12:00:00 AM | 3 | 3X3 | 6015749.59409 | 2104353.68141 | 37.759038771941 | -122.388568827983 | (37.759038771941, -122.388568827983) | 10 | 3 | 8 | 28856 | 29 | ||
13109 | 38799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | Permit Number 40645 | ||||||||||||||
15918 | 255699 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
16985 | 202583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012034.01872 | 2108546.23297 | 37.7703439695143 | -122.40171381097 | (37.7703439695143, -122.40171381097) | 14 | 2 | 8 | 28856 | 20 | |||
18395 | 76233 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6015642.74628 | 2112555.88205 | 37.7815542949404 | -122.389511184418 | (37.7815542949404, -122.389511184418) | 6 | 2 | 9 | 28856 | 6 | |||
19516 | 201159 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 9 | : | Tree | Private 2 | 5 | Width 4ft | 6014843.23746 | 2099080.51228 | 37.7445094958311 | -122.39133484225 | (37.7445094958311, -122.39133484225) | 10 | 3 | 8 | 58 | 1 | |||
20687 | 130079 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006638.95897 | 2112585.46441 | 37.781132186441 | -122.420662137964 | (37.781132186441, -122.420662137964) | 7 | 9 | 11 | 28852 | 41 | |||
21625 | 14774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000X McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
21833 | 202745 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 Long Bridge St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014279.79053 | 2108951.83796 | 37.7715827370909 | -122.393974026007 | (37.7715827370909, -122.393974026007) | 14 | 3 | 9 | 310 | 20 | |||
22231 | 192640 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Cashmere St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016119.32854 | 2096115.08664 | 37.7364377809872 | -122.386715586059 | (37.7364377809872, -122.386715586059) | 10 | 3 | 8 | 58 | 1 | |||
22710 | 229085 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Putnam St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009095.80428 | 2096224.9104 | 37.736347980961 | -122.411006719696 | (37.736347980961, -122.411006719696) | 10 | 7 | 7 | 28859 | 2 | |||
27214 | 108859 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6015632.2 | 2115560.3 | 37.7898031599115 | -122.389757582477 | (37.7898031599115, -122.389757582477) | 6 | 2 | 9 | 28855 | 6 | ||||
27458 | 202733 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 20 Long Bridge St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6014631.41364 | 2109284.28528 | 37.7725150993229 | -122.392780993454 | (37.7725150993229, -122.392780993454) | 14 | 3 | 9 | 310 | 20 | |||
28029 | 29319 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5994043.25824 | 2097888.70202 | 37.7400607501907 | -122.463169946149 | (37.7400607501907, -122.463169946149) | 1 | 8 | 4 | 59 | 40 | ||
28251 | 191641 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6012284.92431 | 2114050.84012 | 37.7854723533096 | -122.401232795975 | (37.7854723533096, -122.401232795975) | 12 | 2 | 9 | 28853 | 6 | |||
28677 | 178295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 3x6 | 5990056.81744 | 2088683.04681 | 37.7145538887276 | -122.47628102917 | (37.7145538887276, -122.47628102917) | 1 | 8 | 4 | 64 | 14 | |||
32841 | 103295 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2013 12:00:00 AM | 3x3 | Permit Number 769976 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||
33234 | 208271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | 9 | 7 | 4 | 59 | 40 | |||
33369 | 191609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2400 Mendell St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013373.34204 | 2093012.51066 | 37.7277663334322 | -122.395992333084 | (37.7277663334322, -122.395992333084) | 10 | 3 | 8 | 58 | 1 | |||
34015 | 23229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 655X Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6006626.36739 | 2112726.37233 | 37.7815183756303 | -122.420715704793 | (37.7815183756303, -122.420715704793) | 7 | 9 | 11 | 28852 | 41 | |||
36751 | 121063 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
37684 | 94810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
38164 | 202363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 80 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015776.21123 | 2115314.46445 | 37.78913613646 | -122.389242139624 | (37.78913613646, -122.389242139624) | 6 | 2 | 9 | 28855 | 6 | |||
38420 | 250095 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 9 | : | Tree | Private 2 | 11 | Width 4ft | 6005324.16733 | 2115642.15375 | 37.789450908188 | -122.425428259725 | (37.789450908188, -122.425428259725) | 13 | 9 | 1 | 28858 | 41 | |||
41012 | 202514 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 749 02nd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015418.72361 | 2112179.14869 | 37.7805074463072 | -122.390259873595 | (37.7805074463072, -122.390259873595) | 6 | 2 | 9 | 28856 | 20 | |||
42511 | 192707 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 599 Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017583.67839 | 2096438.68812 | 37.7374072896996 | -122.3816751585 | (37.7374072896996, -122.3816751585) | 10 | 3 | 8 | 58 | 1 | |||
43356 | 130393 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013378.91553 | 2117221.99904 | 37.7942405867728 | -122.397670386194 | (37.7942405867728, -122.397670386194) | 4 | 1 | 10 | 28860 | 6 | |||
44204 | 130334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011603.10457 | 2120820.39092 | 37.80402185349 | -122.404068284619 | (37.80402185349, -122.404068284619) | 3 | 1 | 10 | 28860 | 6 | |||
44886 | 49661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 8 | Permit Number 46510 | 6000222.49515 | 2120829.72457 | 37.8034050435642 | -122.443452205969 | (37.8034050435642, -122.443452205969) | 13 | 9 | 1 | 57 | 17 | ||
45076 | 112096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6019785.67464 | 2093301.20525 | 37.7289137064936 | -122.373844504239 | (37.7289137064936, -122.373844504239) | 10 | 3 | 8 | 58 | 1 | |||
45943 | 192537 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 820 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010898.80972 | 2113269.36985 | 37.7832491923324 | -122.405973295145 | (37.7832491923324, -122.405973295145) | 12 | 2 | 9 | 28853 | 34 | |||
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 | ||
46923 | 229054 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3531 22nd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004929.83515 | 2103087.53248 | 37.7549566736176 | -122.425898571877 | (37.7549566736176, -122.425898571877) | 2 | 4 | 5 | 28862 | 22 | |||
47326 | 29265 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999025.51534 | 2100236.39083 | 37.746792692825 | -122.446112234204 | (37.746792692825, -122.446112234204) | 2 | 7 | 5 | 63 | 22 | ||
48050 | 201120 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3401 03rd St | 9 | : | Tree | Private 2 | 5 | Width 3ft | 6016104.5336 | 2099503.69829 | 37.7457413979641 | -122.38700300581 | (37.7457413979641, -122.38700300581) | 10 | 3 | 8 | 58 | 1 | |||
49444 | 101461 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011374.44126 | 2107692.69319 | 37.7679635144368 | -122.403935228122 | (37.7679635144368, -122.403935228122) | 8 | 2 | 8 | 28853 | 20 | |||
49862 | 340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
51089 | 22020 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2799 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2007 12:00:00 AM | 0 | 3X3 | 6015941.69116 | 2102557.11513 | 37.7541164253054 | -122.38777910638 | (37.7541164253054, -122.38777910638) | 10 | 3 | 8 | 28856 | 29 | ||
51103 | 91433 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/01/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
53004 | 47665 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 130 De Haro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45458 | 6011932.12138648 | 2107802.29908765 | 37.7682956086843 | -122.402013969527 | (37.7682956086843, -122.402013969527) | 8 | 3 | 8 | 28853 | 20 | ||
54820 | 191574 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6015165.95983 | 2097518.53465 | 37.7402385335877 | -122.390109826201 | (37.7402385335877, -122.390109826201) | 10 | 3 | 8 | 58 | 1 | |||
57731 | 7796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006248.95348 | 2112141.93432 | 37.7798923726783 | -122.421979848041 | (37.7798923726783, -122.421979848041) | 7 | 9 | 11 | 28852 | 41 | |||
57783 | 47633 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
58041 | 11905 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495 Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
58724 | 27474 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016026.07183 | 2100945.39988 | 37.7496956666258 | -122.387374870966 | (37.7496956666258, -122.387374870966) | 10 | 3 | 8 | 58 | 1 | ||
58850 | 201156 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3450 03rd St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6016026.46881 | 2099308.87493 | 37.7452021302722 | -122.387259357554 | (37.7452021302722, -122.387259357554) | 10 | 3 | 8 | 58 | 1 | |||
60021 | 160066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:19:00 AM | 3 | Width 0ft | 6000393.82803 | 2090707.46812 | 37.7207065384449 | -122.440697363085 | (37.7207065384449, -122.440697363085) | 9 | 7 | 6 | 28861 | 25 | ||
64876 | 6870 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/07/2011 12:00:00 AM | 3 | 3x3 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
70596 | 202504 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6015806.78326 | 2112583.35757 | 37.7816388303074 | -122.388945608849 | (37.7816388303074, -122.388945608849) | 6 | 2 | 9 | 28856 | 20 | |||
70679 | 363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 8 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
71040 | 255337 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 801x Gough St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005717 | 2112430 | 37.7806533149468 | -122.423840602482 | (37.7806533149468, -122.423840602482) | 7 | 9 | 11 | 28852 | 41 | ||||
71823 | 202373 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015435.81673 | 2115548.52151 | 37.7897599269371 | -122.390436232456 | (37.7897599269371, -122.390436232456) | 6 | 2 | 9 | 28855 | 6 | |||
72451 | 202762 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 89 Long Bridge St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014330.838 | 2108929.89793 | 37.7715253315638 | -122.393795912564 | (37.7715253315638, -122.393795912564) | 14 | 3 | 9 | 310 | 20 | |||
72519 | 130000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1047 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6006030.0944 | 2113466.83966 | 37.7835178926838 | -122.422831166043 | (37.7835178926838, -122.422831166043) | 7 | 9 | 11 | 28858 | 41 | |||
74810 | 86991 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 301 Executive Park Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.7111429140183 | -122.390768534473 | (37.7111429140183, -122.390768534473) | 10 | 3 | 8 | 58 | 1 | ||
75374 | 29812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
77063 | 130361 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011807.64809 | 2121011.70405 | 37.8045585787875 | -122.403373910883 | (37.8045585787875, -122.403373910883) | 3 | 1 | 10 | 28860 | 6 | |||
77080 | 91443 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
77731 | 21912 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2177 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/1995 12:00:00 AM | 9 | 3X3 | 6015776.7871 | 2105582.99607 | 37.7624157136285 | -122.388560590207 | (37.7624157136285, -122.388560590207) | 10 | 3 | 8 | 28856 | 29 | ||
78383 | 200436 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015707.38722 | 2101485.43428 | 37.7511608331158 | -122.388514594396 | (37.7511608331158, -122.388514594396) | 10 | 3 | 8 | 28856 | 1 | |||
78551 | 130243 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006013.54538 | 2120789.53922 | 37.8036232541808 | -122.423409164803 | (37.8036232541808, -122.423409164803) | 5 | 9 | 1 | 28858 | 32 | |||
80342 | 121514 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
80403 | 115137 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | |||||
84860 | 201420 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6018503.96229 | 2094561.26034 | 37.7323030129561 | -122.378362968895 | (37.7323030129561, -122.378362968895) | 10 | 3 | 8 | 58 | 1 | |||
86956 | 17947 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2014 12:00:00 AM | 3 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.436021882306 | (37.7875790308508, -122.436021882306) | 13 | 6 | 11 | 29490 | 27 | ||
88979 | 202606 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701 Division St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6011622.22809 | 2108398.01843 | 37.7699140180408 | -122.403127775434 | (37.7699140180408, -122.403127775434) | 14 | 2 | 8 | 28853 | 20 | |||
89422 | 197452 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 668 Natoma St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009185.76341 | 2111038.87777 | 37.7770288335587 | -122.411742116918 | (37.7770288335587, -122.411742116918) | 8 | 2 | 9 | 28853 | 34 | |||
89919 | 1787 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | |||
92115 | 22057 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3000 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2015 08:03:00 AM | 3 | 3x3 | 6015925.33481 | 2101359.47494 | 37.750827050625 | -122.38775211407 | (37.750827050625, -122.38775211407) | 10 | 3 | 8 | 28856 | 1 | ||
93052 | 41557 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 181 Shipley St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2000 12:00:00 AM | Permit Number 42081 | 6011929.63995711 | 2112113.99187797 | 37.7801343920604 | -122.402325751057 | (37.7801343920604, -122.402325751057) | 6 | 2 | 9 | 28856 | 34 | |||
93715 | 100117 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
94205 | 24959 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1995 12:00:00 AM | 7 | 3x3 | 6015946.43235 | 2100817.87014 | 37.7493410855268 | -122.387641373359 | (37.7493410855268, -122.387641373359) | 10 | 3 | 8 | 58 | 1 | ||
96059 | 74239 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 499 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 3x3 | 6012750.5 | 2109712.9 | 37.7735873297862 | -122.399317399206 | (37.7735873297862, -122.399317399206) | 14 | 2 | 9 | 28856 | 20 | |||
96629 | 201137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1101 Cesar Chavez St | 9 | : | Tree | Private 2 | 9 | Width 3ft | 6015512.83936 | 2101059.00392 | 37.749979161706 | -122.389157595246 | (37.749979161706, -122.389157595246) | 10 | 3 | 8 | 58 | 1 | |||
98570 | 44359 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | 5 | 1 | 10 | 308 | 23 | |||
100943 | 201436 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Harbor Rd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6018173.8141 | 2094960.79605 | 37.7333818567751 | -122.379532124417 | (37.7333818567751, -122.379532124417) | 10 | 3 | 8 | 58 | 1 | |||
101201 | 130320 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009003.41854 | 2121507.27888 | 37.8057622817731 | -122.413113306058 | (37.8057622817731, -122.413113306058) | 3 | 1 | 10 | 308 | 23 | |||
101678 | 192655 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016645.88477 | 2095959.61401 | 37.7360400225306 | -122.384884213834 | (37.7360400225306, -122.384884213834) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
102172 | 97726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | ||
102325 | 130169 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 60 Fell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007059.59937 | 2110875.31453 | 37.7764602254961 | -122.419085590445 | (37.7764602254961, -122.419085590445) | 7 | 9 | 9 | 28852 | 36 | |||
103432 | 22985 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 9 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
105270 | 11862 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 0 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
109934 | 228074 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 15 Elk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000783.47885 | 2096466.54594 | 37.7365418235496 | -122.43976314736 | (37.7365418235496, -122.43976314736) | 2 | 7 | 5 | 63 | 7 | |||
110822 | 17654 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
111395 | 202798 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014301.65452 | 2108701.46714 | 37.7708964896101 | -122.393880867921 | (37.7708964896101, -122.393880867921) | 14 | 3 | 9 | 310 | 20 | |||
113686 | 117470 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 511x HAMPSHIRE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010223 | 2105808 | 37.7627241794067 | -122.407785042208 | (37.7627241794067, -122.407785042208) | 8 | 4 | 8 | 28859 | 19 |
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) );