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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10187 | 10187 | 173885 | Tree(s) :: 17 | 410 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774920 | 5998687.3529 | 2094401.8148700001 | 37.7307530256695 | -122.446861792344 | (37.7307530256695, -122.446861792344) | ||
| 10251 | 10251 | 173771 | Tree(s) :: 17 | 231 Stratford Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779366 | 5990884.97189 | 2090977.2345099999 | 37.7209011553391 | -122.47358587031601 | (37.7209011553391, -122.473585870316) | ||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 93324 | 93324 | 32776 | Tree(s) :: 17 | 552 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2010 12:00:00 AM | Permit Number 54024 | 6001158.24288979 | 2110568.68225327 | 37.775284198166496 | -122.43947802668 | (37.7752841981665, -122.43947802668) | |||
| 104127 | 104127 | 105442 | Tree(s) :: 17 | 38 Museum Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000691.7 | 2106753.8 | 37.764782922965004 | -122.440818185531 | (37.764782922965, -122.440818185531) | ||||||
| 119480 | 119480 | 87425 | Tree(s) :: 17 | 25X Jones St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009102.081359 | 2112621.9601169997 | 37.781370907497 | -122.41214351023399 | (37.781370907497, -122.412143510234) | ||||
| 51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
| 57 | 57 | 44642 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 77 | 77 | 49739 | Permitted Site 1 | Tree(s) :: 17 | 145 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779552 | 6013462.1222 | 2106403.54987 | 37.764540227980206 | -122.396623740816 | (37.7645402279802, -122.396623740816) | |
| 89 | 89 | 251189 | Permitted Site 1 | Tree(s) :: 17 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 3x3 | 6016267.45517 | 2096986.6643299998 | 37.7388391569445 | -122.38626419104999 | (37.7388391569445, -122.38626419105) | ||
| 169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
| 172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
| 235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 297 | 297 | 32804 | Permitted Site 1 | Tree(s) :: 17 | 1683 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779644 | 5999817.40523345 | 2110171.54968226 | 37.774117372599896 | -122.44408773423099 | (37.7741173725999, -122.444087734231) | |
| 308 | 308 | 46059 | Permitted Site 1 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 316 | 316 | 67789 | Permitted Site 1 | Tree(s) :: 17 | 7 4384 St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31429 | ||||||||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 320 | 320 | 48259 | Permitted Site 1 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 321 | 321 | 65143 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | Permit Number 27118 | |||||||||
| 444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 515 | 515 | 48129 | Permitted Site 1 | Tree(s) :: 17 | 297 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 536 | 536 | 45913 | Permitted Site 1 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 604 | 604 | 171523 | Permitted Site 1 | Tree(s) :: 17 | 281 Harvard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779632 | 6006304.03409 | 2092571.58308 | 37.7261597980302 | -122.420399821019 | (37.7261597980302, -122.420399821019) | |
| 607 | 607 | 65964 | Permitted Site 1 | Tree(s) :: 17 | 2655 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779612 | 5989236.70778952 | 2097278.67232438 | 37.738107703581704 | -122.479744212489 | (37.7381077035817, -122.479744212489) | |
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
| 632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 705 | 705 | 105051 | Permitted Site 1 | Tree(s) :: 17 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.769633771891606 | -122.445015457708 | (37.7696337718916, -122.445015457708) | ||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 734 | 734 | 173936 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 743 | 743 | 224663 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008964.71968 | 2105285.1997599998 | 37.761218168313704 | -122.412100053373 | (37.7612181683137, -122.412100053373) | |
| 751 | 751 | 224664 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008962.07625 | 2105304.40117 | 37.761270742678704 | -122.412110552966 | (37.7612707426787, -122.412110552966) | |
| 755 | 755 | 224665 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008961.65131 | 2105333.13094 | 37.7613496042185 | -122.412114053139 | (37.7613496042185, -122.412114053139) | |
| 771 | 771 | 224662 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008966.3106 | 2105264.00424 | 37.7611600595223 | -122.412093053058 | (37.7611600595223, -122.412093053058) | |
| 774 | 774 | 231034 | Permitted Site 1 | Tree(s) :: 17 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008943.01244 | 2104996.16235 | 37.760423319597294 | -122.412154701577 | (37.7604233195973, -122.412154701577) | |
| 788 | 788 | 173935 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 983 | 983 | 235091 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009129.80831 | 2096850.9527 | 37.7380688642945 | -122.410933356597 | (37.7380688642945, -122.410933356597) | |
| 993 | 993 | 235090 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009124.9466 | 2096834.17608 | 37.7380225267172 | -122.410948981415 | (37.7380225267172, -122.410948981415) | |
| 1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1032 | 1032 | 164022 | Permitted Site 1 | Tree(s) :: 17 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779959 | 5998844.0 | 2107514.0 | 37.7667648389525 | -122.447263591802 | (37.7667648389525, -122.447263591802) | |
| 1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
| 1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1113 | 1113 | 45845 | Permitted Site 1 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1210 | 1210 | 44727 | Permitted Site 1 | Tree(s) :: 17 | 1234 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779706 | 5990135.3835 | 2102474.7725 | 37.752427007324 | -122.47701665532301 | (37.752427007324, -122.477016655323) | |
| 1215 | 1215 | 218931 | Permitted Site 1 | Tree(s) :: 17 | 1353 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779656 | 5994855.14791 | 2106335.8141799998 | 37.7633011159875 | -122.460974863827 | (37.7633011159875, -122.460974863827) | |
| 1225 | 1225 | 44628 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1232 | 1232 | 182646 | Permitted Site 1 | Tree(s) :: 17 | 1234 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779706 | 5990115.3264 | 2102475.6639 | 37.7524282912752 | -122.47708608048 | (37.7524282912752, -122.47708608048) | |
| 1239 | 1239 | 187690 | Permitted Site 1 | Tree(s) :: 17 | 876 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779712 | 6008536.0 | 2103448.0 | 37.7561495727301 | -122.413452882223 | (37.7561495727301, -122.413452882223) | |
| 1251 | 1251 | 225915 | Permitted Site 1 | Tree(s) :: 17 | 1115 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779648 | 6010030.36922 | 2102582.89023 | 37.7538579673932 | -122.408223810779 | (37.7538579673932, -122.408223810779) | |
| 1323 | 1323 | 41265 | Permitted Site 1 | Tree(s) :: 17 | 2929 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779089 | 6002901.9749300005 | 2118724.9020700003 | 37.7977781914725 | -122.434029221987 | (37.7977781914725, -122.434029221987) | |
| 1418 | 1418 | 48339 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1455 | 1455 | 184625 | Permitted Site 1 | Tree(s) :: 17 | 1762 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2017 12:00:00 AM | 3 | 4x4 | Permit Number 778834 | 5981059.357000001 | 2103059.0208 | 37.7535004788576 | -122.50844586217698 | (37.7535004788576, -122.508445862177) | |
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1499 | 1499 | 44884 | Permitted Site 1 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1511 | 1511 | 45972 | Permitted Site 1 | Tree(s) :: 17 | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1526 | 1526 | 44588 | Permitted Site 1 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1532 | 1532 | 44561 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1591 | 1591 | 63351 | Permitted Site 1 | Tree(s) :: 17 | 3020 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780039 | 6000130.91921 | 2115807.05661 | 37.7896089046631 | -122.44340811579501 | (37.7896089046631, -122.443408115795) | |
| 1734 | 1734 | 247340 | Permitted Site 1 | Tree(s) :: 17 | 307 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779988 | 6003225.5695 | 2109437.2242 | 37.7722949315945 | -122.43224585173401 | (37.7722949315945, -122.432245851734) | |
| 1764 | 1764 | 33168 | Permitted Site 1 | Tree(s) :: 17 | 2221 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773963 | 5986287.4 | 2098860.0 | 37.7422778317635 | -122.490057581406 | (37.7422778317635, -122.490057581406) | |
| 1765 | 1765 | 45968 | Permitted Site 1 | Tree(s) :: 17 | 155 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1804 | 1804 | 44554 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1823 | 1823 | 38862 | Permitted Site 1 | Tree(s) :: 17 | 1551 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779966 | 5989293.07470895 | 2104790.33093507 | 37.7587360109051 | -122.4800989152 | (37.7587360109051, -122.4800989152) | |
| 1863 | 1863 | 33121 | Permitted Site 1 | Tree(s) :: 17 | 2360 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2017 12:00:00 AM | 3 | Permit Number 780047 | 6001597.15977 | 2119079.49 | 37.7986776600995 | -122.438569654391 | (37.7986776600995, -122.438569654391) | |
| 1864 | 1864 | 44087 | Permitted Site 1 | Tree(s) :: 17 | 500 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013716.56338 | 2112456.73733 | 37.7811750796017 | -122.396167952707 | (37.7811750796017, -122.396167952707) | |
| 1885 | 1885 | 30481 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 147 | |||||||||
| 1959 | 1959 | 48104 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1973 | 1973 | 66343 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | Permit Number 29464 | |||||||||
| 2019 | 2019 | 48201 | Permitted Site 1 | Tree(s) :: 17 | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 2023 | 2023 | 35053 | Permitted Site 1 | Tree(s) :: 17 | 700 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 2039 | 2039 | 45572 | Permitted Site 1 | Tree(s) :: 17 | 1951 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2017 12:00:00 AM | 3 | Permit Number 779446 | 5999433.18152 | 2115607.6653299998 | 37.7890216140951 | -122.44580786133999 | (37.7890216140951, -122.44580786134) | |
| 2086 | 2086 | 45988 | Permitted Site 1 | Tree(s) :: 17 | 223 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2115 | 2115 | 44893 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2154 | 2154 | 45014 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2193 | 2193 | 46043 | Permitted Site 1 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2195 | 2195 | 44993 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2215 | 2215 | 62177 | Permitted Site 1 | Tree(s) :: 17 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 15 | 3x3 | Permit Number 780357 | 6000151.498869999 | 2091775.04378 | 37.723624054296295 | -122.44161159051599 | (37.7236240542963, -122.441611590516) |
| 2304 | 2304 | 44646 | Permitted Site 1 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 |
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");