trees
90 rows where qSpecies_id = 269 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7131 | 227527 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 18 Worth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6000853.893 | 2103182.27868 | 37.7549856353975 | -122.440001092669 | (37.7549856353975, -122.440001092669) | 2 | 4 | 5 | 28862 | 22 | |||
13697 | 227535 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 433 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003472.7376 | 2103874.65169 | 37.7570354628405 | -122.430993799639 | (37.7570354628405, -122.430993799639) | 2 | 4 | 5 | 28862 | 3 | |||
23009 | 227533 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202 Hartford St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002683.27293 | 2104635.83496 | 37.7590807244115 | -122.43377846852 | (37.7590807244115, -122.43377846852) | 2 | 4 | 5 | 28862 | 3 | |||
30008 | 82867 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 243-245 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52430 | 6009431.77507071 | 2110559.3179918 | 37.7757258727902 | -122.410857204902 | (37.7757258727902, -122.410857204902) | 8 | 2 | 9 | 28853 | 34 | ||
38390 | 84039 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1117-1119 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | Permit Number 50428 | 6004461.93276532 | 2102391.33206178 | 37.753018616529 | -122.427467116446 | (37.753018616529, -122.427467116446) | 2 | 4 | 5 | 28862 | 22 | |||
39579 | 5439 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 500X Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/01/1990 12:00:00 AM | 45 | 6 | 6004897.25501 | 2105174.42186 | 37.7606849395651 | -122.426159805147 | (37.7606849395651, -122.426159805147) | 2 | 4 | 5 | 28862 | 3 | ||
45335 | 84102 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4297 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | 2 | 4 | 5 | 28862 | 22 | ||
51670 | 227525 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 705 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001257.1165 | 2102241.08377 | 37.7524242870632 | -122.438539201525 | (37.7524242870632, -122.438539201525) | 2 | 4 | 5 | 28862 | 22 | |||
52948 | 84103 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4297 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | 2 | 4 | 5 | 28862 | 22 | ||
55939 | 227524 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006695.80913 | 2100883.44136 | 37.7490043865639 | -122.419634947601 | (37.7490043865639, -122.419634947601) | 2 | 4 | 7 | 28859 | 19 | |||
58249 | 208016 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 2348 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5992345.58828 | 2099437.95609 | 37.7442166639716 | -122.469152467524 | (37.7442166639716, -122.469152467524) | 1 | 8 | 4 | 29491 | 40 | |||
59755 | 227530 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 25 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000951.52237 | 2104906.48443 | 37.7597254421078 | -122.439787074722 | (37.7597254421078, -122.439787074722) | 2 | 4 | 5 | 28862 | 3 | |||
63127 | 5445 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 500X Dolores St | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/20/1990 12:00:00 AM | 8 | 6 | 6004913.51654 | 2104964.38719 | 37.7601091531428 | -122.426088611215 | (37.7601091531428, -122.426088611215) | 2 | 4 | 5 | 28862 | 3 | ||
64007 | 4414 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1117 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1992 12:00:00 AM | 4 | 1X1 | 6004464.79166 | 2102375.22618 | 37.7529745552411 | -122.427456082543 | (37.7529745552411, -122.427456082543) | 2 | 4 | 5 | 28862 | 22 | ||
64351 | 53681 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 3676 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1989 12:00:00 AM | 12 | 7x9 | Permit Number 28114 | 6005126.00914316 | 2104896.86340653 | 37.7599357563315 | -122.425348894887 | (37.7599357563315, -122.425348894887) | 2 | 4 | 5 | 28859 | 19 | |
68590 | 227531 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002677.00253 | 2104676.70583 | 37.7591925901746 | -122.433803075747 | (37.7591925901746, -122.433803075747) | 2 | 4 | 5 | 28862 | 3 | |||
81748 | 227529 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4297 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001280.54465 | 2102294.52512 | 37.7525723568362 | -122.438462011837 | (37.7525723568362, -122.438462011837) | 2 | 4 | 5 | 28862 | 22 | |||
81769 | 227534 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 310 Liberty St | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6004116.82698 | 2103937.8336 | 37.7572454203459 | -122.428770797837 | (37.7572454203459, -122.428770797837) | 2 | 4 | 5 | 28862 | 3 | |||
82110 | 227526 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 705 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001255.81284 | 2102255.85885 | 37.7524647817245 | -122.438544768324 | (37.7524647817245, -122.438544768324) | 2 | 4 | 5 | 28862 | 22 | |||
84085 | 227522 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 749 Dolores St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 8ft | 6005045.57864 | 2104083.12055 | 37.7576968656229 | -122.425569150194 | (37.7576968656229, -122.425569150194) | 2 | 4 | 5 | 28859 | 19 | |||
85389 | 82868 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 229- 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52430 | 6009387 | 2110633 | 37.7759256755533 | -122.411017299189 | (37.7759256755533, -122.411017299189) | 8 | 2 | 9 | 28853 | 34 | ||
86780 | 82958 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 35 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50805 | 6000912.41841684 | 2104895.69025966 | 37.7596935780473 | -122.439921541658 | (37.7596935780473, -122.439921541658) | 2 | 4 | 5 | 28862 | 3 | ||
93104 | 227523 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 3450 26th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6006737.2033 | 2100885.725 | 37.7490129885555 | -122.419491968004 | (37.7490129885555, -122.419491968004) | 2 | 4 | 7 | 28859 | 19 | |||
93945 | 100307 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.433805877135 | (37.7592732879998, -122.433805877135) | 2 | 4 | 5 | 28862 | 3 | |||
104130 | 5725 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1676 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6005265.5295 | 2098569.21573 | 37.7425693811872 | -122.424416284994 | (37.7425693811872, -122.424416284994) | 2 | 7 | 5 | 63 | 22 | |||
104151 | 227528 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 18 Worth St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6000854.651 | 2103166.63578 | 37.7549427269363 | -122.439997349707 | (37.7549427269363, -122.439997349707) | 2 | 4 | 5 | 28862 | 22 | |||
107021 | 84124 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1118 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50685 | 6011552.18251 | 2089642.5375 | 37.7184115873075 | -122.402051338211 | (37.7184115873075, -122.402051338211) | 10 | 7 | 8 | 309 | 39 | |
108882 | 100308 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.433805877135 | (37.7592732879998, -122.433805877135) | 2 | 4 | 5 | 28862 | 3 | |||
110966 | 227532 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202 Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002679.72985 | 2104658.05028 | 37.7591415212848 | -122.433792309982 | (37.7591415212848, -122.433792309982) | 2 | 4 | 5 | 28862 | 3 | |||
131756 | 5373 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 267 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6004889.68559 | 2106830.22133 | 37.7652309432866 | -122.426303875628 | (37.7652309432866, -122.426303875628) | 8 | 4 | 5 | 28853 | 19 | |||
135158 | 106776 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 769790 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.433805877135 | (37.7592732879998, -122.433805877135) | 2 | 4 | 5 | 28862 | 3 | ||
141507 | 208018 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1268 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994573.78905 | 2106877.28551 | 37.7647716613149 | -122.461987252204 | (37.7647716613149, -122.461987252204) | 15 | 5 | 11 | 56 | 12 | |||
144987 | 83293 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 25 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50806 | 6000965.01829306 | 2104898.82090875 | 37.7597051681424 | -122.439739849682 | (37.7597051681424, -122.439739849682) | 2 | 4 | 5 | 28862 | 3 | ||
147426 | 129682 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 2222 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999361.98488 | 2116489.37643 | 37.7914384953318 | -122.446117638238 | (37.7914384953318, -122.446117638238) | 13 | 6 | 1 | 29490 | 27 | |||
147675 | 5453 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 553 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6X6 | 6004986.22513 | 2105148.12108 | 37.7606177521254 | -122.425850225204 | (37.7606177521254, -122.425850225204) | 2 | 4 | 5 | 28859 | 19 | |||
150981 | 33035 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 494 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50595 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | 2 | 4 | 7 | 28859 | 19 | ||
151780 | 81485 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1268 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50894 | 5994575.83487134 | 2106890.23144341 | 37.764807325258 | -122.46198111515 | (37.764807325258, -122.46198111515) | 15 | 5 | 11 | 56 | 12 | ||
159422 | 208017 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 133 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993400.26342 | 2093895.06859 | 37.7290581627904 | -122.465103152187 | (37.7290581627904, -122.465103152187) | 9 | 8 | 4 | 59 | 40 | |||
171657 | 67048 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52417 | 6002670.77878077 | 2104705.7738753 | 37.7592720508615 | -122.433826678093 | (37.7592720508615, -122.433826678093) | 2 | 4 | 5 | 28862 | 3 | ||
178888 | 84061 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4297 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | 2 | 4 | 5 | 28862 | 22 | ||
180565 | 191510 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 900x Carolina St | 34 | Median : Yard | Tree | DPW 1 | 26 | 6012478.66144 | 2103273.09419 | 37.7558899046023 | -122.399805455861 | (37.7558899046023, -122.399805455861) | 10 | 3 | 8 | 28856 | 29 | ||||
189384 | 32238 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 800 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | 1 | Permit Number 35555 | 6009122.52689 | 2090393.35811 | 37.7203372759166 | -122.410502667675 | (37.7203372759166, -122.410502667675) | 9 | 3 | 7 | 309 | 28 | ||
3922 | 53770 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 316 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1996 12:00:00 AM | Permit Number 9456 | 5992852.04223281 | 2094739.01017834 | 37.7313437896565 | -122.46705971241 | (37.7313437896565, -122.46705971241) | 9 | 8 | 4 | 59 | 40 | ||
9578 | 66230 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29327 | 5994183.35951866 | 2090739.39799628 | 37.7204385809106 | -122.462167182155 | (37.7204385809106, -122.462167182155) | 9 | 8 | 6 | 28861 | 24 | ||
25552 | 62511 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 45 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22687 | 6000904.22158412 | 2103102.48758677 | 37.7547694133198 | -122.439821322061 | (37.7547694133198, -122.439821322061) | 2 | 4 | 5 | 28862 | 22 | ||
26743 | 63971 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 464 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1987 12:00:00 AM | 6002138.24458134 | 2101514.59186962 | 37.7504795961936 | -122.435440154372 | (37.7504795961936, -122.435440154372) | 2 | 4 | 5 | 28862 | 22 | |||
28603 | 58473 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 755 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 5x4 | Permit Number 32218 | 5998560.64278981 | 2107909.72137719 | 37.7678351944794 | -122.448272171383 | (37.7678351944794, -122.448272171383) | 15 | 5 | 11 | 29492 | 9 | |
34599 | 68571 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 680 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32462 | 5981371.58179768 | 2111111.81123309 | 37.7756295116497 | -122.507963735355 | (37.7756295116497, -122.507963735355) | 11 | 6 | 2 | 55 | 26 | ||
35505 | 63278 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 359 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23839 | 6006562.57447992 | 2104022.1319099 | 37.7576150041382 | -122.420318417009 | (37.7576150041382, -122.420318417009) | 2 | 4 | 7 | 28859 | 19 | ||
40355 | 55504 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 869 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | Permit Number 27152 | 6001313.84664035 | 2101330.48409718 | 37.7499272254089 | -122.438277790254 | (37.7499272254089, -122.438277790254) | 2 | 4 | 5 | 28862 | 22 | ||
40454 | 62510 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 40 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22686 | 6000851.23665541 | 2103119.64379278 | 37.7548135039581 | -122.440005788129 | (37.7548135039581, -122.440005788129) | 2 | 4 | 5 | 28862 | 22 | ||
42907 | 62266 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 107 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1994 12:00:00 AM | Permit Number 28558 | 6003332.16344898 | 2108632.83425409 | 37.7700923172623 | -122.431819689178 | (37.7700923172623, -122.431819689178) | 15 | 9 | 5 | 29492 | 9 | ||
44541 | 58468 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 32215 | 5998538.83594579 | 2108065.94626606 | 37.7682629016755 | -122.448358849843 | (37.7682629016755, -122.448358849843) | 15 | 5 | 11 | 29492 | 9 | ||
51621 | 65912 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1319 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28921 | 5994225.84250459 | 2106529.43291316 | 37.7637965106849 | -122.463165457674 | (37.7637965106849, -122.463165457674) | 1 | 5 | 11 | 56 | 12 | ||
52614 | 63253 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 347 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1987 12:00:00 AM | Permit Number 23805 | 6006558.34152348 | 2104089.11498703 | 37.7577986856169 | -122.420337810485 | (37.7577986856169, -122.420337810485) | 2 | 4 | 7 | 28859 | 19 | ||
52987 | 65742 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 156 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | Permit Number 28679 | 5999815.09781742 | 2087341.70418364 | 37.7114319377923 | -122.442456329735 | (37.7114319377923, -122.442456329735) | 9 | 7 | 6 | 28861 | 5 | ||
64320 | 67819 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 132 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31475 | 6004088.24128484 | 2102368.84156133 | 37.7529357200137 | -122.428757810552 | (37.7529357200137, -122.428757810552) | 2 | 4 | 5 | 28862 | 22 | ||
64895 | 65743 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 161 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | Permit Number 28700 | 5999869.91209267 | 2087340.5824876 | 37.7114319821081 | -122.442266797514 | (37.7114319821081, -122.442266797514) | 9 | 7 | 6 | 28861 | 5 | ||
69757 | 95667 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 800 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767425 | 6009127.32448 | 2090380.00742 | 37.7203008866705 | -122.410485141671 | (37.7203008866705, -122.410485141671) | 9 | 3 | 7 | 309 | 28 |
70688 | 66576 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 183 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | Permit Number 29766 | 6004051.78498145 | 2092614.17435811 | 37.7261495673942 | -122.428188753915 | (37.7261495673942, -122.428188753915) | 9 | 7 | 6 | 28861 | 5 | ||
71276 | 67953 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 587 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31669 | 5988423.51616993 | 2112003.2558784 | 37.7784901524227 | -122.483635032376 | (37.7784901524227, -122.483635032376) | 11 | 6 | 2 | 55 | 26 | ||
71365 | 48403 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 137 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2002 12:00:00 AM | Permit Number 45784 | 5999838.90671346 | 2087440.10998802 | 37.7117034951385 | -122.442381100461 | (37.7117034951385, -122.442381100461) | 9 | 7 | 6 | 28861 | 5 | ||
72201 | 65741 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 150 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | Permit Number 28678 | 5999807.34647383 | 2087366.58605487 | 37.7114998160049 | -122.442484905562 | (37.7114998160049, -122.442484905562) | 9 | 7 | 6 | 28861 | 5 | ||
74496 | 39790 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 50 San Jose Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/1999 12:00:00 AM | Permit Number 41142 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
82575 | 66929 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 175 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1992 12:00:00 AM | Permit Number 31181 | 6007601.16481288 | 2097856.63104946 | 37.7407443985359 | -122.416289861454 | (37.7407443985359, -122.416289861454) | 2 | 7 | 7 | 28859 | 2 | ||
83737 | 65740 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 131 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | Permit Number 28676 | 5999831.15536745 | 2087464.99186701 | 37.7117713733875 | -122.442409676333 | (37.7117713733875, -122.442409676333) | 9 | 7 | 6 | 28861 | 5 | ||
87330 | 68388 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4977 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 15 | Permit Number 32213 | 5997544.8295208 | 2105597.02046098 | 37.7614269792514 | -122.451618890925 | (37.7614269792514, -122.451618890925) | 15 | 5 | 11 | 29492 | 12 | |
89791 | 64486 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 1760 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/1995 12:00:00 AM | Permit Number 25361 | 6009183.88964129 | 2119335.0439705 | 37.7998079955543 | -122.412335123816 | (37.7998079955543, -122.412335123816) | 3 | 1 | 10 | 308 | 4 | ||
91414 | 63800 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 98 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 30485 | 6009121.91960633 | 2096902.39222229 | 37.7382096636994 | -122.410964264052 | (37.7382096636994, -122.410964264052) | 10 | 7 | 7 | 28859 | 2 | ||
93733 | 64791 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 235 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1995 12:00:00 AM | Permit Number 25787 | 6002748.20782442 | 2109342.92244592 | 37.7720089245306 | -122.433890345377 | (37.7720089245306, -122.433890345377) | 15 | 5 | 11 | 29492 | 9 | ||
106722 | 65252 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 992 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28051 | 6009395.74802139 | 2103403.69283522 | 37.7560761510907 | -122.41047644187 | (37.7560761510907, -122.41047644187) | 2 | 4 | 7 | 28859 | 19 | ||
112822 | 58827 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 761 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 18081 | 5998566.09450379 | 2107870.66513368 | 37.7677282676072 | -122.448250501912 | (37.7677282676072, -122.448250501912) | 15 | 5 | 11 | 29492 | 9 | ||
118316 | 67336 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 616 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1992 12:00:00 AM | Permit Number 30820 | 5993805.86166428 | 2111291.38109791 | 37.7768473564115 | -122.464963895393 | (37.7768473564115, -122.464963895393) | 11 | 6 | 2 | 54 | 11 | ||
122626 | 59346 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 526 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1996 12:00:00 AM | Permit Number 18694 | 6000169.01235763 | 2110692.10451001 | 37.7755667359424 | -122.442908856545 | (37.7755667359424, -122.442908856545) | 15 | 5 | 11 | 29492 | 16 | ||
124543 | 62513 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 48 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22689 | 6000852.895877 | 2103088.41664199 | 37.7547278562227 | -122.439997811128 | (37.7547278562227, -122.439997811128) | 2 | 4 | 5 | 28862 | 22 | ||
126887 | 59007 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1993 12:00:00 AM | Permit Number 29743 | 6005443.80886724 | 2104276.22523779 | 37.7582495793176 | -122.424205638431 | (37.7582495793176, -122.424205638431) | 2 | 4 | 5 | 28859 | 19 | ||
127845 | 62512 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 47 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22688 | 6000904.62792341 | 2103094.84013439 | 37.7547484383972 | -122.439819368565 | (37.7547484383972, -122.439819368565) | 2 | 4 | 5 | 28862 | 22 | ||
129687 | 59580 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 157 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1981 12:00:00 AM | Permit Number 18972 | 6004144.08144051 | 2102300.97252485 | 37.7527525277972 | -122.42855986736 | (37.7527525277972, -122.42855986736) | 2 | 4 | 5 | 28862 | 22 | ||
130603 | 65358 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 123 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28193 | 6001809.60745082 | 2096649.18793885 | 37.7371016703992 | -122.436228455773 | (37.7371016703992, -122.436228455773) | 2 | 7 | 5 | 63 | 7 | ||
139277 | 65699 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 201 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1990 12:00:00 AM | Permit Number 28628 | 6000097.30491035 | 2087663.87118265 | 37.7123326179359 | -122.441504055389 | (37.7123326179359, -122.441504055389) | 9 | 7 | 6 | 28861 | 5 | ||
142299 | 68802 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 39 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32743 | 5993216.60176137 | 2098854.68485021 | 37.7426654396593 | -122.46609833981 | (37.7426654396593, -122.46609833981) | 1 | 8 | 4 | 59 | 40 | ||
145232 | 68390 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 751 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32217 | 5998557.00831722 | 2107935.75884853 | 37.767906478991 | -122.448286617718 | (37.767906478991, -122.448286617718) | 15 | 5 | 11 | 29492 | 9 | ||
146301 | 68572 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 685 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32463 | 5981320.71250249 | 2111079.78815826 | 37.7755385883149 | -122.508137324272 | (37.7755385883149, -122.508137324272) | 11 | 6 | 2 | 55 | 26 | ||
152449 | 60827 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 4248 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 25330 | 6001569.00146643 | 2102360.55614987 | 37.7527700660107 | -122.437469208461 | (37.7527700660107, -122.437469208461) | 2 | 4 | 5 | 28862 | 22 | ||
155017 | 41375 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 174 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2000 12:00:00 AM | Permit Number 42012 | 5999838.35184821 | 2087267.05856995 | 37.7112283031088 | -122.442370602567 | (37.7112283031088, -122.442370602567) | 9 | 7 | 6 | 28861 | 5 | ||
161985 | 67695 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 64 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1995 12:00:00 AM | Permit Number 32214 | 5998556.66816134 | 2105411.31929459 | 37.7609749843529 | -122.448106005057 | (37.7609749843529, -122.448106005057) | 15 | 5 | 11 | 29492 | 12 | ||
171665 | 63076 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 199 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23555 | 6007806.32049195 | 2098166.67321626 | 37.7416072398469 | -122.415602454818 | (37.7416072398469, -122.415602454818) | 2 | 7 | 7 | 28859 | 2 | ||
171716 | 63249 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 348 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1986 12:00:00 AM | Permit Number 23801 | 6006507.15053837 | 2104074.67156974 | 37.7577561425846 | -122.420513825277 | (37.7577561425846, -122.420513825277) | 2 | 4 | 7 | 28859 | 19 | ||
185415 | 63252 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 329 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1987 12:00:00 AM | Permit Number 23804 | 6006551.99209013 | 2104189.58958185 | 37.7580742077609 | -122.420366900872 | (37.7580742077609, -122.420366900872) | 2 | 4 | 7 | 28859 | 19 | ||
190910 | 62509 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 30 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22685 | 6000849.16262918 | 2103158.67771698 | 37.7549205635855 | -122.440015759403 | (37.7549205635855, -122.440015759403) | 2 | 4 | 5 | 28862 | 22 |
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) );