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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51358 | 51358 | 210658 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993547.0242 | 2093685.64408 | 37.728491596189606 | -122.464580592135 | (37.7284915961896, -122.464580592135) | |||
| 60391 | 60391 | 210659 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993556.39391 | 2093703.65355 | 37.7285415859236 | -122.46454950796301 | (37.7285415859236, -122.464549507963) | |||
| 101210 | 101210 | 42019 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.46463338232799 | (37.7283633513404, -122.464633382328) | |||
| 139131 | 139131 | 42022 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.46463338232799 | (37.7283633513404, -122.464633382328) | |||
| 143420 | 143420 | 42021 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.46463338232799 | (37.7283633513404, -122.464633382328) | |||
| 9279 | 9279 | 19768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 12551 | 12551 | 19769 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 12682 | 12682 | 19875 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 48342 | 48342 | 232992 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1001 Ashbury St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5999171.207330001 | 2106627.37895 | 37.764349091448395 | -122.446068061312 | (37.7643490914484, -122.446068061312) | |||
| 143867 | 143867 | 88725 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1003 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001771.0 | 2109412.0 | 37.772143091507296 | -122.43727552323799 | (37.7721430915073, -122.437275523238) | ||
| 83101 | 83101 | 88726 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
| 148575 | 148575 | 245892 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001712.4921 | 2109397.5688 | 37.7721001408501 | -122.437476872946 | (37.7721001408501, -122.437476872946) | |||
| 42884 | 42884 | 245891 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001696.2054 | 2109395.2421 | 37.7720928263506 | -122.437533043207 | (37.7720928263506, -122.437533043207) | |||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 59414 | 59414 | 83045 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | ||
| 79713 | 79713 | 3575 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 84280 | 84280 | 3576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 95791 | 95791 | 3567 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 103648 | 103648 | 3574 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 113278 | 113278 | 3568 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 138764 | 138764 | 3571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 173934 | 173934 | 83044 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018777.54715 | 2097643.31156 | 37.740780796002895 | -122.377630926146 | (37.7407807960029, -122.377630926146) | ||
| 183967 | 183967 | 115620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100x Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012248.320119999 | 2106930.54412 | 37.7659196081195 | -122.400859007135 | (37.7659196081195, -122.400859007135) | |||
| 115432 | 115432 | 210682 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100x Idora Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 5995339.29404 | 2099412.4410200003 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | |||
| 63047 | 63047 | 120379 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5987993.53196 | 2115242.52574 | 37.787359230974104 | -122.485360251255 | (37.7873592309741, -122.485360251255) | |||
| 149977 | 149977 | 120381 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5987991.90304 | 2115282.62041 | 37.7874692245738 | -122.485368830184 | (37.7874692245738, -122.485368830184) | |||
| 13656 | 13656 | 3557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.221530001 | 2097553.75967 | 37.740533839473294 | -122.377691534151 | (37.7405338394733, -122.377691534151) | ||
| 13816 | 13816 | 3563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.37733612657401 | (37.7403324731777, -122.377336126574) | ||
| 14102 | 14102 | 3562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.37739405370701 | (37.7403663524293, -122.377394053707) | ||
| 14314 | 14314 | 3560 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | ||
| 14754 | 14754 | 3564 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.740299071447794 | -122.377276992562 | (37.7402990714478, -122.377276992562) | ||
| 16143 | 16143 | 3559 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | ||
| 45233 | 45233 | 194145 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014334.84146 | 2106266.74633 | 37.764213127454205 | -122.393595642523 | (37.7642131274542, -122.393595642523) | ||||
| 48789 | 48789 | 194147 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014318.41099 | 2106520.5018700003 | 37.7649089715932 | -122.393670233204 | (37.7649089715932, -122.393670233204) | ||||
| 71773 | 71773 | 194149 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014236.41284 | 2106693.2411599997 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | ||||
| 153006 | 153006 | 194148 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014289.98871 | 2106632.9609 | 37.7652161800146 | -122.393776411647 | (37.7652161800146, -122.393776411647) | ||||
| 166955 | 166955 | 194146 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014326.39851 | 2106410.8143 | 37.7646082374101 | -122.393634928533 | (37.7646082374101, -122.393634928533) | ||||
| 170562 | 170562 | 178006 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004071.97549 | 2094334.96699 | 37.730875622499 | -122.42824154141199 | (37.730875622499, -122.428241541412) | |||
| 185000 | 185000 | 233610 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009156.0477 | 2103144.9026099998 | 37.7553521307214 | -122.411287128293 | (37.7553521307214, -122.411287128293) | |||
| 96949 | 96949 | 109968 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
| 140856 | 140856 | 109967 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
| 13811 | 13811 | 3566 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.740229404572396 | -122.377152086609 | (37.7402294045724, -122.377152086609) | ||
| 16144 | 16144 | 3565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.37721484129601 | (37.740264715549, -122.377214841296) | ||
| 116499 | 116499 | 3555 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | ||
| 96186 | 96186 | 103579 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 107493 | 107493 | 103577 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 114135 | 114135 | 103575 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 115818 | 115818 | 103576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 126244 | 126244 | 103578 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 153388 | 153388 | 232993 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1025 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999120.10377 | 2106539.64026 | 37.7641052645834 | -122.446238501702 | (37.7641052645834, -122.446238501702) | |||
| 139284 | 139284 | 56943 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1028 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1974 12:00:00 AM | 3x3 | Permit Number 14193 | 5999097.12659236 | 2106428.06249602 | 37.7637975877357 | -122.44630994567801 | (37.7637975877357, -122.446309945678) | ||
| 179363 | 179363 | 233177 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1028 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999101.075680001 | 2106447.88478 | 37.763852240304104 | -122.44629771307501 | (37.7638522403041, -122.446297713075) | |||
| 63305 | 63305 | 132021 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1028 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007930.0135699995 | 2119968.33776 | 37.801476420470294 | -122.41671890215099 | (37.8014764204703, -122.416718902151) | |||
| 130245 | 130245 | 132020 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1028 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007946.582219999 | 2119968.79133 | 37.8014785977268 | -122.416661599167 | (37.8014785977268, -122.416661599167) | |||
| 177851 | 177851 | 233206 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 103 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007392.9922400005 | 2097693.10233 | 37.7402836768503 | -122.416998061628 | (37.7402836768503, -122.416998061628) | |||
| 65907 | 65907 | 194214 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1030 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013004.48576 | 2089699.06872 | 37.7186477627738 | -122.397035257987 | (37.7186477627738, -122.397035257987) | |||
| 39268 | 39268 | 233028 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1031 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009195.32545 | 2103132.31552 | 37.755319772209795 | -122.411150404385 | (37.7553197722098, -122.411150404385) | |||
| 43672 | 43672 | 233178 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1032 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999091.07957 | 2106428.33595 | 37.763797993211206 | -122.446330880074 | (37.7637979932112, -122.446330880074) | |||
| 92692 | 92692 | 53963 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1034 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 3x3 | Permit Number 9678 | 5999077.6651474 | 2106402.81511165 | 37.7637271532356 | -122.446375440222 | (37.7637271532356, -122.446375440222) | ||
| 89486 | 89486 | 41526 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | |||
| 45549 | 45549 | 233066 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1037 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001345.83281 | 2100638.16269 | 37.7480280951206 | -122.438117593069 | (37.7480280951206, -122.438117593069) | |||
| 52063 | 52063 | 233064 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1037 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001346.73145 | 2100610.1660599997 | 37.7479512741444 | -122.43811248040501 | (37.7479512741444, -122.438112480405) | |||
| 62586 | 62586 | 233065 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1037 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001346.41468 | 2100623.4255 | 37.7479876633961 | -122.438114525463 | (37.7479876633961, -122.438114525463) | |||
| 76518 | 76518 | 233067 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1037 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001344.07448 | 2100653.2187 | 37.748069335340794 | -122.43812475165899 | (37.7480693353408, -122.438124751659) | |||
| 24611 | 24611 | 178026 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 104 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011109.90647 | 2093496.75882 | 37.728969789123795 | -122.40385117479299 | (37.7289697891238, -122.403851174793) | |||
| 70165 | 70165 | 178027 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 104 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011081.26767 | 2093487.71091 | 37.7289433454513 | -122.403949545331 | (37.7289433454513, -122.403949545331) | |||
| 42236 | 42236 | 232990 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998833.08221 | 2106296.55498 | 37.7634214173918 | -122.447213725654 | (37.7634214173918, -122.447213725654) | |||
| 89058 | 89058 | 56849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14083 | 5998828.52357861 | 2106301.56148098 | 37.7634349035124 | -122.447229852767 | (37.7634349035124, -122.447229852767) | |||
| 41013 | 41013 | 232923 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1044 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004380.50848 | 2102786.98314 | 37.754100376040505 | -122.427776885991 | (37.7541003760405, -122.427776885991) | |||
| 70032 | 70032 | 232922 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1044 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004379.7073 | 2102801.65271 | 37.7541406099171 | -122.427780701834 | (37.7541406099171, -122.427780701834) | |||
| 135450 | 135450 | 210653 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992494.33571 | 2098391.50751 | 37.7413519761053 | -122.468562012235 | (37.7413519761053, -122.468562012235) | |||
| 135260 | 135260 | 233203 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 105 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008326.365019999 | 2098049.92263 | 37.7413158872061 | -122.41379605425101 | (37.7413158872061, -122.413796054251) | |||
| 64726 | 64726 | 210675 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 105 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994239.22716 | 2095898.6318700002 | 37.7346077982181 | -122.46234806920201 | (37.7346077982181, -122.462348069202) | |||
| 170410 | 170410 | 210676 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 105 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994232.52898 | 2095915.2629200001 | 37.7346530772751 | -122.46237243275 | (37.7346530772751, -122.46237243275) | |||
| 1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 64667 | 64667 | 233027 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007577.65197 | 2103596.17277 | 37.7565025650535 | -122.41677768004 | (37.7565025650535, -122.41677768004) | |||
| 95232 | 95232 | 39179 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | 9 | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | ||
| 17218 | 17218 | 26701 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1055 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2002 12:00:00 AM | 3 | 3X3 | 6004445.56166 | 2102766.22763 | 37.754047066024704 | -122.427550437605 | (37.7540470660247, -122.427550437605) | ||
| 76364 | 76364 | 132014 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1059 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6008488.51458 | 2118614.01673 | 37.797789188388 | -122.414690333816 | (37.797789188388, -122.414690333816) | ||||
| 176040 | 176040 | 132015 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1059 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008494.23217 | 2118613.42416 | 37.797787882574 | -122.414670507348 | (37.797787882574, -122.414670507348) | ||||
| 99125 | 99125 | 1984 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.38062186171699 | (37.732867343787, -122.380621861717) | ||
| 76619 | 76619 | 138269 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 106 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997877.2646 | 2112995.6821 | 37.7817608358344 | -122.451002677666 | (37.7817608358344, -122.451002677666) | |||
| 61073 | 61073 | 248370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 107 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998216.6849 | 2108153.1367 | 37.768483881038705 | -122.449479417032 | (37.7684838810387, -122.449479417032) | |||
| 65170 | 65170 | 233004 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 107 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008863.5869 | 2098014.91089 | 37.7412499075619 | -122.411936049411 | (37.7412499075619, -122.411936049411) | |||
| 158884 | 158884 | 132013 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1070 Vallejo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008438.128819999 | 2118657.35642 | 37.7979053574127 | -122.41486775203998 | (37.7979053574127, -122.41486775204) | |||
| 48388 | 48388 | 233179 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1072 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998990.943659999 | 2106256.22808 | 37.7633197085617 | -122.446664834323 | (37.7633197085617, -122.446664834323) | |||
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 28798 | 28798 | 194222 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1080 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6012957.45228 | 2090084.12895 | 37.719702442702605 | -122.39722482158399 | (37.7197024427026, -122.397224821584) | |||
| 28973 | 28973 | 194221 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1080 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6012968.460940001 | 2090076.8184 | 37.719682982271706 | -122.397186255957 | (37.7196829822717, -122.397186255957) | |||
| 74968 | 74968 | 194223 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1080 Key Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6012938.89979 | 2090098.87174 | 37.71974189056571 | -122.39728998465701 | (37.7197418905657, -122.397289984657) | |||
| 45188 | 45188 | 233180 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1082 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998982.84174 | 2106232.35903 | 37.76325370732079 | -122.446691138603 | (37.7632537073208, -122.446691138603) | |||
| 181897 | 181897 | 233181 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.763185897523606 | -122.44671629981899 | (37.7631858975236, -122.446716299819) |
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");