53 rows where Zip Codes = 29491 and qSpecies_id = 63 sorted by XCoord

View and edit SQL

Zip Codes

  • 29491 · 53
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

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