trees
1,345 rows where qLegalStatus_id = 1 and qSpecies_id = 95 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194108 | 185186 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2500 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985145.3106 | 2097846.0357 | 37.7394269990792 | -122.493931809687 | (37.7394269990792, -122.493931809687) | 1 | 8 | 3 | 29491 | 35 | |||
194007 | 22791 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1008X Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6000922.6378 | 2112256.3151 | 37.7799045987504 | -122.44041409826 | (37.7799045987504, -122.44041409826) | 15 | 5 | 11 | 29490 | 41 | |||
193787 | 183220 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3334 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982719.2756 | 2100178.2815 | 37.7456884593513 | -122.502492404811 | (37.7456884593513, -122.502492404811) | 1 | 8 | 3 | 29491 | 35 | |||
193786 | 185321 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984996.5739 | 2097166.5141 | 37.7375525114305 | -122.494395991403 | (37.7375525114305, -122.494395991403) | 1 | 8 | 3 | 29491 | 35 | |||
193706 | 219152 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 6ft | 5991180.06905 | 2105137.85002 | 37.759799666743 | -122.473598237272 | (37.759799666743, -122.473598237272) | 1 | 8 | 4 | 56 | 12 | |||
193560 | 139079 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2245 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001410.9091 | 2113865.4385 | 37.7843506313341 | -122.438840297721 | (37.7843506313341, -122.438840297721) | 15 | 6 | 11 | 29490 | 13 | |||
193182 | 227558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4648 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000435.44361 | 2104661.21425 | 37.7590226012171 | -122.441554329764 | (37.7590226012171, -122.441554329764) | 2 | 4 | 5 | 28862 | 3 | |||
193093 | 186391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984805.569 | 2102404.1116 | 37.7519223510287 | -122.495442549828 | (37.7519223510287, -122.495442549828) | 1 | 8 | 3 | 56 | 35 | |||
193069 | 253276 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 998 Douglass St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226 | 2100921 | 37.7487978830785 | -122.438552231639 | (37.7487978830785, -122.438552231639) | 2 | 4 | 5 | 28862 | 22 | ||
192967 | 185420 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 36 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985096.6371 | 2099279.3646 | 37.7433596860109 | -122.494205716911 | (37.7433596860109, -122.494205716911) | 1 | 8 | 3 | 29491 | 35 | |||
192945 | 178376 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 195 Allison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000081.42891 | 2087748.87485 | 37.712565114463 | -122.441565023612 | (37.712565114463, -122.441565023612) | 9 | 7 | 6 | 28861 | 5 | |||
192940 | 185890 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985019.5893 | 2101161.6914 | 37.7485235348142 | -122.494610863585 | (37.7485235348142, -122.494610863585) | 1 | 8 | 3 | 29491 | 35 | |||
192743 | 211365 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1x Minerva St | 13 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5996056.33729 | 2089003.23942 | 37.7157791619554 | -122.455567518236 | (37.7157791619554, -122.455567518236) | 9 | 8 | 6 | 28861 | 24 | |||
192646 | 185984 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2001 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984862.8861 | 2101045.5811 | 37.7481955546607 | -122.495144171736 | (37.7481955546607, -122.495144171736) | 1 | 8 | 3 | 29491 | 35 | |||
192569 | 250336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 27th Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5987380.06723 | 2115230.15893 | 37.7872895171323 | -122.48748177497 | (37.7872895171323, -122.48748177497) | 11 | 6 | 1 | 55 | 33 | |||
192546 | 118515 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 8101 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5981830.75546 | 2112312.1769 | 37.7789524069017 | -122.506464407278 | (37.7789524069017, -122.506464407278) | 11 | 6 | 2 | 55 | 26 | |||
192540 | 186785 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984846.1414 | 2106857.3525 | 37.7641520878967 | -122.495630683702 | (37.7641520878967, -122.495630683702) | 1 | 8 | 3 | 56 | 35 | |||
192275 | 186071 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1901 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984835.467 | 2102046.6826 | 37.750942699833 | -122.495312802816 | (37.750942699833, -122.495312802816) | 1 | 8 | 3 | 29491 | 35 | |||
192115 | 182930 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2638 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982150.6342 | 2097134.8675 | 37.737298653985 | -122.504233241862 | (37.737298653985, -122.504233241862) | 1 | 8 | 3 | 29491 | 35 | |||
192087 | 132326 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900 Green St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008538.05329 | 2119021.31977 | 37.7989103246178 | -122.414547752584 | (37.7989103246178, -122.414547752584) | 5 | 1 | 10 | 308 | 32 | |||
192063 | 183260 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980890.8145 | 2106708.2585 | 37.76351030418 | -122.509299696626 | (37.76351030418, -122.509299696626) | 1 | 8 | 3 | 56 | 35 | |||
192040 | 233954 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 51 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6002902.189 | 2097480.2364 | 37.7394455545679 | -122.432510251748 | (37.7394455545679, -122.432510251748) | 2 | 7 | 5 | 63 | 7 | |||
191869 | 181454 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.7669 | 2105104.6837 | 37.7593407233891 | -122.495443909168 | (37.7593407233891, -122.495443909168) | 1 | 8 | 3 | 56 | 35 | |||
191741 | 185292 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984972.0785 | 2097370.0138 | 37.738109833477 | -122.494495679492 | (37.738109833477, -122.494495679492) | 1 | 8 | 3 | 29491 | 35 | |||
191044 | 44433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.7103892965003 | -122.434330380639 | (37.7103892965003, -122.434330380639) | 9 | 7 | 6 | 28861 | 5 | |
191010 | 185723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2101 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984874.1643 | 2100328.8424 | 37.7462282459464 | -122.495052329472 | (37.7462282459464, -122.495052329472) | 1 | 8 | 3 | 29491 | 35 | |||
191002 | 185031 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2701 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984996.2598 | 2096307.8164 | 37.7351947387018 | -122.49433379981 | (37.7351947387018, -122.49433379981) | 1 | 8 | 3 | 29491 | 35 | |||
190992 | 178384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002851.22923 | 2092740.35479 | 37.726428028905 | -122.432348011369 | (37.726428028905, -122.432348011369) | 9 | 7 | 6 | 28861 | 5 | |||
190943 | 132287 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 926 Taylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6009134.27648 | 2116171.69815 | 37.7911194401688 | -122.412283098711 | (37.7911194401688, -122.412283098711) | 5 | 1 | 10 | 28857 | 21 | |||
190926 | 103703 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4700 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 5980967.69346 | 2110300.1672 | 37.7733771705098 | -122.509300569193 | (37.7733771705098, -122.509300569193) | 11 | 6 | 2 | 55 | 26 | |||
190703 | 181444 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984879.4757 | 2105060.127 | 37.7592193614535 | -122.495382836778 | (37.7592193614535, -122.495382836778) | 1 | 8 | 3 | 56 | 35 | |||
190650 | 211360 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 205 Granada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995618.4586 | 2091274.81338 | 37.7219912298988 | -122.457245251188 | (37.7219912298988, -122.457245251188) | 9 | 8 | 4 | 28861 | 24 | |||
190307 | 132335 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 603 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007080.77462 | 2122230.42424 | 37.80763973344 | -122.419818260919 | (37.80763973344, -122.419818260919) | 5 | 1 | 1 | 308 | 32 | |||
190018 | 233951 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 162 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002803.21932 | 2097405.15608 | 37.7392337885099 | -122.432847082927 | (37.7392337885099, -122.432847082927) | 2 | 7 | 5 | 63 | 7 | |||
189999 | 211343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2464 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5992061.49355 | 2098678.91862 | 37.7421161210646 | -122.470079538139 | (37.7421161210646, -122.470079538139) | 1 | 8 | 4 | 29491 | 40 | |||
189903 | 186209 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1701 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984763.6006 | 2103397.6649 | 37.7546479167619 | -122.495660958323 | (37.7546479167619, -122.495660958323) | 1 | 8 | 3 | 56 | 35 | |||
189745 | 123915 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 389 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993078.24924 | 2112871.04962 | 37.7811427178869 | -122.46759581141 | (37.7811427178869, -122.46759581141) | 11 | 6 | 2 | 54 | 11 | |||
189698 | 181527 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1300 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984868.615 | 2105743.7944 | 37.7610958854432 | -122.495470820725 | (37.7610958854432, -122.495470820725) | 1 | 8 | 3 | 56 | 35 | |||
189634 | 123279 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 539 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994047.26303 | 2111825.17321 | 37.7783269225833 | -122.464167582464 | (37.7783269225833, -122.464167582464) | 11 | 6 | 2 | 54 | 11 | |||
189552 | 185345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985009.2403 | 2096974.0058 | 37.7370246764469 | -122.494338012308 | (37.7370246764469, -122.494338012308) | 1 | 8 | 3 | 29491 | 35 | |||
189476 | 184065 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984936.83 | 2103975.2691 | 37.7562440009699 | -122.495104483371 | (37.7562440009699, -122.495104483371) | 1 | 8 | 3 | 56 | 35 | |||
189463 | 183190 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2455 45th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982371.7929 | 2098405.4722 | 37.7408003902911 | -122.503562670948 | (37.7408003902911, -122.503562670948) | 1 | 8 | 3 | 29491 | 35 | |||
189412 | 194573 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 614 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009542.67378 | 2111646.52636 | 37.7787173088821 | -122.410550367712 | (37.7787173088821, -122.410550367712) | 8 | 2 | 9 | 28853 | 34 | |||
189317 | 15068 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 26 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996455.6283198 | 2089039.7599438 | 37.7159023437396 | -122.454190028496 | (37.7159023437396, -122.454190028496) | 9 | 8 | 6 | 28861 | 24 | |||
188929 | 184023 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984925.7341 | 2103781.6794 | 37.7557118076488 | -122.495128581301 | (37.7557118076488, -122.495128581301) | 1 | 8 | 3 | 56 | 35 | |||
188921 | 124584 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3979 Washington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5995666.02988 | 2115466.79704 | 37.7884190136411 | -122.45883142437 | (37.7884190136411, -122.45883142437) | 11 | 6 | 1 | 54 | 31 | |||
188886 | 185892 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985033.4781 | 2101168.0045 | 37.7485416817578 | -122.494563302382 | (37.7485416817578, -122.494563302382) | 1 | 8 | 3 | 29491 | 35 | |||
188883 | 132316 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1275 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6006816.19203 | 2119756.21492 | 37.800831276511 | -122.420558166429 | (37.800831276511, -122.420558166429) | 5 | 1 | 1 | 28858 | 32 | |||
188822 | 211355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 30 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999309.78108 | 2097559.20163 | 37.7394580029801 | -122.444936853564 | (37.7394580029801, -122.444936853564) | 9 | 7 | 4 | 59 | 40 | |||
188593 | 181376 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984898.9273 | 2104425.8178 | 37.7574788636934 | -122.495268786886 | (37.7574788636934, -122.495268786886) | 1 | 8 | 3 | 56 | 35 | |||
188455 | 219151 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 5991179.47447 | 2105124.8493 | 37.7597639357807 | -122.473599345261 | (37.7597639357807, -122.473599345261) | 1 | 8 | 4 | 56 | 12 | |||
188375 | 185044 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3311 Wawona St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982550.4866 | 2096710.0878 | 37.7361558327762 | -122.502819355388 | (37.7361558327762, -122.502819355388) | 1 | 8 | 3 | 29491 | 35 | |||
188231 | 120832 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2047 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5989074.44064 | 2113302.03404 | 37.7820941005118 | -122.481478407238 | (37.7820941005118, -122.481478407238) | 11 | 6 | 2 | 55 | 26 | |||
188118 | 186449 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1601 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984739.2681 | 2103899.1733 | 37.7560234949851 | -122.495782096963 | (37.7560234949851, -122.495782096963) | 1 | 8 | 3 | 56 | 35 | |||
188072 | 186305 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984984.0877 | 2102754.186 | 37.7528940103996 | -122.494851024666 | (37.7528940103996, -122.494851024666) | 1 | 8 | 3 | 56 | 35 | |||
188059 | 132345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 4ft | 6010293.68664 | 2121970.09812 | 37.807105416558 | -122.408680791404 | (37.807105416558, -122.408680791404) | 3 | 1 | 10 | 308 | 23 | |||
187686 | 183300 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1286 42nd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983077.483 | 2106399.7047 | 37.7627917872274 | -122.501714001279 | (37.7627917872274, -122.501714001279) | 1 | 8 | 3 | 56 | 35 | |||
187685 | 185522 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984867.3695 | 2100152.2019 | 37.7457428414209 | -122.495062801762 | (37.7457428414209, -122.495062801762) | 1 | 8 | 3 | 29491 | 35 | |||
187627 | 233549 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4181 23rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001924.74366 | 2102332.8937 | 37.7527143301036 | -122.436237009941 | (37.7527143301036, -122.436237009941) | 2 | 4 | 5 | 28862 | 22 | |||
187501 | 123412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 401 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 5994941.8407 | 2112759.69789 | 37.780944396957 | -122.461140684835 | (37.780944396957, -122.461140684835) | 11 | 6 | 2 | 54 | 11 | |||
187453 | 1148 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2674 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998040.26266 | 2088367.91283 | 37.7141483475384 | -122.448664456212 | (37.7141483475384, -122.448664456212) | 9 | 7 | 6 | 28861 | 25 | |||
187397 | 44423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.44633 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | 9 | 7 | 6 | 28861 | 5 | |
187347 | 132293 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1009 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6005925.58045 | 2121359.44598 | 37.805183106669 | -122.423754118678 | (37.805183106669, -122.423754118678) | 5 | 1 | 1 | 28858 | 32 | |||
187245 | 185294 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984984.2215 | 2097354.9398 | 37.7380691549913 | -122.494452584816 | (37.7380691549913, -122.494452584816) | 1 | 8 | 3 | 29491 | 35 | |||
187243 | 184322 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3300 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983974.6701 | 2104301.5258 | 37.7570834352108 | -122.49845600814 | (37.7570834352108, -122.49845600814) | 1 | 8 | 3 | 56 | 35 | |||
186970 | 225283 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998142.22071 | 2105955.37376 | 37.7624451205691 | -122.449578595475 | (37.7624451205691, -122.449578595475) | 15 | 5 | 11 | 29492 | 9 | |||
186762 | 124109 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3911 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994829.3396 | 2112782.40677 | 37.7810002746926 | -122.461531525656 | (37.7810002746926, -122.461531525656) | 11 | 6 | 2 | 54 | 11 | |||
186699 | 139070 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2211 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001584 | 2113871 | 37.7843757479057 | -122.438241863273 | (37.7843757479057, -122.438241863273) | 15 | 6 | 11 | 29490 | 13 | |||
186569 | 184089 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984906.5283 | 2104110.9388 | 37.7566147383421 | -122.495219279964 | (37.7566147383421, -122.495219279964) | 1 | 8 | 3 | 56 | 35 | |||
186557 | 186463 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1601 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984740.943 | 2103824.2217 | 37.7558177967593 | -122.495770776139 | (37.7558177967593, -122.495770776139) | 1 | 8 | 3 | 56 | 35 | |||
186526 | 233510 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 757 Haight St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6002532.75447 | 2109164.64815 | 37.7715071985232 | -122.434622864475 | (37.7715071985232, -122.434622864475) | 15 | 5 | 11 | 29492 | 9 | |||
186446 | 44425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.41887 | 2086971.04816 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | 9 | 7 | 6 | 28861 | 5 | |
186389 | 185298 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984972.7066 | 2097344.4717 | 37.7380397384801 | -122.494491625504 | (37.7380397384801, -122.494491625504) | 1 | 8 | 3 | 29491 | 35 | |||
186383 | 251738 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | ||||
186269 | 186704 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1401 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984701.2689 | 2105106.6679 | 37.7593367138007 | -122.496002585917 | (37.7593367138007, -122.496002585917) | 1 | 8 | 3 | 56 | 35 | |||
186030 | 132221 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2495 Filbert St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6001107.91349 | 2118609.04924 | 37.7973581109469 | -122.440228844208 | (37.7973581109469, -122.440228844208) | 13 | 9 | 1 | 57 | 17 | |||
185922 | 2189 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1049 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000869.1672 | 2112323.3226 | 37.7800855395625 | -122.440603883886 | (37.7800855395625, -122.440603883886) | 15 | 5 | 1 | 29490 | 41 | |||
185893 | 211336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 10 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 5992533.48421 | 2103100.12483 | 37.7542828925471 | -122.468769200762 | (37.7542828925471, -122.468769200762) | 1 | 8 | 4 | 56 | 12 | |||
185640 | 233594 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 153 Upper Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999783.99245 | 2106717.08599 | 37.7646303787236 | -122.44395506189 | (37.7646303787236, -122.44395506189) | 15 | 5 | 5 | 29492 | 3 | |||
185201 | 185884 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985027.4806 | 2101124.7598 | 37.7484225925938 | -122.494580853765 | (37.7484225925938, -122.494580853765) | 1 | 8 | 3 | 29491 | 35 | |||
185190 | 123917 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 389 09th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993076.23951 | 2112909.95276 | 37.7812494192961 | -122.467605594039 | (37.7812494192961, -122.467605594039) | 11 | 6 | 2 | 54 | 11 | |||
185082 | 186375 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984789.6773 | 2102516.7003 | 37.7522305580742 | -122.495505807921 | (37.7522305580742, -122.495505807921) | 1 | 8 | 3 | 56 | 35 | |||
185068 | 233548 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 630 Alvarado St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 4ft | 6002336.17454 | 2102683.27276 | 37.7536997550592 | -122.434839264735 | (37.7536997550592, -122.434839264735) | 2 | 4 | 5 | 28862 | 22 | |||
184908 | 186208 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1701 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984759.0473 | 2103403.4235 | 37.7546634616414 | -122.495677129358 | (37.7546634616414, -122.495677129358) | 1 | 8 | 3 | 56 | 35 | |||
184759 | 122208 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 513 14th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991557.3358 | 2111950.30529 | 37.7785266769601 | -122.472790207227 | (37.7785266769601, -122.472790207227) | 11 | 6 | 2 | 54 | 26 | |||
184717 | 186661 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1401 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984696.2443 | 2105553.3414 | 37.7605628601789 | -122.496052916638 | (37.7605628601789, -122.496052916638) | 1 | 8 | 3 | 56 | 35 | |||
184523 | 132220 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2495 Filbert St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6001099.94798 | 2118608.00581 | 37.7973547924556 | -122.44025633199 | (37.7973547924556, -122.44025633199) | 13 | 9 | 1 | 57 | 17 | |||
184458 | 184019 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984936.296 | 2103763.6921 | 37.7556630378367 | -122.495090729116 | (37.7556630378367, -122.495090729116) | 1 | 8 | 3 | 56 | 35 | |||
184186 | 123948 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 395 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993388.00138 | 2112889.34301 | 37.781210825725 | -122.466525562152 | (37.781210825725, -122.466525562152) | 11 | 6 | 2 | 54 | 11 | |||
183894 | 185471 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 23 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985135.682 | 2098419.4337 | 37.7410008324731 | -122.494007348608 | (37.7410008324731, -122.494007348608) | 1 | 8 | 3 | 29491 | 35 | |||
183851 | 132261 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2244 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5999352.04113 | 2116603.30372 | 37.7917507417474 | -122.446160241805 | (37.7917507417474, -122.446160241805) | 13 | 6 | 1 | 29490 | 27 | |||
183655 | 138053 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1801 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003423.5383 | 2114956.5878 | 37.7874609504744 | -122.43195524769 | (37.7874609504744, -122.43195524769) | 13 | 9 | 11 | 29490 | 27 | |||
183599 | 186223 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1701 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984810.7404 | 2103382.398 | 37.7546087584802 | -122.495496812722 | (37.7546087584802, -122.495496812722) | 1 | 8 | 3 | 56 | 35 | |||
183331 | 186428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1601 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984783.2341 | 2104071.2687 | 37.7564985959459 | -122.495642743391 | (37.7564985959459, -122.495642743391) | 1 | 8 | 3 | 56 | 35 | |||
183110 | 123920 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 389 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993074.86438 | 2112977.56543 | 37.7814349859023 | -122.46761526981 | (37.7814349859023, -122.46761526981) | 11 | 6 | 2 | 54 | 11 | |||
182771 | 186204 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1701 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984766.0111 | 2103426.4577 | 37.7547271149862 | -122.49565474593 | (37.7547271149862, -122.49565474593) | 1 | 8 | 3 | 56 | 35 | |||
182648 | 11440 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2200X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005103.39154 | 2117206.5873 | 37.7937339726032 | -122.426303549179 | (37.7937339726032, -122.426303549179) | 13 | 9 | 1 | 28858 | 27 | |||
182615 | 184044 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984935.6912 | 2103830.117 | 37.7558453868228 | -122.495097718604 | (37.7558453868228, -122.495097718604) | 1 | 8 | 3 | 56 | 35 | |||
182574 | 186667 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1401 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984693.9413 | 2105532.6146 | 37.7605058152905 | -122.496059352389 | (37.7605058152905, -122.496059352389) | 1 | 8 | 3 | 56 | 35 | |||
182473 | 109083 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 360 09th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5993121.90038 | 2112970.33483 | 37.7814178482518 | -122.46745202346 | (37.7814178482518, -122.46745202346) | 11 | 6 | 2 | 54 | 11 |
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) );