trees

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

✎ 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)
37050 252828 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 3852 17th St 7 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
37022 95985 Significant Tree 6 Juniperus chinensis :: Juniper 113 577 Sanchez St 1 Front Yard : Tree Private 2           6003673 2104901 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
36007 107047 Significant Tree 6 Tree(s) :: 17 1933 15TH ST   Front Yard : Yard Tree Private 2           6004592.7 2107127.1 37.7660293092823 -122.427352228532 (37.7660293092823, -122.427352228532) 8 4 5 28862 3
34658 104715 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
33161 254729 Significant Tree 6 Cryptomeria japonica :: Japanese Cryptomeria 420 1940 Mission St 6 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
33143 116090 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 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
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
27985 253620 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 1120 South Van Ness Ave 3 Front Yard : Cutout Tree Private 2       Width 3ft   6007603.98274 2103104.14442 37.7551530486792 -122.416651764192 (37.7551530486792, -122.416651764192) 2 4 7 28859 19
27944 252826 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 5 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
24634 111770 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 707 Douglass St   Front Yard : Cutout Tree Private 2       3x3 Permit Number 775627 6001281 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375) 2 4 5 28862 22
23877 105554 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 1 Front Yard : Yard Tree Private 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 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
19453 261628 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3930 21st St 1 Front Yard : Cutout Tree Private 2       3x3   6002255 2103579 37.7561545985327 -122.435184046951 (37.7561545985327, -122.435184046951) 2 4 5 28862 3
18002 261423 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011254 2102764 37.7544236960072 -122.404004933004 (37.7544236960072, -122.404004933004) 10 4 8 28859 19
17604 261710 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 3555 16th St 1 Front Yard : Yard Tree Public Library 12       8x8   6003221.95473 2106496.25325 37.7642195378276 -122.432048304209 (37.7642195378276, -122.432048304209) 15 4 5 28862 3
16292 262198 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 801 Sanchez St 2 Back Yard : Yard Tree Private 2       3x3   6003778 2103544 37.7561448640021 -122.429914501498 (37.7561448640021, -122.429914501498) 2 4 5 28862 22
16010 260965 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
15065 261762 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 2943 Harrison St 1 Front Yard : Yard Tree Private 2       Width 3ft   6009034.67775 2101326.83516 37.7503533174728 -122.411578417814 (37.7503533174728, -122.411578417814) 2 4 7 28859 19
14736 92056 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
14462 261432 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
13844 260966 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
13092 261764 Significant Tree 6 Melaleuca quinquenervia :: Cajeput 10 130 Bartlett St 2 Front Yard : Cutout Tree Private 2       4x4   6006663 2102839 37.7543720553146 -122.419887150249 (37.7543720553146, -122.419887150249) 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
12225 102131 Significant Tree 6 Tree(s) :: 17 850 Treat Ave 1 Front Yard : Yard Tree Private 2   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.413420887965 (37.7565461982029, -122.413420887965) 2 4 7 28859 19
10271 262199 Significant Tree 6 Olea europaea :: Olive Tree 9 801 Sanchez St 1 Back Yard : Yard Tree Private 2       3x3   6003778 2103544 37.7561448640021 -122.429914501498 (37.7561448640021, -122.429914501498) 2 4 5 28862 22
10260 261386 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 31 Abbey St 1 Front Yard : Yard Tree Private 2       3x3   6004642 2106187 37.7634508076606 -122.427114742536 (37.7634508076606, -122.427114742536) 8 4 5 28862 3
10119 261688 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9966 251172 Significant Tree 6 Pinus radiata :: Monterey Pine 15 363 Jersey St 2 Front Yard : Yard Tree Private 2           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601) 2 4 5 28862 22
9783 261822 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 122 3580 21st St 2 Front Yard : Yard Tree Private 2       Width 3ft Permit Number 785112 6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373) 2 4 5 28862 3
9703 264868 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 145 Guerrero St 1 Side Yard : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
9216 261431 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9069 255620 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8787 260968 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 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
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
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
6691 256248 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
6430 260967 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
5213 84938 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 145 Guerrero St 1 Front Yard : Yard Tree Private 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
4630 261689 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4089 260964 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
3581 255621 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
3323 258079 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 3 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
2713 121088 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
2313 260963 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
1871 261422 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 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
1533 120590 Significant Tree 6 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 52 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003308 2106220 37.7634658909933 -122.43173097309 (37.7634658909933, -122.43173097309) 15 4 5 28862 3

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