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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151301 | 151301 | 44807 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1276 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 8 | Permit Number 43902 | 5986485.3888 | 2106571.9403 | 37.7634642819189 | -122.489940084577 | (37.7634642819189, -122.489940084577) | |
| 36759 | 36759 | 66335 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1354 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 4 | Permit Number 29456 | 5986504.5124 | 2106031.2188 | 37.7619807269847 | -122.48983417325 | (37.7619807269847, -122.48983417325) | |
| 47319 | 47319 | 66340 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1491 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | 7 | Permit Number 29461 | 5986488.9908 | 2105111.6589 | 37.759454962816704 | -122.48982022427401 | (37.7594549628167, -122.489820224274) | |
| 174962 | 174962 | 119546 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 741 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5986610.11945 | 2110793.83788 | 37.775063713954204 | -122.48981920355601 | (37.7750637139542, -122.489819203556) | |||
| 39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
| 118215 | 118215 | 121238 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 283 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5986785.0 | 2114050.0 | 37.7840144179764 | -122.489453742509 | (37.7840144179764, -122.489453742509) | |||
| 50640 | 50640 | 250891 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 245 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986795.664 | 2114287.51727 | 37.78466719476761 | -122.48943432006399 | (37.7846671947676, -122.489434320064) | |||
| 77119 | 77119 | 250896 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 253 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986796.03039 | 2114232.28383 | 37.784515560989206 | -122.48942898976601 | (37.7845155609892, -122.489428989766) | |||
| 134836 | 134836 | 250899 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 261 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986798.04224 | 2114182.00117 | 37.7843776166842 | -122.48941833100099 | (37.7843776166842, -122.489418331001) | |||
| 48007 | 48007 | 250903 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 269 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986799.05425 | 2114139.02615 | 37.7842596786901 | -122.48941166883199 | (37.7842596786901, -122.489411668832) | |||
| 177741 | 177741 | 250909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 283 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986801.87237 | 2114054.20987 | 37.7840269620296 | -122.48939568068998 | (37.7840269620296, -122.48939568069) | |||
| 70796 | 70796 | 250911 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 289 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986802.05545 | 2114026.5929900003 | 37.7839511446853 | -122.48939301598699 | (37.7839511446853, -122.489393015987) | |||
| 48589 | 48589 | 250912 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 295 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986804.90066 | 2113997.38532 | 37.78387111489079 | -122.48938102442301 | (37.7838711148908, -122.489381024423) | |||
| 149718 | 149718 | 47794 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2590 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 6 | Permit Number 45566 | 5986482.4768 | 2097627.1374 | 37.7389041088914 | -122.489292448824 | (37.7389041088914, -122.489292448824) | |
| 189062 | 189062 | 250894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.784574529539796 | -122.489279763454 | (37.7845745295398, -122.489279763454) | |||
| 135779 | 135779 | 250898 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986841.38943 | 2114228.2514400003 | 37.7845071370277 | -122.48927176847401 | (37.7845071370277, -122.489271768474) | |||
| 70061 | 70061 | 250900 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 258 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986841.97365 | 2114201.3931299997 | 37.7844334259182 | -122.489267771885 | (37.7844334259182, -122.489267771885) | |||
| 63222 | 63222 | 250904 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 270 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986844.372690001 | 2114133.07691 | 37.784245989215 | -122.489254447562 | (37.784245989215, -122.489254447562) | |||
| 54453 | 54453 | 250910 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 282 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986846.58406 | 2114055.94379 | 37.78403433287 | -122.489241124102 | (37.78403433287, -122.489241124102) | |||
| 28942 | 28942 | 119949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 310 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5986854.68996 | 2113836.9608400003 | 37.7834335415925 | -122.489196975605 | (37.7834335415925, -122.489196975605) | |||
| 159083 | 159083 | 119950 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 310 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5986854.69224 | 2113816.90198 | 37.7833784658408 | -122.489195492474 | (37.7833784658408, -122.489195492474) | |||
| 65463 | 65463 | 95574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 420 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767364 | 5986882.15467 | 2113102.72693 | 37.781419148231 | -122.48904796396002 | (37.781419148231, -122.48904796396) | |
| 111342 | 111342 | 95979 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500 Geary Blvd | 6 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5986883.76294 | 2112568.0929 | 37.779951289394205 | -122.489003085019 | (37.7799512893942, -122.489003085019) | |||
| 47264 | 47264 | 182070 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1399 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986780.7254 | 2105847.2904 | 37.761491834291796 | -122.488865351996 | (37.7614918342918, -122.488865351996) | |||
| 25558 | 25558 | 182071 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1399 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986781.3663 | 2105805.6341 | 37.761377494973004 | -122.488860073196 | (37.761377494973, -122.488860073196) | |||
| 188690 | 188690 | 120002 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 743 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5986916.79344 | 2110861.57501 | 37.7752676025083 | -122.48876334533001 | (37.7752676025083, -122.48876334533) | |||
| 175125 | 175125 | 119933 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5986970.48357 | 2112551.91695 | 37.7799119358722 | -122.48870189430001 | (37.7799119358722, -122.4887018943) | ||||
| 154777 | 154777 | 37188 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1486 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 5 | Permit Number 39757 | 5986849.1536 | 2105166.0508 | 37.759625330946605 | -122.48857861831301 | (37.7596253309466, -122.488578618313) | ||
| 179222 | 179222 | 37189 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1486 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 5 | Permit Number 43910 | 5986849.5211 | 2105147.3076 | 37.7595738887086 | -122.48857596971901 | (37.7595738887086, -122.488575969719) | |
| 75559 | 75559 | 119930 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5987085.6039 | 2112558.1946400004 | 37.779935889891895 | -122.48830410860799 | (37.7799358898919, -122.488304108608) | ||||
| 84218 | 84218 | 120030 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 5250 Fulton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5987030.11387 | 2109846.23506 | 37.77248637697021 | -122.488296717273 | (37.7724863769702, -122.488296717273) | |||
| 182561 | 182561 | 120028 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 5250 Fulton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5987055.3761 | 2109846.86772 | 37.7724895879441 | -122.48820938037201 | (37.7724895879441, -122.488209380372) | |||
| 131104 | 131104 | 181748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1231 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987050.3338 | 2106831.7147 | 37.7642105229299 | -122.488005235645 | (37.7642105229299, -122.488005235645) | |||
| 98525 | 98525 | 95978 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5987191.92688 | 2112582.17224 | 37.780007928322 | -122.487938057094 | (37.780007928322, -122.487938057094) | |||
| 100250 | 100250 | 95977 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400 Geary Blvd | 2 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5987191.92688 | 2112582.17224 | 37.780007928322 | -122.487938057094 | (37.780007928322, -122.487938057094) | |||
| 35960 | 35960 | 66328 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1362 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 8 | Permit Number 29447 | 5987126.9265 | 2106002.5454 | 37.7619383203254 | -122.487679407267 | (37.7619383203254, -122.487679407267) | |
| 32237 | 32237 | 250565 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.48760963785601 | (37.7799715553521, -122.487609637856) | |||
| 104883 | 104883 | 95933 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 658 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767630 | 5987275.6 | 2111458.0 | 37.7769261500456 | -122.48756599141899 | (37.7769261500456, -122.487565991419) | |
| 157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
| 79525 | 79525 | 95976 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300 Geary Blvd | 8 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5987433.277530001 | 2112645.56538 | 37.7801960637602 | -122.487107784765 | (37.7801960637602, -122.487107784765) | |||
| 114989 | 114989 | 95975 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300 Geary Blvd | 1 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5987433.277530001 | 2112645.56538 | 37.7801960637602 | -122.487107784765 | (37.7801960637602, -122.487107784765) | |||
| 66695 | 66695 | 250492 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987535.4917 | 2115340.76951 | 37.7876022851576 | -122.486952172315 | (37.7876022851576, -122.486952172315) | |||
| 177412 | 177412 | 250491 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987543.5108900005 | 2115340.02768 | 37.7876007158561 | -122.48692437335698 | (37.7876007158561, -122.486924373357) | |||
| 50780 | 50780 | 44805 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1281 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43900 | 5987370.4099 | 2106563.6067 | 37.7634930388235 | -122.486878508201 | (37.7634930388235, -122.486878508201) | |
| 43811 | 43811 | 182068 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1385 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987396.9049 | 2105872.3945 | 37.7615967047225 | -122.48673611241001 | (37.7615967047225, -122.48673611241) | |||
| 178110 | 178110 | 182069 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1385 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5987400.2917 | 2105805.1418 | 37.7614122446952 | -122.48671946046001 | (37.7614122446952, -122.48671946046) | |||
| 27457 | 27457 | 50206 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 718@ BALBOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | Permit Number 46914 | 5987576.49801 | 2111020.59392 | 37.7757427005024 | -122.486492983703 | (37.7757427005024, -122.486492983703) | |
| 12723 | 12723 | 53310 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2427 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1969 12:00:00 AM | 12 | 3x3 | Permit Number 6202 | 5987330.8568 | 2098750.6624 | 37.7420384981227 | -122.486441648664 | (37.7420384981227, -122.486441648664) | |
| 12603 | 12603 | 107700 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2427 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987331.1952 | 2098735.7718 | 37.7419976322055 | -122.486439385586 | (37.7419976322055, -122.486439385586) | |||
| 122374 | 122374 | 90219 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2500X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987762.945 | 2111232.52097 | 37.7763354591186 | -122.48586358362101 | (37.7763354591186, -122.485863583621) | ||
| 2612 | 2612 | 120193 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 400 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5987807.29514 | 2113237.3235 | 37.7818426655183 | -122.485857349295 | (37.7818426655183, -122.485857349295) | |||
| 28597 | 28597 | 120195 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 466 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5987821.16266 | 2112837.4508700003 | 37.7807455366166 | -122.485780016927 | (37.7807455366166, -122.485780016927) | |||
| 2623 | 2623 | 120194 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 400 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987832.0 | 2113186.0 | 37.781703185313795 | -122.485768115014 | (37.7817031853138, -122.485768115014) | |||
| 136352 | 136352 | 50202 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 622@ ANZA 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46910 | 5987860.85977 | 2111714.76081 | 37.7776652594819 | -122.48556027194901 | (37.7776652594819, -122.485560271949) | |
| 179814 | 179814 | 50204 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 755@ BALBOA 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 6 | Permit Number 47608 | 5987844.0757 | 2110824.62129 | 37.7752202083284 | -122.485552991998 | (37.7752202083284, -122.485552991998) | |
| 117291 | 117291 | 12850 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2416 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5987930.1073199995 | 2114678.83948 | 37.785807814373705 | -122.48553830183701 | (37.7858078143737, -122.485538301837) | |||
| 60769 | 60769 | 44215 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2254 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43958 | 5987642.6248 | 2099932.1859999998 | 37.7453008167348 | -122.485450351812 | (37.7453008167348, -122.485450351812) | |
| 40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
| 55336 | 55336 | 182124 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2431 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5987641.1896 | 2098719.3245 | 37.741970536904795 | -122.48536633101601 | (37.7419705369048, -122.485366331016) | |||
| 36469 | 36469 | 45076 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2370 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43959 | 5987670.9707 | 2099169.2902 | 37.743207758660496 | -122.485296368606 | (37.7432077586605, -122.485296368606) | |
| 186043 | 186043 | 42264 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1550 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 0 | Permit Number 42505 | 5987793.60406594 | 2104738.95133982 | 37.7585076977755 | -122.48528093761801 | (37.7585076977755, -122.485280937618) | |
| 44687 | 44687 | 181970 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2472 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987696.6908 | 2098473.1565 | 37.74129785780921 | -122.485156370336 | (37.7412978578092, -122.485156370336) | |||
| 22664 | 22664 | 9175 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8M | 5987996.8569 | 2112591.565 | 37.780080639606794 | -122.48515416671499 | (37.7800806396068, -122.485154166715) | |||
| 114670 | 114670 | 86486 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1666 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 01:29:00 PM | 3 | 3x3 | 5987814.532834 | 2103956.097513 | 37.7563594127844 | -122.48515111822701 | (37.7563594127844, -122.485151118227) | ||
| 177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
| 21240 | 21240 | 95973 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100 Geary Blvd | 2 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5988036.984 | 2112655.97284 | 37.780259822750295 | -122.48502007741101 | (37.7802598227503, -122.485020077411) | |||
| 99563 | 99563 | 95974 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100 Geary Blvd | 13 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5988036.984 | 2112655.97284 | 37.780259822750295 | -122.48502007741101 | (37.7802598227503, -122.485020077411) | |||
| 117006 | 117006 | 116524 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 371 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5988056.7062 | 2113530.7862 | 37.7826629615841 | -122.48501605096399 | (37.7826629615841, -122.485016050964) | |||
| 172085 | 172085 | 65958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2636 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 12 | Permit Number 28980 | 5987794.4947 | 2098312.0677 | 37.74086124721529 | -122.48480638859199 | (37.7408612472153, -122.484806388592) | |
| 147336 | 147336 | 70301 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2240 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5987950.7299 | 2100020.9476 | 37.7455624781653 | -122.48439149772699 | (37.7455624781653, -122.484391497727) | ||
| 154196 | 154196 | 182735 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1763 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988103.6655 | 2103315.4097 | 37.7546170951662 | -122.48410422691299 | (37.7546170951662, -122.484104226913) | |||
| 185224 | 185224 | 182761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1771 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988107.0179 | 2103255.9052 | 37.754453907013605 | -122.484088270186 | (37.7544539070136, -122.484088270186) | |||
| 130207 | 130207 | 182786 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1779 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5988107.856000001 | 2103203.9435 | 37.7543112829694 | -122.48408156160299 | (37.7543112829694, -122.484081561603) | |||
| 166029 | 166029 | 183461 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2526 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5988018.4599 | 2098093.913 | 37.7402752933506 | -122.484016016544 | (37.7402752933506, -122.484016016544) | |||
| 132546 | 132546 | 43805 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43435 | 5988374.1163800005 | 2113468.5404 | 37.782510535493294 | -122.483913395012 | (37.7825105354933, -122.483913395012) | |
| 13210 | 13210 | 110356 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988236.4947 | 2106489.4695 | 37.763339935168794 | -122.483877597947 | (37.7633399351688, -122.483877597947) | |||
| 11605 | 11605 | 56678 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2400 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988274.3719 | 2106490.5517 | 37.763345111521105 | -122.483746674042 | (37.7633451115211, -122.483746674042) | |||
| 180791 | 180791 | 181624 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1283 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988302.0733 | 2106569.4928 | 37.7635634746869 | -122.483656653164 | (37.7635634746869, -122.483656653164) | |||
| 75288 | 75288 | 181625 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1289 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988304.371 | 2106548.8136 | 37.763506828999205 | -122.483647190024 | (37.7635068289992, -122.483647190024) | |||
| 170131 | 170131 | 181626 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1295 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988304.371 | 2106529.6662 | 37.763454255471004 | -122.483645786119 | (37.763454255471, -122.483645786119) | |||
| 101217 | 101217 | 109143 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 631 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773541 | 5988438.18172 | 2111663.5381 | 37.7775582362364 | -122.48355938694901 | (37.7775582362364, -122.483559386949) |
| 29654 | 29654 | 71164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2118 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5988230.9552 | 2100880.1949 | 37.7479380567645 | -122.483485514105 | (37.7479380567645, -122.483485514105) | ||
| 67265 | 67265 | 50201 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 871@ FULTON 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46909 | 5988493.605359999 | 2110073.3464599997 | 37.7731952390959 | -122.483251067175 | (37.7731952390959, -122.483251067175) | |
| 165918 | 165918 | 45060 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2350 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43945 | 5988286.3907 | 2099314.6423 | 37.7436426900717 | -122.483179086197 | (37.7436426900717, -122.483179086197) | |
| 52208 | 52208 | 45062 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2354 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 5 | Permit Number 43946 | 5988287.7444 | 2099288.9223 | 37.7435721485099 | -122.48317252062901 | (37.7435721485099, -122.483172520629) | |
| 162541 | 162541 | 45061 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2354 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 5 | Permit Number 43946 | 5988288.0829 | 2099272.3396 | 37.743526636485704 | -122.48317013495199 | (37.7435266364857, -122.483170134952) | |
| 28654 | 28654 | 182879 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2416 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988300.9429 | 2098918.3504 | 37.7425554237279 | -122.483099728122 | (37.7425554237279, -122.483099728122) | |||
| 30193 | 30193 | 182877 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2416 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988301.6197 | 2098876.0477 | 37.7424393110269 | -122.483094288039 | (37.7424393110269, -122.483094288039) | |||
| 130181 | 130181 | 182878 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2416 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988302.2966 | 2098894.9993 | 37.7424913865249 | -122.48309333631701 | (37.7424913865249, -122.483093336317) | |||
| 160790 | 160790 | 182876 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2416 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988303.9887 | 2098856.4192 | 37.7423855541847 | -122.483084658481 | (37.7423855541847, -122.483084658481) | |||
| 57397 | 57397 | 98014 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5988336.307999999 | 2098951.3465 | 37.742648080234495 | -122.482979865289 | (37.7426480802345, -122.482979865289) | |||
| 79240 | 79240 | 98015 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 87334 | 87334 | 98017 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 88171 | 88171 | 98019 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 102587 | 102587 | 98018 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 126729 | 126729 | 98016 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 173365 | 173365 | 182077 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1551 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988358.6438 | 2098950.6697 | 37.7426475215766 | -122.48290258590201 | (37.7426475215766, -122.482902585902) | |||
| 180191 | 180191 | 181781 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1551 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988374.5496 | 2098951.3465 | 37.7426503053739 | -122.482847638505 | (37.7426503053739, -122.482847638505) | |||
| 30176 | 30176 | 183589 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2624 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988350.9686 | 2097439.6217 | 37.7384981331628 | -122.48281841008499 | (37.7384981331628, -122.482818410085) | |||
| 137457 | 137457 | 183588 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2624 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988352.1066 | 2097421.4683 | 37.7384483548784 | -122.48281314546101 | (37.7384483548784, -122.482813145461) |
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");