trees
2,421 rows where qSpecies_id = 8 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65679 | 126541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007346.83481 | 2121683.49611 | 37.8061529931217 | -122.418858679793 | (37.8061529931217, -122.418858679793) | 5 | 1 | 1 | 28858 | 32 | |||
70288 | 126514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Casa Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001509.62012 | 2121629.43894 | 37.8056741643903 | -122.439055417799 | (37.8056741643903, -122.439055417799) | 13 | 9 | 1 | 57 | 17 | |||
109118 | 42845 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 704 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 1 | Permit Number 42776 | 6007326.6292 | 2121624.2795 | 37.8059892616711 | -122.418924402261 | (37.8059892616711, -122.418924402261) | 5 | 1 | 1 | 28858 | 32 | |
7031 | 126517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568 | (37.8051781307269, -122.44226256568) | 13 | 9 | 1 | 57 | 17 | |||
146753 | 68253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.92976 | 37.8051366728892 | -122.442254132748 | (37.8051366728892, -122.442254132748) | 13 | 9 | 1 | 57 | 17 | |
173377 | 126524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002732.93596 | 2121317.83643 | 37.8048881155466 | -122.434799663981 | (37.8048881155466, -122.434799663981) | 13 | 9 | 1 | 57 | 17 | |||
26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
24312 | 126513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.8041193022167 | -122.438461940777 | (37.8041193022167, -122.438461940777) | 13 | 9 | 1 | 57 | 17 | |||
112160 | 68237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | 13 | 9 | 1 | 57 | 17 | |
66763 | 33335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) | 13 | 9 | 1 | 28858 | 17 |
29099 | 33334 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788582 | (37.8033246198945, -122.42991788582) | 13 | 9 | 1 | 28858 | 17 |
187842 | 61998 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3337 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 10 | Permit Number 22065 | 6004092.37742 | 2120634.4827 | 37.8030888913932 | -122.430046392648 | (37.8030888913932, -122.430046392648) | 13 | 9 | 1 | 57 | 17 | |
97010 | 40609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 10 | Permit Number 41619 | 6005248.55961 | 2120627.08998 | 37.8031340049926 | -122.426044866398 | (37.8031340049926, -122.426044866398) | 13 | 9 | 1 | 28858 | 17 | ||
108749 | 61995 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3324 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52348 | 6004148.34958 | 2120589.64511 | 37.8029689488237 | -122.429849499548 | (37.8029689488237, -122.429849499548) | 13 | 9 | 1 | 57 | 17 | |
14856 | 126525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.8029309470697 | -122.430014078187 | (37.8029309470697, -122.430014078187) | 13 | 9 | 1 | 57 | 17 | |||
109252 | 65832 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2205 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 1 | Permit Number 28822 | 6000136.86621 | 2120563.93301 | 37.8026703676171 | -122.443729421089 | (37.8026703676171, -122.443729421089) | 13 | 9 | 1 | 57 | 17 | |
74042 | 61992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | 13 | 9 | 1 | 57 | 17 | ||
105687 | 61989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3245 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 9 | Permit Number 22056 | 6004135.50024 | 2120335.16174 | 37.802269475902 | -122.429875802037 | (37.802269475902, -122.429875802037) | 13 | 9 | 1 | 57 | 17 | |
152745 | 126523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1436 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004946.35763 | 2120239.41034 | 37.8020524524204 | -122.427063015844 | (37.8020524524204, -122.427063015844) | 13 | 9 | 1 | 57 | 17 | |||
32015 | 61986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3219 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 13 | Permit Number 22053 | 6004150.64271 | 2120237.53433 | 37.8020022738516 | -122.429816434187 | (37.8020022738516, -122.429816434187) | 13 | 9 | 1 | 57 | 17 | |
90366 | 55965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.14258 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | 5 | 9 | 1 | 28858 | 32 | |
87764 | 61985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3212 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22052 | 6004200.44828 | 2120220.07156 | 37.8019571458696 | -122.429642837148 | (37.8019571458696, -122.429642837148) | 13 | 9 | 1 | 57 | 17 | |
140852 | 126508 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2241 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000053.49785 | 2120204.95376 | 37.801679951426 | -122.443992108573 | (37.801679951426, -122.443992108573) | 13 | 9 | 1 | 57 | 17 | |||
147006 | 126509 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2259 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999989.15096 | 2120195.34054 | 37.801649885296 | -122.444214086407 | (37.801649885296, -122.444214086407) | 13 | 9 | 1 | 57 | 17 | |||
159289 | 68965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2271 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52893 | 5999938.80053 | 2120187.45751 | 37.8016253679701 | -122.444387754501 | (37.8016253679701, -122.444387754501) | 13 | 9 | 1 | 57 | 17 | |
112846 | 126505 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3434 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000801.45062 | 2120178.5293 | 37.8016500345732 | -122.441401958532 | (37.8016500345732, -122.441401958532) | 13 | 9 | 1 | 57 | 17 | |||
79356 | 66089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.97147 | 2120081.10266 | 37.8017685454413 | -122.417803248017 | (37.8017685454413, -122.417803248017) | 5 | 1 | 10 | 308 | 32 | |
142355 | 126518 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001004.11411 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | 13 | 9 | 1 | 57 | 17 | |||
74476 | 126519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000986.5183 | 2120044.44522 | 37.8012924164688 | -122.440751917771 | (37.8012924164688, -122.440751917771) | 13 | 9 | 1 | 57 | 17 | |||
187425 | 126520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000968.94208 | 2120040.14536 | 37.8012796092356 | -122.440812430464 | (37.8012796092356, -122.440812430464) | 13 | 9 | 1 | 57 | 17 | |||
76374 | 126521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000953.24503 | 2120036.11736 | 37.8012676554495 | -122.440866459913 | (37.8012676554495, -122.440866459913) | 13 | 9 | 1 | 57 | 17 | |||
86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
22636 | 126510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000996.04097 | 2120002.97644 | 37.8011790965073 | -122.440715988969 | (37.8011790965073, -122.440715988969) | 13 | 9 | 1 | 57 | 17 | |||
120076 | 126511 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000979.36028 | 2119998.96358 | 37.8011671283179 | -122.44077342326 | (37.8011671283179, -122.44077342326) | 13 | 9 | 1 | 57 | 17 | |||
187626 | 126512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000962.49695 | 2119994.9542 | 37.8011551592542 | -122.440831489795 | (37.8011551592542, -122.440831489795) | 13 | 9 | 1 | 57 | 17 | |||
5105 | 153628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780837 | 6004230.96494 | 2119993.8857 | 37.8013378259475 | -122.429521095049 | (37.8013378259475, -122.429521095049) | 13 | 9 | 1 | 57 | 17 | |
45388 | 84616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50830 | 6001046.02752 | 2119987.7015 | 37.8011400020673 | -122.440541917971 | (37.8011400020673, -122.440541917971) | 13 | 9 | 1 | 57 | 17 | |
48583 | 87865 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50830 | 6001049.07284 | 2119968.8143 | 37.8010883162347 | -122.440530024452 | (37.8010883162347, -122.440530024452) | 13 | 9 | 1 | 57 | 17 | |
193756 | 61982 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | 13 | 9 | 1 | 57 | 17 | ||
58226 | 126507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000262.11092 | 2119933.43499 | 37.8009463312723 | -122.443250701178 | (37.8009463312723, -122.443250701178) | 13 | 9 | 1 | 57 | 17 | |||
87158 | 126506 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000233.97348 | 2119929.48889 | 37.8009338918396 | -122.44334778477 | (37.8009338918396, -122.44334778477) | 13 | 9 | 1 | 57 | 17 | |||
177772 | 83360 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2322 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50843 | 6000204.02563621 | 2119927.77926672 | 37.8009274898516 | -122.443451293811 | (37.8009274898516, -122.443451293811) | 13 | 9 | 1 | 57 | 17 | ||
133050 | 78962 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000164.38759 | 2119919.60804 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | 13 | 9 | 1 | 57 | 17 | |||
175557 | 84618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2334 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000130.7318 | 2119914.64406 | 37.8008872440121 | -122.443703976566 | (37.8008872440121, -122.443703976566) | 13 | 9 | 1 | 57 | 17 | |
36343 | 87872 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2334 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000114.75256 | 2119911.95547 | 37.8008789504673 | -122.443759078037 | (37.8008789504673, -122.443759078037) | 13 | 9 | 1 | 57 | 17 | |
46236 | 87868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
81050 | 87866 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
171681 | 87867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
165274 | 61980 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.4296037598 | (37.8009411736685, -122.4296037598) | 13 | 9 | 1 | 57 | 17 | |
83955 | 126526 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3101 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004207.10509 | 2119826.7769 | 37.8008776374509 | -122.429591735885 | (37.8008776374509, -122.429591735885) | 13 | 9 | 1 | 57 | 17 | |||
93522 | 256142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
134359 | 172715 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
48194 | 172714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005831.81614 | 2119622.88276 | 37.8004096554382 | -122.42395503709 | (37.8004096554382, -122.42395503709) | 13 | 9 | 1 | 28858 | 32 | |
74465 | 126522 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002338.78522 | 2119619.00301 | 37.800201180891 | -122.436042024317 | (37.800201180891, -122.436042024317) | 13 | 9 | 1 | 57 | 17 | |||
70526 | 66093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.416894219588 | (37.8004974059005, -122.416894219588) | 5 | 1 | 1 | 308 | 32 | |
23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
112806 | 121021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.8000754484782 | -122.42658871161 | (37.8000754484782, -122.42658871161) | 13 | 9 | 1 | 57 | 17 | |||
35395 | 64964 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.10624 | 2119511.23081 | 37.8000586419391 | -122.426669414059 | (37.8000586419391, -122.426669414059) | 13 | 9 | 1 | 57 | 17 | |
148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
146857 | 126543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | 5 | 1 | 1 | 308 | 32 | |||
27975 | 126544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | 5 | 1 | 1 | 308 | 32 | |||
26406 | 33945 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.76429 | 37.7998015374823 | -122.427531938546 | (37.7998015374823, -122.427531938546) | 13 | 9 | 1 | 57 | 17 | |
8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
116323 | 126538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | 3 | 1 | 10 | 308 | 32 | |||
124459 | 126545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008151.87492 | 2119410.8388 | 37.7999581436157 | -122.415911658989 | (37.7999581436157, -122.415911658989) | 5 | 1 | 1 | 308 | 32 | |||
15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
34935 | 126546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008154.11673 | 2119394.05894 | 37.7999121963461 | -122.415902712567 | (37.7999121963461, -122.415902712567) | 5 | 1 | 1 | 308 | 32 | |||
96112 | 126554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | 3 | 1 | 10 | 308 | 23 | |||
173635 | 126547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.7998627156539 | -122.41589197733 | (37.7998627156539, -122.41589197733) | 5 | 1 | 1 | 308 | 32 | |||
130734 | 126548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | 5 | 1 | 1 | 308 | 32 | |||
54705 | 126555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | 3 | 1 | 10 | 308 | 23 | |||
15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
71572 | 126556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499876 | -122.402609980888 | (37.799883499876, -122.402609980888) | 3 | 1 | 10 | 308 | 23 | |||
36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
169709 | 126558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | 3 | 1 | 10 | 308 | 23 | |||
158435 | 126499 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1636 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005076.86043 | 2119214.79365 | 37.7992464965988 | -122.426538412535 | (37.7992464965988, -122.426538412535) | 13 | 9 | 1 | 57 | 17 | |||
41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
12399 | 55507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1986 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | 13 | 9 | 1 | 57 | 17 | |
115576 | 64968 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1674 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 1 | Permit Number 26003 | 6004952.75334 | 2119199.45471 | 37.7991973630238 | -122.426966773099 | (37.7991973630238, -122.426966773099) | 13 | 9 | 1 | 57 | 17 | |
77337 | 64966 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1690 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26001 | 6004915.29698 | 2119193.66495 | 37.79917934781 | -122.427095972412 | (37.79917934781, -122.427095972412) | 13 | 9 | 1 | 57 | 17 | |
63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
67463 | 55804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.7991487753414 | -122.42632699542 | (37.7991487753414, -122.42632699542) | 13 | 9 | 1 | 57 | 17 | ||
96778 | 64972 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1627 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | Permit Number 26007 | 6005156.95767536 | 2119176.82289308 | 37.7991467663209 | -122.426258543392 | (37.7991467663209, -122.426258543392) | 13 | 9 | 1 | 57 | 17 | ||
27761 | 126498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.7991247544637 | -122.426523212175 | (37.7991247544637, -122.426523212175) | 13 | 9 | 1 | 57 | 17 | |||
162028 | 64971 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | 10 | Permit Number 26006 | 6005064.1075 | 2119167.53641 | 37.7991160193549 | -122.426579175209 | (37.7991160193549, -122.426579175209) | 13 | 9 | 1 | 57 | 17 | |
9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
155105 | 64970 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 11 | Permit Number 26005 | 6005030.07255 | 2119163.06773 | 37.7991018253479 | -122.426696629358 | (37.7991018253479, -122.426696629358) | 13 | 9 | 1 | 57 | 17 | |
92943 | 126496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004921.92717 | 2119147.20146 | 37.7990521458892 | -122.42706971849 | (37.7990521458892, -122.42706971849) | 13 | 9 | 1 | 57 | 17 | |||
57493 | 64965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26000 | 6004890.47461 | 2119142.08334 | 37.7990363142334 | -122.42717819022 | (37.7990363142334, -122.42717819022) | 13 | 9 | 1 | 57 | 17 | |
194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 | |||
78300 | 126552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.402245448777 | (37.7993296056227, -122.402245448777) | 3 | 1 | 10 | 28860 | 6 | |||
68414 | 126491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002852.03397 | 2119100.62162 | 37.7988069853068 | -122.434228905666 | (37.7988069853068, -122.434228905666) | 13 | 9 | 1 | 57 | 17 | |||
143270 | 88403 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071 | 2119078 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | 3 | 1 | 10 | 308 | 32 | ||
45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
39577 | 126542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 789 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | 3 | 1 | 10 | 308 | 4 | |||
8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 |
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) );