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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186967 | 186967 | 246066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999949.17 | 2108444.1555 | 37.7693819003429 | -122.443507828871 | (37.7693819003429, -122.443507828871) | |||
| 24517 | 24517 | 129740 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012353.73266 | 2119674.7684299997 | 37.8009181627066 | -122.401390109871 | (37.8009181627066, -122.401390109871) | |||
| 27635 | 27635 | 129744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012609.98453 | 2119710.6419 | 37.801030956563395 | -122.400505885653 | (37.8010309565634, -122.400505885653) | |||
| 28393 | 28393 | 129742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012372.32254 | 2119675.23965 | 37.8009204937473 | -122.401325813756 | (37.8009204937473, -122.401325813756) | |||
| 71250 | 71250 | 129745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012618.68817 | 2119711.1441 | 37.8010328208639 | -122.400475802435 | (37.8010328208639, -122.400475802435) | |||
| 171510 | 171510 | 129743 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012600.30896 | 2119709.91151 | 37.8010284114971 | -122.400539316148 | (37.8010284114971, -122.400539316148) | |||
| 177163 | 177163 | 129741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012363.448469999 | 2119674.7409900003 | 37.80091862944111 | -122.40135648692 | (37.8009186294411, -122.40135648692) | |||
| 34090 | 34090 | 200282 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.10078 | 2097031.29718 | 37.7390049434275 | -122.383564705169 | (37.7390049434275, -122.383564705169) | |||
| 153586 | 153586 | 200280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017039.14807 | 2097019.94402 | 37.7389732198275 | -122.383598327225 | (37.7389732198275, -122.383598327225) | |||
| 173001 | 173001 | 200279 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.91134 | 2097012.03507 | 37.7389520983484 | -122.383560561973 | (37.7389520983484, -122.383560561973) | |||
| 175173 | 175173 | 200284 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017057.48354 | 2097042.3029900002 | 37.739035626492296 | -122.38353648713199 | (37.7390356264923, -122.383536487132) | |||
| 177285 | 177285 | 200285 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017066.92688 | 2097055.31943 | 37.739071888953795 | -122.38350474196699 | (37.7390718889538, -122.383504741967) | |||
| 181542 | 181542 | 200281 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017058.90214 | 2097021.55085 | 37.7389787236965 | -122.38353013790702 | (37.7389787236965, -122.383530137907) | |||
| 187429 | 187429 | 200283 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017069.557019999 | 2097033.93305 | 37.7390133116224 | -122.383494159632 | (37.7390133116224, -122.383494159632) | |||
| 48143 | 48143 | 208054 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 San Fernando Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992102.39322 | 2096463.5019599998 | 37.736035512423 | -122.46977686683 | (37.736035512423, -122.46977686683) | |||
| 165952 | 165952 | 245931 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Beulah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997879.1818 | 2107870.9 | 37.767689618362496 | -122.450626454426 | (37.7676896183625, -122.450626454426) | |||
| 52524 | 52524 | 191128 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012078.814590001 | 2104152.3276 | 37.758281787386 | -122.401250047675 | (37.758281787386, -122.401250047675) | |||
| 16387 | 16387 | 111703 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1006 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x12 | 6015488.19364 | 2104440.58048 | 37.7592628883951 | -122.389478950919 | (37.7592628883951, -122.389478950919) | |||
| 97490 | 97490 | 100180 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997991.0 | 2108152.0 | 37.768467847026294 | -122.450259955793 | (37.7684678470263, -122.450259955793) | ||||
| 50299 | 50299 | 227796 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997239.9919300005 | 2106930.72577 | 37.7650715330364 | -122.452769455742 | (37.7650715330364, -122.452769455742) | |||
| 158395 | 158395 | 227795 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5997235.15112 | 2106961.34501 | 37.7651553282738 | -122.452788408983 | (37.7651553282738, -122.452788408983) | |||
| 185632 | 185632 | 227794 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997230.41248 | 2106977.41048 | 37.7651991684211 | -122.45280595835399 | (37.7651991684211, -122.452805958354) | |||
| 169034 | 169034 | 228001 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1027 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998100.634380001 | 2106690.05164 | 37.764459981474204 | -122.44977537345899 | (37.7644599814742, -122.449775373459) | |||
| 146691 | 146691 | 228002 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1033 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998104.33903 | 2106671.65488 | 37.764409680579 | -122.449761234305 | (37.764409680579, -122.449761234305) | |||
| 135564 | 135564 | 228004 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1039 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998111.03938 | 2106633.51885 | 37.7643053520281 | -122.449735311348 | (37.7643053520281, -122.449735311348) | |||
| 159772 | 159772 | 228003 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1039 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998107.95915 | 2106649.18866 | 37.7643482011369 | -122.44974709425199 | (37.7643482011369, -122.449747094252) | |||
| 185336 | 185336 | 227730 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1044 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997692.15164 | 2106891.22645 | 37.7649889770905 | -122.451202705446 | (37.7649889770905, -122.451202705446) | |||
| 67648 | 67648 | 248339 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 105 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998213.3537 | 2108180.6942 | 37.76855935635471 | -122.4494929252 | (37.7685593563547, -122.4494929252) | |||
| 178240 | 178240 | 228005 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1051 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998115.625990001 | 2106592.03461 | 37.7641917091996 | -122.44971645795401 | (37.7641917091996, -122.449716457954) | |||
| 25393 | 25393 | 228021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1054 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998157.054409999 | 2106607.36365 | 37.7642361689933 | -122.44957427424102 | (37.7642361689933, -122.449574274241) | |||
| 57577 | 57577 | 129724 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007826.23151 | 2119905.33102 | 37.801297582165205 | -122.417073568702 | (37.8012975821652, -122.417073568702) | |||
| 136534 | 136534 | 129723 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007809.591659999 | 2119903.72607 | 37.801292239302796 | -122.417131036286 | (37.8012922393028, -122.417131036286) | |||
| 136861 | 136861 | 129726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007892.05327 | 2119913.90484 | 37.8013248262425 | -122.41684640354299 | (37.8013248262425, -122.416846403543) | |||
| 163183 | 163183 | 129725 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007869.3354400005 | 2119911.2573599997 | 37.801316279082705 | -122.416924829814 | (37.8013162790827, -122.416924829814) | |||
| 67771 | 67771 | 228006 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1057 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998117.27341 | 2106573.00208 | 37.76413954493321 | -122.449709388403 | (37.7641395449332, -122.449709388403) | |||
| 150442 | 150442 | 248323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 106 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998260.7465 | 2108151.4712 | 37.768481828451705 | -122.449326892475 | (37.7684818284517, -122.449326892475) | |||
| 50223 | 50223 | 191523 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 7ft | 6015501.46651 | 2104207.8933 | 37.7586247150714 | -122.389416796942 | (37.7586247150714, -122.389416796942) | |||
| 73547 | 73547 | 191524 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 7ft | 6015503.99036 | 2104179.13483 | 37.7585458903883 | -122.38940605994499 | (37.7585458903883, -122.389406059945) | |||
| 136710 | 136710 | 191525 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6015505.26646 | 2104138.41993 | 37.758434166722395 | -122.38939880333099 | (37.7584341667224, -122.389398803331) | |||
| 134532 | 134532 | 227811 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1068 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5998996.78199 | 2106266.6439900002 | 37.7633486415415 | -122.44664539098999 | (37.7633486415415, -122.44664539099) | |||
| 35063 | 35063 | 227915 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999880.17425 | 2106931.0988 | 37.765223490583296 | -122.443637771174 | (37.7652234905833, -122.443637771174) | |||
| 36630 | 36630 | 227914 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999872.11976 | 2106925.98957 | 37.7652090025309 | -122.44366526256701 | (37.7652090025309, -122.443665262567) | |||
| 187164 | 187164 | 227916 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999889.55267 | 2106936.18055 | 37.7652379786836 | -122.44360569865299 | (37.7652379786836, -122.443605698653) | |||
| 27930 | 27930 | 129716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006809.35 | 2120459.5660099997 | 37.8027621146536 | -122.42063180021299 | (37.8027621146536, -122.420631800213) | |||
| 28107 | 28107 | 129718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.42050619192699 | (37.8027774273877, -122.420506191927) | |||
| 33165 | 33165 | 129714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006770.61766 | 2120452.09935 | 37.8027394301331 | -122.420765303696 | (37.8027394301331, -122.420765303696) | |||
| 69185 | 69185 | 129717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006827.222569999 | 2120461.26491 | 37.8027677866551 | -122.420570072569 | (37.8027677866551, -122.420570072569) | |||
| 86026 | 86026 | 129719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006860.09044 | 2120465.9602200002 | 37.802782531050795 | -122.420456666246 | (37.8027825310508, -122.420456666246) | |||
| 153938 | 153938 | 129713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006753.58301 | 2120450.7966299998 | 37.802734893067495 | -122.420824159811 | (37.8027348930675, -122.420824159811) | |||
| 161282 | 161282 | 129715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006786.6709199995 | 2120456.10735 | 37.8027513398688 | -122.420710035851 | (37.8027513398688, -122.420710035851) | |||
| 178469 | 178469 | 129721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006892.13335 | 2120470.8795 | 37.8027978438157 | -122.420346130572 | (37.8027978438157, -122.420346130572) | |||
| 178527 | 178527 | 129720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006876.11825 | 2120468.72973 | 37.802791038628705 | -122.42040139843 | (37.8027910386287, -122.42040139843) | |||
| 176226 | 176226 | 191522 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1089 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015567.39851 | 2104058.65501 | 37.7582185938385 | -122.389178351619 | (37.7582185938385, -122.389178351619) | |||
| 58341 | 58341 | 228009 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Alma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998119.85145 | 2106206.2133 | 37.7631325830122 | -122.44967403874399 | (37.7631325830122, -122.449674038744) | |||
| 46761 | 46761 | 191521 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1099 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015569.33397 | 2104003.49166 | 37.7580672343431 | -122.38916780615801 | (37.7580672343431, -122.389167806158) | |||
| 184303 | 184303 | 191520 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1099 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015569.63455 | 2103986.90153 | 37.7580216980478 | -122.389165608225 | (37.7580216980478, -122.389165608225) | |||
| 54983 | 54983 | 227892 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003807.3589 | 2108238.1096 | 37.7690354253758 | -122.43014783075199 | (37.7690354253758, -122.430147830752) | |||
| 164582 | 164582 | 227820 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007044.27544 | 2099680.4476 | 37.745720860129104 | -122.41834466148799 | (37.7457208601291, -122.418344661488) | |||
| 75949 | 75949 | 208138 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Santa Rita Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993885.92048 | 2100911.41075 | 37.748351281781 | -122.463933307785 | (37.748351281781, -122.463933307785) | |||
| 152889 | 152889 | 248322 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998263.1691 | 2108132.3929 | 37.7684295828689 | -122.449317138225 | (37.7684295828689, -122.449317138225) | |||
| 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) | |||
| 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) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 52418 | 52418 | 177149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991352.53535 | 2088761.3617099999 | 37.714843978538205 | -122.47180825186301 | (37.7148439785382, -122.471808251863) | |||
| 162256 | 162256 | 177150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991357.8727400005 | 2088731.5467 | 37.7147624226096 | -122.471787632218 | (37.7147624226096, -122.471787632218) | |||
| 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) | |||
| 63311 | 63311 | 228020 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1112 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998182.13932 | 2106442.54702 | 37.7637850591596 | -122.449475636595 | (37.7637850591596, -122.449475636595) | |||
| 177956 | 177956 | 228018 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1118 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998188.96847 | 2106410.92165 | 37.7636986145324 | -122.44944973792101 | (37.7636986145324, -122.449449737921) | |||
| 183153 | 183153 | 228019 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1118 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998187.56387 | 2106423.37848 | 37.7637327374956 | -122.44945549358299 | (37.7637327374956, -122.449455493583) | |||
| 68517 | 68517 | 227725 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1125 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998884.79342 | 2105911.12846 | 37.7623660872596 | -122.447007136094 | (37.7623660872596, -122.447007136094) | |||
| 166783 | 166783 | 191517 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1129 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015588.78153 | 2103719.02877 | 37.7572872379344 | -122.389080686136 | (37.7572872379344, -122.389080686136) | |||
| 63354 | 63354 | 228017 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998195.21077 | 2106351.13938 | 37.7635348245821 | -122.44942384014601 | (37.7635348245821, -122.449423840146) | |||
| 43056 | 43056 | 191129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012185.62091 | 2103105.89638 | 37.7554144753107 | -122.400807145928 | (37.7554144753107, -122.400807145928) | |||
| 142405 | 142405 | 121587 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6012170.0 | 2103110.0 | 37.7554248716487 | -122.400861456416 | (37.7554248716487, -122.400861456416) | ||
| 56359 | 56359 | 228007 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1139 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998149.3046699995 | 2106328.0712900003 | 37.763468859326295 | -122.44958095170901 | (37.7634688593263, -122.449580951709) | |||
| 131118 | 131118 | 227877 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Corwin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000737.7441300005 | 2104105.27937 | 37.7575133580643 | -122.440468962298 | (37.7575133580643, -122.440468962298) | |||
| 72800 | 72800 | 208075 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998390.034080001 | 2098450.75063 | 37.7418534470942 | -122.448181102087 | (37.7418534470942, -122.448181102087) | |||
| 154927 | 154927 | 227726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1143 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998891.01652 | 2105852.59143 | 37.7622057147555 | -122.44698140018801 | (37.7622057147555, -122.446981400188) | |||
| 54555 | 54555 | 227728 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998894.21082 | 2105816.78299 | 37.762107576228296 | -122.446967775438 | (37.7621075762283, -122.446967775438) | |||
| 131392 | 131392 | 227727 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998891.41091 | 2105829.4817 | 37.7621422837475 | -122.446978373068 | (37.7621422837475, -122.446978373068) | |||
| 42186 | 42186 | 228008 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998158.99229 | 2106286.14081 | 37.7633542830094 | -122.449544423956 | (37.7633542830094, -122.449544423956) | |||
| 42724 | 42724 | 227852 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004384.0702 | 2101006.82199 | 37.749212670433295 | -122.427637746503 | (37.7492126704333, -122.427637746503) | |||
| 62922 | 62922 | 227853 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004399.30217 | 2101007.45313 | 37.749215264974396 | -122.42758511905399 | (37.7492152649744, -122.427585119054) | |||
| 32695 | 32695 | 191536 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014495.86116 | 2103903.97635 | 37.7577344195295 | -122.39287340149099 | (37.7577344195295, -122.392873401491) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 155762 | 155762 | 191537 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6014473.63415 | 2103902.4166 | 37.7577289021798 | -122.392950163136 | (37.7577289021798, -122.392950163136) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 53154 | 53154 | 227957 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 116 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006644.85008 | 2105377.83742 | 37.7613420921909 | -122.42013008553002 | (37.7613420921909, -122.42013008553) | |||
| 136755 | 136755 | 227997 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1183 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997362.1332 | 2106037.84673 | 37.7626269122233 | -122.452282568209 | (37.7626269122233, -122.452282568209) | |||
| 63959 | 63959 | 227998 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997369.80314 | 2106003.7248299997 | 37.7625336615227 | -122.45225357855101 | (37.7625336615227, -122.452253578551) | |||
| 113028 | 113028 | 110257 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 116771 | 116771 | 110256 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 142550 | 142550 | 110258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) |
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");