trees
7,157 rows where qSpecies_id = 36 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7790 | 178430 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 661 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6001092.95814 | 2089944.7413 | 37.7186520516399 | -122.438226080097 | (37.7186520516399, -122.438226080097) | 9 | 7 | 6 | 28861 | 5 | ||||
7814 | 194682 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Jack Balestreri Way | 22 | Front Yard : Yard | Tree | Private 2 | 8 | 6012380.91774 | 2104784.08259 | 37.7600332971117 | -122.400249606728 | (37.7600332971117, -122.400249606728) | 10 | 3 | 8 | 28856 | 29 | ||||
7820 | 194790 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013605.05122 | 2116340.26995 | 37.7918321555771 | -122.396826080181 | (37.7918321555771, -122.396826080181) | 12 | 2 | 9 | 28855 | 6 | |||
7823 | 19798 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY21 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
7824 | 139570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1161 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000814.0044 | 2112720.6298 | 37.781173302356 | -122.440823225006 | (37.781173302356, -122.440823225006) | 15 | 5 | 1 | 29490 | 41 | |||
7845 | 139459 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 818 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001028.7331 | 2111499.2655 | 37.7778319731371 | -122.439992770142 | (37.7778319731371, -122.439992770142) | 15 | 5 | 11 | 29490 | 41 | |||
7890 | 12638 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 917 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3 | 5992587.66451 | 2114789.03199 | 37.7863806345724 | -122.469432628996 | (37.7863806345724, -122.469432628996) | 11 | 6 | 2 | 54 | 11 | |||
7916 | 133157 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:39:00 PM | 3 | Width 4ft | 6010238.59911 | 2122044.66703 | 37.8073070787122 | -122.408876698811 | (37.8073070787122, -122.408876698811) | 3 | 1 | 10 | 308 | 23 | ||
7926 | 105855 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 4X Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006273.18234 | 2099962.59464 | 37.746452135478 | -122.421031022521 | (37.746452135478, -122.421031022521) | 2 | 7 | 7 | 28859 | 2 | ||||
7943 | 194966 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011517.79907 | 2112391.01147 | 37.7808720251553 | -122.403770001992 | (37.7808720251553, -122.403770001992) | 6 | 2 | 9 | 28853 | 34 | |||
8013 | 162581 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 109 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5995313.94103 | 2090657.06399 | 37.7202775429677 | -122.458253196048 | (37.7202775429677, -122.458253196048) | 9 | 8 | 6 | 28861 | 24 | |||
8014 | 72029 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2049 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007657.13445 | 2119469.15821 | 37.8000904473654 | -122.417627788486 | (37.8000904473654, -122.417627788486) | 5 | 1 | 1 | 28858 | 32 | |||
8157 | 8138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 919 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003262.67464 | 2111347.69223 | 37.7775427083406 | -122.432253966617 | (37.7775427083406, -122.432253966617) | 15 | 9 | 11 | 29492 | 10 | |||
8244 | 20067 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY54 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
8334 | 258102 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 Woolsey St | 3 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 4x5 | 6010863.11329 | 2091931.53922 | 37.7246582312756 | -122.404594222384 | (37.7246582312756, -122.404594222384) | 10 | 3 | 7 | 309 | 28 | |||
8401 | 28903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6011671.18393 | 2112073.93673 | 37.7800099791183 | -122.403217054727 | (37.7800099791183, -122.403217054727) | 14 | 2 | 9 | 28856 | 34 | ||
8410 | 194679 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 905 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011626.96976 | 2104120.55143 | 37.7581693181819 | -122.402810499115 | (37.7581693181819, -122.402810499115) | 10 | 3 | 8 | 28856 | 29 | |||
8422 | 18844 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2135 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1993 12:00:00 AM | 8 | 3x3 | 6004541.20002 | 2116043.53648 | 37.7905087357386 | -122.428165857165 | (37.7905087357386, -122.428165857165) | 13 | 9 | 1 | 28858 | 27 | ||
8453 | 132477 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2665 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005685.38019 | 2119478.18291 | 37.800004078292 | -122.424451466457 | (37.800004078292, -122.424451466457) | 13 | 9 | 1 | 57 | 17 | |||
8526 | 20030 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
8590 | 142524 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:52:00 PM | 20 | Width 0ft | 6009733.2838 | 2121208.6135 | 37.8049831671154 | -122.410566384357 | (37.8049831671154, -122.410566384357) | 3 | 1 | 10 | 308 | 23 | ||
8598 | 121137 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
8630 | 5179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1071X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001831.363 | 2109760.4908 | 37.7731033917316 | -122.437091677951 | (37.7731033917316, -122.437091677951) | 15 | 5 | 11 | 29492 | 9 | |||
8737 | 180668 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | 9 | 7 | 6 | 28861 | 5 | ||
8900 | 234194 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 375 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003458.09568 | 2099493.1742 | 37.7450041256393 | -122.430731778545 | (37.7450041256393, -122.430731778545) | 2 | 7 | 5 | 63 | 22 | |||
8914 | 7995 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2250 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1992 12:00:00 AM | 12 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | ||
9119 | 18646 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 55 Reuel Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017250.7089795 | 2096167.8793556 | 37.7366453120483 | -122.382807560554 | (37.7366453120483, -122.382807560554) | 10 | 3 | 8 | 58 | 1 | |||
9138 | 78309 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 455 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002281.32907 | 2090819.50286 | 37.7211214694746 | -122.434180870171 | (37.7211214694746, -122.434180870171) | 9 | 7 | 6 | 28861 | 5 | |||
9190 | 103620 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 132 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6x8 | 5992751.57388 | 2114579.30418 | 37.7858142507268 | -122.468850281745 | (37.7858142507268, -122.468850281745) | 11 | 6 | 2 | 54 | 11 | |||
9236 | 133244 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2018 12:00:00 AM | 3 | Width 3ft | 6012682.67669 | 2118166.8825 | 37.7967962172142 | -122.40014585736 | (37.7967962172142, -122.40014585736) | 3 | 1 | 10 | 28860 | 6 | ||
9267 | 147629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 711 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | 4x4 | 5990651.334 | 2110508.03529 | 37.7745141105818 | -122.475819026753 | (37.7745141105818, -122.475819026753) | 11 | 6 | 2 | 55 | 26 | ||
9478 | 260514 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3025 22nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5989750.29916 | 2095052.76589 | 37.7320257582668 | -122.477805820702 | (37.7320257582668, -122.477805820702) | 1 | 8 | 4 | 64 | 35 | ||||
9493 | 116897 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 180 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992666 | 2097552 | 37.7390568153225 | -122.467907415395 | (37.7390568153225, -122.467907415395) | 1 | 8 | 4 | 59 | 40 | ||||
9523 | 132919 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002415.78178 | 2117399.35825 | 37.7941109881849 | -122.435616701668 | (37.7941109881849, -122.435616701668) | 13 | 9 | 1 | 29490 | 27 | |||
9583 | 259871 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 901x Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
9619 | 75308 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6002852.68268 | 2092471.30856 | 37.7256893707662 | -122.43232378004 | (37.7256893707662, -122.43232378004) | 9 | 7 | 6 | 28861 | 5 | ||
9639 | 98171 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 462 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 7.5x7.5 | 6003453.57489 | 2090734.81251 | 37.7209553916669 | -122.430122719882 | (37.7209553916669, -122.430122719882) | 9 | 7 | 6 | 28861 | 5 | |||
9653 | 247307 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 311 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003219.2087 | 2109482.81 | 37.7724197383315 | -122.432271110524 | (37.7724197383315, -122.432271110524) | 15 | 9 | 11 | 29492 | 9 | |||
9673 | 73533 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2167 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988506.4537 | 2100580.6191 | 37.7471315320336 | -122.482510915675 | (37.7471315320336, -122.482510915675) | 1 | 8 | 3 | 29491 | 35 | |||
9719 | 116812 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3660x 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005401 | 2102665 | 37.7538231135776 | -122.42423909942 | (37.7538231135776, -122.42423909942) | 2 | 4 | 5 | 28859 | 19 | ||||
9769 | 72164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004416.60562 | 2120115.89629 | 37.8016833445826 | -122.42888739946 | (37.8016833445826, -122.42888739946) | 13 | 9 | 1 | 57 | 17 | |||
9786 | 72365 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 670 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5991322.83408 | 2110838.60197 | 37.7754606658684 | -122.47352031836 | (37.7754606658684, -122.47352031836) | 11 | 6 | 2 | 54 | 26 | |||
9825 | 259868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
9892 | 258923 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 900 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007771 | 2115657 | 37.7896296127826 | -122.416963519552 | (37.7896296127826, -122.416963519552) | 13 | 1 | 10 | 28858 | 21 | ||||
9947 | 216751 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 31 Granada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/30/2019 12:00:00 AM | 3 | Width 3ft | 5995599.77101 | 2090122.15974 | 37.7188252430706 | -122.457226507498 | (37.7188252430706, -122.457226507498) | 9 | 8 | 6 | 28861 | 24 | ||
10117 | 247028 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 550x Valley St | 6 | Median : Yard | Tree | DPW 1 | 10 | 6002355.44127 | 2099181.99154 | 37.7440871579993 | -122.434522308567 | (37.7440871579993, -122.434522308567) | 2 | 7 | 5 | 63 | 22 | ||||
10213 | 260647 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
10283 | 264747 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
10380 | 5959 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1499X Eddy St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 6 | 3X3 | 6003487.34677 | 2112767.17991 | 37.7814530042955 | -122.431578116755 | (37.7814530042955, -122.431578116755) | 15 | 9 | 11 | 29490 | 41 | ||
10446 | 139889 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1525 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002802.0633 | 2112323.8303 | 37.7801968120337 | -122.433917164161 | (37.7801968120337, -122.433917164161) | 15 | 5 | 11 | 29490 | 41 | |||
10481 | 211766 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 98 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992106.77002 | 2095921.08992 | 37.7345464383679 | -122.469722258175 | (37.7345464383679, -122.469722258175) | 9 | 8 | 4 | 59 | 40 | |||
10534 | 80777 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 307 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6012947.09697 | 2105591.10387 | 37.7622807541866 | -122.398348076615 | (37.7622807541866, -122.398348076615) | 10 | 3 | 8 | 28856 | 29 | |||
10573 | 234111 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2670 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010063.08718 | 2103410.40612 | 37.7561319733355 | -122.408169022303 | (37.7561319733355, -122.408169022303) | 2 | 4 | 7 | 28859 | 19 | |||
10587 | 72371 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 656 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5990684.35587 | 2110897.8962 | 37.7755864763334 | -122.475733274071 | (37.7755864763334, -122.475733274071) | 11 | 6 | 2 | 54 | 26 | |||
10596 | 98772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | 13 | 9 | 1 | 57 | 17 | |||
10625 | 8037 | 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 | 6 | 3X3 | 6005159.5163 | 2111612.2048 | 37.7783763628277 | -122.425710983373 | (37.7783763628277, -122.425710983373) | 7 | 9 | 11 | 28852 | 10 | ||
10692 | 72329 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2618 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5996593.28486 | 2110816.23096 | 37.7757030454034 | -122.455287065722 | (37.7757030454034, -122.455287065722) | 11 | 6 | 2 | 54 | 16 | |||
10726 | 113513 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 352 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008306 | 2113136 | 37.7827376375446 | -122.414933965724 | (37.7827376375446, -122.414933965724) | 7 | 10 | 9 | 28852 | 36 | ||||
10752 | 235093 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 40x Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007334 | 2098021 | 37.74118069243 | -122.417225263332 | (37.74118069243, -122.417225263332) | 2 | 7 | 7 | 28859 | 2 | |||
10763 | 194618 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012064.61514 | 2112283.75478 | 37.780608055269 | -122.401870744457 | (37.780608055269, -122.401870744457) | 6 | 2 | 9 | 28856 | 34 | |||
10781 | 194991 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016579.94443 | 2096258.22378 | 37.7368562975712 | -122.385132997804 | (37.7368562975712, -122.385132997804) | 10 | 3 | 8 | 58 | 1 | |||
10798 | 246087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999728.2562 | 2108429.1654 | 37.7693281401256 | -122.444270879733 | (37.7693281401256, -122.444270879733) | 15 | 5 | 11 | 29492 | 9 | |||
10825 | 133096 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1069 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006198.01577 | 2120713.57476 | 37.8034250849665 | -122.422765393206 | (37.8034250849665, -122.422765393206) | 5 | 9 | 1 | 28858 | 32 | |||
10842 | 7846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 885 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1997 12:00:00 AM | 3 | 4X4 | 6006112.07352 | 2113078.82451 | 37.7824571234444 | -122.422519969114 | (37.7824571234444, -122.422519969114) | 7 | 9 | 11 | 28852 | 41 | ||
10890 | 121828 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 286 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989971.23535 | 2113431.37554 | 37.782501338447 | -122.478385399006 | (37.782501338447, -122.478385399006) | 11 | 6 | 2 | 55 | 26 | |||
10987 | 211628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 8 | Median : Cutout | Tree | DPW 1 | 14 | Width 6ft | 5994455.12768 | 2100116.98357 | 37.7462027717556 | -122.461907419396 | (37.7462027717556, -122.461907419396) | 1 | 8 | 4 | 29491 | 40 | |||
10992 | 98625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002285.2374 | 2120040.843 | 37.8013564005351 | -122.43625752619 | (37.8013564005351, -122.43625752619) | 13 | 9 | 1 | 57 | 17 | ||
11037 | 262112 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2021 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991247 | 2101647 | 37.7502185858925 | -122.473112177678 | (37.7502185858925, -122.473112177678) | 1 | 8 | 4 | 29491 | 12 | ||||
11072 | 73642 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1453 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002204.6528 | 2111546.6075 | 37.7780288334744 | -122.435928249132 | (37.7780288334744, -122.435928249132) | 15 | 5 | 11 | 29492 | 41 | |||
11146 | 246588 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 68 Waller St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6005380.13328 | 2109258.65002 | 37.7719265371042 | -122.42478030806 | (37.7719265371042, -122.42478030806) | 7 | 9 | 11 | 28852 | 10 | |||
11158 | 70931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007940.72744 | 2117762.47273 | 37.7954202679833 | -122.416525483181 | (37.7954202679833, -122.416525483181) | 5 | 1 | 10 | 28858 | 21 | |||
11162 | 194818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015745.50684 | 2114096.95158 | 37.785791421082 | -122.389263322262 | (37.785791421082, -122.389263322262) | 6 | 2 | 9 | 28856 | 6 | |||
11200 | 4249 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1995 12:00:00 AM | 12 | 4x4 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.430255820476 | (37.7474383143284, -122.430255820476) | 2 | 4 | 5 | 63 | 22 | ||
11210 | 262290 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
11250 | 235185 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4069 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002730.5706 | 2102373.10913 | 37.7528705036792 | -122.433453192728 | (37.7528705036792, -122.433453192728) | 2 | 4 | 5 | 28862 | 22 | |||
11278 | 194611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012143.7658 | 2112366.54969 | 37.7808398078518 | -122.401602743794 | (37.7808398078518, -122.401602743794) | 6 | 2 | 9 | 28856 | 34 | |||
11469 | 91857 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 146 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 3 | 3x3 | 5995340.54196 | 2106725.32469 | 37.7643985300215 | -122.459324265639 | (37.7643985300215, -122.459324265639) | 15 | 5 | 11 | 56 | 12 | ||
11473 | 181779 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1539 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5988409.0687 | 2098953.0386 | 37.7426569598489 | -122.482728406861 | (37.7426569598489, -122.482728406861) | 1 | 8 | 3 | 29491 | 35 | |||
11479 | 110887 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 800 INDIANA ST | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
11557 | 74123 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1810 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989871.6002 | 2113390.52641 | 37.7823833935167 | -122.47872710108 | (37.7823833935167, -122.47872710108) | 11 | 6 | 2 | 55 | 26 | |||
11780 | 73541 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1944 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003405.1717 | 2115462.6704 | 37.7888494837108 | -122.432054945508 | (37.7888494837108, -122.432054945508) | 13 | 9 | 1 | 29490 | 27 | |||
11867 | 262287 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
11869 | 181032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/24/2017 12:14:00 PM | 3 | Width 4ft | 6000613.84351 | 2088248.98957 | 37.7139686369286 | -122.439760670618 | (37.7139686369286, -122.439760670618) | 9 | 7 | 6 | 28861 | 5 | ||
11889 | 246929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 349 Frederick St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.449096088512 | (37.7668065294199, -122.449096088512) | 15 | 5 | 11 | 29492 | 9 | |||
11902 | 245438 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2940 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6007245.2483 | 2106773.8474 | 37.7652090208421 | -122.418152529971 | (37.7652090208421, -122.418152529971) | 8 | 4 | 7 | 28853 | 19 | |||
12111 | 20037 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | ST | |||||||||||||
12176 | 8052 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 604 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
12251 | 180667 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 344 Chicago Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:51:00 PM | 3 | Width 6ft | 6002403.88387 | 2086502.6359 | 37.7092752595273 | -122.43344890204 | (37.7092752595273, -122.43344890204) | 9 | 7 | 6 | 28861 | 5 | ||
12283 | 69918 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1285 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986443.4748 | 2106504.0514 | 37.7632754302753 | -122.490080055854 | (37.7632754302753, -122.490080055854) | 1 | 8 | 3 | 56 | 35 | |||
12305 | 167317 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 95 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6001726.8082 | 2105314.2038 | 37.760889039807 | -122.437134941622 | (37.760889039807, -122.437134941622) | 15 | 4 | 5 | 28862 | 3 | |||
12367 | 20005 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY46 | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
12396 | 5267 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6001292.1098 | 2112753.8798 | 37.7812918154006 | -122.43917160516 | (37.7812918154006, -122.43917160516) | 15 | 5 | 11 | 29490 | 41 | |||
12419 | 9256 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6600X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 2 | 8M | 5986422.80447 | 2112533.30055 | 37.7798288450778 | -122.490595163822 | (37.7798288450778, -122.490595163822) | 11 | 6 | 2 | 55 | 26 | ||
12425 | 132893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2625 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001143.29931 | 2117400.39133 | 37.7940414678908 | -122.440019689778 | (37.7940414678908, -122.440019689778) | 13 | 9 | 1 | 57 | 27 | |||
12466 | 16906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 444 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004850.54878 | 2110241.10729 | 37.774594200606 | -122.426682154766 | (37.774594200606, -122.426682154766) | 7 | 9 | 11 | 28852 | 10 | |||
12523 | 132728 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2659 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6000218.30691 | 2118493.83649 | 37.7969910787183 | -122.443298822996 | (37.7969910787183, -122.443298822996) | 13 | 9 | 1 | 57 | 17 | |||
12528 | 234291 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 587 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007896.37215 | 2104512.06659 | 37.7590353212501 | -122.415740278805 | (37.7590353212501, -122.415740278805) | 2 | 4 | 7 | 28859 | 19 | |||
12543 | 132866 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3100 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999294.28359 | 2116345.32704 | 37.7910391073126 | -122.446341515442 | (37.7910391073126, -122.446341515442) | 13 | 6 | 1 | 29490 | 31 | |||
12552 | 261008 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 715 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | 4x4 | 5990636 | 2110495 | 37.774477430199 | -122.475871117318 | (37.774477430199, -122.475871117318) | 11 | 6 | 2 | 55 | 26 |
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) );