Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13879 | 13879 | 50774 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 1835 | 1835 | 251742 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
| 186108 | 186108 | 176878 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.709862662502104 | -122.396290845073 | (37.7098626625021, -122.396290845073) | |||
| 31319 | 31319 | 176877 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.709910397621705 | -122.396487432357 | (37.7099103976217, -122.396487432357) | |||
| 4432 | 4432 | 172375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574.0 | 2086750.0 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | ||
| 146826 | 146826 | 176876 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013031.567530001 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | |||
| 135940 | 135940 | 176875 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.710052832254796 | -122.39707427417801 | (37.7100528322548, -122.397074274178) | |||
| 52735 | 52735 | 176874 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | |||
| 13144 | 13144 | 108829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.7470099998 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | ||
| 80279 | 80279 | 108768 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103563 | 103563 | 108764 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103975 | 103975 | 108778 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 115794 | 115794 | 108772 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 127494 | 127494 | 108775 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 4276 | 4276 | 180842 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.45115578601299 | (37.710473721248, -122.451155786013) | ||
| 140964 | 140964 | 108825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
| 3992 | 3992 | 159336 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | ||
| 3982 | 3982 | 159338 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.44832801714199 | (37.7108995709325, -122.448328017142) | ||
| 4070 | 4070 | 159339 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.4578599995 | 2087195.02696 | 37.710932799068104 | -122.44828212563 | (37.7109327990681, -122.44828212563) | ||
| 64001 | 64001 | 69398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.4410400002 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | |
| 57165 | 57165 | 176885 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008580.05361 | 2087004.5673599998 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | |||
| 17806 | 17806 | 25338 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 297x Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2015 02:44:00 PM | 3 | 3X3 | 5994177.957230001 | 2087395.7640200001 | 37.7112574471386 | -122.46194351998699 | (37.7112574471386, -122.461943519987) | ||
| 11504 | 11504 | 25763 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.3858299998 | 37.711281031873 | -122.42734293164801 | (37.711281031873, -122.427342931648) | ||
| 4077 | 4077 | 159345 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | ||
| 4058 | 4058 | 159346 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.8062099998 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | ||
| 4091 | 4091 | 159347 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.711367382076396 | -122.44773365338999 | (37.7113673820764, -122.44773365339) | ||
| 4072 | 4072 | 159348 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.3667799998 | 37.711430378688796 | -122.447651252104 | (37.7114303786888, -122.447651252104) | ||
| 4258 | 4258 | 19062 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 174 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 08:47:00 AM | 3 | 3X3 | 5995225.08055 | 2087462.80286 | 37.7115017488702 | -122.458329272374 | (37.7115017488702, -122.458329272374) | ||
| 65576 | 65576 | 176919 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.71151328628479 | -122.436613103724 | (37.7115132862848, -122.436613103724) | |||
| 1848 | 1848 | 251743 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Cordova St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001773.0 | 2087479.0 | 37.7119203272299 | -122.43569914014999 | (37.7119203272299, -122.43569914015) | |||||
| 1836 | 1836 | 251749 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 601 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002875.0 | 2087693.0 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | |||||
| 179772 | 179772 | 176916 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001888.93185 | 2087835.8979599997 | 37.7129068748214 | -122.43532396063601 | (37.7129068748214, -122.435323960636) | |||
| 150268 | 150268 | 49761 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 366@ REY Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46555 | 6008949.54261 | 2087928.8807700002 | 37.713560633393 | -122.41092664676 | (37.713560633393, -122.41092664676) | |
| 157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
| 146422 | 146422 | 116546 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001545.434780001 | 2088113.86518 | 37.7136505979649 | -122.43653108014401 | (37.7136505979649, -122.436531080144) | |||
| 30642 | 30642 | 176917 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | ||||
| 64250 | 64250 | 116547 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | |||
| 59010 | 59010 | 116551 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.43660856033199 | (37.713721490625, -122.436608560332) | |||
| 158984 | 158984 | 116549 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001562.82912 | 2088145.2407900002 | 37.713737736870705 | -122.43647320339599 | (37.7137377368707, -122.436473203396) | |||
| 151872 | 151872 | 116550 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001534.78323 | 2088160.3445099997 | 37.7137776146169 | -122.43657122050399 | (37.7137776146169, -122.436571220504) | |||
| 51471 | 51471 | 116543 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001574.8493099995 | 2088164.89401 | 37.713792383287796 | -122.43643306305 | (37.7137923832878, -122.43643306305) | |||
| 156295 | 156295 | 116548 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001544.87474 | 2088178.1549900002 | 37.713827091712396 | -122.436537614614 | (37.7138270917124, -122.436537614614) | |||
| 23771 | 23771 | 116544 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.713842599620904 | -122.436395723209 | (37.7138425996209, -122.436395723209) | |||
| 44260 | 44260 | 116540 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001555.506159999 | 2088195.95431 | 37.713876568835396 | -122.43650214175399 | (37.7138765688354, -122.436502141754) | |||
| 24383 | 24383 | 116552 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | |||
| 158635 | 158635 | 116539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001567.487380001 | 2088213.7256900002 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | |||
| 171144 | 171144 | 176918 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6001604.803669999 | 2088215.9120200002 | 37.713934169489704 | -122.43633317895599 | (37.7139341694897, -122.436333178956) | ||||
| 11046 | 11046 | 116538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001578.1015800005 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | |||
| 4130 | 4130 | 216848 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | ||
| 4192 | 4192 | 216845 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.714105005620205 | -122.458764825742 | (37.7141050056202, -122.458764825742) | ||
| 4282 | 4282 | 251444 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545.0 | 2088436.0 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | ||
| 4257 | 4257 | 181010 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.9005900002 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | ||
| 4306 | 4306 | 181011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.315830001 | 2088326.0025400002 | 37.714208969932706 | -122.438012171843 | (37.7142089699327, -122.438012171843) | ||
| 4227 | 4227 | 181017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.43836906510201 | (37.7143700996689, -122.438369065102) | ||
| 4273 | 4273 | 181018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.0469099998 | 37.714394713229105 | -122.43841724088999 | (37.7143947132291, -122.43841724089) | ||
| 4245 | 4245 | 181019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.714429647391896 | -122.438501549606 | (37.7144296473919, -122.438501549606) | ||
| 4220 | 4220 | 181020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.9301099998 | 37.714476492181895 | -122.438602919392 | (37.7144764921819, -122.438602919392) | ||
| 4266 | 4266 | 181021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.6994199995 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | ||
| 47585 | 47585 | 176883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.63475 | 2088252.8219299999 | 37.7145675926038 | -122.40369417294501 | (37.7145675926038, -122.403694172945) | ||||
| 172938 | 172938 | 176884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.40364648639601 | (37.7145850034576, -122.403646486396) | ||||
| 159962 | 159962 | 207028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 227 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992956.15905 | 2088729.24095 | 37.7148484391912 | -122.46626317241001 | (37.7148484391912, -122.46626317241) | |||
| 39635 | 39635 | 207026 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994724.722630001 | 2088692.2453700001 | 37.71484874224021 | -122.460147642199 | (37.7148487422402, -122.460147642199) | |||
| 11819 | 11819 | 115757 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.2129099998 | 37.715109392747294 | -122.44840583185899 | (37.7151093927473, -122.448405831859) | ||
| 4113 | 4113 | 181027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.2481099998 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | ||
| 4096 | 4096 | 181028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.4676599998 | 37.715132307492794 | -122.44007027934201 | (37.7151323074928, -122.440070279342) | ||
| 137158 | 137158 | 207029 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.47055564102301 | (37.7160401362134, -122.470555641023) | |||
| 178180 | 178180 | 207030 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.716043271265704 | -122.470505441771 | (37.7160432712657, -122.470505441771) | |||
| 86290 | 86290 | 40470 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 55458 | 55458 | 207027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997356.5626300005 | 2089224.02458 | 37.716459913666704 | -122.451089274853 | (37.7164599136667, -122.451089274853) | |||
| 62998 | 62998 | 176882 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | |||
| 167979 | 167979 | 95712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) |
| 21386 | 21386 | 19350 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774109 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | |
| 36288 | 36288 | 31158 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 600 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2001 12:00:00 AM | 1 | Permit Number 34860 | 5993522.80361 | 2089878.90243 | 37.71803781197371 | -122.464388049089 | (37.7180378119737, -122.464388049089) | |
| 139293 | 139293 | 38921 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.718159804985795 | -122.460857119734 | (37.7181598049858, -122.460857119734) | ||
| 13068 | 13068 | 109689 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.7354700002 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) |
| 3971 | 3971 | 251681 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550.0 | 2089909.0 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | ||
| 41516 | 41516 | 46433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011103.47209 | 2089684.5822599998 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | |
| 44865 | 44865 | 46434 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | |
| 43685 | 43685 | 46431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.40365624942899 | (37.7185939356546, -122.403656249429) | ||
| 2122 | 2122 | 252898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 3974 | 3974 | 162331 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.5104099999 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | ||
| 3950 | 3950 | 162332 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.718864853708205 | -122.45402201441001 | (37.7188648537082, -122.45402201441) | ||
| 11936 | 11936 | 109688 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.933730001 | 2090069.7229400002 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) |
| 4142 | 4142 | 216723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.9874099998 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | ||
| 4270 | 4270 | 252889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:58:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 98279 | 98279 | 120680 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717.0 | 2090174.0 | 37.719430440149104 | -122.42917217063999 | (37.7194304401491, -122.42917217064) | ||
| 59233 | 59233 | 108371 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.719605888781295 | -122.43642558878 | (37.7196058887813, -122.43642558878) | ||
| 4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
| 24388 | 24388 | 63507 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.43653782327401 | (37.7196774559426, -122.436537823274) | ||
| 154067 | 154067 | 176880 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012013.01229 | 2090122.1042900002 | 37.719754090752204 | -122.40049209994801 | (37.7197540907522, -122.400492099948) | |||
| 3913 | 3913 | 253116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3918 | 3918 | 253108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3928 | 3928 | 253114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3937 | 3937 | 253112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3968 | 3968 | 253118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3973 | 3973 | 253110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3935 | 3935 | 160073 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.999340001 | 2090399.7386 | 37.7198438772755 | -122.44174972458201 | (37.7198438772755, -122.441749724582) | ||
| 98150 | 98150 | 43741 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 103046 | 103046 | 43742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) | |||
| 112382 | 112382 | 43739 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.45213982606899 | (37.7199634590291, -122.452139826069) |
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");