Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 163088 | 163088 | 200189 | Undocumented 2 | Tristania conferta :: 79 | 3236 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014033.1596 | 2089680.5719 | 37.7186541836147 | -122.393478228827 | (37.7186541836147, -122.393478228827) | |||
| 16659 | 16659 | 29380 | DPW Maintained 3 | Tristania conferta :: 79 | 3231 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014087.9762 | 2089684.2263 | 37.7186672634726 | -122.393289004191 | (37.7186672634726, -122.393289004191) | ||
| 15499 | 15499 | 29379 | Permitted Site 1 | Tristania conferta :: 79 | 3225 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014101.9849 | 2089704.3258 | 37.718723230996105 | -122.39324198712299 | (37.7187232309961, -122.393241987123) | ||
| 131314 | 131314 | 200179 | Undocumented 2 | Tristania conferta :: 79 | 3224 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014060.5679 | 2089717.7254 | 37.7187577226119 | -122.393386087342 | (37.7187577226119, -122.393386087342) | |||
| 14096 | 14096 | 29566 | Permitted Site 1 | Tristania conferta :: 79 | 3224 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014068.4858 | 2089729.2978 | 37.718789938046605 | -122.39335952751999 | (37.7187899380466, -122.39335952752) | ||
| 15709 | 15709 | 29381 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014224.4086 | 2089865.1211 | 37.7191715436771 | -122.392830057526 | (37.7191715436771, -122.392830057526) | ||
| 16740 | 16740 | 29382 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014237.1991 | 2089885.2205 | 37.7192274430768 | -122.39278725067498 | (37.7192274430768, -122.392787250675) | ||
| 14107 | 14107 | 29383 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014243.8989 | 2089896.7929 | 37.7192595907189 | -122.39276490097099 | (37.7192595907189, -122.392764900971) | ||
| 15085 | 15085 | 29384 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014251.8169 | 2089910.1925 | 37.7192968231465 | -122.39273846811199 | (37.7192968231465, -122.392738468112) | ||
| 15503 | 15503 | 29385 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014260.3439 | 2089918.7195 | 37.7193207101956 | -122.39270958943999 | (37.7193207101956, -122.39270958944) | ||
| 50280 | 50280 | 200158 | Undocumented 2 | Tristania conferta :: 79 | 3198 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014214.6634 | 2089926.0284 | 37.7193382417884 | -122.39286800212601 | (37.7193382417884, -122.392868002126) | |||
| 15923 | 15923 | 29386 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.719364835170396 | -122.392670694873 | (37.7193648351704, -122.392670694873) | ||
| 15071 | 15071 | 29387 | DPW Maintained 3 | Tristania conferta :: 79 | 3103 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014285.3159 | 2089950.3913 | 37.7194090616104 | -122.392625484256 | (37.7194090616104, -122.392625484256) | ||
| 13658 | 13658 | 29560 | DPW Maintained 3 | Tristania conferta :: 79 | 3100X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 16 | 3X3 | 6014251.2078 | 2089975.3633 | 37.7194757354442 | -122.39274513029 | (37.7194757354442, -122.39274513029) | ||
| 188054 | 188054 | 200154 | Undocumented 2 | Tristania conferta :: 79 | 3101 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014306.6335 | 2089979.6268 | 37.7194905204176 | -122.392553840565 | (37.7194905204176, -122.392553840565) | |||
| 69731 | 69731 | 200256 | Undocumented 2 | Tristania conferta :: 79 | 3100 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014294.4520000005 | 2090037.4888 | 37.719648721514 | -122.39259999327801 | (37.719648721514, -122.392599993278) | |||
| 42165 | 42165 | 200240 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014390.6856 | 2090089.8691 | 37.7197978915 | -122.392271007172 | (37.7197978915, -122.392271007172) | |||
| 123425 | 123425 | 200225 | Undocumented 2 | Tristania conferta :: 79 | 3098 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014353.5321 | 2090113.0139 | 37.7198593794464 | -122.392401052747 | (37.7198593794464, -122.392401052747) | |||
| 49160 | 49160 | 200241 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014416.2666 | 2090127.0226 | 37.719901328074 | -122.39218517897899 | (37.719901328074, -122.392185178979) | |||
| 177137 | 177137 | 200242 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014430.8844 | 2090146.5129 | 37.7199556562223 | -122.39213601225201 | (37.7199556562223, -122.392136012252) | |||
| 152647 | 152647 | 200243 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014440.6296 | 2090158.0853 | 37.719987972824896 | -122.39210313506099 | (37.7199879728249, -122.392103135061) | |||
| 14948 | 14948 | 29394 | Permitted Site 1 | Tristania conferta :: 79 | 3019 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6014458.2927 | 2090182.4482 | 37.720055849211604 | -122.392043782138 | (37.7200558492116, -122.392043782138) | ||
| 16048 | 16048 | 29395 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014475.9558 | 2090207.4202 | 37.7201253980359 | -122.39198447167699 | (37.7201253980359, -122.391984471677) | ||
| 14830 | 14830 | 29396 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014489.3554 | 2090228.1287 | 37.720183003403704 | -122.39193960073999 | (37.7201830034037, -122.39193960074) | ||
| 42216 | 42216 | 200803 | Undocumented 2 | Tristania conferta :: 79 | 6325 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013205.3174 | 2090330.4355 | 37.72039254732071 | -122.396385289165 | (37.7203925473207, -122.396385289165) | |||
| 23303 | 23303 | 22490 | DPW Maintained 3 | Tristania conferta :: 79 | 6300 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6013127.1033 | 2090369.4903 | 37.7204954312128 | -122.396658388199 | (37.7204954312128, -122.396658388199) | ||||
| 179733 | 179733 | 200187 | Undocumented 2 | Tristania conferta :: 79 | 2999 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014602.6431 | 2090373.0881 | 37.720587322073 | -122.391558129174 | (37.720587322073, -122.391558129174) | |||
| 13997 | 13997 | 22496 | DPW Maintained 3 | Tristania conferta :: 79 | 6321 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2011 12:00:00 AM | 3 | 3x3 | 6013227.4986 | 2090389.3545 | 37.7205555613998 | -122.396312742847 | (37.7205555613998, -122.396312742847) | ||
| 14819 | 14819 | 29402 | Permitted Site 1 | Tristania conferta :: 79 | 2919 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | 6014617.8699 | 2090399.8874 | 37.720661752825706 | -122.391507367115 | (37.7206617528257, -122.391507367115) | |||
| 29655 | 29655 | 22495 | DPW Maintained 3 | Tristania conferta :: 79 | 6315 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/2011 12:00:00 AM | 1 | 3x3 | 6013233.044 | 2090405.2973 | 37.7205996457096 | -122.396294690849 | (37.7205996457096, -122.396294690849) | ||
| 14024 | 14024 | 29547 | Permitted Site 1 | Tristania conferta :: 79 | 2920 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014582.5436 | 2090417.5505 | 37.720708291367 | -122.391630714392 | (37.720708291367, -122.391630714392) | ||
| 14292 | 14292 | 22494 | DPW Maintained 3 | Tristania conferta :: 79 | 6315 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013237.8961 | 2090421.2401 | 37.7206436914379 | -122.39627903536699 | (37.7206436914379, -122.396279035367) | |||
| 16696 | 16696 | 29546 | DPW Maintained 3 | Tristania conferta :: 79 | 2900X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6014598.9886 | 2090439.4771 | 37.7207694102971 | -122.39157540084999 | (37.7207694102971, -122.39157540085) | ||
| 15276 | 15276 | 22492 | DPW Maintained 3 | Tristania conferta :: 79 | 6301 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2011 12:00:00 AM | 8 | 3X3 | 6013246.9072 | 2090443.4213 | 37.7207050979835 | -122.396249440399 | (37.7207050979835, -122.396249440399) | ||
| 14950 | 14950 | 87474 | DPW Maintained 3 | Tristania conferta :: 79 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726988998 | (37.7209087510834, -122.39647726989) | |||
| 49502 | 49502 | 200163 | Undocumented 2 | Tristania conferta :: 79 | 1200 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014648.9326 | 2090536.3198 | 37.721038093310796 | -122.39140952495899 | (37.7210380933108, -122.391409524959) | |||
| 14045 | 14045 | 29406 | Permitted Site 1 | Tristania conferta :: 79 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.39107255471599 | (37.7211221378179, -122.391072554716) | ||
| 16303 | 16303 | 95313 | DPW Maintained 3 | Tristania conferta :: 79 | 6295 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2011 12:00:00 AM | 3 | 3x3 | 6013297.1751 | 2090576.8022 | 37.7210741321738 | -122.396085021222 | (37.7210741321738, -122.396085021222) | ||
| 15472 | 15472 | 22489 | Permitted Site 1 | Tristania conferta :: 79 | 6283 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 6 | 3x3 | 6013301.3486 | 2090589.3102 | 37.7211087088425 | -122.396071470667 | (37.7211087088425, -122.396071470667) | ||
| 15081 | 15081 | 22487 | Permitted Site 1 | Tristania conferta :: 79 | 6275 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1995 12:00:00 AM | 12 | 3x3 | 6013315.0844 | 2090629.8634 | 37.7212208240298 | -122.39602683012698 | (37.7212208240298, -122.396026830127) | ||
| 15636 | 15636 | 22484 | DPW Maintained 3 | Tristania conferta :: 79 | 6271 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1998 12:00:00 AM | 3 | 3x3 | 6013332.0905 | 2090676.3033 | 37.72134928484171 | -122.395971297174 | (37.7213492848417, -122.395971297174) | ||
| 14490 | 14490 | 22478 | DPW Maintained 3 | Tristania conferta :: 79 | 6255 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6013343.2099 | 2090697.888 | 37.7214091707282 | -122.39593437203101 | (37.7214091707282, -122.395934372031) | |||
| 41635 | 41635 | 200152 | Undocumented 2 | Tristania conferta :: 79 | 6251 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013352.3671 | 2090722.0891 | 37.7214761315479 | -122.395904412913 | (37.7214761315479, -122.395904412913) | |||
| 183290 | 183290 | 199659 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014895.3627 | 2090769.4954 | 37.7216920217337 | -122.39057396691003 | (37.7216920217337, -122.39057396691) | |||
| 28713 | 28713 | 199660 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014919.1748 | 2090797.1689 | 37.7217693287026 | -122.390493586774 | (37.7217693287026, -122.390493586774) | |||
| 28394 | 28394 | 36794 | Permitted Site 1 | Tristania conferta :: 79 | 1350 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39527 | 6015278.7143 | 2090801.8757 | 37.721802191533705 | -122.38925107024599 | (37.7218021915337, -122.389251070246) | |
| 73046 | 73046 | 199661 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014931.4027 | 2090815.1889 | 37.7218194863987 | -122.390452576229 | (37.7218194863987, -122.390452576229) | |||
| 186664 | 186664 | 199655 | Undocumented 2 | Tristania conferta :: 79 | 2798 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014883.1348 | 2090822.9118 | 37.721838014236205 | -122.39061996667299 | (37.7218380142362, -122.390619966673) | |||
| 15623 | 15623 | 22475 | DPW Maintained 3 | Tristania conferta :: 79 | 6245 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1995 12:00:00 AM | 3 | 3x3 | 6013399.7881 | 2090837.5348 | 37.7217957603798 | -122.395748575331 | (37.7217957603798, -122.395748575331) | ||
| 16478 | 16478 | 22473 | DPW Maintained 3 | Tristania conferta :: 79 | 6237 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1995 12:00:00 AM | 6 | 3x3 | 6013406.3289 | 2090861.7358 | 37.7218625753274 | -122.395727660172 | (37.7218625753274, -122.395727660172) | ||
| 13492 | 13492 | 29408 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014970.0169 | 2090872.4668 | 37.7219789022018 | -122.39032309567 | (37.7219789022018, -122.39032309567) | ||
| 31667 | 31667 | 199657 | Undocumented 2 | Tristania conferta :: 79 | 1395 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015062.4933 | 2090889.5822 | 37.7220310269415 | -122.39000462027599 | (37.7220310269415, -122.390004620276) | |||
| 15696 | 15696 | 29409 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014989.3241 | 2090898.8532 | 37.7220524249966 | -122.39025819753901 | (37.7220524249966, -122.390258197539) | ||
| 13659 | 13659 | 22470 | Permitted Site 1 | Tristania conferta :: 79 | 6227 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1995 12:00:00 AM | 5 | 3x3 | 6013423.3351 | 2090899.6727 | 37.7219676884588 | -122.39567153040701 | (37.7219676884588, -122.395671530407) | ||
| 16712 | 16712 | 22469 | DPW Maintained 3 | Tristania conferta :: 79 | 6221 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1995 12:00:00 AM | 5 | 3x3 | 6013435.1086 | 2090931.7227 | 37.722056346244 | -122.395633076514 | (37.722056346244, -122.395633076514) | ||
| 48250 | 48250 | 199652 | Undocumented 2 | Tristania conferta :: 79 | 2700 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014964.2248 | 2090934.2496 | 37.722148224277205 | -122.390347432201 | (37.7221482242772, -122.390347432201) | |||
| 151205 | 151205 | 200143 | Undocumented 2 | Tristania conferta :: 79 | 6215 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6013445.5739 | 2090955.2697 | 37.7221215837156 | -122.395598549244 | (37.7221215837156, -122.395598549244) | |||
| 168967 | 168967 | 199795 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015060.1169 | 2090989.5967 | 37.7223055152201 | -122.39001981815599 | (37.7223055152201, -122.390019818156) | |||
| 184619 | 184619 | 199796 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015085.8598 | 2091024.3496 | 37.7224023675174 | -122.389933256672 | (37.7224023675174, -122.389933256672) | |||
| 15695 | 15695 | 22463 | DPW Maintained 3 | Tristania conferta :: 79 | 6202 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/02/2011 12:00:00 AM | 3 | 3x3 | 6013379.6455 | 2091026.8711 | 37.7223145193079 | -122.395831463965 | (37.7223145193079, -122.395831463965) | ||
| 188411 | 188411 | 199797 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015107.7412 | 2091052.6667 | 37.7224813341695 | -122.389859594082 | (37.7224813341695, -122.389859594082) | |||
| 150258 | 150258 | 199798 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015121.8998 | 2091073.261 | 37.7225386672258 | -122.389812088389 | (37.7225386672258, -122.389812088389) | |||
| 173133 | 173133 | 199799 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015139.2762 | 2091096.4296 | 37.72260324722 | -122.389753639026 | (37.72260324722, -122.389753639026) | |||
| 72699 | 72699 | 199800 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015155.3655 | 2091117.0238 | 37.7226606870185 | -122.389699459103 | (37.7226606870185, -122.389699459103) | |||
| 13647 | 13647 | 30096 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2011 12:00:00 AM | 6 | 3x3 | 6013417.4786 | 2091122.0564 | 37.722577983662504 | -122.395707348923 | (37.7225779836625, -122.395707348923) | ||
| 34345 | 34345 | 200150 | Undocumented 2 | Tristania conferta :: 79 | 6199 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013507.0577 | 2091126.6395 | 37.7225955506276 | -122.39539801261499 | (37.7225955506276, -122.395398012615) | |||
| 15886 | 15886 | 30095 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013424.226 | 2091142.2984 | 37.7226339394685 | -122.395685442076 | (37.7226339394685, -122.395685442076) | |||
| 13739 | 13739 | 30026 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6013442.0581 | 2091191.4573 | 37.7227699118645 | -122.39562724256201 | (37.7227699118645, -122.395627242562) | ||
| 16179 | 16179 | 30024 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013452.1791 | 2091216.0368 | 37.7228379652128 | -122.39559397744 | (37.7228379652128, -122.39559397744) | |||
| 13674 | 13674 | 29421 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6015238.3862 | 2091224.5002 | 37.7229603992916 | -122.389419974154 | (37.7229603992916, -122.389419974154) | ||
| 49166 | 49166 | 200149 | Undocumented 2 | Tristania conferta :: 79 | 6101 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6013550.8813 | 2091248.9530000002 | 37.7229338362641 | -122.39525508692101 | (37.7229338362641, -122.395255086921) | |||
| 16447 | 16447 | 29423 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6015296.9511 | 2091308.8081 | 37.7231951390157 | -122.38922340969101 | (37.7231951390157, -122.389223409691) | ||
| 14365 | 14365 | 29425 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015328.4861 | 2091346.7788 | 37.7233011472419 | -122.389117048339 | (37.7233011472419, -122.389117048339) | ||
| 15654 | 15654 | 22460 | DPW Maintained 3 | Tristania conferta :: 79 | 6150 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013503.2659 | 2091352.4289 | 37.7232153120582 | -122.39542693034402 | (37.7232153120582, -122.395426930344) | |||
| 13890 | 13890 | 29426 | Permitted Site 1 | Tristania conferta :: 79 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | ||
| 14949 | 14949 | 22438 | DPW Maintained 3 | Tristania conferta :: 79 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.72336088868371 | -122.395066921688 | (37.7233608886837, -122.395066921688) | |||
| 13508 | 13508 | 29427 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.38896553930401 | (37.7234697537221, -122.388965539304) | ||
| 16191 | 16191 | 22439 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2011 12:00:00 AM | 3 | 3X3 | 6013618.2519 | 2091420.3228 | 37.7234081298852 | -122.39503419617901 | (37.7234081298852, -122.395034196179) | ||
| 15225 | 15225 | 22440 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | ||
| 14886 | 14886 | 29429 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015416.6554 | 2091465.8395 | 37.7236329516711 | -122.388820569012 | (37.7236329516711, -122.388820569012) | ||
| 13617 | 13617 | 29430 | Permitted Site 1 | Tristania conferta :: 79 | 2401X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015434.0318 | 2091490.2952 | 37.7237010652846 | -122.388762207738 | (37.7237010652846, -122.388762207738) | ||
| 13756 | 13756 | 29432 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | ||
| 15822 | 15822 | 29431 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015465.5668 | 2091536.6323 | 37.7238300455694 | -122.388656428754 | (37.7238300455694, -122.388656428754) | ||
| 15369 | 15369 | 22443 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.39488407213601 | (37.7237303604467, -122.394884072136) | |||
| 15158 | 15158 | 29434 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015482.9432 | 2091559.1573 | 37.723892857778104 | -122.38859793246701 | (37.7238928577781, -122.388597932467) | ||
| 13571 | 13571 | 29433 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | ||
| 153593 | 153593 | 199820 | Undocumented 2 | Tristania conferta :: 79 | 2311 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015569.4483 | 2091672.6551 | 37.724209294028896 | -122.388306813339 | (37.7242092940289, -122.388306813339) | |||
| 66323 | 66323 | 200509 | Undocumented 2 | Tristania conferta :: 79 | 5999 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6013721.597 | 2091689.1509 | 37.7241520241375 | -122.39469576540199 | (37.7241520241375, -122.394695765402) | |||
| 133305 | 133305 | 199823 | Undocumented 2 | Tristania conferta :: 79 | 2350 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015539.2196 | 2091696.8381 | 37.724274020732004 | -122.388412997536 | (37.724274020732, -122.388412997536) | |||
| 56152 | 56152 | 199821 | Undocumented 2 | Tristania conferta :: 79 | 2309 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015591.9824 | 2091704.5326 | 37.7242980719622 | -122.388231139286 | (37.7242980719622, -122.388231139286) | |||
| 172169 | 172169 | 199822 | Undocumented 2 | Tristania conferta :: 79 | 2350 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015555.1584 | 2091721.021 | 37.7243413054209 | -122.388359585978 | (37.7243413054209, -122.388359585978) | |||
| 13454 | 13454 | 29437 | DPW Maintained 3 | Tristania conferta :: 79 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.72437616438229 | -122.388162796666 | (37.7243761643823, -122.388162796666) | ||
| 14504 | 14504 | 29438 | DPW Maintained 3 | Tristania conferta :: 79 | 2305X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015624.4095 | 2091751.2497 | 37.72442814458989 | -122.388122301142 | (37.7244281445899, -122.388122301142) | ||
| 15436 | 15436 | 29533 | DPW Maintained 3 | Tristania conferta :: 79 | 2304X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015579.3413 | 2091755.0969999998 | 37.724436211393396 | -122.388278365495 | (37.7244362113934, -122.388278365495) | ||
| 13552 | 13552 | 29439 | DPW Maintained 3 | Tristania conferta :: 79 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.38806679762199 | (37.7244879141293, -122.388066797622) | ||
| 183030 | 183030 | 200510 | Undocumented 2 | Tristania conferta :: 79 | 5913 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013756.9175 | 2091787.9175 | 37.7244251810597 | -122.394580579707 | (37.7244251810597, -122.394580579707) | |||
| 14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
| 45240 | 45240 | 200511 | Undocumented 2 | Tristania conferta :: 79 | 5913 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013766.0746 | 2091810.1563 | 37.7244867534159 | -122.394550481156 | (37.7244867534159, -122.394550481156) | |||
| 13783 | 13783 | 29532 | DPW Maintained 3 | Tristania conferta :: 79 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | ||
| 16375 | 16375 | 22415 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53653 | 6013701.5886 | 2091876.0685 | 37.7246641498069 | -122.39477801609101 | (37.7246641498069, -122.394778016091) |
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");