trees
3,709 rows where qSpecies_id = 9 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44527 | 55280 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1230 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11206 | 5988336.5387 | 2106915.6786 | 37.7645160123234 | -122.483562831314 | (37.7645160123234, -122.483562831314) | 1 | 8 | 3 | 56 | 35 | ||
| 44750 | 210585 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5991143.28102 | 2103974.04499 | 37.7566020354667 | -122.473640571055 | (37.7566020354667, -122.473640571055) | 1 | 8 | 4 | 56 | 12 | |||
| 45180 | 36110 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43523 | 5992873.88147935 | 2102526.51410864 | 37.7527275651303 | -122.467550320151 | (37.7527275651303, -122.467550320151) | 1 | 8 | 4 | 29491 | 12 | ||
| 46221 | 210753 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1307 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994224.89423 | 2106606.44565 | 37.764007912949 | -122.463174325841 | (37.764007912949, -122.463174325841) | 1 | 5 | 11 | 56 | 12 | |||
| 47610 | 115296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1715 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776029 | 5993685.8 | 2103804.5 | 37.7562834285867 | -122.464835383865 | (37.7562834285867, -122.464835383865) | 1 | 8 | 4 | 56 | 12 | |||
| 48402 | 185050 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2735 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983672.8883 | 2096524.5821 | 37.7357123843546 | -122.498925114194 | (37.7357123843546, -122.498925114194) | 1 | 8 | 3 | 29491 | 35 | |||
| 49162 | 48887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3616 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | 0 | Permit Number 46093 | 5981682.07511006 | 2099461.07988631 | 37.743658222157 | -122.506025661966 | (37.743658222157, -122.506025661966) | 1 | 8 | 3 | 29491 | 35 | ||
| 49353 | 183311 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1278 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983695.1836 | 2106447.4811 | 37.7629592306856 | -122.499581157409 | (37.7629592306856, -122.499581157409) | 1 | 8 | 3 | 56 | 35 | |||
| 49954 | 48839 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1239 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46837 | 5992309.70821316 | 2098410.34670203 | 37.7413930369511 | -122.469201754626 | (37.7413930369511, -122.469201754626) | 1 | 8 | 4 | 59 | 40 | ||
| 50561 | 210819 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1570 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994025.62968 | 2104835.89025 | 37.7591349472303 | -122.463735000965 | (37.7591349472303, -122.463735000965) | 1 | 5 | 4 | 56 | 12 | |||
| 50696 | 184702 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3719 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982717.3841 | 2104205.1171 | 37.7567449138844 | -122.502796975056 | (37.7567449138844, -122.502796975056) | 1 | 8 | 3 | 56 | 35 | |||
| 51161 | 182770 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989659.6776 | 2103177.4732 | 37.7543288282333 | -122.478713093614 | (37.7543288282333, -122.478713093614) | 1 | 8 | 3 | 56 | 35 | |||
| 51418 | 210594 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1598 10th Ave | 8 | : | Tree | Private 2 | 6 | Width 2ft | 5993107.5867 | 2104697.22808 | 37.758701273452 | -122.466899924805 | (37.758701273452, -122.466899924805) | 1 | 8 | 4 | 56 | 12 | |||
| 52558 | 255280 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
| 53360 | 210794 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991711.6896 | 2099423.53791 | 37.7441404266563 | -122.471343280781 | (37.7441404266563, -122.471343280781) | 1 | 8 | 4 | 29491 | 40 | |||
| 53471 | 46897 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1364 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44953 | 5992430.5821262 | 2106168.20504671 | 37.762701091794 | -122.469348364409 | (37.762701091794, -122.469348364409) | 1 | 8 | 11 | 56 | 12 | ||
| 53619 | 37128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1501 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 8 | 2x2 | Permit Number 39712 | 5981844.8018 | 2104832.4428 | 37.7584160519707 | -122.505861139063 | (37.7584160519707, -122.505861139063) | 1 | 8 | 3 | 56 | 35 | |
| 53852 | 187200 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2301 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984910.7598 | 2099021.3208 | 37.7426402887161 | -122.49482940194 | (37.7426402887161, -122.49482940194) | 1 | 8 | 3 | 29491 | 35 | |||
| 54432 | 55288 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11214 | 5988299.0097 | 2106694.3342 | 37.7639060767139 | -122.483676402691 | (37.7639060767139, -122.483676402691) | 1 | 8 | 3 | 56 | 35 | ||
| 54706 | 39795 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 54767 | 31298 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1718 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 8 | Permit Number 43850 | 5989075.352 | 2103610.9593 | 37.7554851201375 | -122.480765550046 | (37.7554851201375, -122.480765550046) | 1 | 8 | 3 | 56 | 35 | |
| 56001 | 177922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990625.84661 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | 1 | 8 | 4 | 64 | 14 | |||
| 56121 | 92389 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2210 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52794 | 5986107.9 | 2100167.2 | 37.7458565681974 | -122.490774390723 | (37.7458565681974, -122.490774390723) | 1 | 8 | 3 | 29491 | 35 |
| 56662 | 55281 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1235 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11207 | 5988295.1802 | 2106895.7653 | 37.7644589284875 | -122.483704417245 | (37.7644589284875, -122.483704417245) | 1 | 8 | 3 | 56 | 35 | ||
| 57481 | 184919 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 38 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983531.226 | 2102116.9441 | 37.7510591687413 | -122.499828114856 | (37.7510591687413, -122.499828114856) | 1 | 8 | 3 | 29491 | 35 | |||
| 58055 | 210621 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1358 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993664.65933 | 2106245.23095 | 37.7629838225623 | -122.465085760203 | (37.7629838225623, -122.465085760203) | 1 | 8 | 11 | 56 | 12 | |||
| 58135 | 183039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2561 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989842.8898 | 2097922.948 | 37.7399119148264 | -122.477695442626 | (37.7399119148264, -122.477695442626) | 1 | 8 | 3 | 29491 | 35 | |||
| 58808 | 177947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | 1 | 8 | 4 | 64 | 14 | ||||
| 59128 | 183448 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2949 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986774.6087 | 2098158.366 | 37.7403797702872 | -122.488321434667 | (37.7403797702872, -122.488321434667) | 1 | 8 | 3 | 29491 | 35 | |||
| 59564 | 177913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2924 21st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5990007.1003 | 2095790.68963 | 37.7340668092368 | -122.476971913545 | (37.7340668092368, -122.476971913545) | 1 | 8 | 4 | 64 | 35 | |||
| 60585 | 177955 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989333.41698 | 2089519.46327 | 37.7168085025868 | -122.478842503398 | (37.7168085025868, -122.478842503398) | 1 | 8 | 4 | 64 | 14 | ||||
| 60724 | 210821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 75 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994156.51155 | 2102044.29077 | 37.7514774727317 | -122.463079803498 | (37.7514774727317, -122.463079803498) | 1 | 8 | 4 | 29491 | 40 | |||
| 60885 | 210667 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 461 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993772.15723 | 2101783.21661 | 37.7507384818159 | -122.464389983509 | (37.7507384818159, -122.464389983509) | 1 | 8 | 4 | 29491 | 40 | |||
| 62025 | 183697 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1341 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983052.2798 | 2105821.6343 | 37.7612030896009 | -122.501758397661 | (37.7612030896009, -122.501758397661) | 1 | 8 | 3 | 56 | 35 | |||
| 62288 | 181686 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1359 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986151.7159 | 2105978.9882 | 37.7618167104083 | -122.491050498004 | (37.7618167104083, -122.491050498004) | 1 | 8 | 3 | 56 | 35 | |||
| 62337 | 92284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52732 | 5992529 | 2098634 | 37.7420198013099 | -122.468459794719 | (37.7420198013099, -122.468459794719) | 1 | 8 | 4 | 29491 | 40 | ||
| 62773 | 210627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1330 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5992419.82533 | 2106386.5718 | 37.7633000475855 | -122.469401463718 | (37.7633000475855, -122.469401463718) | 1 | 8 | 11 | 56 | 12 | |||
| 64390 | 210765 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1467 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994567.52834 | 2105555.58906 | 37.7611422655243 | -122.461913058167 | (37.7611422655243, -122.461913058167) | 1 | 5 | 11 | 56 | 12 | |||
| 64589 | 210616 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1383 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994242.30472 | 2106108.15261 | 37.7626407330016 | -122.463077951787 | (37.7626407330016, -122.463077951787) | 1 | 5 | 11 | 56 | 12 | |||
| 64636 | 108496 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773640 | 5992376.99621 | 2106387.92207 | 37.7633012798944 | -122.469549692534 | (37.7633012798944, -122.469549692534) | 1 | 8 | 11 | 56 | 12 |
| 64774 | 48615 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 201 Ulloa St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
| 65420 | 50089 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 Lenox Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | 1 | 8 | 4 | 59 | 40 | |||
| 65429 | 98843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5986532.0852 | 2103042.7532 | 37.7537768301776 | -122.489519049824 | (37.7537768301776, -122.489519049824) | 1 | 8 | 3 | 56 | 35 | |||
| 65510 | 181755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1243 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5988296.712 | 2106832.1958 | 37.7642844732055 | -122.483694458087 | (37.7642844732055, -122.483694458087) | 1 | 8 | 3 | 56 | 35 | |||
| 66870 | 177914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989849.36693 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | 1 | 8 | 4 | 64 | 14 | ||||
| 67622 | 32288 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1459 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36871 | 5991132.74207 | 2105501.46243 | 37.7607953088837 | -122.473788443003 | (37.7607953088837, -122.473788443003) | 1 | 8 | 4 | 56 | 12 | ||
| 68003 | 81559 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1341 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52756 | 5987079.0271 | 2106106.0855 | 37.7622198190489 | -122.487852677927 | (37.7622198190489, -122.487852677927) | 1 | 8 | 3 | 56 | 35 |
| 68391 | 210663 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2050 09th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993512.16458 | 2101452.63659 | 37.7498158034608 | -122.465265043663 | (37.7498158034608, -122.465265043663) | 1 | 8 | 4 | 29491 | 40 | |||
| 68431 | 210781 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1780 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5990634.50214 | 2103258.97933 | 37.7546091755868 | -122.475347888103 | (37.7546091755868, -122.475347888103) | 1 | 8 | 4 | 56 | 12 | |||
| 68861 | 251590 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 340x Vicente St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5991910 | 2097743 | 37.7395375677929 | -122.470535201056 | (37.7395375677929, -122.470535201056) | 1 | 8 | 4 | 59 | 40 | ||||
| 69546 | 210619 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1351 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994232.97707 | 2106350.80899 | 37.7633064669379 | -122.463127820109 | (37.7633064669379, -122.463127820109) | 1 | 5 | 11 | 56 | 12 | |||
| 70097 | 177918 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989709.79651 | 2089731.70675 | 37.7174131186015 | -122.477557062834 | (37.7174131186015, -122.477557062834) | 1 | 8 | 4 | 64 | 14 | ||||
| 70701 | 210766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1459 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5994570.95939 | 2105601.31284 | 37.7612680087194 | -122.461904507388 | (37.7612680087194, -122.461904507388) | 1 | 5 | 11 | 56 | 12 | |||
| 70718 | 182847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1790 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985366.9663 | 2103044.3154 | 37.7537130309901 | -122.493548353659 | (37.7537130309901, -122.493548353659) | 1 | 8 | 3 | 56 | 35 | |||
| 70835 | 37126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1503 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 2x2 | Permit Number 39712 | 5981845.4129 | 2104790.8867 | 37.7583019867208 | -122.505855944814 | (37.7583019867208, -122.505855944814) | 1 | 8 | 3 | 56 | 35 |
| 71682 | 95422 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1642 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767290 | 5989672.6005 | 2104167.8485 | 37.7570488852115 | -122.478740830177 | (37.7570488852115, -122.478740830177) | 1 | 8 | 3 | 56 | 35 |
| 71722 | 210620 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1325 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5994228.97975 | 2106484.44863 | 37.7636731762967 | -122.463151342753 | (37.7636731762967, -122.463151342753) | 1 | 5 | 11 | 56 | 12 | |||
| 71792 | 42857 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2587 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43444 | 5986747.1123 | 2097651.6781 | 37.7389869353159 | -122.488379277224 | (37.7389869353159, -122.488379277224) | 1 | 8 | 3 | 29491 | 35 | |
| 71924 | 210628 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992371.84345 | 2106377.00826 | 37.7632710156579 | -122.469566719548 | (37.7632710156579, -122.469566719548) | 1 | 8 | 11 | 56 | 12 | |||
| 72341 | 210751 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1382 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994290.50454 | 2106122.75399 | 37.7626836009878 | -122.462912306568 | (37.7626836009878, -122.462912306568) | 1 | 5 | 11 | 56 | 12 | |||
| 72550 | 177943 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989687.38089 | 2089641.08495 | 37.7171629928544 | -122.477627922194 | (37.7171629928544, -122.477627922194) | 1 | 8 | 4 | 64 | 14 | ||||
| 72661 | 11198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 186 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
| 73348 | 210648 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1327 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991901.50113 | 2098392.84804 | 37.7413213937668 | -122.470611905334 | (37.7413213937668, -122.470611905334) | 1 | 8 | 4 | 59 | 40 | |||
| 73548 | 96294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | ||
| 74660 | 210755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994519.49208 | 2106024.97078 | 37.762428300536 | -122.462113234642 | (37.762428300536, -122.462113234642) | 1 | 5 | 11 | 56 | 12 | |||
| 76444 | 46669 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1410 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44798 | 5991496.386577 | 2105807.77483853 | 37.7616574165081 | -122.47255310345 | (37.7616574165081, -122.47255310345) | 1 | 8 | 4 | 56 | 12 | ||
| 78232 | 92489 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2949 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52860 | 5986907 | 2098225 | 37.7405704530713 | -122.487868578446 | (37.7405704530713, -122.487868578446) | 1 | 8 | 3 | 29491 | 35 | |
| 79171 | 210764 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1499 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1987 12:00:00 AM | 15 | Width 3ft | Permit Number 24541 | 5994579.33292 | 2105376.64031 | 37.7606515981079 | -122.4618592553 | (37.7606515981079, -122.4618592553) | 1 | 5 | 11 | 56 | 12 | |
| 80058 | 183151 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2358 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984568.7624 | 2099123.297 | 37.7429002626214 | -122.496019433491 | (37.7429002626214, -122.496019433491) | 1 | 8 | 3 | 29491 | 35 | |||
| 80140 | 50088 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 Lenox Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | 1 | 8 | 4 | 59 | 40 | |||
| 80602 | 210829 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 21 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994366.30728 | 2101559.16657 | 37.7501575278628 | -122.462319128134 | (37.7501575278628, -122.462319128134) | 1 | 8 | 4 | 29491 | 40 | |||
| 80919 | 69183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1245 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 4 | Permit Number 33223 | 5986432.8487 | 2106764.3904 | 37.7639896284279 | -122.490135958203 | (37.7639896284279, -122.490135958203) | 1 | 8 | 3 | 56 | 35 | |
| 81122 | 184034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984925.6803 | 2103804.9468 | 37.7557756903402 | -122.495130483038 | (37.7557756903402, -122.495130483038) | 1 | 8 | 3 | 56 | 35 | |||
| 81537 | 78426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1954 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2011 12:00:00 AM | 1 | Permit Number 768091 | 5982612.2416 | 2101808.1342 | 37.7501572918213 | -122.502983144485 | (37.7501572918213, -122.502983144485) | 1 | 8 | 3 | 29491 | 35 | ||
| 81712 | 218409 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 205 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994259.4284 | 2100564.41639 | 37.7474200409988 | -122.462616569007 | (37.7474200409988, -122.462616569007) | 1 | 8 | 4 | 29491 | 40 | |||
| 83257 | 187242 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2401 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.0235 | 2098562.0875 | 37.7413814807711 | -122.494670165431 | (37.7413814807711, -122.494670165431) | 1 | 8 | 3 | 29491 | 35 | |||
| 83548 | 210796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992519.97697 | 2098572.7203 | 37.7418510216099 | -122.468486535743 | (37.7418510216099, -122.468486535743) | 1 | 8 | 4 | 29491 | 40 | |||
| 83607 | 37088 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1515 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | Permit Number 39688 | 5981846.9407 | 2104770.7198 | 37.7582467040795 | -122.505849166004 | (37.7582467040795, -122.505849166004) | 1 | 8 | 3 | 56 | 35 | |
| 84197 | 177919 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989736.06041 | 2089740.76738 | 37.7174395208859 | -122.477466943539 | (37.7174395208859, -122.477466943539) | 1 | 8 | 4 | 64 | 14 | ||||
| 84998 | 183312 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1278 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983694.638 | 2106469.3043 | 37.7630191190041 | -122.499584657362 | (37.7630191190041, -122.499584657362) | 1 | 8 | 3 | 56 | 35 | |||
| 85077 | 29233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902 41st Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 85552 | 210653 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992494.33571 | 2098391.50751 | 37.7413519761053 | -122.468562012235 | (37.7413519761053, -122.468562012235) | 1 | 8 | 4 | 59 | 40 | |||
| 87229 | 185755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985387.9173 | 2100269.6824 | 37.7460958716028 | -122.493271502729 | (37.7460958716028, -122.493271502729) | 1 | 8 | 3 | 29491 | 35 | |||
| 87980 | 177937 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.478271538203 | (37.7153620069155, -122.478271538203) | 1 | 8 | 4 | 64 | 14 | ||||
| 88135 | 39797 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 88411 | 177916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989586.18825 | 2089731.4345 | 37.7174051973785 | -122.477984294746 | (37.7174051973785, -122.477984294746) | 1 | 8 | 4 | 64 | 14 | ||||
| 89112 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1327 ULLOA ST | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | 1 | 8 | 4 | 59 | 40 | ||
| 89198 | 177951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989499.70601 | 2089731.63068 | 37.7174007160611 | -122.478283234789 | (37.7174007160611, -122.478283234789) | 1 | 8 | 4 | 64 | 14 | ||||
| 89503 | 210788 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2183 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991300.00585 | 2100601.54446 | 37.7473511052724 | -122.472852658828 | (37.7473511052724, -122.472852658828) | 1 | 8 | 4 | 29491 | 40 | |||
| 89670 | 92300 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2336 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52744 | 5989525.0145 | 2099451.0263 | 37.7440891677404 | -122.478906247553 | (37.7440891677404, -122.478906247553) | 1 | 8 | 3 | 29491 | 35 |
| 89925 | 185759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2520 Rivera St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985327.7352 | 2100265.3599 | 37.7460804829424 | -122.493479283219 | (37.7460804829424, -122.493479283219) | 1 | 8 | 3 | 29491 | 35 | |||
| 90297 | 81881 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1455 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | Permit Number 767798 | 5991454.38310922 | 2105516.3061244 | 37.7608546894327 | -122.472677122952 | (37.7608546894327, -122.472677122952) | 1 | 8 | 4 | 56 | 12 | ||
| 90378 | 53480 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1206 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1969 12:00:00 AM | 2 | Permit Number 6389 | 5983992.7975 | 2106909.1782 | 37.7642443784807 | -122.49858593622 | (37.7642443784807, -122.49858593622) | 1 | 8 | 3 | 56 | 35 | ||
| 90887 | 46898 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1364 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44953 | 5992430.5821262 | 2106168.20504671 | 37.762701091794 | -122.469348364409 | (37.762701091794, -122.469348364409) | 1 | 8 | 11 | 56 | 12 | ||
| 91170 | 210669 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 220 Ulloa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996141.13831 | 2099000.15799 | 37.743233164483 | -122.455996712494 | (37.743233164483, -122.455996712494) | 1 | 8 | 4 | 59 | 40 | |||
| 91529 | 218413 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 205 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994318.3495 | 2100641.87853 | 37.7476361256044 | -122.462418442952 | (37.7476361256044, -122.462418442952) | 1 | 8 | 4 | 29491 | 40 | |||
| 91884 | 177932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988789.67714 | 2089358.25698 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | 1 | 8 | 4 | 64 | 14 | ||||
| 91900 | 210652 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1245 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992223.01504 | 2098404.8144 | 37.7413728367905 | -122.469501104116 | (37.7413728367905, -122.469501104116) | 1 | 8 | 4 | 59 | 40 | |||
| 91966 | 210630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1495 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993028.5487 | 2105319.82116 | 37.7604061893258 | -122.467218540213 | (37.7604061893258, -122.467218540213) | 1 | 8 | 4 | 56 | 12 | |||
| 92388 | 177930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | 1 | 8 | 4 | 64 | 14 |
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) );