Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, PermitNotes
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 5565 | 5565 | 18845 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2135 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2016 03:13:00 PM | 3 | 3x3 | 6004567.763809999 | 2116045.68372 | 37.7905161344505 | -122.428074101148 | (37.7905161344505, -122.428074101148) | ||
| 5582 | 5582 | 20186 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 12 | 3X3 | 6002813.3025 | 2112396.3664 | 37.78039661577 | -122.433883468838 | (37.78039661577, -122.433883468838) | ||
| 5584 | 5584 | 2623 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1810 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 9 | 3X3 | 6004694.7357 | 2115072.9947 | 37.787852557835706 | -122.42756545836599 | (37.7878525578357, -122.427565458366) | ||
| 5611 | 5611 | 22669 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1301 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003694.9541 | 2112452.7229 | 37.780601348717 | -122.43083744803499 | (37.780601348717, -122.430837448035) | |||
| 5623 | 5623 | 19242 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 707 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/2012 12:00:00 AM | 3 | 3X3 | 6002040.9749 | 2110967.2112 | 37.776428657122395 | -122.43645298909901 | (37.7764286571224, -122.436452989099) | ||
| 5627 | 5627 | 27603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 6003200.8903 | 2111391.8168 | 37.77766036009189 | -122.43247085155501 | (37.7776603600919, -122.432470851555) | |||
| 5645 | 5645 | 9433 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 727 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006000.20886 | 2112421.0496400003 | 37.7806447233077 | -122.42286020963199 | (37.7806447233077, -122.422860209632) | |||
| 5674 | 5674 | 2605 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2011 12:00:00 AM | 3 | 3x3 | 6005035.0389 | 2115121.5009 | 37.788004986085895 | -122.42639152665001 | (37.7880049860859, -122.42639152665) | ||
| 5725 | 5725 | 18975 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2915X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000830.69631 | 2115532.1014400003 | 37.7888938303451 | -122.440967232554 | (37.7888938303451, -122.440967232554) | |||
| 5791 | 5791 | 5992 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1675 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002425.8303 | 2112618.0961 | 37.7809834340029 | -122.435239778846 | (37.7809834340029, -122.435239778846) | |||
| 5821 | 5821 | 13219 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2233 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001704.3053 | 2119361.4174 | 37.7994578530016 | -122.438219104839 | (37.7994578530016, -122.438219104839) | ||
| 5895 | 5895 | 18863 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2224 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003936.17366 | 2116009.64602 | 37.7903814304031 | -122.430256791725 | (37.7903814304031, -122.430256791725) | |||
| 5937 | 5937 | 21745 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2053 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002761.9991 | 2114399.8594 | 37.7858947903994 | -122.434204220723 | (37.7858947903994, -122.434204220723) | |||
| 5970 | 5970 | 18896 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2555 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002535.92495 | 2115763.84644 | 37.789627116838005 | -122.435083963947 | (37.789627116838, -122.435083963947) | |||
| 5972 | 5972 | 21744 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2045 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002980.1505 | 2114436.9349 | 37.7860089694907 | -122.433452128346 | (37.7860089694907, -122.433452128346) | |||
| 6108 | 6108 | 20197 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002792.1678 | 2112863.231 | 37.7816773092935 | -122.43398996532301 | (37.7816773092935, -122.433989965323) | ||
| 6182 | 6182 | 8032 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 555 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.778311728407104 | -122.426254616894 | (37.7783117284071, -122.426254616894) | |||
| 6194 | 6194 | 18986 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2927 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000773.77883 | 2115525.0246900003 | 37.788871157515004 | -122.44116365078999 | (37.788871157515, -122.44116365079) | |||
| 6195 | 6195 | 5203 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 773 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2011 12:00:00 AM | 3 | 4x4 | 6001531.5367 | 2111004.3927 | 37.7765017872485 | -122.438217940497 | (37.7765017872485, -122.438217940497) | ||
| 6202 | 6202 | 9755 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 725 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/1997 12:00:00 AM | 16 | 4x4 | 6005757.8268 | 2112173.6531 | 37.7799517537853 | -122.423681131146 | (37.7799517537853, -122.423681131146) | ||
| 6229 | 6229 | 20177 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002831.7078 | 2112581.7505 | 37.780906678417104 | -122.433833050629 | (37.7809066784171, -122.433833050629) | ||
| 6234 | 6234 | 9428 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 727 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005875.6191 | 2112402.13001 | 37.7805857439866 | -122.42328988052799 | (37.7805857439866, -122.423289880528) | |||
| 6255 | 6255 | 5277 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1343 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001253.1913 | 2113044.9225 | 37.7820887298486 | -122.43932711157301 | (37.7820887298486, -122.439327111573) | |||
| 6316 | 6316 | 27615 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1235 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003202.3958 | 2111689.9854 | 37.778479142224995 | -122.432486945826 | (37.778479142225, -122.432486945826) |
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");