trees
1,521 rows where qSpecies_id = 37
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71 | 227799 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1265 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2020 12:00:00 AM | 17 | 6x6 | 5997473.24622 | 2105221.8097 | 37.760392645519 | -122.451839397566 | (37.760392645519, -122.451839397566) | 15 | 5 | 11 | 29492 | 12 | ||
933 | 191132 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 853 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012171.3747 | 2104414.8785 | 37.759007857755 | -122.400948379065 | (37.759007857755, -122.400948379065) | 10 | 3 | 8 | 28856 | 29 | |||
1055 | 35449 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
1114 | 32669 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 750 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | 14 | 2 | 9 | 28853 | 34 | ||
1179 | 251578 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1000X Columbus Ave | 6 | Median : Cutout | Tree | DPW 1 | |||||||||||||||
1581 | 19590 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
1619 | 95785 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 347 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | |||||||||||
1648 | 35048 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 700 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
1759 | 35455 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
2138 | 228020 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1112 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998182.13932 | 2106442.54702 | 37.7637850591596 | -122.449475636595 | (37.7637850591596, -122.449475636595) | 15 | 5 | 11 | 29492 | 9 | |||
2525 | 261765 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 301 Funston Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5991822 | 2113404 | 37.7825334415324 | -122.471980622767 | (37.7825334415324, -122.471980622767) | 11 | 6 | 2 | 54 | 11 | ||||
2864 | 227812 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.445489132637 | (37.765232827359, -122.445489132637) | 15 | 5 | 5 | 29492 | 9 | |||
2898 | 191530 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | 14 | 3 | 9 | 310 | 20 | |||
2921 | 124004 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 145 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | Width 4ft | 5993946.73385 | 2114533.02839 | 37.7857561658631 | -122.464712034275 | (37.7857561658631, -122.464712034275) | 11 | 6 | 2 | 54 | 11 | ||
2934 | 70681 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 366 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6010590.1917 | 2106606.8545 | 37.7649382022496 | -122.406571346991 | (37.7649382022496, -122.406571346991) | 8 | 4 | 8 | 28853 | 19 | |||
3180 | 191527 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.7668840087222 | -122.387813186138 | (37.7668840087222, -122.387813186138) | 14 | 3 | 9 | 310 | 20 | |||
3451 | 142202 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 300 LYON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000252.2157 | 2110108.2355 | 37.7739683228777 | -122.442579106401 | (37.7739683228777, -122.442579106401) | 15 | 5 | 11 | 29492 | 16 | |||
3677 | 95316 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2870@Divisadero Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000971.60034 | 2116251.73043 | 37.7908777689321 | -122.440531359949 | (37.7908777689321, -122.440531359949) | 13 | 6 | 1 | 29490 | 27 | |
3896 | 227738 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1240 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1991 12:00:00 AM | 9 | Width 4ft | Permit Number 30100 | 5997494.2501 | 2105433.95534 | 37.7609763468939 | -122.451782059502 | (37.7609763468939, -122.451782059502) | 15 | 5 | 11 | 29492 | 12 | |
4084 | 259522 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 309 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994311 | 2099921 | 37.7456563517477 | -122.462391578862 | (37.7456563517477, -122.462391578862) | 1 | 8 | 4 | 29491 | 40 | ||||
4255 | 19806 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60ST | |||||||||||||
4267 | 4458 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1420 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1999 12:00:00 AM | 3 | 3X3 | 6004503.18681 | 2100562.97231 | 37.7480006990827 | -122.427194227854 | (37.7480006990827, -122.427194227854) | 2 | 4 | 5 | 63 | 22 | ||
5065 | 35446 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
5174 | 35453 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
5179 | 261766 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 301 Funston Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5991822 | 2113404 | 37.7825334415324 | -122.471980622767 | (37.7825334415324, -122.471980622767) | 11 | 6 | 2 | 54 | 11 | ||||
5451 | 227724 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 937 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 18 | Width 4ft | Permit Number 17591 | 5999190.54097 | 2106890.47379 | 37.7650725879622 | -122.446020116632 | (37.7650725879622, -122.446020116632) | 15 | 5 | 11 | 29492 | 9 | |
5532 | 227753 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 201X Powhattan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007829.3265 | 2098181.77554 | 37.7416500006593 | -122.415523976565 | (37.7416500006593, -122.415523976565) | 2 | 7 | 7 | 28859 | 2 | |||
5740 | 37326 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39837 | 6002947.90722614 | 2103845.15191447 | 37.756924711117 | -122.432806753551 | (37.756924711117, -122.432806753551) | 2 | 4 | 5 | 28862 | 3 | ||
5921 | 227756 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 201X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007867.24029 | 2098177.26821 | 37.7416397555584 | -122.415392564015 | (37.7416397555584, -122.415392564015) | 2 | 7 | 7 | 28859 | 2 | |||
6154 | 35450 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
6181 | 227892 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 11 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003807.3589 | 2108238.1096 | 37.7690354253758 | -122.430147830752 | (37.7690354253758, -122.430147830752) | 7 | 9 | 5 | 28862 | 3 | |||
6797 | 35457 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
7015 | 23789 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1100X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.430519258933 | (37.7812424081927, -122.430519258933) | 15 | 9 | 11 | 29490 | 41 | |||
7219 | 100493 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 1899X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008692.6 | 2107433.7 | 37.7671021827668 | -122.413193133966 | (37.7671021827668, -122.413193133966) | 8 | 4 | 7 | 28853 | 19 | |||
7332 | 81252 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 877 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011897.37583 | 2104298.81412 | 37.7586738828079 | -122.40188784325 | (37.7586738828079, -122.40188784325) | 10 | 3 | 8 | 28856 | 29 | |||
7338 | 35458 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
7443 | 191114 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6014324.84977 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | 10 | 3 | 8 | 28856 | 29 | |||
7558 | 225711 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 220 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 5x5 | 6006136.54015 | 2101854.84256 | 37.7516401124236 | -122.421637890685 | (37.7516401124236, -122.421637890685) | 2 | 4 | 5 | 28859 | 19 | |||
7711 | 121707 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6014418.63388 | 2103271.30813 | 37.7559929588317 | -122.393096220215 | (37.7559929588317, -122.393096220215) | 10 | 3 | 8 | 28856 | 29 | ||||
7762 | 227806 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1235 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997433.43236 | 2105521.01823 | 37.7612119162092 | -122.451998681919 | (37.7612119162092, -122.451998681919) | 15 | 5 | 11 | 29492 | 12 | |||
7866 | 191127 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 14 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012309.59663 | 2104032.19634 | 37.7579648060593 | -122.400443459212 | (37.7579648060593, -122.400443459212) | 10 | 3 | 8 | 28856 | 29 | |||
7960 | 228004 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1039 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998111.03938 | 2106633.51885 | 37.7643053520281 | -122.449735311348 | (37.7643053520281, -122.449735311348) | 15 | 5 | 11 | 29492 | 9 | |||
7994 | 200267 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 860x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 5ft | 6014763.42943 | 2089103.48734 | 37.7171101711671 | -122.39091365107 | (37.7171101711671, -122.39091365107) | 10 | 3 | 8 | 58 | 1 | |||
8010 | 2406 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2729 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009835.50998 | 2101434.53387 | 37.7506939230859 | -122.408816669975 | (37.7506939230859, -122.408816669975) | 2 | 4 | 7 | 28859 | 19 | |||
8015 | 35369 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 628 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 8 | 5x9 | Permit Number 780712 | 6010944.29074 | 2105222.09895 | 37.76115577964 | -122.405249080092 | (37.76115577964, -122.405249080092) | 10 | 3 | 8 | 28856 | 29 |
8036 | 121715 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.393046892403 | (37.7555585790683, -122.393046892403) | 10 | 3 | 8 | 28856 | 29 | ||
8204 | 72246 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002360.66039 | 2091027.79889 | 37.7216979061151 | -122.433921526363 | (37.7216979061151, -122.433921526363) | 9 | 7 | 6 | 28861 | 5 | |||
8225 | 227755 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 201X Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007852.28017 | 2098178.64056 | 37.7416426828781 | -122.415444388362 | (37.7416426828781, -122.415444388362) | 2 | 7 | 7 | 28859 | 2 | |||
8331 | 191528 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.387720466935 | (37.76689343092, -122.387720466935) | 14 | 3 | 9 | 310 | 20 | ||
8467 | 227792 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1983 12:00:00 AM | 18 | Width 3ft | Permit Number 20294 | 6004387.52295 | 2097025.09932 | 37.7382799693533 | -122.427342203202 | (37.7382799693533, -122.427342203202) | 2 | 7 | 5 | 63 | 7 | |
8645 | 35454 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
8852 | 248572 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 196 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998334.1825 | 2107625.9113 | 37.7670429747654 | -122.449035020083 | (37.7670429747654, -122.449035020083) | 15 | 5 | 11 | 29492 | 9 | |||
8889 | 227748 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 899 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009090.18719 | 2096911.91378 | 37.7382340283696 | -122.411074651796 | (37.7382340283696, -122.411074651796) | 10 | 7 | 7 | 28859 | 2 | |||
8897 | 191138 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 770 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | 6011596.13889 | 2113930.29234 | 37.7851029064102 | -122.403607318248 | (37.7851029064102, -122.403607318248) | 12 | 2 | 9 | 28853 | 6 | |||
8954 | 208076 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 442 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998485.7432 | 2094410.13539 | 37.7307643520895 | -122.447559384561 | (37.7307643520895, -122.447559384561) | 9 | 7 | 4 | 59 | 40 | |||
9169 | 208142 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 40 Garcia Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 5995206.6173 | 2099521.98382 | 37.7446122856405 | -122.459265799391 | (37.7446122856405, -122.459265799391) | 1 | 8 | 4 | 59 | 40 | |||
9186 | 59095 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 671 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18396 | 5994079.76607 | 2110941.26812 | 37.7759018291206 | -122.463990963797 | (37.7759018291206, -122.463990963797) | 11 | 6 | 2 | 54 | 11 | ||
9206 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 6 Higuera Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5987898 | 2090420 | 37.7191976939958 | -122.48386996767 | (37.7191976939958, -122.48386996767) | 1 | 8 | 4 | 64 | 14 | ||||
9213 | 35448 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
9360 | 35444 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
9372 | 208097 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1578 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992786.16766 | 2104723.32687 | 37.7587543775304 | -122.468013427586 | (37.7587543775304, -122.468013427586) | 1 | 8 | 4 | 56 | 12 | |||
9374 | 124022 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 301 Funston Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991822 | 2113404 | 37.7825334415324 | -122.471980622767 | (37.7825334415324, -122.471980622767) | 11 | 6 | 2 | 54 | 11 | |||
9436 | 115038 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 788 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777510 | 6012725 | 2112521 | 37.7812963087062 | -122.399602805279 | (37.7812963087062, -122.399602805279) | 6 | 2 | 9 | 28856 | 34 | |
9524 | 71574 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 970 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6015483.05138 | 2104523.27151 | 37.759489655143 | -122.389502510438 | (37.759489655143, -122.389502510438) | 10 | 3 | 8 | 28856 | 29 | |||
9586 | 191511 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 392 04th St | 2 | : | Tree | Private 2 | 09/27/2001 12:00:00 AM | 5 | Width 3ft | Permit Number 44376 | 6012652.22642 | 2112454.21838 | 37.7811088850041 | -122.399849876973 | (37.7811088850041, -122.399849876973) | 6 | 2 | 9 | 28856 | 34 | |
9761 | 19588 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 100 STAIRWAY4 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
9902 | 258348 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1760 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1988 12:00:00 AM | 3x3 | Permit Number 25361 | 6009198 | 2119365 | 37.7998910391876 | -122.412288414988 | (37.7998910391876, -122.412288414988) | 3 | 1 | 10 | 308 | 4 | ||
9997 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 835 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
10079 | 140408 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1395 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003217.0783 | 2112984.5587 | 37.7820345494787 | -122.432528645817 | (37.7820345494787, -122.432528645817) | 15 | 9 | 11 | 29490 | 41 | |||
10105 | 35452 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
10231 | 228002 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1033 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998104.33903 | 2106671.65488 | 37.764409680579 | -122.449761234305 | (37.764409680579, -122.449761234305) | 15 | 5 | 11 | 29492 | 9 | |||
10235 | 191533 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | 14 | 3 | 9 | 310 | 20 | |||
10294 | 129716 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1087 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006809.35 | 2120459.56601 | 37.8027621146536 | -122.420631800213 | (37.8027621146536, -122.420631800213) | 5 | 1 | 1 | 28858 | 32 | |||
10329 | 97503 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | Permit Number 768347 | 5992229 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | 1 | 8 | 4 | 29491 | 40 | |||
10435 | 1664 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1400X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000454.8566 | 2109968.1462 | 37.7735952220186 | -122.441868082855 | (37.7735952220186, -122.441868082855) | 15 | 5 | 11 | 29492 | 16 | |||
10450 | 114373 | Property Tree 8 | Liquidambar styraciflua :: American Sweet Gum 37 | 805 GONZALEZ DR | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5988302 | 2089566 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | 1 | 8 | 4 | 64 | 14 | ||||
10497 | 35451 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
10521 | 123551 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 69 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994236.53379 | 2115140.07553 | 37.7874396553249 | -122.463753492359 | (37.7874396553249, -122.463753492359) | 11 | 6 | 1 | 54 | 11 | |||
10550 | 72745 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 630 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014368.47068 | 2104204.35874 | 37.7585521280858 | -122.39333499383 | (37.7585521280858, -122.39333499383) | 10 | 3 | 8 | 28856 | 29 | |||
10676 | 26756 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | 13 | 9 | 1 | 28858 | 41 | |||
10691 | 121718 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 880 Pennsylvania Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6014431.62012 | 2103050.15485 | 37.7553864407519 | -122.393035836129 | (37.7553864407519, -122.393035836129) | 10 | 3 | 8 | 28856 | 29 | ||||
10733 | 123473 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 625 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995601.02022 | 2111940.74017 | 37.7787336686397 | -122.458800964288 | (37.7787336686397, -122.458800964288) | 11 | 6 | 2 | 54 | 11 | |||
10741 | 19589 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 100 STAIRWAY4 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
10822 | 227716 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 810 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998663.42523 | 2107521.35267 | 37.7667747077998 | -122.447888696528 | (37.7667747077998, -122.447888696528) | 15 | 5 | 11 | 29492 | 9 | |||
11208 | 117135 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 660 Mississippi St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014096.85518034 | 2104132.8866965 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | 10 | 3 | 8 | 28856 | 29 | ||||
11219 | 140380 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1405 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003187.4853 | 2113207.0518 | 37.7826437814696 | -122.432646922023 | (37.7826437814696, -122.432646922023) | 15 | 9 | 11 | 29490 | 41 | |||
11270 | 32664 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 750 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | 14 | 2 | 9 | 28853 | 34 | ||
11273 | 248466 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | 15 | 5 | 11 | 29492 | 9 | |||
11397 | 191531 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.7669129399083 | -122.387275369984 | (37.7669129399083, -122.387275369984) | 14 | 3 | 9 | 310 | 20 | |||
11427 | 173646 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 380 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003542 | 2106028 | 37.7629519666094 | -122.43090793912 | (37.7629519666094, -122.43090793912) | 15 | 4 | 5 | 28862 | 3 | ||||
11649 | 76428 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | 6 | 2 | 9 | 28855 | 6 | |||
11872 | 227964 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 221 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005458.52467 | 2102332.5968 | 37.7529136594399 | -122.424016529154 | (37.7529136594399, -122.424016529154) | 2 | 4 | 5 | 28859 | 19 | |||
12148 | 227749 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 899 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009066.20939 | 2096913.93044 | 37.7382382210078 | -122.411157697894 | (37.7382382210078, -122.411157697894) | 10 | 7 | 7 | 28859 | 2 | |||
12201 | 140276 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998008.2541 | 2109969.0086 | 37.7734578744037 | -122.450331271992 | (37.7734578744037, -122.450331271992) | 15 | 5 | 11 | 29492 | 16 | ||
12586 | 37973 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 630 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40203 | |||||||||||||
12658 | 41678 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42133 | 5999656.32726227 | 2105735.31763117 | 37.761927403993 | -122.444326061687 | (37.761927403993, -122.444326061687) | 15 | 5 | 5 | 28862 | 3 | ||
12842 | 23729 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 800X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.429917683229 | (37.7783296231018, -122.429917683229) | 7 | 9 | 11 | 29490 | 41 | ||
12974 | 191523 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1060 Tennessee St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015501.46651 | 2104207.8933 | 37.7586247150714 | -122.389416796942 | (37.7586247150714, -122.389416796942) | 10 | 3 | 8 | 28856 | 29 | |||
13454 | 35445 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
13561 | 129718 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.420506191927 | (37.8027774273877, -122.420506191927) | 5 | 1 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );