Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5701 | 5701 | 35451 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
6310 | 6310 | 35452 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
6803 | 6803 | 19590 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7231 | 7231 | 19588 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7407 | 7407 | 19591 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7488 | 7488 | 35443 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
7802 | 7802 | 35460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
8146 | 8146 | 35450 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
8339 | 8339 | 37971 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40201 | ||||||||
8797 | 8797 | 35455 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9539 | 9539 | 35456 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9554 | 9554 | 35448 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
9566 | 9566 | 95785 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | ||||||
9594 | 9594 | 35445 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10262 | 10262 | 35446 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10483 | 10483 | 35442 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
10753 | 10753 | 35454 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
11139 | 11139 | 35047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
11629 | 11629 | 35449 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
12085 | 12085 | 35458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
12173 | 12173 | 37972 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40202 | ||||||||
12970 | 12970 | 19589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
14341 | 14341 | 35444 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
14595 | 14595 | 35457 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
14838 | 14838 | 35048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
15544 | 15544 | 37973 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 630 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40203 | ||||||||
16105 | 16105 | 35453 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
16221 | 16221 | 35459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
17025 | 17025 | 35447 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
77005 | 77005 | 69406 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 791 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33510 | 6002424.30927 | 2087088.10255 | 37.7108839820803 | -122.43342011837 | (37.7108839820803, -122.43342011837) | |
133317 | 133317 | 177153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 701 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002643.53653 | 2087345.7216599998 | 37.711603783270704 | -122.43268080909401 | (37.7116037832707, -122.432680809094) | |||
167014 | 167014 | 177146 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 183 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010243.9758 | 2087974.1482400002 | 37.7137574284457 | -122.406455788622 | (37.7137574284457, -122.406455788622) | |||
64816 | 64816 | 177147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 184 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010274.23891 | 2088006.9688799998 | 37.71384924022011 | -122.406353498838 | (37.7138492402201, -122.406353498838) | |||
41501 | 41501 | 109608 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | |||
117105 | 117105 | 109646 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 CURTIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6000484.3 | 2088475.7 | 37.7145837584364 | -122.44022466861401 | (37.7145837584364, -122.440224668614) | |||
179602 | 179602 | 208091 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 247 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994538.89775 | 2088695.72634 | 37.714847610008 | -122.46079017812599 | (37.714847610008, -122.460790178126) | |||
189027 | 189027 | 177145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 646 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001109.079969999 | 2090060.7156599998 | 37.718971408083796 | -122.438178657041 | (37.7189714080838, -122.438178657041) | |||
44961 | 44961 | 208090 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994177.92287 | 2090747.0249299998 | 37.720459209606396 | -122.46218652760099 | (37.7204592096064, -122.462186527601) | |||
123544 | 123544 | 95666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 800 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
45277 | 45277 | 208077 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 338 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995744.67706 | 2091237.28528 | 37.7218954350055 | -122.456806235434 | (37.7218954350055, -122.456806235434) | |||
169032 | 169032 | 66942 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 4 | Permit Number 30268 | 6007235.19224 | 2091579.2151400002 | 37.7234873977973 | -122.41711056590201 | (37.7234873977973, -122.417110565902) | ||
141526 | 141526 | 66940 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 633 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 8 | Permit Number 30266 | 6007221.66075 | 2091629.66903 | 37.7236251721365 | -122.417160915365 | (37.7236251721365, -122.417160915365) | ||
135648 | 135648 | 208078 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994204.15445 | 2092252.12785 | 37.7245933696677 | -122.462204953795 | (37.7245933696677, -122.462204953795) | |||
129182 | 129182 | 62460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1985 12:00:00 AM | Permit Number 22628 | 5994209.59395504 | 2092281.24653849 | 37.724673635737 | -122.46218826108101 | (37.724673635737, -122.462188261081) | |||
172116 | 172116 | 208079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 370 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994204.7092699995 | 2092293.8325900002 | 37.7247079127335 | -122.462206059069 | (37.7247079127335, -122.462206059069) | |||
24703 | 24703 | 208140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994042.19484 | 2092647.64079 | 37.7256700254358 | -122.462793502527 | (37.7256700254358, -122.462793502527) | |||
31262 | 31262 | 177151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 183 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004046.6041 | 2092611.27045 | 37.7261413007669 | -122.428206457066 | (37.7261413007669, -122.428206457066) | |||
137384 | 137384 | 208053 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 111 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5993326.69721 | 2093754.23227 | 37.7286672184966 | -122.465347248004 | (37.7286672184966, -122.465347248004) | |||
67524 | 67524 | 208159 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999853.60531 | 2093798.1643400001 | 37.7291620992495 | -122.442786557466 | (37.7291620992495, -122.442786557466) | |||
82405 | 82405 | 92905 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
89942 | 89942 | 92903 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
109586 | 109586 | 92904 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
119042 | 119042 | 92906 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
120300 | 120300 | 92902 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
55067 | 55067 | 208055 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 920 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5994534.77621 | 2093970.7327700001 | 37.729331273397705 | -122.46118656331998 | (37.7293312733977, -122.46118656332) | |||
12206 | 12206 | 65603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 131 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 15 | 3x3 | Permit Number 28506 | 6004245.84033 | 2093781.6134799998 | 37.7293660735617 | -122.427601053271 | (37.7293660735617, -122.427601053271) |
75826 | 75826 | 208118 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 907 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994500.10104 | 2094002.40377 | 37.7294162386642 | -122.461308732617 | (37.7294162386642, -122.461308732617) | |||
166578 | 166578 | 208119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 915 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994530.86611 | 2094005.87306 | 37.7294275350513 | -122.461202626994 | (37.7294275350513, -122.461202626994) | |||
173727 | 173727 | 208120 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 925 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994563.96243 | 2094007.92247 | 37.7294350668528 | -122.461088359166 | (37.7294350668528, -122.461088359166) | |||
73080 | 73080 | 208074 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994748.8803900005 | 2095031.81828 | 37.732257074696705 | -122.460523248557 | (37.7322570746967, -122.460523248557) | |||
58750 | 58750 | 208151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001394.62924 | 2094896.4943 | 37.7322655930748 | -122.43753774257799 | (37.7322655930748, -122.437537742578) | |||
134696 | 134696 | 208073 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5994756.9312 | 2095079.7197900002 | 37.732389063688395 | -122.46049888501999 | (37.7323890636884, -122.46049888502) | |||
97080 | 97080 | 46078 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44459 | 6016168.14280668 | 2094664.01192279 | 37.7324561236274 | -122.38644566841499 | (37.7324561236274, -122.386445668415) | |||
135110 | 135110 | 208051 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992912.8595 | 2095175.00787 | 37.7325444413573 | -122.466881141568 | (37.7325444413573, -122.466881141568) | |||
92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
179943 | 179943 | 208052 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992910.68234 | 2095197.7097 | 37.732606649283106 | -122.466890318243 | (37.7326066492831, -122.466890318243) | |||
135962 | 135962 | 208148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6001401.2605 | 2095043.16775 | 37.7326687015796 | -122.43752531665899 | (37.7326687015796, -122.437525316659) | |||
159648 | 159648 | 208147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 213 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001401.19821 | 2095102.87221 | 37.7328326327156 | -122.437529806065 | (37.7328326327156, -122.437529806065) | |||
88085 | 88085 | 35688 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38992 | 5994858.93773428 | 2095456.23739151 | 37.7334287567384 | -122.460173495672 | (37.7334287567384, -122.460173495672) | |||
65030 | 65030 | 54536 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 5 | Permit Number 10331 | 6009931.29054 | 2095213.10874 | 37.7336166059206 | -122.408046748666 | (37.7336166059206, -122.408046748666) | ||
37582 | 37582 | 208152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80 Nordhoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000435.90571 | 2095588.3603299998 | 37.7341107411125 | -122.44090187344999 | (37.7341107411125, -122.44090187345) | |||
25894 | 25894 | 227929 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3110 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002869.05371 | 2095746.24255 | 37.7346825264594 | -122.432500998617 | (37.7346825264594, -122.432500998617) | |||
68130 | 68130 | 227745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006858.63803 | 2095797.2986700002 | 37.7350481467491 | -122.418711238627 | (37.7350481467491, -122.418711238627) | |||
39989 | 39989 | 227790 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 127 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003497.77442 | 2096110.61078 | 37.735718631796395 | -122.430353286268 | (37.7357186317964, -122.430353286268) | |||
71904 | 71904 | 227791 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 125 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003492.804819999 | 2096117.76895 | 37.7357380050008 | -122.430370978657 | (37.7357380050008, -122.430370978657) | |||
184300 | 184300 | 227789 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003244.21071 | 2096170.02845 | 37.7358674129555 | -122.43123419382201 | (37.7358674129555, -122.431234193822) | |||
93536 | 93536 | 119890 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | ||||
167028 | 167028 | 227928 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 27 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002674.88554 | 2096258.78019 | 37.736078824679105 | -122.433208913461 | (37.7360788246791, -122.433208913461) | |||
62687 | 62687 | 227747 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 331 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6006987.22929 | 2096307.4498700001 | 37.7364561487303 | -122.41830281065201 | (37.7364561487303, -122.418302810652) | |||
130051 | 130051 | 227930 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 60 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002467.73938 | 2096558.4933900002 | 37.7368900149663 | -122.433946517617 | (37.7368900149663, -122.433946517617) | |||
66497 | 66497 | 227925 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001796.41757 | 2096593.1915099998 | 37.736947167771795 | -122.436270052841 | (37.7369471677718, -122.436270052841) | |||
144524 | 144524 | 84799 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49306 | 6003755.0 | 2096568.0 | 37.7369890856012 | -122.42949656641501 | (37.7369890856012, -122.429496566415) | |||
131248 | 131248 | 227926 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001798.975190001 | 2096621.3956 | 37.737024754984 | -122.43626322786301 | (37.737024754984, -122.436263227863) | |||
135828 | 135828 | 227927 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001800.50314 | 2096635.61515 | 37.7370638853866 | -122.436258962388 | (37.7370638853866, -122.436258962388) | |||
31548 | 31548 | 227788 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 394 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003786.51974 | 2096596.76601 | 37.7370698550876 | -122.42938963933099 | (37.7370698550876, -122.429389639331) | |||
31295 | 31295 | 227823 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 316 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006968.36013 | 2096533.98003 | 37.737077088338 | -122.41838410663799 | (37.737077088338, -122.418384106638) | |||
75081 | 75081 | 31663 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 154 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35171 | 6007340.50387 | 2096742.6904 | 37.7376711031279 | -122.41711221886699 | (37.7376711031279, -122.417112218867) | |
49319 | 49319 | 227793 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001793.11618 | 2096866.54712 | 37.7376975512926 | -122.43630102458499 | (37.7376975512926, -122.436301024585) | |||
74327 | 74327 | 38387 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 13 | Permit Number 40446 | 6014272.48503 | 2096672.22783 | 37.7378651543499 | -122.39313992457399 | (37.7378651543499, -122.393139924574) | ||
86844 | 86844 | 53174 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 44@ DIAMOND Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49089 | 6001797.88022558 | 2096945.60904163 | 37.7379149076596 | -122.43629020957701 | (37.7379149076596, -122.436290209577) | ||
173491 | 173491 | 227748 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 95 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009090.18719 | 2096911.9137799998 | 37.738234028369604 | -122.411074651796 | (37.7382340283696, -122.411074651796) | |||
147613 | 147613 | 227749 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 95 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009066.20939 | 2096913.9304400003 | 37.7382382210078 | -122.411157697894 | (37.7382382210078, -122.411157697894) | |||
177357 | 177357 | 227792 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004387.52295 | 2097025.09932 | 37.7382799693533 | -122.427342203202 | (37.7382799693533, -122.427342203202) | |||
116540 | 116540 | 60660 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 17 | Permit Number 20294 | 6004379.78679579 | 2097028.45773942 | 37.738288753282106 | -122.42736919019501 | (37.7382887532821, -122.427369190195) | |
38974 | 38974 | 227825 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008200.416540001 | 2096957.1149400002 | 37.7383082035529 | -122.414154245241 | (37.7383082035529, -122.414154245241) | |||
61896 | 61896 | 227750 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 609 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008693.585969999 | 2096947.7514900002 | 37.7383101820654 | -122.41244843994 | (37.7383101820654, -122.41244843994) | |||
163534 | 163534 | 227824 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008211.90866 | 2096957.8323099997 | 37.73831081878821 | -122.41411456174801 | (37.7383108187882, -122.414114561748) | |||
144610 | 144610 | 70136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Gates St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768270 | 6008220.64737322 | 2096959.77893551 | 37.738316654626395 | -122.41408448515101 | (37.7383166546264, -122.414084485151) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");