trees
3,965 rows where qSpecies_id = 70 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20469 | 114842 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2670 LEAVENWORTH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007398 | 2121652 | 37.8060693936166 | -122.418679378695 | (37.8060693936166, -122.418679378695) | 5 | 1 | 1 | 308 | 23 | ||||
20506 | 250806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 279 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5986182.48717 | 2114056.18318 | 37.7839962033991 | -122.491538643706 | (37.7839962033991, -122.491538643706) | 11 | 6 | 1 | 55 | 33 | |||
20526 | 125225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1606 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6005725.27471 | 2118266.64899 | 37.7966797667037 | -122.424227203437 | (37.7966797667037, -122.424227203437) | 13 | 9 | 1 | 28858 | 17 | |||
20738 | 18077 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.444405127725 | (37.7866642791044, -122.444405127725) | 15 | 6 | 1 | 29490 | 31 | |||
21431 | 124977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999590.28353 | 2121474.47758 | 37.8051392872022 | -122.445686385433 | (37.8051392872022, -122.445686385433) | 13 | 9 | 1 | 57 | 17 | |||
21465 | 104273 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | 11 | 6 | 1 | 54 | 31 | ||||
21969 | 125176 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2519 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001330.49234 | 2117251.0663 | 37.7936421149431 | -122.439361275412 | (37.7936421149431, -122.439361275412) | 13 | 9 | 1 | 29490 | 27 | |||
22096 | 124305 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 169 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5996209.82243 | 2113206.80783 | 37.7822449293206 | -122.456786484191 | (37.7822449293206, -122.456786484191) | 11 | 6 | 1 | 54 | 31 | |||
22235 | 125135 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2655 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000111.60795 | 2117732.00363 | 37.7948932023106 | -122.44361327005 | (37.7948932023106, -122.44361327005) | 13 | 9 | 1 | 57 | 27 | |||
22295 | 99908 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
22416 | 38478 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 21 | Permit Number 40477 | 5987978.37889 | 2115306.2666 | 37.7875333623487 | -122.485417356275 | (37.7875333623487, -122.485417356275) | 11 | 6 | 1 | 55 | 33 | ||
22458 | 125100 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3298 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999060.86441 | 2115983.22168 | 37.7900315275801 | -122.4471230632 | (37.7900315275801, -122.4471230632) | 13 | 6 | 1 | 29490 | 31 | |||
22904 | 95659 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 499@Cervantes Marina Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000674 | 2121505 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | 13 | 9 | 1 | 57 | 17 | |||
22959 | 124866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001683.07545 | 2121358.73098 | 37.8049407402829 | -122.438435744435 | (37.8049407402829, -122.438435744435) | 13 | 9 | 1 | 57 | 17 | |||
22983 | 125092 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2145 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5999827.24336 | 2116322.83843 | 37.7910077839349 | -122.444495883591 | (37.7910077839349, -122.444495883591) | 13 | 6 | 1 | 29490 | 27 | |||
23415 | 125278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | 6006716.82854 | 2119779.13638 | 37.8008886127761 | -122.420903634692 | (37.8008886127761, -122.420903634692) | 5 | 1 | 1 | 28858 | 32 | ||||
23492 | 99901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
23699 | 124946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3636 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5997401.33489 | 2115425.81933 | 37.7884060911058 | -122.452824617461 | (37.7884060911058, -122.452824617461) | 11 | 6 | 1 | 54 | 31 | |||
23702 | 124834 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001777.19779 | 2121403.36061 | 37.8050686346845 | -122.438113223249 | (37.8050686346845, -122.438113223249) | 13 | 9 | 1 | 57 | 17 | |||
23718 | 124908 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3837 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996520.53305 | 2115587.04423 | 37.7887982593656 | -122.455883692899 | (37.7887982593656, -122.455883692899) | 11 | 6 | 1 | 54 | 31 | |||
24026 | 125179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Broadway | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6002026.35862 | 2117343.77621 | 37.793936248109 | -122.436960163797 | (37.793936248109, -122.436960163797) | 13 | 9 | 1 | 29490 | 27 | |||
24289 | 30297 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | 13 | 9 | 1 | 29490 | 27 | ||
24362 | 125167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2647 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001006.56911 | 2117558.99371 | 37.7944691638671 | -122.440504169841 | (37.7944691638671, -122.440504169841) | 13 | 9 | 1 | 57 | 27 | |||
24398 | 23561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | 5 | 9 | 1 | 28858 | 32 | |||
24417 | 125274 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007531.27909 | 2121531.59091 | 37.8057462837276 | -122.418209601296 | (37.8057462837276, -122.418209601296) | 5 | 1 | 1 | 308 | 32 | |||
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 | |||
24486 | 124784 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3055 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000935.85485 | 2118878.39953 | 37.7980878784058 | -122.440843541621 | (37.7980878784058, -122.440843541621) | 13 | 9 | 1 | 57 | 17 | |||
24934 | 125171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2711 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000618.48773 | 2117603.50665 | 37.7945692791008 | -122.441850171667 | (37.7945692791008, -122.441850171667) | 13 | 9 | 1 | 57 | 27 | |||
25250 | 137823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2188 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6003472.4181 | 2115248.3783 | 37.7882649041847 | -122.431806975674 | (37.7882649041847, -122.431806975674) | 13 | 9 | 1 | 29490 | 27 | |||
25306 | 116489 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2149 LYON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999319 | 2116238 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | 13 | 6 | 1 | 29490 | 31 | ||||
25341 | 138422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1739 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002029.7373 | 2114496.7631 | 37.786119275153 | -122.436744579025 | (37.786119275153, -122.436744579025) | 13 | 6 | 1 | 29490 | 27 | |||
25791 | 124961 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3146 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999036.86973 | 2119627.81105 | 37.800037228206 | -122.447468527859 | (37.800037228206, -122.447468527859) | 13 | 9 | 1 | 57 | 17 | |||
26046 | 124954 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5996644.15697 | 2115487.85447 | 37.7885330052342 | -122.455448802332 | (37.7885330052342, -122.455448802332) | 11 | 6 | 1 | 54 | 31 | |||
26093 | 124678 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3855 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995722.23749 | 2115802.66967 | 37.7893444597434 | -122.458661280755 | (37.7893444597434, -122.458661280755) | 11 | 6 | 1 | 54 | 31 | |||
26287 | 119617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3536 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2016 12:00:00 AM | 3 | 3x10 | 5999214.99092 | 2121000.37655 | 37.8038161003064 | -122.446950987796 | (37.8038161003064, -122.446950987796) | 13 | 9 | 1 | 57 | 17 | ||
26390 | 97260 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
26482 | 125136 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2655 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000114.20701 | 2117720.96546 | 37.7948630426412 | -122.443603483632 | (37.7948630426412, -122.443603483632) | 13 | 9 | 1 | 57 | 27 | |||
26485 | 124878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3638 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997336.3936 | 2115745.57778 | 37.7892803409597 | -122.453072394193 | (37.7892803409597, -122.453072394193) | 11 | 6 | 1 | 54 | 31 | |||
26679 | 124855 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001720.89506 | 2121441.74849 | 37.805170835422 | -122.438310816889 | (37.805170835422, -122.438310816889) | 13 | 9 | 1 | 57 | 17 | |||
27095 | 104422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2362 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 5999509.01294 | 2120174.0716 | 37.8015640827681 | -122.445874046945 | (37.8015640827681, -122.445874046945) | 13 | 9 | 1 | 57 | 17 | |||
27128 | 124972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2957 Divisadero St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6000499.51434 | 2118479.2792 | 37.7969671396726 | -122.442324734908 | (37.7969671396726, -122.442324734908) | 13 | 9 | 1 | 57 | 17 | |||
27228 | 124845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001817.73408 | 2121573.58628 | 37.8055383343822 | -122.437985143623 | (37.8055383343822, -122.437985143623) | 13 | 9 | 1 | 57 | 17 | |||
27408 | 124833 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001778.79024 | 2121390.34711 | 37.8050329936375 | -122.438106779619 | (37.8050329936375, -122.438106779619) | 13 | 9 | 1 | 57 | 17 | |||
27527 | 51878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2251 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 14 | Permit Number 48095 | 6002306.75433 | 2116015.71739 | 37.790305674209 | -122.435894898847 | (37.790305674209, -122.435894898847) | 13 | 9 | 1 | 29490 | 27 | ||
27561 | 116787 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Locust St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 5997585.95933 | 2115721.09611 | 37.7892274203572 | -122.452207163638 | (37.7892274203572, -122.452207163638) | 11 | 6 | 1 | 54 | 31 | |||
27576 | 23937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2186X PINE ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003453 | 2115265 | 37.7883094423957 | -122.431875346345 | (37.7883094423957, -122.431875346345) | 13 | 9 | 1 | 29490 | 27 | |||
27780 | 250630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5987115.47488 | 2114730.85404 | 37.7859031348758 | -122.488360488171 | (37.7859031348758, -122.488360488171) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
28116 | 125029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002224.17314 | 2121593.74459 | 37.8056167885575 | -122.436580050938 | (37.8056167885575, -122.436580050938) | 13 | 9 | 1 | 57 | 17 | |||
28808 | 125112 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3140 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5999143.47803 | 2116326.58568 | 37.7909790343956 | -122.446861945921 | (37.7909790343956, -122.446861945921) | 13 | 6 | 1 | 29490 | 31 | |||
28996 | 125108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3157 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999114.64614 | 2116271.09078 | 37.7908250128999 | -122.446957707555 | (37.7908250128999, -122.446957707555) | 13 | 6 | 1 | 29490 | 31 | |||
29051 | 44174 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
29295 | 125189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6002270.60471 | 2117783.5161 | 37.7951575391526 | -122.436146532744 | (37.7951575391526, -122.436146532744) | 13 | 9 | 1 | 57 | 17 | |||
29455 | 23464 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2305 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005842.188 | 2118344.10635 | 37.7968990457145 | -122.423828167031 | (37.7968990457145, -122.423828167031) | 13 | 9 | 1 | 57 | 17 | |||
29539 | 138615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2926 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999888.2411 | 2114747.6353 | 37.7866861681099 | -122.444171595218 | (37.7866861681099, -122.444171595218) | 15 | 6 | 1 | 29490 | 31 | |||
29568 | 125050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005509.11521 | 2120789.62029 | 37.8035949938703 | -122.425154777693 | (37.8035949938703, -122.425154777693) | 13 | 9 | 1 | 28858 | 17 | |||
29784 | 12809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | 11 | 6 | 1 | 55 | 33 | |||
30177 | 125126 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2921 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999560.3078 | 2117361.82624 | 37.7938453356549 | -122.445494209301 | (37.7938453356549, -122.445494209301) | 13 | 9 | 1 | 57 | 27 | |||
30506 | 124772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2630 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999644.99215 | 2117912.00689 | 37.7953608200945 | -122.445240769548 | (37.7953608200945, -122.445240769548) | 13 | 9 | 1 | 57 | 17 | |||
30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
30901 | 103929 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5994248.3 | 2114379.9 | 37.7853530981444 | -122.463657591004 | (37.7853530981444, -122.463657591004) | 11 | 6 | 1 | 54 | 11 | ||||
30945 | 125193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003491.11176 | 2118014.84394 | 37.7958619718008 | -122.431939917892 | (37.7958619718008, -122.431939917892) | 13 | 9 | 1 | 57 | 17 | |||
31010 | 249714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 3 | Back Yard : Yard | Tree | Private 2 | 20 | 5999388.9274 | 2116973.59042 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | 13 | 9 | 1 | 29490 | 27 | ||||
31521 | 124836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 66 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001774.9431 | 2121429.36866 | 37.8051399176477 | -122.438122890072 | (37.8051399176477, -122.438122890072) | 13 | 9 | 1 | 57 | 17 | |||
31574 | 125219 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2269 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 4ft | 6003923.5815 | 2115960.33762 | 37.7902453288032 | -122.430296840347 | (37.7902453288032, -122.430296840347) | 13 | 9 | 1 | 29490 | 27 | |||
31693 | 143121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1869 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003430.714 | 2119601.3681 | 37.8002147325944 | -122.432262267287 | (37.8002147325944, -122.432262267287) | 13 | 9 | 1 | 57 | 17 | |||
31878 | 125201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2201 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003579.67641 | 2116899.4218 | 37.7928043289977 | -122.431553796666 | (37.7928043289977, -122.431553796666) | 13 | 9 | 1 | 29490 | 27 | |||
32061 | 49500 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
32384 | 46269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2373 REVISED Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 44553 | 6003358.75375 | 2116535.00791 | 37.7917912175406 | -122.432292160763 | (37.7917912175406, -122.432292160763) | 13 | 9 | 1 | 29490 | 27 | |||
32479 | 125072 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2559 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002527.91845 | 2116093.19627 | 37.7905309723786 | -122.435135231625 | (37.7905309723786, -122.435135231625) | 13 | 9 | 1 | 29490 | 27 | |||
32544 | 105274 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
32695 | 38515 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
32867 | 124933 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 313 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5996636.27305 | 2115218.34892 | 37.78779256281 | -122.45545659314 | (37.78779256281, -122.45545659314) | 11 | 6 | 1 | 54 | 31 | |||
32977 | 125002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 69 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001637.34931 | 2120884.52761 | 37.8036361027929 | -122.438559986648 | (37.8036361027929, -122.438559986648) | 13 | 9 | 1 | 57 | 17 | |||
32979 | 125014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999712.95085 | 2121535.70639 | 37.8053144077071 | -122.445266286916 | (37.8053144077071, -122.445266286916) | 13 | 9 | 1 | 57 | 17 | |||
33026 | 125054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1733 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002453.36276 | 2120887.52869 | 37.8036907276167 | -122.435736350154 | (37.8036907276167, -122.435736350154) | 13 | 9 | 1 | 57 | 17 | |||
33055 | 250847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5986528.24832 | 2114250.81305 | 37.7845508009207 | -122.490356775353 | (37.7845508009207, -122.490356775353) | 11 | 6 | 1 | 55 | 33 | |||
33120 | 12727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | |||
33190 | 7922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1295X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x6 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | 13 | 9 | 1 | 28858 | 41 | |||
33207 | 124998 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001147.91549 | 2121233.53954 | 37.8045665431681 | -122.440278736772 | (37.8045665431681, -122.440278736772) | 13 | 9 | 1 | 57 | 17 | |||
33344 | 125185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2757 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002077.54743 | 2117675.01873 | 37.7948486633864 | -122.436806769111 | (37.7948486633864, -122.436806769111) | 13 | 9 | 1 | 57 | 27 | |||
33368 | 103490 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001053.62878 | 2117568.22705 | 37.7944971957398 | -122.440342000495 | (37.7944971957398, -122.440342000495) | 13 | 9 | 1 | 57 | 27 | |||
33407 | 125055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1725 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002469.3064 | 2120890.0959 | 37.8036986821095 | -122.435681360206 | (37.8036986821095, -122.435681360206) | 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 | |||
34135 | 106832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 138 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 774880 | 5997571.74884 | 2115814.60363 | 37.7894833530272 | -122.452263079899 | (37.7894833530272, -122.452263079899) | 11 | 6 | 1 | 54 | 31 | |||
34145 | 23560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2909 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005511.81289 | 2120357.28421 | 37.8024080624664 | -122.425114661564 | (37.8024080624664, -122.425114661564) | 13 | 9 | 1 | 28858 | 17 | |||
34218 | 32423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.60357 | 37.7961002417749 | -122.442810555866 | (37.7961002417749, -122.442810555866) | 13 | 9 | 1 | 57 | 17 | ||
34522 | 124953 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5996648.39198 | 2115469.91468 | 37.7884839903839 | -122.45543285284 | (37.7884839903839, -122.45543285284) | 11 | 6 | 1 | 54 | 31 | |||
35099 | 124895 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3757 Washington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5996835.55355 | 2115629.96293 | 37.7889341775065 | -122.454796874798 | (37.7889341775065, -122.454796874798) | 11 | 6 | 1 | 54 | 31 | |||
35200 | 250846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 4ft | 5986528.43338 | 2114238.12689 | 37.7845159791832 | -122.490355201546 | (37.7845159791832, -122.490355201546) | 11 | 6 | 1 | 55 | 33 | |||
35437 | 115478 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54X Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5998000.5009 | 2116231.73295 | 37.7906532316094 | -122.450809740384 | (37.7906532316094, -122.450809740384) | 13 | 6 | 1 | 54 | 31 | |||
35606 | 124793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2661 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6000281.59874 | 2118154.61893 | 37.7960632859464 | -122.443055444859 | (37.7960632859464, -122.443055444859) | 13 | 9 | 1 | 57 | 17 | |||
35847 | 249706 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 5999689.68932 | 2117193.09573 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | 13 | 9 | 1 | 57 | 27 | ||||
36070 | 125169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2647 Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6001017.71367 | 2117559.63744 | 37.7944715659634 | -122.440465654581 | (37.7944715659634, -122.440465654581) | 13 | 9 | 1 | 57 | 27 | |||
36081 | 124796 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000021.82645 | 2118165.23175 | 37.7960776112345 | -122.443955068183 | (37.7960776112345, -122.443955068183) | 13 | 9 | 1 | 57 | 17 | |||
36128 | 124795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2643 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000315.12191 | 2118159.5515 | 37.7960787407936 | -122.442939802828 | (37.7960787407936, -122.442939802828) | 13 | 9 | 1 | 57 | 17 | |||
36288 | 125048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005420.68062 | 2121375.93261 | 37.8051998601557 | -122.425502561696 | (37.8051998601557, -122.425502561696) | 13 | 1 | 1 | 28858 | 17 | |||
36351 | 125212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2010 Washington St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6004876.33851 | 2116792.20983 | 37.7925833601806 | -122.427059645199 | (37.7925833601806, -122.427059645199) | 13 | 9 | 1 | 28858 | 27 | |||
36619 | 43982 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2000 12:00:00 AM | 11 | Permit Number 43545 | 5997823.8786 | 2113381.5676 | 37.7828173196945 | -122.451215205093 | (37.7828173196945, -122.451215205093) | 15 | 6 | 1 | 54 | 31 |
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) );