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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189039 | 189039 | 117389 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006295.544430001 | 2117317.5523599996 | 37.7941059690696 | -122.42218647533998 | (37.7941059690696, -122.42218647534) | |||
| 188691 | 188691 | 60492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1982 12:00:00 AM | 16 | Permit Number 20090 | 6005025.8027 | 2113323.9775 | 37.783068912088 | -122.42629545390699 | (37.783068912088, -122.426295453907) | ||
| 188503 | 188503 | 106738 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006290.51922 | 2117597.30119 | 37.7948738057383 | -122.42222374772301 | (37.7948738057383, -122.422223747723) | |
| 188439 | 188439 | 48708 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 6 | Permit Number 45976 | 6014000.73763 | 2115276.8947099997 | 37.7889343906698 | -122.39538246774599 | (37.7889343906698, -122.395382467746) | ||
| 188343 | 188343 | 113059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776016 | 6000289.21565 | 2117461.28412 | 37.7941600057183 | -122.44297927319599 | (37.7941600057183, -122.442979273196) | |
| 188282 | 188282 | 44019 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007852.239130001 | 2112732.3547 | 37.7816038169983 | -122.416475189498 | (37.7816038169983, -122.416475189498) | ||
| 188104 | 188104 | 50580 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | 8 | Permit Number 56162 | 6006391.85485 | 2121486.039 | 37.805557008807504 | -122.422149515895 | (37.8055570088075, -122.422149515895) | ||
| 187721 | 187721 | 94282 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 5998306.81105 | 2115836.29563 | 37.789584995308296 | -122.449721420432 | (37.7895849953083, -122.449721420432) | ||||
| 187712 | 187712 | 42534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 616 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42640 | 6009431.8080400005 | 2111539.80243 | 37.778418054096605 | -122.41092635717199 | (37.7784180540966, -122.410926357172) | ||
| 187635 | 187635 | 41263 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2430 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | 8 | Permit Number 41950 | 6007052.18114 | 2120671.77147 | 37.8033584595886 | -122.41980654544099 | (37.8033584595886, -122.419806545441) | ||
| 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) | |
| 187333 | 187333 | 58713 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 680 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1979 12:00:00 AM | 14 | Permit Number 17947 | 6004611.37306 | 2110893.76935 | 37.7763727259597 | -122.427556018821 | (37.7763727259597, -122.427556018821) | ||
| 187293 | 187293 | 93552 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2255 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2010 12:00:00 AM | 16 | 3x3 | Permit Number 53247 | 5999300.87312 | 2116569.26617 | 37.7916543614119 | -122.446334832597 | (37.7916543614119, -122.446334832597) | |
| 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) | |
| 186662 | 186662 | 110195 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1890 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5998786.0591 | 2110425.299 | 37.774755214093 | -122.447673596734 | (37.774755214093, -122.447673596734) | |||
| 186482 | 186482 | 57082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 16 | Permit Number 14349 | 5992700.43493 | 2114720.19275 | 37.7861981373728 | -122.469037463703 | (37.7861981373728, -122.469037463703) | ||
| 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) |
| 186190 | 186190 | 58089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1977 12:00:00 AM | 8 | Permit Number 17061 | 6004464.66499 | 2117743.64004 | 37.795172457994106 | -122.42855189925601 | (37.7951724579941, -122.428551899256) | ||
| 186165 | 186165 | 50326 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 9 | Permit Number 47027 | 6011571.59486 | 2113053.82803 | 37.7826949698513 | -122.403630544136 | (37.7826949698513, -122.403630544136) | ||
| 186039 | 186039 | 48890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985723.18076 | 2113238.27416 | 37.781723609133394 | -122.493067382279 | (37.7817236091334, -122.493067382279) | ||
| 185658 | 185658 | 66291 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2638 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 7 | Permit Number 29721 | 5999216.28245 | 2117883.67217 | 37.7952585401923 | -122.44672213012801 | (37.7952585401923, -122.446722130128) | ||
| 185297 | 185297 | 60185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2863 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1982 12:00:00 AM | 13 | Permit Number 19718 | 6000424.88643 | 2116781.78626 | 37.7923020171871 | -122.442461031666 | (37.7923020171871, -122.442461031666) | ||
| 185294 | 185294 | 94525 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2010 12:00:00 AM | 3 | Permit Number 53714 | 6001142.2302 | 2113794.1445 | 37.784139586715796 | -122.43976471776399 | (37.7841395867158, -122.439764717764) | ||
| 185166 | 185166 | 41045 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3035 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1999 12:00:00 AM | 9 | Permit Number 41826 | 5999619.8379 | 2116669.53364 | 37.7919478812301 | -122.445238433108 | (37.7919478812301, -122.445238433108) | ||
| 185102 | 185102 | 35062 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 7 | Permit Number 41350 | 6014151.3296 | 2092812.8657 | 37.7272614022518 | -122.393288830363 | (37.7272614022518, -122.393288830363) | ||
| 185080 | 185080 | 61190 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1983 12:00:00 AM | 13 | Permit Number 21052 | 6006267.44697 | 2117996.2168799997 | 37.7959678265213 | -122.422331937987 | (37.7959678265213, -122.422331937987) | ||
| 184952 | 184952 | 106737 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 4 | 3x3 | Permit Number 773198 | 6006268.17593 | 2117593.2029 | 37.7948612925596 | -122.42230076746901 | (37.7948612925596, -122.422300767469) | |
| 184602 | 184602 | 54000 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 19 | Permit Number 9718 | 6010673.62628 | 2089402.8086700002 | 37.71770426600779 | -122.40507128591001 | (37.7177042660078, -122.40507128591) | ||
| 184514 | 184514 | 56066 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1988 12:00:00 AM | 16 | Permit Number 25291 | 6001224.68553 | 2117156.35271 | 37.793376034315 | -122.439720581565 | (37.793376034315, -122.439720581565) | ||
| 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) | |
| 184032 | 184032 | 57999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 871 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1977 12:00:00 AM | 19 | Permit Number 16964 | 5983538.74255 | 2109889.72287 | 37.772401462891004 | -122.50037673928499 | (37.772401462891, -122.500376739285) | ||
| 183504 | 183504 | 97705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 4 | 4x8 | Permit Number 56162 | 6006172.56674 | 2121455.2767 | 37.805460172501 | -122.42290620636001 | (37.805460172501, -122.42290620636) | |
| 182915 | 182915 | 40120 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43544 | 6011849.73829 | 2105164.57827 | 37.761048420380796 | -122.40211346246099 | (37.7610484203808, -122.402113462461) | |
| 182663 | 182663 | 97701 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 5 | 4x8 | Permit Number 56162 | 6006233.520269999 | 2121465.78 | 37.805492450988496 | -122.42269601500799 | (37.8054924509885, -122.422696015008) | |
| 182628 | 182628 | 34911 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1137 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1997 12:00:00 AM | 16 | Permit Number 38512 | 6007603.44226 | 2116356.76889 | 37.7915415792431 | -122.41759287052099 | (37.7915415792431, -122.417592870521) | ||
| 181966 | 181966 | 48759 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 8 | Permit Number 46024 | 6015250.56942 | 2112972.49973 | 37.7826764806794 | -122.390897065741 | (37.7826764806794, -122.390897065741) | ||
| 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) | |
| 181271 | 181271 | 44272 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2835 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | 7 | Permit Number 43699 | 6000038.18901 | 2117070.5239 | 37.7930727658465 | -122.443819762467 | (37.7930727658465, -122.443819762467) | ||
| 181250 | 181250 | 93715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 53306 | 6013992.279630001 | 2115354.39003 | 37.7891467044149 | -122.39541716269699 | (37.7891467044149, -122.395417162697) | ||
| 181245 | 181245 | 33773 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2640 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | 12 | Permit Number 37820 | 5999639.77056 | 2117940.89784 | 37.7954398489265 | -122.44526091526001 | (37.7954398489265, -122.44526091526) | ||
| 181184 | 181184 | 30289 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2556 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 133 | 6000738.36176 | 2118613.3196099997 | 37.7973487894679 | -122.441507891481 | (37.7973487894679, -122.441507891481) | |||
| 181126 | 181126 | 40951 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2009 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | 14 | Permit Number 41807 | 6003321.51287 | 2118227.75979 | 37.796436967742 | -122.432541977155 | (37.796436967742, -122.432541977155) | ||
| 181002 | 181002 | 101738 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 21052 | 6006078.36195 | 2117970.48855 | 37.7958865152173 | -122.422984379952 | (37.7958865152173, -122.422984379952) | |||
| 180942 | 180942 | 59529 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 316 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1981 12:00:00 AM | 10 | Permit Number 18911 | 6011029.93343 | 2111422.70211 | 37.7781860074155 | -122.405389564093 | (37.7781860074155, -122.405389564093) | ||
| 180219 | 180219 | 97700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 6 | 4x8 | Permit Number 56162 | 6006261.64827 | 2121469.12065 | 37.805503210468395 | -122.42259891161699 | (37.8055032104684, -122.422598911617) | |
| 179807 | 179807 | 85301 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1998 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2007 12:00:00 AM | 22 | Permit Number 49588 | 6004620.85955 | 2117413.32658 | 37.7942743392338 | -122.42798789214399 | (37.7942743392338, -122.427987892144) | ||
| 179719 | 179719 | 55178 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2102 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | 17 | Permit Number 11087 | 6003476.980219999 | 2117606.46103 | 37.7947398562165 | -122.43195964002199 | (37.7947398562165, -122.431959640022) | ||
| 179564 | 179564 | 34881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 12 | Permit Number 38492 | 6014682.09423 | 2115822.57014 | 37.7904705613091 | -122.39306324298799 | (37.7904705613091, -122.393063242988) | ||
| 179513 | 179513 | 97716 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100x Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 4 | 4x8 | Permit Number 56162 | 6005962.77838 | 2121531.80747 | 37.8056584667326 | -122.42363765286301 | (37.8056584667326, -122.423637652863) | |
| 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) | |
| 178275 | 178275 | 97694 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 6 | 4x8 | Permit Number 56162 | 6006362.212280001 | 2121483.92188 | 37.8055495237667 | -122.42225194779199 | (37.8055495237667, -122.422251947792) | |
| 178270 | 178270 | 97706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 3 | 4x8 | Permit Number 771764 | 6006154.05787 | 2121453.78292 | 37.8054550265821 | -122.42297015265801 | (37.8054550265821, -122.422970152658) | |
| 177874 | 177874 | 53376 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 615 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1969 12:00:00 AM | 12 | Permit Number 6272 | 6012726.4423 | 2104522.31178 | 37.759333792731205 | -122.399036221654 | (37.7593337927312, -122.399036221654) | ||
| 177795 | 177795 | 58881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2611 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1980 12:00:00 AM | 13 | Permit Number 18145 | 6000348.27162 | 2118512.6376900002 | 37.797050112026795 | -122.442850465993 | (37.7970501120268, -122.442850465993) | ||
| 177287 | 177287 | 60101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1065 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 13 | Permit Number 29837 | 6007505.4343 | 2115057.05119 | 37.787967358662705 | -122.41783980727199 | (37.7879673586627, -122.417839807272) | ||
| 176816 | 176816 | 102531 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5499 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768962 | 5990599.66311 | 2114037.49002 | 37.78420202225121 | -122.476255621527 | (37.7842020222512, -122.476255621527) | |
| 176460 | 176460 | 106736 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006250.8348900005 | 2117590.81509 | 37.7948537580534 | -122.42236060026698 | (37.7948537580534, -122.422360600267) | |
| 175762 | 175762 | 30418 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2509 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1956 12:00:00 AM | 12 | Permit Number 73 | 6000919.61601 | 2118590.12909 | 37.797295438976896 | -122.44087904234199 | (37.7972954389769, -122.440879042342) | ||
| 175590 | 175590 | 64396 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 9 | Permit Number 25238 | 6014825.71904 | 2116189.42708 | 37.7914858428567 | -122.392591979359 | (37.7914858428567, -122.392591979359) | ||
| 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) | ||
| 175249 | 175249 | 97696 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 6 | 4x8 | Permit Number 56162 | 6006335.43874 | 2121479.8717 | 37.8055368927886 | -122.422344313546 | (37.8055368927886, -122.422344313546) | |
| 175180 | 175180 | 48760 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 2 | Permit Number 46024 | 6015271.681530001 | 2112993.844 | 37.7827362586252 | -122.390825518378 | (37.7827362586252, -122.390825518378) | ||
| 174738 | 174738 | 106739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006308.23049 | 2117598.1394 | 37.794877106244606 | -122.42216252370199 | (37.7948771062446, -122.422162523702) | |
| 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) | |
| 174405 | 174405 | 50727 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3101 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47278 | 5999820.18681 | 2116042.5685900003 | 37.7902378338637 | -122.44450014727501 | (37.7902378338637, -122.444500147275) | ||
| 174281 | 174281 | 107970 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001251.207140001 | 2116633.12968 | 37.7919409096905 | -122.439591288703 | (37.7919409096905, -122.439591288703) | |||
| 173088 | 173088 | 106422 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6006057.80404 | 2121440.5977 | 37.8054133915718 | -122.42330231457198 | (37.8054133915718, -122.423302314572) | ||||
| 172536 | 172536 | 48754 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 6 | Permit Number 46024 | 6015472.988419999 | 2113185.10635 | 37.7832725891017 | -122.39014244194401 | (37.7832725891017, -122.390142441944) | ||
| 171983 | 171983 | 50335 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 11 | Permit Number 47027 | 6011504.68398 | 2112991.16238 | 37.782519166777895 | -122.40385761753299 | (37.7825191667779, -122.403857617533) | ||
| 171828 | 171828 | 117267 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2420 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 778065 | 6001282.64713 | 2116736.29992 | 37.7922259776859 | -122.439489905429 | (37.7922259776859, -122.439489905429) | ||
| 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) | |
| 171236 | 171236 | 94347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1160 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2010 12:00:00 AM | 14 | 3x3 | Permit Number 53632 | 6012294.8491400005 | 2120000.64626 | 37.8018096588565 | -122.401616790282 | (37.8018096588565, -122.401616790282) | |
| 171219 | 171219 | 64448 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2663 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1988 12:00:00 AM | 8 | Permit Number 25315 | 6000639.921709999 | 2117486.92161 | 37.7942503885102 | -122.441767636387 | (37.7942503885102, -122.441767636387) | ||
| 170890 | 170890 | 97436 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 6004989.17293 | 2117465.32107 | 37.7944379331231 | -122.426717189648 | (37.7944379331231, -122.426717189648) | ||||
| 170698 | 170698 | 50331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 6 | Permit Number 53108 | 6011486.904569999 | 2112973.18308 | 37.7824688065362 | -122.40391786131399 | (37.7824688065362, -122.403917861314) | ||
| 170541 | 170541 | 48891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985690.94714 | 2113237.00512 | 37.781718239515705 | -122.49317880031299 | (37.7817182395157, -122.493178800313) | ||
| 170381 | 170381 | 88658 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 716 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51635 | 6004376.9691 | 2110859.9669 | 37.7762666516219 | -122.42836447811001 | (37.7762666516219, -122.42836447811) | |
| 170359 | 170359 | 94283 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3445 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5998292.753880001 | 2115833.6649700003 | 37.789576967964 | -122.449769866892 | (37.789576967964, -122.449769866892) | ||||
| 170298 | 170298 | 55464 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 817 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 14 | Permit Number 11415 | 6003764.6757 | 2111074.1497 | 37.776820078702706 | -122.43049785477301 | (37.7768200787027, -122.430497854773) | ||
| 170133 | 170133 | 97708 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 5 | 4x8 | Permit Number 56162 | 6006127.29476 | 2121450.2436900004 | 37.8054437985674 | -122.423062518416 | (37.8054437985674, -122.423062518416) | |
| 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) | |
| 169739 | 169739 | 93716 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 53306 | 6013981.28856 | 2115344.19884 | 37.789118110457004 | -122.39545447644699 | (37.789118110457, -122.395454476447) | ||
| 169434 | 169434 | 45568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 1 | Permit Number 772596 | 5998090.07255 | 2115572.48086 | 37.7888482275181 | -122.45045228325 | (37.7888482275181, -122.45045228325) | ||
| 168602 | 168602 | 57545 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1154 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1976 12:00:00 AM | 12 | Permit Number 16404 | 6006316.61344 | 2120431.07501 | 37.8026561034526 | -122.42233489676201 | (37.8026561034526, -122.422334896762) | ||
| 168601 | 168601 | 97709 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2008 12:00:00 AM | 5 | 4x8 | Permit Number 56162 | 6006113.73852 | 2121448.3075099997 | 37.8054377173305 | -122.42310929396002 | (37.8054377173305, -122.42310929396) | |
| 167944 | 167944 | 30433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 341 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 8 | Permit Number 86 | 6011286.31064 | 2119684.8725 | 37.80088629253979 | -122.40508457338998 | (37.8008862925398, -122.40508457339) | ||
| 167626 | 167626 | 112435 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6012216.81066 | 2120584.93709 | 37.8034096247177 | -122.401927938628 | (37.8034096247177, -122.401927938628) | |||
| 167493 | 167493 | 113517 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6008826.1188900005 | 2113161.19235 | 37.7828360222128 | -122.413136350284 | (37.7828360222128, -122.413136350284) | ||||
| 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) | |
| 166862 | 166862 | 106530 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Laurel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 1 | Permit Number 772596 | 5998088.611330001 | 2115587.62473 | 37.7888897249384 | -122.450458431005 | (37.7888897249384, -122.450458431005) | ||
| 166795 | 166795 | 50643 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 5 | Permit Number 47231 | 6011987.58292 | 2108563.9259599997 | 37.7703899590537 | -122.401875677239 | (37.7703899590537, -122.401875677239) | ||
| 166411 | 166411 | 107969 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001249.24493 | 2116653.52755 | 37.7919968052569 | -122.43959954088999 | (37.7919968052569, -122.43959954089) | |||
| 166250 | 166250 | 38720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 40623 | 6001765.1389 | 2113291.0398 | 37.782793625585 | -122.437573639371 | (37.782793625585, -122.437573639371) | |||
| 165993 | 165993 | 30440 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 364 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 11 | Permit Number 93 | 6011168.38887 | 2119716.6741400003 | 37.8009670192778 | -122.40549487558901 | (37.8009670192778, -122.405494875589) | ||
| 165940 | 165940 | 114299 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6013998.084419999 | 2111768.5721299998 | 37.7793011946314 | -122.395145804856 | (37.7793011946314, -122.395145804856) | ||||
| 165738 | 165738 | 61771 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2970 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1984 12:00:00 AM | 15 | Permit Number 21790 | 5999413.21942 | 2117034.78773 | 37.7929389764029 | -122.44597961389299 | (37.7929389764029, -122.445979613893) | ||
| 165561 | 165561 | 98462 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2080 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005162.63701 | 2116769.9772099997 | 37.7925385002093 | -122.426067458244 | (37.7925385002093, -122.426067458244) |
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");