Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
97 | 97 | 5266 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.43918115910401 | (37.781343716873, -122.439181159104) | |||
153 | 153 | 5972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.43311045884899 | (37.7813844410266, -122.433110458849) | ||
234 | 234 | 26932 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1570 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2000 12:00:00 AM | 3 | 3X3 | 6002097.1307 | 2111930.5841 | 37.7790770280177 | -122.43632769328998 | (37.7790770280177, -122.43632769329) | ||
264 | 264 | 20199 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | ||
309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
329 | 329 | 5267 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6001292.1098 | 2112753.8798 | 37.7812918154006 | -122.43917160516001 | (37.7812918154006, -122.43917160516) | |||
337 | 337 | 14819 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | |||
463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
590 | 590 | 98625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002285.2374 | 2120040.8430000003 | 37.8013564005351 | -122.43625752618999 | (37.8013564005351, -122.43625752619) | ||
616 | 616 | 8142 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.777707304798206 | -122.432059137251 | (37.7777073047982, -122.432059137251) | |||
871 | 871 | 20198 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002788.752 | 2112893.404 | 37.7817599629104 | -122.43400393984501 | (37.7817599629104, -122.434003939845) | ||
957 | 957 | 141829 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1058 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | 6004468.2701 | 2112261.9634 | 37.780121354581105 | -122.42814858004101 | (37.7801213545811, -122.428148580041) | |||
1110 | 1110 | 14853 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1351 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6002697.0103 | 2111613.4514 | 37.778240327396105 | -122.434229790526 | (37.7782403273961, -122.434229790526) | ||
1142 | 1142 | 20178 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002826.2747 | 2112615.9016 | 37.781000140452704 | -122.433854288088 | (37.7810001404527, -122.433854288088) | ||
1236 | 1236 | 9417 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 4X4 | 6006077.70084 | 2112484.44584 | 37.7808231658948 | -122.422596633642 | (37.7808231658948, -122.422596633642) | ||
1268 | 1268 | 221739 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 960 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 5997261.09109 | 2107110.0824 | 37.7655652095945 | -122.452709425124 | (37.7655652095945, -122.452709425124) | |||
1331 | 1331 | 14830 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1284 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003046.0718 | 2111709.6378 | 37.778524236985895 | -122.433029133637 | (37.7785242369859, -122.433029133637) | |||
1351 | 1351 | 5208 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001567.0603 | 2111230.6559 | 37.777125069374705 | -122.438111266341 | (37.7771250693747, -122.438111266341) | |||
1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
1449 | 1449 | 234076 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12 | Width 4ft | 6011147.1312 | 2101589.6307 | 37.751193164657 | -122.40429186329901 | (37.751193164657, -122.404291863299) | |||
1454 | 1454 | 234074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.8522900003 | 37.751468148541996 | -122.40431145682301 | (37.751468148542, -122.404311456823) | |||
1461 | 1461 | 234073 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | |||
1464 | 1464 | 234075 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.75130354562771 | -122.404297986789 | (37.7513035456277, -122.404297986789) | |||
1724 | 1724 | 14824 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003110.3265 | 2111720.6082 | 37.7785580034409 | -122.43280763628599 | (37.7785580034409, -122.432807636286) | |||
1744 | 1744 | 9601 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6003062.4207 | 2112013.0769 | 37.7793583323419 | -122.432994261414 | (37.7793583323419, -122.432994261414) | |||
1821 | 1821 | 21741 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002908.4575 | 2114420.548 | 37.7859599074732 | -122.433698994827 | (37.7859599074732, -122.433698994827) | |||
1845 | 1845 | 98642 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002233.86885 | 2120387.2869599997 | 37.8023047257379 | -122.436460093962 | (37.8023047257379, -122.436460093962) | ||
1887 | 1887 | 20008 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
1922 | 1922 | 14822 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003155.2525 | 2111726.3545 | 37.778576329265 | -122.432652630798 | (37.778576329265, -122.432652630798) | |||
1986 | 1986 | 251131 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
2036 | 2036 | 11448 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:09:00 PM | 3 | 3 | 5995519.82754 | 2115841.84115 | 37.789440378559796 | -122.45936442896799 | (37.7894403785598, -122.459364428968) | ||
2044 | 2044 | 20173 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002849.1714 | 2112441.6535 | 37.780522998189795 | -122.43376261941201 | (37.7805229981898, -122.433762619412) | ||
2130 | 2130 | 18891 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2513 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1990 12:00:00 AM | 8 | 3X3 | 6002620.56709 | 2115777.954 | 37.7896706584215 | -122.434792120457 | (37.7896706584215, -122.434792120457) | ||
2181 | 2181 | 98628 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x4 | 6002274.71062 | 2120096.76485 | 37.801509349129795 | -122.43629795788999 | (37.8015093491298, -122.43629795789) | ||
2243 | 2243 | 20174 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002845.6787 | 2112476.9688 | 37.7806197669525 | -122.433777227143 | (37.7806197669525, -122.433777227143) | ||
2375 | 2375 | 14825 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003082.6395 | 2111715.9066 | 37.7785435236875 | -122.432903080133 | (37.7785435236875, -122.432903080133) | |||
2474 | 2474 | 13234 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2301X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001261.9345 | 2119300.1034 | 37.7992643314035 | -122.439745463198 | (37.7992643314035, -122.439745463198) | |||
2495 | 2495 | 13230 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2301X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001287.1241 | 2119305.7914 | 37.7992813828917 | -122.439658706658 | (37.7992813828917, -122.439658706658) | |||
2545 | 2545 | 138184 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1865 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | 6003938.7944 | 2114760.9916 | 37.7869530894134 | -122.430158607711 | (37.7869530894134, -122.430158607711) | |||
2558 | 2558 | 98632 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x4 | 6002258.48202 | 2120196.40471 | 37.801782011886 | -122.43636125128799 | (37.801782011886, -122.436361251288) | ||
2790 | 2790 | 20006 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
2925 | 2925 | 26961 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2075X Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002606.079 | 2114377.3094 | 37.7858240230682 | -122.434742047375 | (37.7858240230682, -122.434742047375) | |||
3124 | 3124 | 20200 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2005 12:00:00 AM | 3 | 3X3 | 6002780.7817 | 2112950.9036 | 37.78191739001421 | -122.434035624824 | (37.7819173900142, -122.434035624824) | ||
3310 | 3310 | 8019 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 457 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1992 12:00:00 AM | 12 | 3X3 | 6005584.1273 | 2111672.955 | 37.7785671526871 | -122.42424641558901 | (37.7785671526871, -122.424246415589) | ||
3312 | 3312 | 19273 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001744.1568 | 2113114.3836 | 37.7823073795972 | -122.437633572993 | (37.7823073795972, -122.437633572993) | |||
3333 | 3333 | 140460 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1410 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/1996 12:00:00 AM | 5 | Width 0ft | 6003106.8567 | 2112412.5475 | 37.780457699101206 | -122.432869084795 | (37.7804576991012, -122.432869084795) | ||
3341 | 3341 | 8013 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 440 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2014 12:00:00 AM | 3 | 3X3 | 6005616.7891 | 2111728.1123 | 37.7787204453524 | -122.424137349487 | (37.7787204453524, -122.424137349487) | ||
3359 | 3359 | 20213 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6002747.1929 | 2113184.3178 | 37.7825563803095 | -122.4341685179 | (37.7825563803095, -122.4341685179) | |||
3431 | 3431 | 98631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 4x4 | 6002262.16905 | 2120180.85898 | 37.801739536897294 | -122.436347379249 | (37.8017395368973, -122.436347379249) | ||
3436 | 3436 | 100973 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 0 | Permit Number 37341 | 6009614.0 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | ||
3461 | 3461 | 9635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1455 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 3 | 3X3 | 6002683.6157 | 2111959.35 | 37.7791893181143 | -122.43430086301201 | (37.7791893181143, -122.434300863012) | ||
3475 | 3475 | 236136 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 44 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2014 12:00:00 AM | 3 | Width 4ft | 6006544.21691 | 2110371.8259 | 37.775048730543205 | -122.42083269437201 | (37.7750487305432, -122.420832694372) | ||
3508 | 3508 | 21563 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1450 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005662.55853 | 2114856.43275 | 37.7873126270251 | -122.424201559266 | (37.7873126270251, -122.424201559266) | |||
3652 | 3652 | 8053 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 608 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/1990 12:00:00 AM | 30 | 3X3 | 6004781.8955 | 2111614.8115 | 37.778362174466295 | -122.427017501013 | (37.7783621744663, -122.427017501013) | ||
3653 | 3653 | 18293 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2000 Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002259.4651 | 2114036.7138 | 37.7848691499899 | -122.435916853386 | (37.7848691499899, -122.435916853386) | |||
3778 | 3778 | 23411 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1755 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006198.56305 | 2116531.68812 | 37.7919427119246 | -122.42246617527799 | (37.7919427119246, -122.422466175278) | |||
3895 | 3895 | 20182 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002796.4844 | 2112525.5787 | 37.7807504459126 | -122.433950889197 | (37.7807504459126, -122.433950889197) | |||
4056 | 4056 | 6316 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1830 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002062.1887 | 2112973.0079 | 37.7819372750965 | -122.43652320334299 | (37.7819372750965, -122.436523203343) | |||
4107 | 4107 | 98607 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002988.210519999 | 2116859.68166 | 37.792661671341705 | -122.43359745208599 | (37.7926616713417, -122.433597452086) | ||
4193 | 4193 | 14866 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1399 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002549.1256 | 2111595.7053 | 37.7781832063518 | -122.434740108006 | (37.7781832063518, -122.434740108006) | |||
4204 | 4204 | 18292 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2000 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1993 12:00:00 AM | 6 | 4X4 | 6002281.8567 | 2114040.95 | 37.7848820534936 | -122.43583968903 | (37.7848820534936, -122.43583968903) | ||
4280 | 4280 | 6310 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1810 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002083.1708 | 2112974.3616 | 37.7819421842971 | -122.43645071198 | (37.7819421842971, -122.43645071198) | |||
4453 | 4453 | 253083 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:53:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4463 | 4463 | 14823 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6003134.879 | 2111723.2201 | 37.778566567554 | -122.432722886511 | (37.778566567554, -122.432722886511) | ||
4493 | 4493 | 253082 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:25:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4525 | 4525 | 23475 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2363 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6005818.66321 | 2118523.8401900004 | 37.7973912212721 | -122.42392235573601 | (37.7973912212721, -122.423922355736) | |||
4554 | 4554 | 18291 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2000 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002309.6948 | 2114045.1862 | 37.7848952663203 | -122.435743681544 | (37.7848952663203, -122.435743681544) | ||
4564 | 4564 | 142521 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.41142249927401 | (37.8048839283261, -122.411422499274) | ||
4571 | 4571 | 142549 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.41079549257799 | (37.8049613971858, -122.410795492578) | |||
4573 | 4573 | 142546 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | ||
4581 | 4581 | 142526 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | |||
4583 | 4583 | 142550 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.805015586162796 | -122.41038927752199 | (37.8050155861628, -122.410389277522) | ||
4590 | 4590 | 142522 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.804975764730294 | -122.410719306308 | (37.8049757647303, -122.410719306308) | |||
4591 | 4591 | 142544 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.41125134413299 | (37.8049064021217, -122.411251344133) | ||
4595 | 4595 | 142523 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.804977071531404 | -122.410638645677 | (37.8049770715314, -122.410638645677) | |||
4612 | 4612 | 142548 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | |||
4618 | 4618 | 20216 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002742.6384 | 2113206.5206 | 37.7826170851045 | -122.434185862237 | (37.7826170851045, -122.434185862237) | |||
4727 | 4727 | 253673 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 600 x Sanchez St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
4746 | 4746 | 206086 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1337 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 5 | Width 3ft | 5991588.39226 | 2106545.66282 | 37.7636887858255 | -122.472288687689 | (37.7636887858255, -122.472288687689) | ||
5174 | 5174 | 27604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | |
5175 | 5175 | 27606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.43266311980801 | (37.7776386560762, -122.432663119808) | |
5240 | 5240 | 8038 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005189.4271 | 2111616.4778 | 37.778389785584295 | -122.425607814865 | (37.7783897855843, -122.425607814865) | ||
5241 | 5241 | 18090 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3000 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999493.6958 | 2114692.3125 | 37.786511749732 | -122.44553264282699 | (37.786511749732, -122.445532642827) | |||
5255 | 5255 | 18091 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3000 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999467.4746 | 2114690.2424 | 37.786504568796296 | -122.44562321243299 | (37.7865045687963, -122.445623212433) | |||
5295 | 5295 | 6028 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1800 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001799.5064 | 2112579.1081 | 37.780840795713395 | -122.437403746471 | (37.7808407957134, -122.437403746471) | |||
5316 | 5316 | 20193 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002809.8162 | 2112741.4002 | 37.7813437940939 | -122.433920199287 | (37.7813437940939, -122.433920199287) | ||
5338 | 5338 | 2730 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2254 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002720.3576 | 2114799.1787 | 37.7869888561759 | -122.43437684858999 | (37.7869888561759, -122.43437684859) | |||
5352 | 5352 | 26155 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1801 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005663.23321 | 2116309.8802400003 | 37.7913034693206 | -122.424302638575 | (37.7913034693206, -122.424302638575) | |||
5359 | 5359 | 2607 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1992 12:00:00 AM | 6 | 3X3 | 6004969.2886 | 2115108.3508 | 37.787965162278205 | -122.426618074327 | (37.7879651622782, -122.426618074327) | ||
5366 | 5366 | 19799 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
5367 | 5367 | 22746 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1585 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002419.6467 | 2112271.0365 | 37.7800301445704 | -122.43523633930401 | (37.7800301445704, -122.435236339304) | |||
5399 | 5399 | 22679 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1345 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1993 12:00:00 AM | 12 | 3X3 | 6003639.8316 | 2112445.6772 | 37.780578879691504 | -122.43102763996201 | (37.7805788796915, -122.431027639962) | ||
5424 | 5424 | 18952 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2848 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001174.38746 | 2115625.67946 | 37.78917034037811 | -122.439784822813 | (37.7891703403781, -122.439784822813) | |||
5430 | 5430 | 8037 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 555 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/18/2015 12:00:00 AM | 6 | 3X3 | 6005159.5163 | 2111612.2048 | 37.7783763628277 | -122.425710983373 | (37.7783763628277, -122.425710983373) | ||
5471 | 5471 | 98637 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6002243.51572 | 2120296.51697 | 37.8020560434066 | -122.43642021082898 | (37.8020560434066, -122.436420210829) | ||
5486 | 5486 | 5961 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1510 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6003164.2072 | 2112768.442 | 37.7814381488904 | -122.432696112772 | (37.7814381488904, -122.432696112772) | ||
5492 | 5492 | 8001 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 355 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1992 12:00:00 AM | 12 | 3X3 | 6006046.8196 | 2111733.76797 | 37.7787602452394 | -122.422650106445 | (37.7787602452394, -122.422650106445) | ||
5496 | 5496 | 99696 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.794393599230204 | -122.41905900288799 | (37.7943935992302, -122.419059002888) | ||
5500 | 5500 | 8034 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 555 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/1997 12:00:00 AM | 6 | 3X3 | 6005040.4073 | 2111596.7153 | 37.7783271011631 | -122.426121923149 | (37.7783271011631, -122.426121923149) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");