trees
141 rows where qSpecies_id = 192
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127937 | 205927 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 351 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994099.7296 | 2099750.24687 | 37.7451753385886 | -122.463109727528 | (37.7451753385886, -122.463109727528) | 1 | 8 | 4 | 29491 | 40 | |||
129259 | 222723 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 6 Roscoe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006834.2082 | 2095713.35843 | 37.7348162898445 | -122.418789750356 | (37.7348162898445, -122.418789750356) | 2 | 7 | 7 | 28859 | 2 | |||
130076 | 222658 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 397 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003726.11997 | 2103884.92664 | 37.7570780295385 | -122.430118240357 | (37.7570780295385, -122.430118240357) | 2 | 4 | 5 | 28862 | 3 | |||
131708 | 205936 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 16 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5998119.51434 | 2093651.58316 | 37.7286606102943 | -122.448770873875 | (37.7286606102943, -122.448770873875) | 9 | 7 | 4 | 28861 | 40 | |||
132450 | 222661 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 737 Sanchez St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6003696.567 | 2104082.72525 | 37.7576194636886 | -122.430234556892 | (37.7576194636886, -122.430234556892) | 2 | 4 | 5 | 28862 | 3 | |||
132584 | 122169 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 773 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991300.41308 | 2110156.21664 | 37.7735857231524 | -122.473548090693 | (37.7735857231524, -122.473548090693) | 11 | 6 | 2 | 54 | 26 | |||
134508 | 204711 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 400x Marietta Dr | 37 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5999138.58947 | 2096999.87001 | 37.7379124398128 | -122.445488548067 | (37.7379124398128, -122.445488548067) | 9 | 7 | 4 | 59 | 40 | |||
136942 | 222717 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5998192.89709 | 2106359.88718 | 37.7635587114837 | -122.44943247273 | (37.7635587114837, -122.44943247273) | 15 | 5 | 11 | 29492 | 9 | |||
137271 | 205925 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 339 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993786.38841 | 2105256.23483 | 37.7602753154789 | -122.464592927245 | (37.7602753154789, -122.464592927245) | 1 | 8 | 4 | 56 | 12 | |||
137663 | 108908 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 85 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772733 | 5999781.28744 | 2087663.99349 | 37.7123149446499 | -122.442596312184 | (37.7123149446499, -122.442596312184) | 9 | 7 | 6 | 28861 | 5 |
138215 | 205926 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991750.33901 | 2100031.2106 | 37.7458111754419 | -122.471253906169 | (37.7458111754419, -122.471253906169) | 1 | 8 | 4 | 29491 | 40 | |||
138704 | 222644 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 121 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005291.14603 | 2096211.0656 | 37.7360958794178 | -122.424160040259 | (37.7360958794178, -122.424160040259) | 2 | 7 | 7 | 28859 | 2 | |||
139724 | 188421 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 602 Arthur Ave | 38 | Front Yard : Yard | Tree | Private 2 | 7 | 6015740.2817 | 2099823.35637 | 37.7465989366059 | -122.388284852668 | (37.7465989366059, -122.388284852668) | 10 | 3 | 8 | 58 | 1 | ||||
141178 | 204710 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 545 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998992.31443 | 2097369.41624 | 37.7389187739861 | -122.446020863095 | (37.7389187739861, -122.446020863095) | 9 | 7 | 4 | 59 | 40 | |||
141224 | 222626 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 101 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006239.65947 | 2097553.04485 | 37.7398341651269 | -122.420975890732 | (37.7398341651269, -122.420975890732) | 2 | 7 | 7 | 28859 | 2 | |||
148295 | 222712 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1101 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 12 | 6004716.12579 | 2096285.00945 | 37.7362664286601 | -122.426153382197 | (37.7362664286601, -122.426153382197) | 2 | 7 | 5 | 28859 | 2 | ||||
150943 | 222741 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 500x 27th St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6002744.61883 | 2100060.70302 | 37.7465219789108 | -122.433239395083 | (37.7465219789108, -122.433239395083) | 2 | 7 | 5 | 63 | 22 | |||
153445 | 222627 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 322x Elsie St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6006329.86925 | 2096925.87693 | 37.7381171866669 | -122.420619473203 | (37.7381171866669, -122.420619473203) | 2 | 7 | 7 | 28859 | 2 | |||
155590 | 222716 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4800 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998213.80869 | 2105679.41887 | 37.7616915129762 | -122.449311117323 | (37.7616915129762, -122.449311117323) | 15 | 5 | 11 | 29492 | 9 | |||
156528 | 222669 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003665.94004 | 2103977.36903 | 37.7573284457732 | -122.43033296072 | (37.7573284457732, -122.43033296072) | 2 | 4 | 5 | 28862 | 3 | |||
158474 | 222711 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 276 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6002996.93111 | 2096284.15675 | 37.7361667666773 | -122.432097283983 | (37.7361667666773, -122.432097283983) | 2 | 7 | 5 | 63 | 7 | |||
158547 | 222656 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 310 Liberty St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004069.16963 | 2103935.80533 | 37.7572371537858 | -122.428935470922 | (37.7572371537858, -122.428935470922) | 2 | 4 | 5 | 28862 | 3 | |||
160278 | 175818 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 12 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000786.09001 | 2088431.87786 | 37.7144806101721 | -122.439178423455 | (37.7144806101721, -122.439178423455) | 9 | 7 | 6 | 28861 | 5 | |||
161650 | 222714 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 501 York St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6009828.15271 | 2105893.93218 | 37.762938017409 | -122.409156748601 | (37.762938017409, -122.409156748601) | 8 | 4 | 8 | 28859 | 19 | |||
162267 | 222672 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 841 Church St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004365.34197 | 2104133.78232 | 37.7577975114758 | -122.427925298424 | (37.7577975114758, -122.427925298424) | 2 | 4 | 5 | 28862 | 3 | |||
165546 | 222662 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 396 Cumberland St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003135.75728 | 2104484.93256 | 37.7586920482127 | -122.432202787039 | (37.7586920482127, -122.432202787039) | 2 | 4 | 5 | 28862 | 3 | |||
165635 | 222664 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4090 20th St | 3 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6003149.42788 | 2104190.19818 | 37.7578835531891 | -122.432134460156 | (37.7578835531891, -122.432134460156) | 2 | 4 | 5 | 28862 | 3 | |||
165957 | 205937 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 50 Circular Ave | 1 | : Yard | Tree | Private 2 | 6 | 6000127.5419 | 2093913.29351 | 37.7294938303644 | -122.441847798355 | (37.7294938303644, -122.441847798355) | 9 | 7 | 4 | 63 | 40 | ||||
170674 | 246773 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1850 Alabama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6009440.64435 | 2098764.59055 | 37.7433407224918 | -122.409993691869 | (37.7433407224918, -122.409993691869) | 2 | 7 | 7 | 28859 | 2 | ||||
171419 | 222745 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999630.16383 | 2107483.17366 | 37.7667250877199 | -122.444542176192 | (37.7667250877199, -122.444542176192) | 15 | 5 | 5 | 29492 | 9 | |||
172426 | 222623 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 165 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006768.24548 | 2098530.20309 | 37.7425470051393 | -122.419217556051 | (37.7425470051393, -122.419217556051) | 2 | 7 | 7 | 28859 | 2 | |||
177109 | 222671 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 841 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004365.5079 | 2104119.71112 | 37.7577588846739 | -122.42792372191 | (37.7577588846739, -122.42792372191) | 2 | 4 | 5 | 28862 | 3 | |||
181102 | 222743 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 310 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004293.88459 | 2096588.21513 | 37.7370750882366 | -122.427634840771 | (37.7370750882366, -122.427634840771) | 2 | 7 | 5 | 63 | 7 | |||
183160 | 222643 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 2892 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008956.86387 | 2101628.01459 | 37.7511759237542 | -122.411868784621 | (37.7511759237542, -122.411868784621) | 2 | 4 | 7 | 28859 | 19 | |||
183226 | 205931 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 75 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993781.54533 | 2093460.74171 | 37.7278875863259 | -122.463753529699 | (37.7278875863259, -122.463753529699) | 9 | 8 | 4 | 59 | 40 | |||
184872 | 222724 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 250 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008607.34417 | 2097436.28567 | 37.7396467499959 | -122.412781151352 | (37.7396467499959, -122.412781151352) | 10 | 7 | 7 | 28859 | 2 | |||
185207 | 222738 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1643 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002073.55581 | 2099180.0465 | 37.7440658116781 | -122.435496865185 | (37.7440658116781, -122.435496865185) | 2 | 7 | 5 | 63 | 22 | |||
186744 | 188423 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 602 Arthur Ave | 40 | Front Yard : Yard | Tree | Private 2 | 6 | 6015745.55798 | 2099807.317 | 37.7465551881795 | -122.388265488462 | (37.7465551881795, -122.388265488462) | 10 | 3 | 8 | 58 | 1 | ||||
188499 | 222670 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 790 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003687.86635 | 2103677.4965 | 37.7565063089475 | -122.430235737705 | (37.7565063089475, -122.430235737705) | 2 | 4 | 5 | 28862 | 3 | |||
188601 | 205924 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1680 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993739.53974 | 2104078.92299 | 37.7570400215039 | -122.464669461335 | (37.7570400215039, -122.464669461335) | 1 | 8 | 4 | 56 | 12 | |||
192317 | 54986 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 630 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774083 | 5990989.66226 | 2111091.4426 | 37.7761355972955 | -122.474691284924 | (37.7761355972955, -122.474691284924) | 11 | 6 | 2 | 54 | 26 |
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) );