trees
508 rows where qSpecies_id = 25 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
38044 | 255484 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2147 Beach St | : | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | Permit Number 781954 | 5999947.25363 | 2120887.03087 | 37.8035466909489 | -122.444408807729 | (37.8035466909489, -122.444408807729) | 13 | 9 | 1 | 57 | 17 | ||
45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
636 | 67551 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.7613646282886 | -122.403117586111 | (37.7613646282886, -122.403117586111) | 10 | 3 | 8 | 28856 | 29 | |
732 | 181868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2335 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5987618.1769 | 2099375.389 | 37.7437705756333 | -122.485494034638 | (37.7437705756333, -122.485494034638) | 1 | 8 | 3 | 29491 | 35 | ||
993 | 67493 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.7606474054712 | -122.402272073209 | (37.7606474054712, -122.402272073209) | 10 | 3 | 8 | 28856 | 29 | ||
1058 | 160441 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001628.58163 | 2090114.34641 | 37.7191481986061 | -122.436386782123 | (37.7191481986061, -122.436386782123) | 9 | 7 | 6 | 28861 | 5 | |
1568 | 172155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 649 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 6011250.4218 | 2091802.92791 | 37.7243267296922 | -122.403246295306 | (37.7243267296922, -122.403246295306) | 10 | 3 | 7 | 309 | 28 | |||
2617 | 247759 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | 15 | 5 | 5 | 29492 | 9 | |||
3439 | 43015 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
4108 | 171288 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003689.73978 | 2092721.91783 | 37.7264249154698 | -122.429448003531 | (37.7264249154698, -122.429448003531) | 9 | 7 | 6 | 28861 | 5 | ||
4619 | 84421 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3450 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | 2 | 4 | 7 | 28859 | 19 | ||
4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | |||
4939 | 225906 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.7502609561874 | -122.423660939909 | (37.7502609561874, -122.423660939909) | 2 | 4 | 5 | 28859 | 19 | |||
5259 | 45154 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44007 | |||||||||||||
5319 | 26546 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2020 12:45:00 PM | 3 | 4X4 | 6008578.3106 | 2121094.8201 | 37.804605899968 | -122.414555254943 | (37.804605899968, -122.414555254943) | 3 | 1 | 10 | 308 | 23 | ||
5483 | 83664 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/2019 12:00:00 AM | 3 | 3x3 | Permit Number 769750 | 6003631.23676 | 2092962.7354 | 37.7270828342867 | -122.429667413832 | (37.7270828342867, -122.429667413832) | 9 | 7 | 6 | 28861 | 5 |
5523 | 38232 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
6809 | 65477 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 400 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28358 | 5994782.15079154 | 2091255.17859292 | 37.7218892499679 | -122.460134715976 | (37.7218892499679, -122.460134715976) | 9 | 8 | 4 | 28861 | 24 | ||
7369 | 228945 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 25 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6005777.88967 | 2106349.43528 | 37.7639609845445 | -122.423197607405 | (37.7639609845445, -122.423197607405) | 8 | 4 | 5 | 28859 | 19 | |
7461 | 32089 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3976 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | Permit Number 35462 | 6003168.80356063 | 2104788.27114216 | 37.7595268169135 | -122.432110159889 | (37.7595268169135, -122.432110159889) | 2 | 4 | 5 | 28862 | 3 | ||
7887 | 152881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3572 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005780.88013 | 2104928.47476 | 37.7600595303512 | -122.42308625784 | (37.7600595303512, -122.42308625784) | 2 | 4 | 5 | 28859 | 19 | |||
8075 | 225935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1994 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.47689 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | 2 | 4 | 7 | 28859 | 19 | |
8908 | 69088 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.470278745237 | (37.7606123691548, -122.470278745237) | 1 | 8 | 4 | 56 | 12 | ||
9398 | 264655 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1099 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
9717 | 56360 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1973 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | 13 | 6 | 1 | 29490 | 27 | |
10034 | 262181 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 299 Raymond Ave | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009464.05793 | 2087979.76345 | 37.7137291845874 | -122.409151878423 | (37.7137291845874, -122.409151878423) | 9 | 7 | 8 | 309 | 39 | ||
10061 | 171232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 83 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2019 12:00:00 AM | 3 | 4x6 | 6003613.10498 | 2092939.5829 | 37.727018235977 | -122.429728444518 | (37.727018235977, -122.429728444518) | 9 | 7 | 6 | 28861 | 5 | ||
10451 | 225947 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003497.57041 | 2095097.96573 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | 9 | 7 | 5 | 28861 | 25 | |||
11255 | 70154 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | 11 | 6 | 2 | 54 | 11 | |||
11311 | 73919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007979.77962 | 2109750.06791 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | 8 | 2 | 9 | 28853 | 34 | |||
11749 | 200232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | ||
12728 | 256034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1455 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015659 | 2093559 | 37.729393784799 | -122.388128823531 | (37.729393784799, -122.388128823531) | 10 | 3 | 8 | 58 | 1 | |||
13543 | 83275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008740.14676 | 2118614.90766 | 37.7978057691893 | -122.413819676732 | (37.7978057691893, -122.413819676732) | 5 | 1 | 10 | 308 | 21 | |||
13990 | 142563 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 555 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:42:00 PM | 3 | Width 0ft | 6008640.5494 | 2121060.0298 | 37.8045138709312 | -122.414337407838 | (37.8045138709312, -122.414337407838) | 3 | 1 | 10 | 308 | 23 | ||
14624 | 261099 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011819 | 2093407 | 37.7287629192895 | -122.401393465775 | (37.7287629192895, -122.401393465775) | 10 | 3 | 8 | 58 | 1 | |
15108 | 113387 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
15134 | 261076 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1188 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
15349 | 122920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 330 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2020 12:00:00 AM | 3 | Width 2ft | 5992493.10071 | 2113220.22773 | 37.7820676636923 | -122.469645543184 | (37.7820676636923, -122.469645543184) | 11 | 6 | 2 | 54 | 11 | ||
16190 | 34502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1997 12:00:00 AM | 9 | Permit Number 38224 | 6013698.3172 | 2104744.62684 | 37.7599983314835 | -122.395690557494 | (37.7599983314835, -122.395690557494) | 10 | 3 | 8 | 28856 | 29 | |
16692 | 78621 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011632.94564 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | 10 | 3 | 8 | 28856 | 29 | |||
17037 | 264800 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 330 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011202 | 2089015 | 37.7166689455126 | -122.403217660421 | (37.7166689455126, -122.403217660421) | 10 | 7 | 8 | 309 | 39 | ||||
17098 | 34067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
17201 | 72137 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013608.91395 | 2104739.63414 | 37.7599796489713 | -122.395999412568 | (37.7599796489713, -122.395999412568) | 10 | 3 | 8 | 28856 | 29 | |||
17567 | 150775 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2004 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 4x5 | 6012077.37529 | 2103767.84682 | 37.757226007585 | -122.401228007969 | (37.757226007585, -122.401228007969) | 10 | 3 | 8 | 28856 | 29 | |
18508 | 79749 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.389711390588 | (37.7638512843329, -122.389711390588) | 14 | 3 | 8 | 28856 | 29 | |||
19459 | 49782 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2020 12:00:00 AM | 3 | Permit Number 46567 | 6012093.71999 | 2087090.74144 | 37.711435076735 | -122.400000354248 | (37.711435076735, -122.400000354248) | 10 | 3 | 8 | 309 | 1 | |
19562 | 62935 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 108 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23316 | 6007129.03577236 | 2097271.50045175 | 37.7391111999262 | -122.417880841628 | (37.7391111999262, -122.417880841628) | 2 | 7 | 7 | 28859 | 2 | ||
20477 | 39576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) | 2 | 7 | 7 | 28859 | 2 | ||
21411 | 10091 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.7597558823477 | -122.423740797923 | (37.7597558823477, -122.423740797923) | 2 | 4 | 5 | 28859 | 19 | ||
21840 | 67067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30456 | 6006871.92388007 | 2096801.0625203 | 37.7378050085566 | -122.418736466303 | (37.7378050085566, -122.418736466303) | 2 | 7 | 7 | 28859 | 2 | ||
22071 | 192422 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.7680909933277 | -122.401057281578 | (37.7680909933277, -122.401057281578) | 14 | 3 | 8 | 28856 | 20 | |||
22131 | 49877 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.7633942890183 | -122.467431700246 | (37.7633942890183, -122.467431700246) | 1 | 8 | 11 | 56 | 12 | |||
22267 | 82278 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.7836876598148 | -122.468856534024 | (37.7836876598148, -122.468856534024) | 11 | 6 | 2 | 54 | 11 | |
23044 | 51908 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.432833581883 | (37.7610905025589, -122.432833581883) | 15 | 4 | 5 | 28862 | 3 |
23576 | 10026 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2x3 | 6005455.03663 | 2107324.13866 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | 8 | 4 | 5 | 28853 | 19 | |||
24456 | 225946 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | 2 | 4 | 5 | 28859 | 19 | |||
25081 | 225931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | 2 | 7 | 7 | 28859 | 2 | |||
25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
27374 | 176498 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.421797376475 | (37.7121905153633, -122.421797376475) | 9 | 7 | 8 | 309 | 18 | |||
27755 | 82843 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | 8 | 2 | 9 | 28853 | 34 | |
28366 | 36001 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336 | (37.7472437298861, -122.41664293336) | 2 | 7 | 7 | 28859 | 2 | ||
28535 | 41155 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | 15 | 6 | 1 | 54 | 31 | |||
29333 | 225916 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.7583230563848 | -122.425169300823 | (37.7583230563848, -122.425169300823) | 2 | 4 | 5 | 28859 | 19 | |||
29499 | 244210 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | 7 | 9 | 11 | 29492 | 10 | |||
30741 | 176516 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | 9 | 7 | 8 | 309 | 39 | |||
30868 | 95394 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 208 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579 | 2098715 | 37.7429308791836 | -122.426800483584 | (37.7429308791836, -122.426800483584) | 2 | 7 | 5 | 63 | 22 | |
31110 | 48958 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
31262 | 69447 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | 11 | 6 | 2 | 55 | 26 | ||
32183 | 225901 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.7639719400684 | -122.423034081872 | (37.7639719400684, -122.423034081872) | 8 | 4 | 5 | 28859 | 19 | |||
32550 | 59941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | 15 | 5 | 11 | 29492 | 16 | |
33078 | 52211 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | 2 | 4 | 5 | 28859 | 19 | ||
33525 | 67084 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248 | -122.417988384197 | (37.738413501248, -122.417988384197) | 2 | 7 | 7 | 28859 | 2 | ||
33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
35443 | 73660 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.7940966 | 2090940.29616255 | 37.7210552801536 | -122.458270736601 | (37.7210552801536, -122.458270736601) | 9 | 8 | 6 | 28861 | 24 | ||
35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
39253 | 66067 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.70593 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | 10 | 3 | 8 | 28856 | 29 | |
40018 | 105804 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 117 ALPINE TER | 1 | Front Yard : Cutout | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | 15 | 5 | 5 | 29492 | 3 | |
40331 | 45143 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | 15 | 5 | 11 | 29492 | 9 | ||
40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
40882 | 219016 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | 9 | 7 | 4 | 59 | 40 | |||
40896 | 247270 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | 15 | 5 | 11 | 29492 | 9 | |||
41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
41661 | 49835 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.86383 | 37.7590565524297 | -122.393142029905 | (37.7590565524297, -122.393142029905) | 10 | 3 | 8 | 28856 | 29 | |
41836 | 32486 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.7187841 | 2106514.92813142 | 37.7641354685469 | -122.440289096409 | (37.7641354685469, -122.440289096409) | 15 | 5 | 5 | 28862 | 3 | ||
42236 | 66180 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.7600022642143 | -122.395600181905 | (37.7600022642143, -122.395600181905) | 10 | 3 | 8 | 28856 | 29 | |
43247 | 35398 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | 2 | 7 | 5 | 63 | 22 | ||
43636 | 94704 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.91007 | 2110887.94739 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) | 11 | 6 | 2 | 54 | 11 |
44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
44632 | 36064 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
44918 | 67927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.7330050563948 | -122.429274738173 | (37.7330050563948, -122.429274738173) | 9 | 7 | 5 | 28861 | 25 | ||
45175 | 225948 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6003779.75499 | 2095097.51754 | 37.7329528756765 | -122.429306150766 | (37.7329528756765, -122.429306150766) | 9 | 7 | 5 | 28861 | 25 | |||
45964 | 67574 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | 10 | 3 | 8 | 28856 | 29 | |
46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 |
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) );