home / trees

Street_Tree_List

Data source: data.sfgov.org

8,520 rows where qSpecies = 9

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
35 100030 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 535@Clay Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19     6012036.249419999 2117732.6252099997 37.795567786487496 -122.40235210926201 (37.7955677864875, -122.402352109262) 3 1 10 28860 4
61 100054 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
62 100055 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
63 100056 Significant Tree 4 Lophostemon confertus :: Brisbane Box 9 401X Tehama St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
66 100059 Section 143 6 Lophostemon confertus :: Brisbane Box 9 260 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
68 100060 Section 143 6 Lophostemon confertus :: Brisbane Box 9 260 05th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
74 100066 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 93 Buena Vista Ter 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/29/2012 12:00:00 AM   2x2 Permit Number 768610 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
90 100080 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 701X POLK ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774752 6007001.0 2113322.0 37.7831749319814 -122.419461922492 (37.7831749319814, -122.419461922492) 7 9 9 28858 36
116 100109 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
118 100110 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
119 100111 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
120 100112 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
121 100113 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
122 100114 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
123 100115 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
124 100116 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
125 100117 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
126 100118 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
127 100119 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
128 100120 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
177 100175 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1140 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/12/2012 12:00:00 AM   3x3 Permit Number 768230 6001099.0 2109378.2 37.772012061027006 -122.43959759817301 (37.772012061027, -122.439597598173) 15 5 11 29492 9
286 100296 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1494 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4.5x5   5994028.4 2105353.7 37.76055687821629 -122.46376300352301 (37.7605568782163, -122.463763003523) 1 5 11 56 12
288 100298 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 250 Kirkham St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
292 100300 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 250 Kirkham St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
293 100301 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 250 Kirkham St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
294 100302 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 250 Kirkham St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
296 100304 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 250 Kirkham St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5994135.4 2105324.6 37.7604831423825 -122.463390830401 (37.7604831423825, -122.463390830401) 1 5 11 56 12
324 100338 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 3 3x3 Permit Number 767726 6008923.44106 2111377.62388 37.7779442309909 -122.41267352768801 (37.7779442309909, -122.412673527688) 8 2 9 28853 34
325 100339 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 2 3x3 Permit Number 767726 6008905.6037 2111360.20225 37.7778953941811 -122.412734001686 (37.7778953941811, -122.412734001686) 8 2 9 28853 34
326 100340 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 3 3x3 Permit Number 767726 6008888.95993 2111345.40532 37.7778538311389 -122.412790532155 (37.7778538311389, -122.412790532155) 8 2 9 28853 34
327 100341 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 4 3x3 Permit Number 767726 6008871.11478 2111327.60525 37.777803954724604 -122.412851006189 (37.7778039547246, -122.412851006189) 8 2 9 28853 34
328 100342 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 4 3x3 Permit Number 767726 6008841.69587 2111301.3376700003 37.777730178835704 -122.412950919067 (37.7777301788357, -122.412950919067) 8 2 9 28853 34
329 100343 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 3 3x3 Permit Number 767726 6008825.45514 2111287.66775 37.7776917328153 -122.41300613473699 (37.7776917328153, -122.413006134737) 8 2 9 28853 34
330 100344 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1190 Mission St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/2012 12:00:00 AM 4 3x3 Permit Number 767726 6008816.06754 2111274.61433 37.7776553642406 -122.41303768656401 (37.7776553642406, -122.413037686564) 8 2 9 28853 34
530 100585 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 270x 05th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3     6011529.62988 2112216.22494 37.780392762953504 -122.40371677113501 (37.7803927629535, -122.403716771135) 14 2 9 28853 34
570 100627 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 270X 05th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3     6011410.5 2112131.8 37.780154296134704 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
571 100628 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 270X 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3     6011410.5 2112131.8 37.780154296134704 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
572 100629 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 270X 05th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3     6011502.95528 2112245.6234 37.7804719941376 -122.403811120803 (37.7804719941376, -122.403811120803) 14 2 9 28853 34
660 10074 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 589 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/09/1990 12:00:00 AM 12 2X2   6005613.39136 2105612.3018 37.76192770550821 -122.423714143811 (37.7619277055082, -122.423714143811) 8 4 5 28859 19
670 100752 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
671 100753 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
672 100754 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
673 100755 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
674 100756 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
675 100757 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
676 100758 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 700X Brannan St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6012260.07583 2110177.24035 37.7748349572731 -122.401046493351 (37.7748349572731, -122.401046493351) 14 2 9 28853 34
812 100911 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1400x 15th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6007975.0 2107432.0 37.7670572023826 -122.415675090491 (37.7670572023826, -122.415675090491) 8 4 7 28853 19
889 10103 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 780 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/11/1994 12:00:00 AM 15 2x2   6005610.101530001 2104443.54178 37.7587183794707 -122.423642421088 (37.7587183794707, -122.423642421088) 2 4 5 28859 19
900 10104 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 780 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/11/1994 12:00:00 AM 13 3x5   6005610.4392800005 2104403.21485 37.758607670231 -122.42363838580401 (37.758607670231, -122.423638385804) 2 4 5 28859 19
918 101064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 2 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
919 101065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 1 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
931 101082 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1699X Tennessee St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6015823.0 2101385.0 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
932 101083 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1699X Tennessee St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6015823.0 2101385.0 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
1084 101239 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 3000X Divisadero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/21/2014 12:00:00 AM 2 3x3 Permit Number 771215 6000530.949030001 2118615.7760400004 37.7973437154854 -122.44222576721201 (37.7973437154854, -122.442225767212) 13 9 1 57 17
1091 101248 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 634 IRVING ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   5993713.5 2106706.6 37.7642534373973 -122.464950347427 (37.7642534373973, -122.464950347427) 11 8 11 56 12
1152 101312 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 4244X 19th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     12 4x4   6001912.0 2104709.0 37.7592378221466 -122.43645112889901 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
1171 101331 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 15X Kittredge Ter 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   5997920.7 2111591.6 37.777908079309896 -122.450751145765 (37.7779080793099, -122.450751145765) 15 6 2 54 16
1172 101332 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 15X Kittredge Ter 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 3x3   5997920.7 2111591.6 37.777908079309896 -122.450751145765 (37.7779080793099, -122.450751145765) 15 6 2 54 16
1199 101363 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 394 Broadway 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6011665.4 2118805.7 37.7984934826399 -122.40371086132 (37.7984934826399, -122.40371086132) 3 1 10 308 23
1200 101364 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 394 Broadway 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6011665.4 2118805.7 37.7984934826399 -122.40371086132 (37.7984934826399, -122.40371086132) 3 1 10 308 23
1201 101365 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 394 Broadway 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6011665.4 2118805.7 37.7984934826399 -122.40371086132 (37.7984934826399, -122.40371086132) 3 1 10 308 23
1215 101387 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1777 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x3   6001446.8 2091921.2 37.7240990805525 -122.437144428251 (37.7240990805525, -122.437144428251) 9 7 6 28861 25
1216 101388 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1777 Alemany Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x3   6001446.8 2091921.2 37.7240990805525 -122.437144428251 (37.7240990805525, -122.437144428251) 9 7 6 28861 25
1217 101389 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1777 Alemany Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x3   6001446.8 2091921.2 37.7240990805525 -122.437144428251 (37.7240990805525, -122.437144428251) 9 7 6 28861 25
1219 101390 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1777 Alemany Blvd 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x3   6001446.8 2091921.2 37.7240990805525 -122.437144428251 (37.7240990805525, -122.437144428251) 9 7 6 28861 25
1285 101452 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011366.43435 2107858.17309 37.76841743734529 -122.40397456987 (37.7684174373453, -122.40397456987) 8 2 8 28853 20
1286 101453 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011366.28419 2107838.89709 37.7683645014365 -122.40397373259701 (37.7683645014365, -122.403973732597) 8 2 8 28853 20
1287 101454 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3 Permit Number 769522 6011366.607890001 2107819.1296599996 37.768310242646606 -122.403971221693 (37.7683102426466, -122.403971221693) 8 2 8 28853 20
1288 101456 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011371.03407 2107798.7966299998 37.768254660051106 -122.40395448083 (37.7682546600511, -122.40395448083) 8 2 8 28853 20
1290 101458 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011372.13626 2107757.80647 37.768142171953 -122.403947783556 (37.768142171953, -122.403947783556) 8 2 8 28853 20
1291 101459 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011371.6069 2107731.79075 37.7680707091139 -122.403947783585 (37.7680707091139, -122.403947783585) 8 2 8 28853 20
1293 101460 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011373.5993099995 2107710.78439 37.7680131417293 -122.40393941359699 (37.7680131417293, -122.403939413597) 8 2 8 28853 20
1294 101461 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011374.44126 2107692.69319 37.7679635144368 -122.40393522812201 (37.7679635144368, -122.403935228122) 8 2 8 28853 20
1295 101462 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011376.9421 2107672.88146 37.7679092556385 -122.40392518362101 (37.7679092556385, -122.403925183621) 8 2 8 28853 20
1296 101463 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011376.92788 2107636.49255 37.767809339149 -122.40392267180201 (37.767809339149, -122.403922671802) 8 2 8 28853 20
1297 101464 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011378.397419999 2107613.56866 37.7677464774454 -122.403915975464 (37.7677464774454, -122.403915975464) 8 2 8 28853 20
1298 101465 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 102 Henry Adams St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6011381.48513 2107598.80565 37.767706114071395 -122.403904256402 (37.7677061140714, -122.403904256402) 8 2 8 28853 20
1308 101474 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 541 Congo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/04/2016 12:00:00 AM     Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963) 9 7 4 63 40
1309 101475 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 541 Congo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/04/2016 12:00:00 AM     Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963) 9 7 4 63 40
1314 101483 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1315 101484 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1316 101485 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1317 101486 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1318 101487 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1319 101488 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 1805X Alameda St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6011653.3 2107915.0 37.7685894941919 -122.402986319314 (37.7685894941919, -122.402986319314) 8 2 8 28853 20
1377 10156 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 998 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6005679.7391 2103202.59116 37.7553149491356 -122.423313367215 (37.7553149491356, -122.423313367215) 2 4 5 28859 19
1415 1016 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1856 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/06/1997 12:00:00 AM 12 3x3   6001112.043219999 2091350.8843 37.722514088530296 -122.43826079120899 (37.7225140885303, -122.438260791209) 9 7 6 28861 25
1433 101620 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 32 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x2   6004057.0 2108606.0 37.7700596990804 -122.429310574863 (37.7700596990804, -122.429310574863) 7 9 5 29492 10
1550 101744 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 1000 Montgomery St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 25770 6011635.0 2118713.0 37.7982372525996 -122.403809528937 (37.7982372525996, -122.403809528937) 3 1 10 308 23
1551 101745 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 1000 Montgomery St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 25770 6011635.0 2118713.0 37.7982372525996 -122.403809528937 (37.7982372525996, -122.403809528937) 3 1 10 308 23
1552 101746 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 1000 Montgomery St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 25770 6011635.0 2118713.0 37.7982372525996 -122.403809528937 (37.7982372525996, -122.403809528937) 3 1 10 308 23
1553 101747 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 1000 Montgomery St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 25770 6011635.0 2118713.0 37.7982372525996 -122.403809528937 (37.7982372525996, -122.403809528937) 3 1 10 308 23
1593 101808 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 3149 26th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.41263499808599 (37.7488661984732, -122.412634998086) 2 4 7 28859 19
1625 101876 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 150X Moulton St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3 Permit Number 48902 6002586.0 2119386.0 37.7995754568509 -122.435169891098 (37.7995754568509, -122.435169891098) 13 9 1 57 17
1626 101877 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 150X Moulton St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3 Permit Number 48902 6002592.4 2119429.3 37.799694710759795 -122.435150843512 (37.7996947107598, -122.435150843512) 13 9 1 57 17
1627 101879 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 150X Moulton St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3 Permit Number 48902 6002592.4 2119429.3 37.799694710759795 -122.435150843512 (37.7996947107598, -122.435150843512) 13 9 1 57 17
1714 101995 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 501X Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6014257.0 2114662.0 37.7872602812755 -122.394452755334 (37.7872602812755, -122.394452755334) 6 2 9 28855 6
1715 101996 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 501X Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6014257.0 2114662.0 37.7872602812755 -122.394452755334 (37.7872602812755, -122.394452755334) 6 2 9 28855 6
1716 101997 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 501X Folsom St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6014257.0 2114662.0 37.7872602812755 -122.394452755334 (37.7872602812755, -122.394452755334) 6 2 9 28855 6
1717 101998 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 501X Folsom St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6014257.0 2114662.0 37.7872602812755 -122.394452755334 (37.7872602812755, -122.394452755334) 6 2 9 28855 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 289.769ms · Data source: data.sfgov.org