trees
3,965 rows where qSpecies_id = 70 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35576 | 109177 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 320 COLON AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 5995887.7 | 2094797.5 | 37.7316791433679 | -122.456569176029 | (37.7316791433679, -122.456569176029) | 9 | 7 | 4 | 59 | 40 | ||||
12083 | 109385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5990496.07684 | 2114830.6827 | 37.7863739000635 | -122.476671958733 | (37.7863739000635, -122.476671958733) | 11 | 6 | 1 | 55 | 33 | |||
6833 | 109426 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Locust St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | 11 | 6 | 1 | 54 | 31 | ||||
117125 | 109522 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2332 ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991405.3 | 2112053 | 37.7787998461051 | -122.473323643711 | (37.7787998461051, -122.473323643711) | 11 | 6 | 2 | 54 | 26 | ||||
140579 | 109579 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 290x ARKANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012903 | 2105890 | 37.7630990003622 | -122.398521567136 | (37.7630990003622, -122.398521567136) | 14 | 3 | 8 | 28856 | 29 | |||
88209 | 110028 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1900 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003453.1 | 2115265.7 | 37.788311370087 | -122.431875050364 | (37.788311370087, -122.431875050364) | 13 | 9 | 1 | 29490 | 27 | |||
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
176081 | 110253 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6000252.5201 | 2113528.9926 | 37.7833608655524 | -122.442823740221 | (37.7833608655524, -122.442823740221) | 15 | 6 | 1 | 29490 | 13 | |||
27962 | 110465 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 9 | 3x3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
83887 | 110557 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987235.91404 | 2111803.79765 | 37.7778732980336 | -122.487728686455 | (37.7778732980336, -122.487728686455) | 11 | 6 | 2 | 55 | 26 | |
28495 | 110830 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 55x HILLWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996252 | 2106562 | 37.7640024435914 | -122.456159994784 | (37.7640024435914, -122.456159994784) | 15 | 5 | 11 | 29492 | 12 | ||||
73770 | 110847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.441103181276 | (37.7945324365719, -122.441103181276) | 13 | 9 | 1 | 57 | 27 | |
57608 | 110848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | 13 | 9 | 1 | 57 | 27 | ||
59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
119861 | 110871 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
152080 | 110880 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
106539 | 110882 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
64261 | 110884 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
153919 | 111044 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1635 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x10 | Permit Number 775721 | 5995557 | 2094802 | 37.7316725070779 | -122.457712790279 | (37.7316725070779, -122.457712790279) | 9 | 7 | 4 | 59 | 40 | |||
30545 | 111071 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1908 15TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5991632 | 2102414 | 37.7523468518329 | -122.471836728689 | (37.7523468518329, -122.471836728689) | 1 | 8 | 4 | 29491 | 12 | ||||
102561 | 111074 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991438 | 2105265 | 37.7601637210649 | -122.472715460505 | (37.7601637210649, -122.472715460505) | 1 | 8 | 4 | 56 | 12 | ||||
166125 | 111075 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X KIRKHAM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991438 | 2105265 | 37.7601637210649 | -122.472715460505 | (37.7601637210649, -122.472715460505) | 1 | 8 | 4 | 56 | 12 | ||||
27997 | 111166 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003221.39002 | 2119816.29205 | 37.8007929869658 | -122.433001973165 | (37.8007929869658, -122.433001973165) | 13 | 9 | 1 | 57 | 17 | |||
24454 | 111167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003205.80331 | 2119813.99508 | 37.8007857959727 | -122.433055745441 | (37.8007857959727, -122.433055745441) | 13 | 9 | 1 | 57 | 17 | |||
34132 | 111168 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003190.19669 | 2119810.74673 | 37.8007759915841 | -122.43310951859 | (37.8007759915841, -122.43310951859) | 13 | 9 | 1 | 57 | 17 | |||
6759 | 111228 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
57849 | 111229 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
171124 | 111239 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 399x LIBERTY ST | 1 | Median : Yard | Tree | DPW 1 | 40 | 3x3 | 6003700 | 2103889 | 37.7570877346209 | -122.430208863755 | (37.7570877346209, -122.430208863755) | 2 | 4 | 5 | 28862 | 3 | |||
115885 | 111243 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 745X SANCHEZ ST | 2 | Median : Yard | Tree | DPW 1 | 18 | 3x3 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | |||
16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
56627 | 111324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6010207.43823 | 2087366.89683 | 37.7120879953496 | -122.406539311355 | (37.7120879953496, -122.406539311355) | 9 | 7 | 8 | 309 | 39 | ||||
140352 | 111337 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.473689301 | (37.7473430166558, -122.473689301) | 1 | 8 | 4 | 29491 | 40 | |
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 | ||||
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 | ||||
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 | ||||
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 | ||||
43856 | 111715 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390x MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
25711 | 111769 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 MONTEREY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996319 | 2094654 | 37.7313098799379 | -122.455067728735 | (37.7313098799379, -122.455067728735) | 9 | 7 | 4 | 28861 | 40 | ||||
194294 | 111846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785307 | 6000128.0406 | 2117924.83666 | 37.7954236080649 | -122.443570269862 | (37.7954236080649, -122.443570269862) | 13 | 9 | 1 | 57 | 17 | |
194303 | 111847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.3505 | 2117932.29224 | 37.7954440397598 | -122.443573193555 | (37.7954440397598, -122.443573193555) | 13 | 9 | 1 | 57 | 17 | ||
194295 | 111848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.46619 | 2117938.95057 | 37.7954623283723 | -122.443573271789 | (37.7954623283723, -122.443573271789) | 13 | 9 | 1 | 57 | 17 | ||
194313 | 111849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.71624 | 2117950.98913 | 37.7954953973371 | -122.443573271798 | (37.7954953973371, -122.443573271798) | 13 | 9 | 1 | 57 | 17 | ||
135905 | 11187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | 1 | 8 | 4 | 59 | 40 | |||
49773 | 111913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6003233.77012 | 2119841.33042 | 37.8008624380147 | -122.432960922718 | (37.8008624380147, -122.432960922718) | 13 | 9 | 1 | 57 | 17 | ||||
46535 | 111998 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1243 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2015 12:00:00 AM | 3 | 4x4 | 5997431 | 2105451 | 37.7610195245131 | -122.452002042614 | (37.7610195245131, -122.452002042614) | 15 | 5 | 11 | 29492 | 12 | ||
68058 | 112042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2418 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 17 | 3x3 | Permit Number 776583 | 6002409.60423 | 2117108.01013 | 37.7933106707057 | -122.435617223266 | (37.7933106707057, -122.435617223266) | 13 | 9 | 1 | 29490 | 27 | |
28555 | 112249 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X EUCALYPTUS DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991186 | 2094598 | 37.730860304248 | -122.472809193365 | (37.730860304248, -122.472809193365) | 9 | 8 | 4 | 64 | 40 | ||||
168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
172737 | 112384 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3080 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x6 | 5999474.64167 | 2116368.74438 | 37.791113704275 | -122.445719170201 | (37.791113704275, -122.445719170201) | 13 | 6 | 1 | 29490 | 27 | |||
179210 | 112417 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 98X BROADMOOR DR | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | |||
56112 | 112489 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | |||
151507 | 112490 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | ||
123098 | 112590 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1899x VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5987396 | 2097538 | 37.7387126443172 | -122.486127408072 | (37.7387126443172, -122.486127408072) | 1 | 8 | 3 | 29491 | 35 | |||
69992 | 112618 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | 13 | 9 | 1 | 29490 | 27 | |
183403 | 112677 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 470 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 4x4 | 6010678 | 2119694 | 37.8008773296715 | -122.40719023879 | (37.8008773296715, -122.40719023879) | 3 | 1 | 10 | 308 | 23 | |||
111417 | 112832 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1068x BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6008436 | 2118271 | 37.7968443988369 | -122.414847760064 | (37.7968443988369, -122.414847760064) | 5 | 1 | 10 | 308 | 21 | |||
168399 | 112949 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
43872 | 112950 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
43226 | 112951 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
70595 | 112952 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
121018 | 112953 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
148727 | 113056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5988176.09683 | 2110229.83232 | 37.7736064228649 | -122.48436083687 | (37.7736064228649, -122.48436083687) | 11 | 6 | 2 | 55 | 26 | |||
43618 | 113057 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988174.67863 | 2110213.36174 | 37.7735611166607 | -122.484364534338 | (37.7735611166607, -122.484364534338) | 11 | 6 | 2 | 55 | 26 | |||
122110 | 113061 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2775 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776016 | 6000301.4 | 2117440.5 | 37.7941036326689 | -122.442935620895 | (37.7941036326689, -122.442935620895) | 13 | 9 | 1 | 57 | 27 | |||
188036 | 113085 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5984727.7654 | 2112562.56652 | 37.7798100456413 | -122.496461123088 | (37.7798100456413, -122.496461123088) | 11 | 6 | 2 | 55 | 26 | |||
152626 | 113086 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5984727.03316 | 2112580.82435 | 37.7798601334655 | -122.496465003816 | (37.7798601334655, -122.496465003816) | 11 | 6 | 2 | 55 | 26 | |||
68783 | 113087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5984726.14635 | 2112591.82566 | 37.7798902879287 | -122.496468883656 | (37.7798902879287, -122.496468883656) | 11 | 6 | 2 | 55 | 26 | |||
40131 | 113088 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5984725.43026 | 2112610.82785 | 37.7799424204954 | -122.496472763467 | (37.7799424204954, -122.496472763467) | 11 | 6 | 2 | 55 | 26 | |||
137077 | 113089 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5984740.35768 | 2112618.32743 | 37.7799638866667 | -122.496421677178 | (37.7799638866667, -122.496421677178) | 11 | 6 | 2 | 55 | 26 | |||
186930 | 113144 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
44421 | 113145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
125350 | 113235 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009409 | 2120545 | 37.8031428642343 | -122.411641692368 | (37.8031428642343, -122.411641692368) | 3 | 1 | 10 | 308 | 23 | ||||
134443 | 113236 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009409 | 2120545 | 37.8031428642343 | -122.411641692368 | (37.8031428642343, -122.411641692368) | 3 | 1 | 10 | 308 | 23 | ||||
172105 | 113265 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 BROADMOOR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991046 | 2092853 | 37.7260608659296 | -122.473165978042 | (37.7260608659296, -122.473165978042) | 9 | 8 | 4 | 64 | 40 | ||||
105200 | 113348 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | 9 | 7 | 6 | 28861 | 5 | |||
132279 | 113531 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 28 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | |||
60364 | 113532 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
101568 | 113533 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
110296 | 113585 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 15x6 | 5998642 | 2106082 | 37.7628213832292 | -122.447859166975 | (37.7628213832292, -122.447859166975) | 15 | 5 | 11 | 29492 | 9 | |||
105829 | 113656 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 600x 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001710 | 2099417 | 37.744695775282 | -122.436770916391 | (37.744695775282, -122.436770916391) | 2 | 7 | 5 | 63 | 22 | ||||
167689 | 113657 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 600x 28TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001710 | 2099417 | 37.744695775282 | -122.436770916391 | (37.744695775282, -122.436770916391) | 2 | 7 | 5 | 63 | 22 | ||||
152707 | 113658 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 600x 28TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001710 | 2099417 | 37.744695775282 | -122.436770916391 | (37.744695775282, -122.436770916391) | 2 | 7 | 5 | 63 | 22 | ||||
120624 | 113660 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Permit Number 776720 | 5999534 | 2116404 | 37.7912138957856 | -122.445516329339 | (37.7912138957856, -122.445516329339) | 13 | 6 | 1 | 29490 | 27 | |||
110004 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
188661 | 113700 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3315 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5985186.78495 | 2113160.2672 | 37.78147803947 | -122.494917278462 | (37.78147803947, -122.494917278462) | 11 | 6 | 2 | 55 | 26 | |||
108084 | 113797 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
153894 | 113798 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
90007 | 113799 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
181281 | 113800 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
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 | ||||
53586 | 113984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 538 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | 5982879.61718 | 2112112.63686 | 37.7784662262945 | -122.502821259971 | (37.7784662262945, -122.502821259971) | 11 | 6 | 2 | 55 | 26 | |||
147326 | 113989 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||||
83951 | 114090 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001183.08872 | 2115909.2328 | 37.7899493996846 | -122.439775055277 | (37.7899493996846, -122.439775055277) | 13 | 6 | 1 | 29490 | 27 | ||||
133684 | 114109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | ||||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
106748 | 114218 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 119 TALBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010311 | 2086793 | 37.7105179840213 | -122.406140963349 | (37.7105179840213, -122.406140963349) | 9 | 7 | 8 | 309 | 39 | ||||
71845 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 443X ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988110 | 2090275 | 37.7188118998372 | -122.483126550771 | (37.7188118998372, -122.483126550771) | 1 | 8 | 4 | 64 | 14 | ||||
146956 | 114420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 227 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000878.35425 | 2121425.6538 | 37.8050786864012 | -122.44122536858 | (37.8050786864012, -122.44122536858) | 13 | 9 | 1 | 57 | 17 |
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) );