trees
1,914 rows where qSpecies_id = 45 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 26240 | 115259 | DPW Maintained 1 | :: 45 | 2130 Jackson St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004 | 37.7931106894063 | -122.430387878845 | (37.7931106894063, -122.430387878845) | 13 | 9 | 1 | 29490 | 27 | ||||
| 31000 | 104827 | Permitted Site 7 | :: 45 | 4366 26th St | : Cutout | Tree | Private 2 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | 2 | 4 | 5 | 28862 | 22 | |||||
| 37319 | 105121 | Undocumented 4 | :: 45 | 721 BEACH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.420969011396 | (37.8064757462399, -122.420969011396) | 5 | 1 | 1 | 28858 | 32 | |||||
| 65959 | 105925 | Permitted Site 7 | :: 45 | 4166 20th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6002608.6 | 2104160 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | 2 | 4 | 5 | 28862 | 3 | |||||
| 78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
| 91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 98201 | 106968 | Property Tree 8 | :: 45 | 351 26th Ave | Back Yard : Yard | Tree | Private 2 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.486185401226 | (37.7828456076198, -122.486185401226) | 11 | 6 | 2 | 55 | 26 | ||||||
| 104259 | 104859 | DPW Maintained 1 | :: 45 | 650 Fillmore St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.431038440447 | (37.775386259915, -122.431038440447) | 7 | 9 | 11 | 29492 | 10 | ||||||
| 104748 | 104860 | DPW Maintained 1 | :: 45 | 283 Randall St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | 2 | 7 | 5 | 63 | 7 | ||||||
| 121061 | 107631 | Undocumented 4 | :: 45 | 4059 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003507 | 2100669 | 37.7482354401484 | -122.430646564887 | (37.7482354401484, -122.430646564887) | 2 | 4 | 5 | 63 | 22 | ||||||
| 123101 | 104856 | DPW Maintained 1 | :: 45 | 739 27th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.7461866004606 | -122.436767226643 | (37.7461866004606, -122.436767226643) | 2 | 7 | 5 | 63 | 22 | ||||
| 127177 | 115258 | DPW Maintained 1 | :: 45 | 2150 Jackson St | : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003858 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | 13 | 9 | 1 | 29490 | 27 | ||||
| 127241 | 104634 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
| 138642 | 105046 | Permitted Site 7 | :: 45 | 268 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 141766 | 104864 | DPW Maintained 1 | :: 45 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6000629.3 | 2102650 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 141783 | 110320 | Property Tree 8 | :: 45 | 9 Imperial Aly | Back Yard : Yard | Landscaping | Private 2 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | 13 | 9 | 1 | 57 | 17 | ||||||
| 148544 | 104637 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
| 151200 | 119244 | Undocumented 4 | :: 45 | 311 30th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402 | 2098353 | 37.7419269008751 | -122.427386718491 | (37.7419269008751, -122.427386718491) | 2 | 7 | 5 | 63 | 7 | |||
| 152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
| 171517 | 104636 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
| 178111 | 104635 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
| 179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
| 94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
| 119 | 184195 | DPW Maintained 1 | :: 45 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690204 | (37.759713770345, -122.49627690204) | 1 | 8 | 3 | 56 | 35 | |||
| 120 | 141225 | DPW Maintained 1 | :: 45 | 3 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5996479.075 | 2114520.1031 | 37.7858663452689 | -122.455949967769 | (37.7858663452689, -122.455949967769) | 11 | 6 | 1 | 54 | 31 | |||
| 132 | 182257 | DPW Maintained 1 | :: 45 | 1439 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985240.365 | 2105399.9729 | 37.7601736080068 | -122.494159774452 | (37.7601736080068, -122.494159774452) | 1 | 8 | 3 | 56 | 35 | |||
| 141 | 254165 | DPW Maintained 1 | :: 45 | 579 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983759 | 2111886 | 37.7778955894485 | -122.499762435435 | (37.7778955894485, -122.499762435435) | 11 | 6 | 2 | 55 | 26 | ||||
| 142 | 186181 | DPW Maintained 1 | :: 45 | 1700 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984741.0761 | 2103142.2522 | 37.75394530503 | -122.495720014116 | (37.75394530503, -122.495720014116) | 1 | 8 | 3 | 56 | 35 | |||
| 175 | 184150 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.7571490682193 | -122.503626084685 | (37.7571490682193, -122.503626084685) | 1 | 8 | 3 | 56 | 35 | |||
| 179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
| 185 | 184541 | DPW Maintained 1 | :: 45 | 1706 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984416.199 | 2103539.5001 | 37.7550170068332 | -122.496872815694 | (37.7550170068332, -122.496872815694) | 1 | 8 | 3 | 56 | 35 | |||
| 192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
| 214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
| 218 | 181787 | DPW Maintained 1 | :: 45 | 2915 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986983.636 | 2098224.4165 | 37.740573320949 | -122.487603561386 | (37.740573320949, -122.487603561386) | 1 | 8 | 3 | 29491 | 35 | |||
| 221 | 182334 | DPW Maintained 1 | :: 45 | 1507 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985257.4301 | 2104914.9526 | 37.758842875608 | -122.494065007935 | (37.758842875608, -122.494065007935) | 1 | 8 | 3 | 56 | 35 | |||
| 224 | 183657 | DPW Maintained 1 | :: 45 | 1490 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981573.7378 | 2104946.7308 | 37.7587138957913 | -122.506807059304 | (37.7587138957913, -122.506807059304) | 1 | 8 | 3 | 56 | 35 | |||
| 229 | 121402 | Undocumented 4 | :: 45 | 346X Duncan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6004011 | 2099874 | 37.7460810947058 | -122.428847079389 | (37.7460810947058, -122.428847079389) | 2 | 7 | 5 | 63 | 22 | ||||
| 232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
| 234 | 183167 | DPW Maintained 1 | :: 45 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.7413295619026 | -122.503441142831 | (37.7413295619026, -122.503441142831) | 1 | 8 | 3 | 29491 | 35 | |||
| 235 | 184469 | DPW Maintained 1 | :: 45 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.7457660664858 | -122.506976375045 | (37.7457660664858, -122.506976375045) | 1 | 8 | 3 | 29491 | 35 | |||
| 242 | 184584 | DPW Maintained 1 | :: 45 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | 1 | 8 | 3 | 56 | 35 | |||
| 253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
| 257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
| 268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
| 276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
| 279 | 182423 | DPW Maintained 1 | :: 45 | 1539 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988365.4024 | 2104835.4768 | 37.7588060244513 | -122.483310502266 | (37.7588060244513, -122.483310502266) | 1 | 8 | 3 | 56 | 35 | |||
| 295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
| 320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
| 325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
| 326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
| 327 | 182422 | DPW Maintained 1 | :: 45 | 1534 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987477.4649 | 2104817.3887 | 37.7587046434176 | -122.486380033207 | (37.7587046434176, -122.486380033207) | 1 | 8 | 3 | 56 | 35 | |||
| 351 | 182685 | DPW Maintained 1 | :: 45 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | 1 | 8 | 3 | 56 | 35 | |||
| 354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
| 360 | 181895 | DPW Maintained 1 | :: 45 | 2366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986431.1624 | 2099136.6325 | 37.7430457847891 | -122.489580839702 | (37.7430457847891, -122.489580839702) | 1 | 8 | 3 | 29491 | 35 | |||
| 365 | 184621 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.7533372599652 | -122.496976365214 | (37.7533372599652, -122.496976365214) | 1 | 8 | 3 | 56 | 35 | |||
| 367 | 183862 | DPW Maintained 1 | :: 45 | 2239 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986357.5018 | 2099996.4101 | 37.7454022028518 | -122.489898755555 | (37.7454022028518, -122.489898755555) | 1 | 8 | 3 | 29491 | 35 | |||
| 373 | 200940 | DPW Maintained 1 | :: 45 | 1515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008432.2434 | 2109068.8895 | 37.7715774111529 | -122.414209373869 | (37.7715774111529, -122.414209373869) | 8 | 2 | 9 | 28853 | 19 | |||
| 377 | 142111 | DPW Maintained 1 | :: 45 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | 15 | 6 | 2 | 29492 | 16 | |||
| 378 | 182780 | DPW Maintained 1 | :: 45 | 1743 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985620.0055 | 2103342.2275 | 37.7545458149545 | -122.492695239531 | (37.7545458149545, -122.492695239531) | 1 | 8 | 3 | 56 | 35 | |||
| 386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
| 388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 397 | 253904 | DPW Maintained 1 | :: 45 | 3637 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997456 | 2115038 | 37.7873443747179 | -122.4526074861 | (37.7873443747179, -122.4526074861) | 11 | 6 | 1 | 54 | 31 | ||||
| 410 | 183338 | DPW Maintained 1 | :: 45 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.509312865514 | (37.7637711641625, -122.509312865514) | 1 | 8 | 3 | 56 | 35 | |||
| 435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
| 446 | 182929 | DPW Maintained 1 | :: 45 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.73729554361 | -122.505454091008 | (37.73729554361, -122.505454091008) | 1 | 8 | 3 | 29491 | 35 | |||
| 452 | 182004 | DPW Maintained 1 | :: 45 | 3220 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986004.751 | 2098249.2905 | 37.7405844772428 | -122.490989950641 | (37.7405844772428, -122.490989950641) | 1 | 8 | 3 | 29491 | 35 | |||
| 460 | 182240 | DPW Maintained 1 | :: 45 | 1427 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985548.7085 | 2105482.2958 | 37.7604176820805 | -122.49309944026 | (37.7604176820805, -122.49309944026) | 1 | 8 | 3 | 56 | 35 | |||
| 484 | 182121 | DPW Maintained 1 | :: 45 | 2516 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988187.7408 | 2098326.2815 | 37.7409231701359 | -122.483447748483 | (37.7409231701359, -122.483447748483) | 1 | 8 | 3 | 29491 | 35 | |||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
| 534 | 183705 | Undocumented 4 | :: 45 | 3628 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983226.2116 | 2105643.5823 | 37.7607244242532 | -122.501143681764 | (37.7607244242532, -122.501143681764) | 1 | 8 | 3 | 56 | 35 | |||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 610 | 182578 | DPW Maintained 1 | :: 45 | 2451 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988885.5665 | 2098636.2758 | 37.7418149236633 | -122.481057645938 | (37.7418149236633, -122.481057645938) | 1 | 8 | 3 | 29491 | 35 | |||
| 644 | 182239 | DPW Maintained 1 | :: 45 | 1434 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985592.8101 | 2105449.5872 | 37.7603304525285 | -122.492944506053 | (37.7603304525285, -122.492944506053) | 1 | 8 | 3 | 56 | 35 | |||
| 758 | 228462 | DPW Maintained 1 | :: 45 | 227 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.7683047783783 | -122.418472926402 | (37.7683047783783, -122.418472926402) | 8 | 4 | 7 | 28853 | 19 | |||
| 771 | 182161 | DPW Maintained 1 | :: 45 | 1634 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989670.2283 | 2104207.7015 | 37.757158173162 | -122.478751948653 | (37.757158173162, -122.478751948653) | 1 | 8 | 3 | 56 | 35 | |||
| 905 | 181988 | DPW Maintained 1 | :: 45 | 2838 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987152.1701 | 2098289.7319 | 37.740762487887 | -122.487025638785 | (37.740762487887, -122.487025638785) | 1 | 8 | 3 | 29491 | 35 | |||
| 1022 | 182384 | DPW Maintained 1 | :: 45 | 1539 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985884.4808 | 2104746.0177 | 37.7584156979157 | -122.49188396911 | (37.7584156979157, -122.49188396911) | 1 | 8 | 3 | 56 | 35 | |||
| 1289 | 190652 | DPW Maintained 1 | :: 45 | 310 Arkansas St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.398528520183 | (37.7621425904374, -122.398528520183) | 10 | 3 | 8 | 28856 | 29 | |||
| 1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
| 1482 | 29956 | DPW Maintained 1 | :: 45 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.432282489737 | (37.7719405092432, -122.432282489737) | 15 | 5 | 11 | 29492 | 9 | ||
| 1603 | 182661 | DPW Maintained 1 | :: 45 | 2500 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986241.1388 | 2102339.3676 | 37.7518285352163 | -122.490473451437 | (37.7518285352163, -122.490473451437) | 1 | 8 | 3 | 56 | 35 | |||
| 1755 | 181883 | DPW Maintained 1 | :: 45 | 2362 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986739.9723 | 2099172.336 | 37.7431618411675 | -122.48851569655 | (37.7431618411675, -122.48851569655) | 1 | 8 | 3 | 29491 | 35 | |||
| 1846 | 182526 | DPW Maintained 1 | :: 45 | 1578 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985626.9415 | 2104489.6047 | 37.7576966023025 | -122.492755756192 | (37.7576966023025, -122.492755756192) | 1 | 8 | 3 | 56 | 35 | |||
| 1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
| 1996 | 183451 | DPW Maintained 1 | :: 45 | 2515 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988280.1843 | 2098179.6898 | 37.7405260477437 | -122.483117374817 | (37.7405260477437, -122.483117374817) | 1 | 8 | 3 | 29491 | 35 | |||
| 2002 | 182728 | DPW Maintained 1 | :: 45 | 1726 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985974.3316 | 2103468.8168 | 37.7549141067074 | -122.491479220658 | (37.7549141067074, -122.491479220658) | 1 | 8 | 3 | 56 | 35 | |||
| 2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
| 2112 | 183619 | DPW Maintained 1 | :: 45 | 1415 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983065.6286 | 2105470.5181 | 37.7602398080473 | -122.501686253156 | (37.7602398080473, -122.501686253156) | 1 | 8 | 3 | 56 | 35 | |||
| 2292 | 182145 | DPW Maintained 1 | :: 45 | 1452 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989717.6723 | 2103818.6604 | 37.7560927247983 | -122.478559421541 | (37.7560927247983, -122.478559421541) | 1 | 8 | 3 | 56 | 35 | |||
| 2338 | 260969 | Permitted Site 7 | :: 45 | 897 37th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11/05/2019 12:00:00 AM | 3 | 10X27 | 5984476.51719 | 2109749.52706 | 37.7720715265353 | -122.497122586729 | (37.7720715265353, -122.497122586729) | 11 | 6 | 2 | 55 | 26 | ||
| 2448 | 181960 | DPW Maintained 1 | :: 45 | 2455 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985784.4384 | 2098510.2137 | 37.7412880286271 | -122.491770899478 | (37.7412880286271, -122.491770899478) | 1 | 8 | 3 | 29491 | 35 |
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) );