Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24045 | 24045 | 211638 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993404.24438 | 2096035.5287900001 | 37.7349355669295 | -122.465244802603 | (37.7349355669295, -122.465244802603) | ||||
24462 | 24462 | 211631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993552.90123 | 2096075.99565 | 37.735055250506704 | -122.464733785358 | (37.7350552505067, -122.464733785358) | ||||
26676 | 26676 | 247028 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 550x Valley St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6002355.441269999 | 2099181.9915400003 | 37.744087157999296 | -122.43452230856701 | (37.7440871579993, -122.434522308567) | ||||
27995 | 27995 | 211600 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | ||||
32165 | 32165 | 211633 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993517.47022 | 2096073.45578 | 37.7350462338855 | -122.464856097643 | (37.7350462338855, -122.464856097643) | ||||
32237 | 32237 | 250565 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.48760963785601 | (37.7799715553521, -122.487609637856) | |||
34570 | 34570 | 251048 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5700x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989255.4598 | 2112633.0799 | 37.7802678632993 | -122.480803179963 | (37.7802678632993, -122.480803179963) | |||
36478 | 36478 | 133192 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | |||
39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
39455 | 39455 | 211655 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993781.5938099995 | 2096511.3140900002 | 37.736263709102296 | -122.46397470897301 | (37.7362637091023, -122.463974708973) | ||||
39483 | 39483 | 211654 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993772.928590001 | 2096520.6347700001 | 37.7362888019871 | -122.464005344374 | (37.7362888019871, -122.464005344374) | ||||
40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
47168 | 47168 | 251029 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991370.3842 | 2112709.3567 | 37.7805999993895 | -122.473492318223 | (37.7805999993895, -122.473492318223) | |||
47467 | 47467 | 211597 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993315.91751 | 2096029.3267299999 | 37.734913443583004 | -122.46554972673701 | (37.734913443583, -122.465549726737) | ||||
57950 | 57950 | 211602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993273.01858 | 2096070.8179900001 | 37.7350248938828 | -122.46570105566201 | (37.7350248938828, -122.465701055662) | ||||
58657 | 58657 | 211636 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5993435.6641 | 2096075.47209 | 37.73504705316721 | -122.465139074704 | (37.7350470531672, -122.465139074704) | ||||
60406 | 60406 | 194760 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1700x Quesada Ave | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6014240.46002 | 2095410.02862 | 37.734397635636796 | -122.393162357259 | (37.7343976356368, -122.393162357259) | ||||
63223 | 63223 | 211635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993454.5439 | 2096075.0755900003 | 37.735047053161004 | -122.46507377223699 | (37.735047053161, -122.465073772237) | ||||
63302 | 63302 | 211637 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993407.09448 | 2096071.29538 | 37.7350339374534 | -122.465237545992 | (37.7350339374534, -122.465237545992) | ||||
65745 | 65745 | 211595 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993265.55195 | 2096027.93285 | 37.7349067112733 | -122.465723755468 | (37.7349067112733, -122.465723755468) | ||||
66534 | 66534 | 211642 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5993503.77568 | 2096035.22982 | 37.734940485303895 | -122.464900668957 | (37.7349404853039, -122.464900668957) | ||||
66680 | 66680 | 211596 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993283.92452 | 2096029.9988 | 37.734913443609 | -122.465660385625 | (37.734913443609, -122.465660385625) | ||||
68908 | 68908 | 194663 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012487.04658 | 2103373.70419 | 37.7561666251126 | -122.39978352139099 | (37.7561666251126, -122.399783521391) | ||||
69767 | 69767 | 251022 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991511.6828 | 2112712.2313 | 37.7806160737768 | -122.473003713445 | (37.7806160737768, -122.473003713445) | |||
73062 | 73062 | 211603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993248.1121 | 2096070.25185 | 37.7350219027308 | -122.465787124396 | (37.7350219027308, -122.465787124396) | ||||
73552 | 73552 | 194662 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012476.06279 | 2103566.1501700003 | 37.756694427329 | -122.39983502019501 | (37.756694427329, -122.399835020195) | ||||
74413 | 74413 | 251035 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5317x Geary Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990415.7605 | 2112675.5562 | 37.7804518645045 | -122.47679231146002 | (37.7804518645045, -122.47679231146) | |||
74791 | 74791 | 247024 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 550x Valley St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6002373.83689 | 2099182.06322 | 37.744088399054704 | -122.43445870581199 | (37.7440883990547, -122.434458705812) | ||||
75559 | 75559 | 119930 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5987085.6039 | 2112558.1946400004 | 37.779935889891895 | -122.48830410860799 | (37.7799358898919, -122.488304108608) | ||||
79875 | 79875 | 112144 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 401X ROOSEVELT WAY | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000065.0 | 2106738.0 | 37.764703828929896 | -122.44298463673401 | (37.7647038289299, -122.442984636734) | ||||
133633 | 133633 | 211643 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993526.28926 | 2096036.5483400002 | 37.734945403693295 | -122.464822927933 | (37.7349454036933, -122.464822927933) | ||||
149583 | 149583 | 211598 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993342.23689 | 2096032.04298 | 37.7349224197171 | -122.46545892941002 | (37.7349224197171, -122.46545892941) | ||||
150515 | 150515 | 211601 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 5993297.40661 | 2096072.7575700001 | 37.7350316261928 | -122.465616879121 | (37.7350316261928, -122.465616879121) | ||||
151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
152127 | 152127 | 251023 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991490.4549 | 2112712.2313 | 37.780614844759995 | -122.473077150172 | (37.78061484476, -122.473077150172) | |||
153106 | 153106 | 211641 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993480.406880001 | 2096036.0192599997 | 37.7349413054856 | -122.464981519787 | (37.7349413054856, -122.464981519787) | ||||
153730 | 153730 | 195015 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1427x Innes Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016257.183540001 | 2096668.3945900002 | 37.737964684134 | -122.38627752271299 | (37.737964684134, -122.386277522713) | ||||
154753 | 154753 | 211644 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993552.38645 | 2096037.19487 | 37.7349486835202 | -122.46473274841401 | (37.7349486835202, -122.464732748414) | ||||
157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
158762 | 158762 | 211634 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993470.414340001 | 2096074.14522 | 37.7350454137208 | -122.465018835356 | (37.7350454137208, -122.465018835356) | ||||
160297 | 160297 | 211599 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993337.92227 | 2096074.08591 | 37.7350376103014 | -122.46547689966499 | (37.7350376103014, -122.465476899665) | ||||
160700 | 160700 | 211630 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5993569.69584 | 2096076.2401 | 37.7350568899517 | -122.464675738601 | (37.7350568899517, -122.464675738601) | ||||
162038 | 162038 | 211594 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5993241.397369999 | 2096024.08182 | 37.7348947439874 | -122.465806985911 | (37.7348947439874, -122.465806985911) | ||||
162635 | 162635 | 211645 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993570.72936 | 2096039.7951900002 | 37.734956880860295 | -122.46466951978 | (37.7349568808603, -122.46466951978) | ||||
164104 | 164104 | 247027 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 550x Valley St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6002364.701780001 | 2099184.55069 | 37.7440947105094 | -122.434490470767 | (37.7440947105094, -122.434490470767) | ||||
166324 | 166324 | 211639 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993426.13357 | 2096035.66615 | 37.7349372063681 | -122.46516913456199 | (37.7349372063681, -122.465169134562) | ||||
172018 | 172018 | 211632 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993530.98701 | 2096074.66452 | 37.7350503321086 | -122.464809453402 | (37.7350503321086, -122.464809453402) | ||||
172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
172734 | 172734 | 211640 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993453.729169999 | 2096036.2807900002 | 37.734940485300896 | -122.465073772263 | (37.7349404853009, -122.465073772263) | ||||
173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
175125 | 175125 | 119933 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5986970.48357 | 2112551.91695 | 37.7799119358722 | -122.48870189430001 | (37.7799119358722, -122.4887018943) | ||||
175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
178639 | 178639 | 194661 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012476.239519999 | 2103642.76078 | 37.756904793134204 | -122.399839788377 | (37.7569047931342, -122.399839788377) | ||||
180177 | 180177 | 211656 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993885.28493 | 2096476.0493 | 37.7361728559925 | -122.463613650077 | (37.7361728559925, -122.463613650077) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");