trees

1,521 rows where qSpecies_id = 37 sorted by DBH descending

✎ View and edit SQL

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)
151861 12943 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 725X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1     90     6005046.7981655 2104134.69405 37.7578385432445 -122.425568603003 (37.7578385432445, -122.425568603003) 2 4 5 28859 19
2934 70681 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 366 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6010590.1917 2106606.8545 37.7649382022496 -122.406571346991 (37.7649382022496, -122.406571346991) 8 4 8 28853 19
3896 227738 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1240 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1991 12:00:00 AM 9 Width 4ft Permit Number 30100 5997494.2501 2105433.95534 37.7609763468939 -122.451782059502 (37.7609763468939, -122.451782059502) 15 5 11 29492 12
10294 129716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006809.35 2120459.56601 37.8027621146536 -122.420631800213 (37.8027621146536, -122.420631800213) 5 1 1 28858 32
16537 79734 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 278 Clara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011401.45456 2111396.60649 37.7781351201838 -122.404102493055 (37.7781351201838, -122.404102493055) 14 2 9 28856 34
27404 246068 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 5 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999954.0153 2108402.9707 37.7692690935594 -122.443488110434 (37.7692690935594, -122.443488110434) 15 5 11 29492 9
27531 208119 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 915 Darien Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5994530.86611 2094005.87306 37.7294275350513 -122.461202626994 (37.7294275350513, -122.461202626994) 9 8 4 59 40
29583 116767 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 598X EUREKA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6001504 2102368 37.7527868092986 -122.437694527956 (37.7527868092986, -122.437694527956) 2 4 5 28862 22
34037 208045 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 25 Forest Side Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992699.77164 2098959.96028 37.7429246682415 -122.467893029044 (37.7429246682415, -122.467893029044) 1 8 4 59 40
39417 183548 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2590 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5989271.0961 2097748.8175 37.7394005980364 -122.479659706735 (37.7394005980364, -122.479659706735) 1 8 3 29491 35
39605 227772 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4143 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6002232.11959 2102348.47866 37.7527745820066 -122.435175165117 (37.7527745820066, -122.435175165117) 2 4 5 28862 22
40505 129715 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006786.67092 2120456.10735 37.8027513398688 -122.420710035851 (37.8027513398688, -122.420710035851) 5 1 1 28858 32
42819 228018 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1118 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998188.96847 2106410.92165 37.7636986145324 -122.449449737921 (37.7636986145324, -122.449449737921) 15 5 11 29492 9
45535 33646 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 491 Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 9   Permit Number 37738 6005091.8882 2110750.3935 37.776006217968 -122.425883573067 (37.776006217968, -122.425883573067) 7 9 11 28852 10
48739 106913 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 141 JULIAN AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6006471.6 2107041.4 37.7659000812053 -122.420847395478 (37.7659000812053, -122.420847395478) 8 4 7 28853 19
51573 191120 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 209 Mississippi St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014042.89853 2106078.37631 37.7636796783924 -122.394592205568 (37.7636796783924, -122.394592205568) 14 3 8 28856 29
56543 129692 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6000656.11857 2116207.75576 37.7907390566157 -122.441619752742 (37.7907390566157, -122.441619752742) 13 6 1 29490 27
57128 191147 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 44 Boardman Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011750.26705 2110044.73207 37.7744426675252 -122.402800717192 (37.7744426675252, -122.402800717192) 14 2 9 28853 34
58074 191553 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 151 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6012602.20262 2106783.19503 37.7655347531458 -122.399624646269 (37.7655347531458, -122.399624646269) 14 3 8 28856 20
58315 248471 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 753 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5998562.8185 2107931.7687 37.7678958552223 -122.448266233683 (37.7678958552223, -122.448266233683) 15 5 11 29492 9
58555 208143 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 40 Garcia Ave 3 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   5995206.31782 2099507.68118 37.7445729969391 -122.459265799394 (37.7445729969391, -122.459265799394) 1 8 4 59 40
65279 227969 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010032.30789 2099922.75582 37.7465539345268 -122.408029521258 (37.7465539345268, -122.408029521258) 2 7 7 28859 2
66762 227809 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 930 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1979 12:00:00 AM 9 Width 3ft Permit Number 17590 5999239.85444 2106888.20822 37.765069183133 -122.445849391156 (37.765069183133, -122.445849391156) 15 5 5 29492 9
69072 140475 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1299 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003263.9128 2112672.0778 37.7811792109881 -122.432344295437 (37.7811792109881, -122.432344295437) 15 9 11 29490 41
72349 227765 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 869 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001308.58538 2101306.39787 37.7498607911403 -122.438294258574 (37.7498607911403, -122.438294258574) 2 4 5 28862 22
72695 227926 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 123 Conrad St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6001798.97519 2096621.3956 37.737024754984 -122.436263227863 (37.737024754984, -122.436263227863) 2 7 5 63 7
78633 191135 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 651 Arthur Ave 1 Sidewalk: Property side : Yard Tree Private 2     9     6015829.29207 2099737.97336 37.7463694242077 -122.387971104383 (37.7463694242077, -122.387971104383) 10 3 8 58 1
81793 140551 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800x WEBSTER ST 3 Median : Cutout Tree DPW 1     9 Width 0ft   6003947.0899 2111598.2308 37.7782694076565 -122.42990422118 (37.7782694076565, -122.42990422118) 7 9 11 29490 41
89586 248502 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 160 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5998304.9595 2107828.0497 37.7675963241352 -122.449150661447 (37.7675963241352, -122.449150661447) 15 5 11 29492 9
91066 59336 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 775 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 9   Permit Number 31976 5982585.1174 2110516.14744 37.7740654203717 -122.50372176445 (37.7740654203717, -122.50372176445) 11 6 2 55 26
91848 245930 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 8 Beulah St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5997897.9572 2107873.0198 37.7676965134568 -122.450561665801 (37.7676965134568, -122.450561665801) 15 5 11 29492 9
92113 208100 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2291 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991679.25346 2099828.98191 37.7452517953444 -122.471484974349 (37.7452517953444, -122.471484974349) 1 8 4 29491 40
96592 247313 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 235 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6002747.4483 2109401.7096 37.7721702964431 -122.433897175351 (37.7721702964431, -122.433897175351) 15 5 11 29492 9
99900 101219 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 444 De Haro St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6012016.9704 2106218.6671 37.7639520461846 -122.401609164037 (37.7639520461846, -122.401609164037) 8 3 8 28856 29
100388 129727 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 333 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011976.37318 2119087.45755 37.7992844875525 -122.402654616021 (37.7992844875525, -122.402654616021) 3 1 10 308 23
100999 101214 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 444 De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6012005.53818 2106423.45815 37.7645137186686 -122.401663099973 (37.7645137186686, -122.401663099973) 8 3 8 28856 29
109019 208063 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 459 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   5993844.11289 2101701.56795 37.7505184428887 -122.464135229877 (37.7505184428887, -122.464135229877) 1 8 4 29491 40
109928 191144 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 75 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014827.12403 2113162.01848 37.7831733516173 -122.39237527782 (37.7831733516173, -122.39237527782) 6 2 9 28856 6
110048 245956 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 753 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5997593.1598 2107917.3843 37.76780087666 -122.45161911748 (37.76780087666, -122.45161911748) 15 5 11 29492 9
116621 245960 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 826 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5997194.7881 2107596.3855 37.7668966742107 -122.45297385706 (37.7668966742107, -122.45297385706) 15 5 11 29492 9
117172 38503 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2442 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM 9   Permit Number 40494 6006707.70986 2119633.57608 37.8004884270583 -122.420924848825 (37.8004884270583, -122.420924848825) 5 9 1 28858 32
121582 191150 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 46 Boardman Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011793.36377 2109999.80296 37.7743217087203 -122.402648476365 (37.7743217087203, -122.402648476365) 14 2 9 28853 34
128077 228009 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 109 Alma St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998119.85145 2106206.2133 37.7631325830122 -122.449674038744 (37.7631325830122, -122.449674038744) 15 5 11 29492 9
130530 245064 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 32 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000392.6081 2109071.4254 37.7711295053866 -122.44201903159 (37.7711295053866, -122.44201903159) 15 5 11 29492 9
137251 129731 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 332 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011929.52293 2119129.49117 37.7993972859062 -122.402819692899 (37.7993972859062, -122.402819692899) 3 1 10 308 23
140720 191130 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 887 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6012179.62384 2104272.6112 37.758617683286 -122.400909853925 (37.758617683286, -122.400909853925) 10 3 8 28856 29
143648 228024 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4977 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5997519.34069 2105604.11976 37.7614450124062 -122.451707557883 (37.7614450124062, -122.451707557883) 15 5 11 29492 12
143784 140477 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1299 FILLMORE ST 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003269.6358 2112623.4327 37.7810459682248 -122.432321021452 (37.7810459682248, -122.432321021452) 15 9 11 29490 41
146028 228023 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4983 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5997504.72256 2105600.12187 37.7614331980103 -122.451757827265 (37.7614331980103, -122.451757827265) 15 5 11 29492 12
146802 99323 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1150 Vicente St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5989330.3766 2097681.8666 37.7392202117097 -122.479449846275 (37.7392202117097, -122.479449846275) 1 8 3 29491 35
147466 227858 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 132 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004094.70808 2102310.56792 37.7527760802641 -122.428731293332 (37.7527760802641, -122.428731293332) 2 4 5 28862 22
149261 227808 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 930 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999237.81252 2106917.22715 37.7651487452469 -122.445858540841 (37.7651487452469, -122.445858540841) 15 5 5 29492 9
151231 247318 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 225 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6002751.6889 2109356.6539 37.7720468252571 -122.433879285742 (37.7720468252571, -122.433879285742) 15 5 11 29492 9
151260 67337 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 639 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1992 12:00:00 AM 9   Permit Number 30821 5993452.94224 2111127.09035 37.776375902741 -122.466172798249 (37.776375902741, -122.466172798249) 11 6 2 54 11
151369 227820 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 11 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007044.27544 2099680.4476 37.7457208601291 -122.418344661488 (37.7457208601291, -122.418344661488) 2 7 7 28859 2
154227 244028 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 505 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5997955.1459 2108804.2678 37.7702567557727 -122.450430998709 (37.7702567557727, -122.450430998709) 15 5 11 29492 9
155141 227943 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2526 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009705.19097 2102597.95155 37.7538811087357 -122.409349420246 (37.7538811087357, -122.409349420246) 2 4 7 28859 19
161374 227847 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 221 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003542.15255 2100956.57814 37.7490270539503 -122.43054552537 (37.7490270539503, -122.43054552537) 2 4 5 28862 22
166657 142195 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 333 BAKER ST 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000674.1127 2110102.0455 37.7739753669119 -122.441119253455 (37.7739753669119, -122.441119253455) 15 5 11 29492 16
169394 103127 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 871 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 6x9   6012175.18388 2104366.03206 37.758873948693 -122.400931773105 (37.758873948693, -122.400931773105) 10 3 8 28856 29
180983 140358 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1527 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003135.2322 2113566.3871 37.7836274623194 -122.432853374116 (37.7836274623194, -122.432853374116) 13 9 11 29490 41
181296 139756 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1520 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003178.6209 2113599.5503 37.7837209809063 -122.432705635675 (37.7837209809063, -122.432705635675) 13 9 11 29490 41
181681 191522 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1089 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015567.39851 2104058.65501 37.7582185938385 -122.389178351619 (37.7582185938385, -122.389178351619) 10 3 8 28856 29
187207 227541 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 141 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006449.92183 2107026.17298 37.7658570494855 -122.420921294707 (37.7658570494855, -122.420921294707) 8 4 7 28853 19
187684 227764 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4314 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001842.53618 2100618.06148 37.7480011379615 -122.436398576738 (37.7480011379615, -122.436398576738) 2 4 5 28862 22
189567 67610 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1095 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1992 12:00:00 AM 9   Permit Number 31188 6015569.94295 2104025.3864 37.7581273863874 -122.389167228807 (37.7581273863874, -122.389167228807) 10 3 8 28856 29
190204 129742 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 John Maher St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6012372.32254 2119675.23965 37.8009204937473 -122.401325813756 (37.8009204937473, -122.401325813756) 3 1 10 28860 6
191109 208137 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 41 Santa Rita Ave 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5993786.87978 2100730.78266 37.7478496147728 -122.464262673683 (37.7478496147728, -122.464262673683) 1 8 4 29491 40
32751 4718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 5 Median : Cutout Tree DPW 1     80 3   6008205.1504 2120957.4944 37.8042078669522 -122.415836885075 (37.8042078669522, -122.415836885075) 5 1 10 308 23
81901 4714 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 1 Median : Cutout Tree DPW 1     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828) 5 1 10 308 23
7219 100493 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
7332 81252 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 877 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011897.37583 2104298.81412 37.7586738828079 -122.40188784325 (37.7586738828079, -122.40188784325) 10 3 8 28856 29
8015 35369 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 628 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 8 5x9 Permit Number 780712 6010944.29074 2105222.09895 37.76115577964 -122.405249080092 (37.76115577964, -122.405249080092) 10 3 8 28856 29
8852 248572 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 196 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998334.1825 2107625.9113 37.7670429747654 -122.449035020083 (37.7670429747654, -122.449035020083) 15 5 11 29492 9
8889 227748 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 899 Jarboe Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6009090.18719 2096911.91378 37.7382340283696 -122.411074651796 (37.7382340283696, -122.411074651796) 10 7 7 28859 2
9169 208142 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 40 Garcia Ave 2 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5995206.6173 2099521.98382 37.7446122856405 -122.459265799391 (37.7446122856405, -122.459265799391) 1 8 4 59 40
9372 208097 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1578 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992786.16766 2104723.32687 37.7587543775304 -122.468013427586 (37.7587543775304, -122.468013427586) 1 8 4 56 12
10550 72745 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 630 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6014368.47068 2104204.35874 37.7585521280858 -122.39333499383 (37.7585521280858, -122.39333499383) 10 3 8 28856 29
14122 247317 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 225 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6002750.0987 2109384.7475 37.7721238731083 -122.433886794778 (37.7721238731083, -122.433886794778) 15 5 11 29492 9
18131 69952 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 565 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5997087.15611 2114145.30542 37.7848721322932 -122.453819112066 (37.7848721322932, -122.453819112066) 11 6 1 54 31
22293 218388 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 50 San Marcos Ave 10 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5993887.93086 2100247.90665 37.7465295835701 -122.463878201824 (37.7465295835701, -122.463878201824) 1 8 4 29491 40
23195 250130 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1377 Post St 2 : Tree Private 2     8 Width 4ft   6005624.52501 2114452.88232 37.7862024301534 -122.424304434526 (37.7862024301534, -122.424304434526) 13 9 1 28858 41
29213 227825 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 397 Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008200.41654 2096957.11494 37.7383082035529 -122.414154245241 (37.7383082035529, -122.414154245241) 2 7 7 28859 2
29425 208077 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 338 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995744.67706 2091237.28528 37.7218954350055 -122.456806235434 (37.7218954350055, -122.456806235434) 9 8 4 28861 24
30047 129688 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3033 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003377.01383 2118791.5959 37.7979882632152 -122.43239022283 (37.7979882632152, -122.43239022283) 13 9 1 57 17
30712 2409 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2743 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1996 12:00:00 AM 8 3X3   6009838.5674 2101356.55662 37.7504799860819 -122.408800596389 (37.7504799860819, -122.408800596389) 2 4 7 28859 19
34532 100497 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
34668 4669 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 4 Median : Cutout Tree DPW 1   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711) 3 1 10 308 23
40137 4634 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 1 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685 -122.409399111615 (37.799747198685, -122.409399111615) 3 1 10 308 4
41147 142196 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 333 BAKER ST 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000678.9996 2110060.0187 37.7738602502702 -122.441099333105 (37.7738602502702, -122.441099333105) 15 5 11 29492 16
41165 208022 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1670 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5993736.11126 2104143.24753 37.7572164424068 -122.464685989083 (37.7572164424068, -122.464685989083) 1 8 4 56 12
41613 36688 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 21 Albion St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 8 3x3 Permit Number 39487 6005806.4873735 2107131.86319182 37.76611096005 -122.423154315796 (37.76611096005, -122.423154315796) 8 4 5 28853 19
45024 227769 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 90 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000345.07571 2101218.59101 37.7495648458573 -122.441619809413 (37.7495648458573, -122.441619809413) 2 4 5 28862 22
47713 227542 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 141 Julian Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006449.70519 2107045.25708 37.7659094377086 -122.420923399089 (37.7659094377086, -122.420923399089) 8 4 7 28853 19
49079 191124 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 601 Carolina St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6012423.59359 2105049.63029 37.760764811978 -122.400120660154 (37.760764811978, -122.400120660154) 10 3 8 28856 29
50326 227816 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 177 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007369.02598 2097414.123 37.7395163132196 -122.417061165265 (37.7395163132196, -122.417061165265) 2 7 7 28859 2
52480 65056 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3033 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/1989 12:00:00 AM 8   Permit Number 27010 6003374.31765 2118807.79308 37.7980325835968 -122.432400709833 (37.7980325835968, -122.432400709833) 13 9 1 57 17
55551 140410 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1325 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6003227.817 2112933.649 37.7818953731726 -122.432487857443 (37.7818953731726, -122.432487857443) 15 9 11 29490 41
57325 208146 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 40 Garcia Ave 6 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5995205.6435 2099446.88271 37.7444060207274 -122.45926372915 (37.7444060207274, -122.45926372915) 1 8 4 59 40
57669 227984 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 151 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004984.7941 2098700.56967 37.7429141920365 -122.425396332001 (37.7429141920365, -122.425396332001) 2 7 5 63 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);