trees
877 rows where qLegalStatus_id = 1 and qSpecies_id = 6 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 92547 | 106331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:38:00 PM | 3 | 3x3 | 5988118.12003 | 2098953.52216 | 37.7426413556222 | -122.483734446336 | (37.7426413556222, -122.483734446336) | 1 | 8 | 3 | 29491 | 35 | ||
| 149522 | 106431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | 8 | 2 | 9 | 28853 | 34 | |||
| 35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 68252 | 106608 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 2654 | 108556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) | 9 | 7 | 6 | 28861 | 25 |
| 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 | ||
| 91948 | 109136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.47436 | 2111505.41074 | 37.7768703987748 | -122.498566890903 | (37.7768703987748, -122.498566890903) | 11 | 6 | 2 | 55 | 26 |
| 169615 | 109265 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260 | 2101732.7 | 37.7499882212347 | -122.500737615767 | (37.7499882212347, -122.500737615767) | 1 | 8 | 3 | 29491 | 35 |
| 50370 | 109275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) | 1 | 8 | 3 | 56 | 35 |
| 186425 | 109577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) | 9 | 7 | 6 | 28861 | 25 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 152525 | 109744 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.7583589503944 | -122.507191346523 | (37.7583589503944, -122.507191346523) | 1 | 8 | 3 | 56 | 35 |
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 31538 | 113355 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.7797303315274 | -122.503248436763 | (37.7797303315274, -122.503248436763) | 11 | 6 | 2 | 55 | 26 | |||
| 129314 | 113356 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982735.90689 | 2112577.00884 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | 11 | 6 | 2 | 55 | 26 | |||
| 153523 | 113357 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 POINT LOBOS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5982777 | 2112621 | 37.7798560111402 | -122.503213894495 | (37.7798560111402, -122.503213894495) | 11 | 6 | 2 | 55 | 26 | ||||
| 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 | |||
| 159810 | 114206 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1030 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 01:19:00 PM | 3 | 3x3 | 5989968.0933 | 2099069.2019 | 37.7430664963024 | -122.477346296714 | (37.7430664963024, -122.477346296714) | 1 | 8 | 3 | 29491 | 35 | ||
| 43518 | 114818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 825 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2018 12:00:00 AM | 3 | Permit Number 774480 | 5986555.6 | 2110296.1 | 37.773693882861 | -122.489971179067 | (37.773693882861, -122.489971179067) | 11 | 6 | 2 | 55 | 26 | ||
| 69435 | 114895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | 11 | 6 | 2 | 55 | 26 | |||
| 59213 | 115174 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 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 | |||
| 63206 | 115239 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 70295 | 11573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 169433 | 115802 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192749 | (37.7636499175412, -122.50814192749) | 1 | 8 | 3 | 56 | 35 | |
| 115054 | 11582 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4000 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.7605501938414 | -122.505003612665 | (37.7605501938414, -122.505003612665) | 1 | 8 | 3 | 56 | 35 | ||
| 58640 | 11589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.3567285 | 2105594.1635633 | 37.7605162040396 | -122.505407296146 | (37.7605162040396, -122.505407296146) | 1 | 8 | 3 | 56 | 35 | ||
| 59994 | 11598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.7604834464148 | -122.506543543521 | (37.7604834464148, -122.506543543521) | 1 | 8 | 3 | 56 | 35 | ||
| 93431 | 11602 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | 1 | 8 | 3 | 56 | 35 | ||
| 145389 | 11603 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4245 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 05:31:00 PM | 3 | 3X3 | 5981392.2965206 | 2105523.6051476 | 37.7602871413722 | -122.507477357537 | (37.7602871413722, -122.507477357537) | 1 | 8 | 3 | 56 | 35 | ||
| 55470 | 11606 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.7604509471428 | -122.507135818078 | (37.7604509471428, -122.507135818078) | 1 | 8 | 3 | 56 | 35 | ||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 138570 | 116539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001567.48738 | 2088213.72569 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | 9 | 7 | 6 | 28861 | 5 | |||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 69235 | 116543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001574.84931 | 2088164.89401 | 37.7137923832878 | -122.43643306305 | (37.7137923832878, -122.43643306305) | 9 | 7 | 6 | 28861 | 5 | |||
| 7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
| 144424 | 116545 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 1 | Median : Yard | Tree | DPW 1 | 2 | 3x3 | 6001537.05763 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | 9 | 7 | 6 | 28861 | 5 | |||
| 116664 | 116546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001545.43478 | 2088113.86518 | 37.7136505979649 | -122.436531080144 | (37.7136505979649, -122.436531080144) | 9 | 7 | 6 | 28861 | 5 | |||
| 95040 | 116547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 3 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | 9 | 7 | 6 | 28861 | 5 | |||
| 138388 | 116548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 4 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001544.87474 | 2088178.15499 | 37.7138270917124 | -122.436537614614 | (37.7138270917124, -122.436537614614) | 9 | 7 | 6 | 28861 | 5 | |||
| 139455 | 116549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 5 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001562.82912 | 2088145.24079 | 37.7137377368707 | -122.436473203396 | (37.7137377368707, -122.436473203396) | 9 | 7 | 6 | 28861 | 5 | |||
| 123255 | 116550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001534.78323 | 2088160.34451 | 37.7137776146169 | -122.436571220504 | (37.7137776146169, -122.436571220504) | 9 | 7 | 6 | 28861 | 5 | |||
| 58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 35644 | 117055 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.493860404631 | (37.7747038750392, -122.493860404631) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | ||
| 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 | ||
| 63426 | 117686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 34 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5982669.57188 | 2112585.47797 | 37.7797521626965 | -122.503582898398 | (37.7797521626965, -122.503582898398) | 11 | 6 | 2 | 55 | 26 | |||
| 104812 | 117687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.503826840405 | (37.7797745547632, -122.503826840405) | 11 | 6 | 2 | 55 | 26 | |||
| 82708 | 117883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | 11 | 6 | 2 | 55 | 26 | |||
| 128256 | 117895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | 11 | 6 | 2 | 55 | 26 | |||
| 113649 | 117934 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982916.92515 | 2109877.96567 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | 11 | 6 | 2 | 55 | 26 | |||
| 162564 | 118108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | 11 | 6 | 2 | 55 | 26 | ||
| 139164 | 118188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.493943116599 | (37.7747152280145, -122.493943116599) | 11 | 6 | 2 | 55 | 26 | |||
| 139886 | 118581 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 5982478.43556 | 2112606.93724 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | 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 | |||
| 114283 | 118588 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982305.68238 | 2112631.11012 | 37.7798560544886 | -122.504845112217 | (37.7798560544886, -122.504845112217) | 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 | |||
| 156031 | 118592 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5982471.06333 | 2112548.68274 | 37.7796394610188 | -122.504266888216 | (37.7796394610188, -122.504266888216) | 11 | 6 | 2 | 55 | 26 | |||
| 102188 | 118593 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5982449.24993 | 2112557.22359 | 37.7796616287576 | -122.504342981812 | (37.7796616287576, -122.504342981812) | 11 | 6 | 2 | 55 | 26 | |||
| 194199 | 118595 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | 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 | |||
| 168020 | 118692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4549 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5981428.28301 | 2110941.30275 | 37.7751646862289 | -122.507754939589 | (37.7751646862289, -122.507754939589) | 11 | 6 | 2 | 55 | 26 | |||
| 102876 | 119072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | Width 4ft | Permit Number 778557 | 5981931.09212 | 2111414.85236 | 37.7764945246953 | -122.506050759134 | (37.7764945246953, -122.506050759134) | 11 | 6 | 2 | 55 | 26 | |
| 186887 | 119083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | 11 | 6 | 2 | 55 | 26 | |||
| 83077 | 119164 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) | 11 | 6 | 2 | 55 | 26 | |||
| 124907 | 119231 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4327 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982159.48772 | 2110285.61161 | 37.7734074014784 | -122.505176976845 | (37.7734074014784, -122.505176976845) | 11 | 6 | 2 | 55 | 26 | |||
| 13391 | 119240 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | 11 | 6 | 2 | 55 | 26 | |||
| 184601 | 119241 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.5077607921 | (37.776245435782, -122.5077607921) | 11 | 6 | 2 | 55 | 26 | |||
| 83413 | 119242 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | 11 | 6 | 2 | 55 | 26 | |||
| 154132 | 119243 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981398.37029 | 2111333.42566 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 186958 | 120000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 818 30th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5986676.70436 | 2110336.54693 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | 11 | 6 | 2 | 55 | 26 | |||
| 170818 | 120009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5986962.57059 | 2110820.51914 | 37.775157546008 | -122.488601975561 | (37.775157546008, -122.488601975561) | 11 | 6 | 2 | 55 | 26 | |||
| 178384 | 120804 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.479069875733 | (37.774932704327, -122.479069875733) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 8275 | 123462 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995351.08305 | 2111296.01241 | 37.7769490481008 | -122.459618879478 | (37.7769490481008, -122.459618879478) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );