trees
6,714 rows where qSpecies_id = 7 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25990 | 93977 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Loraine Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Tree 2 on Anza. | 5996139.98903 | 2112289.25125 | 37.7797215523196 | -122.45696168713 | (37.7797215523196, -122.45696168713) | 11 | 6 | 2 | 54 | 16 | ||
151285 | 54234 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1270 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2010 12:00:00 AM | Permit Number 9974 | 5995196.04681137 | 2106906.46154553 | 37.7648875762272 | -122.459837152742 | (37.7648875762272, -122.459837152742) | 15 | 5 | 11 | 56 | 12 | ||
152024 | 54057 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 874 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | 8 | Permit Number 9779 | 5985134.071 | 2109910.10647 | 37.7725509445557 | -122.494859930916 | (37.7725509445557, -122.494859930916) | 11 | 6 | 2 | 55 | 26 | ||
173391 | 54020 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 862 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1972 12:00:00 AM | 13 | Permit Number 9739 | 5985131.43408 | 2109993.46709 | 37.7727796747305 | -122.494875199577 | (37.7727796747305, -122.494875199577) | 11 | 6 | 2 | 55 | 26 | ||
194411 | 236860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 785228 | 5996892.19398 | 2106024.42834 | 37.7625631359112 | -122.453906940775 | (37.7625631359112, -122.453906940775) | 15 | 5 | 11 | 29492 | 12 | ||
15943 | 236821 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 24 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | Permit Number 785021 | 5997068.53221 | 2106495.97306 | 37.7638679865405 | -122.453331099472 | (37.7638679865405, -122.453331099472) | 15 | 5 | 11 | 29492 | 12 | ||
6471 | 237657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4187 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 784809 | 6002500.86643 | 2104117.7916 | 37.7576479497003 | -122.434372278263 | (37.7576479497003, -122.434372278263) | 2 | 4 | 5 | 28862 | 3 | ||
9045 | 217860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1525 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 784373 | 5996862.66566 | 2105957.03699 | 37.7623764033599 | -122.454004200645 | (37.7623764033599, -122.454004200645) | 15 | 5 | 11 | 29492 | 12 | ||
16495 | 236652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 22 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 783263 | 6006034.30532 | 2103480.29783 | 37.7560974717362 | -122.422106897024 | (37.7560974717362, -122.422106897024) | 2 | 4 | 5 | 28859 | 19 | ||
8662 | 236510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 281 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | Permit Number 783074 | 6008991.12721 | 2097033.14308 | 37.7385613420185 | -122.411425715645 | (37.7385613420185, -122.411425715645) | 10 | 7 | 7 | 28859 | 2 | ||
16759 | 55973 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2221 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | Permit Number 783032 | 6003231.299 | 2116343.71442 | 37.7912587469411 | -122.432719482638 | (37.7912587469411, -122.432719482638) | 13 | 9 | 1 | 29490 | 27 | ||
4793 | 235921 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2549 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | Permit Number 782939 | 6010182.2586 | 2105017.82125 | 37.7605522464049 | -122.407870229727 | (37.7605522464049, -122.407870229727) | 10 | 4 | 8 | 28859 | 19 | ||
73018 | 235900 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3700 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 782553 | 6005547.98467 | 2104328.13741 | 37.7583979995899 | -122.423849043905 | (37.7583979995899, -122.423849043905) | 2 | 4 | 5 | 28859 | 19 | ||
89155 | 32622 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3521 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/2018 12:00:00 AM | 3 | Permit Number 782132 | 5997997.08435 | 2115134.3077 | 37.787639797681 | -122.450742402761 | (37.787639797681, -122.450742402761) | 11 | 6 | 1 | 54 | 31 | |
123794 | 43548 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1857 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/2018 12:00:00 AM | 3 | Permit Number 782038 | 6000253.363 | 2111274.4996 | 37.7771706534548 | -122.442658894423 | (37.7771706534548, -122.442658894423) | 15 | 5 | 11 | 29492 | 16 | |
16964 | 264738 | Section 806 (d) 5 | Prunus cerasifera :: Cherry Plum 7 | 2722 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/29/2020 12:00:00 AM | 3 | 3x6 | Permit Number 781841 | 5983409.1923 | 2096639.50516 | 37.7360124610612 | -122.499845290879 | (37.7360124610612, -122.499845290879) | 1 | 8 | 3 | 29491 | 35 | |
124127 | 4189 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/1998 12:00:00 AM | 6 | 3X3 | Permit Number 781750 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | 2 | 4 | 5 | 63 | 22 | |
56376 | 139521 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1694 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781558 | 5999688.4135 | 2110903.3047 | 37.7761192260042 | -122.444586541828 | (37.7761192260042, -122.444586541828) | 15 | 5 | 11 | 29492 | 16 | |
125784 | 236262 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 824 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 781410 | 6009352.78205 | 2104341.55355 | 37.7586488960466 | -122.410691262694 | (37.7586488960466, -122.410691262694) | 2 | 4 | 7 | 28859 | 19 | ||
47745 | 237505 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 932 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 781043 | 6003738.00119 | 2102839.48332 | 37.7542081624992 | -122.430002576781 | (37.7542081624992, -122.430002576781) | 2 | 4 | 5 | 28862 | 22 | |
24182 | 217988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2639 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780707 | 5990786.59635 | 2097418.05081 | 37.7385803177224 | -122.474395696709 | (37.7385803177224, -122.474395696709) | 1 | 8 | 4 | 29491 | 40 | |
194288 | 264990 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
194289 | 264993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993487.77014 | 2106611.56006 | 37.7639794646992 | -122.465724170953 | (37.7639794646992, -122.465724170953) | 1 | 8 | 11 | 56 | 12 | |
194290 | 264989 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
194292 | 214534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
194310 | 264995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194311 | 264987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
194312 | 264991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
194314 | 214535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194315 | 264988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
194317 | 264994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194320 | 206251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 05:08:00 PM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
170271 | 50319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 207 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Permit Number 780459 | 5994858.57459 | 2113511.06459 | 37.7830026560888 | -122.461483229537 | (37.7830026560888, -122.461483229537) | 11 | 6 | 2 | 54 | 11 | ||
169915 | 246983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | Permit Number 779954 | 6004884.23476 | 2101078.02552 | 37.7494364577399 | -122.425913236212 | (37.7494364577399, -122.425913236212) | 2 | 4 | 5 | 28862 | 22 | ||
51782 | 236727 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1616 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 779934 | 6002562.04117 | 2100731.79845 | 37.7483542900352 | -122.433918688992 | (37.7483542900352, -122.433918688992) | 2 | 4 | 5 | 28862 | 22 | ||
2669 | 248462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 779787 | 5997458.098 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | 15 | 5 | 11 | 29492 | 9 | ||
184814 | 238568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | 2 | 4 | 5 | 63 | 22 | |
87915 | 237516 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1004 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779660 | 6003758.05774 | 2102389.16893 | 37.752972841143 | -122.429901097271 | (37.752972841143, -122.429901097271) | 2 | 4 | 5 | 28862 | 22 | |
56581 | 122896 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 263 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004832 | 2098951 | 37.7435931826557 | -122.425942474759 | (37.7435931826557, -122.425942474759) | 2 | 7 | 5 | 63 | 22 | ||
56907 | 62845 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 263 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | 2 | 7 | 5 | 63 | 22 | ||
73867 | 122897 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 263 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | 2 | 7 | 5 | 63 | 22 | ||
148191 | 32469 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593 | 2105649 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | 15 | 5 | 5 | 28862 | 3 | |
136720 | 121400 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3998X 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912 | 2101337 | 37.7500925484643 | -122.429293713772 | (37.7500925484643, -122.429293713772) | 2 | 4 | 5 | 28862 | 22 | |
163662 | 121401 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3998X 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912 | 2101337 | 37.7500925484643 | -122.429293713772 | (37.7500925484643, -122.429293713772) | 2 | 4 | 5 | 28862 | 22 | |
12184 | 243309 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 780 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 10:07:00 AM | 0 | Width 3ft | Permit Number 779025 | 6007491.90913 | 2105126.68883 | 37.7607001866898 | -122.417182659168 | (37.7607001866898, -122.417182659168) | 2 | 4 | 7 | 28859 | 19 | |
30703 | 121633 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.43173 | 37.7149880967002 | -122.43413431136 | (37.7149880967002, -122.43413431136) | 9 | 7 | 6 | 28861 | 5 | |
50566 | 121239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.0724 | 2113967.4603 | 37.7843501979957 | -122.455833899065 | (37.7843501979957, -122.455833899065) | 11 | 6 | 1 | 54 | 31 | |
106938 | 121240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.4108 | 2113948.5087 | 37.7842981813685 | -122.455831357874 | (37.7842981813685, -122.455831357874) | 11 | 6 | 1 | 54 | 31 | |
112895 | 38094 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | 15 | 6 | 1 | 29490 | 31 | |
55211 | 64255 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 224 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | 8 | Permit Number 778662 | 6004470.35805114 | 2098718.34053249 | 37.7429339083051 | -122.427176375442 | (37.7429339083051, -122.427176375442) | 2 | 7 | 5 | 63 | 22 | |
44897 | 37251 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3956 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2016 12:00:00 AM | 3 | Permit Number 778657 | 6003965.79227695 | 2104246.29716673 | 37.7580838387743 | -122.42931513025 | (37.7580838387743, -122.42931513025) | 2 | 4 | 5 | 28862 | 3 | |
65756 | 110275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2612 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778382 | 6001183.56283 | 2117454.33561 | 37.794191876798 | -122.43988424377 | (37.794191876798, -122.43988424377) | 13 | 9 | 1 | 57 | 27 | ||
175043 | 49474 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2612 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | 3 | Permit Number 778382 | 6001188.38101 | 2117426.72551 | 37.7941163409457 | -122.439865591834 | (37.7941163409457, -122.439865591834) | 13 | 9 | 1 | 57 | 27 | ||
113693 | 39082 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3700 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2016 12:00:00 AM | 3 | Permit Number 778242 | 6005630.70572311 | 2104338.6748817 | 37.7584316025475 | -122.423563706662 | (37.7584316025475, -122.423563706662) | 2 | 4 | 5 | 28859 | 19 | |
135815 | 116159 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2660 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x5 | Permit Number 777886 | 6000321.54837 | 2117859.43879 | 37.7952550769057 | -122.442896004055 | (37.7952550769057, -122.442896004055) | 13 | 9 | 1 | 57 | 17 | |
28653 | 32772 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 555 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.441492045083 | (37.7760031430575, -122.441492045083) | 15 | 5 | 11 | 29492 | 16 | ||
96979 | 32773 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 555 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.441492045083 | (37.7760031430575, -122.441492045083) | 15 | 5 | 11 | 29492 | 16 | ||
175947 | 114492 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 1 | 3x3 | Permit Number 777002 | 6014200.75816 | 2111763.05938 | 37.7792973266569 | -122.394444280578 | (37.7792973266569, -122.394444280578) | 6 | 2 | 9 | 28856 | 34 | |
52945 | 117454 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | |
67732 | 68521 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.7752702616141 | -122.459497105638 | (37.7752702616141, -122.459497105638) | 11 | 6 | 2 | 54 | 11 | |
162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
137684 | 69479 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1875 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/2015 12:00:00 AM | 3 | Permit Number 775176 | 5993735.88293516 | 2102744.9511731 | 37.753377067666 | -122.464585247952 | (37.753377067666, -122.464585247952) | 1 | 8 | 4 | 56 | 12 | |
140507 | 108205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2014 12:00:00 AM | 3 | Permit Number 774208 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | ||
13711 | 50946 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | 5 | 1 | 10 | 28858 | 32 | ||
33146 | 108559 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.436125873507 | (37.7300263216596, -122.436125873507) | 9 | 7 | 6 | 28861 | 25 |
103181 | 55604 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 658 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 1 | Permit Number 773340 | 5982601.78539 | 2111293.43809 | 37.7762006139918 | -122.503721684505 | (37.7762006139918, -122.503721684505) | 11 | 6 | 2 | 55 | 26 | ||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
119169 | 117250 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | 13 | 9 | 1 | 57 | 27 | |
190527 | 106859 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | 10 | 3 | 8 | 28856 | 29 | ||
147374 | 108944 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 105 Richland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |
157018 | 46366 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 105 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005231.58018962 | 2096222.89831587 | 37.7361250059804 | -122.424366825083 | (37.7361250059804, -122.424366825083) | 2 | 7 | 7 | 28859 | 2 | |
170643 | 61601 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 41 Temescal Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/1984 12:00:00 AM | Permit Number 771041 | 5997430.33539748 | 2111463.9976056 | 37.7775296345883 | -122.452438269997 | (37.7775296345883, -122.452438269997) | 15 | 6 | 2 | 54 | 16 | ||
38736 | 103621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.80986 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | 11 | 6 | 1 | 54 | 31 | |
88605 | 105252 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.430012644752 | (37.7977291534815, -122.430012644752) | 13 | 9 | 1 | 57 | 17 | ||||
102439 | 33470 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 770772 | 6006658.5962402 | 2099060.66654687 | 37.7439973628671 | -122.419634320147 | (37.7439973628671, -122.419634320147) | 2 | 7 | 7 | 28859 | 2 | |||
47525 | 105287 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770757 | 6000732.18991 | 2118218.38629 | 37.7962640551003 | -122.441500892961 | (37.7962640551003, -122.441500892961) | 13 | 9 | 1 | 57 | 17 | ||
85846 | 30870 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.7879711376069 | -122.436932736614 | (37.7879711376069, -122.436932736614) | 13 | 6 | 1 | 29490 | 27 | |
28332 | 65077 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2472 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2016 12:00:00 AM | 1 | Permit Number 770324 | 6008829.8770174 | 2104068.83442406 | 37.7578707396144 | -122.412480435255 | (37.7578707396144, -122.412480435255) | 2 | 4 | 7 | 28859 | 19 | ||
184647 | 51006 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1262 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 770221 | 5987105.8451 | 2106709.4716 | 37.7638781152555 | -122.487804258623 | (37.7638781152555, -122.487804258623) | 1 | 8 | 3 | 56 | 35 | |
74062 | 106161 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.32366 | 37.8055893943007 | -122.420884191365 | (37.8055893943007, -122.420884191365) | 5 | 1 | 1 | 28858 | 32 | |
114867 | 33993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2034 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001441.2983 | 2115588.39061 | 37.7890831439105 | -122.438858673106 | (37.7890831439105, -122.438858673106) | 13 | 6 | 1 | 29490 | 27 | ||
19962 | 41358 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |
74575 | 41359 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |
103688 | 38787 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 564 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2013 12:00:00 AM | 3 | Permit Number 769972 | 6013384.96932 | 2111589.18475 | 37.7787745228569 | -122.397254257292 | (37.7787745228569, -122.397254257292) | 6 | 2 | 9 | 28856 | 34 | |
117225 | 102628 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | 6 | 2 | 9 | 28856 | 34 | |
179772 | 41360 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 564 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |||
127904 | 102986 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1459 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2013 12:00:00 AM | 3x3 | Permit Number 769945 | 5996811.8 | 2106244.7 | 37.7631633360428 | -122.45420090344 | (37.7631633360428, -122.45420090344) | 15 | 5 | 11 | 29492 | 12 | ||
34084 | 102045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999896.35932 | 2117404.6933 | 37.7939822160532 | -122.444334525426 | (37.7939822160532, -122.444334525426) | 13 | 9 | 1 | 57 | 27 | ||
161913 | 102047 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999920.96714 | 2117404.74534 | 37.7939837628837 | -122.444249383927 | (37.7939837628837, -122.444249383927) | 13 | 9 | 1 | 57 | 27 | ||
93670 | 95603 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769429 | 5993376.02287 | 2113174.3502 | 37.7819926868669 | -122.466587723775 | (37.7819926868669, -122.466587723775) | 11 | 6 | 2 | 54 | 11 | |
95355 | 95606 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769429 | 5993379.4788 | 2113094.52593 | 37.7817737105334 | -122.466569964084 | (37.7817737105334, -122.466569964084) | 11 | 6 | 2 | 54 | 11 | |
186258 | 101623 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 80 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/2012 12:00:00 AM | 4x4 | Permit Number 769409 | 6000945.5 | 2101263.6 | 37.7497226204904 | -122.439546753899 | (37.7497226204904, -122.439546753899) | 2 | 4 | 5 | 28862 | 22 | |
66958 | 66162 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 198x Venus St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2012 12:00:00 AM | 1 | 2x2 | Permit Number 769335 | 6012793.61205 | 2093996.0268 | 37.7304345958639 | -122.398065452068 | (37.7304345958639, -122.398065452068) | 10 | 3 | 8 | 58 | 1 |
125647 | 97459 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 198x Venus St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2012 12:00:00 AM | 7 | 3x3 | Permit Number 769335 | 6012779.45987 | 2093933.74506 | 37.7302627947816 | -122.398110010771 | (37.7302627947816, -122.398110010771) | 10 | 3 | 8 | 58 | 1 | |
108088 | 98173 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2061 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769212 | 5999384.05181 | 2115955.03644 | 37.7899725985939 | -122.446002837966 | (37.7899725985939, -122.446002837966) | 13 | 6 | 1 | 29490 | 31 | |
133268 | 100349 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 551 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769104 | 6002969.98856 | 2090393.63163 | 37.7199911835241 | -122.431769984714 | (37.7199911835241, -122.431769984714) | 9 | 7 | 6 | 28861 | 5 | |
29267 | 98663 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 388 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013484.27433 | 2110492.11239 | 37.7757677394235 | -122.396833785577 | (37.7757677394235, -122.396833785577) | 6 | 2 | 9 | 28856 | 34 | |
168517 | 98664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 388 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013470.34035 | 2110479.34444 | 37.7757319059416 | -122.396881091699 | (37.7757319059416, -122.396881091699) | 6 | 2 | 9 | 28856 | 34 | |
176371 | 98662 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 388 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769043 | 6013504.77165 | 2110513.20608 | 37.775826798791 | -122.396764358806 | (37.775826798791, -122.396764358806) | 6 | 2 | 9 | 28856 | 34 | |
55256 | 99870 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2244 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768957 | 6002355.52291 | 2116016.09819 | 37.7903094900332 | -122.435726190525 | (37.7903094900332, -122.435726190525) | 13 | 9 | 1 | 29490 | 27 |
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) );