trees
169 rows where qSpecies_id = 3 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
| 80157 | 24936 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2099X Post St | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/21/2007 12:00:00 AM | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 128206 | 26749 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2099X Post St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/28/1999 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
| 175832 | 115290 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2642 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 774426 | 5991478.6 | 2097428.2 | 37.7386482527839 | -122.472003841981 | (37.7386482527839, -122.472003841981) | 1 | 8 | 4 | 29491 | 40 | |||
| 4743 | 167761 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 451 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780770 | 6000439.87639 | 2107208.3352 | 37.7660166188918 | -122.441721798828 | (37.7660166188918, -122.441721798828) | 15 | 5 | 5 | 29492 | 3 | |
| 21928 | 87453 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 525 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2008 12:00:00 AM | 3 | 3x3 | 5999059.32842 | 2111007.41675 | 37.7763691743336 | -122.446770200329 | (37.7763691743336, -122.446770200329) | 15 | 6 | 2 | 29492 | 16 | ||
| 38508 | 93522 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 36 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 4x5 | Permit Number 53241 | 6001363.6 | 2107898.4 | 37.7679639544684 | -122.438576280736 | (37.7679639544684, -122.438576280736) | 15 | 5 | 5 | 29492 | 3 | ||
| 76668 | 88258 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 327 Carl St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51243 | 5996646 | 2106962 | 37.7651233493989 | -122.454826175676 | (37.7651233493989, -122.454826175676) | 15 | 5 | 11 | 29492 | 12 | |||
| 87504 | 87033 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 30 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53735 | 6001416 | 2107932 | 37.7680591923974 | -122.43839744289 | (37.7680591923974, -122.43839744289) | 15 | 5 | 5 | 29492 | 3 | |
| 101551 | 14519 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 607 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | 8 | 3X3 | 5999088.24175 | 2110697.41803 | 37.7755196490068 | -122.446647872043 | (37.7755196490068, -122.446647872043) | 15 | 5 | 11 | 29492 | 16 | ||
| 134331 | 111021 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 90x DOWNEY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 27998 | 58743 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | Permit Number 779599 | 6007661.70452 | 2119773.97834 | 37.800927664051 | -122.417633590924 | (37.800927664051, -122.417633590924) | 5 | 1 | 1 | 308 | 32 | ||
| 81770 | 95643 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3x3` | Permit Number 767411 | 6009341 | 2118148 | 37.7965574803307 | -122.411707541294 | (37.7965574803307, -122.411707541294) | 3 | 1 | 10 | 308 | 4 | |
| 103511 | 126549 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2113 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782608 | 6008108.43544 | 2119716.18601 | 37.8007941084157 | -122.416083612992 | (37.8007941084157, -122.416083612992) | 5 | 1 | 1 | 308 | 32 |
| 115121 | 172492 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1650 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782055 | 6008369.46089 | 2118168.63641 | 37.7965595947944 | -122.415070752424 | (37.7965595947944, -122.415070752424) | 5 | 1 | 10 | 308 | 21 | |
| 3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
| 27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
| 2600 | 258371 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 4048 | 255910 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 85 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6007891 | 2093604 | 37.7290838947974 | -122.414986794268 | (37.7290838947974, -122.414986794268) | 9 | 3 | 7 | 309 | 28 | ||
| 5926 | 258370 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 6088 | 258369 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 9698 | 258382 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 91 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007891.9701 | 2093531.56209 | 37.7288850504069 | -122.414978315537 | (37.7288850504069, -122.414978315537) | 9 | 3 | 7 | 309 | 28 | |||
| 101133 | 114693 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 436 Hamilton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774634 | 6009470.9 | 2092282.5 | 37.7255439885799 | -122.409431705435 | (37.7255439885799, -122.409431705435) | 9 | 3 | 7 | 309 | 28 | ||||
| 13639 | 147784 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 237 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5991492.63835 | 2113823.73496 | 37.7836668536977 | -122.473150680654 | (37.7836668536977, -122.473150680654) | 11 | 6 | 2 | 54 | 26 | |||
| 6840 | 146944 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 657 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5982245.6447 | 2111287.33209 | 37.7761629024372 | -122.504953198457 | (37.7761629024372, -122.504953198457) | 11 | 6 | 2 | 55 | 26 | |||
| 15797 | 69451 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 446 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 1 | Permit Number 33561 | 5985648.90845 | 2112873.99944 | 37.78071907161 | -122.493297480343 | (37.78071907161, -122.493297480343) | 11 | 6 | 2 | 55 | 26 | |
| 52951 | 115234 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 614 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775529 | 5982925.7 | 2111574.8 | 37.776992191518 | -122.502622024839 | (37.776992191518, -122.502622024839) | 11 | 6 | 2 | 55 | 26 | |||
| 63366 | 110454 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | 11 | 6 | 2 | 55 | 26 | |
| 100740 | 110453 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | 11 | 6 | 2 | 55 | 26 | |
| 145406 | 88575 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 562 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51515 | 5990373.3 | 2111545.8 | 37.7773474033188 | -122.47685663061 | (37.7773474033188, -122.47685663061) | 11 | 6 | 2 | 55 | 26 | |||
| 187369 | 24737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.71592 | 2112541.16992 | 37.7796672396255 | -122.501417008283 | (37.7796672396255, -122.501417008283) | 11 | 6 | 2 | 55 | 26 | |
| 11383 | 54618 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1241 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773836 | 5995447.87893812 | 2107104.396215 | 37.7654455330173 | -122.458980467929 | (37.7654455330173, -122.458980467929) | 15 | 5 | 11 | 56 | 12 | ||
| 77580 | 109775 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1530 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775056 | 5992490 | 2105022.4 | 37.7595584460972 | -122.469059468108 | (37.7595584460972, -122.469059468108) | 1 | 8 | 4 | 56 | 12 |
| 79970 | 94823 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1247 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53903 | 5990745.7 | 2106901.7 | 37.7646175620315 | -122.475229262837 | (37.7646175620315, -122.475229262837) | 11 | 8 | 3 | 56 | 12 | |
| 110670 | 43224 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52405 | 5990924.01024208 | 2103958.73208826 | 37.7565472889648 | -122.474397763174 | (37.7565472889648, -122.474397763174) | 1 | 8 | 4 | 56 | 12 | ||
| 147711 | 46901 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1490 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | Permit Number 775424 | 5991189.27223217 | 2105275.5936987 | 37.7601784073134 | -122.473576456034 | (37.7601784073134, -122.473576456034) | 1 | 8 | 4 | 56 | 12 | ||
| 174021 | 117327 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1762 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778536 | 5992852.9 | 2103474.1 | 37.7553281792803 | -122.467691786389 | (37.7553281792803, -122.467691786389) | 1 | 8 | 4 | 56 | 12 | ||
| 180108 | 64097 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1275 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 4x4 | Permit Number 53106 | 5992357.42606092 | 2106782.26411484 | 37.7643829076917 | -122.469646088045 | (37.7643829076917, -122.469646088045) | 11 | 8 | 11 | 56 | 12 | ||
| 11065 | 259366 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1630 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6014976.19391 | 2094504.46411 | 37.731951983893 | -122.390555407158 | (37.731951983893, -122.390555407158) | 10 | 3 | 8 | 58 | 1 | ||
| 12619 | 261103 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 67 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013064 | 2090741 | 37.7215120099241 | -122.396902551001 | (37.7215120099241, -122.396902551001) | 10 | 3 | 8 | 58 | 1 | |
| 14422 | 264660 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1026 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014740.42217 | 2089801.7979 | 37.7190263183384 | -122.391041957232 | (37.7190263183384, -122.391041957232) | 10 | 3 | 8 | 58 | 1 | |||
| 26566 | 1397 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 46 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/1996 12:00:00 AM | 3 | 3X4 | 6017391.9702428 | 2095401.4824272 | 37.7345487420519 | -122.382265852373 | (37.7345487420519, -122.382265852373) | 10 | 3 | 8 | 58 | 1 | ||
| 35005 | 6638 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1499 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | 10 | 3 | 8 | 58 | 1 | ||
| 62325 | 6575 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1331 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017079.2770781 | 2097404.6143377 | 37.7400316650274 | -122.383486349847 | (37.7400316650274, -122.383486349847) | 10 | 3 | 8 | 58 | 1 | ||
| 64293 | 6477 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1200X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2004 12:00:00 AM | 3 | 3x3 | 6017471.90101 | 2097239.05901 | 37.7395987755115 | -122.382117290159 | (37.7395987755115, -122.382117290159) | 10 | 3 | 8 | 58 | 1 | ||
| 75164 | 256027 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1330 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 6016370 | 2093149 | 37.7283073735733 | -122.385642243241 | (37.7283073735733, -122.385642243241) | 10 | 3 | 8 | 58 | 1 | ||||
| 92899 | 190438 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 4 | : | Tree | DPW 1 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.7407421449384 | -122.38415488076 | (37.7407421449384, -122.38415488076) | 10 | 3 | 8 | 58 | 1 | ||
| 117072 | 190439 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 6 | : | Tree | DPW 1 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.7408108009722 | -122.384272247659 | (37.7408108009722, -122.384272247659) | 10 | 3 | 8 | 58 | 1 | ||
| 120431 | 188691 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 45 | : | Tree | DPW 1 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.7403143140663 | -122.38339440234 | (37.7403143140663, -122.38339440234) | 10 | 3 | 8 | 58 | 1 | ||
| 121223 | 6643 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1499 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | 10 | 3 | 8 | 58 | 1 | ||
| 125974 | 1404 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 63 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/1996 12:00:00 AM | 6 | 3X4 | 6017388.8354209 | 2095314.9218023 | 37.7343108905935 | -122.382270670557 | (37.7343108905935, -122.382270670557) | 10 | 3 | 8 | 58 | 1 | ||
| 149263 | 188692 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 46 | : | Tree | DPW 1 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | 10 | 3 | 8 | 58 | 1 | ||
| 154111 | 6541 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1201 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1997 12:00:00 AM | 3 | 4X4 | 6017765.6846273 | 2096901.7583545 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | 10 | 3 | 8 | 58 | 1 | ||
| 177500 | 188690 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 44 | : | Tree | DPW 1 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | 10 | 3 | 8 | 58 | 1 | ||
| 184142 | 6604 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1400 Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016747.6410828 | 2097755.6169144 | 37.7409771122017 | -122.384657465748 | (37.7409771122017, -122.384657465748) | 10 | 3 | 8 | 58 | 1 | ||
| 92208 | 87201 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637 | 2097914 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | 1 | 8 | 4 | 59 | 40 | ||
| 105180 | 114988 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 2 | Side Yard : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.7415364116566 | -122.467057099516 | (37.7415364116566, -122.467057099516) | 1 | 8 | 4 | 59 | 40 | |||
| 107555 | 106975 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.77277 | 2098449.45466 | 37.7415362855926 | -122.467057190372 | (37.7415362855926, -122.467057190372) | 1 | 8 | 4 | 59 | 40 | |||
| 108192 | 114981 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 115 Moncada Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 776112 | 5992157.9 | 2093028.6 | 37.7266073370069 | -122.469335018242 | (37.7266073370069, -122.469335018242) | 9 | 8 | 4 | 59 | 40 | |||
| 166075 | 67634 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.7400913848475 | -122.468021337222 | (37.7400913848475, -122.468021337222) | 1 | 8 | 4 | 59 | 40 | ||
| 51160 | 96776 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 226 27TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2011 12:00:00 AM | Permit Number 767240 | 6004896 | 2100216 | 37.7470701993865 | -122.425811201312 | (37.7470701993865, -122.425811201312) | 2 | 7 | 5 | 63 | 22 | |||
| 87955 | 35400 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 527 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50782 | 6003213.78352736 | 2098311.09733417 | 37.7417445720019 | -122.431492193982 | (37.7417445720019, -122.431492193982) | 2 | 7 | 5 | 63 | 7 | ||
| 112282 | 60630 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 470 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 772107 | 6003622.94051992 | 2096160.25019953 | 37.7358620195082 | -122.429924078324 | (37.7358620195082, -122.429924078324) | 2 | 7 | 5 | 63 | 7 | |
| 151570 | 96775 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 226 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2011 12:00:00 AM | Permit Number 767240 | 6004896 | 2100216 | 37.7470701993865 | -122.425811201312 | (37.7470701993865, -122.425811201312) | 2 | 7 | 5 | 63 | 22 | |||
| 591 | 264763 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
| 18566 | 256863 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/19/2018 12:00:00 AM | 3 | 3x8 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
| 25596 | 117510 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 23x BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993679 | 2087403 | 37.7112485771375 | -122.463668552658 | (37.7112485771375, -122.463668552658) | 9 | 8 | 4 | 64 | 24 | ||
| 41488 | 215160 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 125 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 781603 | 5992679.1263 | 2088076.57107 | 37.7130403764755 | -122.467173279126 | (37.7130403764755, -122.467173279126) | 9 | 8 | 6 | 64 | 24 | |
| 68354 | 41383 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2004 12:00:00 AM | 3x3 | Permit Number 771193 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 |
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) );