trees
53 rows where Zip Codes = 29491 and qSpecies_id = 63 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
192105 | 186099 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984856.2078 | 2101707.4688 | 37.7500125261534 | -122.495216067916 | (37.7500125261534, -122.495216067916) | 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 | |||
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 | |||
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 | |||
85285 | 20978 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
38282 | 21135 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
74662 | 21131 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 0 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
190239 | 185656 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5985042.305 | 2100549.4408 | 37.746843791076 | -122.494487187243 | (37.746843791076, -122.494487187243) | 1 | 8 | 3 | 29491 | 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 | |||
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 | |||
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 | |||
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 | |||
140469 | 21312 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2501X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 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 | |||
188950 | 185409 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2300 Sunset Blvd | 24 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985081.6412 | 2099150.9001 | 37.7430060796886 | -122.494248101225 | (37.7430060796886, -122.494248101225) | 1 | 8 | 3 | 29491 | 35 | |||
189399 | 185410 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2300 Sunset Blvd | 25 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985099.6362 | 2099155.3989 | 37.7430194852088 | -122.494186211855 | (37.7430194852088, -122.494186211855) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
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 | |||
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 | |||
184638 | 185176 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2500 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5985156.5992 | 2097794.2406 | 37.7392854441206 | -122.493888963204 | (37.7392854441206, -122.493888963204) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
133744 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 1 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
105788 | 218299 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Ardenwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991311.90242 | 2096390.21304 | 37.7357885567818 | -122.472504543874 | (37.7357885567818, -122.472504543874) | 1 | 8 | 4 | 29491 | 40 | |||
48354 | 211060 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 6ft | 5991645.7062 | 2101259.684 | 37.7491781931242 | -122.471705217417 | (37.7491781931242, -122.471705217417) | 1 | 8 | 4 | 29491 | 12 | |||
98798 | 211059 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 6ft | 5991648.13538 | 2101268.04551 | 37.74920129221 | -122.471697426622 | (37.74920129221, -122.471697426622) | 1 | 8 | 4 | 29491 | 12 | |||
99356 | 211061 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 6ft | 5991650.04455 | 2101251.74063 | 37.7491566336932 | -122.47168963669 | (37.7491566336932, -122.47168963669) | 1 | 8 | 4 | 29491 | 12 | |||
60775 | 211062 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 33 | Width 6ft | 5991653.15073 | 2101238.7756 | 37.7491212147934 | -122.47167795089 | (37.7491212147934, -122.47167795089) | 1 | 8 | 4 | 29491 | 12 | |||
28006 | 211079 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2319 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5992294.50858 | 2099658.84702 | 37.7448202223807 | -122.469345163475 | (37.7448202223807, -122.469345163475) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||||
126413 | 211063 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 333 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 4ft | 5994231.86901 | 2100876.38212 | 37.7482750327754 | -122.462734494413 | (37.7482750327754, -122.462734494413) | 1 | 8 | 4 | 29491 | 40 |
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) );