trees
531 rows where Fire Prevention Districts = 15 and qSpecies_id = 54 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30164 | 138611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1711 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6000013.0072 | 2114911.1445 | 37.7871422388637 | -122.443751687038 | (37.7871422388637, -122.443751687038) | 15 | 6 | 1 | 29490 | 31 | |||
118617 | 111432 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | 15 | 6 | 1 | 29490 | 31 | |||
22348 | 111433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | 15 | 6 | 1 | 29490 | 31 | |||
93628 | 138626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1707 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000016.9472 | 2114873.7147 | 37.7870396910965 | -122.443735365508 | (37.7870396910965, -122.443735365508) | 15 | 6 | 1 | 29490 | 31 | |||
137924 | 111431 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999170.7617 | 2114883.4508 | 37.7870181241285 | -122.446663667925 | (37.7870181241285, -122.446663667925) | 15 | 6 | 1 | 29490 | 31 | |||
152825 | 138608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999173.5218 | 2114868.2702 | 37.78697659984 | -122.446653025988 | (37.78697659984, -122.446653025988) | 15 | 6 | 1 | 29490 | 31 | |||
128147 | 138629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1705 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000022.8572 | 2114841.5382 | 37.7869516798811 | -122.443712605837 | (37.7869516798811, -122.443712605837) | 15 | 6 | 1 | 29490 | 31 | |||
61706 | 138607 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 512 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999174.9019 | 2114851.0194 | 37.7869293124952 | -122.446647009525 | (37.7869293124952, -122.446647009525) | 15 | 6 | 1 | 29490 | 31 | |||
10282 | 18081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | 15 | 6 | 1 | 29490 | 31 | |||
106261 | 13311 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2973X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 5999715.5386 | 2114669.4924 | 37.7864617540071 | -122.444763483448 | (37.7864617540071, -122.444763483448) | 15 | 6 | 1 | 29490 | 31 | |||
36660 | 138731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000355.1143 | 2114408.2991 | 37.7857810625069 | -122.44253195817 | (37.7857810625069, -122.44253195817) | 15 | 6 | 1 | 29490 | 27 | |||
45097 | 138716 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | 15 | 6 | 1 | 29490 | 31 | |||
13248 | 138690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2838 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999904.6577 | 2114405.5136 | 37.7857477274076 | -122.444090205696 | (37.7857477274076, -122.444090205696) | 15 | 6 | 1 | 29490 | 31 | |||
180949 | 38058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | 15 | 6 | 1 | 29490 | 31 | |
83635 | 138691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999863.2879 | 2114398.2903 | 37.7857255339984 | -122.444232813751 | (37.7857255339984, -122.444232813751) | 15 | 6 | 1 | 29490 | 31 | |||
106147 | 138717 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1607 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999600.5215 | 2114397.0591 | 37.7857071588413 | -122.445141819006 | (37.7857071588413, -122.445141819006) | 15 | 6 | 1 | 29490 | 31 | |||
35064 | 138707 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.444654293951 | (37.7856770956012, -122.444654293951) | 15 | 6 | 1 | 29490 | 31 | |||
111393 | 106408 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 5x9 | 5999241.4715 | 2114391.8555 | 37.7856723708173 | -122.446383650374 | (37.7856723708173, -122.446383650374) | 15 | 6 | 1 | 29490 | 31 | |||
182958 | 138718 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1605 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999603.495 | 2114383.6783 | 37.7856705883683 | -122.445130569247 | (37.7856705883683, -122.445130569247) | 15 | 6 | 1 | 29490 | 31 | |||
129892 | 58879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.7856114118811 | -122.445177156478 | (37.7856114118811, -122.445177156478) | 15 | 6 | 1 | 29490 | 31 | ||
154652 | 106407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x6 | 5999244.445 | 2114365.5896 | 37.7856004213418 | -122.446371472736 | (37.7856004213418, -122.446371472736) | 15 | 6 | 1 | 29490 | 31 | |||
43953 | 138715 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.7855987705543 | -122.445234179741 | (37.7855987705543, -122.445234179741) | 15 | 6 | 1 | 29490 | 31 | |||
145096 | 47470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | 15 | 6 | 1 | 29490 | 31 | ||
84048 | 57327 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.7855920575643 | -122.445393527485 | (37.7855920575643, -122.445393527485) | 15 | 6 | 1 | 29490 | 31 | ||
53873 | 106406 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x6 | 5999248.4097 | 2114351.2177 | 37.7855611862943 | -122.446356721815 | (37.7855611862943, -122.446356721815) | 15 | 6 | 1 | 29490 | 31 | |||
165670 | 61337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392 | 2114334.8634 | 37.7855163948709 | -122.446348686743 | (37.7855163948709, -122.446348686743) | 15 | 6 | 1 | 29490 | 31 | |
83301 | 139365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1590 LYON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999665.9385 | 2114296.9513 | 37.7854360225018 | -122.444908296806 | (37.7854360225018, -122.444908296806) | 15 | 6 | 1 | 29490 | 31 | |||
129515 | 138745 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999354.2167 | 2114269.6942 | 37.7853433864461 | -122.445984796208 | (37.7853433864461, -122.445984796208) | 15 | 6 | 1 | 29490 | 31 | |||
113925 | 138744 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999334.3934 | 2114268.2075 | 37.7853381723766 | -122.446053271608 | (37.7853381723766, -122.446053271608) | 15 | 6 | 1 | 29490 | 31 | |||
148115 | 138743 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999307.6319 | 2114263.2516 | 37.7853230365302 | -122.446145501349 | (37.7853230365302, -122.446145501349) | 15 | 6 | 1 | 29490 | 31 | |||
157472 | 138742 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999291.2776 | 2114261.7649 | 37.7853180204784 | -122.446201975075 | (37.7853180204784, -122.446201975075) | 15 | 6 | 1 | 29490 | 31 | |||
124768 | 138741 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999272.4455 | 2114257.3047 | 37.7853046984356 | -122.446266807223 | (37.7853046984356, -122.446266807223) | 15 | 6 | 1 | 29490 | 31 | |||
142147 | 138749 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000156.6321 | 2114235.0077 | 37.7852939335101 | -122.443206197892 | (37.7852939335101, -122.443206197892) | 15 | 6 | 1 | 29490 | 27 | |||
67896 | 59593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.7852505885272 | -122.443194090382 | (37.7852505885272, -122.443194090382) | 15 | 6 | 1 | 29490 | 27 | ||
149607 | 138740 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999265.5073 | 2114223.1094 | 37.7852104108131 | -122.446288350453 | (37.7852104108131, -122.446288350453) | 15 | 6 | 1 | 29490 | 31 | |||
53611 | 138739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999270.4631 | 2114185.9407 | 37.7851086382869 | -122.446268530298 | (37.7851086382869, -122.446268530298) | 15 | 6 | 1 | 29490 | 31 | |||
84375 | 138765 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2736 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999497.9358 | 2113999.1058 | 37.7846086267732 | -122.445468109626 | (37.7846086267732, -122.445468109626) | 15 | 6 | 1 | 29490 | 31 | |||
125107 | 105341 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1407 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6000167.325 | 2113807.8025 | 37.7841215482425 | -122.4431385113 | (37.7841215482425, -122.4431385113) | 15 | 6 | 11 | 29490 | 31 | ||||
194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
158404 | 139083 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2512 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000143.6633 | 2113744.4727 | 37.7839463117797 | -122.443215821997 | (37.7839463117797, -122.443215821997) | 15 | 6 | 11 | 29490 | 31 | |||
71607 | 61078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.444377837774 | (37.7837992291467, -122.444377837774) | 15 | 6 | 11 | 29490 | 31 | ||
53133 | 104353 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2594 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999783.3073 | 2113692.3242 | 37.7837825709749 | -122.444458768108 | (37.7837825709749, -122.444458768108) | 15 | 6 | 11 | 29490 | 31 | |||
101660 | 121389 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | 15 | 6 | 11 | 29490 | 31 | |||
11526 | 66368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | 15 | 6 | 1 | 54 | 31 | |
25346 | 139115 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2613 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999526.5436 | 2113598.8751 | 37.7835113303016 | -122.445340349757 | (37.7835113303016, -122.445340349757) | 15 | 6 | 1 | 29490 | 31 | |||
111506 | 140932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 COOK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997447.8074 | 2113631.9151 | 37.783483168451 | -122.452534319363 | (37.783483168451, -122.452534319363) | 15 | 6 | 1 | 54 | 31 | |||
24743 | 66562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.7833936486138 | -122.450290371551 | (37.7833936486138, -122.450290371551) | 15 | 6 | 1 | 54 | 31 | |
155852 | 139407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1311 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000207.9303 | 2113507.632 | 37.7832996726996 | -122.442976468383 | (37.7832996726996, -122.442976468383) | 15 | 6 | 1 | 29490 | 31 | |||
130423 | 137532 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300 Pierce St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002250.4834 | 2113262.6052 | 37.7827431340216 | -122.435892519009 | (37.7827431340216, -122.435892519009) | 15 | 5 | 11 | 29490 | 41 | |||
51977 | 141307 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 61 COOK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5997486.7259 | 2113348.6561 | 37.7827076436193 | -122.452379230189 | (37.7827076436193, -122.452379230189) | 15 | 6 | 1 | 54 | 31 | |||
112434 | 137529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.435860649108 | (37.7825202770743, -122.435860649108) | 15 | 5 | 11 | 29490 | 41 | |||
79599 | 137528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300 Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6002263.2838 | 2113153.4253 | 37.7824440807926 | -122.435840420812 | (37.7824440807926, -122.435840420812) | 15 | 5 | 11 | 29490 | 41 | |||
138181 | 140745 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2069 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001396.8514 | 2113169.2925 | 37.7824383924166 | -122.438839029082 | (37.7824383924166, -122.438839029082) | 15 | 5 | 11 | 29490 | 41 | |||
97734 | 140446 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1435 EDDY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003632.9 | 2112791.8873 | 37.781529093472 | -122.431076337144 | (37.781529093472, -122.431076337144) | 15 | 9 | 11 | 29490 | 41 | |||
21051 | 141109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.448827586566 | (37.7814254265925, -122.448827586566) | 15 | 6 | 2 | 54 | 16 | |||
127244 | 107346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | 15 | 6 | 2 | 54 | 16 | |||
164343 | 140777 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.443098035367 | (37.7813935692054, -122.443098035367) | 15 | 5 | 1 | 29490 | 16 | |||
125234 | 140776 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | 15 | 5 | 1 | 29490 | 16 | |||
148694 | 119622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6000135.3841 | 2112812.4267 | 37.7813866815394 | -122.44317750199 | (37.7813866815394, -122.44317750199) | 15 | 5 | 1 | 29490 | 16 | ||||
174204 | 140775 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000103.2341 | 2112808.3657 | 37.7813736978278 | -122.443288433233 | (37.7813736978278, -122.443288433233) | 15 | 5 | 1 | 29490 | 16 | |||
159022 | 54831 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.7813662861419 | -122.443343289517 | (37.7813662861419, -122.443343289517) | 15 | 5 | 1 | 29490 | 16 | ||
85736 | 23797 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | 15 | 9 | 11 | 29490 | 41 | |||
147979 | 140482 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1137 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003743.6898 | 2112670.736 | 37.781202719512 | -122.430684409839 | (37.781202719512, -122.430684409839) | 15 | 9 | 11 | 29490 | 41 | |||
108725 | 140404 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003767 | 2112659 | 37.7811718159606 | -122.430602930425 | (37.7811718159606, -122.430602930425) | 15 | 9 | 11 | 29490 | 41 | |||
136329 | 23794 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003750.8632 | 2112612.5515 | 37.7810433657763 | -122.430655440253 | (37.7810433657763, -122.430655440253) | 15 | 9 | 11 | 29490 | 41 | |||
54101 | 140403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1119 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003754.0514 | 2112594.2194 | 37.7809932110185 | -122.430643102161 | (37.7809932110185, -122.430643102161) | 15 | 9 | 11 | 29490 | 41 | |||
54904 | 137591 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1235 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002786.4345 | 2112612.3356 | 37.7809880882364 | -122.433991859956 | (37.7809880882364, -122.433991859956) | 15 | 9 | 11 | 29490 | 41 | |||
68422 | 140405 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003761.2248 | 2112532.0496 | 37.7808229146257 | -122.430613848284 | (37.7808229146257, -122.430613848284) | 15 | 9 | 11 | 29490 | 41 | |||
89946 | 22673 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1330 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003656.8115 | 2112490.6031 | 37.780703197144 | -122.430972105719 | (37.780703197144, -122.430972105719) | 15 | 9 | 11 | 29490 | 41 | |||
82753 | 140492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1330 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003634.4941 | 2112489.009 | 37.7806975555682 | -122.431049198514 | (37.7806975555682, -122.431049198514) | 15 | 9 | 11 | 29490 | 41 | |||
184958 | 140491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | 15 | 9 | 11 | 29490 | 41 | |||
138318 | 140434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003279.731 | 2112394.6985 | 37.7804184937232 | -122.432269756603 | (37.7804184937232, -122.432269756603) | 15 | 9 | 11 | 29490 | 41 | |||
2145 | 140433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | 15 | 9 | 11 | 29490 | 41 | |||
105583 | 140431 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | 15 | 9 | 11 | 29490 | 41 | |||
61153 | 140429 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | 15 | 9 | 11 | 29490 | 41 | |||
179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
76752 | 140427 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | 15 | 9 | 11 | 29490 | 41 | |||
81097 | 140426 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.433141244136 | (37.7803076012967, -122.433141244136) | 15 | 9 | 11 | 29490 | 41 | |||
28390 | 140425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.7803005084328 | -122.43321309579 | (37.7803005084328, -122.43321309579) | 15 | 9 | 11 | 29490 | 41 | |||
102758 | 140424 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | 15 | 9 | 11 | 29490 | 41 | |||
191153 | 140423 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.433383957928 | (37.7802799627924, -122.433383957928) | 15 | 9 | 11 | 29490 | 41 | |||
191363 | 140422 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.433470553427 | (37.7802667133087, -122.433470553427) | 15 | 9 | 11 | 29490 | 41 | |||
150721 | 140693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003357.1733 | 2112337.09 | 37.780264705851 | -122.431997732698 | (37.780264705851, -122.431997732698) | 15 | 9 | 11 | 29490 | 41 | |||
128043 | 140692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003358.0022 | 2112322.1697 | 37.7802237854245 | -122.431993799423 | (37.7802237854245, -122.431993799423) | 15 | 9 | 11 | 29490 | 41 | |||
186344 | 140691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.7801942444853 | -122.431990162179 | (37.7801942444853, -122.431990162179) | 15 | 9 | 11 | 29490 | 41 | |||
68432 | 140421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002869.1903 | 2112320.0547 | 37.7801902543068 | -122.43368467143 | (37.7801902543068, -122.43368467143) | 15 | 9 | 11 | 29490 | 41 | |||
136964 | 140690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | 15 | 9 | 11 | 29490 | 41 | |||
27263 | 140420 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.433665289686 | (37.7801136820125, -122.433665289686) | 15 | 9 | 11 | 29490 | 41 | |||
75521 | 140689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.7801124033613 | -122.431982295298 | (37.7801124033613, -122.431982295298) | 15 | 9 | 11 | 29490 | 41 | |||
154157 | 140688 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003366.7058 | 2112262.0737 | 37.7800592702293 | -122.431959397228 | (37.7800592702293, -122.431959397228) | 15 | 9 | 11 | 29490 | 41 | |||
154590 | 140419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.433658630762 | (37.780048730384, -122.433658630762) | 15 | 9 | 11 | 29490 | 41 | |||
107570 | 141696 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998768.2977 | 2112343.8058 | 37.7800219238864 | -122.447873187985 | (37.7800219238864, -122.447873187985) | 15 | 6 | 2 | 54 | 16 | |||
86985 | 141695 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998748.3741 | 2112341.6402 | 37.7800148388988 | -122.447941956435 | (37.7800148388988, -122.447941956435) | 15 | 6 | 2 | 54 | 16 | |||
116510 | 141694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998733.648 | 2112339.0414 | 37.780006861514 | -122.44799271326 | (37.780006861514, -122.44799271326) | 15 | 6 | 2 | 54 | 16 | |||
148222 | 141693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998717.1894 | 2112334.7102 | 37.7799940283513 | -122.448049338774 | (37.7799940283513, -122.448049338774) | 15 | 6 | 2 | 54 | 16 | |||
83182 | 141692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998708.9601 | 2112320.4172 | 37.7799543130642 | -122.44807677808 | (37.7799543130642, -122.44807677808) | 15 | 6 | 2 | 54 | 16 | |||
23992 | 20166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6002621 | 2112212 | 37.7798794773869 | -122.434535545992 | (37.7798794773869, -122.434535545992) | 15 | 5 | 11 | 29490 | 41 | |||
184887 | 137574 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.433750829498 | (37.7797734277366, -122.433750829498) | 15 | 9 | 11 | 29490 | 41 | |||
68988 | 140439 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1100 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003462.4449 | 2112120.7446 | 37.7796766428298 | -122.431618099739 | (37.7796766428298, -122.431618099739) | 15 | 9 | 11 | 29490 | 41 | |||
157137 | 45611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401 | (37.7796667869975, -122.43166374401) | 15 | 9 | 11 | 29490 | 41 |
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) );