trees

161 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 63 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 61 ✖
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)
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
143060 185340 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5984975.3236 2097003.7352 37.7371043205037 -122.494457466722 (37.7371043205037, -122.494457466722) 1 8 3 29491 35
117514 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 4 Sidewalk: Property side : Yard Tree Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.419286081687 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
12042 201792 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 40 Sidewalk: Property side : Yard Tree Private 2     22 Width 8ft   6015451.0989 2088156.51994 37.7145481150837 -122.388470624731 (37.7145481150837, -122.388470624731) 10 3 8 58 1
33872 186702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984718.4366 2105146.0279 37.7594457908807 -122.495946116181 (37.7594457908807, -122.495946116181) 1 8 3 56 35
65486 201795 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 43 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6015420.28917 2088209.03426 37.7146906018698 -122.388580780005 (37.7146906018698, -122.388580780005) 10 3 8 58 1
166032 194459 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 34 Sidewalk: Property side : Yard Tree Private 2     24     6012781.55557 2101851.76257 37.7520041175184 -122.398658203327 (37.7520041175184, -122.398658203327) 10 3 8 28856 29
187217 132182 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 601 Beach St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   6007241.65576 2121894.78138 37.8067272057567 -122.419237667598 (37.8067272057567, -122.419237667598) 5 1 1 28858 32
17861 201752 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   6015886.86298 2086978.1992 37.7113368105223 -122.386882306895 (37.7113368105223, -122.386882306895) 10 3 8 58 1
59640 211078 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 97 Ashton Ave 1 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   5994121.91269 2090532.87853 37.7198679898921 -122.462364611346 (37.7198679898921, -122.462364611346) 9 8 6 28861 24
144133 201751 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   6015871.64119 2086992.23012 37.7113744939227 -122.386935895675 (37.7113744939227, -122.386935895675) 10 3 8 58 1
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
113722 201749 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     26 Width 8ft   6015821.03447 2087045.57383 37.7115181633057 -122.387114525336 (37.7115181633057, -122.387114525336) 10 3 8 58 1
146172 132180 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 3 Sidewalk: Property side : Yard Tree Private 2     26     6007242.78631 2121872.67886 37.8066665815484 -122.419232186229 (37.8066665815484, -122.419232186229) 5 1 1 28858 32
2394 184349 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1251 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984659.3559 2106454.1603 37.7630340956965 -122.496246960605 (37.7630340956965, -122.496246960605) 1 8 3 56 35
79197 187345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2200 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985074.9529 2099709.2267 37.7445387020266 -122.494312372955 (37.7445387020266, -122.494312372955) 1 8 3 29491 35
108195 247896 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 351 Mayflower St 1 Sidewalk: Property side : Yard Tree Private 2     29 Width 5ft   6010145.43386 2098385.46575 37.7423392041921 -122.407529975731 (37.7423392041921, -122.407529975731) 10 7 7 28859 2
193239 184993 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985021.3833 2096558.6319 37.7358848813643 -122.494265421421 (37.7358848813643, -122.494265421421) 1 8 3 29491 35
63026 186711 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494) 1 8 3 56 35
78578 185360 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 85 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985022.2207 2096895.7045 37.7368104416486 -122.494287364038 (37.7368104416486, -122.494287364038) 1 8 3 29491 35
109871 185295 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.8666 2097355.3585 37.7380690548117 -122.494526449097 (37.7380690548117, -122.494526449097) 1 8 3 29491 35
120570 187096 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985160.1655 2097173.7115 37.7375818461267 -122.493830916284 (37.7375818461267, -122.493830916284) 1 8 3 29491 35
128762 247016 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 Valley St 6 Sidewalk: Property side : Yard Tree Private 2     3     6002574.36339 2099193.51243 37.7441312166966 -122.433766148707 (37.7441312166966, -122.433766148707) 2 7 5 63 22
156225 185362 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 87 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984999.1909 2096870.1623 37.7367389618664 -122.494365104774 (37.7367389618664, -122.494365104774) 1 8 3 29491 35
178211 186688 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984691.4289 2105282.7412 37.7598195855983 -122.496049606755 (37.7598195855983, -122.496049606755) 1 8 3 56 35
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
61393 186897 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     33 Width 0ft   5985183.7588 2096592.6965 37.7359879144627 -122.493706542591 (37.7359879144627, -122.493706542591) 1 8 3 29491 35
193997 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 2 Sidewalk: Property side : Yard Tree Private 2     33     6007259.69894 2121860.76679 37.8066348265036 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32
82734 201750 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     34 Width 8ft   6015853.10494 2087012.76113 37.7114298417752 -122.3870013933 (37.7114298417752, -122.3870013933) 10 3 8 58 1
45510 185230 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2509 44th Ave 1 Sidewalk: Property side : Yard Tree Private 2     35 Width 0ft   5982693.8052 2098008.2989 37.7397287878455 -122.50241990404 (37.7397287878455, -122.50241990404) 1 8 3 29491 35
6278 132178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2449 Mason St 1 Sidewalk: Property side : Yard Tree Private 2     36     6008741.74811 2122071.63658 37.807297172691 -122.414058809171 (37.807297172691, -122.414058809171) 3 1 10 308 23
49420 187123 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     37 Width 0ft   5985149.3505 2097343.9312 37.7380485911062 -122.493880849001 (37.7380485911062, -122.493880849001) 1 8 3 29491 35
38402 194467 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6012416.6749 2095223.97206 37.7337852773717 -122.399454760738 (37.7337852773717, -122.399454760738) 10 3 8 58 1
101713 185705 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2101 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984891.1634 2100474.9689 37.7466304646766 -122.495004322509 (37.7466304646766, -122.495004322509) 1 8 3 29491 35
108098 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1048 Union St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.416814304957 (37.7995736051877, -122.416814304957) 5 1 1 308 32
154451 178178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 769 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6001369.37887 2092541.7115 37.725798463024 -122.43745647446 (37.725798463024, -122.43745647446) 9 7 6 28861 25
173903 184079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 80 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984934.15 2104045.1938 37.7564358379272 -122.49511890768 (37.7564358379272, -122.49511890768) 1 8 3 56 35
128546 185363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     43 Width 0ft   5984980.3483 2096870.9998 37.7367401586853 -122.494430312609 (37.7367401586853, -122.494430312609) 1 8 3 29491 35
41307 184977 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984998.3534 2096742.4516 37.7363882534207 -122.494358589298 (37.7363882534207, -122.494358589298) 1 8 3 29491 35
43488 185314 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985007.4607 2097237.2784 37.7377474483668 -122.494363565845 (37.7377474483668, -122.494363565845) 1 8 3 29491 35
137520 194468 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6012422.70585 2095229.76642 37.7338015236278 -122.399434316464 (37.7338015236278, -122.399434316464) 10 3 8 58 1
42716 187095 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985178.0339 2097175.5923 37.7375880557056 -122.493769276198 (37.7375880557056, -122.493769276198) 1 8 3 29491 35
121598 186348 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984789.3132 2102727.1271 37.7528083107787 -122.495522585708 (37.7528083107787, -122.495522585708) 1 8 3 56 35
162189 184737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984694.2473 2106265.1087 37.7625170568543 -122.496112336517 (37.7625170568543, -122.496112336517) 1 8 3 56 35
172030 185637 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985047.0682 2100399.1831 37.7464315030837 -122.494459642192 (37.7464315030837, -122.494459642192) 1 8 3 29491 35
173494 181382 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1500 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984896.9779 2104470.096 37.7576003251998 -122.49527879388 (37.7576003251998, -122.49527879388) 1 8 3 56 35
186578 211080 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5999525.10685 2095532.7271 37.7339060697915 -122.444046783738 (37.7339060697915, -122.444046783738) 9 7 4 63 40
72242 187396 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5985054.0302 2100695.3416 37.74724508117 -122.494457396667 (37.74724508117, -122.494457396667) 1 8 3 29491 35
103634 186594 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518) 1 8 3 56 35
106470 186343 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984811.8118 2102790.6052 37.7529839215525 -122.495449463877 (37.7529839215525, -122.495449463877) 1 8 3 56 35
66936 187102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985165.8082 2097224.4952 37.7377216147142 -122.493815148362 (37.7377216147142, -122.493815148362) 1 8 3 29491 35
95767 185659 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985060.0587 2100566.7616 37.7468923883135 -122.494427074117 (37.7468923883135, -122.494427074117) 1 8 3 29491 35
125583 184742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.496209373012 (37.7624121488276, -122.496209373012) 1 8 3 56 35
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
20177 187394 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985039.81 2100667.7899 37.7471685994587 -122.494504537591 (37.7471685994587, -122.494504537591) 1 8 3 29491 35
20635 201770 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 18 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015634.53236 2087578.56705 37.712971331023 -122.387796296857 (37.712971331023, -122.387796296857) 10 3 8 58 1
23165 201759 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015719.97269 2087309.22701 37.712236507578 -122.387482205949 (37.712236507578, -122.387482205949) 10 3 8 58 1
133258 201758 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015742.62341 2087279.17788 37.7121552529428 -122.387401822747 (37.7121552529428, -122.387401822747) 10 3 8 58 1
136927 211081 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999513.42858 2095531.79881 37.7339028547188 -122.444087092249 (37.7339028547188, -122.444087092249) 9 7 4 63 40
142542 201755 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015777.13838 2087239.45412 37.7120480906272 -122.38727975865 (37.7120480906272, -122.38727975865) 10 3 8 58 1
183575 187017 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984955.1646 2097931.5729 37.7396507340198 -122.494595545547 (37.7396507340198, -122.494595545547) 1 8 3 29491 35

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