trees
7,157 rows where qSpecies_id = 36 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194511 | 23411 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006198.56305 | 2116531.68812 | 37.7919427119246 | -122.422466175278 | (37.7919427119246, -122.422466175278) | 13 | 9 | 10 | 28858 | 21 | |||
194510 | 133064 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006197.29283 | 2116545.94616 | 37.7919817892855 | -122.422471583817 | (37.7919817892855, -122.422471583817) | 13 | 9 | 10 | 28858 | 21 | |||
194507 | 265147 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1362 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993998 | 2106231 | 37.7629639639015 | -122.463931825158 | (37.7629639639015, -122.463931825158) | 1 | 5 | 11 | 56 | 12 | ||||
194500 | 133065 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006194.66564 | 2116570.23884 | 37.7920483427106 | -122.422482400837 | (37.7920483427106, -122.422482400837) | 13 | 9 | 10 | 28858 | 21 | |||
194459 | 248440 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 724 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 788001 | 5997627.8337 | 2107978.5557 | 37.7679708233346 | -122.451503597918 | (37.7679708233346, -122.451503597918) | 15 | 5 | 11 | 29492 | 9 | ||
194450 | 234943 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 4339 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 788007 | 6001670.90597 | 2100562.91239 | 37.7478399578525 | -122.436988118323 | (37.7478399578525, -122.436988118323) | 2 | 4 | 5 | 63 | 22 | ||
194430 | 206231 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995148.67652 | 2106807.2788 | 37.7646125217846 | -122.459993807784 | (37.7646125217846, -122.459993807784) | 15 | 5 | 11 | 56 | 12 | |||
194419 | 179076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 09:01:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194409 | 176258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 09:09:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194383 | 170708 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6000579.72538 | 2092917.63724 | 37.7267857432424 | -122.440213187895 | (37.7267857432424, -122.440213187895) | 9 | 7 | 6 | 28861 | 25 | ||
194375 | 206127 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 4 | Width 3ft | 5995066.94571 | 2106670.30306 | 37.7642317209355 | -122.460266565852 | (37.7642317209355, -122.460266565852) | 15 | 5 | 11 | 56 | 12 | ||
194371 | 205154 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 7 | Width 3ft | 5995104.98822 | 2106728.27185 | 37.7643930764078 | -122.460139188574 | (37.7643930764078, -122.460139188574) | 15 | 5 | 11 | 56 | 12 | ||
194368 | 206128 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 2 | Width 3ft | 5995094.6325 | 2106669.72305 | 37.7642317209303 | -122.46017076378 | (37.7642317209303, -122.46017076378) | 15 | 5 | 11 | 56 | 12 | ||
194331 | 143216 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010256 | 2121247 | 37.8051178581324 | -122.408760167658 | (37.8051178581324, -122.408760167658) | 3 | 1 | 10 | 308 | 23 | |||
194326 | 139658 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1654 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001647 | 2111894 | 37.7789509909807 | -122.437882254054 | (37.7789509909807, -122.437882254054) | 15 | 5 | 11 | 29490 | 41 | |||
194271 | 15783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 03:01:00 PM | 3 | 3X3 | Permit Number 785142 | 6001146.6106 | 2090614.741 | 37.7204947713768 | -122.43808859365 | (37.7204947713768, -122.43808859365) | 9 | 7 | 6 | 28861 | 25 | |
194268 | 15788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2020 12:00:00 AM | 12 | 3X3 | Permit Number 785142 | 6001054.6013 | 2090473.5841 | 37.7201019532463 | -122.438396531841 | (37.7201019532463, -122.438396531841) | 9 | 7 | 6 | 28861 | 25 | |
194263 | 15782 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 12:38:00 PM | 3 | 3X3 | Permit Number 785142 | 6001159.6334 | 2090631.0194 | 37.7205402088092 | -122.438044743528 | (37.7205402088092, -122.438044743528) | 9 | 7 | 6 | 28861 | 25 | |
194262 | 262537 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
194200 | 122143 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991132.05119 | 2114911.74358 | 37.7866333383967 | -122.474477589177 | (37.7866333383967, -122.474477589177) | 11 | 6 | 1 | 54 | 33 | |||
194171 | 7883 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1100X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6006046.87918 | 2113965.56823 | 37.7848882256545 | -122.422808552567 | (37.7848882256545, -122.422808552567) | 13 | 9 | 11 | 28858 | 41 | |||
194139 | 139081 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2255 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001382.06 | 2113859.167 | 37.7843317700504 | -122.438939655743 | (37.7843317700504, -122.438939655743) | 15 | 6 | 11 | 29490 | 13 | |||
194124 | 254846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 790 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5984182.54238 | 2110499.30676 | 37.774112974271 | -122.498194837344 | (37.774112974271, -122.498194837344) | 11 | 6 | 2 | 55 | 26 | ||
194110 | 236117 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 103 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003342.25441 | 2108624.99064 | 37.7700713526377 | -122.431784224572 | (37.7700713526377, -122.431784224572) | 15 | 9 | 5 | 29492 | 9 | |||
194109 | 211677 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994475.01078 | 2090918.19734 | 37.7209463093969 | -122.461171998793 | (37.7209463093969, -122.461171998793) | 9 | 8 | 6 | 28861 | 24 | |||
194105 | 2593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1717 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005272.31567 | 2115067.90207 | 37.7878712268979 | -122.425566774536 | (37.7878712268979, -122.425566774536) | 13 | 9 | 11 | 28858 | 27 | |||
194095 | 181702 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2119 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989150.688 | 2107146.9797 | 37.7651984562784 | -122.480763877638 | (37.7651984562784, -122.480763877638) | 1 | 8 | 3 | 56 | 35 | |||
194063 | 120619 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 | |||
193985 | 14719 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 871 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x5 | 6005011.2646 | 2111934.1612 | 37.779251997589 | -122.426246769427 | (37.779251997589, -122.426246769427) | 7 | 9 | 11 | 28852 | 41 | |||
193945 | 2569 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1616 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4X4 | 6005720.9755 | 2115211.89577 | 37.7882919383578 | -122.424024736347 | (37.7882919383578, -122.424024736347) | 13 | 9 | 1 | 28858 | 41 | |||
193870 | 133226 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 Front St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012871.05323 | 2118401.05303 | 37.7974496952149 | -122.399510475549 | (37.7974496952149, -122.399510475549) | 3 | 1 | 10 | 28860 | 6 | |||
193825 | 236151 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 78 Harper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003574.11815 | 2097824.57791 | 37.7404291179076 | -122.430211575624 | (37.7404291179076, -122.430211575624) | 2 | 7 | 5 | 63 | 7 | |||
193765 | 178460 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 21 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009708.04486 | 2089358.13135 | 37.7175275654099 | -122.408405731934 | (37.7175275654099, -122.408405731934) | 9 | 7 | 8 | 309 | 39 | |||
193748 | 52810 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52055 | 6013684.69191 | 2116256.10913 | 37.7916055021526 | -122.396544619343 | (37.7916055021526, -122.396544619343) | 12 | 2 | 9 | 28855 | 6 | |
193727 | 7977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2007 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6005570.41069 | 2117004.73054 | 37.7932061119264 | -122.424673253679 | (37.7932061119264, -122.424673253679) | 13 | 9 | 1 | 28858 | 27 | |||
193725 | 8040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005219.6402 | 2111621.59299 | 37.7784055377786 | -122.425503660502 | (37.7784055377786, -122.425503660502) | 7 | 9 | 11 | 28852 | 10 | ||
193661 | 236097 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 255 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6000606.85331 | 2106614.29592 | 37.7643950468288 | -122.441101638034 | (37.7643950468288, -122.441101638034) | 15 | 5 | 5 | 28862 | 3 | |||
193604 | 20175 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002842.186 | 2112511.508 | 37.7807144047359 | -122.433791779426 | (37.7807144047359, -122.433791779426) | 15 | 9 | 11 | 29490 | 41 | ||
193597 | 65962 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2607 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 12 | Permit Number 28984 | 5988921.4607 | 2097570.5974 | 37.7388909351647 | -122.480855533186 | (37.7388909351647, -122.480855533186) | 1 | 8 | 3 | 29491 | 35 | |
193588 | 101174 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 445 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994418 | 2106645 | 37.7641248955045 | -122.462509231781 | (37.7641248955045, -122.462509231781) | 1 | 5 | 11 | 56 | 12 | ||||
193482 | 140753 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Beideman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001524.098 | 2112992.9748 | 37.7819615074859 | -122.438386176343 | (37.7819615074859, -122.438386176343) | 15 | 5 | 11 | 29490 | 41 | |||
193475 | 141475 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 60 Annapolis Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998777.6259 | 2111518.5573 | 37.7777565381137 | -122.447781490326 | (37.7777565381137, -122.447781490326) | 15 | 6 | 2 | 54 | 16 | |||
193473 | 234951 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4724 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000219.54957 | 2101112.7199 | 37.7492669966878 | -122.442046283215 | (37.7492669966878, -122.442046283215) | 2 | 4 | 5 | 28862 | 22 | |||
193460 | 235243 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 432 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003573.77281 | 2105750.89169 | 37.76219289401 | -122.430778271711 | (37.76219289401, -122.430778271711) | 15 | 4 | 5 | 28862 | 3 | |||
193444 | 20251 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1880 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | 3X3 | Permit Number 769843 | 6002540.9652 | 2114632.1752 | 37.786520122821 | -122.434985556743 | (37.786520122821, -122.434985556743) | 13 | 9 | 11 | 29490 | 27 | |
193364 | 194698 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1740 20th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6012759.92434 | 2104737.44003 | 37.7599263533461 | -122.398935522751 | (37.7599263533461, -122.398935522751) | 10 | 3 | 8 | 28856 | 29 | |||
193357 | 141252 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 36 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996224.2433 | 2114281.5158 | 37.7851966190297 | -122.456814347196 | (37.7851966190297, -122.456814347196) | 11 | 6 | 1 | 54 | 31 | |||
193350 | 211701 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 242 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994578.07601 | 2088727.88839 | 37.7149381735225 | -122.460657091963 | (37.7149381735225, -122.460657091963) | 9 | 8 | 6 | 28861 | 24 | |||
193320 | 194924 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 660 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6014787.84326 | 2109062.18535 | 37.7719139493118 | -122.392224347299 | (37.7719139493118, -122.392224347299) | 14 | 3 | 9 | 310 | 20 | |||
193314 | 12673 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1135 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3X3 | 5991939.10092 | 2114765.0913 | 37.7862773979781 | -122.471674727817 | (37.7862773979781, -122.471674727817) | 11 | 6 | 2 | 54 | 11 | |||
193300 | 132488 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2435 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001386.04625 | 2118308.03991 | 37.7965474494464 | -122.439244849194 | (37.7965474494464, -122.439244849194) | 13 | 9 | 1 | 57 | 17 | |||
193275 | 132598 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3447 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998176.88861 | 2115490.46741 | 37.7886280087156 | -122.45014599936 | (37.7886280087156, -122.45014599936) | 13 | 6 | 1 | 54 | 31 | |||
193257 | 139884 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1585 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1990 12:00:00 AM | 4 | Width 0ft | 6002525.5727 | 2112285.5886 | 37.7800761156462 | -122.434870935003 | (37.7800761156462, -122.434870935003) | 15 | 5 | 11 | 29490 | 41 | ||
193200 | 8076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 675 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1993 12:00:00 AM | 6 | 3x3 | 6004503.1654 | 2111520.8482 | 37.778088409359 | -122.427975035059 | (37.778088409359, -122.427975035059) | 7 | 9 | 11 | 28852 | 10 | ||
193183 | 69268 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2670 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1994 12:00:00 AM | 10 | Permit Number 33339 | 6000276.95453 | 2117854.51763 | 37.7952390222261 | -122.443049951791 | (37.7952390222261, -122.443049951791) | 13 | 9 | 1 | 57 | 17 | ||
193179 | 218327 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 446 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993041.13869 | 2099946.28589 | 37.7456525746007 | -122.466784370006 | (37.7456525746007, -122.466784370006) | 1 | 8 | 4 | 29491 | 40 | |||
193155 | 142096 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1013 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003019.2266 | 2110623.1721 | 37.7755395496789 | -122.433044356765 | (37.7755395496789, -122.433044356765) | 15 | 5 | 11 | 29492 | 10 | |||
193131 | 32414 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 50 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36945 | 6002852.94175731 | 2087255.56592811 | 37.7113681090093 | -122.431950615733 | (37.7113681090093, -122.431950615733) | 9 | 7 | 6 | 28861 | 5 | |||
193049 | 143105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 468 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010662.8034 | 2119993.5815 | 37.8016990565052 | -122.407263956217 | (37.8016990565052, -122.407263956217) | 3 | 1 | 10 | 308 | 23 | |||
193021 | 194720 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 692 Connecticut St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013264.85358 | 2103877.61118 | 37.7575935739908 | -122.397128914288 | (37.7575935739908, -122.397128914288) | 10 | 3 | 8 | 28856 | 29 | |||
193005 | 132709 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999229.39494 | 2120229.50642 | 37.8017003219629 | -122.44684563944 | (37.8017003219629, -122.44684563944) | 13 | 9 | 1 | 57 | 17 | |||
192986 | 118059 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 478 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5984726.55462 | 2112637.2362 | 37.780014996055 | -122.496470823095 | (37.780014996055, -122.496470823095) | 11 | 6 | 2 | 55 | 26 | |||
192983 | 211670 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5999288.54786 | 2094050.18318 | 37.7298218544765 | -122.444758108808 | (37.7298218544765, -122.444758108808) | 9 | 7 | 4 | 28861 | 40 | ||||
192921 | 189 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1990X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6006778.46705 | 2106797.52493 | 37.7652477494393 | -122.419768697906 | (37.7652477494393, -122.419768697906) | 8 | 4 | 7 | 28853 | 19 | |||
192860 | 194883 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 389 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015278.21463 | 2109042.57043 | 37.7718873068728 | -122.390526732118 | (37.7718873068728, -122.390526732118) | 14 | 3 | 9 | 310 | 20 | |||
192839 | 138457 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002927.5014 | 2114824.4522 | 37.7870700064768 | -122.433661985434 | (37.7870700064768, -122.433661985434) | 13 | 9 | 11 | 29490 | 27 | |||
192823 | 8021 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 457 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1992 12:00:00 AM | 12 | 3X3 | Permit Number 772922 | 6005607.2143 | 2111677.1526 | 37.778579981846 | -122.42416684735 | (37.778579981846, -122.42416684735) | 7 | 9 | 11 | 28852 | 10 | |
192800 | 249773 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.8048710311487 | -122.408142559726 | (37.8048710311487, -122.408142559726) | 3 | 1 | 10 | 308 | 23 | |||
192790 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 8 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
192742 | 66124 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3651 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 9 | Permit Number 29186 | 6000655.26617 | 2120917.00616 | 37.8036693660109 | -122.441960857534 | (37.8036693660109, -122.441960857534) | 13 | 9 | 1 | 57 | 17 | ||
192730 | 121826 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 286 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5989968.02691 | 2113465.06181 | 37.782593645277 | -122.478398962697 | (37.782593645277, -122.478398962697) | 11 | 6 | 2 | 55 | 26 | |||
192683 | 16787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1979 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 10 | 4x4 | 6001845.83815 | 2113227.85716 | 37.7826247299921 | -122.437289928899 | (37.7826247299921, -122.437289928899) | 15 | 5 | 11 | 29490 | 41 | ||
192637 | 11454 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 9 Jade Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6000702.8384041 | 2098560.6268459 | 37.7422870867037 | -122.440192077523 | (37.7422870867037, -122.440192077523) | 2 | 7 | 5 | 63 | 7 | ||
192616 | 122044 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 251 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5990224.84085 | 2113663.9919 | 37.7831547574271 | -122.477525051022 | (37.7831547574271, -122.477525051022) | 11 | 6 | 2 | 55 | 26 | |||
192560 | 234257 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 87 Winfield St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6007213.59235 | 2098966.64021 | 37.7437704347493 | -122.41770860157 | (37.7437704347493, -122.41770860157) | 2 | 7 | 7 | 28859 | 2 | |||
192541 | 44170 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2100 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 5 | Permit Number 43638 | 6003459.43812 | 2117948.28219 | 37.7956774147323 | -122.432044759064 | (37.7956774147323, -122.432044759064) | 13 | 9 | 1 | 57 | 17 | ||
192504 | 97231 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Newcomb Ave | 11 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016395.2358 | 2094838.1728 | 37.732946903013 | -122.385672680851 | (37.732946903013, -122.385672680851) | 10 | 3 | 8 | 58 | 1 | |||
192494 | 137575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1135 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002848.9897 | 2112147.7865 | 37.779716102763 | -122.433742238572 | (37.779716102763, -122.433742238572) | 15 | 9 | 11 | 29490 | 41 | |||
192426 | 234948 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1235 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001995.48726 | 2100426.47119 | 37.7474837660675 | -122.43585597259 | (37.7474837660675, -122.43585597259) | 2 | 4 | 5 | 63 | 22 | |||
192418 | 194715 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 516 Connecticut St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6013228.69514 | 2104483.46683 | 37.7592551083636 | -122.397296450774 | (37.7592551083636, -122.397296450774) | 10 | 3 | 8 | 28856 | 29 | |||
192323 | 15780 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4834 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6001191.3763 | 2090682.2965 | 37.7206828093365 | -122.437938689577 | (37.7206828093365, -122.437938689577) | 9 | 7 | 6 | 28861 | 25 | ||
192308 | 52578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/2006 12:00:00 AM | 5 | Permit Number 48671 | 5993634.38666 | 2114631.28229 | 37.7860079318797 | -122.465799799764 | (37.7860079318797, -122.465799799764) | 11 | 6 | 2 | 54 | 11 | |
192284 | 1502 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 345 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995526.05984 | 2113977.70095 | 37.7843223104602 | -122.459207822084 | (37.7843223104602, -122.459207822084) | 11 | 6 | 2 | 54 | 11 | |||
192246 | 50175 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 246 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/2003 12:00:00 AM | Permit Number 46884 | 6001512.54075764 | 2096465.43875915 | 37.7365802550193 | -122.437242394949 | (37.7365802550193, -122.437242394949) | 2 | 7 | 5 | 63 | 7 | ||
192194 | 30395 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
192157 | 236087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4150 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001309.29887 | 2105853.65061 | 37.7623464874169 | -122.438617572948 | (37.7623464874169, -122.438617572948) | 15 | 5 | 5 | 28862 | 3 | |||
192155 | 14827 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1273 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003087.05957 | 2111664.07375 | 37.7784014543053 | -122.432884085497 | (37.7784014543053, -122.432884085497) | 15 | 9 | 11 | 29492 | 41 | |||
192135 | 57139 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 563 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 8 | Permit Number 14413 | 6003627.01818 | 2089911.87724 | 37.7187056143591 | -122.429464521381 | (37.7187056143591, -122.429464521381) | 9 | 7 | 6 | 28861 | 5 | ||
192121 | 52478 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 66CORTLAND Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48588 | 6009258.07429993 | 2097670.84630053 | 37.7403273056038 | -122.410547756061 | (37.7403273056038, -122.410547756061) | 10 | 7 | 7 | 28859 | 2 | ||
192116 | 199878 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1408 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6015930.5512 | 2093462.2061 | 37.7291430496929 | -122.387183288185 | (37.7291430496929, -122.387183288185) | 10 | 3 | 8 | 58 | 1 | |||
192094 | 49302 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 147 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 5 | Permit Number 47162 | 5996870.7982 | 2113397.0504 | 37.7828052157547 | -122.454513563418 | (37.7828052157547, -122.454513563418) | 11 | 6 | 1 | 54 | 31 | |
192080 | 137572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1175 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002831.1461 | 2112275.1529 | 37.7800648064585 | -122.433813073333 | (37.7800648064585, -122.433813073333) | 15 | 9 | 11 | 29490 | 41 | |||
192078 | 133253 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012958.60104 | 2118206.32809 | 37.7969199063763 | -122.399193859326 | (37.7969199063763, -122.399193859326) | 3 | 1 | 10 | 28860 | 6 | |||
192073 | 139659 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1664 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001639.246 | 2111867.9761 | 37.7788790949925 | -122.437907213697 | (37.7788790949925, -122.437907213697) | 15 | 5 | 11 | 29490 | 41 | |||
192068 | 62188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1985 12:00:00 AM | 9 | Permit Number 22307 | 6000284.22228 | 2092306.40422 | 37.7250906093267 | -122.441190895755 | (37.7250906093267, -122.441190895755) | 9 | 7 | 6 | 28861 | 25 | |
192032 | 124670 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 362 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995584.57011 | 2114051.21056 | 37.7845275117392 | -122.459010722712 | (37.7845275117392, -122.459010722712) | 11 | 6 | 1 | 54 | 31 | |||
192005 | 235239 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 337 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002958.2023 | 2106247.04046 | 37.7635203032431 | -122.432942742012 | (37.7635203032431, -122.432942742012) | 15 | 4 | 5 | 28862 | 3 | |||
191986 | 115085 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2786 JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000894 | 2116629 | 37.7919092338162 | -122.440826927692 | (37.7919092338162, -122.440826927692) | 13 | 6 | 1 | 29490 | 27 | |||
191967 | 114502 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 701 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6008840.77344 | 2110939.06685 | 37.7767354171383 | -122.412928489958 | (37.7767354171383, -122.412928489958) | 8 | 2 | 9 | 28853 | 34 | ||||
191965 | 139958 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002719.4884 | 2112363.0872 | 37.7802999152838 | -122.434205635502 | (37.7802999152838, -122.434205635502) | 15 | 5 | 11 | 29490 | 41 |
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) );