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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 327 | 327 | 191528 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.38772046693501 | (37.76689343092, -122.387720466935) | ||
| 1513 | 1513 | 251580 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | ||||
| 2568 | 2568 | 227812 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.44548913263701 | (37.765232827359, -122.445489132637) | |||
| 2858 | 2858 | 110567 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779053 | 6009356.33336 | 2110648.62955 | 37.77596687089571 | -122.411124487731 | (37.7759668708957, -122.411124487731) | ||
| 2906 | 2906 | 140272 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998087.0735 | 2109979.7192 | 37.7734917934815 | -122.450059397698 | (37.7734917934815, -122.450059397698) | ||
| 2907 | 2907 | 140271 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998106.0231 | 2109982.4655 | 37.773500418432704 | -122.44999404654301 | (37.7735004184327, -122.449994046543) | ||
| 2911 | 2911 | 140276 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998008.2541 | 2109969.0086 | 37.773457874403704 | -122.450331271992 | (37.7734578744037, -122.450331271992) | ||
| 2912 | 2912 | 140274 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998046.1533 | 2109973.9519 | 37.7734736163349 | -122.45020053018699 | (37.7734736163349, -122.450200530187) | ||
| 2913 | 2913 | 140273 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998068.9478 | 2109976.9729 | 37.773483215641 | -122.450121898862 | (37.773483215641, -122.450121898862) | ||
| 2922 | 2922 | 140275 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998028.0276 | 2109971.4803 | 37.773465792675 | -122.450263051124 | (37.773465792675, -122.450263051124) | ||
| 2924 | 2924 | 140269 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998144.7463 | 2109987.1343 | 37.7735154534297 | -122.449860434482 | (37.7735154534297, -122.449860434482) | |
| 2926 | 2926 | 140270 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998125.7967 | 2109984.6626 | 37.773507582533604 | -122.44992580546001 | (37.7735075825336, -122.44992580546) | ||
| 5076 | 5076 | 227766 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000997.83471 | 2101277.8848900003 | 37.749764821811 | -122.439366802634 | (37.749764821811, -122.439366802634) | |||
| 5880 | 5880 | 97919 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000669.5517 | 2110132.6697 | 37.7740591934476 | -122.44113722827299 | (37.7740591934476, -122.441137228273) | |||
| 7357 | 7357 | 97916 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000651.9591 | 2110235.6191 | 37.77434086442889 | -122.441205471863 | (37.7743408644289, -122.441205471863) | |||
| 7449 | 7449 | 97915 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000647.534 | 2110270.503 | 37.7744363947481 | -122.441223282456 | (37.7744363947481, -122.441223282456) | |||
| 7913 | 7913 | 97918 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000663.0359 | 2110165.9002 | 37.7741500648743 | -122.44116215214198 | (37.7741500648743, -122.441162152142) | |||
| 9611 | 9611 | 138137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1790 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004447.4756 | 2114919.1759 | 37.7874162214119 | -122.42840996490801 | (37.7874162214119, -122.428409964908) | ||||
| 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) | |||
| 13963 | 13963 | 100835 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 642 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009411.19134 | 2111256.02049 | 37.777637699760795 | -122.41097762931999 | (37.7776376997608, -122.41097762932) | |||
| 14627 | 14627 | 115035 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012851.17431 | 2112502.5973400003 | 37.781252811600794 | -122.39916500906601 | (37.7812528116008, -122.399165009066) | |||
| 15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
| 15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
| 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) | |||
| 16501 | 16501 | 100834 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 642 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009421.99762 | 2111264.1253 | 37.7776605596195 | -122.410940819169 | (37.7776605596195, -122.410940819169) | |||
| 16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
| 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) | |||
| 23897 | 23897 | 248466 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | |||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 24503 | 24503 | 191147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011750.26705 | 2110044.73207 | 37.7744426675252 | -122.40280071719201 | (37.7744426675252, -122.402800717192) | |||
| 24508 | 24508 | 138147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000229.7014 | 2111271.7391 | 37.777161724967996 | -122.442740548891 | (37.777161724968, -122.442740548891) | |||
| 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) | |||
| 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) | |||
| 24770 | 24770 | 227722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 845 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999121.83175 | 2107384.4786900003 | 37.7664250774754 | -122.44629330369601 | (37.7664250774754, -122.446293303696) | |||
| 24970 | 24970 | 227868 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 390 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003558.10771 | 2106024.70188 | 37.7629438234204 | -122.430851992743 | (37.7629438234204, -122.430851992743) | |||
| 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) | |||
| 25442 | 25442 | 227871 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3800 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004234.236219999 | 2104844.24859 | 37.7597408654757 | -122.428429354932 | (37.7597408654757, -122.428429354932) | |||
| 25463 | 25463 | 200261 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 243 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009424.87449 | 2110575.33974 | 37.7757694778185 | -122.410882207661 | (37.7757694778185, -122.410882207661) | |||
| 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) | |||
| 25607 | 25607 | 227742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997482.84112 | 2105527.7140599997 | 37.761233131234896 | -122.451828281975 | (37.7612331312349, -122.451828281975) | |||
| 25626 | 25626 | 129738 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012361.066869999 | 2119691.7640299997 | 37.800965237719204 | -122.40136592529801 | (37.8009652377192, -122.401365925298) | |||
| 25648 | 25648 | 191123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012425.58055 | 2105029.27463 | 37.7607090306229 | -122.400112358502 | (37.7607090306229, -122.400112358502) | |||
| 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) | |||
| 26117 | 26117 | 129704 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000269.523080001 | 2116153.9558 | 37.7905693023891 | -122.442953484235 | (37.7905693023891, -122.442953484235) | |||
| 26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
| 26311 | 26311 | 227767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000143.14107 | 2101645.6357400003 | 37.7507259002966 | -122.442348757612 | (37.7507259002966, -122.442348757612) | |||
| 26456 | 26456 | 246068 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999954.0153 | 2108402.9707 | 37.7692690935594 | -122.443488110434 | (37.7692690935594, -122.443488110434) | |||
| 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) | |||
| 26610 | 26610 | 228013 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1343 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998231.8221 | 2105759.10992 | 37.76191135493279 | -122.449254558076 | (37.7619113549328, -122.449254558076) | |||
| 26638 | 26638 | 200276 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017047.12766 | 2097054.90505 | 37.7390696568319 | -122.383573170476 | (37.7390696568319, -122.383573170476) | |||
| 26653 | 26653 | 208094 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993960.310959999 | 2106767.61522 | 37.7644351970401 | -122.46410113478001 | (37.7644351970401, -122.46410113478) | |||
| 26876 | 26876 | 129739 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012352.16177 | 2119689.7384 | 37.8009591789808 | -122.401396598486 | (37.8009591789808, -122.401396598486) | |||
| 27352 | 27352 | 227958 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3627 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6005410.5124699995 | 2104865.85603 | 37.7598666869207 | -122.42436272946199 | (37.7598666869207, -122.424362729462) | |||
| 27545 | 27545 | 140410 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1325 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003227.817000001 | 2112933.649 | 37.7818953731726 | -122.43248785744301 | (37.7818953731726, -122.432487857443) | |||
| 27561 | 27561 | 227876 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 133 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002056.6842 | 2105072.72951 | 37.7602447556215 | -122.43597676861 | (37.7602447556215, -122.43597676861) | |||
| 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) | |||
| 27768 | 27768 | 208072 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 48 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994750.66862 | 2100768.2505900003 | 37.7480079970652 | -122.460932676625 | (37.7480079970652, -122.460932676625) | |||
| 27892 | 27892 | 208144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.64176 | 2099494.55804 | 37.7445369826924 | -122.459263729149 | (37.7445369826924, -122.459263729149) | |||
| 27923 | 27923 | 208116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994839.35424 | 2100452.13911 | 37.747145137147704 | -122.460603103876 | (37.7471451371477, -122.460603103876) | |||
| 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) | |||
| 28050 | 28050 | 129731 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011929.52293 | 2119129.4911700003 | 37.7993972859062 | -122.402819692899 | (37.7993972859062, -122.402819692899) | |||
| 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) | |||
| 28121 | 28121 | 139774 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003214.319 | 2113328.8398 | 37.782979702448394 | -122.43256279089898 | (37.7829797024484, -122.432562790899) | |||
| 28215 | 28215 | 247280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998954.6357 | 2108912.2879 | 37.7706105046931 | -122.446981556392 | (37.7706105046931, -122.446981556392) | |||
| 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) | |||
| 28612 | 28612 | 129695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000588.35894 | 2116200.69282 | 37.7907158028324 | -122.441853689821 | (37.7907158028324, -122.441853689821) | |||
| 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) | ||
| 28803 | 28803 | 227813 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 168 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999428.13676 | 2107230.4029200003 | 37.7660195129085 | -122.445222775925 | (37.7660195129085, -122.445222775925) | |||
| 28836 | 28836 | 200258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 46 Boardman Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011826.839269999 | 2109963.92529 | 37.7742250657728 | -122.40253015436501 | (37.7742250657728, -122.402530154365) | |||
| 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) | |||
| 29073 | 29073 | 227764 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4314 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001842.536180001 | 2100618.06148 | 37.7480011379615 | -122.436398576738 | (37.7480011379615, -122.436398576738) | |||
| 29224 | 29224 | 227995 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 321 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004807.15163 | 2101805.7755 | 37.7514303338561 | -122.426231597132 | (37.7514303338561, -122.426231597132) | |||
| 29318 | 29318 | 248428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 130 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998278.3106 | 2108020.0433 | 37.768121965532295 | -122.449256670048 | (37.7681219655323, -122.449256670048) | |||
| 29643 | 29643 | 246620 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009078.777530001 | 2099136.29589 | 37.744341055486295 | -122.411271191437 | (37.7443410554863, -122.411271191437) | |||
| 29850 | 29850 | 129698 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000533.7718 | 2116193.1450799997 | 37.7906919681164 | -122.442042015953 | (37.7906919681164, -122.442042015953) | |||
| 30061 | 30061 | 247344 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 213 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002764.9406 | 2109273.4332 | 37.771819073738705 | -122.43382749783899 | (37.7718190737387, -122.433827497839) | |||
| 30195 | 30195 | 142197 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 BAKER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000681.6059 | 2110025.4851 | 37.773765578161296 | -122.44108783944799 | (37.7737655781613, -122.441087839448) | |||
| 30224 | 30224 | 227891 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 58 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003143.30655 | 2107929.00611 | 37.7681490697424 | -122.432422664995 | (37.7681490697424, -122.432422664995) | |||
| 30357 | 30357 | 227761 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.61046 | 2099602.37866 | 37.745415306472204 | -122.42393276538601 | (37.7454153064722, -122.423932765386) | |||
| 30431 | 30431 | 208020 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1285 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994218.151430001 | 2106814.05581 | 37.7645775678277 | -122.463212712505 | (37.7645775678277, -122.463212712505) | |||
| 30507 | 30507 | 129709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002148.23302 | 2117769.42382 | 37.795111892265 | -122.436568947899 | (37.795111892265, -122.436568947899) | |||
| 30686 | 30686 | 200259 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 46 Boardman Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011837.77758 | 2109952.34907 | 37.7741938907772 | -122.402491502385 | (37.7741938907772, -122.402491502385) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 31751 | 31751 | 129693 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000643.07515 | 2116204.21556 | 37.7907285930009 | -122.44166462801701 | (37.7907285930009, -122.441664628017) | |||
| 31872 | 31872 | 124631 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 725 Euclid Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5996077.92539 | 2113787.58101 | 37.783832003391296 | -122.45728481381501 | (37.7838320033913, -122.457284813815) | |||
| 31953 | 31953 | 227817 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 177 Wool St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007367.5579 | 2097392.89252 | 37.7394579364345 | -122.417064737348 | (37.7394579364345, -122.417064737348) | |||
| 31979 | 31979 | 129746 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1310 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011484.09994 | 2119879.99013 | 37.801433092922004 | -122.40441387701401 | (37.801433092922, -122.404413877014) | |||
| 32066 | 32066 | 208129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 14 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994035.372909999 | 2102011.52015 | 37.751380514111396 | -122.463496334396 | (37.7513805141114, -122.463496334396) | |||
| 32527 | 32527 | 248574 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998368.8565 | 2107590.9345 | 37.7669489203591 | -122.448912568843 | (37.7669489203591, -122.448912568843) | |||
| 32656 | 32656 | 123589 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 32 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994275.31768 | 2115360.29886 | 37.7880465633309 | -122.463635298323 | (37.7880465633309, -122.463635298323) | |||
| 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) | |||
| 32758 | 32758 | 208066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994517.25257 | 2100489.12784 | 37.7472281625491 | -122.46171957892099 | (37.7472281625491, -122.461719578921) | |||
| 32924 | 32924 | 191543 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014401.59884 | 2103605.63066 | 37.7569099903147 | -122.39317852616199 | (37.7569099903147, -122.393178526162) | |||
| 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) | |||
| 33184 | 33184 | 227781 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 585 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001575.56604 | 2102446.1042 | 37.7530053336508 | -122.437452632547 | (37.7530053336508, -122.437452632547) | |||
| 33223 | 33223 | 191555 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011789.66308 | 2106208.9715 | 37.7639127377095 | -122.402394675067 | (37.7639127377095, -122.402394675067) | |||
| 33495 | 33495 | 105991 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 997 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x9 | 6015541.70538 | 2104536.18595 | 37.7595283673583 | -122.389300555992 | (37.7595283673583, -122.389300555992) | |||
| 33653 | 33653 | 208029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993680.14998 | 2104375.72277 | 37.7578515328401 | -122.464896406148 | (37.7578515328401, -122.464896406148) |
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");