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 | ||||||||
46626 | 46626 | 59336 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 775 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31976 | 5982585.1174 | 2110516.14744 | 37.774065420371706 | -122.50372176444999 | (37.7740654203717, -122.50372176445) | ||
164001 | 164001 | 56674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1371 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5984603.4838 | 2105851.1543 | 37.761375137437604 | -122.496395703433 | (37.7613751374376, -122.496395703433) | ||||
112719 | 112719 | 21073 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
115970 | 115970 | 21074 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
140920 | 140920 | 21075 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
189129 | 189129 | 182301 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2537 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986893.9274 | 2105029.3143 | 37.7592525025823 | -122.488413720954 | (37.7592525025823, -122.488413720954) | |||
56115 | 56115 | 182302 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2535 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986906.12 | 2105029.3143 | 37.7592532139832 | -122.488371553614 | (37.7592532139832, -122.488371553614) | |||
40247 | 40247 | 182303 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2533 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986913.9581 | 2105029.3143 | 37.7592536713044 | -122.488344446038 | (37.7592536713044, -122.488344446038) | |||
153718 | 153718 | 69330 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2119 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 4 | Permit Number 33413 | 5987433.342 | 2102324.8030000003 | 37.751858106926704 | -122.486349632544 | (37.7518581069267, -122.486349632544) | ||
171446 | 171446 | 45471 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44250 | 5987593.6437099995 | 2110560.6661900003 | 37.7744808674341 | -122.48639989849501 | (37.7744808674341, -122.486399898495) | |
127535 | 127535 | 12849 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2412 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 12 | 3X3 | 5987958.93678 | 2114680.36581 | 37.7858136848869 | -122.48543867329501 | (37.7858136848869, -122.485438673295) | ||
180131 | 180131 | 43801 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 525 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43431 | 5988746.62136 | 2111728.0872299997 | 37.777753417998206 | -122.48249713450899 | (37.7777534179982, -122.482497134509) | |
176780 | 176780 | 67047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2532 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1992 12:00:00 AM | 8 | Permit Number 30427 | 5988951.1175 | 2098070.1197 | 37.7402642171623 | -122.480789555517 | (37.7402642171623, -122.480789555517) | ||
162278 | 162278 | 183548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2590 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989271.0961 | 2097748.8175 | 37.7394005980364 | -122.479659706735 | (37.7394005980364, -122.479659706735) | |||
51194 | 51194 | 99324 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5989313.9402 | 2097680.7708 | 37.739216248209 | -122.479506595172 | (37.739216248209, -122.479506595172) | |||
173203 | 173203 | 99323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5989330.3766 | 2097681.8666 | 37.73922021170971 | -122.479449846275 | (37.7392202117097, -122.479449846275) | |||
165203 | 165203 | 99322 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5989346.812999999 | 2097682.9624 | 37.739224175183 | -122.479393097373 | (37.739224175183, -122.479393097373) | |||
59050 | 59050 | 99321 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989362.5919 | 2097683.4007 | 37.7392262951159 | -122.47933857369101 | (37.7392262951159, -122.479338573691) | |||
166570 | 166570 | 99320 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5989380.1241 | 2097683.1815 | 37.7392267115304 | -122.479277939862 | (37.7392267115304, -122.479277939862) | |||
133189 | 133189 | 120726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 450 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5989392.84856 | 2112260.68272 | 37.779253349203294 | -122.480300629667 | (37.7792533492033, -122.480300629667) | |||
134764 | 134764 | 99319 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989394.1498 | 2097683.839 | 37.73922933145371 | -122.479229493917 | (37.7392293314537, -122.479229493917) | |||
91835 | 91835 | 99325 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150@23rd Ave Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x6 | 5989403.0 | 2097682.0 | 37.73922479603689 | -122.479198759749 | (37.7392247960369, -122.479198759749) | ||||
76802 | 76802 | 99318 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989408.3581 | 2097684.4234 | 37.7392317612483 | -122.47918041128 | (37.7392317612483, -122.47918041128) | |||
11928 | 11928 | 105246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2439 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x6 | 5989501.8448 | 2098751.2622 | 37.7421664525595 | -122.478935190185 | (37.7421664525595, -122.478935190185) | |||
53171 | 53171 | 85317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | ||||
112317 | 112317 | 85318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49596 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | |||
168505 | 168505 | 46656 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 6 | Permit Number 44787 | 5989986.8778099995 | 2113120.4528799998 | 37.781648539642404 | -122.47830854187 | (37.7816485396424, -122.47830854187) | |
147926 | 147926 | 121858 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 682 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990066.45835 | 2110748.50952 | 37.7751404594463 | -122.477859785758 | (37.7751404594463, -122.477859785758) | |||
62476 | 62476 | 43761 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 364 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43396 | 5990612.6596 | 2112954.63099 | 37.781229546008895 | -122.476131541236 | (37.7812295460089, -122.476131541236) | |
134959 | 134959 | 68463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 8 | Permit Number 32325 | 5991519.12103 | 2113131.34732 | 37.781767281646204 | -122.473008553548 | (37.7817672816462, -122.473008553548) | |
121033 | 121033 | 38222 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40349 | 5991678.28674141 | 2099849.72262287 | 37.745308688082396 | -122.471489828106 | (37.7453086880824, -122.471489828106) | |||
153199 | 153199 | 208100 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991679.25346 | 2099828.9819099996 | 37.7452517953444 | -122.471484974349 | (37.7452517953444, -122.471484974349) | |||
26594 | 26594 | 208099 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991681.99819 | 2099835.94672 | 37.745271077706704 | -122.471475991035 | (37.7452710777067, -122.471475991035) | |||
186783 | 186783 | 208098 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991684.149119999 | 2099849.94635 | 37.74530964152321 | -122.471469573465 | (37.7453096415232, -122.471469573465) | |||
111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
142779 | 142779 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
122400 | 122400 | 38006 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40217 | 5992035.60667724 | 2098055.00516972 | 37.740401516958705 | -122.47012362496099 | (37.7404015169587, -122.470123624961) | ||
153373 | 153373 | 208112 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992037.32657 | 2098038.7861599997 | 37.7403570831075 | -122.47011649758801 | (37.7403570831075, -122.470116497588) | |||
60879 | 60879 | 208111 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2559 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992039.89052 | 2098021.8056099997 | 37.740310607054894 | -122.470106396399 | (37.7403106070549, -122.470106396399) | |||
167306 | 167306 | 208019 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992092.96115 | 2106864.9565 | 37.7645946702215 | -122.470566813326 | (37.7645946702215, -122.470566813326) | |||
128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
60910 | 60910 | 97503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768347 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||
96178 | 96178 | 97500 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
102146 | 102146 | 97502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
111067 | 111067 | 97499 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
127577 | 127577 | 97501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
180850 | 180850 | 208057 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992245.259459999 | 2101079.6682 | 37.7487185865149 | -122.46961886943599 | (37.7487185865149, -122.469618869436) | |||
71209 | 71209 | 208056 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992245.83027 | 2101094.43022 | 37.7487591522095 | -122.46961797009399 | (37.7487591522095, -122.469617970094) | |||
67413 | 67413 | 208058 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992246.20583 | 2101062.80127 | 37.7486723289665 | -122.469614369217 | (37.7486723289665, -122.469614369217) | |||
68119 | 68119 | 208059 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992246.63721 | 2101046.2039400004 | 37.7486267819054 | -122.469611669441 | (37.7486267819054, -122.469611669441) | |||
29002 | 29002 | 208061 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992248.52602 | 2101024.65147 | 37.748567713538996 | -122.46960356926901 | (37.748567713539, -122.469603569269) | |||
148810 | 148810 | 208060 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992248.76597 | 2101036.0508 | 37.748599027031496 | -122.46960356926 | (37.7485990270315, -122.46960356926) | |||
188394 | 188394 | 208043 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992271.8581 | 2102134.57412 | 37.751616623007 | -122.469603676282 | (37.751616623007, -122.469603676282) | |||
84595 | 84595 | 102523 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 3X3 | Permit Number 769544 | 5992300.8 | 2100554.8 | 37.7472806432819 | -122.46938861272601 | (37.7472806432819, -122.469388612726) | ||
74489 | 74489 | 208101 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2357 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992303.56626 | 2099363.27465 | 37.7440091795707 | -122.469292334575 | (37.7440091795707, -122.469292334575) | |||
152821 | 152821 | 208062 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5992310.81526 | 2100558.61038 | 37.7472916843786 | -122.469354258319 | (37.7472916843786, -122.469354258319) | |||
171296 | 171296 | 52472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1038@ 12th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | Permit Number 48583 | 5992323.330569999 | 2111390.84025 | 37.777034850900606 | -122.470099615521 | (37.7770348509006, -122.470099615521) | |
72962 | 72962 | 208050 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2338 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992343.816769999 | 2099531.60984 | 37.7444737108967 | -122.46916540785601 | (37.7444737108967, -122.469165407856) | |||
158220 | 158220 | 208049 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992344.1762 | 2099503.1223 | 37.744395512154796 | -122.46916209207899 | (37.7443955121548, -122.469162092079) | |||
25465 | 25465 | 208048 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2344 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992344.38135 | 2099463.27392 | 37.74428611053071 | -122.469158483081 | (37.7442861105307, -122.469158483081) | |||
73671 | 73671 | 208047 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2356 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992346.98246 | 2099405.01198 | 37.744126288412396 | -122.46914524958 | (37.7441262884124, -122.46914524958) | |||
69538 | 69538 | 37593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 643 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40021 | 5992524.5893 | 2111069.01654 | 37.776162842853296 | -122.469379974251 | (37.7761628428533, -122.469379974251) | |
45512 | 45512 | 59134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | 7x7 | Permit Number 18439 | 5992554.02664 | 2110259.06028 | 37.7739406226936 | -122.469219178519 | (37.7739406226936, -122.469219178519) | |
72595 | 72595 | 208109 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992602.58698 | 2099633.7724 | 37.7447691723617 | -122.468278072002 | (37.7447691723617, -122.468278072002) | |||
158225 | 158225 | 208108 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992604.0801800005 | 2099624.3028 | 37.7447432574969 | -122.468272220082 | (37.7447432574969, -122.468272220082) | |||
58305 | 58305 | 208107 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992604.896919999 | 2099614.84743 | 37.7447173426335 | -122.468268708247 | (37.7447173426335, -122.468268708247) | |||
76625 | 76625 | 208106 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2367 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992612.0223 | 2099358.1816 | 37.744013015182 | -122.46822540229999 | (37.744013015182, -122.4682254023) | |||
180818 | 180818 | 208044 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992692.13842 | 2098948.0132400002 | 37.7428914239144 | -122.467918553594 | (37.7428914239144, -122.467918553594) | |||
172894 | 172894 | 208045 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992699.77164 | 2098959.9602799998 | 37.7429246682415 | -122.46789302904399 | (37.7429246682415, -122.467893029044) | |||
76968 | 76968 | 208097 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1578 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992786.16766 | 2104723.32687 | 37.7587543775304 | -122.468013427586 | (37.7587543775304, -122.468013427586) |
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");