trees
1,121 rows where qSpecies_id = 6 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52224 | 129373 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | 13 | 9 | 1 | 57 | 17 | |||
| 163097 | 129372 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999985.51807 | 2120890.75849 | 37.8035591091338 | -122.444276660352 | (37.8035591091338, -122.444276660352) | 13 | 9 | 1 | 57 | 17 | |||
| 67418 | 255648 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2834 Polk St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779253 | 6006100.90264 | 2120497.78973 | 37.8028271147622 | -122.423086110708 | (37.8028271147622, -122.423086110708) | 5 | 9 | 1 | 28858 | 32 | |
| 169832 | 65853 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.441501736515 | (37.8013609996628, -122.441501736515) | 13 | 9 | 1 | 57 | 17 | |
| 63396 | 129389 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006655.24817 | 2120043.69212 | 37.8016115444852 | -122.421135524881 | (37.8016115444852, -122.421135524881) | 5 | 9 | 1 | 28858 | 32 | |||
| 57139 | 83205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | 13 | 9 | 1 | 57 | 17 | |
| 188002 | 88645 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2500x Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51618 | 6006882.7 | 2119972.1 | 37.8014277902223 | -122.420343352043 | (37.8014277902223, -122.420343352043) | 5 | 1 | 1 | 28858 | 32 | |||
| 29272 | 129388 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006666.99925 | 2119949.93729 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | 5 | 9 | 1 | 28858 | 32 | |||
| 42678 | 87855 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2537 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50783 | 6006632 | 2119882 | 37.8011662683494 | -122.421204486113 | (37.8011662683494, -122.421204486113) | 5 | 9 | 1 | 28858 | 32 | ||
| 179565 | 129387 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.8010643609816 | -122.421036932226 | (37.8010643609816, -122.421036932226) | 5 | 9 | 1 | 28858 | 32 | |||
| 74064 | 42693 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |
| 29195 | 34680 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.431295719127 | (37.7996008996227, -122.431295719127) | 13 | 9 | 1 | 57 | 17 | |
| 142719 | 124805 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2798 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781937 | 5999607.72686 | 2118800.07594 | 37.7977970943207 | -122.445433600384 | (37.7977970943207, -122.445433600384) | 13 | 9 | 1 | 57 | 17 | |
| 150091 | 129390 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.412262888224 | (37.798209676283, -122.412262888224) | 3 | 1 | 10 | 308 | 21 | |||
| 4801 | 125249 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | Width 3ft | 6008457.69643 | 2118247.71377 | 37.7967816796858 | -122.414771036277 | (37.7967816796858, -122.414771036277) | 5 | 1 | 10 | 308 | 21 | ||
| 6798 | 125247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1085 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782055 | 6008420.1565 | 2118241.89629 | 37.796763597016 | -122.414900521554 | (37.796763597016, -122.414900521554) | 5 | 1 | 10 | 308 | 21 | |
| 4231 | 261663 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1099x Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | 6008393 | 2118190 | 37.7966195766837 | -122.414990814528 | (37.7966195766837, -122.414990814528) | 5 | 1 | 10 | 308 | 21 | |||
| 127633 | 52071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.410515038747 | (37.7954949369081, -122.410515038747) | 3 | 1 | 10 | 28857 | 4 | ||
| 194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 | ||
| 80490 | 83685 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | 3 | 1 | 10 | 28857 | 4 | |
| 42267 | 83686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.29288 | 2117660.17543 | 37.7952218082983 | -122.411440210903 | (37.7952218082983, -122.411440210903) | 3 | 1 | 10 | 28857 | 4 | |
| 81222 | 83687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.65188 | 2117634.89994 | 37.7951527646548 | -122.411416421158 | (37.7951527646548, -122.411416421158) | 3 | 1 | 10 | 28857 | 4 | |
| 166093 | 88438 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421 | 2117567 | 37.7949666840821 | -122.411389656386 | (37.7949666840821, -122.411389656386) | 3 | 1 | 10 | 28857 | 4 | |||
| 154237 | 60223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.59197 | 2117542.6242 | 37.7949000677337 | -122.411368584404 | (37.7949000677337, -122.411368584404) | 3 | 1 | 10 | 28857 | 4 | |
| 146089 | 52362 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.93646 | 2117377.76116 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | 5 | 1 | 10 | 28858 | 21 | |
| 92442 | 129379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1765 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005697.11148 | 2117184.40611 | 37.793706610722 | -122.424247645012 | (37.793706610722, -122.424247645012) | 13 | 9 | 1 | 28858 | 27 | |||
| 41709 | 129378 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | 13 | 9 | 1 | 29490 | 27 | |||
| 95828 | 129377 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002239.2844 | 2116842.37021 | 37.7925716168296 | -122.436187522037 | (37.7925716168296, -122.436187522037) | 13 | 9 | 1 | 29490 | 27 | |||
| 21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
| 43690 | 52885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.7924687577648 | -122.436169092224 | (37.7924687577648, -122.436169092224) | 13 | 9 | 1 | 29490 | 27 | ||
| 136198 | 255789 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2240 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003983 | 2116665 | 37.7921835181407 | -122.430141547967 | (37.7921835181407, -122.430141547967) | 13 | 9 | 1 | 29490 | 27 | ||||
| 135075 | 52442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.431503592933 | (37.7920224826905, -122.431503592933) | 13 | 9 | 1 | 29490 | 27 | |
| 74010 | 129386 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | 5 | 1 | 10 | 28857 | 21 | |||
| 81750 | 129385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | 5 | 1 | 10 | 28857 | 21 | |||
| 53099 | 113489 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | 11 | 6 | 1 | 54 | 31 | |||
| 20629 | 51532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.43094 | 37.78839440084 | -122.44482529806 | (37.78839440084, -122.44482529806) | 13 | 6 | 1 | 29490 | 27 | ||
| 27719 | 250553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 1 | : | Tree | Private 2 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.7877136895948 | -122.484739928202 | (37.7877136895948, -122.484739928202) | 11 | 6 | 1 | 55 | 33 | |||
| 183672 | 250554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 2 | : | Tree | Private 2 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | 11 | 6 | 1 | 55 | 33 | |||
| 106437 | 250555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 3 | : | Tree | Private 2 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | 11 | 6 | 1 | 55 | 33 | |||
| 21393 | 87031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52524 | 5994278.21944 | 2115255.72364 | 37.7877595955023 | -122.463617666169 | (37.7877595955023, -122.463617666169) | 11 | 6 | 1 | 54 | 11 | |
| 2780 | 79224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3562 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997807.39537 | 2115154.90167 | 37.7876854832564 | -122.451400172276 | (37.7876854832564, -122.451400172276) | 11 | 6 | 1 | 54 | 31 | |||
| 119325 | 129374 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998634.47077 | 2115144.95556 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | 13 | 6 | 1 | 54 | 31 | |||
| 21404 | 129375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998637.858 | 2115126.26996 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | 13 | 6 | 1 | 54 | 31 | |||
| 132744 | 50185 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 139 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49870 | 5987999.15348 | 2115065.15007 | 37.7868725355783 | -122.485327781661 | (37.7868725355783, -122.485327781661) | 11 | 6 | 1 | 55 | 33 | |
| 183256 | 88394 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 139 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.7867985724398 | -122.485322676521 | (37.7867985724398, -122.485322676521) | 11 | 6 | 1 | 55 | 33 | ||
| 76042 | 79199 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | 11 | 6 | 1 | 54 | 31 | |
| 102379 | 84816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.93046 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | 5 | 1 | 10 | 28858 | 21 | |
| 142268 | 129380 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008321.92773 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | 5 | 1 | 10 | 28858 | 21 | |||
| 49974 | 73594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.7875805296608 | -122.414547298434 | (37.7875805296608, -122.414547298434) | 5 | 1 | 10 | 28858 | 21 | |
| 158967 | 79726 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | 5 | 1 | 10 | 28858 | 21 | ||
| 131191 | 71549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.414625660841 | (37.7875672592553, -122.414625660841) | 5 | 1 | 10 | 28858 | 21 |
| 51537 | 100491 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.7867936596919 | -122.458440353598 | (37.7867936596919, -122.458440353598) | 11 | 6 | 1 | 54 | 31 | |
| 72800 | 121883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248 | -122.477592056385 | (37.786404156248, -122.477592056385) | 11 | 6 | 1 | 55 | 33 | |||
| 82053 | 121884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5990230.57834 | 2114834.81932 | 37.7863698548312 | -122.477590808601 | (37.7863698548312, -122.477590808601) | 11 | 6 | 1 | 55 | 33 | |||
| 155117 | 94712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) | 11 | 6 | 2 | 54 | 11 |
| 94740 | 50815 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 131 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2004 12:00:00 AM | 4 | Permit Number 47338 | 5993943.23893 | 2114634.67726 | 37.7860350644754 | -122.464731509757 | (37.7860350644754, -122.464731509757) | 11 | 6 | 2 | 54 | 11 | ||
| 146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
| 76341 | 47469 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.7854156010234 | -122.445403484856 | (37.7854156010234, -122.445403484856) | 15 | 6 | 1 | 29490 | 31 | |
| 125716 | 119982 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | 11 | 6 | 1 | 55 | 26 | |||
| 57001 | 36152 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 4 | Permit Number 39237 | 5996489.9045 | 2114249.7041 | 37.7851245233187 | -122.455892946486 | (37.7851245233187, -122.455892946486) | 11 | 6 | 1 | 54 | 31 | |
| 120895 | 88732 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | 13 | 9 | 11 | 29490 | 13 | ||
| 31525 | 251509 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 103037 | 251507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 131156 | 251508 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 132614 | 251506 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 148373 | 129381 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.413883591577 | (37.7856101663154, -122.413883591577) | 7 | 10 | 9 | 28852 | 36 | |||
| 95229 | 250789 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 285 32nd Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5985873.63674 | 2113998.18517 | 37.7838189038641 | -122.492602865457 | (37.7838189038641, -122.492602865457) | 11 | 6 | 1 | 55 | 33 | |||
| 113032 | 111713 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 105283 | 83202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | 11 | 6 | 2 | 55 | 26 | |||
| 62319 | 88398 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.92322 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | 11 | 6 | 2 | 55 | 26 | |
| 89162 | 88397 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.7817097621118 | -122.487138517946 | (37.7817097621118, -122.487138517946) | 11 | 6 | 2 | 55 | 26 | ||
| 8242 | 264706 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 17698 | 264705 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 9840 | 256599 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 29256 | 256605 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 32904 | 256600 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 51877 | 256607 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 61590 | 256576 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 70541 | 256574 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 92562 | 256604 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 134706 | 256601 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 160238 | 256575 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 183981 | 256606 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 44290 | 140758 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.7815689287559 | -122.442554464995 | (37.7815689287559, -122.442554464995) | 15 | 5 | 1 | 29490 | 16 | |||
| 104311 | 96799 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 438 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 2 | Permit Number 769004 | 5983479.29231 | 2112857.21489 | 37.7805458450517 | -122.500801866987 | (37.7805458450517, -122.500801866987) | 11 | 6 | 2 | 55 | 26 | ||
| 10365 | 256095 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | ||||
| 14180 | 256094 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777292 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | |
| 109142 | 96082 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 448 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767705 | 5982547.81502 | 2112777.55396 | 37.7802723877651 | -122.504018332463 | (37.7802723877651, -122.504018332463) | 11 | 6 | 2 | 55 | 26 | |
| 1777 | 260927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 354 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5981645 | 2112753 | 37.7801518383055 | -122.507139709579 | (37.7801518383055, -122.507139709579) | 11 | 6 | 2 | 55 | 26 | ||||
| 16685 | 251006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 348 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.7800429545487 | -122.507083518802 | (37.7800429545487, -122.507083518802) | 11 | 6 | 2 | 55 | 26 | |||
| 20622 | 251003 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Point Lobos Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5981957.64195 | 2112675.64357 | 37.7799578490271 | -122.506052420011 | (37.7799578490271, -122.506052420011) | 11 | 6 | 2 | 55 | 26 | |||
| 120195 | 251002 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Point Lobos Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.505931690493 | (37.7799462432625, -122.505931690493) | 11 | 6 | 2 | 55 | 26 | |||
| 30229 | 251001 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Point Lobos Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | 11 | 6 | 2 | 55 | 26 | |||
| 7092 | 118587 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 134 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982351 | 2112664 | 37.7799490263229 | -122.504690778822 | (37.7799490263229, -122.504690778822) | 11 | 6 | 2 | 55 | 26 | |||
| 92254 | 251000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 226 Point Lobos Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5982074.74727 | 2112660.45291 | 37.7799230326473 | -122.505646180935 | (37.7799230326473, -122.505646180935) | 11 | 6 | 2 | 55 | 26 | |||
| 82485 | 118666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5982506.22463 | 2112651.75572 | 37.7799245369815 | -122.504152889313 | (37.7799245369815, -122.504152889313) | 11 | 6 | 2 | 55 | 26 | |||
| 1932 | 250999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5982160.80138 | 2112648.74636 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | 11 | 6 | 2 | 55 | 26 | |||
| 162045 | 24747 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.7798709615679 | -122.505158146759 | (37.7798709615679, -122.505158146759) | 11 | 6 | 2 | 55 | 26 | ||
| 169302 | 118589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982275.32502 | 2112634.79146 | 37.779864376411 | -122.50495040284 | (37.779864376411, -122.50495040284) | 11 | 6 | 2 | 55 | 26 |
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) );