trees
508 rows where qSpecies_id = 25 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1940 | 43017 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 2735 | 262549 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 3 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | |||
| 3439 | 43015 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 4619 | 84421 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3450 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | 2 | 4 | 7 | 28859 | 19 | ||
| 5259 | 45154 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44007 | |||||||||||||
| 5523 | 38232 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 6572 | 34068 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 6767 | 38234 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 6809 | 65477 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 400 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28358 | 5994782.15079154 | 2091255.17859292 | 37.7218892499679 | -122.460134715976 | (37.7218892499679, -122.460134715976) | 9 | 8 | 4 | 28861 | 24 | ||
| 7060 | 38233 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 7097 | 34072 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 7436 | 43016 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 7461 | 32089 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3976 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35462 | 6003168.80356063 | 2104788.27114216 | 37.7595268169135 | -122.432110159889 | (37.7595268169135, -122.432110159889) | 2 | 4 | 5 | 28862 | 3 | ||
| 8908 | 69088 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.470278745237 | (37.7606123691548, -122.470278745237) | 1 | 8 | 4 | 56 | 12 | ||
| 9043 | 43018 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 9398 | 264655 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1099 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
| 9850 | 30919 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 Granada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941 | -122.457074050715 | (37.722170938941, -122.457074050715) | 9 | 8 | 4 | 28861 | 24 | |||
| 12809 | 38231 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 14576 | 34071 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 15256 | 259564 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
| 16742 | 34070 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 17037 | 264800 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 330 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011202 | 2089015 | 37.7166689455126 | -122.403217660421 | (37.7166689455126, -122.403217660421) | 10 | 7 | 8 | 309 | 39 | ||||
| 17098 | 34067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 19562 | 62935 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 108 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23316 | 6007129.03577236 | 2097271.50045175 | 37.7391111999262 | -122.417880841628 | (37.7391111999262, -122.417880841628) | 2 | 7 | 7 | 28859 | 2 | ||
| 19983 | 36067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 20477 | 39576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) | 2 | 7 | 7 | 28859 | 2 | ||
| 21840 | 67067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30456 | 6006871.92388007 | 2096801.0625203 | 37.7378050085566 | -122.418736466303 | (37.7378050085566, -122.418736466303) | 2 | 7 | 7 | 28859 | 2 | ||
| 22131 | 49877 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.7633942890183 | -122.467431700246 | (37.7633942890183, -122.467431700246) | 1 | 8 | 11 | 56 | 12 | |||
| 25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
| 28119 | 36065 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 28366 | 36001 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336 | (37.7472437298861, -122.41664293336) | 2 | 7 | 7 | 28859 | 2 | ||
| 28535 | 41155 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | 15 | 6 | 1 | 54 | 31 | |||
| 30403 | 32983 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | ||
| 30868 | 95394 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 208 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579 | 2098715 | 37.7429308791836 | -122.426800483584 | (37.7429308791836, -122.426800483584) | 2 | 7 | 5 | 63 | 22 | |
| 31110 | 48958 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
| 31262 | 69447 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | 11 | 6 | 2 | 55 | 26 | ||
| 32236 | 32806 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
| 33078 | 52211 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | 2 | 4 | 5 | 28859 | 19 | ||
| 33525 | 67084 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248 | -122.417988384197 | (37.738413501248, -122.417988384197) | 2 | 7 | 7 | 28859 | 2 | ||
| 34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
| 40331 | 45143 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | 15 | 5 | 11 | 29492 | 9 | ||
| 41477 | 34073 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | 8 | 4 | 7 | 28859 | 19 | ||
| 41836 | 32486 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.7187841 | 2106514.92813142 | 37.7641354685469 | -122.440289096409 | (37.7641354685469, -122.440289096409) | 15 | 5 | 5 | 28862 | 3 | ||
| 43247 | 35398 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | 2 | 7 | 5 | 63 | 22 | ||
| 44632 | 36064 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 44918 | 67927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.7330050563948 | -122.429274738173 | (37.7330050563948, -122.429274738173) | 9 | 7 | 5 | 28861 | 25 | ||
| 45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
| 47126 | 60044 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | 2 | 7 | 5 | 63 | 7 | ||
| 50698 | 66557 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29741 | 6005175.23956871 | 2104313.40408574 | 37.7583364956152 | -122.425137114448 | (37.7583364956152, -122.425137114448) | 2 | 4 | 5 | 28859 | 19 | ||
| 51882 | 32986 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
| 52069 | 60140 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | 1 | 8 | 4 | 56 | 12 | ||
| 52646 | 59406 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.7340363078834 | -122.42943165971 | (37.7340363078834, -122.42943165971) | 2 | 7 | 5 | 28861 | 25 | ||
| 53315 | 34425 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.7353641309188 | -122.429928789613 | (37.7353641309188, -122.429928789613) | 2 | 7 | 5 | 63 | 7 | ||
| 57421 | 32985 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
| 60037 | 93902 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768056 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||
| 60771 | 36002 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | 2 | 7 | 7 | 28859 | 2 | ||
| 62340 | 95571 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109 | 2102648 | 37.7536467518763 | -122.432164143819 | (37.7536467518763, -122.432164143819) | 2 | 4 | 5 | 28862 | 22 | |
| 69462 | 67933 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31646 | 6003490.5816971 | 2095075.42432118 | 37.7328758373096 | -122.43030432183 | (37.7328758373096, -122.43030432183) | 9 | 7 | 5 | 28861 | 25 | ||
| 70921 | 33910 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1456 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1997 12:00:00 AM | Permit Number 37880 | 6000788.78339737 | 2111054.09529381 | 37.7765959861438 | -122.440790896143 | (37.7765959861438, -122.440790896143) | 15 | 5 | 11 | 29492 | 41 | |||
| 71850 | 47716 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45512 | 6003756.95954941 | 2095440.56895285 | 37.7338935267661 | -122.429409415665 | (37.7338935267661, -122.429409415665) | 2 | 7 | 5 | 28861 | 25 | ||
| 76434 | 67080 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 343 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30477 | 6007097.80000141 | 2096683.93673196 | 37.7374961220492 | -122.417947200602 | (37.7374961220492, -122.417947200602) | 2 | 7 | 7 | 28859 | 2 | ||
| 76873 | 34040 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | 8 | 4 | 7 | 28859 | 19 | ||
| 79262 | 32807 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
| 79612 | 105962 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6013706.37383 | 2104134.52437 | 37.7583235710722 | -122.395619946844 | (37.7583235710722, -122.395619946844) | 10 | 3 | 8 | 28856 | 29 | ||||
| 85822 | 48957 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
| 89804 | 108167 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009908 | 2100009 | 37.7467837814289 | -122.40846544894 | (37.7467837814289, -122.40846544894) | 2 | 7 | 7 | 28859 | 2 | ||||
| 90128 | 72237 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 365 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53060 | 6003968.6918684 | 2103317.11324706 | 37.7555326838578 | -122.429238846799 | (37.7555326838578, -122.429238846799) | 2 | 4 | 5 | 28862 | 22 | ||
| 91608 | 50169 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 89@ DUBOCE Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2003 12:00:00 AM | Permit Number 46880 | 6001684.35285968 | 2108342.8233287 | 37.7692024719005 | -122.437498663894 | (37.7692024719005, -122.437498663894) | 15 | 5 | 5 | 29492 | 9 | |||
| 91917 | 34747 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38395 | 6008968.42681544 | 2102467.18370323 | 37.7534807427404 | -122.411888091902 | (37.7534807427404, -122.411888091902) | 2 | 4 | 7 | 28859 | 19 | ||
| 92806 | 69223 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33275 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.412842385916 | (37.7500562758063, -122.412842385916) | 2 | 4 | 7 | 28859 | 19 | ||
| 94309 | 69219 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33271 | 6008659.77445957 | 2101360.31284296 | 37.7504242029934 | -122.412877230419 | (37.7504242029934, -122.412877230419) | 2 | 4 | 7 | 28859 | 19 | ||
| 96557 | 62524 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 342 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38698 | 6002273.08197673 | 2109652.09551148 | 37.7728308633198 | -122.435555961743 | (37.7728308633198, -122.435555961743) | 15 | 5 | 11 | 29492 | 9 | ||
| 102399 | 62468 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | Permit Number 767707 | 5997942.58905548 | 2109236.69156954 | 37.7714433619175 | -122.450505611482 | (37.7714433619175, -122.450505611482) | 15 | 5 | 11 | 29492 | 9 | |||
| 105362 | 34074 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2055 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | 8 | 4 | 7 | 28859 | 19 | ||
| 109140 | 102653 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | ||||
| 109731 | 45152 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2001 12:00:00 AM | Permit Number 44005 | 6009316.84366878 | 2099994.11121489 | 37.7467097764312 | -122.410508567135 | (37.7467097764312, -122.410508567135) | 2 | 7 | 7 | 28859 | 2 | ||
| 109935 | 48959 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
| 111491 | 95562 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496 | 2099787 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | 2 | 7 | 5 | 63 | 22 | |
| 112761 | 69222 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2001 12:00:00 AM | 3x3 | Permit Number 33274 | 6008665.27491562 | 2101259.70225891 | 37.7501482575919 | -122.412851097008 | (37.7501482575919, -122.412851097008) | 2 | 4 | 7 | 28859 | 19 | |
| 116552 | 65468 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | 9 | 8 | 6 | 28861 | 24 | ||
| 118274 | 85304 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857 | 2109314 | 37.7717079252645 | -122.447348195836 | (37.7717079252645, -122.447348195836) | 15 | 5 | 11 | 29492 | 9 | |||
| 122480 | 38842 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | 15 | 5 | 11 | 29492 | 10 | ||||
| 125083 | 34039 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | 8 | 4 | 7 | 28859 | 19 | ||
| 129612 | 46907 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | 1 | 5 | 11 | 56 | 12 | ||
| 131118 | 59938 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.7740615827199 | -122.445666937047 | (37.7740615827199, -122.445666937047) | 15 | 5 | 11 | 29492 | 16 | ||
| 131125 | 98179 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 50-60 Camp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005725 | 2106380 | 37.7640419231114 | -122.423382710222 | (37.7640419231114, -122.423382710222) | 8 | 4 | 5 | 28859 | 19 | ||||
| 132169 | 65670 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.447403560759 | (37.7343541747365, -122.447403560759) | 9 | 7 | 4 | 59 | 40 | ||
| 132497 | 95583 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 320 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767373 | 6004245 | 2103375 | 37.7557072655698 | -122.428287412943 | (37.7557072655698, -122.428287412943) | 2 | 4 | 5 | 28862 | 22 | |
| 134411 | 66548 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3444 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29730 | 6005443.81991983 | 2103160.76453772 | 37.7551867854403 | -122.424126272898 | (37.7551867854403, -122.424126272898) | 2 | 4 | 5 | 28859 | 19 | ||
| 139962 | 67087 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30488 | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||
| 140391 | 69220 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 3x3 | Permit Number 33272 | 6008663.44143065 | 2101293.23911329 | 37.7502402393754 | -122.412859808121 | (37.7502402393754, -122.412859808121) | 2 | 4 | 7 | 28859 | 19 | |
| 141317 | 60696 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2839 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20342 | 6009224.45070504 | 2103317.03242809 | 37.7558285965659 | -122.411062726793 | (37.7558285965659, -122.411062726793) | 2 | 4 | 7 | 28859 | 19 | ||
| 141655 | 52023 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2005 12:00:00 AM | Permit Number 48238 | 6006866.55802505 | 2096801.82623419 | 37.7378068034281 | -122.418755072853 | (37.7378068034281, -122.418755072853) | 2 | 7 | 7 | 28859 | 2 | ||
| 151060 | 59771 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30471 | 6006914.85070557 | 2096794.9528113 | 37.7377906494843 | -122.41858761398 | (37.7377906494843, -122.41858761398) | 2 | 7 | 7 | 28859 | 2 | ||
| 151974 | 36066 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 152965 | 59772 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 131 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1981 12:00:00 AM | Permit Number 19217 | 6007221.04974766 | 2096803.89603525 | 37.7378324395755 | -122.417529566585 | (37.7378324395755, -122.417529566585) | 2 | 7 | 7 | 28859 | 2 | ||
| 155414 | 35576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38944 | 6005785.83921356 | 2104003.6408016 | 37.7575204324701 | -122.42300337284 | (37.7575204324701, -122.42300337284) | 2 | 4 | 5 | 28859 | 19 | ||
| 157154 | 57311 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 50- 60 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | Permit Number 16134 | 6005724.56470965 | 2106391.56239992 | 37.764073646158 | -122.423385037786 | (37.764073646158, -122.423385037786) | 8 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );