61 rows where qSpecies_id = 81

View and edit SQL

Suggested facets: qLegalStatus_id

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)
266 219228 DPW Maintained 1 Ilex spp :: Holly Species 81 200x Terrace Dr 4 Median : Yard Tree DPW 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
2963 183435 DPW Maintained 1 Ilex spp :: Holly Species 81 2502 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988322.9645 2098243.2971 37.740703186103 -122.48297412001 (37.740703186103, -122.48297412001) 1 8 3 29491 35
3732 118637 DPW Maintained 1 Ilex spp :: Holly Species 81 489 45th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5981892.63195 2112480.11557 37.7794171598516 -122.506262811826 (37.7794171598516, -122.506262811826) 11 6 2 55 26
6225 19831 DPW Maintained 1 Ilex spp :: Holly Species 81 100 STAIRWAY25 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
6370 261832 Significant Tree 6 Ilex spp :: Holly Species 81 16 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995265 2100184 37.7464333732005 -122.459111852123 (37.7464333732005, -122.459111852123) 1 8 4 59 40
13139 182087 DPW Maintained 1 Ilex spp :: Holly Species 81 2445 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5988353.2291 2098271.1187 37.7407813379181 -122.482871516272 (37.7407813379181, -122.482871516272) 1 8 3 29491 35
16656 19780 DPW Maintained 1 Ilex spp :: Holly Species 81 100 STAIRWAY19 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 50ST                      
16878 117887 DPW Maintained 1 Ilex spp :: Holly Species 81 592 43rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5982584.75817 2111760.42718 37.7774818283717 -122.50381517937 (37.7774818283717, -122.50381517937) 11 6 2 55 26
19823 116396 DPW Maintained 1 Ilex spp :: Holly Species 81 491 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   5986227.46387 2112707.13917 37.7802947441584 -122.491283721582 (37.7802947441584, -122.491283721582) 11 6 2 55 26
31003 247544 DPW Maintained 1 Ilex spp :: Holly Species 81 815 Buena Vista Ave West 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   6000179.66489 2108445.2622 37.7693980814777 -122.442710639406 (37.7693980814777, -122.442710639406) 15 5 11 29492 9
32791 254539 Significant Tree 6 Ilex spp :: Holly Species 81 737 Buena Vista Ave West 5 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
35009 244388 DPW Maintained 1 Ilex spp :: Holly Species 81 867 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003258.1157 2110303.4924 37.7746753358595 -122.432195147264 (37.7746753358595, -122.432195147264) 15 9 11 29492 10
35326 183434 DPW Maintained 1 Ilex spp :: Holly Species 81 2502 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988323.5274 2098241.0455 37.7406970365538 -122.482972008757 (37.7406970365538, -122.482972008757) 1 8 3 29491 35
36703 244150 DPW Maintained 1 Ilex spp :: Holly Species 81 403 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004582.2514 2109632.0608 37.772906735272 -122.427566848583 (37.772906735272, -122.427566848583) 7 9 11 28852 10
38400 182091 DPW Maintained 1 Ilex spp :: Holly Species 81 2445 Ulloa St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5988425.6513 2098272.8108 37.740790197611 -122.482621234539 (37.740790197611, -122.482621234539) 1 8 3 29491 35
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
40889 183436 DPW Maintained 1 Ilex spp :: Holly Species 81 2502 26th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988324.0903 2098255.9623 37.7407380269297 -122.482971155492 (37.7407380269297, -122.482971155492) 1 8 3 29491 35
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
43728 254538 Significant Tree 6 Ilex spp :: Holly Species 81 737 Buena Vista Ave West 4 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
53410 129098 DPW Maintained 1 Ilex spp :: Holly Species 81 699 Marina Blvd 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 7ft   5999673.75993 2121514.33526 37.8052534912214 -122.445400374028 (37.8052534912214, -122.445400374028) 13 9 1 57 17
54394 228523 DPW Maintained 1 Ilex spp :: Holly Species 81 885 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5998683.04499 2107050.20185 37.7654821679992 -122.447786913029 (37.7654821679992, -122.447786913029) 15 5 11 29492 9
60246 190677 DPW Maintained 1 Ilex spp :: Holly Species 81 900x Carolina St 71 Median : Yard Tree DPW 1     7     6012520.45276 2102813.85342 37.7546312593522 -122.399628684232 (37.7546312593522, -122.399628684232) 10 3 8 28856 29
63781 182010 DPW Maintained 1 Ilex spp :: Holly Species 81 2798 Ulloa St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   5987426.2917 2098298.8693 37.7408035561751 -122.486078512429 (37.7408035561751, -122.486078512429) 1 8 3 29491 35
67127 183439 DPW Maintained 1 Ilex spp :: Holly Species 81 2506 26th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5988324.3717 2098230.6319 37.7406684926665 -122.482968326485 (37.7406684926665, -122.482968326485) 1 8 3 29491 35
68606 117716 DPW Maintained 1 Ilex spp :: Holly Species 81 3945 Clement St 3 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   5983209.45945 2113085.35212 37.7811563972474 -122.501752215396 (37.7811563972474, -122.501752215396) 11 6 2 55 26
72029 183057 DPW Maintained 1 Ilex spp :: Holly Species 81 912 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5990112.1764 2097710.1846 37.7393433452946 -122.476748830936 (37.7393433452946, -122.476748830936) 1 8 3 29491 35
73248 129095 DPW Maintained 1 Ilex spp :: Holly Species 81 2942 Divisadero St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000568.08591 2118422.82625 37.7968160427755 -122.442083407248 (37.7968160427755, -122.442083407248) 13 9 1 57 17
73662 183058 DPW Maintained 1 Ilex spp :: Holly Species 81 920 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5990096.9474 2097710.523 37.7393433910761 -122.476801510221 (37.7393433910761, -122.476801510221) 1 8 3 29491 35
77275 118638 DPW Maintained 1 Ilex spp :: Holly Species 81 489 45th Ave 1 Front Yard : Yard Tree Private 2     2 Width 9ft   5981883.80409 2112496.71277 37.779462211155 -122.506294581666 (37.779462211155, -122.506294581666) 11 6 2 55 26
82605 182089 DPW Maintained 1 Ilex spp :: Holly Species 81 2445 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988388.4249 2098272.134 37.7407861734754 -122.482749898297 (37.7407861734754, -122.482749898297) 1 8 3 29491 35
90283 3132 DPW Maintained 1 Ilex spp :: Holly Species 81 3266 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   5998797.59633 2114972.68409 37.7872418121422 -122.447961158094 (37.7872418121422, -122.447961158094) 13 6 1 54 31
95132 122063 DPW Maintained 1 Ilex spp :: Holly Species 81 5 17th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   5990505.08019 2115005.32961 37.7868539537607 -122.476653573827 (37.7868539537607, -122.476653573827) 11 6 1 61 30
95303 123326 DPW Maintained 1 Ilex spp :: Holly Species 81 799 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994723.62372 2110289.80732 37.7741501756081 -122.461716464535 (37.7741501756081, -122.461716464535) 11 6 2 54 11
97746 111068 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 1 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
102261 244100 DPW Maintained 1 Ilex spp :: Holly Species 81 1601 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5998872.1214 2109002.8983 37.7708545832672 -122.447273495634 (37.7708545832672, -122.447273495634) 15 5 11 29492 9
103673 244149 DPW Maintained 1 Ilex spp :: Holly Species 81 403 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004569.5642 2109632.0608 37.7729060176478 -122.427610735127 (37.7729060176478, -122.427610735127) 7 9 11 28852 10
103915 183059 DPW Maintained 1 Ilex spp :: Holly Species 81 924 Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5990080.3647 2097710.523 37.7393424291485 -122.476858845232 (37.7393424291485, -122.476858845232) 1 8 3 29491 35
109067 181783 DPW Maintained 1 Ilex spp :: Holly Species 81 2755 Ulloa St 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5987457.0881 2098239.9839 37.7406436671581 -122.485967710136 (37.7406436671581, -122.485967710136) 1 8 3 29491 35
109572 249700 DPW Maintained 1 Ilex spp :: Holly Species 81 2400 Baker St 32 Front Yard : Yard Tree Private 2     4     5999694.38585 2117225.06205 37.7934774706624 -122.445020451827 (37.7934774706624, -122.445020451827) 13 9 1 57 27
112002 219227 DPW Maintained 1 Ilex spp :: Holly Species 81 70 Aloha Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991836.36372 2104420.02538 37.7578666954186 -122.471276157164 (37.7578666954186, -122.471276157164) 1 8 4 56 12
115341 182090 DPW Maintained 1 Ilex spp :: Holly Species 81 2445 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5988408.7302 2098273.1492 37.7407901423219 -122.482679765429 (37.7407901423219, -122.482679765429) 1 8 3 29491 35
125082 129096 DPW Maintained 1 Ilex spp :: Holly Species 81 313 Maple St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5996631.61587 2115198.1283 37.7877367751689 -122.455471243996 (37.7877367751689, -122.455471243996) 11 6 1 54 31
125938 116398 DPW Maintained 1 Ilex spp :: Holly Species 81 491 31st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5986230.22871 2112671.88005 37.7801980942572 -122.491271561101 (37.7801980942572, -122.491271561101) 11 6 2 55 26
130801 182587 DPW Maintained 1 Ilex spp :: Holly Species 81 2447 26th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5988270.6541 2098478.9097 37.7413470724826 -122.483172253202 (37.7413470724826, -122.483172253202) 1 8 3 29491 35
132465 182088 DPW Maintained 1 Ilex spp :: Holly Species 81 2445 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5988370.827 2098270.4419 37.7407805035232 -122.482810620505 (37.7407805035232, -122.482810620505) 1 8 3 29491 35
136228 252825 Significant Tree 6 Ilex spp :: Holly Species 81 3852 17th St 4 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
136654 118083 DPW Maintained 1 Ilex spp :: Holly Species 81 7309 Geary Blvd 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 2ft   5984328.88362 2112397.00903 37.7793320968225 -122.49782878117 (37.7793320968225, -122.49782878117) 11 6 2 55 26
145083 219225 DPW Maintained 1 Ilex spp :: Holly Species 81 1820 16th Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 5ft   5991268.14409 2102994.44508 37.7539195421662 -122.473137315828 (37.7539195421662, -122.473137315828) 1 8 4 56 12
148432 219231 DPW Maintained 1 Ilex spp :: Holly Species 81 449 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     10     5997163.53491 2095515.52142 37.7337238258 -122.452210171862 (37.7337238258, -122.452210171862) 9 7 4 59 40
152436 219226 DPW Maintained 1 Ilex spp :: Holly Species 81 98 Lurline St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   5991838.56734 2105160.13567 37.759898970787 -122.471322460584 (37.759898970787, -122.471322460584) 1 8 4 56 12
156283 219230 DPW Maintained 1 Ilex spp :: Holly Species 81 175 Stillings Ave 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 5ft   5999606.10326 2095741.44552 37.7344837817026 -122.443781745426 (37.7344837817026, -122.443781745426) 9 7 4 63 40
163605 120103 DPW Maintained 1 Ilex spp :: Holly Species 81 2551 Cabrillo St 4 Sidewalk: Property side : Yard Tree Private 2     20 Width 3ft   5987706.88835 2110474.66057 37.77425132027 -122.486001854101 (37.77425132027, -122.486001854101) 11 6 2 55 26
165251 138779 DPW Maintained 1 Ilex spp :: Holly Species 81 538 PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999189.3925 2114781.3264 37.7867387814828 -122.446591859454 (37.7867387814828, -122.446591859454) 15 6 1 29490 31
166543 219229 DPW Maintained 1 Ilex spp :: Holly Species 81 300x Marietta Dr 47 Median : Cutout Tree DPW 1     11 Width 5ft   5999539.46642 2097492.37053 37.7392876066259 -122.444137903966 (37.7392876066259, -122.444137903966) 9 7 4 59 40
170567 182009 DPW Maintained 1 Ilex spp :: Holly Species 81 2796 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5987440.5055 2098297.1772 37.7407997384745 -122.486029242895 (37.7407997384745, -122.486029242895) 1 8 3 29491 35
171576 129097 DPW Maintained 1 Ilex spp :: Holly Species 81 699 Marina Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 7ft   5999648.00124 2121510.04753 37.8052402478033 -122.445489206378 (37.8052402478033, -122.445489206378) 13 9 1 57 17
171930 129094 DPW Maintained 1 Ilex spp :: Holly Species 81 2942 Divisadero St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6000566.12061 2118445.50816 37.7968782093121 -122.442091836579 (37.7968782093121, -122.442091836579) 13 9 1 57 17
176304 181782 DPW Maintained 1 Ilex spp :: Holly Species 81 2755 Ulloa St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   5987437.7981 2098239.3071 37.7406406846815 -122.48603435705 (37.7406406846815, -122.48603435705) 1 8 3 29491 35
177272 185003 DPW Maintained 1 Ilex spp :: Holly Species 81 2701 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985018.8709 2096488.705 37.7356927337416 -122.494268955014 (37.7356927337416, -122.494268955014) 1 8 3 29491 35
177413 218287 DPW Maintained 1 Ilex spp :: Holly Species 81 1 Woodacre Dr 11 Sidewalk: Curb side : Yard Tree Private 2     8     5991329.99765 2095591.79515 37.7335973505247 -122.472383795489 (37.7335973505247, -122.472383795489) 1 8 4 64 40
188319 117909 DPW Maintained 1 Ilex spp :: Holly Species 81 835 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5983528.95902 2110122.17554 37.7730391366516 -122.500427770772 (37.7730391366516, -122.500427770772) 11 6 2 55 26

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