trees
161 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 63
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 126322 | 186253 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1701 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984779.1353 | 2103090.988 | 37.7538067764424 | -122.495584617514 | (37.7538067764424, -122.495584617514) | 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 | |||
| 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 | ||||
| 131920 | 201760 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015686.51796 | 2087358.79354 | 37.7123707547676 | -122.387601292376 | (37.7123707547676, -122.387601292376) | 10 | 3 | 8 | 58 | 1 | |||
| 132701 | 186592 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984742.0945 | 2104511.4521 | 37.757704808066 | -122.495817486185 | (37.757704808066, -122.495817486185) | 1 | 8 | 3 | 56 | 35 | |||
| 132708 | 201780 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015582.72471 | 2087849.79956 | 37.7137132132682 | -122.387994278123 | (37.7137132132682, -122.387994278123) | 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 | |||
| 133522 | 201785 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015530.91454 | 2087992.79913 | 37.7141029920284 | -122.388183328214 | (37.7141029920284, -122.388183328214) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 145724 | 201793 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015446.06267 | 2088163.05451 | 37.7145657786635 | -122.388488487967 | (37.7145657786635, -122.388488487967) | 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 | ||||
| 146862 | 201738 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015533.66415 | 2087659.51426 | 37.7131880082953 | -122.388150579386 | (37.7131880082953, -122.388150579386) | 10 | 3 | 8 | 58 | 1 | |||
| 152112 | 186248 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1701 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984775.1177 | 2103139.467 | 37.7539396511246 | -122.495602086568 | (37.7539396511246, -122.495602086568) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 154751 | 201787 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015507.5354 | 2088050.73887 | 37.7142607879799 | -122.388268177459 | (37.7142607879799, -122.388268177459) | 10 | 3 | 8 | 58 | 1 | |||
| 154803 | 201786 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015524.34656 | 2088008.79963 | 37.714146562401 | -122.38820714586 | (37.714146562401, -122.38820714586) | 10 | 3 | 8 | 58 | 1 | |||
| 156029 | 201763 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015661.0546 | 2087420.2073 | 37.7125379747236 | -122.387693584416 | (37.7125379747236, -122.387693584416) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 157519 | 187090 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5985165.338 | 2097125.749 | 37.7374504565555 | -122.493809499319 | (37.7374504565555, -122.493809499319) | 1 | 8 | 3 | 29491 | 35 | |||
| 157528 | 201756 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6015765.33497 | 2087252.12963 | 37.7120822414633 | -122.387321438639 | (37.7120822414633, -122.387321438639) | 10 | 3 | 8 | 58 | 1 | |||
| 160221 | 201791 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015459.4491 | 2088143.48556 | 37.7145127879215 | -122.388440853585 | (37.7145127879215, -122.388440853585) | 10 | 3 | 8 | 58 | 1 |
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) );