trees
141 rows where qSpecies_id = 192 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68878 | 117879 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 600 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5982899.69473 | 2111629.29997 | 37.7771403043217 | -122.502716018744 | (37.7771403043217, -122.502716018744) | 11 | 6 | 2 | 55 | 26 | |||
| 117801 | 117731 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 454 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5983478.40513 | 2112756.72866 | 37.7802698871367 | -122.500797502973 | (37.7802698871367, -122.500797502973) | 11 | 6 | 2 | 55 | 26 | |||
| 54836 | 117730 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 454 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5983478.41225 | 2112771.80451 | 37.780311281435 | -122.500798593525 | (37.780311281435, -122.500798593525) | 11 | 6 | 2 | 55 | 26 | |||
| 56838 | 119542 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781594 | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.489770606489 | (37.7743914964818, -122.489770606489) | 11 | 6 | 2 | 55 | 26 | |
| 83155 | 106433 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 571 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772463 | 5986872.98787 | 2112036.42636 | 37.7784908552992 | -122.489001264146 | (37.7784908552992, -122.489001264146) | 11 | 6 | 2 | 55 | 26 | |
| 84856 | 100047 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 191@ 23rd Ave 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 5988664 | 2114068 | 37.7841733536199 | -122.482954484434 | (37.7841733536199, -122.482954484434) | 11 | 6 | 2 | 55 | 26 | ||||
| 111492 | 122243 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1602 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5990412.22012 | 2114764.44305 | 37.7861871602654 | -122.476957236709 | (37.7861871602654, -122.476957236709) | 11 | 6 | 1 | 55 | 33 | |||
| 67316 | 121924 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 634 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990987.34247 | 2111070.84307 | 37.7760789022063 | -122.4746978058 | (37.7760789022063, -122.4746978058) | 11 | 6 | 2 | 54 | 26 | |||
| 192317 | 54986 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 630 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774083 | 5990989.66226 | 2111091.4426 | 37.7761355972955 | -122.474691284924 | (37.7761355972955, -122.474691284924) | 11 | 6 | 2 | 54 | 26 | ||
| 14791 | 79962 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5991293.33065 | 2110344.21659 | 37.774101509723 | -122.473586305934 | (37.774101509723, -122.473586305934) | 11 | 6 | 2 | 54 | 26 | |||
| 5518 | 74721 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 751 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991294.08826 | 2110301.56991 | 37.7739844574191 | -122.473580573781 | (37.7739844574191, -122.473580573781) | 11 | 6 | 2 | 54 | 26 | |||
| 13553 | 74568 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 751 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991294.51043 | 2110282.3084 | 37.7739315950017 | -122.473577708136 | (37.7739315950017, -122.473577708136) | 11 | 6 | 2 | 54 | 26 | |||
| 132584 | 122169 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 773 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991300.41308 | 2110156.21664 | 37.7735857231524 | -122.473548090693 | (37.7735857231524, -122.473548090693) | 11 | 6 | 2 | 54 | 26 | |||
| 54392 | 65017 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 773 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1989 12:00:00 AM | 4 | Permit Number 26064 | 5991300.61602 | 2110165.83871 | 37.7736121544932 | -122.473548090703 | (37.7736121544932, -122.473548090703) | 11 | 6 | 2 | 54 | 26 | ||
| 138215 | 205926 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991750.33901 | 2100031.2106 | 37.7458111754419 | -122.471253906169 | (37.7458111754419, -122.471253906169) | 1 | 8 | 4 | 29491 | 40 | |||
| 55192 | 204705 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1550 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993090.57371 | 2104919.01452 | 37.7593092592319 | -122.466974886903 | (37.7593092592319, -122.466974886903) | 1 | 8 | 4 | 56 | 12 | |||
| 188601 | 205924 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1680 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993739.53974 | 2104078.92299 | 37.7570400215039 | -122.464669461335 | (37.7570400215039, -122.464669461335) | 1 | 8 | 4 | 56 | 12 | |||
| 183226 | 205931 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 75 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993781.54533 | 2093460.74171 | 37.7278875863259 | -122.463753529699 | (37.7278875863259, -122.463753529699) | 9 | 8 | 4 | 59 | 40 | |||
| 137271 | 205925 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 339 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993786.38841 | 2105256.23483 | 37.7602753154789 | -122.464592927245 | (37.7602753154789, -122.464592927245) | 1 | 8 | 4 | 56 | 12 | |||
| 127937 | 205927 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 351 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994099.7296 | 2099750.24687 | 37.7451753385886 | -122.463109727528 | (37.7451753385886, -122.463109727528) | 1 | 8 | 4 | 29491 | 40 | |||
| 81174 | 205928 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 201 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5994258.71917 | 2098719.4731 | 37.7423542498388 | -122.462485220335 | (37.7423542498388, -122.462485220335) | 1 | 8 | 4 | 59 | 40 | |||
| 64941 | 205929 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 30 Northgate Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994458.86462 | 2093951.39499 | 37.7292738076366 | -122.461447593334 | (37.7292738076366, -122.461447593334) | 9 | 8 | 4 | 59 | 40 | |||
| 86017 | 205933 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 491 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994722.91121 | 2099956.84307 | 37.7457784788033 | -122.460969859075 | (37.7457784788033, -122.460969859075) | 1 | 8 | 4 | 59 | 40 | |||
| 127237 | 205930 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 235 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5996324.55462 | 2094916.82803 | 37.7320318610725 | -122.455067510477 | (37.7320318610725, -122.455067510477) | 9 | 7 | 4 | 59 | 40 | |||
| 36551 | 204707 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 368 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5997187.85064 | 2096211.75299 | 37.7356369032136 | -122.4521763241 | (37.7356369032136, -122.4521763241) | 9 | 7 | 4 | 59 | 40 | |||
| 66380 | 204706 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 368 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5997198.1227 | 2096218.63596 | 37.735656390617 | -122.45214130629 | (37.735656390617, -122.45214130629) | 9 | 7 | 4 | 59 | 40 | |||
| 64411 | 222715 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1155 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997334.69956 | 2106260.61019 | 37.7632369925263 | -122.45239352654 | (37.7632369925263, -122.45239352654) | 15 | 5 | 11 | 29492 | 12 | |||
| 113923 | 222719 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1401 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5997793.01483 | 2105883.03644 | 37.7622265169483 | -122.450781148249 | (37.7622265169483, -122.450781148249) | 15 | 5 | 11 | 29492 | 9 | |||
| 131708 | 205936 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 16 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5998119.51434 | 2093651.58316 | 37.7286606102943 | -122.448770873875 | (37.7286606102943, -122.448770873875) | 9 | 7 | 4 | 28861 | 40 | |||
| 74397 | 205932 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 381 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998139.09857 | 2094067.57391 | 37.7298039426763 | -122.448733120346 | (37.7298039426763, -122.448733120346) | 9 | 7 | 4 | 28861 | 40 | |||
| 78141 | 222718 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1130 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5998190.72142 | 2106375.25973 | 37.763600796172 | -122.449441105347 | (37.763600796172, -122.449441105347) | 15 | 5 | 11 | 29492 | 9 | |||
| 136942 | 222717 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5998192.89709 | 2106359.88718 | 37.7635587114837 | -122.44943247273 | (37.7635587114837, -122.44943247273) | 15 | 5 | 11 | 29492 | 9 | |||
| 69200 | 204708 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 60 Sequoia Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998200.81211 | 2097480.11593 | 37.7391774990296 | -122.448765470767 | (37.7391774990296, -122.448765470767) | 9 | 7 | 4 | 59 | 40 | |||
| 155590 | 222716 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4800 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998213.80869 | 2105679.41887 | 37.7616915129762 | -122.449311117323 | (37.7616915129762, -122.449311117323) | 15 | 5 | 11 | 29492 | 9 | |||
| 102574 | 222722 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 456 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5998557.53354 | 2106542.30606 | 37.7640804396927 | -122.448184452078 | (37.7640804396927, -122.448184452078) | 15 | 5 | 11 | 29492 | 9 | |||
| 41086 | 222721 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 460 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998557.98399 | 2106528.83542 | 37.7640434784564 | -122.448181924078 | (37.7640434784564, -122.448181924078) | 15 | 5 | 11 | 29492 | 9 | |||
| 52217 | 222720 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 460 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998559.963 | 2106518.60762 | 37.7640155086256 | -122.448174342784 | (37.7640155086256, -122.448174342784) | 15 | 5 | 11 | 29492 | 9 | |||
| 98669 | 205935 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 494 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998796.69025 | 2094999.7727 | 37.732401122707 | -122.446526800992 | (37.732401122707, -122.446526800992) | 9 | 7 | 4 | 59 | 40 | ||||
| 76141 | 205934 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 906 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998837.85984 | 2095588.97571 | 37.734021286451 | -122.446426841352 | (37.734021286451, -122.446426841352) | 9 | 7 | 4 | 59 | 40 | |||
| 70619 | 204709 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 545 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998992.28712 | 2097331.34526 | 37.7388142385985 | -122.446018219969 | (37.7388142385985, -122.446018219969) | 9 | 7 | 4 | 59 | 40 | |||
| 141178 | 204710 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 545 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998992.31443 | 2097369.41624 | 37.7389187739861 | -122.446020863095 | (37.7389187739861, -122.446020863095) | 9 | 7 | 4 | 59 | 40 | |||
| 134508 | 204711 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 400x Marietta Dr | 37 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5999138.58947 | 2096999.87001 | 37.7379124398128 | -122.445488548067 | (37.7379124398128, -122.445488548067) | 9 | 7 | 4 | 59 | 40 | |||
| 121990 | 204712 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 400x Marietta Dr | 33 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 5999156.87837 | 2097007.30596 | 37.7379339012297 | -122.445425849132 | (37.7379339012297, -122.445425849132) | 9 | 7 | 4 | 59 | 40 | |||
| 73859 | 222729 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 297 Glenview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999301.18467 | 2100808.44264 | 37.7483791472865 | -122.445200121084 | (37.7483791472865, -122.445200121084) | 2 | 5 | 5 | 63 | 38 | |||
| 70030 | 38064 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1916 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 3 | Permit Number 40256 | 5999479.6323 | 2115611.29899 | 37.7890342432733 | -122.445647409716 | (37.7890342432733, -122.445647409716) | 13 | 6 | 1 | 29490 | 27 | |
| 171419 | 222745 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999630.16383 | 2107483.17366 | 37.7667250877199 | -122.444542176192 | (37.7667250877199, -122.444542176192) | 15 | 5 | 5 | 29492 | 9 | |||
| 137663 | 108908 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 85 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772733 | 5999781.28744 | 2087663.99349 | 37.7123149446499 | -122.442596312184 | (37.7123149446499, -122.442596312184) | 9 | 7 | 6 | 28861 | 5 |
| 165957 | 205937 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 50 Circular Ave | 1 | : Yard | Tree | Private 2 | 6 | 6000127.5419 | 2093913.29351 | 37.7294938303644 | -122.441847798355 | (37.7294938303644, -122.441847798355) | 9 | 7 | 4 | 63 | 40 | ||||
| 103744 | 222653 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 168 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000185.10302 | 2104897.86614 | 37.7596581233442 | -122.442437113285 | (37.7596581233442, -122.442437113285) | 2 | 4 | 5 | 28862 | 3 | |||
| 89602 | 175819 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 357 Allison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6000300.68918 | 2087012.03119 | 37.7105543958389 | -122.440754372043 | (37.7105543958389, -122.440754372043) | 9 | 7 | 6 | 28861 | 5 | |||
| 123900 | 175820 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 261 Pope St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6000467.45233 | 2087520.4423 | 37.711959875208 | -122.440214438857 | (37.711959875208, -122.440214438857) | 9 | 7 | 6 | 28861 | 5 | |||
| 46733 | 222650 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 91 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000677.8334 | 2104602.16707 | 37.7588742787364 | -122.440711798109 | (37.7588742787364, -122.440711798109) | 2 | 4 | 5 | 28862 | 38 | |||
| 62672 | 222673 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 190 Storrie St | 10 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000769.8265 | 2105310.91905 | 37.7608255764675 | -122.440444475527 | (37.7608255764675, -122.440444475527) | 15 | 4 | 5 | 28862 | 3 | |||
| 53647 | 222674 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 190 Storrie St | 12 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6000781.07373 | 2105315.73144 | 37.7608394305221 | -122.440405921593 | (37.7608394305221, -122.440405921593) | 15 | 4 | 5 | 28862 | 3 | |||
| 160278 | 175818 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 12 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000786.09001 | 2088431.87786 | 37.7144806101721 | -122.439178423455 | (37.7144806101721, -122.439178423455) | 9 | 7 | 6 | 28861 | 5 | |||
| 16368 | 222737 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 840 27th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6001059.80246 | 2099994.72018 | 37.7462450839594 | -122.439060564612 | (37.7462450839594, -122.439060564612) | 2 | 4 | 5 | 63 | 22 | |||
| 34384 | 222651 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 11 Corwin St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6001073.47546 | 2103923.13331 | 37.7570323403783 | -122.439294815506 | (37.7570323403783, -122.439294815506) | 2 | 4 | 5 | 28862 | 38 | |||
| 52080 | 222652 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 11 Corwin St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001110.99108 | 2103921.57138 | 37.7570301865074 | -122.439164960595 | (37.7570301865074, -122.439164960595) | 2 | 4 | 5 | 28862 | 38 | |||
| 43552 | 222736 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 840 27th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6001147.50542 | 2100000.25103 | 37.7462652602405 | -122.43875769542 | (37.7462652602405, -122.43875769542) | 2 | 4 | 5 | 63 | 22 | |||
| 58383 | 222734 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1335 Douglass St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6001387.85036 | 2099809.36545 | 37.7457548041512 | -122.437912943329 | (37.7457548041512, -122.437912943329) | 2 | 4 | 5 | 63 | 22 | |||
| 67164 | 222733 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1335 Douglass St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001395.73584 | 2099802.96431 | 37.7457376765492 | -122.437885218135 | (37.7457376765492, -122.437885218135) | 2 | 4 | 5 | 63 | 22 | |||
| 47157 | 222735 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 793 27th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 29 | 6001397.56905 | 2099954.79977 | 37.7461546850012 | -122.43788975253 | (37.7461546850012, -122.43788975253) | 2 | 7 | 5 | 63 | 22 | ||||
| 125670 | 222732 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1335 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6001398.36658 | 2099798.53205 | 37.7457256562099 | -122.437875804034 | (37.7457256562099, -122.437875804034) | 2 | 4 | 5 | 63 | 22 | |||
| 65818 | 222731 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1435 Douglass St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001402.34337 | 2099545.22287 | 37.7450303552734 | -122.437843913168 | (37.7450303552734, -122.437843913168) | 2 | 7 | 5 | 63 | 22 | |||
| 96431 | 175817 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1601 San Jose Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6001662.2391 | 2094184.27122 | 37.7303252032495 | -122.436561595945 | (37.7303252032495, -122.436561595945) | 9 | 7 | 6 | 28861 | 25 | ||||
| 58280 | 175821 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1703 San Jose Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6001663.95995 | 2094186.51128 | 37.7303314517312 | -122.436555807014 | (37.7303314517312, -122.436555807014) | 9 | 7 | 6 | 28861 | 25 | |||
| 39196 | 222654 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 352 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001768.69391 | 2103784.5826 | 37.7566914514695 | -122.43688057199 | (37.7566914514695, -122.43688057199) | 2 | 4 | 5 | 28862 | 3 | |||
| 8601 | 222646 | Planning Code 138.1 required 2 | Ceanothus Sps :: California lilac 192 | 4209 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2018 12:00:00 AM | 3 | Width 3ft | 6001770.77195 | 2101738.59247 | 37.7510737715579 | -122.436726932715 | (37.7510737715579, -122.436726932715) | 2 | 4 | 5 | 28862 | 22 | ||
| 185207 | 222738 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1643 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002073.55581 | 2099180.0465 | 37.7440658116781 | -122.435496865185 | (37.7440658116781, -122.435496865185) | 2 | 7 | 5 | 63 | 22 | |||
| 71666 | 222740 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 648 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002389.29196 | 2099761.78027 | 37.7456810435418 | -122.43444670615 | (37.7456810435418, -122.43444670615) | 2 | 7 | 5 | 63 | 22 | |||
| 80072 | 222739 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 540 28th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6002408.85386 | 2099476.32277 | 37.744898354569 | -122.434358658948 | (37.744898354569, -122.434358658948) | 2 | 7 | 5 | 63 | 22 | |||
| 150943 | 222741 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 500x 27th St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6002744.61883 | 2100060.70302 | 37.7465219789108 | -122.433239395083 | (37.7465219789108, -122.433239395083) | 2 | 7 | 5 | 63 | 22 | |||
| 69874 | 222675 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 110 Henry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002794.36582 | 2107408.76473 | 37.7667008213034 | -122.433592429354 | (37.7667008213034, -122.433592429354) | 15 | 5 | 5 | 28862 | 3 | |||
| 102581 | 222742 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 500x 27th St | 18 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6002891.17498 | 2100067.71005 | 37.7465495314539 | -122.432733120839 | (37.7465495314539, -122.432733120839) | 2 | 7 | 5 | 63 | 22 | |||
| 21168 | 222744 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 276 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6002992.57035 | 2096281.23679 | 37.7361585018991 | -122.432112152446 | (37.7361585018991, -122.432112152446) | 2 | 7 | 5 | 63 | 7 | |||
| 158474 | 222711 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 276 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6002996.93111 | 2096284.15675 | 37.7361667666773 | -122.432097283983 | (37.7361667666773, -122.432097283983) | 2 | 7 | 5 | 63 | 7 | |||
| 34761 | 222667 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 645 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003055.60188 | 2104525.93514 | 37.7588000864676 | -122.432482929452 | (37.7588000864676, -122.432482929452) | 2 | 4 | 5 | 28862 | 3 | |||
| 126297 | 222668 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 645 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003056.97537 | 2104549.20276 | 37.7588640516623 | -122.432479841192 | (37.7588640516623, -122.432479841192) | 2 | 4 | 5 | 28862 | 3 | |||
| 165546 | 222662 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 396 Cumberland St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003135.75728 | 2104484.93256 | 37.7586920482127 | -122.432202787039 | (37.7586920482127, -122.432202787039) | 2 | 4 | 5 | 28862 | 3 | |||
| 94912 | 222666 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4090 20th St | 5 | : Yard | Tree | Private 2 | 8 | Width 3ft | 6003140.83414 | 2104172.66898 | 37.7578349349576 | -122.432162929082 | (37.7578349349576, -122.432162929082) | 2 | 4 | 5 | 28862 | 3 | |||
| 36189 | 222665 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4090 20th St | 4 | : Yard | Tree | Private 2 | 8 | Width 3ft | 6003145.04093 | 2104185.04238 | 37.7578691478694 | -122.432149263871 | (37.7578691478694, -122.432149263871) | 2 | 4 | 5 | 28862 | 3 | |||
| 165635 | 222664 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4090 20th St | 3 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6003149.42788 | 2104190.19818 | 37.7578835531891 | -122.432134460156 | (37.7578835531891, -122.432134460156) | 2 | 4 | 5 | 28862 | 3 | |||
| 121264 | 222663 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 4090 20th St | 2 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6003162.22381 | 2104187.96649 | 37.7578781509761 | -122.43209004713 | (37.7578781509761, -122.43209004713) | 2 | 4 | 5 | 28862 | 3 | |||
| 156528 | 222669 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003665.94004 | 2103977.36903 | 37.7573284457732 | -122.43033296072 | (37.7573284457732, -122.43033296072) | 2 | 4 | 5 | 28862 | 3 | |||
| 67731 | 222649 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 545 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003665.9595 | 2105128.1203 | 37.7604881355293 | -122.430414996875 | (37.7604881355293, -122.430414996875) | 2 | 4 | 5 | 28862 | 3 | |||
| 49317 | 222648 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 400 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003683.04706 | 2103350.38442 | 37.7556078637217 | -122.430229068329 | (37.7556078637217, -122.430229068329) | 2 | 4 | 5 | 28862 | 22 | |||
| 188499 | 222670 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 790 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003687.86635 | 2103677.4965 | 37.7565063089475 | -122.430235737705 | (37.7565063089475, -122.430235737705) | 2 | 4 | 5 | 28862 | 3 | |||
| 132450 | 222661 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 737 Sanchez St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6003696.567 | 2104082.72525 | 37.7576194636886 | -122.430234556892 | (37.7576194636886, -122.430234556892) | 2 | 4 | 5 | 28862 | 3 | |||
| 21949 | 222660 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 737 Sanchez St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6003698.27718 | 2104074.03497 | 37.7575956991109 | -122.430228022422 | (37.7575956991109, -122.430228022422) | 2 | 4 | 5 | 28862 | 3 | |||
| 124540 | 222647 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 820 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003702.48516 | 2103374.94949 | 37.755676414553 | -122.430163597697 | (37.755676414553, -122.430163597697) | 2 | 4 | 5 | 28862 | 22 | |||
| 110333 | 222657 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 397 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003712.18229 | 2103887.0958 | 37.7570831961356 | -122.430166596908 | (37.7570831961356, -122.430166596908) | 2 | 4 | 5 | 28862 | 3 | |||
| 130076 | 222658 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 397 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003726.11997 | 2103884.92664 | 37.7570780295385 | -122.430118240357 | (37.7570780295385, -122.430118240357) | 2 | 4 | 5 | 28862 | 3 | |||
| 55792 | 222659 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 397 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003738.16873 | 2103882.79645 | 37.7570728629433 | -122.430076419198 | (37.7570728629433, -122.430076419198) | 2 | 4 | 5 | 28862 | 3 | |||
| 158547 | 222656 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 310 Liberty St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004069.16963 | 2103935.80533 | 37.7572371537858 | -122.428935470922 | (37.7572371537858, -122.428935470922) | 2 | 4 | 5 | 28862 | 3 | |||
| 90522 | 222655 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 310 Liberty St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6004252.67601 | 2103946.69939 | 37.7572774515136 | -122.428301610753 | (37.7572774515136, -122.428301610753) | 2 | 4 | 5 | 28862 | 3 | |||
| 181102 | 222743 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 310 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004293.88459 | 2096588.21513 | 37.7370750882366 | -122.427634840771 | (37.7370750882366, -122.427634840771) | 2 | 7 | 5 | 63 | 7 | |||
| 77842 | 222676 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 701 Church St | 36 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6004317.3839 | 2104765.72552 | 37.7595299645462 | -122.428136192139 | (37.7595299645462, -122.428136192139) | 2 | 4 | 5 | 28862 | 3 | |||
| 162267 | 222672 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 841 Church St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004365.34197 | 2104133.78232 | 37.7577975114758 | -122.427925298424 | (37.7577975114758, -122.427925298424) | 2 | 4 | 5 | 28862 | 3 | |||
| 177109 | 222671 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 841 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004365.5079 | 2104119.71112 | 37.7577588846739 | -122.42792372191 | (37.7577588846739, -122.42792372191) | 2 | 4 | 5 | 28862 | 3 | |||
| 70708 | 97257 | DPW Maintained 1 | Ceanothus Sps :: California lilac 192 | 1994 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6004648.67437 | 2117089.60532 | 37.7933870564247 | -122.427868571893 | (37.7933870564247, -122.427868571893) | 13 | 9 | 1 | 28858 | 27 |
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) );