Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88365 | 88365 | 47489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 101202 | 101202 | 47488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | ||
| 185975 | 185975 | 210672 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5996018.88182 | 2098492.62213 | 37.7418325783074 | -122.456382749179 | (37.7418325783074, -122.456382749179) | |||
| 24011 | 24011 | 247408 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 990 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001866.3003 | 2109465.7283 | 37.7722960331347 | -122.436949719287 | (37.7722960331347, -122.436949719287) | |||
| 72605 | 72605 | 247409 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 990 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001845.9485 | 2109464.3715 | 37.772291150933 | -122.43702002071998 | (37.772291150933, -122.43702002072) | |||
| 142201 | 142201 | 178007 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 99 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004047.84176 | 2094334.75752 | 37.7308736817673 | -122.42832496073 | (37.7308736817673, -122.42832496073) | |||
| 42417 | 42417 | 177969 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 99 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003395.375469999 | 2094530.4746700001 | 37.7313741355927 | -122.430594602255 | (37.7313741355927, -122.430594602255) | |||
| 109494 | 109494 | 108626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 99 LYELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003201.0 | 2094452.0 | 37.7311476483304 | -122.43126099455601 | (37.7311476483304, -122.431260994556) | ||||
| 76381 | 76381 | 177864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001714.742380001 | 2088380.4067900002 | 37.7143920818056 | -122.43596495333999 | (37.7143920818056, -122.43596495334) | |||
| 151492 | 151492 | 177866 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001726.64511 | 2088400.0268 | 37.714446630183794 | -122.43592521588002 | (37.7144466301838, -122.43592521588) | |||
| 156805 | 156805 | 177865 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001720.67634 | 2088389.3755700001 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | |||
| 98870 | 98870 | 51078 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 988 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | Permit Number 47539 | 6001840.60215529 | 2109468.12960392 | 37.7723011658658 | -122.437038783281 | (37.7723011658658, -122.437038783281) | |||
| 111358 | 111358 | 51077 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 988 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | Permit Number 47539 | 6001840.60215529 | 2109468.12960392 | 37.7723011658658 | -122.437038783281 | (37.7723011658658, -122.437038783281) | |||
| 3887 | 3887 | 233176 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 10 | Width 3ft | Permit Number 14045 | 5999260.53687 | 2106690.2118599997 | 37.7645267156554 | -122.445763615616 | (37.7645267156554, -122.445763615616) | |
| 44677 | 44677 | 232436 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 98 Laussat St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004291.459919999 | 2109275.43151 | 37.7719110660771 | -122.428547305538 | (37.7719110660771, -122.428547305538) | |||
| 46893 | 46893 | 247406 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 978 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001915.1447 | 2109474.5474 | 37.7723230242624 | -122.43678139381201 | (37.7723230242624, -122.436781393812) | |||
| 131330 | 131330 | 247407 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 978 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001900.8985 | 2109471.8338 | 37.772314763733505 | -122.43683047834499 | (37.7723147637335, -122.436830478345) | |||
| 75424 | 75424 | 232989 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 977 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998799.73328 | 2106531.1058799997 | 37.7640635297174 | -122.44734595116999 | (37.7640635297174, -122.44734595117) | |||
| 111448 | 111448 | 115523 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 977 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 5998789.42868854 | 2106581.63825895 | 37.7642016900986 | -122.447385228976 | (37.7642016900986, -122.447385228976) | ||||
| 123457 | 123457 | 232988 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 977 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998796.78708 | 2106549.89977 | 37.7641149646647 | -122.447357493961 | (37.7641149646647, -122.447357493961) | |||
| 139444 | 139444 | 56850 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 977 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 3x5 | Permit Number 14084 | 5998789.42868854 | 2106581.63825895 | 37.7642016900986 | -122.447385228976 | (37.7642016900986, -122.447385228976) | ||
| 176561 | 176561 | 31901 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 973 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35326 | 6007886.268540001 | 2110026.25074 | 37.7741754160005 | -122.416165751655 | (37.7741754160005, -122.416165751655) | |
| 52393 | 52393 | 233727 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 97 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000601.20003 | 2104887.54159 | 37.759653482834395 | -122.440997304107 | (37.7596534828344, -122.440997304107) | |||
| 126500 | 126500 | 108790 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 964 Avalon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.7788900002 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | |
| 176392 | 176392 | 178000 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 964 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6005277.15219 | 2092117.50935 | 37.7248550903643 | -122.423917422954 | (37.7248550903643, -122.423917422954) | |||
| 552 | 552 | 194122 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 569 | 569 | 194126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 572 | 572 | 194125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 573 | 573 | 194127 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 574 | 574 | 194128 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 575 | 575 | 194123 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 97171 | 97171 | 60705 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | |
| 165344 | 165344 | 233029 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009170.11197 | 2103561.96647 | 37.7564980828263 | -122.411267950278 | (37.7564980828263, -122.411267950278) | |||
| 119429 | 119429 | 1980 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 96 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 48999 | 48999 | 132016 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 955 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6008442.208 | 2118980.08343 | 37.798791714829896 | -122.414876489872 | (37.7987917148299, -122.414876489872) | ||||
| 154588 | 154588 | 132018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 955 Green St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6008453.78402 | 2118980.23859 | 37.798792791306 | -122.414836443949 | (37.798792791306, -122.414836443949) | ||||
| 155974 | 155974 | 132017 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 955 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6008451.79632 | 2118948.6521 | 37.7987059509698 | -122.41484108536501 | (37.7987059509698, -122.414841085365) | |||
| 95542 | 95542 | 44455 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 54487 | 54487 | 233765 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003185.97234 | 2107800.9752700003 | 37.7677999475382 | -122.432265943725 | (37.7677999475382, -122.432265943725) | |||
| 44267 | 44267 | 210677 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Ravenwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994252.28198 | 2095933.0938400002 | 37.7347031740156 | -122.462305433265 | (37.7347031740156, -122.462305433265) | |||
| 130543 | 130543 | 210678 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Ravenwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994279.56156 | 2095923.3993400002 | 37.7346781260787 | -122.462210416302 | (37.7346781260787, -122.462210416302) | |||
| 161928 | 161928 | 210679 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Ravenwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994311.07494 | 2095913.96689 | 37.7346540413551 | -122.46210078083 | (37.7346540413551, -122.46210078083) | |||
| 27113 | 27113 | 210804 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993437.69651 | 2093562.79994 | 37.728147993133895 | -122.46494962263701 | (37.7281479931339, -122.464949622637) | |||
| 49534 | 49534 | 210805 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993451.46095 | 2093589.86504 | 37.728223100899 | -122.464904003611 | (37.728223100899, -122.464904003611) | |||
| 96300 | 96300 | 42017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420553999 | (37.728283289236, -122.46489420554) | ||
| 102969 | 102969 | 42016 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420553999 | (37.728283289236, -122.46489420554) | ||
| 109020 | 109020 | 42018 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420553999 | (37.728283289236, -122.46489420554) | ||
| 76502 | 76502 | 246528 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | |||
| 173781 | 173781 | 246530 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.42531859367901 | (37.7713974254703, -122.425318593679) | |||
| 181773 | 181773 | 246529 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | |||
| 32223 | 32223 | 66427 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.7106099995 | 2090558.71757 | 37.721006862564295 | -122.397177686318 | (37.7210068625643, -122.397177686318) | ||
| 146926 | 146926 | 232991 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 949 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5999199.10241 | 2106826.4580200003 | 37.7648973055976 | -122.445985900135 | (37.7648973055976, -122.445985900135) | |||
| 184055 | 184055 | 177862 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 941 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000858.94149 | 2091517.8146099998 | 37.7229580424721 | -122.439147663029 | (37.7229580424721, -122.439147663029) | |||
| 185739 | 185739 | 177861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 941 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000851.1649 | 2091503.3604099997 | 37.722917912013294 | -122.43917350956801 | (37.7229179120133, -122.439173509568) | |||
| 175245 | 175245 | 51436 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 940 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 3 | Permit Number 47756 | 5999532.4011 | 2111754.0971 | 37.7784463804052 | -122.44518741065399 | (37.7784463804052, -122.445187410654) | ||
| 129235 | 129235 | 68419 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32262 | 5993499.28123568 | 2093584.8530568 | 37.728212096332996 | -122.46473832451099 | (37.728212096333, -122.464738324511) | ||
| 187228 | 187228 | 210657 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993485.31951 | 2093573.22652 | 37.7281793677659 | -122.46478574638999 | (37.7281793677659, -122.46478574639) | |||
| 83392 | 83392 | 34838 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | |||
| 93839 | 93839 | 34839 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | |||
| 159274 | 159274 | 12642 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 934 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3PL | 5992520.61532 | 2114855.72668 | 37.7865598847705 | -122.469669457241 | (37.7865598847705, -122.469669457241) | |||
| 185941 | 185941 | 12641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 934 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3PL | 5992552.1163800005 | 2114856.32512 | 37.786563348548604 | -122.469560515868 | (37.7865633485486, -122.469560515868) | |||
| 143332 | 143332 | 88075 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 931 Elizabeth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2008 12:00:00 AM | Permit Number 51070 | 6000446.0 | 2101962.0 | 37.7516118173154 | -122.441324145572 | (37.7516118173154, -122.441324145572) | ||||
| 25627 | 25627 | 132022 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 928 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007892.79628 | 2120308.15692 | 37.8024073851468 | -122.416871780604 | (37.8024073851468, -122.416871780604) | |||
| 150088 | 150088 | 132023 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 928 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007881.27524 | 2120306.58627 | 37.80240242449371 | -122.41691153784201 | (37.8024024244937, -122.416911537842) | |||
| 102004 | 102004 | 111035 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 927 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774368 | 5999163.7 | 2106974.1 | 37.765300671793604 | -122.446118968287 | (37.7653006717936, -122.446118968287) | ||||
| 52483 | 52483 | 50498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.7856400001 | 37.714154557357396 | -122.433096072852 | (37.7141545573574, -122.433096072852) | |
| 164265 | 164265 | 247239 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 923 Buena Vista Ave West | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6000025.84088 | 2108639.91315 | 37.7699237738831 | -122.443256690652 | (37.7699237738831, -122.443256690652) | |||
| 61726 | 61726 | 233669 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 921 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002504.70689 | 2102852.60591 | 37.7541742706305 | -122.43426854775299 | (37.7541742706305, -122.434268547753) | |||
| 174440 | 174440 | 69554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 920 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | Permit Number 40588 | 6000963.4177 | 2111955.7965 | 37.779081772988704 | -122.440251465706 | (37.7790817729887, -122.440251465706) | |
| 169521 | 169521 | 38506 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 918 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 5 | Permit Number 40497 | 6008538.5126 | 2119358.21788 | 37.799835388841295 | -122.4145700162 | (37.7998353888413, -122.4145700162) | |
| 149301 | 149301 | 233105 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 917 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000407.865569999 | 2102546.7223400003 | 37.7532151508723 | -122.441497973773 | (37.7532151508723, -122.441497973773) | |||
| 31072 | 31072 | 177863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 916 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6000908.69865 | 2091687.2057 | 37.723425983093 | -122.43898779685101 | (37.723425983093, -122.438987796851) | |||
| 124357 | 124357 | 106713 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 90X BURROWS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011052.0 | 2093468.0 | 37.7288875881876 | -122.404049339755 | (37.7288875881876, -122.404049339755) | |||
| 128127 | 128127 | 47307 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 905 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45238 | 6009420.31304698 | 2103898.06138647 | 37.757434952831396 | -122.410426393727 | (37.7574349528314, -122.410426393727) | ||
| 68041 | 68041 | 132012 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 902 Vallejo St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6009174.978759999 | 2118751.12637 | 37.7982042021283 | -122.412324664466 | (37.7982042021283, -122.412324664466) | |||
| 95421 | 95421 | 88122 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 901 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493.0 | 2102968.0 | 37.754490450787394 | -122.434317282412 | (37.7544904507874, -122.434317282412) | ||
| 105997 | 105997 | 88121 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 901 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493.0 | 2102968.0 | 37.754490450787394 | -122.434317282412 | (37.7544904507874, -122.434317282412) | ||
| 114757 | 114757 | 88120 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 901 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493.0 | 2102968.0 | 37.754490450787394 | -122.434317282412 | (37.7544904507874, -122.434317282412) | ||
| 164138 | 164138 | 194195 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.732391609687205 | -122.393238495663 | (37.7323916096872, -122.393238495663) | |||
| 73858 | 73858 | 177973 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004866.23981 | 2093407.5872099998 | 37.728374152822596 | -122.425429666248 | (37.7283741528226, -122.425429666248) | |||
| 130032 | 130032 | 233219 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007282.53208 | 2099823.35941 | 37.746126672903294 | -122.417530929716 | (37.7461266729033, -122.417530929716) | |||
| 163360 | 163360 | 233218 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Mirabel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007228.55769 | 2099799.12427 | 37.746057091476494 | -122.417715849229 | (37.7460570914765, -122.417715849229) | |||
| 29804 | 29804 | 194225 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6016755.26705 | 2095536.04747 | 37.734883042913395 | -122.384476538576 | (37.7348830429134, -122.384476538576) | |||
| 169950 | 169950 | 194228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016962.87933 | 2095412.7362900001 | 37.7345559334103 | -122.38375016066001 | (37.7345559334103, -122.38375016066) | |||
| 150462 | 150462 | 210768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 8x Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994536.81883 | 2106004.59746 | 37.7623733582716 | -122.46205183074 | (37.7623733582716, -122.46205183074) | |||
| 187501 | 187501 | 92258 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | |
| 62348 | 62348 | 233766 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 89 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003184.93105 | 2107820.05191 | 37.7678522682995 | -122.43227090799499 | (37.7678522682995, -122.432270907995) | |||
| 82107 | 82107 | 57242 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 89 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 24 | 5x5 | Permit Number 14530 | 6003195.89085899 | 2107782.79222796 | 37.7677505837132 | -122.43223033805201 | (37.7677505837132, -122.432230338052) | |
| 156994 | 156994 | 177968 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 89 Lyell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003146.74577 | 2094486.4155700002 | 37.731239070909 | -122.43145101676201 | (37.731239070909, -122.431451016762) | |||
| 165147 | 165147 | 177967 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 89 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003150.9738 | 2094473.33946 | 37.73120340649871 | -122.431435466595 | (37.7312034064987, -122.431435466595) | |||
| 173253 | 173253 | 233017 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 89 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007345.5921 | 2098843.81852 | 37.743440620989105 | -122.417243474931 | (37.7434406209891, -122.417243474931) | |||
| 48913 | 48913 | 233175 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 886 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999204.22068 | 2107162.24762 | 37.7658195918379 | -122.445992350981 | (37.7658195918379, -122.445992350981) | |||
| 160950 | 160950 | 194161 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 882 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012411.151869999 | 2103867.3361 | 37.7575177989154 | -122.40008065831499 | (37.7575177989154, -122.400080658315) | |||
| 129550 | 129550 | 233030 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 881 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009146.45262 | 2103976.05338 | 37.7576337449237 | -122.411379025546 | (37.7576337449237, -122.411379025546) | |||
| 160410 | 160410 | 178013 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 88 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6007561.5406 | 2093436.50677 | 37.728605475564606 | -122.41611390753201 | (37.7286054755646, -122.416113907532) | |||
| 157910 | 157910 | 210795 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 88 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992506.66983 | 2098544.3555400004 | 37.741772370506 | -122.468530483796 | (37.741772370506, -122.468530483796) | |||
| 30938 | 30938 | 232882 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 877 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6010202.299330001 | 2104146.86733 | 37.7581619248595 | -122.407739504273 | (37.7581619248595, -122.407739504273) | |||
| 82339 | 82339 | 97989 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897.0 | 2099683.0 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | ||
| 56442 | 56442 | 233173 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999192.10699 | 2107231.64658 | 37.7660094522115 | -122.446039241614 | (37.7660094522115, -122.446039241614) |
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");