trees
7,322 rows where qSpecies_id = 1 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42319 | 91098 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 535 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2009 12:00:00 AM | 3x3 | Permit Number 51988 | 6007027.8 | 2091471.2 | 37.7231791421759 | -122.417819832233 | (37.7231791421759, -122.417819832233) | 9 | 7 | 7 | 309 | 28 | ||
| 42354 | 38538 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1998 12:00:00 AM | Permit Number 40515 | 6015241.886192 | 2096337.56497418 | 37.7370000434098 | -122.389764834673 | (37.7370000434098, -122.389764834673) | 10 | 3 | 8 | 58 | 1 | |||
| 42505 | 33732 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 73 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37795 | 6003855.80093987 | 2108827.04659377 | 37.7706552465529 | -122.430022290128 | (37.7706552465529, -122.430022290128) | 7 | 9 | 11 | 29492 | 10 | |||
| 42526 | 88341 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 51 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823 | 2090807 | 37.7212310687473 | -122.425394157088 | (37.7212310687473, -122.425394157088) | 9 | 7 | 6 | 28861 | 5 | |||
| 42687 | 111231 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 398X VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991792 | 2097792 | 37.7396652854914 | -122.470946758559 | (37.7396652854914, -122.470946758559) | 1 | 8 | 4 | 59 | 40 | ||||
| 42804 | 81923 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2524X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50824 | 6006683.22400402 | 2119851.76004091 | 37.8010861247199 | -122.421025080133 | (37.8010861247199, -122.421025080133) | 5 | 9 | 1 | 28858 | 32 | ||
| 43052 | 42950 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 996 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42843 | 6007571.84518521 | 2103864.78808287 | 37.7572397945138 | -122.416816791906 | (37.7572397945138, -122.416816791906) | 2 | 4 | 7 | 28859 | 19 | |||
| 43280 | 252882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 726 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.7862263710027 | -122.491019750162 | (37.7862263710027, -122.491019750162) | 11 | 6 | 1 | 55 | 33 | ||||
| 43296 | 37177 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 82 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39750 | 6006243.85281213 | 2099611.0315252 | 37.7454851695113 | -122.421107482255 | (37.7454851695113, -122.421107482255) | 2 | 7 | 5 | 28859 | 2 | ||
| 44015 | 39896 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41178 | 5997800.90036334 | 2106153.01397284 | 37.7629682584611 | -122.450773341977 | (37.7629682584611, -122.450773341977) | 15 | 5 | 11 | 29492 | 9 | |||
| 44061 | 98652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801@Jones Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49829 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | |||
| 44215 | 34207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 615 Edinburg St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38025 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |||
| 44480 | 38262 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3049 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40365 | 6009221.80428817 | 2104486.03920004 | 37.7590382764454 | -122.411154451212 | (37.7590382764454, -122.411154451212) | 2 | 4 | 7 | 28859 | 19 | ||
| 44538 | 53076 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 371 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51458 | 6006420.16268351 | 2097021.21744278 | 37.7383840588887 | -122.420314048095 | (37.7383840588887, -122.420314048095) | 2 | 7 | 7 | 28859 | 2 | ||
| 44770 | 30652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Lafayette St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | Permit Number 34589 | 6007404.25014155 | 2109701.49866568 | 37.7732566094999 | -122.417810118831 | (37.7732566094999, -122.417810118831) | 8 | 2 | 9 | 28853 | 19 | |||
| 45088 | 36294 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | |||
| 45117 | 36201 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 45292 | 96248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
| 45817 | 37161 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
| 46108 | 38840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 321 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1998 12:00:00 AM | Permit Number 40669 | 6001805.99344402 | 2103972.25385855 | 37.7572088713247 | -122.436765010689 | (37.7572088713247, -122.436765010689) | 2 | 4 | 5 | 28862 | 3 | |||
| 46502 | 258330 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998216 | 2087138 | 37.7107813347674 | -122.447968545052 | (37.7107813347674, -122.447968545052) | 9 | 7 | 6 | 28861 | 25 | ||||
| 46605 | 93026 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3865 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2010 12:00:00 AM | 3x3 | Permit Number 53142 | 6002696 | 2102965 | 37.7544937337812 | -122.433615041679 | (37.7544937337812, -122.433615041679) | 2 | 4 | 5 | 28862 | 22 | ||
| 46636 | 94470 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997654.5 | 2094143 | 37.7299833218121 | -122.450413859523 | (37.7299833218121, -122.450413859523) | 9 | 7 | 4 | 28861 | 40 | ||||
| 46977 | 36208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 47912 | 254845 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000101 | 2112125 | 37.7794972235831 | -122.443247065594 | (37.7794972235831, -122.443247065594) | 15 | 5 | 1 | 29490 | 16 | ||||
| 47931 | 41412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42025 | 6002180.68587279 | 2119283.13380429 | 37.7992699891282 | -122.436565055121 | (37.7992699891282, -122.436565055121) | 13 | 9 | 1 | 57 | 17 | |||
| 48286 | 110226 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 48532 | 124724 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4225 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003484 | 2093871 | 37.7295683869713 | -122.430241179535 | (37.7295683869713, -122.430241179535) | 9 | 7 | 6 | 28861 | 5 | ||||
| 48950 | 49347 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2801X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2013 12:00:00 AM | Permit Number 769394 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | 13 | 6 | 1 | 29490 | 27 | |||
| 49092 | 111772 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1350 12TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992447 | 2106254 | 37.7629376108266 | -122.469297826347 | (37.7629376108266, -122.469297826347) | 1 | 8 | 11 | 56 | 12 | ||||
| 49576 | 34937 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 294 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1997 12:00:00 AM | Permit Number 38532 | 5997056.12539173 | 2112496.77058091 | 37.7803439119926 | -122.453807379312 | (37.7803439119926, -122.453807379312) | 11 | 6 | 2 | 54 | 16 | |||
| 49682 | 112303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
| 49770 | 92869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2009 12:00:00 AM | 3x3 | Permit Number 53086 | 6005474 | 2108327 | 37.7693737513235 | -122.424389339236 | (37.7693737513235, -122.424389339236) | 8 | 4 | 5 | 28853 | 19 | ||
| 49786 | 38256 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2525 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40363 | 6009112.31361331 | 2106827.53675456 | 37.7654613523347 | -122.41169856795 | (37.7654613523347, -122.41169856795) | 8 | 4 | 7 | 28859 | 19 | |||
| 50227 | 89042 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231 | 2115470 | 37.7891981742353 | -122.411898830301 | (37.7891981742353, -122.411898830301) | 5 | 1 | 10 | 28857 | 21 | |||
| 50333 | 73636 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701x 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1995 12:00:00 AM | 3x3 | 6001948 | 2099969 | 37.7462249605563 | -122.435987450823 | (37.7462249605563, -122.435987450823) | 2 | 7 | 5 | 63 | 22 | |||
| 50394 | 116204 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 50713 | 111202 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 50906 | 97793 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
| 51135 | 34550 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3661 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38259 | 6008500.27144352 | 2097840.49973377 | 37.7407506227309 | -122.413179939647 | (37.7407506227309, -122.413179939647) | 10 | 7 | 7 | 28859 | 2 | ||
| 51376 | 111203 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 51584 | 100335 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
| 51919 | 43398 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51138 | 6000329.57684873 | 2101296.06622138 | 37.7497766910669 | -122.441678964169 | (37.7497766910669, -122.441678964169) | 2 | 4 | 5 | 28862 | 22 | ||
| 52064 | 37159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
| 52170 | 117347 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1149 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 52291 | 38261 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3049 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40365 | 6009221.80428817 | 2104486.03920004 | 37.7590382764454 | -122.411154451212 | (37.7590382764454, -122.411154451212) | 2 | 4 | 7 | 28859 | 19 | ||
| 52729 | 37486 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1353 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39955 | 5990795.20359731 | 2106190.41144038 | 37.7626674234032 | -122.475006118896 | (37.7626674234032, -122.475006118896) | 1 | 8 | 3 | 56 | 12 | ||
| 52829 | 51759 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48027 | 6002355.39807577 | 2099140.67128625 | 37.7439736997976 | -122.434519504077 | (37.7439736997976, -122.434519504077) | 2 | 7 | 5 | 63 | 22 | |||
| 53038 | 86909 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4447 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 3x3 | Permit Number 50004 | 6001254 | 2105221 | 37.7606062377454 | -122.438763494294 | (37.7606062377454, -122.438763494294) | 2 | 4 | 5 | 28862 | 3 | ||
| 53132 | 88406 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1716 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055 | 2117126 | 37.7936228211286 | -122.419545076389 | (37.7936228211286, -122.419545076389) | 5 | 9 | 10 | 28858 | 32 | |||
| 53135 | 32162 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 53166 | 112854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2622 JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417 | 2105735 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | 1 | 8 | 3 | 56 | 35 | ||
| 53285 | 35859 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44931 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
| 53339 | 87985 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51024 | 5999495.7 | 2111498.4 | 37.7777422068729 | -122.445295983887 | (37.7777422068729, -122.445295983887) | 15 | 5 | 11 | 54 | 16 | ||
| 53350 | 38329 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | Permit Number 40383 | 6007137.73543764 | 2107714.01420189 | 37.7677844459894 | -122.418591067048 | (37.7677844459894, -122.418591067048) | 8 | 4 | 7 | 28853 | 19 | ||
| 53480 | 79186 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 264 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50973 | 6000535.29432741 | 2106716.16265048 | 37.7646706714185 | -122.441356449855 | (37.7646706714185, -122.441356449855) | 15 | 5 | 5 | 28862 | 3 | ||
| 53643 | 36897 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4053 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39550 | 6001673.15981371 | 2102898.88024815 | 37.7542540959721 | -122.437147550415 | (37.7542540959721, -122.437147550415) | 2 | 4 | 5 | 28862 | 22 | ||
| 53768 | 254802 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||||
| 53880 | 116202 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 53899 | 36400 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996171.38037302 | 2093732.38222171 | 37.7287708691135 | -122.455511487051 | (37.7287708691135, -122.455511487051) | 9 | 7 | 4 | 28861 | 40 | ||
| 54128 | 106175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.421653930851 | (37.7898405898041, -122.421653930851) | 13 | 9 | 10 | 28858 | 21 | ||||
| 54239 | 36231 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1485 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/2001 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | 10 | 3 | 8 | 58 | 1 | ||
| 54603 | 31586 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1894 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35121 | 5988494.35729684 | 2102435.66161223 | 37.7522242814151 | -122.482688661372 | (37.7522242814151, -122.482688661372) | 1 | 8 | 3 | 56 | 35 | ||
| 55319 | 65076 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53742 | 6014209.97274141 | 2111734.63120879 | 37.7792197815791 | -122.394410412216 | (37.7792197815791, -122.394410412216) | 6 | 2 | 9 | 28856 | 34 | |
| 55392 | 119621 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2298X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003320 | 2116507 | 37.7917121175407 | -122.432424247263 | (37.7917121175407, -122.432424247263) | 13 | 9 | 1 | 29490 | 27 | ||||
| 55405 | 47246 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1060 Key Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.396767210117 | (37.7194581178311, -122.396767210117) | 10 | 3 | 8 | 58 | 1 | ||
| 55589 | 107512 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1528X ALEMANY BLVD | 1 | Median : Cutout | Tree | DPW 1 | 6001955 | 2093277.9 | 37.727853146555 | -122.435484669091 | (37.727853146555, -122.435484669091) | 9 | 7 | 6 | 28861 | 25 | |||||
| 55699 | 38765 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | 9 | 7 | 4 | 28861 | 25 | ||||
| 55837 | 94871 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.388400481487 | (37.7393228299093, -122.388400481487) | 10 | 3 | 8 | 58 | 1 | ||
| 56445 | 101209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 56506 | 83990 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 549 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50485 | 6003149.67149919 | 2096039.38573025 | 37.7355033398719 | -122.431551729165 | (37.7355033398719, -122.431551729165) | 2 | 7 | 5 | 63 | 7 | ||
| 56962 | 95428 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1701 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767293 | 5989315.6 | 2103729.9 | 37.7558256605685 | -122.479943411619 | (37.7558256605685, -122.479943411619) | 1 | 8 | 3 | 56 | 35 | |
| 57171 | 87956 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3250 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50982 | 5999898.4 | 2119763 | 37.800457616115 | -122.44449703515 | (37.800457616115, -122.44449703515) | 13 | 9 | 1 | 57 | 17 | ||
| 57775 | 87098 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1158 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50054 | 6007039 | 2115043 | 37.7879025171415 | -122.419452592213 | (37.7879025171415, -122.419452592213) | 13 | 9 | 10 | 28858 | 21 | ||
| 58053 | 62858 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399x EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | 3x3 | Permit Number 23226 | 6008618 | 2097694 | 37.7403549752059 | -122.412762522808 | (37.7403549752059, -122.412762522808) | 10 | 7 | 7 | 28859 | 2 | |
| 58067 | 95593 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767292 | 5989311.3 | 2103832.7 | 37.7561076720523 | -122.479965804871 | (37.7561076720523, -122.479965804871) | 1 | 8 | 3 | 56 | 35 | |
| 58535 | 49033 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51460 | 6003769.51621429 | 2102291.73865454 | 37.7527059694214 | -122.429854522688 | (37.7527059694214, -122.429854522688) | 2 | 4 | 5 | 28862 | 22 | ||
| 58598 | 82275 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49900 | 6007963.19465099 | 2107409.01654638 | 37.7669934315585 | -122.415714295955 | (37.7669934315585, -122.415714295955) | 8 | 4 | 7 | 28853 | 19 | ||
| 58637 | 51277 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50924 | 6008254.72294648 | 2097673.72494943 | 37.7402789076073 | -122.414017161022 | (37.7402789076073, -122.414017161022) | 2 | 7 | 7 | 28859 | 2 | ||
| 58938 | 102792 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700X Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011271.9 | 2091582.1 | 37.7237215812631 | -122.403156521576 | (37.7237215812631, -122.403156521576) | 10 | 3 | 7 | 309 | 28 | |||
| 59023 | 87636 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5030 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991377.09346 | 2112789.45059 | 37.7808203036899 | -122.473474951717 | (37.7808203036899, -122.473474951717) | 11 | 6 | 2 | 54 | 26 | ||||
| 59055 | 32544 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Valencia St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | 8 | 2 | 9 | 28853 | 19 | |||
| 59351 | 32445 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4196 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36966 | 6001076.48069144 | 2105842.48573811 | 37.7623025844503 | -122.439422001985 | (37.7623025844503, -122.439422001985) | 15 | 5 | 5 | 28862 | 3 | ||
| 59549 | 103157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 283 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2013 12:00:00 AM | 3x3 | Permit Number 58700 | 5994183.3 | 2087984.2 | 37.7128734608265 | -122.461967697406 | (37.7128734608265, -122.461967697406) | 9 | 8 | 6 | 28861 | 24 | ||
| 59751 | 38884 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3300 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40704 | 5996965.46840287 | 2112983.07502769 | 37.7816739778787 | -122.45415613649 | (37.7816739778787, -122.45415613649) | 11 | 6 | 1 | 54 | 31 | ||
| 59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 60045 | 256037 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1555 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x3 | 6015125 | 2093955 | 37.7304515202688 | -122.390002579169 | (37.7304515202688, -122.390002579169) | 10 | 3 | 8 | 58 | 1 | |||
| 60207 | 113662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 115 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6012589.13870894 | 2106969.27475819 | 37.7660449583156 | -122.399682898168 | (37.7660449583156, -122.399682898168) | 14 | 3 | 8 | 28856 | 20 | |||
| 60214 | 35865 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1998 12:00:00 AM | Permit Number 39077 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
| 60269 | 16738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1550 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2013 12:00:00 AM | 3X3 | 6003776.6871065 | 2113549.9348865 | 37.7836186493065 | -122.430633011597 | (37.7836186493065, -122.430633011597) | 13 | 9 | 11 | 29490 | 41 | |||
| 60295 | 107695 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2440X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003685.72045 | 2116767.65354 | 37.7924485368973 | -122.43117747007 | (37.7924485368973, -122.43117747007) | 13 | 9 | 1 | 29490 | 27 | ||||
| 60487 | 101205 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 60939 | 55848 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2801X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2013 12:00:00 AM | Permit Number 769394 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | 13 | 6 | 1 | 29490 | 27 | |||
| 60951 | 36226 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1485 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | 10 | 3 | 8 | 58 | 1 | |||
| 61435 | 88710 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51653 | 6004475.4 | 2108255.2 | 37.769120165328 | -122.427838335035 | (37.769120165328, -122.427838335035) | 7 | 9 | 5 | 28862 | 3 | ||
| 61491 | 41352 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 450 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 42003 | 6005497.49834422 | 2106351.86830907 | 37.7639518374443 | -122.424167571577 | (37.7639518374443, -122.424167571577) | 8 | 4 | 5 | 28859 | 19 | |||
| 62028 | 34545 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3622 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38254 | 6008461.54328722 | 2098002.05559449 | 37.741192045331 | -122.413325269494 | (37.741192045331, -122.413325269494) | 2 | 7 | 7 | 28859 | 2 | ||
| 62085 | 88196 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 451 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51200 | 6011010 | 2112139 | 37.7801516798572 | -122.405508982546 | (37.7801516798572, -122.405508982546) | 14 | 2 | 9 | 28853 | 34 | |||
| 62256 | 107267 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 62272 | 68904 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4439 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50812 | 6001311.77329387 | 2104633.30085065 | 37.7589958457484 | -122.438521574218 | (37.7589958457484, -122.438521574218) | 2 | 4 | 5 | 28862 | 3 |
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) );