trees
1,985 rows where qSpecies_id = 83 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184251 | 113166 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | 11 | 6 | 1 | 54 | 31 | |||
91056 | 113204 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 3225 26TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008227 | 2100905 | 37.7491497143695 | -122.414341588448 | (37.7491497143695, -122.414341588448) | 2 | 4 | 7 | 28859 | 19 | ||||
141906 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
121713 | 11461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935 | 2095578 | 37.7350081734808 | -122.383858053082 | (37.7350081734808, -122.383858053082) | 10 | 3 | 8 | 58 | 1 | ||
121993 | 11462 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 41X HAWKINS LN | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/1992 12:00:00 AM | 6 | 3X3 | 6016935 | 2095578 | 37.7350081734808 | -122.383858053082 | (37.7350081734808, -122.383858053082) | 10 | 3 | 8 | 58 | 1 | ||
51886 | 11463 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | 10 | 3 | 8 | 58 | 1 | ||
90685 | 11464 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.85852 | 2095545.67202 | 37.7349113274992 | -122.384361070118 | (37.7349113274992, -122.384361070118) | 10 | 3 | 8 | 58 | 1 | ||
115371 | 11465 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665953 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | 10 | 3 | 8 | 58 | 1 | ||
4044 | 11466 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.96757 | 2095560.66167 | 37.7349522709331 | -122.384375566285 | (37.7349522709331, -122.384375566285) | 10 | 3 | 8 | 58 | 1 | ||
163260 | 11467 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.15734 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | 10 | 3 | 8 | 58 | 1 | ||
136459 | 11468 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.7350660954277 | -122.384265809434 | (37.7350660954277, -122.384265809434) | 10 | 3 | 8 | 58 | 1 | ||
65942 | 11469 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 9 | 3X3 | 6016835.01202 | 2095606.77415 | 37.735081653692 | -122.384205753614 | (37.735081653692, -122.384205753614) | 10 | 3 | 8 | 58 | 1 | ||
117118 | 11470 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6016849.3995 | 2095607.37924 | 37.7350841106266 | -122.38415605258 | (37.7350841106266, -122.38415605258) | 10 | 3 | 8 | 58 | 1 | |||
108376 | 11472 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6016881.34744 | 2095602.56066 | 37.7350726460825 | -122.384045260583 | (37.7350726460825, -122.384045260583) | 10 | 3 | 8 | 58 | 1 | |||
98702 | 114903 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 3261 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007278.07200017 | 2102623.89370267 | 37.7538160547365 | -122.417744822627 | (37.7538160547365, -122.417744822627) | 2 | 4 | 7 | 28859 | 19 | |||
189045 | 115209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 777466 | 5997030.13095 | 2115907.11493 | 37.7897063219407 | -122.454143692681 | (37.7897063219407, -122.454143692681) | 11 | 6 | 1 | 54 | 31 | ||
91925 | 115210 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.7896692276076 | -122.454138404663 | (37.7896692276076, -122.454138404663) | 11 | 6 | 1 | 54 | 31 | |||
88524 | 115222 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2252 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002543 | 2107122 | 37.7658991699711 | -122.434441354631 | (37.7658991699711, -122.434441354631) | 15 | 5 | 5 | 28862 | 3 | ||||
28895 | 115389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 378 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776292 | 6007259.3 | 2096222.3 | 37.7362376572368 | -122.417356112468 | (37.7362376572368, -122.417356112468) | 2 | 7 | 7 | 28859 | 2 | ||
170274 | 115488 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1393 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010176 | 2101093 | 37.7497752121793 | -122.407615143394 | (37.7497752121793, -122.407615143394) | 2 | 4 | 7 | 28859 | 19 | |||
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
10955 | 116918 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
119381 | 116919 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
119280 | 116920 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
154306 | 116921 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
147805 | 116922 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
130786 | 117045 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2205x Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002006.1518 | 2114301.3544 | 37.7855813923399 | -122.436812184863 | (37.7855813923399, -122.436812184863) | 13 | 6 | 11 | 29490 | 13 | |||
38069 | 117046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2205x Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6002022.6426 | 2114300.8047 | 37.7855808202172 | -122.436755092227 | (37.7855808202172, -122.436755092227) | 13 | 6 | 11 | 29490 | 13 | |||
114009 | 117078 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1506 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 5x5 | 6003016 | 2114040 | 37.7849211205465 | -122.433299725252 | (37.7849211205465, -122.433299725252) | 13 | 9 | 11 | 29490 | 13 | |||
110729 | 117314 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | 15 | 5 | 11 | 29492 | 9 | |||
95863 | 117418 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 171 COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006547 | 2098715 | 37.7430419534663 | -122.419995670368 | (37.7430419534663, -122.419995670368) | 2 | 7 | 7 | 28859 | 2 | |||
161764 | 117917 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 767 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | 11 | 6 | 2 | 55 | 26 | |||
123864 | 118185 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5985597.25903 | 2112945.42329 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | 11 | 6 | 2 | 55 | 26 | |||
37445 | 118287 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2.5 | 6006177 | 2111293 | 37.7775573470216 | -122.422168438332 | (37.7775573470216, -122.422168438332) | 7 | 9 | 11 | 28852 | 10 | ||||
167945 | 118288 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 240 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2.5 | 6006177 | 2111293 | 37.7775573470216 | -122.422168438332 | (37.7775573470216, -122.422168438332) | 7 | 9 | 11 | 28852 | 10 | ||||
139061 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 720 BATTERY ST | 1 | unknown : Yard | Tree | Private 2 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | |||||
58587 | 120181 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987742.58723 | 2115005.98358 | 37.7866951312776 | -122.486211085191 | (37.7866951312776, -122.486211085191) | 11 | 6 | 1 | 55 | 33 | |||
165912 | 120183 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987744.35264 | 2114901.48572 | 37.7864083129421 | -122.486197303246 | (37.7864083129421, -122.486197303246) | 11 | 6 | 1 | 55 | 33 | |||
92920 | 120248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.7863345857746 | -122.484046777757 | (37.7863345857746, -122.484046777757) | 11 | 6 | 1 | 55 | 33 | |||
28070 | 120249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.7863104293457 | -122.484043303996 | (37.7863104293457, -122.484043303996) | 11 | 6 | 1 | 55 | 33 | |||
3730 | 120250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | 11 | 6 | 1 | 55 | 33 | |||
105538 | 120251 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.484043998399 | (37.7864004688283, -122.484043998399) | 11 | 6 | 1 | 55 | 33 | |||
111047 | 120252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | 11 | 6 | 1 | 55 | 33 | |||
118817 | 120253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.484036357305 | (37.7865333323848, -122.484036357305) | 11 | 6 | 1 | 55 | 33 | |||
141976 | 120254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | 11 | 6 | 1 | 55 | 33 | |||
180083 | 120255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988367.99594 | 2114912.99225 | 37.7864762341937 | -122.484040525506 | (37.7864762341937, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
83246 | 120256 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.484041219882 | (37.7866145875471, -122.484041219882) | 11 | 6 | 1 | 55 | 33 | |||
127417 | 120257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988368.87318 | 2114954.36452 | 37.7865898817391 | -122.484040525506 | (37.7865898817391, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
153821 | 120258 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.484053724446 | (37.7867672160285, -122.484053724446) | 11 | 6 | 1 | 55 | 33 | |||
121667 | 120259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | 11 | 6 | 1 | 55 | 33 | |||
99871 | 120310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5988691.60184 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | 11 | 6 | 2 | 55 | 26 | |||
136633 | 120315 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 206 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5988712.81851 | 2113914.04057 | 37.7837534650339 | -122.4827743052 | (37.7837534650339, -122.4827743052) | 11 | 6 | 2 | 55 | 26 | |||
93256 | 120438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5988956.31634 | 2114501.16974 | 37.7853797200377 | -122.481974928571 | (37.7853797200377, -122.481974928571) | 11 | 6 | 2 | 55 | 26 | |||
43433 | 120515 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
167127 | 120517 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
44993 | 120561 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | 14 | 3 | 8 | 28856 | 29 | |||
11660 | 120676 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003502 | 2105614 | 37.7618129556584 | -122.431016735878 | (37.7618129556584, -122.431016735878) | 15 | 4 | 5 | 28862 | 3 | ||||
170159 | 120774 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989253.85466 | 2114850.93568 | 37.7863573783569 | -122.480971165425 | (37.7863573783569, -122.480971165425) | 11 | 6 | 1 | 55 | 33 | |||
144919 | 120775 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989253.50277 | 2114844.12588 | 37.7863386601165 | -122.48097188408 | (37.7863386601165, -122.48097188408) | 11 | 6 | 1 | 55 | 33 | |||
144958 | 120776 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | 11 | 6 | 1 | 55 | 33 | |||
119489 | 120777 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989253.41901 | 2114816.78103 | 37.7862635740202 | -122.480970171004 | (37.7862635740202, -122.480970171004) | 11 | 6 | 1 | 55 | 33 | |||
120392 | 120778 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989252.84217 | 2114809.14521 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | 11 | 6 | 1 | 55 | 33 | |||
79362 | 120872 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 16 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003333 | 2105685 | 37.7619983269925 | -122.431606308434 | (37.7619983269925, -122.431606308434) | 15 | 4 | 5 | 28862 | 3 | ||||
166617 | 121094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1697 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | 6001082.7006 | 2111393.2018 | 37.7775438211132 | -122.439798471941 | (37.7775438211132, -122.439798471941) | 15 | 5 | 11 | 29492 | 41 | ||
90487 | 121095 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1691 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001097 | 2111345 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | 15 | 5 | 11 | 29492 | 41 | |||
190123 | 121096 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1691 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001097 | 2111345 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | 15 | 5 | 11 | 29492 | 41 | |||
150938 | 121097 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1691 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001097 | 2111345 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | 15 | 5 | 11 | 29492 | 41 | |||
40500 | 121918 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | 11 | 6 | 2 | 54 | 26 | |||
139194 | 121984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 410 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991256.96696 | 2112622.26651 | 37.7803543051205 | -122.473878323075 | (37.7803543051205, -122.473878323075) | 11 | 6 | 2 | 54 | 26 | |||
176509 | 122094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 695 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990954.58445 | 2110703.0239 | 37.7750670731843 | -122.474784270445 | (37.7750670731843, -122.474784270445) | 11 | 6 | 2 | 54 | 26 | |||
38017 | 122096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990911.76477 | 2111862.01127 | 37.7782468532741 | -122.475017013162 | (37.7782468532741, -122.475017013162) | 11 | 6 | 2 | 54 | 26 | |||
91449 | 122099 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 451 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990895.26927 | 2112314.80254 | 37.7794891374062 | -122.47510713931 | (37.7794891374062, -122.47510713931) | 11 | 6 | 2 | 54 | 26 | |||
5677 | 123020 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.78579664693 | -122.464549802121 | (37.78579664693, -122.464549802121) | 11 | 6 | 1 | 54 | 11 | |||
22297 | 123102 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992511.21682 | 2112680.96666 | 37.7805880471465 | -122.469543602377 | (37.7805880471465, -122.469543602377) | 11 | 6 | 2 | 54 | 11 | |||
123867 | 123103 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992512.64277 | 2112661.1585 | 37.7805337417535 | -122.469537227026 | (37.7805337417535, -122.469537227026) | 11 | 6 | 2 | 54 | 11 | |||
169722 | 123173 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 691 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.89087 | 2110769.52892 | 37.7753589775368 | -122.468253641396 | (37.7753589775368, -122.468253641396) | 11 | 6 | 2 | 54 | 11 | |||
118909 | 123209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993132.47666 | 2112678.91247 | 37.7806182922184 | -122.467394237543 | (37.7806182922184, -122.467394237543) | 11 | 6 | 2 | 54 | 11 | |||
151501 | 123226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 774 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993220.36068 | 2110224.45324 | 37.7738840821187 | -122.466911720959 | (37.7738840821187, -122.466911720959) | 11 | 6 | 2 | 54 | 11 | |||
81578 | 123265 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993761.50417 | 2112485.63219 | 37.7801238908447 | -122.465204105338 | (37.7801238908447, -122.465204105338) | 11 | 6 | 2 | 54 | 11 | |||
143823 | 123269 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993762.13117 | 2112380.50791 | 37.7798352840942 | -122.465194298448 | (37.7798352840942, -122.465194298448) | 11 | 6 | 2 | 54 | 11 | |||
101305 | 123293 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 566 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994099.84027 | 2111646.79244 | 37.7778401670229 | -122.463972747763 | (37.7778401670229, -122.463972747763) | 11 | 6 | 2 | 54 | 11 | |||
90743 | 123342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 655 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994692.32091 | 2111064.37501 | 37.7762751309174 | -122.461880922704 | (37.7762751309174, -122.461880922704) | 11 | 6 | 2 | 54 | 11 | |||
129491 | 123627 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995231.45698 | 2114622.12535 | 37.7860747850365 | -122.460273744131 | (37.7860747850365, -122.460273744131) | 11 | 6 | 1 | 54 | 11 | |||
73327 | 123628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995232.14872 | 2114600.88341 | 37.7860165001902 | -122.460269811318 | (37.7860165001902, -122.460269811318) | 11 | 6 | 1 | 54 | 11 | |||
57741 | 124089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | 11 | 6 | 2 | 54 | 11 | ||||
29411 | 124324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996182.48161 | 2113700.35533 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | 11 | 6 | 1 | 54 | 31 | |||
12316 | 124412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.7878533198568 | -122.45724420279 | (37.7878533198568, -122.45724420279) | 11 | 6 | 1 | 54 | 31 | |||
104527 | 124413 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996133.62205 | 2115253.79296 | 37.7878610275159 | -122.457198225213 | (37.7878610275159, -122.457198225213) | 11 | 6 | 1 | 54 | 31 | |||
130146 | 12667 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5991972.94269 | 2114825.89139 | 37.7864462960863 | -122.471562077277 | (37.7864462960863, -122.471562077277) | 11 | 6 | 1 | 54 | 11 | |||
33994 | 12670 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.39199 | 37.786439173997 | -122.471741673868 | (37.786439173997, -122.471741673868) | 11 | 6 | 1 | 54 | 11 | ||
42041 | 13319 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 14 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1992 12:00:00 AM | 7 | 3X3 | 6016463.59576 | 2095940.92929 | 37.7359786339072 | -122.385513164614 | (37.7359786339072, -122.385513164614) | 10 | 3 | 8 | 58 | 1 | ||
5790 | 136106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002236.43409 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | 13 | 9 | 1 | 57 | 17 | |||
181575 | 136110 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | 13 | 9 | 1 | 28858 | 27 | |||
24907 | 136189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002539.896 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | 13 | 9 | 1 | 57 | 17 | |||
50414 | 136190 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002538.23525 | 2118203.76672 | 37.7963266398053 | -122.435250565155 | (37.7963266398053, -122.435250565155) | 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) );