trees
174 rows where qLegalStatus_id = 7 and qSpecies_id = 65 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130795 | 81299 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.7552007652727 | -122.419751988993 | (37.7552007652727, -122.419751988993) | 2 | 4 | 7 | 28859 | 19 | |
| 21373 | 109405 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.7530039316177 | -122.46482995514 | (37.7530039316177, -122.46482995514) | 1 | 8 | 4 | 56 | 12 | ||
| 48996 | 94666 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020 | 2095225 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | 9 | 7 | 5 | 28861 | 25 | |
| 165722 | 64259 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.424779179687 | (37.7430780980429, -122.424779179687) | 2 | 7 | 5 | 63 | 22 | ||
| 78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
| 55051 | 67285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.7263559262182 | -122.425894675863 | (37.7263559262182, -122.425894675863) | 9 | 7 | 6 | 28861 | 5 | ||
| 62808 | 67908 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.7283565792877 | -122.44478069728 | (37.7283565792877, -122.44478069728) | 9 | 7 | 4 | 28861 | 40 | ||
| 135735 | 97220 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132 | 2101212 | 37.749133146159 | -122.466562169914 | (37.749133146159, -122.466562169914) | 1 | 8 | 4 | 29491 | 12 | |||
| 178764 | 83799 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1200 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3x3 | Permit Number 53146 | 5982135.42302083 | 2106787.40938389 | 37.7638009337056 | -122.505000931873 | (37.7638009337056, -122.505000931873) | 1 | 8 | 3 | 56 | 35 | ||
| 188754 | 94833 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.465183709555 | (37.7657499301273, -122.465183709555) | 11 | 8 | 11 | 56 | 12 | |
| 37651 | 64302 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25113 | 6005123.1483335 | 2099287.66798911 | 37.7445340460317 | -122.42495970266 | (37.7445340460317, -122.42495970266) | 2 | 7 | 5 | 63 | 22 | ||
| 122464 | 94832 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.465220756233 | (37.7657245899289, -122.465220756233) | 11 | 8 | 11 | 56 | 12 | ||||
| 155801 | 55230 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/2015 12:00:00 AM | 3 | Permit Number 774077 | 5998221.35114249 | 2106191.93019124 | 37.7630991715617 | -122.449321957902 | (37.7630991715617, -122.449321957902) | 15 | 5 | 11 | 29492 | 9 | |
| 135999 | 109068 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1216 COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774077 | 5998287 | 2106143.6 | 37.762970223958 | -122.449091419823 | (37.762970223958, -122.449091419823) | 15 | 5 | 11 | 29492 | 9 | |
| 176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 63 | 40 | ||
| 95663 | 108501 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) | 11 | 8 | 11 | 56 | 12 |
| 22865 | 66317 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211357 | 37.732303560745 | -122.438056328119 | (37.732303560745, -122.438056328119) | 9 | 7 | 4 | 63 | 40 | ||
| 43220 | 32893 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774785 | 5993955.18913569 | 2106899.23772087 | 37.764796302786 | -122.464128405479 | (37.764796302786, -122.464128405479) | 11 | 5 | 11 | 56 | 12 | |
| 67978 | 67941 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.7346682618025 | -122.427968106929 | (37.7346682618025, -122.427968106929) | 2 | 7 | 5 | 28861 | 25 | ||
| 10364 | 64114 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.7645103445899 | -122.468400685881 | (37.7645103445899, -122.468400685881) | 11 | 8 | 11 | 56 | 12 | ||
| 85395 | 64103 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | 11 | 8 | 11 | 56 | 12 | ||
| 173139 | 98032 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 132 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995145 | 2113574 | 37.783191941507 | -122.460496884135 | (37.783191941507, -122.460496884135) | 11 | 6 | 2 | 54 | 11 | ||||
| 124223 | 108505 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.41391 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) | 1 | 8 | 11 | 56 | 12 |
| 95508 | 115201 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
| 135492 | 115202 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
| 133938 | 106164 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771080 | 5993998.9 | 2106208.9 | 37.7629033349313 | -122.463927108118 | (37.7629033349313, -122.463927108118) | 1 | 5 | 11 | 56 | 12 | |
| 141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
| 108472 | 109743 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.433953002704 | (37.7602597694278, -122.433953002704) | 2 | 4 | 5 | 28862 | 3 |
| 76736 | 94821 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | 1 | 8 | 4 | 56 | 12 | |
| 6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
| 103379 | 60473 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.7167021506206 | -122.451539811129 | (37.7167021506206, -122.451539811129) | 9 | 8 | 6 | 28861 | 24 | |||
| 192665 | 254027 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1486 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781497 | 5981881.09813 | 2104983.58381 | 37.7588331784594 | -122.505746816877 | (37.7588331784594, -122.505746816877) | 1 | 8 | 3 | 56 | 35 |
| 8616 | 47055 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | ||
| 91379 | 47054 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | |||
| 156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
| 3753 | 64301 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.6099578 | 2099277.06478887 | 37.7444941674798 | -122.425617791869 | (37.7444941674798, -122.425617791869) | 2 | 7 | 5 | 63 | 22 | ||
| 147875 | 254474 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1526 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781401 | 5994010.7409 | 2105109.99448 | 37.7598867084746 | -122.463806388501 | (37.7598867084746, -122.463806388501) | 1 | 5 | 4 | 56 | 12 |
| 52586 | 109284 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
| 126015 | 109285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
| 162088 | 109283 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
| 174480 | 109282 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
| 115535 | 94829 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.75996093558 | -122.462946257172 | (37.75996093558, -122.462946257172) | 1 | 5 | 4 | 56 | 12 | |
| 101694 | 94830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | 1 | 5 | 4 | 56 | 12 | |
| 124672 | 94831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.462936786411 | (37.759825119308, -122.462936786411) | 1 | 5 | 4 | 56 | 12 | |
| 126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
| 69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
| 87243 | 109278 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.7560264628403 | -122.508644093874 | (37.7560264628403, -122.508644093874) | 1 | 8 | 3 | 56 | 35 |
| 60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
| 68631 | 68056 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | 1 | 8 | 4 | 56 | 12 | ||
| 151523 | 55367 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 166 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1996 12:00:00 AM | Permit Number 11301 | 5993332.6421826 | 2094501.86251048 | 37.730720369862 | -122.465380982848 | (37.730720369862, -122.465380982848) | 9 | 8 | 4 | 59 | 40 | ||
| 128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
| 31725 | 35065 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1725 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38620 | 5993082.12771331 | 2103730.13138284 | 37.7560444079518 | -122.46691766691 | (37.7560444079518, -122.46691766691) | 1 | 8 | 4 | 56 | 12 | ||
| 72103 | 40424 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.455589722394 | (37.7310042675093, -122.455589722394) | 9 | 7 | 4 | 28861 | 40 | |
| 57192 | 258208 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1751 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783177 | 5982833.22444 | 2103206.19232 | 37.7540089544563 | -122.50232243849 | (37.7540089544563, -122.50232243849) | 1 | 8 | 3 | 56 | 35 | |
| 110639 | 83535 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1779 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50180 | 5981283.63190284 | 2102973.80068941 | 37.7532797037627 | -122.507663961783 | (37.7532797037627, -122.507663961783) | 1 | 8 | 3 | 56 | 35 | |||
| 80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
| 183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 | ||
| 187355 | 115291 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1811 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775894 | 5990908.2 | 2103066.5 | 37.7540965389008 | -122.474387332213 | (37.7540965389008, -122.474387332213) | 1 | 8 | 4 | 56 | 12 | |||
| 73034 | 94147 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.467590799812 | (37.7538665624087, -122.467590799812) | 1 | 8 | 4 | 56 | 12 | ||
| 98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
| 176854 | 67934 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 31647 | 6003947.82619719 | 2095984.77824106 | 37.7353986067624 | -122.428788314932 | (37.7353986067624, -122.428788314932) | 2 | 7 | 5 | 63 | 7 | ||
| 20115 | 97549 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
| 23012 | 97550 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
| 145681 | 97551 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||||
| 98528 | 87814 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 110235 | 87815 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 186665 | 87813 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | ||
| 93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
| 89653 | 66234 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.458274198204 | (37.7221254446058, -122.458274198204) | 9 | 8 | 4 | 28861 | 24 | ||
| 134976 | 255531 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2130 15th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782019 | 6003380.68215 | 2107148.89983 | 37.7660205449408 | -122.431545908158 | (37.7660205449408, -122.431545908158) | 15 | 5 | 5 | 28862 | 3 | |
| 178793 | 64789 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 214 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25785 | 6002808.76039687 | 2109284.75060862 | 37.7718526350484 | -122.433676731328 | (37.7718526350484, -122.433676731328) | 15 | 5 | 11 | 29492 | 9 | ||
| 171966 | 64298 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 217 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25107 | 6005164.15015163 | 2098998.20846843 | 37.7437415721643 | -122.424797337889 | (37.7437415721643, -122.424797337889) | 2 | 7 | 5 | 63 | 22 | ||
| 105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
| 86106 | 66313 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.435659572604 | (37.7324561325978, -122.435659572604) | 9 | 7 | 5 | 63 | 40 | ||
| 21507 | 62444 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25105 | 6005138.76094737 | 2098996.79373606 | 37.7437362535856 | -122.424885027142 | (37.7437362535856, -122.424885027142) | 2 | 7 | 5 | 63 | 22 | ||
| 61402 | 64790 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25786 | 6002754.53875379 | 2109297.20875 | 37.7718837652657 | -122.433865178188 | (37.7718837652657, -122.433865178188) | 15 | 5 | 11 | 29492 | 9 | ||
| 56352 | 238396 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2221 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782349 | 6002719.76824 | 2107072.27368 | 37.7657726661007 | -122.433826396093 | (37.7657726661007, -122.433826396093) | 15 | 5 | 5 | 28862 | 3 | |
| 85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
| 158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
| 95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
| 157166 | 106344 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
| 185739 | 106345 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
| 150990 | 64607 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1988 12:00:00 AM | 20 | Permit Number 25510 | 6008240.6573587 | 2104159.54552526 | 37.7580867271242 | -122.414524628823 | (37.7580867271242, -122.414524628823) | 2 | 4 | 7 | 28859 | 19 | |
| 133428 | 94661 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53798 | 6004650 | 2096961 | 37.7381188082759 | -122.426430123703 | (37.7381188082759, -122.426430123703) | 2 | 7 | 5 | 63 | 7 | |
| 35130 | 63135 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23650 | 6007455.65629161 | 2099393.17627053 | 37.7449552262088 | -122.416901813576 | (37.7449552262088, -122.416901813576) | 2 | 7 | 7 | 28859 | 2 | ||
| 87726 | 97554 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
| 107628 | 97552 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
| 139304 | 97553 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
| 152810 | 94662 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53799 | 6004605 | 2096922 | 37.7380091791898 | -122.426582934947 | (37.7380091791898, -122.426582934947) | 2 | 7 | 5 | 63 | 7 | |
| 142834 | 33539 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 253 BOCANA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | 4x4 | Permit Number 775951 | 6007035 | 2097463 | 37.7396317225537 | -122.418219548801 | (37.7396317225537, -122.418219548801) | 2 | 7 | 7 | 28859 | 2 | ||
| 63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
| 110025 | 255477 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2669 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780207 | 6000139.26098 | 2118831.12681 | 37.7979126806609 | -122.443596582177 | (37.7979126806609, -122.443596582177) | 13 | 9 | 1 | 57 | 17 | |
| 60112 | 66322 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) | 9 | 7 | 5 | 63 | 40 | ||
| 23336 | 63134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23649 | 6007447.90223159 | 2099378.78534919 | 37.7449152757931 | -122.416927606356 | (37.7449152757931, -122.416927606356) | 2 | 7 | 7 | 28859 | 2 | ||
| 31052 | 109288 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773379 | 6002625.7 | 2104315.8 | 37.7581987182413 | -122.433954706682 | (37.7581987182413, -122.433954706682) | 2 | 4 | 5 | 28862 | 3 |
| 135471 | 66323 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29440 | 6000269.21852417 | 2094980.11816522 | 37.7324311551198 | -122.441434530926 | (37.7324311551198, -122.441434530926) | 9 | 7 | 5 | 63 | 40 | ||
| 56987 | 63133 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | 2 | 7 | 7 | 28859 | 2 | ||
| 133256 | 5134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 3X3 | 6002450.59942 | 2095504.85865 | 37.7339960032757 | -122.433930487392 | (37.7339960032757, -122.433930487392) | 2 | 7 | 5 | 63 | 7 | ||
| 129894 | 69204 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.411911217702 | (37.7518104876034, -122.411911217702) | 2 | 4 | 7 | 28859 | 19 |
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) );