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

View and edit SQL

qSiteInfo

  • Sidewalk: Property side : Yard · 161
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)
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
2009 201784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 32 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015541.73553 2087974.13978 37.7140523566047 -122.388144625001 (37.7140523566047, -122.388144625001) 10 3 8 58 1
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
5800 98837 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1                              
5956 98839 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 4 Sidewalk: Property side : Yard Tree DPW 1                              
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
7554 201736 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015525.30693 2087693.56377 37.7132810386533 -122.38818183984 (37.7132810386533, -122.38818183984) 10 3 8 58 1
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
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
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
14391 194472 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 5 Sidewalk: Property side : Yard Tree Private 2     16     6016745.33826 2095063.00852 37.7335836232886 -122.384477928938 (37.7335836232886, -122.384477928938) 10 3 8 58 1
16186 186101 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984808.9821 2101715.6546 37.7500322370685 -122.495379978089 (37.7500322370685, -122.495379978089) 1 8 3 29491 35
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
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
21065 201733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015510.4184 2087766.77172 37.7134812286504 -122.388238406274 (37.7134812286504, -122.388238406274) 10 3 8 58 1
21400 186097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527) 1 8 3 29491 35
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
25472 201732 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015480.18133 2087865.40702 37.713750386735 -122.388349797223 (37.713750386735, -122.388349797223) 10 3 8 58 1
25951 201761 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015680.02756 2087378.65264 37.7124249245429 -122.387625110022 (37.7124249245429, -122.387625110022) 10 3 8 58 1
27135 194470 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 3 Sidewalk: Property side : Yard Tree Private 2     16     6016764.11928 2095038.85548 37.7335183423928 -122.384411315236 (37.7335183423928, -122.384411315236) 10 3 8 58 1
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
31995 201737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015529.27451 2087676.75764 37.7132351120852 -122.38816695425 (37.7132351120852, -122.38816695425) 10 3 8 58 1
32167 201766 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 14 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015647.69731 2087483.94989 37.7127122597387 -122.387744196458 (37.7127122597387, -122.387744196458) 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
34962 184744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.496128558374 (37.7623384159342, -122.496128558374) 1 8 3 56 35
38128 201734 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015517.44938 2087731.03371 37.71338348853 -122.388211611887 (37.71338348853, -122.388211611887) 10 3 8 58 1
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
39195 201740 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015542.0778 2087585.57887 37.7129854620959 -122.388116342205 (37.7129854620959, -122.388116342205) 10 3 8 58 1
39844 185075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2801 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985040.8539 2096108.9226 37.7346512389504 -122.494164969235 (37.7346512389504, -122.494164969235) 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
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
42969 186098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5984859.9858 2101721.9514 37.7500525125937 -122.495204071455 (37.7500525125937, -122.495204071455) 1 8 3 29491 35
43163 201735 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015522.2781 2087714.21053 37.7133375628641 -122.388193748644 (37.7133375628641, -122.388193748644) 10 3 8 58 1
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
45383 186433 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817) 1 8 3 56 35
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
48450 201773 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 21 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015629.12317 2087652.01307 37.7131727000372 -122.387820114508 (37.7131727000372, -122.387820114508) 10 3 8 58 1
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
52616 184782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984677.5396 2105882.9212 37.7614666984861 -122.496141923024 (37.7614666984861, -122.496141923024) 1 8 3 56 35
54785 186417 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984727.1251 2104191.8612 37.7568264235859 -122.495845680799 (37.7568264235859, -122.495845680799) 1 8 3 56 35
56295 185638 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5985050.0993 2100407.4104 37.7464542704067 -122.494449767525 (37.7464542704067, -122.494449767525) 1 8 3 29491 35
57881 201744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 13 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015567.574 2087419.0912 37.7125297315236 -122.388016607392 (37.7125297315236, -122.388016607392) 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
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
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
63112 201741 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 10 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015551.73985 2087509.47398 37.7127770280164 -122.388077638997 (37.7127770280164, -122.388077638997) 10 3 8 58 1
63898 185202 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5985155.2712 2097966.8909 37.7397594177965 -122.493906274966 (37.7397594177965, -122.493906274966) 1 8 3 29491 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
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
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
67122 201776 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 24 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015607.24672 2087763.10237 37.7134765179931 -122.387903474463 (37.7134765179931, -122.387903474463) 10 3 8 58 1
67974 201788 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 36 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015494.63123 2088072.87111 37.7143208438162 -122.388314323455 (37.7143208438162, -122.388314323455) 10 3 8 58 1
68325 184784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201) 1 8 3 56 35
69152 184781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984718.1696 2105899.6288 37.7615149526664 -122.496002635394 (37.7615149526664, -122.496002635394) 1 8 3 56 35
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
75335 185550 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2201 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984877.5845 2099886.0836 37.7450127509214 -122.495007861214 (37.7450127509214, -122.495007861214) 1 8 3 29491 35
77915 257969 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1998X 09th Ave 1 Sidewalk: Property side : Yard Tree Private 2       6x15   5993560 2101938 37.7511512457798 -122.465134876758 (37.7511512457798, -122.465134876758) 1 8 4 29491 12
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
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
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
79660 201757 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015756.55363 2087265.17293 37.7121175695368 -122.38735269906 (37.7121175695368, -122.38735269906) 10 3 8 58 1
82478 98836 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 6 Sidewalk: Property side : Yard Tree DPW 1           5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
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
84080 201783 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 31 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015549.05195 2087952.54872 37.7139934770858 -122.388117830599 (37.7139934770858, -122.388117830599) 10 3 8 58 1
85521 187012 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984974.837 2098002.6963 37.7398471711362 -122.494532769595 (37.7398471711362, -122.494532769595) 1 8 3 29491 35
86298 186102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984817.1679 2101703.0611 37.7499981380626 -122.495350742926 (37.7499981380626, -122.495350742926) 1 8 3 29491 35
87306 201794 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 42 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015439.96848 2088181.18977 37.7146152368657 -122.388510817234 (37.7146152368657, -122.388510817234) 10 3 8 58 1
90634 201790 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 38 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015475.6761 2088115.28204 37.7144362457024 -122.388382798743 (37.7144362457024, -122.388382798743) 10 3 8 58 1
93032 186593 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541) 1 8 3 56 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
96403 201768 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015641.02933 2087537.69345 37.7128594598683 -122.387770990859 (37.7128594598683, -122.387770990859) 10 3 8 58 1
96989 201781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015573.4977 2087883.43723 37.713805064638 -122.388028516222 (37.713805064638, -122.388028516222) 10 3 8 58 1
99536 201777 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 25 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015601.56547 2087780.3718 37.7135236217889 -122.387924315354 (37.7135236217889, -122.387924315354) 10 3 8 58 1
99612 258091 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1500x Steiner St 1 Sidewalk: Property side : Yard Tree DPW 1       15x50   6002808 2113496 37.7834156319858 -122.433980438269 (37.7834156319858, -122.433980438269) 13 9 11 29490 41
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
102199 186902 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5985182.8419 2096662.3766 37.7361791837873 -122.493714845671 (37.7361791837873, -122.493714845671) 1 8 3 29491 35
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
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
106214 201767 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 15 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015642.29299 2087514.93769 37.7127970469199 -122.387765036445 (37.7127970469199, -122.387765036445) 10 3 8 58 1
106418 201754 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015794.33118 2087216.37677 37.7119856767735 -122.387218726159 (37.7119856767735, -122.387218726159) 10 3 8 58 1
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
107661 201748 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015601.73852 2087319.33199 37.7122577046069 -122.387891566548 (37.7122577046069, -122.387891566548) 10 3 8 58 1
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
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
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
110823 201753 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015806.16056 2087204.98759 37.7119550593549 -122.387177046177 (37.7119550593549, -122.387177046177) 10 3 8 58 1
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
114462 201769 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015636.77799 2087561.79601 37.7129254053659 -122.387787365691 (37.7129254053659, -122.387787365691) 10 3 8 58 1
116998 185204 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985139.3342 2097991.4603 37.7398259462999 -122.493963187792 (37.7398259462999, -122.493963187792) 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
118486 100845 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
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
119044 201747 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015587.35405 2087353.50341 37.7123507358797 -122.387943666966 (37.7123507358797, -122.387943666966) 10 3 8 58 1
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
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
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
122823 201764 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 12 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015653.28128 2087440.52101 37.7125933216851 -122.387721868094 (37.7125933216851, -122.387721868094) 10 3 8 58 1
124322 201782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 30 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015559.74323 2087927.45907 37.713925178088 -122.388079127353 (37.713925178088, -122.388079127353) 10 3 8 58 1

Next page

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