trees
11,761 rows where qSpecies_id = 17 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
195 | 101535 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
309 | 40920 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
419 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | 6009421 | 2110873 | 37.7765865656959 | -122.410916638665 | (37.7765865656959, -122.410916638665) | 8 | 2 | 9 | 28853 | 34 | |||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
777 | 84774 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
928 | 67058 | Permitted Site 7 | Tree(s) :: 17 | 180 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1992 12:00:00 AM | 3x3 | Permit Number 30439 | 6009767.36044891 | 2111443.36861251 | 37.7781720795529 | -122.409758741886 | (37.7781720795529, -122.409758741886) | 8 | 2 | 9 | 28853 | 34 | ||
949 | 38398 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
1381 | 84767 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
2436 | 102404 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
2499 | 55575 | Permitted Site 7 | Tree(s) :: 17 | 622 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | Permit Number 11546 | 6010538.99497753 | 2108399.45644768 | 37.7698574135988 | -122.40687477594 | (37.7698574135988, -122.40687477594) | 8 | 2 | 9 | 28853 | 19 | |||
2733 | 107738 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
3301 | 102850 | Undocumented 4 | Tree(s) :: 17 | 25X Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
4131 | 38411 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
4782 | 50976 | Permitted Site 7 | Tree(s) :: 17 | 683 REVISED Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | Permit Number 47463 | 6012417.01604771 | 2110263.6615562 | 37.775081003703 | -122.40050967291 | (37.775081003703, -122.40050967291) | 14 | 2 | 9 | 28856 | 20 | |||
5579 | 50971 | Permitted Site 7 | Tree(s) :: 17 | 683 REVISED Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | Permit Number 47463 | 6012417.01604771 | 2110263.6615562 | 37.775081003703 | -122.40050967291 | (37.775081003703, -122.40050967291) | 14 | 2 | 9 | 28856 | 20 | |||
6214 | 188143 | DPW Maintained 1 | Tree(s) :: 17 | 1050 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781453 | 6015462.26121 | 2109813.47257 | 37.7740142422074 | -122.389943956153 | (37.7740142422074, -122.389943956153) | 14 | 3 | 9 | 310 | 20 | |
6417 | 84770 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
6762 | 260431 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
7228 | 65038 | Permitted Site 7 | Tree(s) :: 17 | 153 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1989 12:00:00 AM | Permit Number 26090 | 6014916.9048923 | 2116605.4476944 | 37.7926332027205 | -122.392305584841 | (37.7926332027205, -122.392305584841) | 12 | 2 | 9 | 28855 | 6 | |||
7276 | 84766 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
7408 | 53652 | Permitted Site 7 | Tree(s) :: 17 | 831 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6588 | 6012089.84873388 | 2112576.989681 | 37.781414618516 | -122.401804066947 | (37.781414618516, -122.401804066947) | 6 | 2 | 9 | 28856 | 34 | |||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7797 | 30672 | DPW Maintained 1 | Tree(s) :: 17 | 39 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 0 | Permit Number 34597 | 6006376.8548 | 2109111.02835 | 37.7715774481695 | -122.421322084747 | (37.7715774481695, -122.421322084747) | 8 | 2 | 9 | 28853 | 19 | |
7885 | 57193 | Permitted Site 7 | Tree(s) :: 17 | 633 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1974 12:00:00 AM | Permit Number 14473 | 6007510.46945444 | 2113541.05571027 | 37.7838050881462 | -122.417714890881 | (37.7838050881462, -122.417714890881) | 7 | 9 | 9 | 28858 | 36 | |||
7888 | 84764 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
7931 | 260390 | Undocumented 4 | Tree(s) :: 17 | 501x Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009931 | 2112548 | 37.7812143059327 | -122.409270622322 | (37.7812143059327, -122.409270622322) | 14 | 2 | 9 | 28853 | 34 | ||||
8436 | 260432 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
8714 | 65277 | Permitted Site 7 | Tree(s) :: 17 | 413 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | Permit Number 28080 | 6011259.0467766 | 2112359.25955834 | 37.7807703835022 | -122.404662921728 | (37.7807703835022, -122.404662921728) | 14 | 2 | 9 | 28853 | 34 | |||
9632 | 91051 | Permitted Site 7 | Tree(s) :: 17 | 750 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51965 | 6012124 | 2113544 | 37.7840717096161 | -122.401753911211 | (37.7840717096161, -122.401753911211) | 12 | 2 | 9 | 28853 | 6 | ||
9826 | 55790 | Permitted Site 7 | Tree(s) :: 17 | 81 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1973 12:00:00 AM | Permit Number 11831 | 6013029.07044422 | 2114920.75129783 | 37.7879024142259 | -122.39871932399 | (37.7879024142259, -122.39871932399) | 12 | 2 | 9 | 28855 | 6 | |||
11321 | 57873 | Permitted Site 7 | Tree(s) :: 17 | 230 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 16819 | 6009047.83782132 | 2113329.34235578 | 37.7833101664213 | -122.412381181992 | (37.7833101664213, -122.412381181992) | 14 | 10 | 9 | 28852 | 36 | |||
11433 | 44087 | DPW Maintained 1 | Tree(s) :: 17 | 500 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013716.56338 | 2112456.73733 | 37.7811750796017 | -122.396167952707 | (37.7811750796017, -122.396167952707) | 6 | 2 | 9 | 28856 | 34 | |
12099 | 102848 | Undocumented 4 | Tree(s) :: 17 | 31 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
12274 | 56690 | Permitted Site 7 | Tree(s) :: 17 | 55 Hallam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010204.8585712 | 2110471.70826771 | 37.7755286348545 | -122.408176723323 | (37.7755286348545, -122.408176723323) | 8 | 2 | 9 | 28853 | 34 | |||||
12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
12401 | 53714 | Permitted Site 7 | Tree(s) :: 17 | 455 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1970 12:00:00 AM | Permit Number 6662 | 6010362.97418755 | 2109585.6917484 | 37.7731046912712 | -122.407567278306 | (37.7731046912712, -122.407567278306) | 14 | 2 | 9 | 28853 | 34 | |||
12696 | 100611 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
15565 | 49257 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 46 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
15642 | 102891 | Undocumented 4 | Tree(s) :: 17 | 115 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008968 | 2112966 | 37.7823080347026 | -122.412631696322 | (37.7823080347026, -122.412631696322) | 7 | 10 | 9 | 28852 | 36 | ||||
15960 | 55933 | Permitted Site 7 | Tree(s) :: 17 | 310 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1973 12:00:00 AM | Permit Number 11997 | 6010418.97594048 | 2110762.00487397 | 37.7763377085644 | -122.407456507 | (37.7763377085644, -122.407456507) | 8 | 2 | 9 | 28853 | 34 | |||
16125 | 260551 | DPW Maintained 1 | Tree(s) :: 17 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011850 | 2111438 | 37.7782738288903 | -122.402553714468 | (37.7782738288903, -122.402553714468) | 14 | 2 | 9 | 28856 | 34 | ||||
17247 | 84762 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
17700 | 260555 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 502 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | 3x3 | 6011196 | 2109910 | 37.7740417608934 | -122.404708555539 | (37.7740417608934, -122.404708555539) | 14 | 2 | 9 | 28853 | 34 | ||
18541 | 59635 | Permitted Site 7 | Tree(s) :: 17 | 1259 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1981 12:00:00 AM | Permit Number 19043 | 6009406.34901547 | 2110013.01200278 | 37.7742244188782 | -122.410906566948 | (37.7742244188782, -122.410906566948) | 8 | 2 | 9 | 28853 | 34 | |||
18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
19790 | 49279 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
19976 | 196623 | DPW Maintained 1 | Tree(s) :: 17 | 147 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780162 | 6012460.77279 | 2114398.06463 | 37.7864355596035 | -122.40064880949 | (37.7864355596035, -122.40064880949) | 12 | 2 | 9 | 28855 | 6 | |
20066 | 37539 | Permitted Site 7 | Tree(s) :: 17 | 628 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2016 12:00:00 AM | 3 | Permit Number 778105 | 6008253.13567923 | 2114173.25091992 | 37.7855827074661 | -122.415190301446 | (37.7855827074661, -122.415190301446) | 13 | 10 | 9 | 28858 | 36 | |
20171 | 100589 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
20195 | 90386 | DPW Maintained 1 | Tree(s) :: 17 | 20 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2013 03:31:00 PM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
20525 | 101542 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
20613 | 84757 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
21485 | 49742 | Permitted Site 7 | Tree(s) :: 17 | 168@ 7th ST Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | Permit Number 46541 | 6010500.77437562 | 2110361.0006442 | 37.7752412222943 | -122.40714526895 | (37.7752412222943, -122.40714526895) | 8 | 2 | 9 | 28853 | 34 | |||
21531 | 88177 | Permitted Site 7 | Tree(s) :: 17 | 430X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
21785 | 49268 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 45 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
21995 | 111152 | Undocumented 4 | Tree(s) :: 17 | 600X MINNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009435 | 2111668 | 37.7787702333332 | -122.410924371776 | (37.7787702333332, -122.410924371776) | 8 | 2 | 9 | 28853 | 34 | ||||
22051 | 64945 | Permitted Site 7 | Tree(s) :: 17 | 560 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1989 12:00:00 AM | Permit Number 25976 | 6011431.97989794 | 2109702.7540465 | 37.7734858975425 | -122.403877669536 | (37.7734858975425, -122.403877669536) | 14 | 2 | 9 | 28853 | 34 | |||
22059 | 49284 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
22459 | 39880 | Permitted Site 7 | Tree(s) :: 17 | 21 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | |||
22868 | 55309 | Permitted Site 7 | Tree(s) :: 17 | 712 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1972 12:00:00 AM | Permit Number 11238 | 6008298.27714903 | 2114528.21620005 | 37.7865598929067 | -122.415059258699 | (37.7865598929067, -122.415059258699) | 13 | 1 | 9 | 28858 | 36 | |||
23081 | 40913 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
23606 | 49271 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
23833 | 100765 | Undocumented 4 | Tree(s) :: 17 | 5 Bernice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008581 | 2108519.7 | 37.7700778198991 | -122.413655963874 | (37.7700778198991, -122.413655963874) | 8 | 2 | 9 | 28853 | 19 | |||
24331 | 104226 | Undocumented 4 | Tree(s) :: 17 | 183 FREMONT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 770922 | 6014030 | 2115507 | 37.7895678338506 | -122.395297348866 | (37.7895678338506, -122.395297348866) | 12 | 2 | 9 | 28855 | 6 | ||
24386 | 59570 | Permitted Site 7 | Tree(s) :: 17 | 1155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/1981 12:00:00 AM | Permit Number 18960 | 6009094.34061337 | 2111467.64595734 | 37.7782010006024 | -122.412088687228 | (37.7782010006024, -122.412088687228) | 8 | 2 | 9 | 28853 | 34 | |||
24589 | 40918 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
25257 | 124734 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
25394 | 100640 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
25602 | 31834 | Permitted Site 7 | Tree(s) :: 17 | 237 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35291 | 6009638.9380413 | 2109067.0653134 | 37.7716401088856 | -122.41003520239 | (37.7716401088856, -122.41003520239) | 8 | 2 | 9 | 28853 | 34 | ||
25649 | 64240 | Permitted Site 7 | Tree(s) :: 17 | 180 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1988 12:00:00 AM | Permit Number 25033 | 6014737.04047994 | 2116199.70520278 | 37.7915091389598 | -122.392899527583 | (37.7915091389598, -122.392899527583) | 12 | 2 | 9 | 28855 | 6 | |||
26498 | 100620 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
26515 | 102395 | Undocumented 4 | Tree(s) :: 17 | 30X Harriet St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010362 | 2111859 | 37.7793466114027 | -122.407730971847 | (37.7793466114027, -122.407730971847) | 14 | 2 | 9 | 28853 | 34 | ||||
26537 | 102408 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
26755 | 100057 | Undocumented 4 | Tree(s) :: 17 | 240 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769058 | 6011351 | 2112431 | 37.7809725048626 | -122.404349860228 | (37.7809725048626, -122.404349860228) | 14 | 2 | 9 | 28853 | 34 | |
26764 | 97511 | Permitted Site 7 | Tree(s) :: 17 | 20X 10th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | ||
26797 | 93891 | Permitted Site 7 | Tree(s) :: 17 | 425 Folsom St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6014407 | 2114805 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | 6 | 2 | 9 | 28855 | 6 | ||||
26937 | 100641 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
28093 | 173489 | DPW Maintained 1 | Tree(s) :: 17 | 1050 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781453 | 6015435.16441 | 2110414.19947 | 37.7756622021933 | -122.390079663871 | (37.7756622021933, -122.390079663871) | 14 | 3 | 9 | 310 | 20 | |
28338 | 97125 | DPW Maintained 1 | Tree(s) :: 17 | 1200x Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.1 | 2109812.6 | 37.7736941320217 | -122.409658347393 | (37.7736941320217, -122.409658347393) | 8 | 2 | 9 | 28853 | 34 | |
28876 | 103712 | Permitted Site 7 | Tree(s) :: 17 | 520 Jones St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908 | 2114310 | 37.7859949684164 | -122.412934325498 | (37.7859949684164, -122.412934325498) | 5 | 10 | 9 | 28852 | 36 | ||
29190 | 100630 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
29339 | 38410 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
30118 | 114912 | Undocumented 4 | Tree(s) :: 17 | 101X LANGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010086 | 2110625 | 37.7759428821795 | -122.408598701657 | (37.7759428821795, -122.408598701657) | 8 | 2 | 9 | 28853 | 34 | ||||
30346 | 100632 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
30393 | 173829 | DPW Maintained 1 | Tree(s) :: 17 | 1200 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021 | 2109379 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | 14 | 3 | 9 | 310 | 20 | |
30918 | 38399 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
31002 | 100636 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
31146 | 113058 | Permitted Site 7 | Tree(s) :: 17 | 134 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2015 12:00:00 AM | 3x3 | Permit Number 776143 | 6008397.7 | 2110543.7 | 37.775624952645 | -122.414433235163 | (37.775624952645, -122.414433235163) | 8 | 2 | 9 | 28853 | 34 | ||
31312 | 101540 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
31633 | 101546 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
31705 | 38416 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
31901 | 26849 | DPW Maintained 1 | Tree(s) :: 17 | 130 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006960.268726 | 2111024.2991523 | 37.7768637073231 | -122.4194397761 | (37.7768637073231, -122.4194397761) | 7 | 9 | 9 | 28852 | 36 | |
32053 | 100346 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 |
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) );