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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57215 | 57215 | 175165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | |||
| 57484 | 57484 | 221751 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.750014791971104 | -122.429672485102 | (37.7500147919711, -122.429672485102) | |||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 58297 | 58297 | 220644 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009354.03531 | 2097334.2588400003 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | |||
| 58353 | 58353 | 125529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | |||
| 58417 | 58417 | 125477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.41197010674802 | (37.793044652131, -122.411970106748) | |||
| 58639 | 58639 | 203477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.47480105801701 | (37.7443538888309, -122.474801058017) | |||
| 59975 | 59975 | 220649 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008103.651880001 | 2099402.16609 | 37.7450163384242 | -122.414661792014 | (37.7450163384242, -122.414661792014) | |||
| 60116 | 60116 | 248097 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010442.71302 | 2099823.47595 | 37.7463043033989 | -122.406603382656 | (37.7463043033989, -122.406603382656) | |||
| 63403 | 63403 | 221758 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001348.5727699995 | 2104052.2530799997 | 37.757402522937 | -122.438352676761 | (37.757402522937, -122.438352676761) | |||
| 63596 | 63596 | 220634 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002844.7092 | 2095716.3109400002 | 37.7345989605548 | -122.432583028494 | (37.7345989605548, -122.432583028494) | |||
| 63824 | 63824 | 220654 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | |||
| 64345 | 64345 | 35678 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 373 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 3 | Permit Number 39754 | 5987751.633830001 | 2113488.06207 | 37.7825278787916 | -122.486068320452 | (37.7825278787916, -122.486068320452) | ||
| 64363 | 64363 | 248092 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010451.32651 | 2099884.28332 | 37.7464717490664 | -122.40657788235701 | (37.7464717490664, -122.406577882357) | |||
| 64810 | 64810 | 220647 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007230.99534 | 2098247.75396 | 37.7417975128515 | -122.41759748493999 | (37.7417975128515, -122.41759748494) | |||
| 65098 | 65098 | 92415 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) |
| 65581 | 65581 | 35740 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/2000 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.7328599999 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | |
| 65850 | 65850 | 92445 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
| 66225 | 66225 | 99400 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 66877 | 66877 | 220656 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008322.74158 | 2096484.8015599998 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | |||
| 67476 | 67476 | 99401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 68669 | 68669 | 203481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993650.092119999 | 2093481.6421299998 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | |||
| 69728 | 69728 | 125437 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.44406922002199 | (37.8045448847905, -122.444069220022) | |||
| 70578 | 70578 | 70577 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 201 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2008 12:00:00 AM | 3 | 4x4 | Permit Number 50063 | 5992415.28352 | 2114057.951 | 37.7843633240791 | -122.469975767472 | (37.7843633240791, -122.469975767472) | |
| 71399 | 71399 | 125537 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.43392 | 2116876.79887 | 37.7931084671277 | -122.409062644443 | (37.7931084671277, -122.409062644443) | |||
| 72861 | 72861 | 32513 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.6295900003 | 37.735251041008794 | -122.416089643829 | (37.7352510410088, -122.416089643829) | |
| 72887 | 72887 | 189192 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012099.2034599995 | 2107516.8442700002 | 37.767521137926394 | -122.401415981588 | (37.7675211379264, -122.401415981588) | |||
| 73487 | 73487 | 125479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1133 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009244.74147 | 2117035.03683 | 37.793496155866706 | -122.411961928316 | (37.7934961558667, -122.411961928316) | |||
| 75445 | 75445 | 220658 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007553.6507 | 2100235.86656 | 37.7472745765577 | -122.416622650424 | (37.7472745765577, -122.416622650424) | |||
| 75833 | 75833 | 41617 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.40176253082501 | (37.7456927230357, -122.401762530825) | |
| 76457 | 76457 | 125449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999876.27718 | 2115725.0378099997 | 37.789369177790206 | -122.444283251471 | (37.7893691777902, -122.444283251471) | |||
| 76690 | 76690 | 35734 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 202 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 6 | Permit Number 47062 | 6010246.45985 | 2093710.9780400002 | 37.7295097141809 | -122.40685127987899 | (37.7295097141809, -122.406851279879) | |
| 76778 | 76778 | 189168 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013001 | (37.7619199120061, -122.40337783013) | |||
| 77169 | 77169 | 34187 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 77178 | 77178 | 220638 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 222 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 5997115.15152 | 2106725.56313 | 37.7645010544003 | -122.453186433611 | (37.7645010544003, -122.453186433611) | |||
| 77274 | 77274 | 189187 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013322.92845 | 2110771.0682 | 37.7765247068749 | -122.39741149296499 | (37.7765247068749, -122.397411492965) | |||
| 77902 | 77902 | 96256 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 78317 | 78317 | 96059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 79612 | 79612 | 32135 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
| 79867 | 79867 | 16399 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 79896 | 79896 | 220604 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 446 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6003586.44761 | 2100127.58593 | 37.7467533438884 | -122.430333215209 | (37.7467533438884, -122.430333215209) | |||
| 79982 | 79982 | 99408 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 80090 | 80090 | 32128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | ||
| 80299 | 80299 | 28777 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 80980 | 80980 | 27672 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 81629 | 81629 | 27670 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 82144 | 82144 | 40782 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | ||
| 82717 | 82717 | 65437 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.782988272364705 | -122.41196892508499 | (37.7829882723647, -122.411968925085) | ||
| 82919 | 82919 | 50074 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | ||
| 84013 | 84013 | 92416 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) | |
| 84998 | 84998 | 16401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 86242 | 86242 | 42581 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.732242319303104 | -122.47039977177499 | (37.7322423193031, -122.470399771775) | ||
| 86465 | 86465 | 65417 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 887 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1989 12:00:00 AM | Permit Number 28274 | 6009256.60978604 | 2115652.27846796 | 37.7897001035195 | -122.41182310868601 | (37.7897001035195, -122.411823108686) | ||
| 86792 | 86792 | 96257 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 87495 | 87495 | 51467 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) | ||
| 88177 | 88177 | 63536 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 337 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24149 | 6006745.70850466 | 2104155.29441199 | 37.7579909553953 | -122.419694511877 | (37.7579909553953, -122.419694511877) | ||
| 88226 | 88226 | 81183 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | ||
| 88563 | 88563 | 50078 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.47222815003599 | (37.7382952135341, -122.472228150036) | ||
| 89015 | 89015 | 66177 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.739604892580296 | -122.41021864302 | (37.7396048925803, -122.41021864302) | ||
| 89567 | 89567 | 33006 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 89745 | 89745 | 33370 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 90024 | 90024 | 27668 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 90399 | 90399 | 27665 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
| 90762 | 90762 | 16404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 90780 | 90780 | 51468 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) |
| 90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 91561 | 91561 | 33364 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 91942 | 91942 | 34190 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 91999 | 91999 | 66176 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.739507066017794 | -122.41022760736601 | (37.7395070660178, -122.410227607366) | ||
| 92011 | 92011 | 99403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 92107 | 92107 | 30608 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 92319 | 92319 | 32141 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
| 92432 | 92432 | 32708 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 92549 | 92549 | 27666 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
| 92731 | 92731 | 32134 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 93445 | 93445 | 33004 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 93613 | 93613 | 30702 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 361 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34614 | 6005271.42565012 | 2110238.90565505 | 37.7746119412537 | -122.425226100731 | (37.7746119412537, -122.425226100731) | ||
| 94446 | 94446 | 27669 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
| 94467 | 94467 | 42095 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | |||
| 94647 | 94647 | 88118 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.44372532203501 | (37.7516991466356, -122.443725322035) | ||
| 95583 | 95583 | 24521 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
| 95859 | 95859 | 42786 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.774128482391205 | -122.425255647592 | (37.7741284823912, -122.425255647592) | ||
| 96760 | 96760 | 32142 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
| 97115 | 97115 | 51611 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.78476232670629 | -122.421284078173 | (37.7847623267063, -122.421284078173) | |||
| 97412 | 97412 | 50391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.732830315621705 | -122.455320609685 | (37.7328303156217, -122.455320609685) | ||
| 97534 | 97534 | 24506 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005494.49314 | 2114994.9262200003 | 37.7876834046589 | -122.424792887097 | (37.7876834046589, -122.424792887097) | |||
| 98723 | 98723 | 71559 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 919 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772718 | 6007599.61852401 | 2104303.467284 | 37.758445868977 | -122.416751817847 | (37.758445868977, -122.416751817847) |
| 99946 | 99946 | 38942 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1998 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
| 100078 | 100078 | 94131 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | ||
| 100083 | 100083 | 8408 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | ||
| 100127 | 100127 | 66898 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | ||
| 100296 | 100296 | 66897 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | ||
| 100438 | 100438 | 97940 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 100451 | 100451 | 99404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 101512 | 101512 | 66924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.41641579438298 | (37.7413986874365, -122.416415794383) | ||
| 101777 | 101777 | 91377 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 49 Seward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52069 | 6000873.0 | 2104304.0 | 37.7580666971462 | -122.440015443053 | (37.7580666971462, -122.440015443053) | |||
| 101834 | 101834 | 96061 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
| 102011 | 102011 | 38318 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767577 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |
| 102103 | 102103 | 34189 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 102801 | 102801 | 18245 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.43169496628599 | (37.7852501414757, -122.431694966286) |
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");