trees
968 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 6 sorted by YCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1967 | 259348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
3117 | 260221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
3183 | 260224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
5614 | 259341 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
5784 | 260220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
8715 | 260222 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
11368 | 259340 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
12542 | 262149 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4600 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | |||||||||||||
15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
16718 | 262177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
17639 | 260223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
17693 | 259347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
18773 | 255529 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782018 | ||||||||||
19156 | 259400 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1649 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
19327 | 262176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
57255 | 176878 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.7098626625021 | -122.396290845073 | (37.7098626625021, -122.396290845073) | 10 | 3 | 8 | 309 | 1 | |||
169305 | 176877 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.7099103976217 | -122.396487432357 | (37.7099103976217, -122.396487432357) | 10 | 3 | 8 | 309 | 1 | |||
127629 | 176876 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013031.56753 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | 10 | 3 | 8 | 309 | 1 | |||
79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
101851 | 176875 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.7100528322548 | -122.397074274178 | (37.7100528322548, -122.397074274178) | 10 | 3 | 8 | 309 | 1 | |||
56826 | 176874 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | 10 | 3 | 8 | 309 | 1 | |||
192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
100552 | 172375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574 | 2086750 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | 9 | 7 | 6 | 28861 | 5 | ||
174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
51610 | 176885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008580.05361 | 2087004.56736 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | 9 | 7 | 8 | 309 | 39 | |||
132775 | 180842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.451155786013 | (37.710473721248, -122.451155786013) | 9 | 7 | 6 | 28861 | 25 | ||
84873 | 69398 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.44104 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | 9 | 7 | 6 | 28861 | 5 | |
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
122783 | 159336 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | 9 | 7 | 6 | 28861 | 25 | ||
28544 | 159338 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.448328017142 | (37.7108995709325, -122.448328017142) | 9 | 7 | 6 | 28861 | 25 | ||
57846 | 159339 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.45786 | 2087195.02696 | 37.7109327990681 | -122.44828212563 | (37.7109327990681, -122.44828212563) | 9 | 7 | 6 | 28861 | 25 | ||
82967 | 25763 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.38583 | 37.711281031873 | -122.427342931648 | (37.711281031873, -122.427342931648) | 9 | 7 | 6 | 28861 | 5 | ||
141967 | 159345 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | 9 | 7 | 6 | 28861 | 25 | ||
154340 | 176919 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.7115132862848 | -122.436613103724 | (37.7115132862848, -122.436613103724) | 9 | 7 | 6 | 28861 | 5 | |||
81002 | 159346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.80621 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | 9 | 7 | 6 | 28861 | 25 | ||
139614 | 159347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.7113673820764 | -122.44773365339 | (37.7113673820764, -122.44773365339) | 9 | 7 | 6 | 28861 | 25 | ||
171958 | 159348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.36678 | 37.7114303786888 | -122.447651252104 | (37.7114303786888, -122.447651252104) | 9 | 7 | 6 | 28861 | 25 | ||
14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
134756 | 19062 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 174 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 08:47:00 AM | 3 | 3X3 | 5995225.08055 | 2087462.80286 | 37.7115017488702 | -122.458329272374 | (37.7115017488702, -122.458329272374) | 9 | 8 | 6 | 28861 | 24 | ||
173908 | 251743 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 Cordova St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001773 | 2087479 | 37.7119203272299 | -122.43569914015 | (37.7119203272299, -122.43569914015) | 9 | 7 | 6 | 28861 | 5 | |||||
121056 | 251749 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 601 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002875 | 2087693 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | 9 | 7 | 6 | 28861 | 5 | |||||
161307 | 176916 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001888.93185 | 2087835.89796 | 37.7129068748214 | -122.435323960636 | (37.7129068748214, -122.435323960636) | 9 | 7 | 6 | 28861 | 5 | |||
103230 | 49761 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 366@ REY Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46555 | 6008949.54261 | 2087928.88077 | 37.713560633393 | -122.41092664676 | (37.713560633393, -122.41092664676) | 9 | 7 | 8 | 309 | 39 | |
88773 | 216845 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.7141050056202 | -122.458764825742 | (37.7141050056202, -122.458764825742) | 9 | 8 | 6 | 28861 | 24 | ||
99461 | 216848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | 9 | 8 | 6 | 28861 | 24 | ||
52445 | 251444 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545 | 2088436 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | 9 | 8 | 6 | 28861 | 24 | ||
57710 | 181021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.69942 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | 9 | 7 | 6 | 28861 | 5 | ||
132066 | 207026 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994724.72263 | 2088692.24537 | 37.7148487422402 | -122.460147642199 | (37.7148487422402, -122.460147642199) | 9 | 8 | 6 | 28861 | 24 | |||
139943 | 115757 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.21291 | 37.7151093927473 | -122.448405831859 | (37.7151093927473, -122.448405831859) | 9 | 7 | 6 | 28861 | 25 | ||
25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
72790 | 40470 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
67542 | 95712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) | 9 | 7 | 6 | 28861 | 5 |
132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
82669 | 46431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.403656249429 | (37.7185939356546, -122.403656249429) | 10 | 7 | 8 | 309 | 28 | ||
61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
179045 | 19350 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781612 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | 9 | 8 | 6 | 64 | 24 | |
12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
189393 | 162332 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.7188648537082 | -122.45402201441 | (37.7188648537082, -122.45402201441) | 9 | 8 | 6 | 28861 | 24 | ||
141360 | 176880 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012013.01229 | 2090122.10429 | 37.7197540907522 | -122.400492099948 | (37.7197540907522, -122.400492099948) | 10 | 7 | 8 | 309 | 28 | |||
102650 | 120680 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717 | 2090174 | 37.7194304401491 | -122.42917217064 | (37.7194304401491, -122.42917217064) | 9 | 7 | 6 | 28861 | 5 | ||
30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
161792 | 216723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.98741 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | 9 | 8 | 6 | 28861 | 24 | ||
23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
41454 | 253116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
96295 | 253108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
156762 | 253110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
172760 | 253118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
173524 | 253112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
182173 | 253114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
143452 | 160073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.99934 | 2090399.7386 | 37.7198438772755 | -122.441749724582 | (37.7198438772755, -122.441749724582) | 9 | 7 | 6 | 28861 | 25 | ||
161401 | 37831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.35388 | 37.7200688687581 | -122.428658848427 | (37.7200688687581, -122.428658848427) | 9 | 7 | 6 | 28861 | 5 |
186495 | 57147 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 578 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.69811 | 37.7200286411902 | -122.4373616868 | (37.7200286411902, -122.4373616868) | 9 | 7 | 6 | 28861 | 5 |
194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
165323 | 160071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | 9 | 7 | 6 | 28861 | 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );