trees
262 rows where Fire Prevention Districts = 9 and qSpecies_id = 8 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 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 | |||
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 | ||
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 | |||
2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
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 | |||
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 | |||
4187 | 78365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
10902 | 259838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1997 12:00:00 AM | 3 | Permit Number 38009 | 5996907.65838 | 2089596.01103 | 37.7174555905703 | -122.452667732297 | (37.7174555905703, -122.452667732297) | 9 | 8 | 6 | 28861 | 24 | ||
11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
11818 | 207596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994790.18426 | 2091971.80036 | 37.7238573834024 | -122.460158838768 | (37.7238573834024, -122.460158838768) | 9 | 8 | 4 | 28861 | 24 | |||
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 | ||
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 | ||
13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
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 | |||
14507 | 78352 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.434490001335 | (37.71927207124, -122.434490001335) | 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 | |||
16907 | 207595 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994790.50669 | 2091956.97642 | 37.7238166989736 | -122.460156650725 | (37.7238166989736, -122.460156650725) | 9 | 8 | 4 | 28861 | 24 | |||
19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
20515 | 216642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.47656 | 37.7191402755735 | -122.45402201442 | (37.7191402755735, -122.45402201442) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
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 | |||
20834 | 251731 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542 | 2087174 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | 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 | ||
23668 | 66231 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | 9 | 8 | 6 | 28861 | 24 | ||
24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
25043 | 253081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
26247 | 207604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996244.76197 | 2090857.98578 | 37.7208826706709 | -122.45505018502 | (37.7208826706709, -122.45505018502) | 9 | 8 | 6 | 28861 | 24 | |||
27050 | 44420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.7106843218039 | -122.433736745364 | (37.7106843218039, -122.433736745364) | 9 | 7 | 6 | 28861 | 5 | |
27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
29323 | 84791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 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 | |||
30263 | 253080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 24 | ||
30876 | 88307 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 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 | |||
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 | ||
31379 | 251733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 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 | |||
32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
33032 | 95765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767501 | 6004737 | 2091251 | 37.7224453364084 | -122.425723020763 | (37.7224453364084, -122.425723020763) | 9 | 7 | 6 | 28861 | 5 | |
36614 | 40677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.68968 | 2093800.00562 | 37.7294395787702 | -122.426195845473 | (37.7294395787702, -122.426195845473) | 9 | 7 | 6 | 28861 | 5 | |
38208 | 207601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||||
39141 | 66232 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | 12 | Permit Number 29329 | 5997099.27039938 | 2089468.87131755 | 37.7171174718407 | -122.451996253737 | (37.7171174718407, -122.451996253737) | 9 | 8 | 6 | 28861 | 24 | |
40210 | 84682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | 9 | 8 | 6 | 28861 | 24 | ||
42776 | 207608 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997723.56116 | 2090176.57785 | 37.7190964093462 | -122.449889363408 | (37.7190964093462, -122.449889363408) | 9 | 8 | 6 | 28861 | 24 | |||
43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
44074 | 254618 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781521 | 6003337.103 | 2094600.11874 | 37.73156206108 | -122.430801029135 | (37.73156206108, -122.430801029135) | 9 | 7 | 5 | 28861 | 25 |
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 | ||
44789 | 44020 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2000 12:00:00 AM | Permit Number 43561 | 6001434.84212338 | 2091667.66659412 | 37.7234022554793 | -122.437167620555 | (37.7234022554793, -122.437167620555) | 9 | 7 | 6 | 28861 | 25 | |||
45628 | 251771 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 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 | |
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 | |||
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 | |||
46531 | 251773 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
49669 | 39646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.5137176 | 2090402.3957614 | 37.7195128594848 | -122.462166418076 | (37.7195128594848, -122.462166418076) | 9 | 8 | 6 | 28861 | 24 | ||
50125 | 251683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:00:00 PM | 3 | 3x3 | 5996555 | 2090205 | 37.7191075183288 | -122.453930658436 | (37.7191075183288, -122.453930658436) | 9 | 8 | 6 | 28861 | 24 | ||
50524 | 207695 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.7244713658451 | -122.456366191771 | (37.7244713658451, -122.456366191771) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |
50744 | 65610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 655 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 10 | Permit Number 28515 | 6002150.88747 | 2090106.59961 | 37.7191565919832 | -122.434580819343 | (37.7191565919832, -122.434580819343) | 9 | 7 | 6 | 28861 | 5 | |
53756 | 251780 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001110 | 2087312 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | 9 | 7 | 6 | 28861 | 5 | ||||
56619 | 67275 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 282 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 8 | Permit Number 30749 | 6004343.26025 | 2091654.32947 | 37.7235305328868 | -122.427112803239 | (37.7235305328868, -122.427112803239) | 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 | |
61161 | 207599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994739.36013 | 2091570.55978 | 37.7227527497193 | -122.460305470535 | (37.7227527497193, -122.460305470535) | 9 | 8 | 4 | 28861 | 24 | |||
61468 | 95763 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 417 Moscow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004111.77372 | 2090686.36945 | 37.7208596345484 | -122.42784407255 | (37.7208596345484, -122.42784407255) | 9 | 7 | 6 | 28861 | 5 |
62175 | 207605 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994168.04761 | 2090360.81563 | 37.71939820295 | -122.462192668156 | (37.71939820295, -122.462192668156) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |
63012 | 207610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Majestic Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | 9 | 8 | 6 | 28861 | 24 | |||
63071 | 58747 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.7205713407191 | -122.457249650747 | (37.7205713407191, -122.457249650747) | 9 | 8 | 6 | 28861 | 24 | ||
63283 | 216859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 08:28:00 AM | 3 | Width 3ft | 5994500.65492 | 2087744.19701 | 37.7122327349221 | -122.460853440033 | (37.7122327349221, -122.460853440033) | 9 | 8 | 6 | 28861 | 24 | ||
63637 | 95714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 649 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767469 | 6004402.3 | 2092291.6 | 37.7252836757454 | -122.426954078943 | (37.7252836757454, -122.426954078943) | 9 | 7 | 6 | 28861 | 5 | |
64127 | 251732 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:20:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
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 | |
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 | |||
68070 | 30930 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.456902112142 | (37.7218954350219, -122.456902112142) | 9 | 8 | 4 | 28861 | 24 |
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 | ||
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 | |||
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 | |
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 | |||
74684 | 216641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 8 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:34:00 PM | 3 | Width 2ft | 5996523.62122 | 2089940.02354 | 37.7183781559031 | -122.454019995444 | (37.7183781559031, -122.454019995444) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
76476 | 46258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 22 Leo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44543 | 6001485.63381 | 2091410.0324 | 37.7226977372868 | -122.436973607764 | (37.7226977372868, -122.436973607764) | 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 |
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) );