3,965 rows where qSpecies_id = 70 sorted by Neighborhoods (old) descending

View and edit SQL

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) ▲
161188 30022 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1659 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2016 10:15:00 AM 3 3x3   5998115.9942 2108549.9942 37.7695677899652 -122.449856300055 (37.7695677899652, -122.449856300055) 15 5 11 29492 9
162649 244118 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1669 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5998605.0908 2108964.4459 37.7707337409227 -122.44819438748 (37.7707337409227, -122.44819438748) 15 5 11 29492 9
163575 10454 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1552 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5998706.96692 2108696.47387 37.7700037813949 -122.44782270261 (37.7700037813949, -122.44782270261) 15 5 11 29492 9
164017 10501 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1738 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   5997829.7408 2108561.4434 37.7695828440479 -122.450847260907 (37.7695828440479, -122.450847260907) 15 5 11 29492 9
164112 10363 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1136 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X4   6000656.6881 2108954.0474 37.7708222602121 -122.441097149265 (37.7708222602121, -122.441097149265) 15 5 11 29492 9
164221 246118 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1420 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 6 Width 0ft Permit Number 31980 5998892.5994 2108357.8492 37.7690846123177 -122.447156231753 (37.7690846123177, -122.447156231753) 15 5 11 29492 9
165440 10335 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 860 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     26 4x4   6002028.0975 2109143.8299 37.7714213748567 -122.436367006921 (37.7714213748567, -122.436367006921) 15 5 11 29492 9
167126 246248 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 94 Frederick St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999664.5107 2107772.1777 37.7675205800989 -122.444444148814 (37.7675205800989, -122.444444148814) 15 5 11 29492 9
167910 253885 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1426 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   5999293.06838 2108758.58264 37.7702077984518 -122.445799862231 (37.7702077984518, -122.445799862231) 15 5 11 29492 9
168160 20107 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1875X Haight St 6 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   5997178.90707 2108418.46554 37.7691529849708 -122.453088136651 (37.7691529849708, -122.453088136651) 15 5 11 29492 9
170493 246110 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1899 Haight St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5997221.5885 2108425.0772 37.7691735849139 -122.452940982068 (37.7691735849139, -122.452940982068) 15 5 11 29492 9
170954 5163 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 288 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24     6001824.579 2109378.5545 37.7720543041481 -122.437087794368 (37.7720543041481, -122.437087794368) 15 5 11 29492 9
172589 246189 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1342 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   5999553.3724 2108105.2897 37.7684288799769 -122.444852507953 (37.7684288799769, -122.444852507953) 15 5 11 29492 9
173865 248321 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1323 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999491.7467 2108226.5728 37.7687583756776 -122.445074385233 (37.7687583756776, -122.445074385233) 15 5 11 29492 9
174034 10452 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1543 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 4X4   5998725.8919 2108633.2722 37.7698313273448 -122.447752691123 (37.7698313273448, -122.447752691123) 15 5 11 29492 9
174168 246162 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 650 Shrader St 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 0ft   5997588.6173 2108259.4297 37.7687397856882 -122.451659505531 (37.7687397856882, -122.451659505531) 15 5 11 29492 9
179775 48496 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 3 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2002 12:00:00 AM     Permit Number 45837 6001939.6131076 2108727.84798346 37.7702741635264 -122.436643297557 (37.7702741635264, -122.436643297557) 15 5 5 29492 9
180519 247490 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 324 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6002272.5041 2109643.1807 37.7728063526387 -122.435557322804 (37.7728063526387, -122.435557322804) 15 5 11 29492 9
180748 10329 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 826 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   6002169.5428 2109164.521 37.7714862234563 -122.435879222083 (37.7714862234563, -122.435879222083) 15 5 11 29492 9
180913 31199 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 31 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM 19   Permit Number 34890 5998530.7281 2106872.07801 37.7649843779477 -122.448300912461 (37.7649843779477, -122.448300912461) 15 5 11 29492 9
183452 31197 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 31 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM 21   Permit Number 34890 5998546.82061 2106872.64956 37.7649868672854 -122.448245293891 (37.7649868672854, -122.448245293891) 15 5 11 29492 9
185590 10422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1407 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   5999387.74957 2108726.34207 37.7701246795762 -122.445470043217 (37.7701246795762, -122.445470043217) 15 5 11 29492 9
187292 245207 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 6 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000894.7456 2109047.992 37.7710937652699 -122.440280443474 (37.7710937652699, -122.440280443474) 15 5 11 29492 9
187450 31198 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 31 Parnassus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 34890 5998547.5134992 2106873.34897224 37.7649888273068 -122.448242947738 (37.7649888273068, -122.448242947738) 15 5 11 29492 9
190128 10319 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 739 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     50 3X3   6002579.70252 2109173.84871 37.7715351260824 -122.434461126791 (37.7715351260824, -122.434461126791) 15 5 11 29492 9
56308 20477 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1203X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5     6 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
68608 20475 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1203X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
91712 100394 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1800X Lincoln Way 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
110591 100393 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1800X Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
134008 100395 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1800X Lincoln Way 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18187 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
137055 20510 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1211X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
178622 100392 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1800X Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769124 5990148.1 2107238.4 37.7655073938756 -122.477320788075 (37.7655073938756, -122.477320788075) 11 8 2 29492 8
3798 262575 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 141 Topaz Way   Front Yard : Yard Tree Private 2       3x3   6001722 2097902 37.7405366227001 -122.436621002014 (37.7405366227001, -122.436621002014) 2 7 5 63 7
8060 220192 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 64 Front Yard : Yard Tree Private 2     12 Width 5ft   6003556.22665 2095685.51446 37.7345547247094 -122.430120878078 (37.7345547247094, -122.430120878078) 2 7 5 63 7
26266 9406 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 479 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6001730.26656 2097665.12438 37.7398866873164 -122.436575468878 (37.7398866873164, -122.436575468878) 2 7 5 63 7
26908 203269 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 61 Burnside Ave 2 Sidewalk: Property side : Yard Tree Private 2     7     6001195.67234 2095721.17604 37.7345186646045 -122.438284639447 (37.7345186646045, -122.438284639447) 2 7 5 63 7
35884 220200 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 73 Front Yard : Yard Tree Private 2     8 Width 5ft   6003513.54179 2095663.72893 37.7344924889333 -122.430266900093 (37.7344924889333, -122.430266900093) 2 7 5 63 7
40440 9405 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 473 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6001706.5922 2097649.68492 37.7398429487944 -122.436656219905 (37.7398429487944, -122.436656219905) 2 7 5 63 7
41980 22564 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 225 Topaz Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     75 3X3   6001403.30325 2097649.91071 37.7398263284251 -122.437704879797 (37.7398263284251, -122.437704879797) 2 7 5 63 7
42888 113973 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 11 Hiliritas Ave 1 Front Yard : Yard Tree Private 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
44638 173859 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 118 Saint Mary's Ave 5 Sidewalk: Property side : Yard Tree DPW 1       Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
48311 220282 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2330 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6001621.97887 2096890.1565 37.7377526518579 -122.436894417057 (37.7377526518579, -122.436894417057) 2 7 5 63 7
51177 221409 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 11 Thor Ave 2 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   6002231.18225 2096094.99891 37.735603938579 -122.434731265154 (37.735603938579, -122.434731265154) 2 7 5 63 7
51614 111552 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 900x BOSWORTH ST 30 Front Yard : Yard Tree DPW 1     6     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
52773 220201 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 74 Front Yard : Yard Tree Private 2     7 Width 5ft   6003510.43036 2095660.01539 37.7344821161581 -122.430277392481 (37.7344821161581, -122.430277392481) 2 7 5 63 7
53791 220198 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 70 Front Yard : Yard Tree Private 2     11 Width 5ft   6003524.19467 2095672.022 37.7345158632135 -122.430230661025 (37.7345158632135, -122.430230661025) 2 7 5 63 7
66632 203274 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 7 Sidewalk: Property side : Yard Tree Private 2     3     6001172.3349 2095747.08466 37.7345884762734 -122.438367180125 (37.7345884762734, -122.438367180125) 2 7 5 63 7
75884 221410 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 81 Digby St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6002579.41102 2097685.70424 37.7399914124663 -122.433640955874 (37.7399914124663, -122.433640955874) 2 7 5 63 7
77321 22570 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 285 Topaz Way 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6001210.73338 2097821.1569 37.7402855789128 -122.438382969513 (37.7402855789128, -122.438382969513) 2 7 5 63 7
82805 220262 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 691 29th St 4 Sidewalk: Property side : Yard Tree Private 2     7     6002099.81762 2098825.68061 37.743094297472 -122.435380714155 (37.743094297472, -122.435380714155) 2 7 5 63 7
83243 9391 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 419 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6001359.02907 2097474.01092 37.7393408312224 -122.437845365595 (37.7393408312224, -122.437845365595) 2 7 5 63 7
83981 220193 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 65 Front Yard : Yard Tree Private 2     9 Width 5ft   6003549.85445 2095682.63787 37.7345464653385 -122.430142703749 (37.7345464653385, -122.430142703749) 2 7 5 63 7
85626 9376 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 312 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/03/1992 12:00:00 AM 35 2X2   6001090.99664 2097832.55819 37.7403100728411 -122.438797787215 (37.7403100728411, -122.438797787215) 2 7 5 63 7
93613 203273 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 6 Sidewalk: Property side : Yard Tree Private 2     6     6001158.4895 2095751.00379 37.7345984497666 -122.43841532891 (37.7345984497666, -122.43841532891) 2 7 5 63 7
96982 220196 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 68 Front Yard : Yard Tree Private 2     12 Width 5ft   6003535.06176 2095676.55127 37.7345289150748 -122.430193412914 (37.7345289150748, -122.430193412914) 2 7 5 63 7
100888 221412 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 45 Harry St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 10ft   6003250.45835 2097675.29375 37.7400008805364 -122.431320009807 (37.7400008805364, -122.431320009807) 2 7 5 63 7
107944 9393 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 425 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001396.09892 2097471.96881 37.7393373319396 -122.437717048529 (37.7393373319396, -122.437717048529) 2 7 5 63 7
109892 9404 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 467 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001682.49889 2097629.47548 37.7397860891552 -122.436738078025 (37.7397860891552, -122.436738078025) 2 7 5 63 7
112892 5731 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1703 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005358.59777 2098401.99369 37.7421154825341 -122.424082592458 (37.7421154825341, -122.424082592458) 2 7 5 28859 7
114090 220194 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 66 Front Yard : Yard Tree Private 2     13 Width 5ft   6003545.8031 2095679.42322 37.7345374091774 -122.430156481356 (37.7345374091774, -122.430156481356) 2 7 5 63 7
116104 203271 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 3 Sidewalk: Property side : Yard Tree Private 2     4     6001161.58855 2095756.5528 37.7346138623368 -122.438405011902 (37.7346138623368, -122.438405011902) 2 7 5 63 7
118464 220280 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Bemis St 4 Sidewalk: Property side : Yard Tree Private 2     16     6003925.29799 2097019.8186 37.7382393172918 -122.428939972905 (37.7382393172918, -122.428939972905) 2 7 5 63 7
124545 22569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 279 Topaz Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   6001194.1444948 2097843.4289615 37.7403457891806 -122.43844192243 (37.7403457891806, -122.43844192243) 2 7 5 63 7
134945 220279 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Bemis St 3 Sidewalk: Property side : Yard Tree Private 2     17     6003936.66384 2097030.27651 37.738268675662 -122.42890142079 (37.738268675662, -122.42890142079) 2 7 5 63 7
135808 203276 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 12 Sidewalk: Property side : Yard Tree Private 2     12     6001144.65729 2095723.55376 37.7345222915553 -122.438461185348 (37.7345222915553, -122.438461185348) 9 7 5 63 7
142914 220195 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 67 Front Yard : Yard Tree Private 2     5 Width 5ft   6003539.74229 2095678.61576 37.7345348487982 -122.430177378003 (37.7345348487982, -122.430177378003) 2 7 5 63 7
144421 220199 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 71 Front Yard : Yard Tree Private 2     7 Width 5ft   6003519.67627 2095667.91857 37.7345043401998 -122.430245989975 (37.7345043401998, -122.430245989975) 2 7 5 63 7
156278 173857 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 118 Saint Mary's Ave 3 Sidewalk: Property side : Yard Tree DPW 1       Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
159539 9402 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6001635.08411 2097595.41214 37.7396898644026 -122.43689958007 (37.7396898644026, -122.43689958007) 2 7 5 63 7
162358 203272 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 5 Sidewalk: Property side : Yard Tree Private 2     12     6001156.85271 2095752.02814 37.7346011692919 -122.438421061197 (37.7346011692919, -122.438421061197) 2 7 5 63 7
163650 220197 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 69 Front Yard : Yard Tree Private 2     10 Width 5ft   6003530.33086 2095674.11312 37.7345219525108 -122.43020959532 (37.7345219525108, -122.43020959532) 2 7 5 63 7
170689 9403 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 461 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/1998 12:00:00 AM 6 3x3   6001657.4794 2097610.87801 37.7397336029134 -122.436823253716 (37.7397336029134, -122.436823253716) 2 7 5 63 7
173671 111532 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 900x BOSWORTH ST 10 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
176291 203275 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 8 Sidewalk: Property side : Yard Tree Private 2     14     6001153.45245 2095743.21498 37.7345767769884 -122.438432185797 (37.7345767769884, -122.438432185797) 2 7 5 63 7
179305 111510 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 800x BOSWORTH ST 5 Front Yard : Yard Tree DPW 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
179817 220202 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 San Jose Ave 75 Front Yard : Yard Tree Private 2     7     6003538.0871 2095667.44086 37.7345040713105 -122.430182303581 (37.7345040713105, -122.430182303581) 2 7 5 63 7
180289 173858 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 118 Saint Mary's Ave 4 Sidewalk: Property side : Yard Tree DPW 1       Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
181499 221411 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 28 Harry St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6003284.97413 2097722.5203 37.7401325098148 -122.431204038645 (37.7401325098148, -122.431204038645) 2 7 5 63 7
187412 111556 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 900x BOSWORTH ST 34 Front Yard : Yard Tree DPW 1     6     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
188904 203270 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 52 Burnside Ave 2 Sidewalk: Property side : Yard Tree Private 2     2     6001166.17423 2095753.81627 37.7346066092953 -122.438388961704 (37.7346066092953, -122.438388961704) 2 7 5 63 7
191251 220281 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Bemis St 5 Sidewalk: Property side : Yard Tree Private 2     14     6003914.80845 2097011.80991 37.7382167335113 -122.428975669715 (37.7382167335113, -122.428975669715) 2 7 5 63 7
191369 22565 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 231 Topaz Way 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3X3   6001358.74635 2097645.73608 37.7398123322633 -122.437858639569 (37.7398123322633, -122.437858639569) 2 7 5 63 7
8099 125296 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 510 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6010613.51109 2116010.55836 37.7907598831005 -122.407153607672 (37.7907598831005, -122.407153607672) 5 1 10 28857 6
12857 125310 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013216.03203 2118385.20589 37.7974254053999 -122.398315638071 (37.7974254053999, -122.398315638071) 3 1 10 28860 6
23204 125307 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
23973 125308 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
30100 125319 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013180.28795 2118636.32064 37.7981129155272 -122.398456952143 (37.7981129155272, -122.398456952143) 3 1 10 28860 6
30332 125323 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013152.59529 2118825.24429 37.7986301120473 -122.398566041686 (37.7986301120473, -122.398566041686) 3 1 10 28860 6
43119 125313 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013202.9728 2118462.79402 37.7976377164748 -122.398366273498 (37.7976377164748, -122.398366273498) 3 1 10 28860 6
45455 249872 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Greenwich St 8 Back Yard : Yard Tree Private 2     9 Width 0ft   6011683.12279 2120489.80597 37.8031186185004 -122.403768099014 (37.8031186185004, -122.403768099014) 3 1 10 28860 6
47188 249874 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Greenwich St 10 Back Yard : Yard Tree Private 2     21 Width 0ft   6011664.09828 2120483.35155 37.8030998334423 -122.403833479743 (37.8030998334423, -122.403833479743) 3 1 10 28860 6
62280 125311 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013212.98295 2118400.3892 37.7974669253095 -122.398327254619 (37.7974669253095, -122.398327254619) 3 1 10 28860 6
65092 188710 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 182 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015012.51159 2115904.85579 37.7907148477575 -122.391925766986 (37.7907148477575, -122.391925766986) 6 2 9 28855 6
67884 125304 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
75871 125324 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013147.44886 2118845.30288 37.798684901431 -122.398585258406 (37.798684901431, -122.398585258406) 3 1 10 28860 6
83073 125309 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013218.75969 2118362.24992 37.7973625257102 -122.398304588108 (37.7973625257102, -122.398304588108) 3 1 10 28860 6
88710 188712 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 182 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6015047.01523 2115868.01492 37.7906156066842 -122.39180380811 (37.7906156066842, -122.39180380811) 6 2 9 28855 6
93087 125306 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
101156 125316 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 11 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6013196.92255 2118512.0582 37.797772647146 -122.398390667602 (37.797772647146, -122.398390667602) 3 1 10 28860 6
102493 125321 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013166.77909 2118747.41812 37.7984172101453 -122.398511496916 (37.7984172101453, -122.398511496916) 3 1 10 28860 6

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