Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187482 | 187482 | 32718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 13 | Permit Number 37112 | 6008124.13541 | 2116125.0175900003 | 37.790934532354605 | -122.415774856832 | (37.7909345323546, -122.415774856832) | |
| 187206 | 187206 | 47445 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 811 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45355 | 5982594.30489 | 2110210.15333 | 37.77322578967961 | -122.50366731846701 | (37.7732257896796, -122.503667318467) | |
| 186673 | 186673 | 78599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1721 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6012838.148159999 | 2104697.96448 | 37.7598223206635 | -122.39866221248501 | (37.7598223206635, -122.398662212485) | ||
| 186214 | 186214 | 45562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3500 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 11 | Permit Number 44308 | 5998028.83742 | 2115512.35745 | 37.7886796396915 | -122.450659810797 | (37.7886796396915, -122.450659810797) | |
| 186201 | 186201 | 94713 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 378 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53850 | 5993742.0039800005 | 2112992.56066 | 37.7815146548766 | -122.465308397966 | (37.7815146548766, -122.465308397966) |
| 185221 | 185221 | 78048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 783 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985063.43296 | 2110545.25732 | 37.7742907524801 | -122.495151117096 | (37.7742907524801, -122.495151117096) | ||
| 184503 | 184503 | 40226 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 24 | Permit Number 41410 | 6014364.45427 | 2112502.79122 | 37.7813375610326 | -122.39392977934799 | (37.7813375610326, -122.393929779348) | |
| 181609 | 181609 | 60096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3369 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 14 | Permit Number 19597 | 5998144.72497 | 2116139.2382400003 | 37.790407520633 | -122.450304065089 | (37.790407520633, -122.450304065089) | |
| 181529 | 181529 | 41125 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 5 | Permit Number 41867 | 5998149.1404 | 2110293.0746 | 37.774355738139704 | -122.44986728758002 | (37.7743557381397, -122.44986728758) | |
| 179039 | 179039 | 41776 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42190 | 6006751.1479 | 2115848.4661 | 37.7900979108814 | -122.420505706434 | (37.7900979108814, -122.420505706434) | |
| 178404 | 178404 | 71238 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 4 | 6001314.2765 | 2112604.1281 | 37.7808818966461 | -122.439084183551 | (37.7808818966461, -122.439084183551) | ||
| 177890 | 177890 | 73918 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 7 | 6004497.3871 | 2111109.5855 | 37.776958856214 | -122.42796571067 | (37.776958856214, -122.42796571067) | ||
| 177495 | 177495 | 73449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6004263.46084 | 2092033.9823200002 | 37.724568462935295 | -122.427415688595 | (37.7245684629353, -122.427415688595) | ||
| 175251 | 175251 | 116387 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 3x3 | 6012828.85686 | 2106647.76969 | 37.765175536957 | -122.398831189703 | (37.765175536957, -122.398831189703) | ||
| 174592 | 174592 | 37957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015227.61132 | 2105153.8731400003 | 37.7612069852338 | -122.390430017258 | (37.7612069852338, -122.390430017258) | |
| 174536 | 174536 | 60097 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3375 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 14 | Permit Number 19598 | 5998106.03883 | 2116134.92 | 37.7903934498444 | -122.450437604508 | (37.7903934498444, -122.450437604508) | |
| 171578 | 171578 | 48783 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 6 | Permit Number 46038 | 6008763.21846 | 2113151.61883 | 37.782806204271395 | -122.413353282927 | (37.7828062042714, -122.413353282927) | |
| 169920 | 169920 | 37960 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015229.736819999 | 2105103.5126900002 | 37.7610688241989 | -122.39041914714501 | (37.7610688241989, -122.390419147145) | |
| 167677 | 167677 | 84556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 5 | 5986323.51581 | 2110116.60697 | 37.7731874908554 | -122.49076077364201 | (37.7731874908554, -122.490760773642) | ||
| 167517 | 167517 | 81822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 2 | 6014995.08745 | 2104204.61069 | 37.7585876135316 | -122.391167870527 | (37.7585876135316, -122.391167870527) | ||
| 167061 | 167061 | 41356 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2000 12:00:00 AM | 15 | Permit Number 42006 | 5998501.11002 | 2116122.08079 | 37.7903807999818 | -122.44906976535201 | (37.7903807999818, -122.449069765352) | |
| 166283 | 166283 | 70678 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1237 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009493.1189 | 2110090.7425 | 37.7744427137413 | -122.410611903339 | (37.7744427137413, -122.410611903339) | ||
| 165070 | 165070 | 68353 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | 9 | Permit Number 32173 | 5991577.3685800005 | 2111540.92265 | 37.777403783844 | -122.47269105029498 | (37.777403783844, -122.472691050295) | |
| 163627 | 163627 | 33266 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 16 | Permit Number 37441 | 6009282.50963 | 2116419.10375 | 37.791807072592604 | -122.411787704436 | (37.7918070725926, -122.411787704436) | |
| 162316 | 162316 | 63864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 4 | Permit Number 24566 | 6003110.8986 | 2110586.8645 | 37.7754450574799 | -122.432724647257 | (37.7754450574799, -122.432724647257) | |
| 161593 | 161593 | 43753 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43389 | 5991242.5374300005 | 2113051.1860700003 | 37.781531164196 | -122.47395954336201 | (37.781531164196, -122.473959543362) | |
| 160953 | 160953 | 31488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1014 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35052 | 6003120.510980001 | 2102286.73127 | 37.7526554461029 | -122.43209853943 | (37.7526554461029, -122.43209853943) | |
| 158987 | 158987 | 63993 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 935 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 10 | Permit Number 24740 | 6007365.07211 | 2120530.50227 | 37.802988191622795 | -122.418713747768 | (37.8029881916228, -122.418713747768) | |
| 158795 | 158795 | 52115 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 698 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 13 | Permit Number 48305 | 6004550.13535 | 2110883.8447 | 37.7763420113959 | -122.42776714996 | (37.7763420113959, -122.42776714996) | |
| 156551 | 156551 | 116385 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 13 | 3x3 | 6012828.15068 | 2106679.17539 | 37.76526173067471 | -122.398835836532 | (37.7652617306747, -122.398835836532) | ||
| 151972 | 151972 | 32802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | Permit Number 37163 | 5999966.1178 | 2110245.6106 | 37.7743292075557 | -122.443578634389 | (37.7743292075557, -122.443578634389) | |
| 151377 | 151377 | 67312 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 766 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 5 | Permit Number 30793 | 5992908.156769999 | 2110250.5229700003 | 37.773937638315 | -122.467993572826 | (37.773937638315, -122.467993572826) | |
| 149722 | 149722 | 52120 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 746 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4 | Permit Number 48307 | 6004256.6307 | 2110842.919 | 37.7762130321261 | -122.42877954616199 | (37.7762130321261, -122.428779546162) | |
| 149508 | 149508 | 41719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 509 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42167 | 5999687.8309 | 2110274.8185 | 37.77439352983821 | -122.444543376584 | (37.7743935298382, -122.444543376584) | |
| 149368 | 149368 | 59225 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 726 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 15 | Permit Number 30799 | 5992899.0374 | 2110485.42999 | 37.7745821032211 | -122.468042208505 | (37.7745821032211, -122.468042208505) | |
| 148399 | 148399 | 30516 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 375 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 7 | Permit Number 42914 | 6008644.40916 | 2113485.04991 | 37.783715054661705 | -122.413787907302 | (37.7837150546617, -122.413787907302) | |
| 145847 | 145847 | 35963 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 725 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39120 | 6006183.36687276 | 2096689.94056482 | 37.737461100246 | -122.421109257926 | (37.737461100246, -122.421109257926) | ||
| 144875 | 144875 | 40597 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 144615 | 144615 | 66262 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 406 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29365 | 5998101.39168775 | 2098008.15814258 | 37.7406216899064 | -122.449147251035 | (37.7406216899064, -122.449147251035) | ||
| 143952 | 143952 | 33270 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 143495 | 143495 | 39290 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142966 | 142966 | 41660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42128 | 5999720.90250233 | 2104674.14058563 | 37.759017358484 | -122.44402647097999 | (37.759017358484, -122.44402647098) | ||
| 142155 | 142155 | 39289 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 141079 | 141079 | 116383 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 ARKANSAS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6012767.6 | 2106714.8 | 37.7653561738939 | -122.399047769046 | (37.7653561738939, -122.399047769046) | |||
| 141025 | 141025 | 62111 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3356 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1985 12:00:00 AM | Permit Number 22211 | 6006696.74836366 | 2102059.40313392 | 37.752233362336504 | -122.419715127552 | (37.7522333623365, -122.419715127552) | ||
| 140371 | 140371 | 39307 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 139661 | 139661 | 65672 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 410 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28592 | 5998124.07489546 | 2097968.25589153 | 37.7405134253056 | -122.44906594777201 | (37.7405134253056, -122.449065947772) | ||
| 139513 | 139513 | 49902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 139207 | 139207 | 41135 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1790 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41874 | 5998011.03341214 | 2108932.61643319 | 37.770612366717 | -122.450246938029 | (37.770612366717, -122.450246938029) | ||
| 137465 | 137465 | 71445 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 60 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 14 | 6013056.352080001 | 2118942.99059 | 37.798948052957 | -122.398907344312 | (37.798948052957, -122.398907344312) | ||
| 137073 | 137073 | 37959 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40192 | 6015221.8904099995 | 2105253.72993 | 37.7614808530901 | -122.390456781078 | (37.7614808530901, -122.390456781078) | |
| 135911 | 135911 | 70116 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 14 | 6006256.51205 | 2117265.43085 | 37.793960654804295 | -122.422317826729 | (37.7939606548043, -122.422317826729) | ||
| 135465 | 135465 | 32767 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 921 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 10 | Permit Number 37273 | 6015272.11857 | 2104284.39215 | 37.758822046111 | -122.390215337371 | (37.758822046111, -122.390215337371) | |
| 133520 | 133520 | 42594 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 12 | Permit Number 42666 | 6004954.56344 | 2117817.05919 | 37.795401759928104 | -122.42686200478799 | (37.7954017599281, -122.426862004788) | |
| 132866 | 132866 | 32609 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37075 | 5985785.2482 | 2106404.8747 | 37.762964658627 | -122.492349308745 | (37.762964658627, -122.492349308745) | |
| 130878 | 130878 | 43690 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 366 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 7 | Permit Number 43334 | 5993429.16856 | 2113028.2999 | 37.7815947391234 | -122.466393247505 | (37.7815947391234, -122.466393247505) | |
| 130760 | 130760 | 37958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015227.3668599995 | 2105129.80279 | 37.7611408796801 | -122.39042918086399 | (37.7611408796801, -122.390429180864) | |
| 129508 | 129508 | 32801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1640 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37163 | 5999986.448 | 2110250.0303 | 37.7743425023806 | -122.443508626239 | (37.7743425023806, -122.443508626239) | |
| 127994 | 127994 | 46947 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 127809 | 127809 | 112263 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 127563 | 127563 | 39288 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 127041 | 127041 | 115596 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 126895 | 126895 | 52240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 637 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2005 12:00:00 AM | 14 | Permit Number 48411 | 6014148.51957 | 2104183.0375599996 | 37.758481362245 | -122.394094197011 | (37.758481362245, -122.394094197011) | |
| 126041 | 126041 | 66248 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 420 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29348 | 5998199.25960991 | 2097894.34900813 | 37.7403147945895 | -122.448800667322 | (37.7403147945895, -122.448800667322) | ||
| 125811 | 125811 | 40580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 125807 | 125807 | 39528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40969 | 6012854.83375701 | 2106613.68395322 | 37.765083392480605 | -122.398738948997 | (37.7650833924806, -122.398738948997) | ||
| 125379 | 125379 | 33269 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 124539 | 124539 | 121304 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 124497 | 124497 | 61101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3075 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20942 | 6007791.37418994 | 2103237.58364273 | 37.7555299798671 | -122.41601315723999 | (37.7555299798671, -122.41601315724) | ||
| 123842 | 123842 | 49905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 123828 | 123828 | 45563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3500 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 11 | Permit Number 44308 | 5998013.737930001 | 2115510.1738 | 37.7886727796678 | -122.45071189506399 | (37.7886727796678, -122.450711895064) | |
| 123481 | 123481 | 68691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4639 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32601 | 5993244.83438124 | 2114136.0623562 | 37.7846257148972 | -122.46711151533701 | (37.7846257148972, -122.467111515337) | ||
| 122352 | 122352 | 39280 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 122264 | 122264 | 39273 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40884 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||
| 122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 120943 | 120943 | 121302 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 120768 | 120768 | 41659 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42128 | 5999720.90250233 | 2104674.14058563 | 37.759017358484 | -122.44402647097999 | (37.759017358484, -122.44402647098) | ||
| 120184 | 120184 | 39310 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 119189 | 119189 | 61852 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1111 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32348 | 6010289.45166146 | 2102742.39978594 | 37.7543104490633 | -122.407339083447 | (37.7543104490633, -122.407339083447) | ||
| 118831 | 118831 | 49904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 118163 | 118163 | 32010 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2002 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1995 12:00:00 AM | Permit Number 35405 | 6003915.74450462 | 2115298.16977388 | 37.7884267396179 | -122.43027669406 | (37.7884267396179, -122.43027669406) | ||
| 117805 | 117805 | 50199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 137REVISED Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2004 12:00:00 AM | Permit Number 46906 | 5999872.84856038 | 2108949.39506285 | 37.7707648080184 | -122.443808124031 | (37.7707648080184, -122.443808124031) | ||
| 117652 | 117652 | 45686 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2001 12:00:00 AM | Permit Number 44372 | 6000482.11013165 | 2115133.23910005 | 37.787778798038104 | -122.442144646612 | (37.7877787980381, -122.442144646612) | ||
| 116752 | 116752 | 68518 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1722 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32398 | 5993753.19333564 | 2103765.68848708 | 37.756180747574 | -122.46459949821501 | (37.756180747574, -122.464599498215) | ||
| 115443 | 115443 | 61147 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1917 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 21003 | 5998690.60672318 | 2110015.33456804 | 37.7736241011269 | -122.4479742617 | (37.7736241011269, -122.4479742617) | ||
| 114398 | 114398 | 46946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 113776 | 113776 | 32791 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 112974 | 112974 | 35946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 41 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39108 | 6005372.49697946 | 2095946.00487356 | 37.735372674911794 | -122.423859934844 | (37.7353726749118, -122.423859934844) |
| 112647 | 112647 | 69453 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 459 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 15 | 6x9 | Permit Number 33563 | 5985605.84685 | 2112812.05347 | 37.780546467003 | -122.49344188362801 | (37.780546467003, -122.493441883628) |
| 112337 | 112337 | 112261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 111712 | 111712 | 39291 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 111665 | 111665 | 115601 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | ||||
| 110937 | 110937 | 36985 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4620 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39608 | 5993296.48645654 | 2114189.85752236 | 37.7847764030666 | -122.466936730196 | (37.7847764030666, -122.466936730196) | ||
| 110199 | 110199 | 64813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4180 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25816 | 6002719.62946943 | 2100377.06444205 | 37.7473892155106 | -122.43334840813999 | (37.7473892155106, -122.43334840814) | ||
| 109882 | 109882 | 31532 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 109411 | 109411 | 115598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 108729 | 108729 | 67498 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 69 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31026 | 5999574.85237964 | 2093753.94204942 | 37.729024779719296 | -122.443747050581 | (37.7290247797193, -122.443747050581) | ||
| 107360 | 107360 | 59569 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 515 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1981 12:00:00 AM | Permit Number 18959 | 6007497.22787602 | 2096469.08485294 | 37.736928657886 | -122.416550971645 | (37.736928657886, -122.416550971645) | ||
| 107150 | 107150 | 116384 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 ARKANSAS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6012767.6 | 2106714.8 | 37.7653561738939 | -122.399047769046 | (37.7653561738939, -122.399047769046) | |||
| 106855 | 106855 | 40577 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) |
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");