trees
3,965 rows where qSpecies_id = 70 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );