trees
4,014 rows where qSpecies_id = 40 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1021 | 213351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993534.80603 | 2090819.23886 | 37.7206204409725 | -122.464414798499 | (37.7206204409725, -122.464414798499) | 9 | 8 | 6 | 64 | 24 | |||
2070 | 213331 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Byxbee St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 5991924.78555 | 2089552.62516 | 37.7170496899626 | -122.469887910591 | (37.7170496899626, -122.469887910591) | 9 | 8 | 6 | 64 | 24 | |||
11099 | 45514 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.72309 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | 1 | 8 | 4 | 64 | 35 | |
12254 | 213339 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992194.58269 | 2090348.43318 | 37.7192503768696 | -122.469013242585 | (37.7192503768696, -122.469013242585) | 9 | 8 | 6 | 64 | 24 | |||
15161 | 45552 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987586.87726 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | 1 | 8 | 4 | 64 | 35 | |
15304 | 45481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3014 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44262 | 5990295.67943 | 2095138.00578 | 37.7322914422893 | -122.475926565872 | (37.7322914422893, -122.475926565872) | 1 | 8 | 4 | 64 | 35 | |
20594 | 50299 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 4 | Permit Number 47010 | 5989048.57412 | 2095810.27611 | 37.7340649359436 | -122.480287231884 | (37.7340649359436, -122.480287231884) | 1 | 8 | 4 | 64 | 35 | |
21882 | 213345 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 542 Arch St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992754.74517 | 2090800.4755 | 37.7205239248105 | -122.467109837375 | (37.7205239248105, -122.467109837375) | 9 | 8 | 6 | 64 | 24 | |||
23854 | 86960 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 208 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.7111251955331 | -122.464305827668 | (37.7111251955331, -122.464305827668) | 9 | 8 | 4 | 64 | 24 | |
24127 | 46734 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 315 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44844 | 5993734.25176167 | 2089288.64398892 | 37.7164292900251 | -122.463614355193 | (37.7164292900251, -122.463614355193) | 9 | 8 | 6 | 64 | 24 | ||
24692 | 213328 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 217 Byxbee St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991931.18505 | 2089973.6935 | 37.7182062109212 | -122.469896430786 | (37.7182062109212, -122.469896430786) | 9 | 8 | 6 | 64 | 24 | |||
25542 | 45508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988794.65729 | 2095738.11606 | 37.7338520448427 | -122.481159808989 | (37.7338520448427, -122.481159808989) | 1 | 8 | 4 | 64 | 35 | |
26361 | 45483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3020 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44263 | 5990296.64858 | 2095102.69561 | 37.7321945457224 | -122.475920637525 | (37.7321945457224, -122.475920637525) | 1 | 8 | 4 | 64 | 35 | |
26990 | 45553 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | 1 | 8 | 4 | 64 | 35 | |
29854 | 179040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 4 | : | Tree | Private 2 | 1 | Width 2ft | 5989055.54597 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | 1 | 8 | 4 | 64 | 35 | |||
31261 | 213337 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992227.25788 | 2089749.39386 | 37.7176074486088 | -122.468856729068 | (37.7176074486088, -122.468856729068) | 9 | 8 | 6 | 64 | 24 | |||
34456 | 213358 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.79794 | 2095256.57076 | 37.7326483517269 | -122.474064462004 | (37.7326483517269, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
36264 | 213336 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992226.96216 | 2089735.33948 | 37.7175688416125 | -122.468856729061 | (37.7175688416125, -122.468856729061) | 9 | 8 | 6 | 64 | 24 | |||
39968 | 213340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5992193.1878 | 2090324.68996 | 37.7191851031829 | -122.469016337141 | (37.7191851031829, -122.469016337141) | 9 | 8 | 6 | 64 | 24 | |||
45010 | 213335 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 53 Byxbee St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991917.8551 | 2088918.99095 | 37.715309483835 | -122.469865758501 | (37.715309483835, -122.469865758501) | 9 | 8 | 6 | 64 | 24 | |||
47504 | 45526 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.7322367742884 | -122.481946089834 | (37.7322367742884, -122.481946089834) | 1 | 8 | 4 | 64 | 35 | |
47943 | 179039 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 3 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.72291 | 2095627.1595 | 37.7335625602678 | -122.480249118597 | (37.7335625602678, -122.480249118597) | 1 | 8 | 4 | 64 | 35 | |||
50295 | 213353 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 315 Bright St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993739.98906 | 2089300.28292 | 37.7164615783281 | -122.463595368644 | (37.7164615783281, -122.463595368644) | 9 | 8 | 6 | 64 | 24 | |||
50575 | 213355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 430 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992826.5059 | 2090512.32679 | 37.7197368804329 | -122.466840849243 | (37.7197368804329, -122.466840849243) | 9 | 8 | 6 | 64 | 24 | |||
55464 | 86961 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 212 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.23034 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | 9 | 8 | 4 | 64 | 24 | |
56607 | 115280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1670 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.7342385999548 | -122.490882714096 | (37.7342385999548, -122.490882714096) | 1 | 8 | 3 | 64 | 35 | |||
56670 | 213333 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991918.76578 | 2089524.27892 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | 9 | 8 | 6 | 64 | 24 | |||
56724 | 179038 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.7335855262488 | -122.480249118607 | (37.7335855262488, -122.480249118607) | 1 | 8 | 4 | 64 | 35 | |||
56967 | 48563 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 53 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45982 | 5991907.82184104 | 2088893.56567496 | 37.7152390922347 | -122.469898587444 | (37.7152390922347, -122.469898587444) | 9 | 8 | 6 | 64 | 24 | ||
59147 | 179041 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2908 20th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990269.38069 | 2095895.56899 | 37.7343699931708 | -122.476072795627 | (37.7343699931708, -122.476072795627) | 1 | 8 | 4 | 64 | 35 | |||
59384 | 213326 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 333 Byxbee St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991939.84993 | 2090759.93539 | 37.7203655398194 | -122.469923694617 | (37.7203655398194, -122.469923694617) | 9 | 8 | 6 | 64 | 24 | |||
59438 | 45485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3036 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44264 | 5990298.1598 | 2095038.91467 | 37.7320195070769 | -122.475910756673 | (37.7320195070769, -122.475910756673) | 1 | 8 | 4 | 64 | 35 | |
59491 | 213344 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 117 Vernon St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 5992432.58541 | 2088617.02757 | 37.7145101052228 | -122.468064688059 | (37.7145101052228, -122.468064688059) | 9 | 8 | 6 | 64 | 24 | |||
61800 | 213321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991673.59488 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | 9 | 8 | 6 | 64 | 24 | |||
63274 | 45510 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 4 | Permit Number 44276 | 5988794.07528 | 2095754.20535 | 37.7338961880477 | -122.481162998885 | (37.7338961880477, -122.481162998885) | 1 | 8 | 4 | 64 | 35 | |
69041 | 44741 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.70048 | 37.7090013413078 | -122.469225944836 | (37.7090013413078, -122.469225944836) | 9 | 8 | 4 | 64 | 24 | |
71705 | 115279 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1670 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.7342385999548 | -122.490882714096 | (37.7342385999548, -122.490882714096) | 1 | 8 | 3 | 64 | 35 | |||
75204 | 213361 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Elmhurst Dr | 6 | : | Tree | Private 2 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.7305156769604 | -122.472695844937 | (37.7305156769604, -122.472695844937) | 9 | 8 | 4 | 64 | 40 | |||
75701 | 213325 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Byxbee St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5991942.47046 | 2090861.00435 | 37.7206432019019 | -122.469921991317 | (37.7206432019019, -122.469921991317) | 9 | 8 | 6 | 64 | 24 | |||
80364 | 45549 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990323.96119 | 2095935.96592 | 37.7344840775814 | -122.475887044262 | (37.7344840775814, -122.475887044262) | 1 | 8 | 4 | 64 | 35 | ||
82166 | 10703 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | 9 | 8 | 6 | 64 | 24 | |||
83640 | 19331 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | 9 | 8 | 6 | 64 | 24 | ||
84550 | 45513 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44278 | 5988534.98014 | 2095768.80664 | 37.733921213495 | -122.482059828009 | (37.733921213495, -122.482059828009) | 1 | 8 | 4 | 64 | 35 | |
85139 | 45478 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3008 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 4 | Permit Number 44261 | 5990292.27426 | 2095193.28859 | 37.732443037405 | -122.475942374151 | (37.732443037405, -122.475942374151) | 1 | 8 | 4 | 64 | 35 | |
92016 | 45509 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988795.25848 | 2095722.94476 | 37.7338104233161 | -122.481156619984 | (37.7338104233161, -122.481156619984) | 1 | 8 | 4 | 64 | 35 | |
93157 | 213343 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 117 Vernon St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | 9 | 8 | 6 | 64 | 24 | |||
94407 | 50300 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.15693 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | 1 | 8 | 4 | 64 | 35 | |
96370 | 46749 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 511 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44851 | 5992686.05826903 | 2089167.34064678 | 37.7160357673292 | -122.467228580698 | (37.7160357673292, -122.467228580698) | 9 | 8 | 6 | 64 | 24 | ||
97613 | 213327 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991934.3542 | 2090733.05166 | 37.7202914059971 | -122.469940735003 | (37.7202914059971, -122.469940735003) | 9 | 8 | 6 | 64 | 24 | |||
97841 | 45547 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990293.17037 | 2095939.46173 | 37.7344918908758 | -122.475993752415 | (37.7344918908758, -122.475993752415) | 1 | 8 | 4 | 64 | 35 | ||
98877 | 179037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 1 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.57419 | 2095644.93656 | 37.7336113628596 | -122.480250933435 | (37.7336113628596, -122.480250933435) | 1 | 8 | 4 | 64 | 35 | |||
101048 | 213357 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992244.95419 | 2088111.94244 | 37.7131124256698 | -122.468676481533 | (37.7131124256698, -122.468676481533) | 9 | 8 | 6 | 64 | 24 | |||
101896 | 45479 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3008 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 5 | Permit Number 44261 | 5990293.0566 | 2095176.19647 | 37.7323961521473 | -122.475938421626 | (37.7323961521473, -122.475938421626) | 1 | 8 | 4 | 64 | 35 | |
103698 | 50296 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3052 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 5 | Permit Number 47008 | 5990299.81493 | 2094981.96074 | 37.7318632220065 | -122.475900876741 | (37.7318632220065, -122.475900876741) | 1 | 8 | 4 | 64 | 35 | |
103857 | 45480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3014 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 4 | Permit Number 44262 | 5990294.42195 | 2095159.66129 | 37.7323508299087 | -122.475932494187 | (37.7323508299087, -122.475932494187) | 1 | 8 | 4 | 64 | 35 | |
105288 | 213349 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 382 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993261.23034 | 2089739.31798 | 37.7176394653578 | -122.465282053445 | (37.7176394653578, -122.465282053445) | 9 | 8 | 6 | 64 | 24 | |||
106499 | 213330 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 217 Byxbee St | 3 | : | Tree | Private 2 | 4 | Width 2ft | 5991929.42464 | 2089936.9124 | 37.7181051172336 | -122.469899839211 | (37.7181051172336, -122.469899839211) | 9 | 8 | 6 | 64 | 24 | |||
106823 | 213350 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 610 Head St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993524.58129 | 2089927.18088 | 37.7181704754556 | -122.464385407781 | (37.7181704754556, -122.464385407781) | 9 | 8 | 6 | 64 | 24 | |||
108795 | 46754 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 382 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 44856 | 5993270.59448238 | 2089720.53231804 | 37.7175884244736 | -122.465248322339 | (37.7175884244736, -122.465248322339) | 9 | 8 | 6 | 64 | 24 | ||
110791 | 213341 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | 9 | 8 | 6 | 64 | 24 | |||
111402 | 50295 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3052 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 4 | Permit Number 47008 | 5990301.1325 | 2094963.14956 | 37.7318116476733 | -122.475894948395 | (37.7318116476733, -122.475894948395) | 1 | 8 | 4 | 64 | 35 | |
111713 | 45550 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44299 | 5990341.11287 | 2095936.17267 | 37.7344856397084 | -122.475827760949 | (37.7344856397084, -122.475827760949) | 1 | 8 | 4 | 64 | 35 | ||
111822 | 213323 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | 9 | 8 | 6 | 64 | 24 | |||
113427 | 213319 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 262 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | 9 | 8 | 6 | 64 | 24 | |||
115210 | 213362 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.7306842467752 | -122.472671762002 | (37.7306842467752, -122.472671762002) | 9 | 8 | 4 | 64 | 40 | |||
115594 | 213363 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 62 Rossmoor Dr | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5990931.27665 | 2094545.31392 | 37.7307008923171 | -122.473685962554 | (37.7307008923171, -122.473685962554) | 9 | 8 | 4 | 64 | 40 | |||
116091 | 91235 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 470 Ramsell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52048 | 5993008 | 2090300 | 37.719164355766 | -122.466198071834 | (37.719164355766, -122.466198071834) | 9 | 8 | 6 | 64 | 24 | |||
117685 | 45540 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.486285522858 | (37.7314359091244, -122.486285522858) | 1 | 8 | 4 | 64 | 35 | |
117948 | 213356 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 128 Shields St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993609.42924 | 2089850.56772 | 37.7179650046545 | -122.464086568463 | (37.7179650046545, -122.464086568463) | 9 | 8 | 6 | 64 | 24 | |||
119831 | 213324 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 355 Byxbee St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | 9 | 8 | 6 | 64 | 24 | |||
120145 | 213329 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 217 Byxbee St | 2 | : | Tree | Private 2 | 4 | Width 2ft | 5991930.7925 | 2089955.0472 | 37.7181549900393 | -122.46989643079 | (37.7181549900393, -122.46989643079) | 9 | 8 | 6 | 64 | 24 | |||
120749 | 213338 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 280 Ralston St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992226.7586 | 2089761.94489 | 37.7176418818408 | -122.468859367667 | (37.7176418818408, -122.468859367667) | 9 | 8 | 6 | 64 | 24 | |||
121822 | 213320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 238 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991458.7746 | 2090762.70401 | 37.7203453212587 | -122.471586801009 | (37.7203453212587, -122.471586801009) | 9 | 8 | 6 | 64 | 24 | |||
123650 | 86870 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
126609 | 213359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.58141 | 2095246.30718 | 37.7326201579899 | -122.474064462004 | (37.7326201579899, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
127559 | 213360 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Elmhurst Dr | 7 | : | Tree | Private 2 | 3 | Width 3ft | 5991212.62572 | 2094437.93395 | 37.7304223444182 | -122.472705478494 | (37.7304223444182, -122.472705478494) | 9 | 8 | 4 | 64 | 40 | |||
134471 | 213348 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 438 Victoria St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993267.15159 | 2090112.97171 | 37.7186657698839 | -122.465288712916 | (37.7186657698839, -122.465288712916) | 9 | 8 | 6 | 64 | 24 | |||
136490 | 213347 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 529 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993232.83209 | 2090695.61301 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | 9 | 8 | 6 | 64 | 24 | |||
140591 | 45544 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 79 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44297 | 5987024.26021 | 2095319.08797 | 37.7325984222842 | -122.487249757963 | (37.7325984222842, -122.487249757963) | 1 | 8 | 4 | 64 | 35 | |
143713 | 19321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 120 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/2010 12:00:00 AM | 3 | 3X3 | 5993639.27417 | 2089852.22483 | 37.7179712747243 | -122.46398352863 | (37.7179712747243, -122.46398352863) | 9 | 8 | 6 | 64 | 24 | ||
148124 | 213332 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006272 | (37.717033514761, -122.46991006272) | 9 | 8 | 6 | 64 | 24 | |||
149693 | 213352 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5993533.94375 | 2090828.77797 | 37.7206465833581 | -122.464418471345 | (37.7206465833581, -122.464418471345) | 9 | 8 | 6 | 64 | 24 | |||
151710 | 86869 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
165049 | 50297 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.49826 | 37.7341725865769 | -122.480292677287 | (37.7341725865769, -122.480292677287) | 1 | 8 | 4 | 64 | 35 | |
172130 | 45548 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990306.88184 | 2095939.17218 | 37.7344918908736 | -122.475946326684 | (37.7344918908736, -122.475946326684) | 1 | 8 | 4 | 64 | 35 | ||
174868 | 213322 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 329 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991674.00828 | 2090730.18875 | 37.7202684921693 | -122.470840448222 | (37.7202684921693, -122.470840448222) | 9 | 8 | 6 | 64 | 24 | |||
176541 | 45482 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3020 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 2 | Permit Number 44263 | 5990295.80642 | 2095116.94306 | 37.7322336167725 | -122.475924589162 | (37.7322336167725, -122.475924589162) | 1 | 8 | 4 | 64 | 35 | |
176814 | 213346 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 223 Ramsell St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992956.82489 | 2088699.80941 | 37.7147676656708 | -122.466258733373 | (37.7147676656708, -122.466258733373) | 9 | 8 | 6 | 64 | 24 | |||
179687 | 31194 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 354 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 5 | Permit Number 46596 | 5993258.72139 | 2089558.71458 | 37.7171434272164 | -122.465277614369 | (37.7171434272164, -122.465277614369) | 9 | 8 | 6 | 64 | 24 | |
180226 | 179042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2913 20th Ave | 1 | : | Tree | Private 2 | 5 | Width 2ft | 5990217.22266 | 2095888.70199 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | 1 | 8 | 4 | 64 | 35 | |||
184014 | 45531 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 47 Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44290 | 5988290.9031 | 2095585.94321 | 37.7334049189832 | -122.482890269181 | (37.7334049189832, -122.482890269181) | 1 | 8 | 4 | 64 | 35 | |
185656 | 213334 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 147 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5991917.94237 | 2089508.58685 | 37.716928375916 | -122.469908359396 | (37.716928375916, -122.469908359396) | 9 | 8 | 6 | 64 | 24 | |||
187026 | 86868 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443 | 2088555 | 37.7143403939216 | -122.468024182233 | (37.7143403939216, -122.468024182233) | 9 | 8 | 6 | 64 | 24 | ||
187542 | 213354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 142 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993565.63371 | 2090507.60393 | 37.7197665436602 | -122.464285624407 | (37.7197665436602, -122.464285624407) | 9 | 8 | 6 | 64 | 24 | |||
189691 | 213342 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 442 Vernon St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 5992492.2832 | 2090792.26428 | 37.7204862252464 | -122.468016479897 | (37.7204862252464, -122.468016479897) | 9 | 8 | 6 | 64 | 24 | |||
191604 | 50298 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2909 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 6 | Permit Number 47009 | 5989047.46422 | 2095832.25514 | 37.7341252202046 | -122.48029267727 | (37.7341252202046, -122.48029267727) | 1 | 8 | 4 | 64 | 35 | |
995 | 238517 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 258 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001824.70148 | 2096208.99046 | 37.7358938476086 | -122.436144777258 | (37.7358938476086, -122.436144777258) | 2 | 7 | 5 | 63 | 7 | |||
3032 | 4178 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3814 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:09:00 AM | 3 | 4x4 | 6005035.97287 | 2100499.61266 | 37.7478568435292 | -122.425347365702 | (37.7478568435292, -122.425347365702) | 2 | 4 | 5 | 63 | 22 | ||
5311 | 237438 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1249 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001996.99133 | 2100364.87543 | 37.7473147241062 | -122.435846365126 | (37.7473147241062, -122.435846365126) | 2 | 4 | 5 | 63 | 22 | |||
6082 | 237213 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 470 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002920.23053 | 2098629.95648 | 37.7426034430062 | -122.432529972083 | (37.7426034430062, -122.432529972083) | 2 | 7 | 5 | 63 | 22 |
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) );