trees
190 rows where Police Districts = 9 and qSpecies_id = 8 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
| 14335 | 126528 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999858.5831 | 2117397.02889 | 37.7939590162525 | -122.444464683403 | (37.7939590162525, -122.444464683403) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |
| 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 | |||
| 84723 | 126495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238 | (37.7951371326294, -122.44382203238) | 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 136408 | 126504 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2520 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000806.13814 | 2118970.30741 | 37.798332844742 | -122.441298996056 | (37.798332844742, -122.441298996056) | 13 | 9 | 1 | 57 | 17 | |||
| 133357 | 33126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.77318 | 2118925.97012 | 37.7982114272598 | -122.441276314246 | (37.7982114272598, -122.441276314246) | 13 | 9 | 1 | 57 | 17 | |
| 118575 | 126503 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2514 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000838.22718 | 2118974.91794 | 37.7983473319336 | -122.441188289519 | (37.7983473319336, -122.441188289519) | 13 | 9 | 1 | 57 | 17 | |||
| 162807 | 126502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000862.28412 | 2118975.43357 | 37.7983501180095 | -122.441105082435 | (37.7983501180095, -122.441105082435) | 13 | 9 | 1 | 57 | 17 | |||
| 180588 | 87454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2516 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50378 | 6000865 | 2118972 | 37.7983408450274 | -122.441095438221 | (37.7983408450274, -122.441095438221) | 13 | 9 | 1 | 57 | 17 | |||
| 51354 | 126501 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000880.46744 | 2118977.69433 | 37.7983573611488 | -122.441042325066 | (37.7983573611488, -122.441042325066) | 13 | 9 | 1 | 57 | 17 | |||
| 157873 | 126500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000899.88147 | 2118980.33539 | 37.7983657185536 | -122.440975336363 | (37.7983657185536, -122.440975336363) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 78668 | 50867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.7946117985032 | -122.440503146962 | (37.7946117985032, -122.440503146962) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 131226 | 54136 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | 13 | 9 | 1 | 57 | 27 | ||
| 101455 | 126529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002006.44363 | 2117342.94973 | 37.7939328468693 | -122.437029012298 | (37.7939328468693, -122.437029012298) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 76415 | 87186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864 | 2119027 | 37.7986055186493 | -122.434182233436 | (37.7986055186493, -122.434182233436) | 13 | 9 | 1 | 57 | 17 | |||
| 98178 | 47029 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.431845439306 | (37.7702201068925, -122.431845439306) | 15 | 9 | 5 | 29492 | 9 | |
| 116466 | 126494 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003442.2603 | 2118361.73826 | 37.7968116846621 | -122.432133738008 | (37.7968116846621, -122.432133738008) | 13 | 9 | 1 | 57 | 17 | |||
| 147719 | 126493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003443.96116 | 2118340.85925 | 37.796754452719 | -122.432126360859 | (37.796754452719, -122.432126360859) | 13 | 9 | 1 | 57 | 17 | |||
| 36215 | 126492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003445.69979 | 2118326.5799 | 37.7967153438803 | -122.432119324565 | (37.7967153438803, -122.432119324565) | 13 | 9 | 1 | 57 | 17 | |||
| 187177 | 244451 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003597.7695 | 2109704.6031 | 37.7730501849709 | -122.430977465184 | (37.7730501849709, -122.430977465184) | 15 | 9 | 11 | 29492 | 10 | |||
| 112987 | 244450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003616.0838 | 2109707.0129 | 37.7730578394028 | -122.430914285765 | (37.7730578394028, -122.430914285765) | 15 | 9 | 11 | 29492 | 10 | |||
| 183343 | 52128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | Permit Number 48312 | 6003680.41407753 | 2109722.31110522 | 37.7731034892906 | -122.430692851209 | (37.7731034892906, -122.430692851209) | 15 | 9 | 11 | 29492 | 10 | |||
| 187938 | 52127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48312 | 6003680.41407753 | 2109722.31110522 | 37.7731034892906 | -122.430692851209 | (37.7731034892906, -122.430692851209) | 15 | 9 | 11 | 29492 | 10 | ||
| 67585 | 224096 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 310 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003743.84038 | 2108689.19941 | 37.7702704103723 | -122.430399726373 | (37.7702704103723, -122.430399726373) | 15 | 9 | 11 | 29492 | 10 | |||
| 57827 | 34683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 2 | Permit Number 770151 | 6003781.4605 | 2118989.07405 | 37.7985534124753 | -122.43100482351 | (37.7985534124753, -122.43100482351) | 13 | 9 | 1 | 57 | 17 | ||
| 147189 | 61923 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51174 | 6003804.33633 | 2118991.05291 | 37.7985601420962 | -122.430925807306 | (37.7985601420962, -122.430925807306) | 13 | 9 | 1 | 57 | 17 | |
| 2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
| 187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
| 60161 | 33723 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 111285 | 33722 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 188422 | 224093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 353 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004017.83242 | 2109024.56898 | 37.7712067701103 | -122.429475909489 | (37.7712067701103, -122.429475909489) | 7 | 9 | 11 | 29492 | 10 | |||
| 93556 | 224095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004037.99786 | 2108888.07328 | 37.77083312788 | -122.429396421106 | (37.77083312788, -122.429396421106) | 7 | 9 | 11 | 29492 | 10 | |||
| 117720 | 224094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004048.7307 | 2108889.92984 | 37.7708388331853 | -122.42935942839 | (37.7708388331853, -122.42935942839) | 7 | 9 | 11 | 29492 | 10 | |||
| 192290 | 255522 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 513 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782014 | 6004052.85891 | 2110487.65333 | 37.7752260248335 | -122.429459106998 | (37.7752260248335, -122.429459106998) | 7 | 9 | 11 | 29492 | 10 |
| 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 | |
| 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 | |||
| 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 | ||
| 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 |
| 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 | |
| 157616 | 141987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004139.84 | 2111815.1387 | 37.7788758968254 | -122.429252898528 | (37.7788758968254, -122.429252898528) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 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 | ||
| 132271 | 141989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.7789487270827 | -122.42870472731 | (37.7789487270827, -122.42870472731) | 7 | 9 | 11 | 29490 | 41 | |||
| 32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 71932 | 88741 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
| 37947 | 224082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004326.71028 | 2109072.08218 | 37.7713547130825 | -122.428410875685 | (37.7713547130825, -122.428410875685) | 7 | 9 | 11 | 28852 | 10 | |||
| 115234 | 224083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004355.4783 | 2109071.91707 | 37.7713558875841 | -122.428311353983 | (37.7713558875841, -122.428311353983) | 7 | 9 | 11 | 28852 | 10 | |||
| 38299 | 66118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29177 | 6004443.55987266 | 2109134.3816324 | 37.771532383715 | -122.428011127655 | (37.771532383715, -122.428011127655) | 7 | 9 | 11 | 28852 | 10 | ||
| 151841 | 224092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004449.56008 | 2109136.25999 | 37.77153788069 | -122.427990506479 | (37.77153788069, -122.427990506479) | 7 | 9 | 11 | 28852 | 10 | |||
| 51136 | 224091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004510.25041 | 2109143.13465 | 37.7715601901838 | -122.427781065151 | (37.7715601901838, -122.427781065151) | 7 | 9 | 11 | 28852 | 10 | |||
| 118432 | 63598 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24232 | 6004516.72851683 | 2109144.57400335 | 37.7715645087532 | -122.427758759583 | (37.7715645087532, -122.427758759583) | 7 | 9 | 11 | 28852 | 10 | ||
| 103766 | 224084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004527.68926 | 2109092.69188 | 37.7714226730598 | -122.427717148539 | (37.7714226730598, -122.427717148539) | 7 | 9 | 11 | 28852 | 10 | |||
| 114388 | 224085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004536.35935 | 2109097.26869 | 37.7714357303029 | -122.427687484405 | (37.7714357303029, -122.427687484405) | 7 | 9 | 11 | 28852 | 10 | |||
| 75073 | 63599 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | 8x6 | Permit Number 24233 | 6004551.34106685 | 2109096.89343089 | 37.7714355473733 | -122.427635635138 | (37.7714355473733, -122.427635635138) | 7 | 9 | 11 | 28852 | 10 | |
| 98434 | 224090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.7715753671272 | -122.427616451463 | (37.7715753671272, -122.427616451463) | 7 | 9 | 11 | 28852 | 10 | |||
| 4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
| 73987 | 14750 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 940 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2000 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
| 134877 | 63600 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 232 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | Permit Number 24234 | 6004580.75107621 | 2109153.49232734 | 37.7715926177163 | -122.427537937355 | (37.7715926177163, -122.427537937355) | 7 | 9 | 11 | 28852 | 10 | ||
| 11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
| 75209 | 224088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004610.98363 | 2109155.17088 | 37.7715989365628 | -122.427433480775 | (37.7715989365628, -122.427433480775) | 7 | 9 | 11 | 28852 | 10 | |||
| 130525 | 224086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004621.17543 | 2109107.92251 | 37.7714697804289 | -122.427394860302 | (37.7714697804289, -122.427394860302) | 7 | 9 | 11 | 28852 | 10 | |||
| 156402 | 63611 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24248 | 6004626.48147455 | 2109159.86255859 | 37.7716126952933 | -122.427380207094 | (37.7716126952933, -122.427380207094) | 7 | 9 | 11 | 28852 | 10 | ||
| 87541 | 83184 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51667 | 6004633.65578728 | 2109108.35984762 | 37.7714716870977 | -122.427351721243 | (37.7714716870977, -122.427351721243) | 7 | 9 | 11 | 28852 | 10 |
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) );