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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5994 | 5994 | 2704 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003159.9198 | 2114801.1722 | 37.787019270384796 | -122.432856206227 | (37.7870192703848, -122.432856206227) | |||
| 5997 | 5997 | 18963 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000852.056369999 | 2115577.81636 | 37.7890205682008 | -122.440896610616 | (37.7890205682008, -122.440896610616) | |||
| 6032 | 6032 | 95646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6004836.79342 | 2119482.75507 | 37.799968675576295 | -122.42738822690201 | (37.7999686755763, -122.427388226902) | |||
| 6035 | 6035 | 20185 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 12 | 3X3 | 6002809.2005 | 2112427.5414 | 37.7804819817185 | -122.43389988853001 | (37.7804819817185, -122.43389988853) | ||
| 6041 | 6041 | 18960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000879.73218 | 2115589.7344400003 | 37.7890548683423 | -122.440801711449 | (37.7890548683423, -122.440801711449) | |||
| 6109 | 6109 | 18931 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2711 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001680.91742 | 2115644.75135 | 37.789251525792295 | -122.438033662046 | (37.7892515257923, -122.438033662046) | |||
| 6134 | 6134 | 8185 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1231 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 6 | 3X3 | 6001830.167 | 2111146.7455 | 37.7769096322666 | -122.43719508955401 | (37.7769096322666, -122.437195089554) | ||
| 6186 | 6186 | 8021 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 457 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/1992 12:00:00 AM | 12 | 3X3 | Permit Number 772922 | 6005607.2143 | 2111677.1526 | 37.778579981846 | -122.42416684735001 | (37.778579981846, -122.42416684735) | |
| 6237 | 6237 | 2645 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1922 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6004273.4414 | 2115014.6406 | 37.7876684938964 | -122.42901889648998 | (37.7876684938964, -122.42901889649) | |||
| 6240 | 6240 | 22745 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1575 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 12 | 3x3 | 6002666.0178 | 2112306.9092 | 37.7801426296316 | -122.434386597187 | (37.7801426296316, -122.434386597187) | ||
| 6276 | 6276 | 26957 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 890 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003645.2355 | 2110757.4997 | 37.775943869260296 | -122.43088843048001 | (37.7759438692603, -122.43088843048) | |||
| 6331 | 6331 | 18947 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2825 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1990 12:00:00 AM | 10 | 3X3 | 6001281.31477 | 2115592.7384200003 | 37.7890859785766 | -122.439412506176 | (37.7890859785766, -122.439412506176) | ||
| 6386 | 6386 | 23474 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2363 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3X3 | 6005814.245619999 | 2118536.7552400003 | 37.797426433331104 | -122.42393856062401 | (37.7974264333311, -122.423938560624) | |||
| 6430 | 6430 | 19274 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1357 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2x2 | 6001742.1262 | 2113132.6584 | 37.782357442099 | -122.437641907141 | (37.782357442099, -122.437641907141) | |||
| 6458 | 6458 | 2638 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1902 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6004294.2274 | 2115016.9501 | 37.787676011765 | -122.428947145676 | (37.787676011765, -122.428947145676) | |||
| 6523 | 6523 | 2219 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1200X Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1992 12:00:00 AM | 3 | 4X4 | 6000837.1863 | 2112865.3051 | 37.7815718639656 | -122.4407534082 | (37.7815718639656, -122.4407534082) | ||
| 6529 | 6529 | 19276 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1375 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6001733.3273 | 2113193.2359 | 37.782523272226 | -122.437676687178 | (37.782523272226, -122.437676687178) | |||
| 6553 | 6553 | 19247 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2012 12:00:00 AM | 3 | 3X3 | 6002021.1577 | 2111125.9971 | 37.7768635173125 | -122.43653291011299 | (37.7768635173125, -122.436532910113) | ||
| 6565 | 6565 | 9626 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1412 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002726.9337 | 2112016.8817 | 37.7793497443727 | -122.434155122321 | (37.7793497443727, -122.434155122321) | |||
| 6575 | 6575 | 102823 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3295 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48877 | 5999143.78747 | 2115622.70016 | 37.7890463679361 | -122.446810205247 | (37.7890463679361, -122.446810205247) | ||
| 6608 | 6608 | 18948 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2832 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6001228.58337 | 2115631.47646 | 37.78918934215 | -122.439597727861 | (37.78918934215, -122.439597727861) | |||
| 6641 | 6641 | 5949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1445 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1990 12:00:00 AM | 9 | 3x3 | 6003539.6454 | 2112776.7434 | 37.7814822273864 | -122.431397871768 | (37.7814822273864, -122.431397871768) | ||
| 6736 | 6736 | 18847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2171 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004409.47419 | 2116033.3162599998 | 37.790473219721704 | -122.428620891643 | (37.7904732197217, -122.428620891643) | |||
| 6747 | 6747 | 27613 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1235 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003138.7984 | 2111681.5354 | 37.7784523340396 | -122.43270634933 | (37.7784523340396, -122.43270634933) | |||
| 6878 | 6878 | 19002 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3055 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000175.03289 | 2115441.15492 | 37.7886067496481 | -122.443229196567 | (37.7886067496481, -122.443229196567) | |||
| 6890 | 6890 | 19261 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1321 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001757.6936 | 2113025.0402 | 37.7820628349745 | -122.437580341502 | (37.7820628349745, -122.437580341502) | |||
| 6897 | 6897 | 54854 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 240 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 10 | 3x3 | Permit Number 10713 | 5998352.4011 | 2109746.0854 | 37.772865474065 | -122.44912476046001 | (37.772865474065, -122.44912476046) | |
| 6905 | 6905 | 18889 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2505 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 14 | 3X3 | 6002719.33455 | 2115789.29201 | 37.789707396626895 | -122.434451206367 | (37.7897073966269, -122.434451206367) | ||
| 6906 | 6906 | 49887 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1400 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52632 | 6006171.58963 | 2119369.0060900003 | 37.799731750966004 | -122.422761231158 | (37.799731750966, -122.422761231158) | |
| 6932 | 6932 | 36849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6956 | 6956 | 2655 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1998 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003984.7473 | 2114974.2234 | 37.78754117279421 | -122.43001483766001 | (37.7875411727942, -122.43001483766) | |||
| 7005 | 7005 | 9643 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1495 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1987 12:00:00 AM | 12 | 3x3 | 6002484.9621 | 2111928.892 | 37.77909441056521 | -122.43498590771699 | (37.7790944105652, -122.434985907717) | ||
| 7018 | 7018 | 18846 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2153 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004468.00056 | 2116036.9604599997 | 37.7904865377806 | -122.428418653923 | (37.7904865377806, -122.428418653923) | |||
| 7020 | 7020 | 8139 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 917 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1997 12:00:00 AM | 6 | 3X3 | 6003246.6025 | 2111344.3141 | 37.777532521537 | -122.432309324162 | (37.777532521537, -122.432309324162) | ||
| 7055 | 7055 | 2223 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1200X Broderick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 3 | 4X4 | 6000822.9726 | 2112969.5391 | 37.7818572544059 | -122.440810060021 | (37.7818572544059, -122.440810060021) | ||
| 7065 | 7065 | 34676 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2000 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2015 12:00:00 AM | 3 | Permit Number 775668 | 6003314.31901 | 2118972.51824 | 37.7984814738846 | -122.432620094941 | (37.7984814738846, -122.432620094941) | |
| 7163 | 7163 | 5975 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 6 | 3X3 | 6002886.6721 | 2112731.722 | 37.7813215813471 | -122.43365362378 | (37.7813215813471, -122.43365362378) | ||
| 7165 | 7165 | 20180 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2008 12:00:00 AM | 3 | 3X3 | 6002788.0753 | 2112583.2115 | 37.7809082138909 | -122.433984101181 | (37.7809082138909, -122.433984101181) | ||
| 7177 | 7177 | 18974 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2915X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6000806.62315 | 2115529.84853 | 37.7888862733176 | -122.44105036048201 | (37.7888862733176, -122.441050360482) | |||
| 7184 | 7184 | 58253 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600X North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1978 12:00:00 AM | 10 | 3x3 | Permit Number 47562 | 6002971.35557 | 2121006.35225 | 37.8040463950837 | -122.433952309277 | (37.8040463950837, -122.433952309277) | |
| 7241 | 7241 | 18843 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2121 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1994 12:00:00 AM | 6 | 3x3 | 6004600.36718 | 2116052.01819 | 37.79053537185071 | -122.427961747031 | (37.7905353718507, -122.427961747031) | ||
| 7254 | 7254 | 59145 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 636 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 18453 | 6001100.9535 | 2110936.3987 | 37.776290594205605 | -122.439702571656 | (37.7762905942056, -122.439702571656) | |
| 7258 | 7258 | 5948 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1445 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1990 12:00:00 AM | 6 | 3x3 | 6003514.9369 | 2112774.3523 | 37.7814742616502 | -122.43148318047399 | (37.7814742616502, -122.431483180474) | ||
| 7300 | 7300 | 36853 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7327 | 7327 | 9518 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1039 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004639.6152 | 2112232.8654 | 37.780051151736295 | -122.427553745606 | (37.7800511517363, -122.427553745606) | |||
| 7351 | 7351 | 14821 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003174.5811 | 2111728.4441 | 37.7785831629181 | -122.432585915124 | (37.7785831629181, -122.432585915124) | |||
| 7355 | 7355 | 9645 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1521 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002120.8202 | 2111880.4977 | 37.7789408493567 | -122.43624215643699 | (37.7789408493567, -122.436242156437) | |||
| 7370 | 7370 | 18933 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2713 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001657.24685 | 2115643.17685 | 37.7892458564681 | -122.43811544637899 | (37.7892458564681, -122.438115446379) | |||
| 7442 | 7442 | 1549 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 521 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 5995574.90365 | 2112668.93283 | 37.780731590921704 | -122.458944048869 | (37.7807315909217, -122.458944048869) | |||
| 7552 | 7552 | 2646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1936 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004216.8574 | 2115005.9798 | 37.787641510438704 | -122.42921404836001 | (37.7876415104387, -122.42921404836) | |||
| 7612 | 7612 | 8137 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 915 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003289.2524 | 2111349.2992 | 37.7775486275955 | -122.432162140105 | (37.7775486275955, -122.432162140105) | |||
| 7614 | 7614 | 20156 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002897.8994 | 2112109.7603 | 37.7796144675148 | -122.43357032043899 | (37.7796144675148, -122.433570320439) | |||
| 7631 | 7631 | 5973 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6002959.8275 | 2112741.1155 | 37.7813515241569 | -122.43340121360201 | (37.7813515241569, -122.433401213602) | ||
| 7659 | 7659 | 9621 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1402 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002809.5086 | 2112030.0801 | 37.779390670103 | -122.43387040511001 | (37.779390670103, -122.43387040511) | |||
| 7678 | 7678 | 5326 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2880X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000992.53955 | 2115601.11953 | 37.7890925526217 | -122.44041223036001 | (37.7890925526217, -122.44041223036) | |||
| 7778 | 7778 | 7847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1998 12:00:00 AM | 6 | 4X4 | 6006117.43642 | 2113052.23371 | 37.7823844141639 | -122.422499525741 | (37.7823844141639, -122.422499525741) | ||
| 7839 | 7839 | 9623 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1406 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002777.3585 | 2112024.327 | 37.7793730490544 | -122.43398121435699 | (37.7793730490544, -122.433981214357) | |||
| 7845 | 7845 | 36850 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7866 | 7866 | 8140 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 921 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003210.0456 | 2111338.7752 | 37.777515240203 | -122.43243539088999 | (37.777515240203, -122.43243539089) | |||
| 7867 | 7867 | 2211 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1151 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000821.1113 | 2112668.1744 | 37.781029677969606 | -122.440794874823 | (37.7810296779696, -122.440794874823) | |||
| 7928 | 7928 | 62385 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/1987 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.776345899243495 | -122.439713770865 | (37.7763458992435, -122.439713770865) | |
| 7975 | 7975 | 18973 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2915X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5X5 | 6000788.70435 | 2115527.04416 | 37.7888775526164 | -122.441112155629 | (37.7888775526164, -122.441112155629) | |||
| 8013 | 8013 | 8113 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 829 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003793.1849 | 2111419.9764 | 37.7777712482613 | -122.430423913429 | (37.7777712482613, -122.430423913429) | |||
| 8092 | 8092 | 2671 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2050 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003681.6186 | 2114932.6684 | 37.7874099012465 | -122.431060634902 | (37.7874099012465, -122.431060634902) | |||
| 8103 | 8103 | 8123 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 859 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003663.0244 | 2111402.3379 | 37.7777154433816 | -122.43087292423901 | (37.7777154433816, -122.430872924239) | |||
| 8107 | 8107 | 19269 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1350 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6001770.5537 | 2113186.4674 | 37.7825068042206 | -122.437547415347 | (37.7825068042206, -122.437547415347) | |||
| 8118 | 8118 | 22724 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1525 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002722.8726 | 2112317.7387 | 37.7801755917615 | -122.43419068516 | (37.7801755917615, -122.43419068516) | |||
| 8181 | 8181 | 19264 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1333 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6001752.6173 | 2113056.8519 | 37.782149893204 | -122.437600182055 | (37.782149893204, -122.437600182055) | |||
| 8198 | 8198 | 22646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1252 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6003993.9681 | 2112542.7326 | 37.7808654300005 | -122.429809438129 | (37.7808654300005, -122.429809438129) | ||
| 8201 | 8201 | 18961 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000876.56799 | 2115580.69562 | 37.7890298698849 | -122.44081201046001 | (37.7890298698849, -122.44081201046) | |||
| 8203 | 8203 | 18844 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2135 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1993 12:00:00 AM | 8 | 3x3 | 6004541.200019999 | 2116043.53648 | 37.790508735738605 | -122.428165857165 | (37.7905087357386, -122.428165857165) | ||
| 8215 | 8215 | 58354 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1245 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 16 | 3x3 | Permit Number 17381 | 6008942.95014 | 2117240.15373 | 37.794042420261 | -122.41302066326999 | (37.794042420261, -122.41302066327) | |
| 8225 | 8225 | 13168 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1920 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003163.0836 | 2119646.9456 | 37.8003246983453 | -122.43319163061001 | (37.8003246983453, -122.43319163061) | |||
| 8256 | 8256 | 22737 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1560 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1997 12:00:00 AM | 12 | 3X3 | 6002411.6938 | 2112321.6305 | 37.78016861134 | -122.435267471873 | (37.78016861134, -122.435267471873) | ||
| 8264 | 8264 | 18965 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900X Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000839.53019 | 2115578.71127 | 37.7890223119783 | -122.440940013671 | (37.7890223119783, -122.440940013671) | |||
| 8269 | 8269 | 18872 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2299 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003854.12399 | 2115951.53057 | 37.790217212412706 | -122.430536529449 | (37.7902172124127, -122.430536529449) | |||
| 8296 | 8296 | 19266 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1348 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6001782.06 | 2113143.1494 | 37.7823885181829 | -122.43750450558001 | (37.7823885181829, -122.43750450558) | |||
| 8316 | 8316 | 9646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1525 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2001 12:00:00 AM | 3 | 3X3 | 6002070.3954 | 2111870.0066 | 37.778909178338296 | -122.436415844629 | (37.7789091783383, -122.436415844629) | ||
| 8342 | 8342 | 27614 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1235 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003172.1537 | 2111686.4275 | 37.778467658147996 | -122.43259131039801 | (37.778467658148, -122.432591310398) | |||
| 8477 | 8477 | 5251 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1145 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2009 12:00:00 AM | 12 | 3X3 | 6001347.7802 | 2112334.4059 | 37.7801432143075 | -122.438948942838 | (37.7801432143075, -122.438948942838) | ||
| 8509 | 8509 | 52869 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3295 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48877 | 5999115.05845 | 2115618.33019 | 37.789032727914204 | -122.44690928895399 | (37.7890327279142, -122.446909288954) | |
| 8537 | 8537 | 22777 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1998 12:00:00 AM | 6 | 3X3 | 6001348.5222 | 2112174.4942 | 37.7797041795705 | -122.43893491272699 | (37.7797041795705, -122.438934912727) | ||
| 8539 | 8539 | 8130 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 903 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 6 | 3X3 | 6003337.4411 | 2111356.4998 | 37.7775711306908 | -122.43199595367099 | (37.7775711306908, -122.431995953671) | ||
| 8549 | 8549 | 19262 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1335 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6001750.5868 | 2113073.4345 | 37.7821953093639 | -122.43760839459101 | (37.7821953093639, -122.437608394591) | |||
| 8561 | 8561 | 52868 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3295 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48877 | 5999101.91152 | 2115616.94773 | 37.789028180956 | -122.446954675917 | (37.789028180956, -122.446954675917) |
| 8567 | 8567 | 51150 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600X North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 47562 | 6003006.23372 | 2121010.1513799997 | 37.804058805743 | -122.43383188285802 | (37.804058805743, -122.433831882858) | ||
| 8612 | 8612 | 19255 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1310 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6001804.0574 | 2112951.6027 | 37.7818638301852 | -122.43741468379801 | (37.7818638301852, -122.437414683798) | |||
| 8618 | 8618 | 8020 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 457 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/1992 12:00:00 AM | 12 | 3X3 | 6005596.7202 | 2111675.0538 | 37.778573626526104 | -122.424203001193 | (37.7785736265261, -122.424203001193) | ||
| 8637 | 8637 | 53285 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2641 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1969 12:00:00 AM | 20 | 4x5 | Permit Number 6175 | 6005287.315119999 | 2119080.31652 | 37.798889151862 | -122.425800588941 | (37.798889151862, -122.425800588941) | |
| 8673 | 8673 | 2652 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1960 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004122.1657 | 2114993.8546 | 37.7876028567046 | -122.42954079807 | (37.7876028567046, -122.42954079807) | |||
| 8681 | 8681 | 7853 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 900 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6006134.704469999 | 2113310.2694200003 | 37.7830938911053 | -122.422458126364 | (37.7830938911053, -122.422458126364) | |||
| 8682 | 8682 | 54373 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1972 12:00:00 AM | 12 | 3x3 | Permit Number 10139 | 6004812.50381 | 2119479.6548200003 | 37.7999587893161 | -122.42747205721001 | (37.7999587893161, -122.42747205721) | |
| 8706 | 8706 | 9539 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | ||
| 8707 | 8707 | 14642 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 600X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1992 12:00:00 AM | 8 | 4x4 | 6006116.02946 | 2112145.75768 | 37.7798953731192 | -122.422439963656 | (37.7798953731192, -122.422439963656) | ||
| 8722 | 8722 | 9624 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1408 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002760.7759 | 2112022.2964 | 37.7793665324534 | -122.434038435276 | (37.7793665324534, -122.434038435276) | |||
| 8737 | 8737 | 18944 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2799X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 6001495.26118 | 2115620.92887 | 37.789175555553996 | -122.43867430129801 | (37.789175555554, -122.438674301298) | ||
| 8738 | 8738 | 23769 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003798.9822 | 2112259.587 | 37.780076939071 | -122.430463780858 | (37.780076939071, -122.430463780858) | |||
| 8745 | 8745 | 19265 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1348 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001785.4442 | 2113118.7831 | 37.782321806917 | -122.437491052318 | (37.782321806917, -122.437491052318) | |||
| 8768 | 8768 | 8076 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 675 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1993 12:00:00 AM | 6 | 3x3 | 6004503.1654 | 2111520.8482 | 37.778088409359 | -122.42797503505899 | (37.778088409359, -122.427975035059) | ||
| 8808 | 8808 | 18849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2171 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004446.32787 | 2116035.79042 | 37.7904820987296 | -122.42849355665001 | (37.7904820987296, -122.42849355665) |
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");