trees
262 rows where Fire Prevention Districts = 9 and qSpecies_id = 8 sorted by TreeID
This data as json, CSV (advanced)
| rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39029 | 103456 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003658 | 2091068 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | 9 | 7 | 6 | 28861 | 5 | ||||
| 132969 | 108369 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) | 9 | 7 | 6 | 28861 | 5 |
| 122709 | 108553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 64302 | 108554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 106652 | 108684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.7153792289568 | -122.440813996186 | (37.7153792289568, -122.440813996186) | 9 | 7 | 6 | 28861 | 5 | |
| 116488 | 108888 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772760 | 5997727.10617 | 2094743.09717 | 37.7316352013333 | -122.450206090909 | (37.7316352013333, -122.450206090909) | 9 | 7 | 4 | 59 | 40 | |
| 72474 | 108891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.224 | 37.7307509423916 | -122.447388264722 | (37.7307509423916, -122.447388264722) | 9 | 7 | 4 | 59 | 40 | |
| 145092 | 110714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994812 | 2091798 | 37.7233814241751 | -122.460070840792 | (37.7233814241751, -122.460070840792) | 9 | 8 | 4 | 28861 | 24 | ||||
| 107804 | 112688 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720 | 2088919 | 37.71541351482 | -122.4636368036 | (37.71541351482, -122.4636368036) | 9 | 8 | 6 | 64 | 24 | ||
| 73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
| 19777 | 117430 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.22692 | 2091583.55482 | 37.7233270936563 | -122.427664426683 | (37.7233270936563, -122.427664426683) | 9 | 7 | 6 | 28861 | 5 | ||
| 142189 | 117442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | 9 | 7 | 6 | 28861 | 5 | ||
| 1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
| 9952 | 148016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002451.59987 | 2088819.6954 | 37.7156401042879 | -122.433449457832 | (37.7156401042879, -122.433449457832) | 9 | 7 | 6 | 28861 | 5 | |||
| 72729 | 15860 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.443454540602 | (37.7139670145471, -122.443454540602) | 9 | 7 | 6 | 28861 | 25 | |||
| 118850 | 159290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 476 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 12:01:00 PM | 3 | Width 0ft | 5998270.83113 | 2087378.17542 | 37.7114439359488 | -122.447796316346 | (37.7114439359488, -122.447796316346) | 9 | 7 | 6 | 28861 | 25 | ||
| 105735 | 159292 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 482 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:20:00 AM | 3 | Width 0ft | 5998250.20897 | 2087358.72103 | 37.7113893399111 | -122.447866191868 | (37.7113893399111, -122.447866191868) | 9 | 7 | 6 | 28861 | 25 | ||
| 179323 | 159293 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:16:00 AM | 3 | Width 0ft | 5998231.36405 | 2087340.7209 | 37.7113388384862 | -122.447930029355 | (37.7113388384862, -122.447930029355) | 9 | 7 | 6 | 28861 | 25 | ||
| 1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
| 96234 | 160559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 710 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:15:00 PM | 3 | Width 0ft | 6002373.47799 | 2089525.51104 | 37.7175736853632 | -122.433769899784 | (37.7175736853632, -122.433769899784) | 9 | 7 | 6 | 28861 | 5 | |
| 147523 | 160560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 718 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:51:00 PM | 3 | Width 0ft | 6002343.44923 | 2089479.71946 | 37.7174462478135 | -122.433870424183 | (37.7174462478135, -122.433870424183) | 9 | 7 | 6 | 28861 | 5 | |
| 50739 | 160561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 730 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:42:00 PM | 3 | Width 0ft | 6002306.04947 | 2089419.84324 | 37.7172797185636 | -122.43399542008 | (37.7172797185636, -122.43399542008) | 9 | 7 | 6 | 28861 | 5 | |
| 170286 | 160563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:34:00 PM | 3 | Width 0ft | Permit Number 47139 | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | 9 | 7 | 6 | 28861 | 5 |
| 95632 | 160567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 790 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:57:00 AM | 3 | Width 0ft | 6002104.08605 | 2089098.7371 | 37.716386568565 | -122.43467056359 | (37.716386568565, -122.43467056359) | 9 | 7 | 6 | 28861 | 5 | |
| 71094 | 160845 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 669 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 03:09:00 PM | 3 | Width 0ft | 6002769.79165 | 2089568.51347 | 37.7177142412877 | -122.432403094831 | (37.7177142412877, -122.432403094831) | 9 | 7 | 6 | 28861 | 5 | |
| 120302 | 160846 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.83021 | 37.7177707025263 | -122.432363340291 | (37.7177707025263, -122.432363340291) | 9 | 7 | 6 | 28861 | 5 | |
| 57686 | 160887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 687 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:35:00 AM | 3 | Width 0ft | 6002277.90968 | 2089801.25761 | 37.7183254007788 | -122.434119936579 | (37.7183254007788, -122.434119936579) | 9 | 7 | 6 | 28861 | 5 | |
| 130316 | 160888 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 679 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:26:00 AM | 3 | Width 0ft | 6002304.81633 | 2089843.73714 | 37.7184435671833 | -122.43402996662 | (37.7184435671833, -122.43402996662) | 9 | 7 | 6 | 28861 | 5 | |
| 62310 | 160917 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.55527 | 2090180.28989 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | 9 | 7 | 6 | 28861 | 5 | |
| 118930 | 160918 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:50:00 AM | 3 | Width 0ft | 6002126.85051 | 2090151.34839 | 37.7192780975889 | -122.43466710393 | (37.7192780975889, -122.43466710393) | 9 | 7 | 6 | 28861 | 5 | |
| 64665 | 160919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 656 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:14:00 AM | 3 | Width 0ft | 6002115.87134 | 2090131.53749 | 37.7192230779683 | -122.43470363886 | (37.7192230779683, -122.43470363886) | 9 | 7 | 6 | 28861 | 5 | |
| 190107 | 161124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781528 | 6003266.33968 | 2090358.66738 | 37.7199119739285 | -122.430743107307 | (37.7199119739285, -122.430743107307) | 9 | 7 | 6 | 28861 | 5 | |
| 6423 | 161312 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6002939.11369 | 2090932.78769 | 37.7214698362342 | -122.431915186563 | (37.7214698362342, -122.431915186563) | 9 | 7 | 6 | 28861 | 5 | ||
| 45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
| 14625 | 161993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 138 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5999425.42548 | 2087282.88829 | 37.7112482236968 | -122.443798910798 | (37.7112482236968, -122.443798910798) | 9 | 7 | 6 | 28861 | 5 | |||
| 2408 | 162789 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 237 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996026.23717 | 2090535.13208 | 37.71998365171 | -122.455782228671 | (37.71998365171, -122.455782228671) | 9 | 8 | 6 | 28861 | 24 | |||
| 139495 | 162893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:55:00 AM | 3 | Width 0ft | 5995900.91597 | 2090507.14729 | 37.7198996190417 | -122.456213396033 | (37.7198996190417, -122.456213396033) | 9 | 8 | 6 | 28861 | 24 | ||
| 31050 | 162895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444284 | (37.7197912084714, -122.45621444284) | 9 | 8 | 6 | 28861 | 24 | ||
| 154681 | 170290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.31058 | 37.7283429067858 | -122.44467875894 | (37.7283429067858, -122.44467875894) | 9 | 7 | 4 | 28861 | 40 | ||
| 12812 | 170654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000891.32853 | 2092534.3103 | 37.7257509509219 | -122.439108525449 | (37.7257509509219, -122.439108525449) | 9 | 7 | 6 | 28861 | 25 | ||
| 7733 | 170655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000850.12796 | 2092564.23012 | 37.7258307594577 | -122.439253095949 | (37.7258307594577, -122.439253095949) | 9 | 7 | 6 | 28861 | 25 | ||
| 10751 | 170656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000839.66357 | 2092572.31066 | 37.7258523512861 | -122.439289849442 | (37.7258523512861, -122.439289849442) | 9 | 7 | 6 | 28861 | 25 | ||
| 6424 | 170682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000690.30065 | 2092674.87518 | 37.7261254691045 | -122.439813535471 | (37.7261254691045, -122.439813535471) | 9 | 7 | 6 | 28861 | 25 | ||
| 12160 | 170683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2020 12:00:00 AM | 3 | Width 3ft | 6000666.46145 | 2092693.59381 | 37.7261755091709 | -122.439897287525 | (37.7261755091709, -122.439897287525) | 9 | 7 | 6 | 28861 | 25 | ||
| 2581 | 170684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2020 12:00:00 AM | 3 | Width 3ft | 6000643.43225 | 2092709.34496 | 37.7262174472681 | -122.439978026889 | (37.7262174472681, -122.439978026889) | 9 | 7 | 6 | 28861 | 25 | ||
| 8973 | 170735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1895 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6000284.32157 | 2093024.69966 | 37.7270628891409 | -122.441242066294 | (37.7270628891409, -122.441242066294) | 9 | 7 | 6 | 28861 | 25 | ||
| 10646 | 172228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 203 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002933 | 2092317 | 37.7252702278754 | -122.432035115452 | (37.7252702278754, -122.432035115452) | 9 | 7 | 6 | 28861 | 5 | |||
| 3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
| 29910 | 172261 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001860 | 2086600 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | 9 | 7 | 6 | 28861 | 5 | |||
| 3971 | 172343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001347.87441 | 2087361.61872 | 37.7115738673031 | -122.437160092082 | (37.7115738673031, -122.437160092082) | 9 | 7 | 6 | 28861 | 5 | |||
| 46447 | 175836 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994366.58552 | 2086543.72285 | 37.7089288002067 | -122.46122985489 | (37.7089288002067, -122.46122985489) | 9 | 8 | 6 | 28861 | 25 | |||
| 141152 | 176225 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001455.44817 | 2091671.04849 | 37.7234127127165 | -122.437096631405 | (37.7234127127165, -122.437096631405) | 9 | 7 | 6 | 28861 | 25 | |||
| 65530 | 176226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 915 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002121.3261 | 2088534.63061 | 37.7148386356627 | -122.434570661505 | (37.7148386356627, -122.434570661505) | 9 | 7 | 6 | 28861 | 5 | |||
| 192858 | 176227 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001457.22396 | 2089001.68524 | 37.7160833414588 | -122.436899487435 | (37.7160833414588, -122.436899487435) | 9 | 7 | 6 | 28861 | 5 | |||
| 161711 | 176228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001469.88954 | 2089023.11794 | 37.7161429107373 | -122.436857242679 | (37.7161429107373, -122.436857242679) | 9 | 7 | 6 | 28861 | 5 | |||
| 30925 | 176229 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001482.8368 | 2089045.33875 | 37.7162046599834 | -122.43681408062 | (37.7162046599834, -122.43681408062) | 9 | 7 | 6 | 28861 | 5 | |||
| 20672 | 176230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001498.44538 | 2089067.7688 | 37.7162671349894 | -122.436761734667 | (37.7162671349894, -122.436761734667) | 9 | 7 | 6 | 28861 | 5 | |||
| 186256 | 176231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001253.10056 | 2089784.48632 | 37.7182211342895 | -122.437661063033 | (37.7182211342895, -122.437661063033) | 9 | 7 | 6 | 28861 | 5 | |||
| 31475 | 176232 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | 9 | 7 | 6 | 28861 | 5 | |||
| 151454 | 176233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002171.16375 | 2090646.0569 | 37.7206389723959 | -122.43454928373 | (37.7206389723959, -122.43454928373) | 9 | 7 | 6 | 28861 | 5 | |||
| 14283 | 176234 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000330.77387 | 2088762.22962 | 37.7153617623173 | -122.44077585684 | (37.7153617623173, -122.44077585684) | 9 | 7 | 6 | 28861 | 5 | |||
| 176065 | 176235 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001042.78255 | 2087493.58621 | 37.7119188733302 | -122.438224016125 | (37.7119188733302, -122.438224016125) | 9 | 7 | 6 | 28861 | 5 | |||
| 78250 | 176236 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001058.00654 | 2087498.50838 | 37.711933254377 | -122.438171750223 | (37.711933254377, -122.438171750223) | 9 | 7 | 6 | 28861 | 5 | |||
| 13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
| 72397 | 176240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009052.31678 | 2090410.35877 | 37.7203800198047 | -122.41074656201 | (37.7203800198047, -122.41074656201) | 9 | 3 | 7 | 309 | 28 | |||
| 140001 | 176241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009064.84821 | 2090413.67882 | 37.7203898385876 | -122.410703479104 | (37.7203898385876, -122.410703479104) | 9 | 3 | 7 | 309 | 28 | |||
| 81467 | 176242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009078.67243 | 2090418.23511 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | 9 | 3 | 7 | 309 | 28 | |||
| 104392 | 176251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009692.49199 | 2089304.87658 | 37.717380467816 | -122.408455736945 | (37.717380467816, -122.408455736945) | 9 | 7 | 8 | 309 | 39 | |||
| 87347 | 176255 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 781 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001324.49693 | 2092468.54904 | 37.7255950237874 | -122.437606390539 | (37.7255950237874, -122.437606390539) | 9 | 7 | 6 | 28861 | 25 | |||
| 111171 | 176256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000782.55302 | 2093188.1019 | 37.7275399228115 | -122.439531400151 | (37.7275399228115, -122.439531400151) | 9 | 7 | 6 | 28861 | 25 | |||
| 138935 | 176257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000825.3698 | 2093157.80225 | 37.7274591636907 | -122.439381211582 | (37.7274591636907, -122.439381211582) | 9 | 7 | 6 | 28861 | 25 | |||
| 100541 | 176259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004478.9263 | 2093384.65246 | 37.7282892883003 | -122.426766995027 | (37.7282892883003, -122.426766995027) | 9 | 7 | 6 | 28861 | 5 | |||
| 143703 | 176260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 282 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004334.87033 | 2091639.7615 | 37.723490058001 | -122.427140768546 | (37.723490058001, -122.427140768546) | 9 | 7 | 6 | 28861 | 5 | |||
| 103840 | 176261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 188 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004431.12132 | 2092306.16061 | 37.7253252856153 | -122.426855482904 | (37.7253252856153, -122.426855482904) | 9 | 7 | 6 | 28861 | 5 | |||
| 149129 | 176262 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 56 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007768.4416 | 2093799.07984 | 37.7296126542007 | -122.415424294819 | (37.7296126542007, -122.415424294819) | 9 | 3 | 7 | 309 | 28 | |||
| 87986 | 176263 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 728 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009121.13665 | 2092884.06532 | 37.7271761560436 | -122.410683275834 | (37.7271761560436, -122.410683275834) | 9 | 3 | 7 | 309 | 28 | |||
| 9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
| 102958 | 176266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004692.43448 | 2091256.7125 | 37.7224585032472 | -122.425877480072 | (37.7224585032472, -122.425877480072) | 9 | 7 | 6 | 28861 | 5 | |||
| 127368 | 176267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000986.70381 | 2087103.40671 | 37.7108443372623 | -122.438389903289 | (37.7108443372623, -122.438389903289) | 9 | 7 | 6 | 28861 | 5 | |||
| 109185 | 176268 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6000987.65781 | 2087139.8501 | 37.7109444570035 | -122.43838921531 | (37.7109444570035, -122.43838921531) | 9 | 7 | 6 | 28861 | 5 | |||
| 78457 | 176269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Curtis St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6000993.66237 | 2087160.73145 | 37.7110021341048 | -122.438369957219 | (37.7110021341048, -122.438369957219) | 9 | 7 | 6 | 28861 | 5 | |||
| 84405 | 177791 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:44:00 AM | 3 | Width 8ft | 6001956.24423 | 2086810.19432 | 37.710094340458 | -122.435017995105 | (37.710094340458, -122.435017995105) | 9 | 7 | 6 | 28861 | 5 | ||
| 194416 | 179075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
| 107073 | 180622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 771 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:19:00 AM | 3 | Width 6ft | 6002476.28052 | 2087135.98969 | 37.7110184181363 | -122.433243913293 | (37.7110184181363, -122.433243913293) | 9 | 7 | 6 | 28861 | 5 | ||
| 44380 | 180623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.55582 | 37.7110759621502 | -122.433179952615 | (37.7110759621502, -122.433179952615) | 9 | 7 | 6 | 28861 | 5 | ||
| 76386 | 180625 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.7112570289525 | -122.432072557104 | (37.7112570289525, -122.432072557104) | 9 | 7 | 6 | 28861 | 5 | |||
| 168353 | 180626 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | 9 | 7 | 6 | 28861 | 5 | |||
| 69377 | 180634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:16:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 179288 | 180663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.7091162701556 | -122.433514058849 | (37.7091162701556, -122.433514058849) | 9 | 7 | 6 | 28861 | 5 | ||
| 141049 | 180766 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | 9 | 7 | 6 | 28861 | 5 | ||
| 499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
| 76601 | 181054 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.7116950572566 | -122.439510213951 | (37.7116950572566, -122.439510213951) | 9 | 7 | 6 | 28861 | 5 | ||
| 23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
| 5953 | 181063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:21:00 PM | 3 | Width 3ft | 5999687.90058 | 2086653.14824 | 37.7095340664096 | -122.44284654224 | (37.7095340664096, -122.44284654224) | 9 | 7 | 6 | 28861 | 5 | ||
| 179470 | 207589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Hearst Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998517.2369 | 2094367.8013 | 37.7306499124478 | -122.447447460328 | (37.7306499124478, -122.447447460328) | 9 | 7 | 4 | 28861 | 40 | |||
| 40764 | 207590 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5998520.92157 | 2094401.97974 | 37.7307439689499 | -122.447437181086 | (37.7307439689499, -122.447437181086) | 9 | 7 | 4 | 59 | 40 | |||
| 69865 | 207591 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 207 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999361.39835 | 2094045.00117 | 37.7298117829776 | -122.444505884965 | (37.7298117829776, -122.444505884965) | 9 | 7 | 4 | 28861 | 40 | |||
| 149870 | 207592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998420.65896 | 2094107.63792 | 37.7299300456356 | -122.447762621454 | (37.7299300456356, -122.447762621454) | 9 | 7 | 4 | 28861 | 40 | |||
| 46051 | 207593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998975.03938 | 2093802.03245 | 37.7291225947148 | -122.445824099527 | (37.7291225947148, -122.445824099527) | 9 | 7 | 4 | 28861 | 40 | |||
| 20570 | 207594 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 234 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995665.54592 | 2091502.05532 | 37.7226178864794 | -122.457098912592 | (37.7226178864794, -122.457098912592) | 9 | 8 | 4 | 28861 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );