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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31148 | 31148 | 32043 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2445 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | 2 | Permit Number 35425 | 6002440.88966 | 2117060.97738 | 37.7931833078272 | -122.435505607515 | (37.7931833078272, -122.435505607515) | ||
| 31246 | 31246 | 30818 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 151 Lippard Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 9 | Permit Number 34679 | 6001851.91271 | 2095252.38683 | 37.7332687805252 | -122.435982268868 | (37.7332687805252, -122.435982268868) | ||
| 31269 | 31269 | 62989 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1237 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 6 | Permit Number 30055 | 6005901.74695 | 2120326.62389 | 37.802345896709106 | -122.42376311459299 | (37.8023458967091, -122.423763114593) | |
| 31340 | 31340 | 50690 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.38905544574699 | (37.7889998109335, -122.389055445747) | |
| 31474 | 31474 | 40620 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3367 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1999 12:00:00 AM | 8 | Permit Number 41625 | 6001284.18567 | 2120046.72207 | 37.8013156153844 | -122.439722023163 | (37.8013156153844, -122.439722023163) | ||
| 31510 | 31510 | 30346 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1956 12:00:00 AM | 30 | Permit Number 29 | 6012920.95972 | 2105089.0499400003 | 37.7609007687805 | -122.39840324732 | (37.7609007687805, -122.39840324732) | ||
| 31580 | 31580 | 30451 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 298 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 11 | Permit Number 100 | 6010449.7115 | 2121003.8319 | 37.8044610266311 | -122.40807264308201 | (37.8044610266311, -122.408072643082) | ||
| 31877 | 31877 | 194684 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012406.88691 | 2104790.52602 | 37.7600524373766 | -122.40016024382099 | (37.7600524373766, -122.400160243821) | ||||
| 31938 | 31938 | 61501 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 162 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 10 | Permit Number 23384 | 5989633.206259999 | 2114282.9804700003 | 37.7848199772441 | -122.479617149174 | (37.7848199772441, -122.479617149174) | |
| 32165 | 32165 | 211633 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993517.47022 | 2096073.45578 | 37.7350462338855 | -122.464856097643 | (37.7350462338855, -122.464856097643) | ||||
| 32267 | 32267 | 66129 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3524 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 9 | Permit Number 29191 | 6001231.20754 | 2120694.50688 | 37.8030912449169 | -122.439951824237 | (37.8030912449169, -122.439951824237) | ||
| 32408 | 32408 | 49732 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 32487 | 32487 | 63608 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 530 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | 10 | Permit Number 24245 | 5999723.4807 | 2110368.918 | 37.7746539372465 | -122.444426821707 | (37.7746539372465, -122.444426821707) | |
| 32834 | 32834 | 63583 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2351 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 9 | Permit Number 24208 | 6006705.30109 | 2119319.99984 | 37.7996272902269 | -122.420910908407 | (37.7996272902269, -122.420910908407) | |
| 32891 | 32891 | 63603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 921 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | 11 | Permit Number 24238 | 5999478.592 | 2111813.9978 | 37.778607780811704 | -122.445377864049 | (37.7786077808117, -122.445377864049) | |
| 33060 | 33060 | 66013 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3448 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | 12 | Permit Number 29047 | 6000314.8367099995 | 2120150.2798099997 | 37.8015447356623 | -122.443083830157 | (37.8015447356623, -122.443083830157) | ||
| 33297 | 33297 | 133178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010460.26266 | 2121350.57674 | 37.8054136928441 | -122.40806059821199 | (37.8054136928441, -122.408060598212) | ||||
| 33667 | 33667 | 37508 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1055 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39967 | 6008450.33204 | 2115534.6033 | 37.789331730921205 | -122.414604427856 | (37.7893317309212, -122.414604427856) | ||
| 33754 | 33754 | 63549 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 924 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 2 | Permit Number 24165 | 5999542.5537 | 2111692.8428 | 37.7782787713205 | -122.445147884156 | (37.7782787713205, -122.445147884156) | |
| 33792 | 33792 | 71652 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 403 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5998109.83834 | 2115116.24613 | 37.7875966590072 | -122.450350995309 | (37.7875966590072, -122.450350995309) | ||
| 34130 | 34130 | 65102 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 50 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 6 | Permit Number 27067 | 5989606.66355 | 2114886.66519 | 37.786475983597704 | -122.47975316578501 | (37.7864759835977, -122.479753165785) | |
| 34147 | 34147 | 132748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5999067.6485 | 2121161.9158799998 | 37.80425122466389 | -122.44747250735901 | (37.8042512246639, -122.447472507359) | ||||
| 34170 | 34170 | 47086 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 163 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | Permit Number 45072 | 5997573.5311 | 2112729.5134 | 37.7810126130998 | -122.45203423828899 | (37.7810126130998, -122.452034238289) | |
| 34302 | 34302 | 30402 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 34377 | 34377 | 31801 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 49 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35271 | 6001922.64301 | 2107937.51024 | 37.76810312699671 | -122.436645416353 | (37.7681031269967, -122.436645416353) | |
| 34531 | 34531 | 31410 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4334 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 10 | Permit Number 34999 | 6001863.520959999 | 2104127.01093 | 37.757637066125795 | -122.436577135341 | (37.7576370661258, -122.436577135341) | |
| 34542 | 34542 | 40876 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | 8 | Permit Number 41788 | 5998115.95184 | 2115853.11645 | 37.7896202595206 | -122.450382983295 | (37.7896202595206, -122.450382983295) | ||
| 34671 | 34671 | 61084 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 248 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/1983 12:00:00 AM | 8 | Permit Number 20921 | 5994641.9408599995 | 2113884.21177 | 37.784014746378496 | -122.46225975931499 | (37.7840147463785, -122.462259759315) | |
| 34707 | 34707 | 36950 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 244 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 3 | Permit Number 45477 | 5994641.64799 | 2113910.66076 | 37.784087351299604 | -122.46226269142299 | (37.7840873512996, -122.462262691423) | |
| 34778 | 34778 | 66007 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3418 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | 7 | Permit Number 29041 | 6000329.77826 | 2120053.99312 | 37.8012812100306 | -122.443025206968 | (37.8012812100306, -122.443025206968) | ||
| 34922 | 34922 | 72029 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2049 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1983 12:00:00 AM | 8 | 6007657.13445 | 2119469.15821 | 37.8000904473654 | -122.417627788486 | (37.8000904473654, -122.417627788486) | ||
| 35194 | 35194 | 31668 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 215#3 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | Permit Number 35176 | 6010250.9256 | 2121284.082 | 37.8052193918816 | -122.408780346054 | (37.8052193918816, -122.408780346054) | |
| 35210 | 35210 | 54867 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1857 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 13 | Permit Number 10726 | 5998948.2148 | 2110055.0909 | 37.7737479836038 | -122.447086021385 | (37.7737479836038, -122.447086021385) | ||
| 35256 | 35256 | 65096 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 274 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1991 12:00:00 AM | 13 | Permit Number 30114 | 5989347.99647 | 2113522.48008 | 37.782715285289505 | -122.480548181096 | (37.7827152852895, -122.480548181096) | |
| 35356 | 35356 | 62294 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 170 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 7 | Permit Number 22432 | 5996863.0145 | 2111846.0633 | 37.7785461675804 | -122.454428417458 | (37.7785461675804, -122.454428417458) | |
| 35747 | 35747 | 66121 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 341 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 10 | Permit Number 29183 | 6000875.659 | 2121214.03728 | 37.8044974905357 | -122.441219503176 | (37.8044974905357, -122.441219503176) | ||
| 35917 | 35917 | 65030 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 395 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1989 12:00:00 AM | 12 | Permit Number 26082 | 5989635.66444 | 2112796.6409400003 | 37.7807390479923 | -122.479499861546 | (37.7807390479923, -122.479499861546) | ||
| 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) | |
| 36018 | 36018 | 30452 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 273 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 11 | Permit Number 101 | 6010525.072000001 | 2120964.5555 | 37.804357402487895 | -122.40780907895001 | (37.8043574024879, -122.40780907895) | ||
| 36098 | 36098 | 78218 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1127 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 18 | 6009634.99445 | 2090933.49058 | 37.7218490839521 | -122.40876931346901 | (37.7218490839521, -122.408769313469) | ||
| 36205 | 36205 | 44457 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002582.01071 | 2086882.75579 | 37.7103290904997 | -122.432860405496 | (37.7103290904997, -122.432860405496) | |
| 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) | |
| 36492 | 36492 | 60348 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1404 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 6 | Permit Number 19926 | 6015899.7652 | 2094527.3411 | 37.732065992936796 | -122.387363991073 | (37.7320659929368, -122.387363991073) | |
| 36510 | 36510 | 41182 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1781 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 10 | Permit Number 41900 | 6001635.93315 | 2121055.7102900003 | 37.8041060444241 | -122.438577160103 | (37.8041060444241, -122.438577160103) | |
| 36541 | 36541 | 57388 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1152 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16227 | 6008117.462069999 | 2116489.43579 | 37.79193476013 | -122.415823761955 | (37.79193476013, -122.415823761955) | ||
| 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) | |
| 36875 | 36875 | 100198 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 81 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 22 | Permit Number 769099 | 5994239.2285400005 | 2115068.80691 | 37.7872441264014 | -122.463738994433 | (37.7872441264014, -122.463738994433) | ||
| 36943 | 36943 | 236176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 44 Miguel St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003678.32801 | 2097312.06482 | 37.7390277763068 | -122.429814711994 | (37.7390277763068, -122.429814711994) | ||||
| 37007 | 37007 | 41089 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 786 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 1 | Permit Number 769357 | 6008594.7555599995 | 2110738.3215900003 | 37.7761704054812 | -122.41376533881201 | (37.7761704054812, -122.413765338812) | |
| 37022 | 37022 | 234105 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1200 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004253.5509 | 2096158.0047 | 37.735891546257 | -122.427743648866 | (37.735891546257, -122.427743648866) | ||||
| 37573 | 37573 | 65688 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 184 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | 8 | Permit Number 28909 | 5995950.945309999 | 2113042.38118 | 37.7817785895398 | -122.45767017670201 | (37.7817785895398, -122.457670176702) | |
| 37709 | 37709 | 50244 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1274 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 6 | Permit Number 46949 | 5985245.6795 | 2106544.1944 | 37.7633156319875 | -122.49422573334999 | (37.7633156319875, -122.49422573335) | |
| 37767 | 37767 | 211724 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992178.335940001 | 2088233.1934099998 | 37.71344150289679 | -122.468915552827 | (37.7134415028968, -122.468915552827) | ||||
| 37877 | 37877 | 34574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3294 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38281 | 5999101.87048 | 2115664.1576900003 | 37.7891578047381 | -122.44695821654301 | (37.7891578047381, -122.446958216543) | |
| 37919 | 37919 | 133114 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6007094.56661 | 2119804.0690599997 | 37.8009783561189 | -122.41959826875099 | (37.8009783561189, -122.419598268751) | ||||
| 37935 | 37935 | 40874 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | 9 | Permit Number 41788 | 5998075.89088 | 2115848.26681 | 37.789604650868895 | -122.45052123967 | (37.7896046508689, -122.45052123967) | ||
| 38083 | 38083 | 61089 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 245 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/1983 12:00:00 AM | 7 | Permit Number 20927 | 5994281.8630800005 | 2113873.03034 | 37.7839633053529 | -122.46350467609301 | (37.7839633053529, -122.463504676093) | |
| 38367 | 38367 | 133141 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 407 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011477.96138 | 2119029.17792 | 37.7990966263734 | -122.40437519896099 | (37.7990966263734, -122.404375198961) | ||||
| 38799 | 38799 | 133113 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007028.127 | 2119798.62305 | 37.800959660109 | -122.41982779193701 | (37.800959660109, -122.419827791937) | ||||
| 38821 | 38821 | 65105 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 63 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 12 | Permit Number 27072 | 5989564.9715599995 | 2114867.9545299998 | 37.7864221872953 | -122.47989603832501 | (37.7864221872953, -122.479896038325) | |
| 39058 | 39058 | 62196 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 100 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | 8 | Permit Number 22315 | 6000474.13806 | 2092219.5232900002 | 37.7248628704139 | -122.440528150264 | (37.7248628704139, -122.440528150264) | |
| 39132 | 39132 | 66124 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3651 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 9 | Permit Number 29186 | 6000655.26617 | 2120917.00616 | 37.8036693660109 | -122.44196085753401 | (37.8036693660109, -122.441960857534) | ||
| 39245 | 39245 | 57164 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2989 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | 15 | Permit Number 14441 | 5999884.50215 | 2116380.66792 | 37.791169835478705 | -122.44430192859801 | (37.7911698354787, -122.444301928598) | ||
| 39295 | 39295 | 44814 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1490 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 7 | Permit Number 43906 | 5986225.4839 | 2105102.471 | 37.7594143459963 | -122.490730872272 | (37.7594143459963, -122.490730872272) | |
| 39455 | 39455 | 211655 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993781.5938099995 | 2096511.3140900002 | 37.736263709102296 | -122.46397470897301 | (37.7362637091023, -122.463974708973) | ||||
| 39483 | 39483 | 211654 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993772.928590001 | 2096520.6347700001 | 37.7362888019871 | -122.464005344374 | (37.7362888019871, -122.464005344374) | ||||
| 39508 | 39508 | 51498 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2635 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 7 | Permit Number 47811 | 6000402.82446 | 2117825.8803 | 37.79516756749221 | -122.44261236597299 | (37.7951675674922, -122.442612365973) | ||
| 39659 | 39659 | 211666 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 658 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997067.86427 | 2094435.3923799999 | 37.7307525691644 | -122.452463011752 | (37.7307525691644, -122.452463011752) | ||||
| 39692 | 39692 | 92947 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3740 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5996967.80791 | 2115041.72959 | 37.787326631266396 | -122.45429678879199 | (37.7873266312664, -122.454296788792) | ||||
| 39727 | 39727 | 67562 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1165 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774855 | 6011687.96169 | 2102947.6687 | 37.754952246266896 | -122.40251708718901 | (37.7549522462669, -122.402517087189) | |
| 39754 | 39754 | 54824 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1439 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 14 | Permit Number 10678 | 6015423.2514 | 2093064.2733 | 37.728022299464 | -122.388909309853 | (37.728022299464, -122.388909309853) | ||
| 40158 | 40158 | 51217 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 148 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | 5 | Permit Number 47581 | 6009096.5942 | 2093544.75365 | 37.728988889808896 | -122.410814760306 | (37.7289888898089, -122.410814760306) | |
| 40243 | 40243 | 100970 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | Permit Number 37341 | 6009657.9659 | 2120896.9693 | 37.804123246932896 | -122.41080500812201 | (37.8041232469329, -122.410805008122) | ||
| 40445 | 40445 | 85307 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2007 12:00:00 AM | 14 | Permit Number 49592 | 5994243.39546 | 2114990.3725400004 | 37.7870290071023 | -122.46371888295499 | (37.7870290071023, -122.463718882955) | ||
| 40512 | 40512 | 63177 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3983 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1986 12:00:00 AM | 12 | Permit Number 23714 | 5995682.47434 | 2114814.1126099997 | 37.7866278633584 | -122.458727259333 | (37.7866278633584, -122.458727259333) | ||
| 40519 | 40519 | 106893 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 580 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6011306.036730001 | 2118337.60033 | 37.797188112993105 | -122.404921401297 | (37.7971881129931, -122.404921401297) | ||||
| 40601 | 40601 | 65925 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 80 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 11 | Permit Number 28942 | 5995918.83699 | 2113960.3676 | 37.7842972908104 | -122.45784770445 | (37.7842972908104, -122.45784770445) | |
| 40820 | 40820 | 40870 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | 8 | Permit Number 41788 | 5998087.673880001 | 2115847.66419 | 37.7896036706333 | -122.45048042844299 | (37.7896036706333, -122.450480428443) | ||
| 40828 | 40828 | 32785 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1903 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 5 | Permit Number 37152 | 6001293.802 | 2112456.0686 | 37.780474197878796 | -122.43914439989099 | (37.7804741978788, -122.439144399891) | ||
| 40964 | 40964 | 55479 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 950 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 16 | Permit Number 11431 | 6002457.7556 | 2111793.5064 | 37.778721130856 | -122.43507034036502 | (37.778721130856, -122.435070340365) | |
| 41075 | 41075 | 103529 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 23 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6009696.39175 | 2089318.75297 | 37.717418787914504 | -122.40844323548299 | (37.7174187879145, -122.408443235483) | ||||
| 41322 | 41322 | 211727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992176.51123 | 2088212.22362 | 37.7133838194885 | -122.468920334526 | (37.7133838194885, -122.468920334526) | ||||
| 41616 | 41616 | 64487 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3193 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1988 12:00:00 AM | 11 | Permit Number 25362 | 5999446.45159 | 2115991.26632 | 37.7900756393323 | -122.44578954757 | (37.7900756393323, -122.44578954757) | ||
| 41658 | 41658 | 43968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 460 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 3 | Permit Number 43535 | 6010609.59678 | 2112394.78892 | 37.780831619534794 | -122.406912199941 | (37.7808316195348, -122.406912199941) | ||
| 41671 | 41671 | 132747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 5999125.84165 | 2121169.76474 | 37.804276100834606 | -122.44727169143101 | (37.8042761008346, -122.447271691431) | ||||
| 41707 | 41707 | 62815 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1600 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | 13 | Permit Number 23176 | 6001857.5281 | 2111897.0804 | 37.7789714183699 | -122.437154175027 | (37.7789714183699, -122.437154175027) | |
| 42306 | 42306 | 62566 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 484 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 11 | Permit Number 22767 | 6011457.1056 | 2106150.727 | 37.7637342411783 | -122.403540799888 | (37.7637342411783, -122.403540799888) | |
| 42473 | 42473 | 62084 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 516 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 6 | Permit Number 22169 | 6013230.31199 | 2104498.201 | 37.7592956551886 | -122.397291892127 | (37.7592956551886, -122.397291892127) | |
| 42553 | 42553 | 133185 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6010525.52833 | 2121313.76081 | 37.805316259401295 | -122.407832138939 | (37.8053162594013, -122.407832138939) | ||||
| 42630 | 42630 | 201727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013753.9526 | 2095943.1082 | 37.7358343232928 | -122.394881707251 | (37.7358343232928, -122.394881707251) | ||||
| 42696 | 42696 | 62299 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 122 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 7 | Permit Number 22437 | 5996812.5896 | 2112198.6988 | 37.7795115199603 | -122.454628337968 | (37.7795115199603, -122.454628337968) | |
| 42858 | 42858 | 66010 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3424 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | 14 | Permit Number 29044 | 6000324.46916 | 2120073.93688 | 37.8013356675699 | -122.44304501183399 | (37.8013356675699, -122.443045011834) | ||
| 42865 | 42865 | 62073 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 660 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 12 | Permit Number 22155 | 6013258.35326 | 2104028.36845 | 37.758007158728 | -122.397161966152 | (37.758007158728, -122.397161966152) | |
| 42952 | 42952 | 96972 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 900 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 17188 | 6009145.817290001 | 2116084.72899 | 37.790881291587404 | -122.41223701831899 | (37.7908812915874, -122.412237018319) | |||
| 43088 | 43088 | 46836 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 279 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44909 | 6004476.88303 | 2090759.95293 | 37.721082326467204 | -122.426587236717 | (37.7210823264672, -122.426587236717) | |
| 43096 | 43096 | 54825 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1443 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 12 | Permit Number 10679 | 6015403.4654 | 2093078.0136 | 37.7280589308616 | -122.388978670165 | (37.7280589308616, -122.388978670165) | ||
| 43425 | 43425 | 62096 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 272 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 13 | Permit Number 22187 | 6013160.195309999 | 2105786.67168 | 37.762829608622 | -122.397624761781 | (37.762829608622, -122.397624761781) | |
| 43445 | 43445 | 65522 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 719 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 12 | Permit Number 28409 | 6001384.5426900005 | 2089392.37473 | 37.717151956363296 | -122.43717866488599 | (37.7171519563633, -122.437178664886) | |
| 43467 | 43467 | 40875 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | 5 | Permit Number 41788 | 5998103.6358900005 | 2115848.85122 | 37.7896078434642 | -122.45042528741101 | (37.7896078434642, -122.450425287411) | ||
| 43617 | 43617 | 31872 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 650 Delancey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35313 | 6015645.45559 | 2113166.2930799997 | 37.7832304963316 | -122.389544454808 | (37.7832304963316, -122.389544454808) |
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");