trees
3,965 rows where qSpecies_id = 70 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
768 | 20385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
876 | 5429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 465 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6004961.54975 | 2105631.51156 | 37.7619436334085 | -122.42596997713 | (37.7619436334085, -122.42596997713) | 8 | 4 | 5 | 28859 | 19 | |||
1343 | 23590 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |||
1522 | 187744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 2 | Median : Yard | Tree | DPW 1 | 3 | 6016140.58365 | 2096258.22676 | 37.7368319916033 | -122.386652075929 | (37.7368319916033, -122.386652075929) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
1923 | 20027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
2304 | 19829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
2487 | 6047 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1230X Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001382.35259 | 2112608.72867 | 37.7808984019389 | -122.438849005281 | (37.7808984019389, -122.438849005281) | 15 | 5 | 11 | 29490 | 41 | |||
2541 | 8258 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6015754 | 2097743 | 37.740887466773 | -122.388092261865 | (37.740887466773, -122.388092261865) | 10 | 3 | 8 | 58 | 1 | |||
2829 | 264759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
3125 | 20020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
3152 | 10368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000449.8535 | 2108924.1608 | 37.7707284158065 | -122.441810447284 | (37.7707284158065, -122.441810447284) | 15 | 5 | 11 | 29492 | 9 | |||
3286 | 264753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 176 Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
4129 | 187747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 5 | Median : Yard | Tree | DPW 1 | 08/26/2020 12:00:00 AM | 3 | 6016140.5122 | 2096271.0286 | 37.7368671389145 | -122.386653215398 | (37.7368671389145, -122.386653215398) | 10 | 3 | 8 | 58 | 1 | |||
4276 | 186874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 23 | Median : Yard | Tree | DPW 1 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | 1 | 8 | 3 | 29491 | 35 | |||
4411 | 20021 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
4760 | 20025 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
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 | |||
4954 | 24213 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
5095 | 200603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 52 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.385609317623 | (37.733790555057, -122.385609317623) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
5814 | 8259 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1555 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6015926.8812 | 2097574.6055 | 37.7404346667176 | -122.387482752719 | (37.7404346667176, -122.387482752719) | 10 | 3 | 8 | 58 | 1 | |||
6048 | 19828 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
6378 | 6740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
7821 | 19789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY19 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
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 | |||
7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
8386 | 20019 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
8416 | 20389 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
9481 | 10434 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259864 | (37.7700106766776, -122.44636259864) | 15 | 5 | 11 | 29492 | 9 | |||
9682 | 19808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
9883 | 262003 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5984810 | 2104956 | 37.7589293895364 | -122.495615433308 | (37.7589293895364, -122.495615433308) | 1 | 8 | 3 | 56 | 35 | ||||
10167 | 16529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
10444 | 20024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
11658 | 6629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575 | (37.7408992492988, -122.38498513575) | 10 | 3 | 8 | 58 | 1 | ||
11795 | 20386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12119 | 20453 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12630 | 24191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
13033 | 20683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1505X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984801 | 2104643 | 37.7580694516324 | -122.495623472482 | (37.7580694516324, -122.495623472482) | 1 | 8 | 3 | 56 | 35 | |||
13471 | 20029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
13976 | 1368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.7461879050589 | -122.445863385507 | (37.7461879050589, -122.445863385507) | 2 | 7 | 5 | 63 | 22 | ||
14165 | 22132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6015998.68116 | 2098857.5612 | 37.743961376797 | -122.387323966992 | (37.743961376797, -122.387323966992) | 10 | 3 | 8 | 58 | 1 | |||
14483 | 22142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
15187 | 6707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017570.5024 | 2096779.609 | 37.7383426628708 | -122.381744418894 | (37.7383426628708, -122.381744418894) | 10 | 3 | 8 | 58 | 1 | |||
15463 | 20023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
15635 | 5803 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 218X Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2020 12:00:00 AM | 3 | 3X4 | 6016111.4085 | 2096200.72161 | 37.7366724788363 | -122.386748939219 | (37.7366724788363, -122.386748939219) | 10 | 3 | 8 | 58 | 1 | ||
15711 | 20018 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
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 | |||
16079 | 20022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
16737 | 5399 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6004915.02967 | 2106451.33313 | 37.764192039253 | -122.426189239948 | (37.764192039253, -122.426189239948) | 8 | 4 | 5 | 28859 | 19 | |||
16854 | 14553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | 15 | 5 | 11 | 29492 | 16 | |||
17638 | 20026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
18268 | 262388 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6016246.49948 | 2097351.8889 | 37.739840829559 | -122.38636210374 | (37.739840829559, -122.38636210374) | 10 | 3 | 8 | 58 | 1 | |||||
18796 | 19809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY23 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18941 | 264761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 240 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007356 | 2087104 | 37.7112061971181 | -122.416376123926 | (37.7112061971181, -122.416376123926) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |||
19569 | 19966 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
20079 | 12739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5990329.44242 | 2114713.68905 | 37.7860430016299 | -122.477239912272 | (37.7860430016299, -122.477239912272) | 11 | 6 | 2 | 55 | 26 | |||
20406 | 188744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6014566.93251 | 2086961.44697 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
20826 | 203829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200x Terrace Dr | 41 | Median : Yard | Tree | DPW 1 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |||
21595 | 26448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1817 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001669.86946 | 2112366.99146 | 37.7802510063553 | -122.437837026039 | (37.7802510063553, -122.437837026039) | 15 | 5 | 11 | 29490 | 41 | |||
22058 | 5492 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 719 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 8 | 6005040.75383 | 2104151.1903 | 37.7578834965409 | -122.425590680889 | (37.7578834965409, -122.425590680889) | 2 | 4 | 5 | 28859 | 19 | |||
22211 | 8278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6015786.61194 | 2097763.1602 | 37.7409446293456 | -122.387980907347 | (37.7409446293456, -122.387980907347) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | ||
22704 | 188665 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 37 | 6011669.71313 | 2097723.45025 | 37.7406066539877 | -122.402212916691 | (37.7406066539877, -122.402212916691) | 10 | 3 | 8 | 58 | 1 | ||||
23506 | 247295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1416 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 5999264.8582 | 2108759.0964 | 37.7702075983445 | -122.445897477638 | (37.7702075983445, -122.445897477638) | 15 | 5 | 11 | 29492 | 9 | |||
23652 | 6630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6016668.82436 | 2097716.7125 | 37.7408659294107 | -122.384927277883 | (37.7408659294107, -122.384927277883) | 10 | 3 | 8 | 58 | 1 | |||
24488 | 220241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10x Benton Ave | 3 | Median : Yard | Tree | DPW 1 | 42 | 6004791.23434 | 2095030.36311 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | 2 | 7 | 7 | 28861 | 2 | ||||
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 | |||
25430 | 4171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005278.26135 | 2100471.01085 | 37.7477919952017 | -122.424507508611 | (37.7477919952017, -122.424507508611) | 2 | 4 | 5 | 28859 | 22 | |||
26266 | 9406 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6001730.26656 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) | 2 | 7 | 5 | 63 | 7 | |||
26309 | 7022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1112 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x5 | 6002070.5 | 2110216.2 | 37.7743682457219 | -122.436297093607 | (37.7743682457219, -122.436297093607) | 15 | 5 | 11 | 29492 | 10 | |||
26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
27754 | 246868 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3090x Market St | 1 | Median : Yard | Tree | DPW 1 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | |||
27996 | 5415 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | |||
28295 | 3742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.7444710828997 | -122.38401932754 | (37.7444710828997, -122.38401932754) | 10 | 3 | 8 | 58 | 1 | |||
28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
28754 | 7088 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1864 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5998522.1287 | 2109694.9471 | 37.7727347674481 | -122.448533971797 | (37.7727347674481, -122.448533971797) | 15 | 5 | 11 | 29492 | 16 | |||
28824 | 188743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | 10 | 3 | 8 | 58 | 1 | |||
29060 | 10429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1428 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 5999246.24636 | 2108817.05532 | 37.7703656761027 | -122.445966024888 | (37.7703656761027, -122.445966024888) | 15 | 5 | 11 | 29492 | 9 | |||
29177 | 187712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51x Executive Park Blvd | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6013733.01886 | 2087017.85621 | 37.7113262093072 | -122.394329370613 | (37.7113262093072, -122.394329370613) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
29316 | 200553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 29 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016224.313 | 2095613.1578 | 37.7350653972301 | -122.386317623483 | (37.7350653972301, -122.386317623483) | 10 | 3 | 8 | 58 | 1 | |||
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 |
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) );