trees
467 rows where Police Districts = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63011 | 102695 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000881 | 2096712 | 37.7372213335044 | -122.439443565515 | (37.7372213335044, -122.439443565515) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
91912 | 107688 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 6008820.4 | 2095497.5 | 37.7343352217744 | -122.411907523711 | (37.7343352217744, -122.411907523711) | 10 | 7 | 7 | 28859 | 2 | ||||
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 |
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
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 | |
45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
136341 | 113703 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
149177 | 121570 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119 | 2100471 | 37.7480641462346 | -122.40776839944 | (37.7480641462346, -122.40776839944) | 2 | 7 | 7 | 28859 | 2 | |
138468 | 12972 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001913.39953 | 2095585.02929 | 37.7341856330519 | -122.435793484091 | (37.7341856330519, -122.435793484091) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
131925 | 169674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781222 | 6002394.02072 | 2096615.67364 | 37.7370428349616 | -122.43420548191 | (37.7370428349616, -122.43420548191) | 2 | 7 | 5 | 63 | 7 |
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 | |||
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 | |||
131630 | 176237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2014 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012237.04254 | 2088170.85532 | 37.7144088442801 | -122.399580777334 | (37.7144088442801, -122.399580777334) | 10 | 7 | 8 | 309 | 39 | |||
172148 | 176238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2018 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012153.04029 | 2088061.68652 | 37.7141044057814 | -122.399863463036 | (37.7141044057814, -122.399863463036) | 10 | 7 | 8 | 309 | 39 | |||
116544 | 176243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.7204250353617 | -122.400893277618 | (37.7204250353617, -122.400893277618) | 10 | 7 | 8 | 309 | 28 | |||
43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
153244 | 176248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.7177579213627 | -122.400193408991 | (37.7177579213627, -122.400193408991) | 10 | 7 | 8 | 309 | 39 | ||
170210 | 176249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.7176940632127 | -122.400177264384 | (37.7176940632127, -122.400177264384) | 10 | 7 | 8 | 309 | 39 | ||
42579 | 176250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3562 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012131.39961 | 2089120.6063 | 37.7170107808051 | -122.400012580531 | (37.7170107808051, -122.400012580531) | 10 | 7 | 8 | 309 | 39 | |||
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 | |||
50780 | 176252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | 10 | 7 | 8 | 309 | 39 | |||
162560 | 176253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | 10 | 7 | 8 | 309 | 39 | |||
172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 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 | |||
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 | |||
129567 | 1769 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
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 |
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) );