trees
603 rows where qSpecies_id = 172 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
3382 | 46731 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
5647 | 46732 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
6590 | 39944 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
7296 | 39946 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
9758 | 46722 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
10645 | 46730 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
11952 | 39952 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
12633 | 39951 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14549 | 39950 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14616 | 39953 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
15472 | 46729 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
17495 | 39948 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
18303 | 39949 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
8107 | 260620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1510 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015860.79811 | 2095596.0425 | 37.7349982739746 | -122.387573242087 | (37.7349982739746, -122.387573242087) | 10 | 3 | 8 | 58 | 1 | ||
16859 | 197195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1700x Quesada Ave | 52 | Median : Yard | Tree | DPW 1 | 5 | 6014229.96459 | 2095381.00329 | 37.7343173549634 | -122.393196613328 | (37.7343173549634, -122.393196613328) | 10 | 3 | 8 | 58 | 1 | ||||
18259 | 51502 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 6 | Permit Number 47813 | 6012107.99979 | 2092823.48534 | 37.7271768287335 | -122.400353400198 | (37.7271768287335, -122.400353400198) | 10 | 3 | 8 | 58 | 1 | ||
19403 | 197209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6019354.09765 | 2093629.33991 | 37.7297909609772 | -122.375359249432 | (37.7297909609772, -122.375359249432) | 10 | 3 | 8 | 58 | 1 | ||||
26327 | 82822 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
31036 | 82818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
32883 | 197205 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019275.32859 | 2093678.30312 | 37.7299210694925 | -122.375634959101 | (37.7299210694925, -122.375634959101) | 10 | 3 | 8 | 58 | 1 | ||||
35171 | 197186 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6016257.1896 | 2100643.95159 | 37.7488807495539 | -122.386554632611 | (37.7488807495539, -122.386554632611) | 10 | 3 | 8 | 58 | 1 | |||
36136 | 197192 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6015810.17797 | 2099864.72659 | 37.7467164033528 | -122.388046043088 | (37.7467164033528, -122.388046043088) | 3 | 8 | 58 | 1 | |||||
36639 | 197190 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 9 | Front Yard : Yard | Tree | Private 2 | 13 | 6015846.29737 | 2099899.92461 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | 3 | 8 | 58 | 1 | |||||
36650 | 197202 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012375.40062 | 2096377.97464 | 37.7369516266217 | -122.399678458117 | (37.7369516266217, -122.399678458117) | 10 | 3 | 8 | 58 | 1 | ||||
40489 | 6510 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | 10 | 3 | 8 | 58 | 1 | |||
47120 | 200030 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015295.7414 | 2094553.9973 | 37.7321057143095 | -122.389454111911 | (37.7321057143095, -122.389454111911) | 10 | 3 | 8 | 58 | 1 | |||
51511 | 83003 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015217.1468 | 2094533.6617 | 37.7320455189111 | -122.389724413212 | (37.7320455189111, -122.389724413212) | 10 | 3 | 8 | 58 | 1 | |
52308 | 197207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6019325.73842 | 2093646.8502 | 37.7298374801948 | -122.375458504919 | (37.7298374801948, -122.375458504919) | 10 | 3 | 8 | 58 | 1 | ||||
53189 | 46622 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015162.1856 | 2094456.1663 | 37.7318296842946 | -122.389909016355 | (37.7318296842946, -122.389909016355) | 10 | 3 | 8 | 58 | 1 | |
54420 | 197204 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 961 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6013357.29959 | 2089363.32814 | 37.7177455197262 | -122.395792202474 | (37.7177455197262, -122.395792202474) | 10 | 3 | 8 | 58 | 1 | ||||
56664 | 97021 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
59942 | 200032 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015330.9166 | 2094529.2648 | 37.7320397540499 | -122.389330775989 | (37.7320397540499, -122.389330775989) | 10 | 3 | 8 | 58 | 1 | |||
66368 | 82820 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
70543 | 51357 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.61459 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) | 10 | 3 | 8 | 58 | 1 |
72156 | 202100 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012079.44226 | 2092845.19967 | 37.727234859285 | -122.400453648533 | (37.727234859285, -122.400453648533) | 10 | 3 | 8 | 58 | 1 | ||||
75706 | 82819 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
75933 | 202101 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012067.0135 | 2092854.03168 | 37.7272584170419 | -122.400497235069 | (37.7272584170419, -122.400497235069) | 10 | 3 | 8 | 58 | 1 | ||||
76209 | 197188 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6016258.08648 | 2100618.43223 | 37.7488107283357 | -122.386549751994 | (37.7488107283357, -122.386549751994) | 10 | 3 | 8 | 58 | 1 | |||
84794 | 200174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013889.8173 | 2089740.206 | 37.718809961526 | -122.393977881076 | (37.718809961526, -122.393977881076) | 10 | 3 | 8 | 58 | 1 | |||
86666 | 51501 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 3 | Permit Number 47813 | 6012094.35334 | 2092834.4343 | 37.7272061313316 | -122.400401344869 | (37.7272061313316, -122.400401344869) | 10 | 3 | 8 | 58 | 1 | ||
89510 | 202102 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6012051.06489 | 2092865.44567 | 37.7272888680664 | -122.400553171109 | (37.7272888680664, -122.400553171109) | 10 | 3 | 8 | 58 | 1 | ||||
91699 | 197189 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 7 | Front Yard : Yard | Tree | Private 2 | 21 | 6015936.19644 | 2099934.12978 | 37.7469139511226 | -122.387615121238 | (37.7469139511226, -122.387615121238) | 3 | 8 | 58 | 1 | |||||
92934 | 46623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52363 | 6015139.1019 | 2094428.6857 | 37.7317529479126 | -122.3899869032 | (37.7317529479126, -122.3899869032) | 10 | 3 | 8 | 58 | 1 | |
93239 | 197199 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012275.41688 | 2096456.43356 | 37.7371614843067 | -122.400029656869 | (37.7371614843067, -122.400029656869) | 10 | 3 | 8 | 58 | 1 | ||||
95375 | 28089 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1100 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | ||
99577 | 201569 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Donahue St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6020624.73776 | 2092976.30056 | 37.7280676809716 | -122.370921308297 | (37.7280676809716, -122.370921308297) | 10 | 3 | 8 | 58 | 1 | |||
103485 | 200173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013894.556 | 2089735.8088 | 37.7187981510491 | -122.393961193506 | (37.7187981510491, -122.393961193506) | 10 | 3 | 8 | 58 | 1 | |||
107973 | 200034 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015379.8321 | 2094494.6392 | 37.7319473909121 | -122.389159246189 | (37.7319473909121, -122.389159246189) | 10 | 3 | 8 | 58 | 1 | |||
112243 | 82829 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015168.781 | 2094466.0594 | 37.731857214516 | -122.389886905293 | (37.731857214516, -122.389886905293) | 10 | 3 | 8 | 58 | 1 | |
113028 | 197197 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6012251.10105 | 2096472.21303 | 37.7372034556659 | -122.400114836148 | (37.7372034556659, -122.400114836148) | 10 | 3 | 8 | 58 | 1 | ||||
113073 | 197196 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1951 Revere Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6013056.64262 | 2095884.22793 | 37.7356338527108 | -122.397288471104 | (37.7356338527108, -122.397288471104) | 10 | 3 | 8 | 58 | 1 | ||||
114102 | 46624 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015146.2469 | 2094436.9299 | 37.7317759810825 | -122.389962776954 | (37.7317759810825, -122.389962776954) | 10 | 3 | 8 | 58 | 1 | |
115893 | 82824 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
117815 | 200031 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015313.8786 | 2094541.9059 | 37.7320735193499 | -122.389390563006 | (37.7320735193499, -122.389390563006) | 10 | 3 | 8 | 58 | 1 | |||
126782 | 52156 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516147 | -122.392803455827 | (37.733990516147, -122.392803455827) | 10 | 3 | 8 | 58 | 1 | |
128850 | 202106 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6011990.13515 | 2092907.27832 | 37.7274003336589 | -122.400766743908 | (37.7274003336589, -122.400766743908) | 10 | 3 | 8 | 58 | 1 | |||
129326 | 197194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 37 | Front Yard : Yard | Tree | Private 2 | 12 | 6015675.19682 | 2099860.17709 | 37.746696432096 | -122.388512480964 | (37.746696432096, -122.388512480964) | 3 | 8 | 58 | 1 | |||||
134803 | 197187 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6016257.35591 | 2100633.78015 | 37.7488528300966 | -122.386553348365 | (37.7488528300966, -122.386553348365) | 10 | 3 | 8 | 58 | 1 | |||
139094 | 202103 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012036.54433 | 2092874.73876 | 37.7273135751543 | -122.400604021475 | (37.7273135751543, -122.400604021475) | 10 | 3 | 8 | 58 | 1 | |||
140317 | 202104 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6012020.3729 | 2092885.52976 | 37.7273423030982 | -122.400660684147 | (37.7273423030982, -122.400660684147) | 10 | 3 | 8 | 58 | 1 | |||
140467 | 197206 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019299.00025 | 2093665.65157 | 37.7298876336035 | -122.375552245738 | (37.7298876336035, -122.375552245738) | 10 | 3 | 8 | 58 | 1 | ||||
144174 | 197201 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012348.82133 | 2096403.61302 | 37.7370205425534 | -122.399772154858 | (37.7370205425534, -122.399772154858) | 10 | 3 | 8 | 58 | 1 | ||||
149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
149673 | 82823 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
152026 | 197193 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 15 | Front Yard : Yard | Tree | Private 2 | 10 | 6015814.64437 | 2099848.11828 | 37.7466710478274 | -122.388029439803 | (37.7466710478274, -122.388029439803) | 3 | 8 | 58 | 1 | |||||
153671 | 46627 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1426 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 0 | 3x3 | Permit Number 51060 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
154848 | 83004 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52363 | 6015190.2158 | 2094494.6392 | 37.7319368775726 | -122.38981479563 | (37.7319368775726, -122.38981479563) | 10 | 3 | 8 | 58 | 1 | |
155260 | 82821 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
155710 | 197191 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 12 | Front Yard : Yard | Tree | Private 2 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.387947067298 | (37.7467614521736, -122.387947067298) | 3 | 8 | 58 | 1 | |||||
156991 | 179339 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012524.83653 | 2086861.12373 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | 10 | 3 | 8 | 309 | 1 | |||
157597 | 200033 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015359.4964 | 2094508.3795 | 37.7319839916649 | -122.389230510733 | (37.7319839916649, -122.389230510733) | 10 | 3 | 8 | 58 | 1 | |||
160990 | 197198 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012265.63539 | 2096460.02897 | 37.7371708111791 | -122.400063728568 | (37.7371708111791, -122.400063728568) | 10 | 3 | 8 | 58 | 1 | ||||
161527 | 29651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 10 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | 10 | 3 | 8 | 58 | 1 | ||
177133 | 197208 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019334.40687 | 2093641.64666 | 37.7298236693276 | -122.375428176194 | (37.7298236693276, -122.375428176194) | 10 | 3 | 8 | 58 | 1 | ||||
179082 | 46625 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015155.0407 | 2094448.4718 | 37.7318081605067 | -122.389933180674 | (37.7318081605067, -122.389933180674) | 10 | 3 | 8 | 58 | 1 | |
179875 | 200029 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015274.8561 | 2094571.5849 | 37.7321528483199 | -122.38952754545 | (37.7321528483199, -122.38952754545) | 10 | 3 | 8 | 58 | 1 | |||
181079 | 202105 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6012005.05891 | 2092897.14051 | 37.727373329703 | -122.40071444024 | (37.727373329703, -122.40071444024) | 10 | 3 | 8 | 58 | 1 | |||
185182 | 29652 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 11 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015669.3226 | 2096063.213 | 37.7362704220955 | -122.388267840771 | (37.7362704220955, -122.388267840771) | 10 | 3 | 8 | 58 | 1 | ||
188325 | 83005 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52363 | 6015179.2236 | 2094481.4485 | 37.7319000489922 | -122.389851877282 | (37.7319000489922, -122.389851877282) | 10 | 3 | 8 | 58 | 1 | |
191441 | 197200 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6012333.19446 | 2096408.64833 | 37.7370334972934 | -122.39982653777 | (37.7370334972934, -122.39982653777) | 10 | 3 | 8 | 58 | 1 | ||||
51002 | 240326 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 343 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004069.13295 | 2109034.20183 | 37.7712361239812 | -122.429299145951 | (37.7712361239812, -122.429299145951) | 7 | 9 | 11 | 29492 | 10 | |||
122071 | 136275 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 699 Webster St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6003966.4578 | 2111069.22256 | 37.7768179785099 | -122.429799478365 | (37.7768179785099, -122.429799478365) | 7 | 9 | 11 | 29492 | 10 | |||
43774 | 123184 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 695 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993153.85102 | 2110782.22133 | 37.7754117246383 | -122.467182349196 | (37.7754117246383, -122.467182349196) | 11 | 6 | 2 | 54 | 11 | |||
8236 | 214000 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5991559.56782 | 2105079.2538 | 37.7596607475761 | -122.472281478703 | (37.7596607475761, -122.472281478703) | 1 | 8 | 4 | 56 | 12 | ||||
45286 | 213997 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500 16th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 23 | 5991180.77064 | 2105068.88436 | 37.7596103459632 | -122.473590780095 | (37.7596103459632, -122.473590780095) | 1 | 8 | 4 | 56 | 12 | ||||
94759 | 213999 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1550 15th Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5991557.04571 | 2104983.06205 | 37.7593964844917 | -122.472283189233 | (37.7593964844917, -122.472283189233) | 1 | 8 | 4 | 56 | 12 | ||||
149454 | 213998 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1550 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991562.73982 | 2104919.95067 | 37.7592235268581 | -122.472258895832 | (37.7592235268581, -122.472258895832) | 1 | 8 | 4 | 56 | 12 | ||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
3335 | 142293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 475 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000600.6108 | 2110614.5346 | 37.775378345569 | -122.441410289609 | (37.775378345569, -122.441410289609) | 15 | 5 | 11 | 29492 | 16 | |||
3558 | 142294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 465 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.0602 | 2110593.7708 | 37.7753215869011 | -122.441393407901 | (37.7753215869011, -122.441393407901) | 15 | 5 | 11 | 29492 | 16 | |||
14733 | 255398 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 637 MASONIC AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999139.3301 | 2110590.1819 | 37.7752281241925 | -122.446463429304 | (37.7752281241925, -122.446463429304) | 15 | 5 | 11 | 29492 | 16 | ||||
21634 | 123489 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 5995672.03179 | 2111788.60232 | 37.7783200198099 | -122.458544293173 | (37.7783200198099, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | |||
45451 | 88773 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
84814 | 88772 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
137430 | 141623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1801 GROVE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998914.533 | 2110398.874 | 37.7746899995309 | -122.44722727877 | (37.7746899995309, -122.44722727877) | 15 | 5 | 11 | 29492 | 16 | |||
142891 | 142295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 455 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.8018 | 2110575.2317 | 37.7752707254694 | -122.441389511979 | (37.7752707254694, -122.441389511979) | 15 | 5 | 11 | 29492 | 16 | |||
18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 |
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) );