8,298 rows where qLegalStatus_id = 4 sorted by qCareAssistant descending

View and edit SQL

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)
22315 113814 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:05:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
23754 113821 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 4101x 25TH ST 14 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
26910 111776 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
39489 111135 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   2 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
45020 111128 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
50286 113709 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
52668 113708 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
73737 113813 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
74558 111133 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
87336 113817 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:00:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
87682 113810 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 4101x 25TH ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
88456 113809 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 06/15/2016 07:36:00 AM 3 5x5   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
90434 113818 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 05:57:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
101614 113808 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4101x 25TH ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
113343 113820 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 4101x 25TH ST 13 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
120864 113819 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4101x 25TH ST 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
124997 113812 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 4101x 25TH ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   1 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
128478 111134 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
130117 113705 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
143725 113706 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
148472 113707 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
152081 111131 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
154938 113811 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
175403 111129 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
177608 113816 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
177877 113822 Undocumented 4 Melaleuca spp :: Melaleuca spp 117 4101x 25TH ST 15 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
179503 113815 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 4101x 25TH ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   8 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
185385 111132 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 4 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11498 115743 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 1 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
11694 263618 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 1 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
50482 103357 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
51920 103361 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 10 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
70238 103355 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
74442 103359 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
87854 103360 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
97800 115748 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 6 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
106391 115747 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 5 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   16 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
107985 115744 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 2 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112309 115745 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 3 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   20 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112589 115746 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 4 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
168063 103358 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
174866 103356 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
177428 103354 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
182306 103352 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
190388 103353 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
5722 255886 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
10029 260896 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 866 Kansas St 1 Front Yard : Cutout Tree DPW 1 Private     3x3   6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
20034 255882 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
22229 255887 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 50 Columbia Square St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
24954 255884 Undocumented 4 Acer rubrum :: Red Maple 75 50 Columbia Square St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
46746 117011 Undocumented 4 Maytenus boaria :: Mayten 58 457X CASTRO ST 1 Back Yard : Cutout Tree MTA 3 Private   27 3x6   6002348 2105584 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888) 15 4 5 28862 3
58440 112748 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 135X TRENTON ST 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
84101 255881 Undocumented 4 Acer rubrum :: Red Maple 75 50 Columbia Square St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
99464 112750 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 4 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
155752 115341 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 1514 SUNNYDALE AVE 2 Sidewalk: Property side : Yard Tree Housing Authority 15 Private     3x3   6006572 2087815 37.7131143345755 -122.419136228821 (37.7131143345755, -122.419136228821) 9 7 8 309 39
162723 114914 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 200x MIDDLE POINT RD 1 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6017974 2095171 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959) 10 3 8 58 1
177021 112749 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 135X TRENTON ST 3 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
186352 255883 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
189496 255885 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
194380 255779 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 45 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/08/2017 12:00:00 AM 3 3x3   5999808 2089058 37.7161440949055 -122.442604012325 (37.7161440949055, -122.442604012325) 9 7 6 28861 25
56573 108255 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 2 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
88030 108259 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 6 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
104693 108256 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 3 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
130441 108258 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 5 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
144404 108257 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 4 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
166621 108254 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 1 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
4148 111380 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
25373 110420 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 419X 18TH AVE 18 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
58757 104623 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 250 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2 MTA     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.401967135301 (37.7824643544146, -122.401967135301) 6 2 9 28853 34
89067 104621 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 266-286X 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2 MTA     4x4 Permit Number 770959 6012142 2112916 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717) 6 2 9 28853 34
95680 110403 Undocumented 4 Ficus laurel :: 247 419X 18TH AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA   22 3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
114523 110402 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
119304 111381 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 3 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
138581 104624 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 250 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2 MTA     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.401967135301 (37.7824643544146, -122.401967135301) 6 2 9 28853 34
139329 110406 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
168033 111379 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
180245 110414 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 15 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
182081 104622 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 266-286X 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2 MTA     4x4 Permit Number 770959 6012142 2112916 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717) 6 2 9 28853 34
189727 104625 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 250 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2 MTA     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.401967135301 (37.7824643544146, -122.401967135301) 6 2 9 28853 34
168011 108643 Undocumented 4 Tree(s) :: 17 315X PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 Housing Authority     3x3   6012408.6 2118423 37.7974841688946 -122.401112237555 (37.7974841688946, -122.401112237555) 3 1 10 28860 4
8380 118286 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 199X JULES AVE 2 Sidewalk: Curb side : Cutout Tree Private 2 Fire Dept     3x3   5994418 2091201 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582) 9 8 6 28861 24
143882 118285 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 199X JULES AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 Fire Dept     3x3   5994418 2091201 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582) 9 8 6 28861 24
53 264969 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
506 264804 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
1918 262485 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
2023 264805 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
3569 261071 Undocumented 4 Acer buergeranum :: Trident Maple 110 58 Latona St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6014335 2094330 37.7314373487466 -122.392759967745 (37.7314373487466, -122.392759967745) 10 3 8 58 1
4127 74230 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1011 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1996 12:00:00 AM 10     6011143.4423 2118449.9882 37.7974876128867 -122.405491940883 (37.7974876128867, -122.405491940883) 3 1 10 308 23
4356 262525 Undocumented 4 Tree(s) :: 17 410 Alpha St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     4x6   6010538 2087515 37.7125131447181 -122.405407212047 (37.7125131447181, -122.405407212047) 9 7 8 309 39
5555 256038 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1563 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6015087 2093984 37.7305290408635 -122.390135976897 (37.7305290408635, -122.390135976897) 10 3 8 58 1
7315 108963 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2395x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6001858 2107008 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881) 15 5 5 28862 3
7364 261070 Undocumented 4 Acer buergeranum :: Trident Maple 110 58 Latona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6014335 2094330 37.7314373487466 -122.392759967745 (37.7314373487466, -122.392759967745) 10 3 8 58 1
8669 262474 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
9260 262526 Undocumented 4 Tree(s) :: 17 410 Alpha St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     4x6   6010538 2087515 37.7125131447181 -122.405407212047 (37.7125131447181, -122.405407212047) 9 7 8 309 39

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);