trees
262 rows where Fire Prevention Districts = 9 and qSpecies_id = 8 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
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 | |||
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 | ||
3696 | 262180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009676.04228 | 2087903.41357 | 37.713531417046 | -122.408413797613 | (37.713531417046, -122.408413797613) | 9 | 7 | 8 | 309 | 39 | ||
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 | |||
5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
7204 | 262178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 235 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009840.919 | 2087844.03033 | 37.713377594646 | -122.407839737463 | (37.713377594646, -122.407839737463) | 9 | 7 | 8 | 309 | 39 | ||
7695 | 262179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009723.14992 | 2087886.44693 | 37.713487468075 | -122.408249780165 | (37.713487468075, -122.408249780165) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||
10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||
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 | |||
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 | ||
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 | |||
26966 | 207618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993529.31712 | 2090633.69129 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | 9 | 8 | 6 | 64 | 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 | |
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 | ||
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 | ||
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 | |||
32065 | 216902 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 Bright St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.463442003639 | (37.7138937098892, -122.463442003639) | 9 | 8 | 6 | 64 | 24 | ||
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 | |
36740 | 207701 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993894.77182 | 2095194.29652 | 37.7326540264533 | -122.463487860092 | (37.7326540264533, -122.463487860092) | 9 | 8 | 4 | 59 | 40 | |||
36741 | 207621 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993736.2843 | 2088924.46634 | 37.7154294623887 | -122.463580914754 | (37.7154294623887, -122.463580914754) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | ||||
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 | |
53000 | 207700 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993887.14565 | 2095187.31864 | 37.7326344275184 | -122.463513719208 | (37.7326344275184, -122.463513719208) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||
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 | ||
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 | |
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 | |||
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 | |||
73572 | 207616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993229.18719 | 2089803.61986 | 37.7178141748665 | -122.46539747963 | (37.7178141748665, -122.46539747963) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
84796 | 207614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997036.49742 | 2089508.96246 | 37.7172239569865 | -122.452216120002 | (37.7172239569865, -122.452216120002) | 9 | 8 | 6 | 28861 | 24 | |||
85273 | 251682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 40 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:02:00 PM | 3 | 3x3 | 5996554 | 2090155 | 37.7189701727187 | -122.453930506054 | (37.7189701727187, -122.453930506054) | 9 | 8 | 6 | 28861 | 24 | ||
86459 | 50502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 744 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:37:00 PM | 3 | 3x3 | Permit Number 767517 | 6002255.61475 | 2089339.38797 | 37.7170559438579 | -122.434164000676 | (37.7170559438579, -122.434164000676) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
87911 | 251759 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001757 | 2086582 | 37.7094564535298 | -122.43569030601 | (37.7094564535298, -122.43569030601) | 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) );