trees
3,965 rows where qSpecies_id = 70 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
717 | 124802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999891.10935 | 2118493.83248 | 37.7969724043147 | -122.444431001117 | (37.7969724043147, -122.444431001117) | 13 | 9 | 1 | 57 | 17 | |||
1104 | 125224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2285 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6003837.08538 | 2116275.37223 | 37.7911054341186 | -122.430618599767 | (37.7911054341186, -122.430618599767) | 13 | 9 | 1 | 29490 | 27 | |||
1494 | 21556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1409 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005783.75363 | 2114822.50195 | 37.7872263038018 | -122.423779835692 | (37.7872263038018, -122.423779835692) | 13 | 9 | 1 | 28858 | 41 | |||
1656 | 125137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2645 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000115.81749 | 2117703.18818 | 37.7948143227728 | -122.443596633488 | (37.7948143227728, -122.443596633488) | 13 | 9 | 1 | 57 | 27 | |||
1696 | 12442 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004358.0388014 | 2115316.8218262 | 37.788502995764 | -122.428747755973 | (37.788502995764, -122.428747755973) | 13 | 9 | 11 | 29490 | 27 | |||
2052 | 13108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.8008727786968 | -122.427090735634 | (37.8008727786968, -122.427090735634) | 13 | 9 | 1 | 57 | 17 | |||
2878 | 124826 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001759.52883 | 2120853.50314 | 37.8035578671766 | -122.438134955373 | (37.8035578671766, -122.438134955373) | 13 | 9 | 1 | 57 | 17 | |||
3691 | 121048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006192.78395747 | 2119877.54417008 | 37.8011292630692 | -122.422724050002 | (37.8011292630692, -122.422724050002) | 13 | 9 | 1 | 28858 | 32 | ||||
3857 | 104292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | 13 | 9 | 1 | 57 | 17 | |||||
4794 | 23518 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005659.14507 | 2119690.7477 | 37.8005862454143 | -122.424557378741 | (37.8005862454143, -122.424557378741) | 13 | 9 | 1 | 57 | 17 | |||
5261 | 262386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6005187.2243 | 2109578.99326 | 37.7727952246844 | -122.425470396534 | (37.7727952246844, -122.425470396534) | 7 | 9 | 11 | 28852 | 10 | ||||
5752 | 125230 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Octavia St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 6004620.5622 | 2117170.01804 | 37.7936062589738 | -122.427971574849 | (37.7936062589738, -122.427971574849) | 13 | 9 | 1 | 28858 | 27 | |||
6497 | 125008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3790 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002036.5769 | 2121760.24067 | 37.8060632803659 | -122.437241182151 | (37.8060632803659, -122.437241182151) | 13 | 9 | 1 | 57 | 17 | |||
6575 | 125025 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1442 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002295.97534 | 2121603.81012 | 37.8056485058273 | -122.436332290414 | (37.8056485058273, -122.436332290414) | 13 | 9 | 1 | 57 | 17 | |||
7197 | 116162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2569 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000631 | 2118874 | 37.7980584318084 | -122.441898109379 | (37.7980584318084, -122.441898109379) | 13 | 9 | 1 | 57 | 17 | ||||
7388 | 29904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||||
7614 | 6251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | 7 | 9 | 11 | 29490 | 41 | |||
7808 | 124777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000983.1166 | 2118879.20139 | 37.7980927716149 | -122.440680060149 | (37.7980927716149, -122.440680060149) | 13 | 9 | 1 | 57 | 17 | |||
7932 | 18681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3X3 | 5999165.53622 | 2119642.20723 | 37.8000841081609 | -122.447024330929 | (37.8000841081609, -122.447024330929) | 13 | 9 | 1 | 57 | 17 | |||
8459 | 142451 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 612 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004562.1168 | 2110606.9092 | 37.7755822921182 | -122.427705966737 | (37.7755822921182, -122.427705966737) | 7 | 9 | 11 | 28852 | 10 | |||
8752 | 7916 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.7857108313539 | -122.423161466763 | (37.7857108313539, -122.423161466763) | 13 | 9 | 1 | 28858 | 41 | |||
8928 | 116888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 799X Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999171.6155 | 2121461.35655 | 37.8050793482968 | -122.447134285827 | (37.8050793482968, -122.447134285827) | 13 | 9 | 1 | 57 | 17 | |||
8988 | 125125 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2921 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | Permit Number 784827 | 5999533.93344 | 2117358.43143 | 37.7938345087112 | -122.445585222496 | (37.7938345087112, -122.445585222496) | 13 | 9 | 1 | 57 | 27 | ||
9096 | 249565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | |||
10310 | 23457 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6005866.88323 | 2118164.3475 | 37.7964068674367 | -122.423729927819 | (37.7964068674367, -122.423729927819) | 13 | 9 | 1 | 28858 | 27 | |||
10569 | 50188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3134 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | 12 | Permit Number 46895 | 5999411.86905 | 2119620.94961 | 37.8000398110413 | -122.446170397871 | (37.8000398110413, -122.446170397871) | 13 | 9 | 1 | 57 | 17 | ||
10690 | 124815 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3766 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999638.74415 | 2121468.4947 | 37.8051256264981 | -122.44551825176 | (37.8051256264981, -122.44551825176) | 13 | 9 | 1 | 57 | 17 | |||
11522 | 125190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003477.09721 | 2118091.6097 | 37.7960719563118 | -122.431993895221 | (37.7960719563118, -122.431993895221) | 13 | 9 | 1 | 57 | 17 | |||
11537 | 125159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2695 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000739.26248 | 2117523.11724 | 37.7943554320128 | -122.441426505548 | (37.7943554320128, -122.441426505548) | 13 | 9 | 1 | 57 | 27 | |||
11631 | 125182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2409 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002021.80255 | 2117699.99218 | 37.7949140656765 | -122.437001442682 | (37.7949140656765, -122.437001442682) | 13 | 9 | 1 | 57 | 27 | |||
12317 | 124989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2330 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999632.98493 | 2120193.24081 | 37.8016237941718 | -122.445446428326 | (37.8016237941718, -122.445446428326) | 13 | 9 | 1 | 57 | 17 | |||
12430 | 220123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Haight St | 1 | : | Tree | Private 2 | 26 | Width 4ft | 6003680.56736 | 2109328.54381 | 37.772022309504 | -122.430664217001 | (37.772022309504, -122.430664217001) | 15 | 9 | 11 | 29492 | 10 | |||
12665 | 125122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2950 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 5999479.00894 | 2117042.99572 | 37.7929652698817 | -122.445752570148 | (37.7929652698817, -122.445752570148) | 13 | 9 | 1 | 57 | 27 | |||
14016 | 249712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 1 | Back Yard : Yard | Tree | Private 2 | 21 | 5999372.04623 | 2116967.23886 | 37.7927511539072 | -122.44611721374 | (37.7927511539072, -122.44611721374) | 13 | 9 | 1 | 29490 | 27 | ||||
14158 | 99903 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 5 | 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 | ||||
14540 | 125028 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1454 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002238.36811 | 2121596.51915 | 37.8056252134011 | -122.436531126017 | (37.8056252134011, -122.436531126017) | 13 | 9 | 1 | 57 | 17 | |||
14952 | 124990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2354 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999518.65691 | 2120176.7884 | 37.8015720930274 | -122.44584087006 | (37.8015720930274, -122.44584087006) | 13 | 9 | 1 | 57 | 17 | |||
15097 | 125078 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2402 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002281.85498 | 2116525.22121 | 37.7917032260602 | -122.4360175223 | (37.7917032260602, -122.4360175223) | 13 | 9 | 1 | 29490 | 27 | |||
15739 | 23509 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2620 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005816.48256 | 2119432.12103 | 37.7998850066476 | -122.423994524448 | (37.7998850066476, -122.423994524448) | 13 | 9 | 1 | 28858 | 32 | |||
16669 | 66481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1991 12:00:00 AM | 17 | Permit Number 29638 | 6002649.70784 | 2117838.97461 | 37.7953313448215 | -122.434838746712 | (37.7953313448215, -122.434838746712) | 13 | 9 | 1 | 57 | 17 | ||
16921 | 125192 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003488.35981 | 2118026.85016 | 37.7958947817809 | -122.431950297892 | (37.7958947817809, -122.431950297892) | 13 | 9 | 1 | 57 | 17 | |||
17126 | 45658 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1330 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | |||
17786 | 258887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | ||||
17877 | 101023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999465 | 2119192 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | 13 | 9 | 1 | 57 | 17 | ||||
18286 | 124768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3030 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5999457.57205 | 2119269.23943 | 37.799076718977 | -122.445986937943 | (37.799076718977, -122.445986937943) | 13 | 9 | 1 | 57 | 17 | |||
19219 | 18871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003913.28197 | 2115924.59754 | 37.7901466122144 | -122.430329924961 | (37.7901466122144, -122.430329924961) | 13 | 9 | 1 | 29490 | 27 | |||
19351 | 125032 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1490 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002182.39111 | 2121589.19488 | 37.8056019218535 | -122.436724317478 | (37.8056019218535, -122.436724317478) | 13 | 9 | 1 | 57 | 17 | |||
19803 | 7872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006017.92474 | 2113680.12204 | 37.7841028269903 | -122.422888431641 | (37.7841028269903, -122.422888431641) | 7 | 9 | 11 | 28858 | 41 | |||
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 | |||
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 | |||
21553 | 6948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 583 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004650.95912 | 2110501.84562 | 37.7752988382968 | -122.427391153284 | (37.7752988382968, -122.427391153284) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
22272 | 5913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004490.90647 | 2112892.55275 | 37.7818540774754 | -122.428115221825 | (37.7818540774754, -122.428115221825) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||||
22371 | 17865 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2016 12:00:00 AM | 18 | 4X4 | 6003789.962559 | 2115237.891116 | 37.7882541043801 | -122.430707576303 | (37.7882541043801, -122.430707576303) | 13 | 9 | 11 | 29490 | 27 | ||
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 | |||
23390 | 22618 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | |||
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 | |||
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 | |||
24792 | 137815 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1916 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004608.8402 | 2115406.0046 | 37.7887620605829 | -122.427886379086 | (37.7887620605829, -122.427886379086) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
25412 | 23448 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | 13 | 9 | 10 | 28858 | 32 | |||
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 | |||
26061 | 125266 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2238 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005980.47493 | 2118083.2287 | 37.7961905472166 | -122.423331106373 | (37.7961905472166, -122.423331106373) | 13 | 9 | 10 | 28858 | 32 | |||
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 | |||
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 | |||
27206 | 66038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 616 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 14 | Permit Number 29076 | 6004557.2069 | 2110631.459 | 37.7756494221228 | -122.427724700841 | (37.7756494221228, -122.427724700841) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
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 | |||
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 | |||
28598 | 249574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6006046.96797 | 2113547.66581 | 37.7837407734727 | -122.422778535918 | (37.7837407734727, -122.422778535918) | 7 | 9 | 11 | 28858 | 41 | |||
29192 | 17858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003631.9915 | 2115212.7417 | 37.7881760994608 | -122.431252333718 | (37.7881760994608, -122.431252333718) | 13 | 9 | 11 | 29490 | 27 | |||
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 | |||
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 | |||
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 | |
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 | |||
31628 | 140221 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 760 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6003775.9657 | 2110429.665 | 37.7750511222096 | -122.430412804763 | (37.7750511222096, -122.430412804763) | 7 | 9 | 11 | 29492 | 10 |
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) );