Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132930 | 132930 | 110400 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.77996145844129 | -122.477285287094 | (37.7799614584413, -122.477285287094) | ||
| 2857 | 2857 | 41128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 2873 | 2873 | 41127 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 2880 | 2880 | 41129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 82909 | 82909 | 95459 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.48994323847201 | (37.776861872872, -122.489943238472) | ||
| 85197 | 85197 | 99341 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791001 | (37.7812257915862, -122.49011031791) | ||
| 86659 | 86659 | 99336 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | ||
| 91017 | 91017 | 99338 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | ||
| 95801 | 95801 | 99340 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 6x8 | 5986575.04866 | 2113011.09375 | 37.7811496204005 | -122.49010364520299 | (37.7811496204005, -122.490103645203) | ||
| 107292 | 107292 | 99342 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.49011031789301 | (37.7812937594666, -122.490110317893) | ||
| 109890 | 109890 | 99334 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.780764663134896 | -122.49007695716298 | (37.7807646631349, -122.490076957163) | ||
| 124223 | 124223 | 99344 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.781426179231204 | -122.49012217925899 | (37.7814261792312, -122.490122179259) | ||
| 126186 | 126186 | 70471 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450X Banks St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 32 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 19062 | 19062 | 50066 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | ||
| 26114 | 26114 | 61073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.783687022959995 | -122.44520566105601 | (37.78368702296, -122.445205661056) | |
| 32763 | 32763 | 68295 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.604780001 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | |
| 34129 | 34129 | 63191 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.006630001 | 2112603.98729 | 37.7798871547077 | -122.49862546555599 | (37.7798871547077, -122.498625465556) |
| 36150 | 36150 | 69365 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3536 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 15 | 4.5x6 | Permit Number 33459 | 6002661.12901 | 2120784.76321 | 37.803420359914796 | -122.435010010914 | (37.8034203599148, -122.435010010914) |
| 38847 | 38847 | 51264 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 11 | Permit Number 47641 | 5991632.45779 | 2110058.1497 | 37.773335681454896 | -122.472392358685 | (37.7733356814549, -122.472392358685) | |
| 40997 | 40997 | 68216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 13 | 4x4 | Permit Number 32003 | 5991199.85508 | 2112923.89297 | 37.781179180083704 | -122.474097911754 | (37.7811791800837, -122.474097911754) |
| 44875 | 44875 | 32939 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.76122625950521 | -122.39674381646999 | (37.7612262595052, -122.39674381647) | |
| 50032 | 50032 | 34999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 14 | 6x10 | Permit Number 43196 | 5999546.79475277 | 2111295.47699927 | 37.7771879487933 | -122.445104637941 | (37.7771879487933, -122.445104637941) |
| 52835 | 52835 | 75161 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 15 | 6005585.43876 | 2119632.07302 | 37.80042097699361 | -122.42480825631 | (37.8004209769936, -122.42480825631) | ||
| 53623 | 53623 | 66064 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 612 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | 14 | Permit Number 29104 | 6013245.790080001 | 2104237.6601 | 37.7585811285267 | -122.397220091143 | (37.7585811285267, -122.397220091143) | |
| 59209 | 59209 | 33675 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | |
| 60605 | 60605 | 51265 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 14 | Permit Number 47641 | 5991632.71365 | 2110039.2533299997 | 37.7732838119525 | -122.472390095818 | (37.7732838119525, -122.472390095818) | |
| 63415 | 63415 | 33467 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.744638227793395 | -122.419218573599 | (37.7446382277934, -122.419218573599) | ||
| 67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
| 76127 | 76127 | 50574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 77699 | 77699 | 50634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 78495 | 78495 | 121113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 79926 | 79926 | 112059 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 36 | 5x6 | 5991981.6527 | 2110175.44232 | 37.7736779395689 | -122.471193003562 | (37.7736779395689, -122.471193003562) | ||
| 80394 | 80394 | 56060 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2601 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | 12 | 3x3 | Permit Number 29254 | 6008923.286869099 | 2103309.03628316 | 37.7557897476479 | -122.412103687584 | (37.7557897476479, -122.412103687584) |
| 82044 | 82044 | 33219 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 82373 | 82373 | 121115 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 83354 | 83354 | 33464 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 52 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37617 | 6006854.98101405 | 2099423.3660818003 | 37.7450043146116 | -122.418980984578 | (37.7450043146116, -122.418980984578) | ||
| 84602 | 84602 | 47600 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 85324 | 85324 | 33493 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | ||
| 87692 | 87692 | 66033 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 176 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1990 12:00:00 AM | 18 | 5x5 | Permit Number 29070 | 6005715.54101004 | 2110005.55330132 | 37.7739962917294 | -122.423673221036 | (37.7739962917294, -122.423673221036) |
| 89057 | 89057 | 33184 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.743997782291395 | -122.46324393518499 | (37.7439977822914, -122.463243935185) | ||
| 89125 | 89125 | 44162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 853 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | Permit Number 43636 | 6002495.49530521 | 2109506.13705466 | 37.772442727355205 | -122.43477616990101 | (37.7724427273552, -122.434776169901) | ||
| 89684 | 89684 | 60589 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 538 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 20207 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | ||
| 90746 | 90746 | 121116 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 91219 | 91219 | 33466 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 60 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37619 | 6006826.41498367 | 2099370.6210257 | 37.7448578799465 | -122.41907602046601 | (37.7448578799465, -122.419076020466) | ||
| 93348 | 93348 | 38998 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2180 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | ||
| 94189 | 94189 | 47042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 6x9 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | |
| 94325 | 94325 | 52113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.42465811266199 | (37.7765968250138, -122.424658112662) | |
| 95599 | 95599 | 33528 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 183 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37638 | 6007285.94975907 | 2097957.3067179 | 37.7410031014535 | -122.417386891564 | (37.7410031014535, -122.417386891564) | ||
| 95818 | 95818 | 60967 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 721 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | 22 | Permit Number 20772 | 5994690.06322675 | 2091210.94869199 | 37.721762508120705 | -122.46044983368999 | (37.7217625081207, -122.46044983369) | |
| 95969 | 95969 | 121114 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 98229 | 98229 | 62433 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.762087537224396 | -122.44303428204901 | (37.7620875372244, -122.443034282049) | ||
| 98743 | 98743 | 50635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 99199 | 99199 | 50657 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | Permit Number 47239 | 5995410.10661733 | 2114891.76691609 | 37.7868254226819 | -122.4596752059 | (37.7868254226819, -122.4596752059) | ||
| 99863 | 99863 | 48654 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Moraga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 106372 | 106372 | 47599 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 107470 | 107470 | 33185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.743997782291395 | -122.46324393518499 | (37.7439977822914, -122.463243935185) | ||
| 109389 | 109389 | 33217 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 110404 | 110404 | 38838 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | Permit Number 40667 | 5994882.83677024 | 2114872.91229278 | 37.7867433187024 | -122.46149805609501 | (37.7867433187024, -122.461498056095) | ||
| 112557 | 112557 | 121112 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 113077 | 113077 | 33531 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 177 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37641 | 6007317.75345238 | 2098016.57716988 | 37.741167634292005 | -122.417281124878 | (37.741167634292, -122.417281124878) | ||
| 114080 | 114080 | 33218 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 117205 | 117205 | 49498 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1517@ KIRKHAM 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2003 12:00:00 AM | Permit Number 46413 | 5993653.11597324 | 2105163.12011836 | 37.7600119628265 | -122.46504708739799 | (37.7600119628265, -122.465047087398) | ||
| 117549 | 117549 | 33715 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 184 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37783 | 6003401.63659312 | 2108816.63624682 | 37.770600930555894 | -122.431592506668 | (37.7706009305559, -122.431592506668) | ||
| 120610 | 120610 | 33503 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 161 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | 3x3 | Permit Number 37597 | 6006560.16848411 | 2098769.04119675 | 37.7431910803563 | -122.41995397132 | (37.7431910803563, -122.41995397132) | |
| 120814 | 120814 | 49692 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2003 12:00:00 AM | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |
| 121772 | 121772 | 33216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 122319 | 122319 | 103020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave property permits | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
| 123999 | 123999 | 33492 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | ||
| 125626 | 125626 | 49691 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2003 12:00:00 AM | tx5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |
| 126596 | 126596 | 33502 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.743270591712104 | -122.419902509091 | (37.7432705917121, -122.419902509091) | ||
| 129049 | 129049 | 41146 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1534 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41879 | 5998316.1437305 | 2108281.00611102 | 37.7688406669583 | -122.449144612222 | (37.7688406669583, -122.449144612222) | ||
| 130842 | 130842 | 67625 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1281 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 16 | Permit Number 31211 | 6007384.19721 | 2118457.0336700003 | 37.7972960451262 | -122.41850045014601 | (37.7972960451262, -122.418500450146) | |
| 134558 | 134558 | 52239 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1025REVISED Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2006 12:00:00 AM | 20 | Permit Number 48410 | 6011950.95504 | 2103369.42747 | 37.756124981991206 | -122.401637218391 | (37.7561249819912, -122.401637218391) | |
| 135052 | 135052 | 49693 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 23 | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) |
| 135524 | 135524 | 50633 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997210996 | -122.393359654849 | (37.721936997211, -122.393359654849) | |
| 137151 | 137151 | 116378 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 3x3 | 6013444.81067 | 2105199.38309 | 37.761232887497 | -122.3965991992 | (37.761232887497, -122.3965991992) | ||
| 138454 | 138454 | 50572 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 138683 | 138683 | 121111 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 157259 | 157259 | 31435 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4319 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 7 | Permit Number 46573 | 6000964.17426 | 2103290.0482799998 | 37.7552878220004 | -122.43962743516 | (37.7552878220004, -122.43962743516) | |
| 158122 | 158122 | 65732 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 254 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 23 | Permit Number 28666 | 6000124.55623 | 2087429.0552700001 | 37.711689418507206 | -122.44139302826099 | (37.7116894185072, -122.441393028261) | |
| 160351 | 160351 | 63201 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 434 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 17 | Permit Number 23742 | 5984713.13689 | 2112937.02697 | 37.7808373486479 | -122.496539369055 | (37.7808373486479, -122.496539369055) | |
| 165111 | 165111 | 39935 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770539 | 6010138.7177 | 2087941.04422 | 37.713660642495 | -122.406817269312 | (37.713660642495, -122.406817269312) |
| 178634 | 178634 | 65604 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 19 | Permit Number 28508 | 6004295.56089 | 2093783.58781 | 37.729374306881496 | -122.427429305233 | (37.7293743068815, -122.427429305233) | |
| 178661 | 178661 | 43780 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 318 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 15 | Permit Number 43410 | 5989670.6824 | 2113208.17204 | 37.7818710314531 | -122.479408835232 | (37.7818710314531, -122.479408835232) | |
| 187342 | 187342 | 65766 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | |
| 187 | 187 | 251248 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001839.0 | 2095802.0 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | ||||
| 197 | 197 | 251245 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.73445361741221 | -122.433896153002 | (37.7344536174122, -122.433896153002) | ||||
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 526 | 526 | 18856 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004191.661859999 | 2115995.22985 | 37.790356315029996 | -122.429371791378 | (37.79035631503, -122.429371791378) | |||
| 570 | 570 | 22578 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006396.3025 | 2112828.5224900004 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) | |||
| 598 | 598 | 22577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006373.00538 | 2112825.1930299997 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | |||
| 662 | 662 | 206411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | ||
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
| 796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
| 797 | 797 | 212191 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002043.865019999 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | ||||
| 800 | 800 | 216493 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 3ft | 6001711.3067 | 2095523.18805 | 37.734004349526 | -122.43648775710301 | (37.734004349526, -122.436487757103) | |||
| 801 | 801 | 212193 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 14 | 6002021.19403 | 2095482.3719 | 37.7339098820273 | -122.43541346386002 | (37.7339098820273, -122.43541346386) |
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");