trees

150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
172650 255483 Significant Tree 6 Persea americana :: Avocado 34 1295 Hampshire St 1 Front Yard : Yard Tree Private 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
173080 105857 Significant Tree 6 Juniperus chinensis :: Juniper 113 1500X Valencia St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006259.2 2100711.5 37.7485076710609 -122.421132539956 (37.7485076710609, -122.421132539956) 2 4 5 28859 19
175545 92054 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
176722 253637 Significant Tree 6 Pinus radiata :: Monterey Pine 15 701 Noe St 2 Front Yard : Yard Tree Private 2       Width 3ft   6003144.80454 2104133.37104 37.7577272573137 -122.432146391441 (37.7577272573137, -122.432146391441) 2 4 5 28862 3
180439 108197 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 930 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
182777 84936 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 145 Guerrero St 1 Front Yard : Yard Tree Private 2           6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
189569 252838 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 1 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
189693 252829 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 3852 17th St 8 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
189920 104445 Significant Tree 6 Acer japonicum :: Japanese Maple 124 507 Capp St 2 Front Yard : Cutout Tree Private 2       2x6 Permit Number 770679 6007300 2104257.5 37.7583027968034 -122.417784776473 (37.7583027968034, -122.417784776473) 2 4 7 28859 19
192074 101233 Significant Tree 6 Tree(s) :: 17 3740 25th St 1 Front Yard : Yard Tree Private 2   10/04/2012 12:00:00 AM     Permit Number 769197 6005584 2101403 37.7503682845448 -122.423516527668 (37.7503682845448, -122.423516527668) 2 4 5 28859 19
193898 258078 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
194287 264983 Significant Tree 6 Yucca spp :: Yucca 289 2957 22nd St   Front Yard : Cutout Tree Private 2       3x3   6008491 2103259 37.7556280948319 -122.41359514096 (37.7556280948319, -122.41359514096) 2 4 7 28859 19
194330 265002 Significant Tree 6 :: Tree 573 1445 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x5   6011217 2101257 37.7502837374969 -122.404026841996 (37.7502837374969, -122.404026841996) 10 4 8 28859 19
194449 262095 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3550 Cesar Chavez St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 785078 6006203 2100616 37.7482422814736 -122.421320098122 (37.7482422814736, -122.421320098122) 2 4 5 28859 19
112975 107342 Significant Tree 6 Prunus laurocerasus :: English laurel 371 110 JULIAN AVE 1 Back Yard : Yard Tree Private 2     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
40225 99859 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 1 Front Yard : Yard Tree Private 2     12     6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
61723 111634 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 3009 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187) 2 4 7 28859 19
145683 112626 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3430X 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6006285 2102686.4 37.7539317482446 -122.421183538041 (37.7539317482446, -122.421183538041) 2 4 5 28859 19
113829 101236 Significant Tree 6 Tree(s) :: 17 895X Church St 1 Back Yard : Yard Tree Private 2   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.427831000859 (37.7565846850157, -122.427831000859) 2 4 5 28862 3
167295 223958 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000714.90104 2104629.88079 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054) 2 4 5 28862 38
8218 100711 Significant Tree 6 Tree(s) :: 17 966-968 Guerrero St 1 Front Yard : Yard Tree Private 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
67906 223957 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6000715.72405 2104622.00656 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927) 2 4 5 28862 38
6758 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 15 180 Yukon St   Back Yard : Cutout Tree Private 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
43597 78107 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 970 GUERRERO ST 1 Front Yard : Yard Tree Private 2     15     6005649.9 2103318.5 37.7556315237614 -122.423424799558 (37.7556315237614, -122.423424799558) 2 4 5 28859 19
143770 110950 Significant Tree 6 Pinus radiata :: Monterey Pine 15 342 HILL ST   Front Yard : Yard Tree Private 2     15 3x3 Permit Number 778799 6004048 2103384 37.7557208285242 -122.428969343229 (37.7557208285242, -122.428969343229) 2 4 5 28862 22
146386 107343 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 110 JULIAN AVE 2 Back Yard : Yard Tree Private 2     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
1790 103256 Significant Tree 6 Maytenus boaria :: Mayten 58 4187 26th St 1 Front Yard : Yard Tree Private 2     16 3x3   6002700 2100625 37.7480688746475 -122.433434000346 (37.7480688746475, -122.433434000346) 2 4 5 63 22
52809 224289 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 166 San Carlos St 1 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   6006647.34642 2105145.25174 37.7607036068074 -122.420104944992 (37.7607036068074, -122.420104944992) 2 4 7 28859 19
42649 115940 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 1 Sidewalk: Curb side : Cutout Tree Police Dept 10     20 3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
54248 115888 Significant Tree 6 Olea europaea :: Olive Tree 9 811 TREAT AVE 1 Front Yard : Cutout Tree Private 2     20 3x3   6008597 2103712 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978) 2 4 7 28859 19
107615 121415 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
159259 104674 Significant Tree 6 Taxus baccata :: Irish Yew 86 3649-3651 17TH ST 1 Front Yard : Yard Tree Private 2     20   Permit Number 770917 6004555.5 2105964.3 37.7628344347284 -122.427398052716 (37.7628344347284, -122.427398052716) 8 4 5 28862 3
66903 233917 Significant Tree 6 Persea americana :: Avocado 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree Private 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
89489 112577 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3326 23RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24   Permit Number 775776 6006851 2102663.4 37.7539004875763 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
110004 113695 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 907 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009441 2103786 37.7571284172194 -122.410346937481 (37.7571284172194, -122.410346937481) 2 4 7 28859 19
29057 116956 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 380 SAN JOSE AVE 1 Front Yard : Cutout Tree Private 2     28 3x3   6006172 2100967 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126) 2 4 5 28859 19
8316 260638 Significant Tree 6 Olea europaea :: Olive Tree 9 3140 25th St 2 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6008726.17419 2101580.94088 37.7510337250786 -122.412663209658 (37.7510337250786, -122.412663209658) 2 4 7 28859 19
12923 237906 Significant Tree 6 Tree(s) :: 17 3937 21st St 3 Front Yard : Yard Tree Private 2   10/06/2020 12:00:00 AM 3 Width 3ft Permit Number 785171 6002245.41508 2103514.00804 37.7559756019151 -122.43521254633 (37.7559756019151, -122.43521254633) 2 4 5 28862 22
20184 108109 Significant Tree 6 Tree(s) :: 17 952 CAPP ST 1 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774355 6007364.7 2101732.3 37.7513728159016 -122.417382061559 (37.7513728159016, -122.417382061559) 2 4 7 28859 19
32199 253765 Significant Tree 6 Cornus SPP :: Dogwood 355 1366 Guerrero St 2 Front Yard : Yard Tree Private 2   02/14/2018 12:00:00 AM 3 3x3 Permit Number 780977 6005800.08489 2101007.66776 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761) 2 4 5 28859 19
78403 258093 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1825 Mission St 7 Front Yard : Yard Tree Private 2   04/04/2019 12:00:00 AM 3 3X3   6006778.7933 2107821.9347 37.7680605555842 -122.419840266187 (37.7680605555842, -122.419840266187) 8 4 7 28853 19
170834 107493 Significant Tree 6 Tree(s) :: 17 180 BARTLETT ST 1 Back Yard : Yard Tree Private 2   11/10/2014 12:00:00 AM 3   Permit Number 774017 6006657.2 2102756.7 37.7541457516772 -122.419901368465 (37.7541457516772, -122.419901368465) 2 4 7 28859 19
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
144070 97894 Significant Tree 6 Tree(s) :: 17 2927 Folsom St   Front Yard : Yard Tree Private 2   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395 2101384 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972) 2 4 7 28859 19
59089 116955 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Front Yard : Cutout Tree Private 2     6 3x3   6001245 2101454 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352) 2 4 5 28862 22
182270 107121 Significant Tree 6 Cercis canadensis :: Eastern Redbud 346 1054 GUERRERO ST 1 Front Yard : Yard Tree Private 2     6     6005686.8 2102852.5 37.7543540785936 -122.423264063467 (37.7543540785936, -122.423264063467) 2 4 5 28859 19
106429 105497 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3929 19TH ST 1 Front Yard : Yard Tree Private 2     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429) 2 4 5 28862 3
152275 103719 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 748 Treat Ave 1 Front Yard : Cutout Tree Private 2     8 3x3   6008496.2 2104169 37.7581270399512 -122.413641518528 (37.7581270399512, -122.413641518528) 2 4 7 28859 19
159982 102589 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5157 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415) 2 4 5 63 22

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