trees
1,121 rows where qSpecies_id = 6 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 106631 | 51232 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1130 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.7637059584567 | -122.452316160446 | (37.7637059584567, -122.452316160446) | 15 | 5 | 11 | 29492 | 9 | |||
| 107198 | 50036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.62107 | 2093714.43935 | 37.7293838567558 | -122.415196429982 | (37.7293838567558, -122.415196429982) | 9 | 3 | 7 | 309 | 28 | |
| 107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 108082 | 41787 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011846.53611 | 2107450.83181 | 37.7673257817889 | -122.402285287842 | (37.7673257817889, -122.402285287842) | 8 | 2 | 8 | 28853 | 20 | |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 | ||
| 116336 | 41826 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2517 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42212 | 5998421.57666404 | 2111723.27260806 | 37.7782982768263 | -122.449027932684 | (37.7782982768263, -122.449027932684) | 15 | 6 | 2 | 54 | 16 | |||
| 116677 | 115268 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2275 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775658 | 5987276.1 | 2099806.2 | 37.7449335319328 | -122.486708467871 | (37.7449335319328, -122.486708467871) | 1 | 8 | 3 | 29491 | 35 | |||
| 117146 | 39959 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 492 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 2 | Permit Number 43327 | 5993771.39961 | 2112170.75464 | 37.7792598926327 | -122.465146995833 | (37.7792598926327, -122.465146995833) | 11 | 6 | 2 | 54 | 11 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 117931 | 74157 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768269 | 6008310.54477322 | 2097714.64471242 | 37.740394399357 | -122.413827044611 | (37.740394399357, -122.413827044611) | 2 | 7 | 7 | 28859 | 2 | ||
| 122415 | 92665 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 123991 | 65594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | 10 | 3 | 8 | 58 | 1 | ||
| 126848 | 41809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.7796097242619 | -122.443712533479 | (37.7796097242619, -122.443712533479) | 15 | 5 | 1 | 29490 | 16 | |
| 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 | ||
| 127936 | 52557 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | 1 | 8 | 3 | 56 | 35 | |
| 128864 | 43975 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | 2 | Permit Number 43537 | 5981491.7088 | 2110943.54345 | 37.7751745750496 | -122.50753570575 | (37.7751745750496, -122.50753570575) | 11 | 6 | 2 | 55 | 26 | ||
| 131707 | 52954 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.11633 | 37.7224704120511 | -122.439451120374 | (37.7224704120511, -122.439451120374) | 9 | 7 | 6 | 28861 | 25 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 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 | |
| 138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
| 139435 | 43740 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 139943 | 115757 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.21291 | 37.7151093927473 | -122.448405831859 | (37.7151093927473, -122.448405831859) | 9 | 7 | 6 | 28861 | 25 | ||
| 140711 | 41785 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | 8 | 2 | 8 | 28853 | 20 | |
| 143378 | 87558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 05:19:00 PM | 3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | |||
| 144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 145011 | 117426 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 395 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.92006 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | 9 | 7 | 6 | 28861 | 5 | ||
| 145329 | 110718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||||
| 145694 | 40073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |
| 148668 | 49802 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071 | 2106574 | 37.765042114519 | -122.394529717904 | (37.765042114519, -122.394529717904) | 14 | 3 | 8 | 28856 | 29 | ||
| 150135 | 50120 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769150 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||
| 151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
| 152713 | 48663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1300 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2002 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.7638910715093 | -122.468357408335 | (37.7638910715093, -122.468357408335) | 1 | 8 | 11 | 56 | 12 | ||
| 152733 | 40072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.7308327545053 | -122.393144818701 | (37.7308327545053, -122.393144818701) | 10 | 3 | 8 | 58 | 1 | |
| 152989 | 47678 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | 10 | 3 | 8 | 28856 | 29 | |
| 154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 154918 | 52292 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48451 | 6006201.82590602 | 2099532.89904471 | 37.7452682661505 | -122.421247257698 | (37.7452682661505, -122.421247257698) | 2 | 7 | 5 | 28859 | 2 | ||
| 155044 | 52456 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.7741102732547 | -122.469236887906 | (37.7741102732547, -122.469236887906) | 11 | 6 | 2 | 54 | 11 | |
| 155326 | 176918 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 9 | Median : Yard | Tree | DPW 1 | 4 | 6001604.80367 | 2088215.91202 | 37.7139341694897 | -122.436333178956 | (37.7139341694897, -122.436333178956) | 9 | 7 | 6 | 28861 | 5 | ||||
| 156644 | 41807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | 15 | 5 | 1 | 29490 | 16 | |
| 158624 | 49803 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | 14 | 3 | 8 | 28856 | 29 | |
| 162239 | 94098 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2010 12:00:00 AM | 4 | Permit Number 53474 | 6007925.01702 | 2094192.51392 | 37.7307017385741 | -122.414910830466 | (37.7307017385741, -122.414910830466) | 9 | 3 | 7 | 309 | 28 | ||
| 164477 | 227094 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009153.63089 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | 10 | 7 | 7 | 28859 | 2 | ||||
| 164972 | 59404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 770892 | 6003547.68037437 | 2095024.45734525 | 37.7327391275899 | -122.430103282559 | (37.7327391275899, -122.430103282559) | 9 | 7 | 5 | 28861 | 25 | |||
| 167096 | 98557 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2012 12:00:00 AM | 3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | |||
| 169035 | 47267 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296 | (37.7617374028544, -122.48229953296) | 1 | 8 | 3 | 56 | 35 | |
| 170413 | 191224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | 10 | 3 | 8 | 28856 | 29 | ||||
| 171342 | 47598 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 171435 | 258215 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2400 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | Permit Number 783182 | 5983025.27936 | 2098776.48804 | 37.7418574964013 | -122.501330634264 | (37.7418574964013, -122.501330634264) | 1 | 8 | 3 | 29491 | 35 | ||
| 171991 | 47551 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | 2 | 7 | 5 | 63 | 22 | ||
| 172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 174553 | 115183 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3610 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2016 12:00:00 AM | Permit Number 774488 | 5982230.3 | 2100857.8 | 37.7475254834273 | -122.50423350924 | (37.7475254834273, -122.50423350924) | 1 | 8 | 3 | 29491 | 35 | |||
| 174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
| 174893 | 191225 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011119.4005 | 2104649.28038 | 37.7595927363317 | -122.404603122242 | (37.7595927363317, -122.404603122242) | 10 | 3 | 8 | 28856 | 29 | ||||
| 175025 | 115381 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1657X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 175230 | 59241 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | Permit Number 18570 | 5998056.20401336 | 2105984.36092392 | 37.7625197907884 | -122.449878183328 | (37.7625197907884, -122.449878183328) | 15 | 5 | 11 | 29492 | 9 | ||
| 175521 | 41812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | 15 | 5 | 1 | 29490 | 16 | |
| 176687 | 63095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | 1 | 8 | 3 | 56 | 35 | ||
| 177874 | 42963 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.507066636025 | (37.7778257173711, -122.507066636025) | 11 | 6 | 2 | 55 | 26 | ||
| 177940 | 50032 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 33 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 5 | Permit Number 46764 | 6007353.74197 | 2093754.84576 | 37.7294678795239 | -122.416854825683 | (37.7294678795239, -122.416854825683) | 9 | 3 | 7 | 309 | 28 | |
| 178343 | 46893 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
| 178481 | 117431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.11578 | 2091567.32576 | 37.7232841663055 | -122.427563407639 | (37.7232841663055, -122.427563407639) | 9 | 7 | 6 | 28861 | 5 | ||
| 184322 | 47592 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 188309 | 50524 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2003 12:00:00 AM | Permit Number 47164 | 6005968.07304834 | 2104305.31315666 | 37.758359035924 | -122.422394568264 | (37.758359035924, -122.422394568264) | 2 | 4 | 5 | 28859 | 19 | ||
| 191490 | 60927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.96946 | 37.7321668403311 | -122.406288313254 | (37.7321668403311, -122.406288313254) | 10 | 3 | 7 | 309 | 28 | ||
| 192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
| 192805 | 115237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.7723677654738 | -122.502584200594 | (37.7723677654738, -122.502584200594) | 11 | 6 | 2 | 55 | 26 | |||
| 193291 | 45368 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44193 | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||
| 193498 | 47037 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.7705849188534 | -122.435471392977 | (37.7705849188534, -122.435471392977) | 15 | 5 | 11 | 29492 | 9 | ||
| 194121 | 52944 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.441525334084 | (37.727706542786, -122.441525334084) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||
| 93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
| 31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 46761 | 27182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.57211 | 37.7295378108224 | -122.433039593603 | (37.7295378108224, -122.433039593603) | 9 | 7 | 6 | 28861 | 25 | ||
| 76315 | 27177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.85102 | 37.7294055924915 | -122.432438768257 | (37.7294055924915, -122.432438768257) | 9 | 7 | 6 | 28861 | 25 | ||
| 82967 | 25763 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.38583 | 37.711281031873 | -122.427342931648 | (37.711281031873, -122.427342931648) | 9 | 7 | 6 | 28861 | 5 | ||
| 109581 | 27083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 773 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006444.73415 | 2093622.02758 | 37.7290520177348 | -122.419987938702 | (37.7290520177348, -122.419987938702) | 9 | 7 | 7 | 309 | 5 | ||
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 122988 | 27089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 725 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6006167.96193 | 2093597.45552 | 37.728968950933 | -122.420943019604 | (37.728968950933, -122.420943019604) | 9 | 7 | 6 | 28861 | 5 | ||
| 125710 | 27179 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 231 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2009 12:00:00 AM | 3 | 2X3 | 6002801.57598 | 2093850.95144 | 37.7294746613043 | -122.432598955494 | (37.7294746613043, -122.432598955494) | 9 | 7 | 6 | 28861 | 25 | ||
| 156893 | 27081 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 157521 | 27181 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 225 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6002702.00816 | 2093915.39197 | 37.7296459533895 | -122.432947772843 | (37.7296459533895, -122.432947772843) | 9 | 7 | 6 | 28861 | 25 | ||
| 175351 | 27251 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 6005015.49022 | 2093543.05731 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | 9 | 7 | 6 | 28861 | 5 | |||
| 13551 | 10193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6005736.25987 | 2102154.58599 | 37.7524405594089 | -122.423043415947 | (37.7524405594089, -122.423043415947) | 2 | 4 | 5 | 28859 | 19 | |||
| 157196 | 27169 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.99276 | 37.7361294762783 | -122.39905085002 | (37.7361294762783, -122.39905085002) | 10 | 3 | 8 | 58 | 1 | ||
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 2299 | 27284 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | 9 | 7 | 7 | 309 | 5 | ||
| 10393 | 3666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.7441802162386 | -122.383400533034 | (37.7441802162386, -122.383400533034) | 10 | 3 | 8 | 58 | 1 | ||
| 11481 | 3673 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.62034 | 37.7444159222737 | -122.383819238476 | (37.7444159222737, -122.383819238476) | 10 | 3 | 8 | 58 | 1 | ||
| 11900 | 3534 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.12937 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | 10 | 3 | 8 | 58 | 1 | ||
| 12906 | 27193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2009 12:00:00 AM | 6 | 3X3 | 6003096.09594 | 2093601.65823 | 37.7288068562446 | -122.431562981455 | (37.7288068562446, -122.431562981455) | 9 | 7 | 6 | 28861 | 25 | ||
| 13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 18371 | 27202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.430149591636 | (37.7284840526724, -122.430149591636) | 9 | 7 | 6 | 28861 | 5 | ||
| 21651 | 27207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.28644 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | 9 | 7 | 6 | 28861 | 5 |
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) );