trees
3,267 rows where qSpecies_id = 67 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46569 | 92915 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
46940 | 44811 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360 | 2105036 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | 1 | 8 | 3 | 56 | 35 | ||
47693 | 217680 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5992385.3244 | 2097283.625 | 37.73830371342 | -122.468858330396 | (37.73830371342, -122.468858330396) | 1 | 8 | 4 | 59 | 40 | |||
47761 | 183269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983336.1919 | 2106636.3882 | 37.763456845523 | -122.500836736792 | (37.763456845523, -122.500836736792) | 1 | 8 | 3 | 56 | 35 | |||
48078 | 112664 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
48137 | 204468 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 180 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994276.47552 | 2099234.04461 | 37.7437681567899 | -122.462461140072 | (37.7437681567899, -122.462461140072) | 1 | 8 | 4 | 59 | 40 | |||
48772 | 184903 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1798 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984124.141 | 2103020.0227 | 37.7535735484973 | -122.497844463399 | (37.7535735484973, -122.497844463399) | 1 | 8 | 3 | 56 | 35 | |||
48867 | 217682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5992831.9496 | 2097739.0243 | 37.7395799184924 | -122.467347238041 | (37.7395799184924, -122.467347238041) | 1 | 8 | 4 | 59 | 40 | |||
49606 | 205740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Mesa Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5993640.80754 | 2100768.42511 | 37.7479445508167 | -122.464770513651 | (37.7479445508167, -122.464770513651) | 1 | 8 | 4 | 29491 | 40 | |||
49792 | 182818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1801 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986875.267 | 2102940.8737 | 37.7535171257271 | -122.488324778074 | (37.7535171257271, -122.488324778074) | 1 | 8 | 3 | 56 | 35 | |||
49840 | 112662 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
49942 | 205754 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 35 | Median : Yard | Tree | DPW 1 | 5 | 5993872.8693 | 2096472.52816 | 37.7361624724174 | -122.46365632018 | (37.7361624724174, -122.46365632018) | 1 | 8 | 4 | 59 | 40 | ||||
50000 | 204494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Mesa Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993641.99222 | 2100733.77083 | 37.7478494672755 | -122.464763900938 | (37.7478494672755, -122.464763900938) | 1 | 8 | 4 | 29491 | 40 | |||
50171 | 182177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5988865 | 2104441 | 37.7577519603078 | -122.48155379204 | (37.7577519603078, -122.48155379204) | 1 | 8 | 3 | 56 | 35 | |||
50216 | 92917 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 346 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992028 | 2097000 | 37.7375043003581 | -122.470073124763 | (37.7375043003581, -122.470073124763) | 1 | 8 | 4 | 59 | 40 | ||||
50464 | 185605 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2618 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985302.1571 | 2100947.2721 | 37.7479513323017 | -122.493617965632 | (37.7479513323017, -122.493617965632) | 1 | 8 | 3 | 29491 | 35 | |||
50978 | 218223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 399 Claremont Blvd | 2 | Side Yard : Yard | Tree | Private 2 | 12 | 5993474.17256 | 2097846.02445 | 37.73991076848 | -122.465134496264 | (37.73991076848, -122.465134496264) | 1 | 8 | 4 | 59 | 40 | ||||
51542 | 217665 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5992999.2698 | 2097917.3829 | 37.740079304226 | -122.466781684087 | (37.740079304226, -122.466781684087) | 1 | 8 | 4 | 59 | 40 | |||
52426 | 183682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1323 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983973.4902 | 2106147.0568 | 37.7621506760822 | -122.498596412549 | (37.7621506760822, -122.498596412549) | 1 | 8 | 3 | 56 | 35 | |||
53062 | 43620 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
53538 | 218209 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Taraval St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993480.34534 | 2099171.49285 | 37.7435505271302 | -122.465209404389 | (37.7435505271302, -122.465209404389) | 1 | 8 | 4 | 59 | 40 | |||
53863 | 205692 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 454 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991321.23075 | 2099784.56704 | 37.745109125085 | -122.472719706665 | (37.745109125085, -122.472719706665) | 1 | 8 | 4 | 29491 | 40 | |||
54046 | 183288 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1285 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982099.3385 | 2106416.2727 | 37.762779775667 | -122.505098228653 | (37.762779775667, -122.505098228653) | 1 | 8 | 3 | 56 | 35 | |||
54253 | 204472 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 293 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994575.1706 | 2100200.25095 | 37.746438313181 | -122.461498364577 | (37.746438313181, -122.461498364577) | 1 | 8 | 4 | 29491 | 40 | |||
55188 | 175656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990014.12726 | 2089314.59531 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | 1 | 8 | 4 | 64 | 14 | ||||
55594 | 204408 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 318 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993250.86582 | 2104625.10677 | 37.7585115156134 | -122.466399162508 | (37.7585115156134, -122.466399162508) | 1 | 8 | 4 | 56 | 12 | |||
55901 | 182111 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2455 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987647.6873 | 2098570.6897 | 37.7415628035476 | -122.485332960195 | (37.7415628035476, -122.485332960195) | 1 | 8 | 3 | 29491 | 35 | |||
56049 | 204444 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2300 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991515.68796 | 2099751.50596 | 37.745029602544 | -122.472044904852 | (37.745029602544, -122.472044904852) | 1 | 8 | 4 | 29491 | 40 | |||
56078 | 38346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.504175425295 | (37.7518433707941, -122.504175425295) | 1 | 8 | 3 | 56 | 35 | |
56665 | 92931 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 323 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992282 | 2096978 | 37.7374585742898 | -122.469193334242 | (37.7374585742898, -122.469193334242) | 1 | 8 | 4 | 59 | 40 | ||||
57324 | 104918 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
58174 | 112478 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X LAWTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988671 | 2104385 | 37.7575869171128 | -122.482220613518 | (37.7575869171128, -122.482220613518) | 1 | 8 | 3 | 56 | 35 | |||
58843 | 204404 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994305.88631 | 2105718.15994 | 37.7615735767848 | -122.4628297533 | (37.7615735767848, -122.4628297533) | 1 | 5 | 11 | 56 | 12 | |||
59639 | 114414 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 786 SANTIAGO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990542 | 2099782 | 37.7450569383371 | -122.475413934806 | (37.7450569383371, -122.475413934806) | 1 | 8 | 4 | 29491 | 40 | ||||
59710 | 182114 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2461 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987955.9219 | 2098548.963 | 37.7415210998625 | -122.484265609923 | (37.7415210998625, -122.484265609923) | 1 | 8 | 3 | 29491 | 35 | |||
61883 | 204426 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2046 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990696.70707 | 2101451.06595 | 37.7496487256149 | -122.475000804639 | (37.7496487256149, -122.475000804639) | 1 | 8 | 4 | 29491 | 12 | |||
62959 | 217659 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 60 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5993054.3652 | 2097973.5639 | 37.7402367426771 | -122.466595270886 | (37.7402367426771, -122.466595270886) | 1 | 8 | 4 | 59 | 40 | |||
63445 | 205747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993775.94958 | 2101415.71343 | 37.7497296304244 | -122.464350190328 | (37.7497296304244, -122.464350190328) | 1 | 8 | 4 | 29491 | 40 | |||
63532 | 205704 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993168.55795 | 2099144.70006 | 37.7434589761641 | -122.466285532248 | (37.7434589761641, -122.466285532248) | 1 | 8 | 4 | 59 | 40 | |||
63650 | 43622 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
63736 | 204443 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2346 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991073.40938 | 2099451.63533 | 37.7441806317458 | -122.473552340388 | (37.7441806317458, -122.473552340388) | 1 | 8 | 4 | 29491 | 40 | |||
63812 | 204447 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2391 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991311.9107 | 2099114.01437 | 37.7432674205575 | -122.472703051209 | (37.7432674205575, -122.472703051209) | 1 | 8 | 4 | 29491 | 40 | |||
64262 | 204461 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 376 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5993925.03451 | 2099657.87207 | 37.7449116357803 | -122.46370708514 | (37.7449116357803, -122.46370708514) | 1 | 8 | 4 | 29491 | 40 | |||
64538 | 217637 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 323 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5992238.289 | 2097019.9802 | 37.7375713154411 | -122.469347517077 | (37.7375713154411, -122.469347517077) | 1 | 8 | 4 | 59 | 40 | |||
65416 | 204452 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993066.12283 | 2098585.83343 | 37.741918558889 | -122.466599110557 | (37.741918558889, -122.466599110557) | 1 | 8 | 4 | 59 | 40 | |||
65749 | 104923 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 767 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
65850 | 69027 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.7473759716808 | -122.506432607968 | (37.7473759716808, -122.506432607968) | 1 | 8 | 3 | 29491 | 35 | |
66445 | 204458 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 390 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993883.60942 | 2099617.77465 | 37.7447991512623 | -122.463847414442 | (37.7447991512623, -122.463847414442) | 1 | 8 | 4 | 29491 | 40 | |||
66884 | 112665 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
67897 | 109264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
67901 | 205753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 34 | Median : Yard | Tree | DPW 1 | 4 | 5993866.87232 | 2096473.28451 | 37.7361642036105 | -122.463677108908 | (37.7361642036105, -122.463677108908) | 1 | 8 | 4 | 59 | 40 | ||||
68086 | 104901 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 314 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
68279 | 175655 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989994.06268 | 2089291.62254 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | 1 | 8 | 4 | 64 | 14 | ||||
68322 | 204457 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 396 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993837.1599 | 2099576.6757 | 37.7446836270619 | -122.464005043996 | (37.7446836270619, -122.464005043996) | 1 | 8 | 4 | 29491 | 40 | |||
68518 | 92933 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 333 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992246.1 | 2096943.8 | 37.7373625952097 | -122.469314967671 | (37.7373625952097, -122.469314967671) | 1 | 8 | 4 | 59 | 40 | ||||
68604 | 112663 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
69246 | 45091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43969 | 5988148.79891202 | 2102403.3041825 | 37.7521153260597 | -122.48388126909 | (37.7521153260597, -122.48388126909) | 1 | 8 | 3 | 56 | 35 | ||
69282 | 204442 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.7433670924093 | -122.472569777984 | (37.7433670924093, -122.472569777984) | 1 | 8 | 4 | 29491 | 40 | |||
69457 | 38344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | 1 | 8 | 3 | 56 | 35 | |
69510 | 204431 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2193 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990684.30614 | 2100474.69239 | 37.7469671397153 | -122.474972424734 | (37.7469671397153, -122.474972424734) | 1 | 8 | 4 | 29491 | 40 | |||
70535 | 185602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2612 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985366.1309 | 2100949.2405 | 37.7479604792755 | -122.493396895173 | (37.7479604792755, -122.493396895173) | 1 | 8 | 3 | 29491 | 35 | |||
71283 | 69110 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 318 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33125 | 5993325.06338494 | 2104621.67061738 | 37.7585063618762 | -122.466142306467 | (37.7585063618762, -122.466142306467) | 1 | 8 | 4 | 56 | 12 | ||
71885 | 205719 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993232.44961 | 2099151.41057 | 37.7434810877719 | -122.466065100337 | (37.7434810877719, -122.466065100337) | 1 | 8 | 4 | 59 | 40 | |||
71956 | 204432 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2193 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990684.91939 | 2100489.86031 | 37.7470088224181 | -122.474971411208 | (37.7470088224181, -122.474971411208) | 1 | 8 | 4 | 29491 | 40 | |||
72083 | 183576 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000X Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986617 | 2097562 | 37.7387331105279 | -122.488822549418 | (37.7387331105279, -122.488822549418) | 1 | 8 | 3 | 29491 | 35 | |||
72152 | 182820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1805 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986876.4726 | 2102898.6794 | 37.7534013419725 | -122.488317508312 | (37.7534013419725, -122.488317508312) | 1 | 8 | 3 | 56 | 35 | |||
72818 | 92935 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 345 West Portal Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | 1 | 8 | 4 | 59 | 40 | ||||
74335 | 52816 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201CLAREMONT Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2006 12:00:00 AM | Permit Number 48842 | 5994261.61912336 | 2098704.96828598 | 37.7423145902485 | -122.462474141393 | (37.7423145902485, -122.462474141393) | 1 | 8 | 4 | 59 | 40 | |||
74914 | 184965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2717 34th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985820.5401 | 2096898.0233 | 37.7368634938723 | -122.491527432912 | (37.7368634938723, -122.491527432912) | 1 | 8 | 3 | 29491 | 35 | |||
75076 | 204406 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1449 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994256.18988 | 2105657.21543 | 37.761403376491 | -122.462997209747 | (37.761403376491, -122.462997209747) | 1 | 5 | 11 | 56 | 12 | |||
75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
76097 | 64932 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2300 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25960 | 5991529 | 2099733 | 37.7449795602653 | -122.471997526068 | (37.7449795602653, -122.471997526068) | 1 | 8 | 4 | 29491 | 40 | ||
76760 | 81369 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.7431538726351 | -122.467952894625 | (37.7431538726351, -122.467952894625) | 1 | 8 | 4 | 29491 | 40 | |||
76981 | 182175 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5988757 | 2104389 | 37.7576029019251 | -122.481923487166 | (37.7576029019251, -122.481923487166) | 1 | 8 | 3 | 56 | 35 | |||
77543 | 217670 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 226 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5992511.2738 | 2097412.1217 | 37.7386638087554 | -122.468432209214 | (37.7386638087554, -122.468432209214) | 1 | 8 | 4 | 59 | 40 | |||
77612 | 183527 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2554 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987715.4408 | 2097895.579 | 37.7397130743363 | -122.485049174462 | (37.7397130743363, -122.485049174462) | 1 | 8 | 3 | 29491 | 35 | |||
77917 | 204413 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1514 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992153.58389 | 2105133.64083 | 37.7598444403763 | -122.47023105232 | (37.7598444403763, -122.47023105232) | 1 | 8 | 4 | 56 | 12 | |||
78218 | 42900 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
78233 | 204489 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 40 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993983.90794 | 2102212.50861 | 37.7519294117375 | -122.463688890928 | (37.7519294117375, -122.463688890928) | 1 | 8 | 4 | 29491 | 40 | |||
78537 | 204463 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 370 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993952.25362 | 2099683.32037 | 37.7449830787995 | -122.463614813792 | (37.7449830787995, -122.463614813792) | 1 | 8 | 4 | 29491 | 40 | |||
79648 | 205752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 33 | Median : Yard | Tree | DPW 1 | 5 | 5993857.73884 | 2096475.3667 | 37.7361693944936 | -122.463708837915 | (37.7361693944936, -122.463708837915) | 1 | 8 | 4 | 59 | 40 | ||||
80478 | 43619 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
81000 | 204439 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2470 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991101.64507 | 2098607.15168 | 37.7418635320852 | -122.473393126203 | (37.7418635320852, -122.473393126203) | 1 | 8 | 4 | 29491 | 40 | |||
81070 | 256613 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2214 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781468 | 5985177 | 2100108 | 37.745639596763 | -122.493988903155 | (37.745639596763, -122.493988903155) | 1 | 8 | 3 | 29491 | 35 | |
81610 | 217706 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 159 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5992788.0796 | 2097577.4127 | 37.7391336410629 | -122.467487171016 | (37.7391336410629, -122.467487171016) | 1 | 8 | 4 | 59 | 40 | |||
81863 | 42874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.490660668299 | (37.7430410269224, -122.490660668299) | 1 | 8 | 3 | 29491 | 35 | |
82160 | 204445 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2300 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991529.26816 | 2099752.44735 | 37.7450329732008 | -122.471998016001 | (37.7450329732008, -122.471998016001) | 1 | 8 | 4 | 29491 | 40 | |||
82190 | 184899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984158.9984 | 2102960.4604 | 37.7534120503685 | -122.497719523191 | (37.7534120503685, -122.497719523191) | 1 | 8 | 3 | 56 | 35 | |||
82574 | 204466 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994033.29677 | 2099756.91004 | 37.7451898068672 | -122.463339922497 | (37.7451898068672, -122.463339922497) | 1 | 8 | 4 | 29491 | 40 | |||
82681 | 184456 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2150 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982348.1034 | 2100464.5996 | 37.7464527920087 | -122.503797042944 | (37.7464527920087, -122.503797042944) | 1 | 8 | 3 | 29491 | 35 | |||
83428 | 104905 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 419 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
83794 | 181889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2335 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985755.9263 | 2099311.3427 | 37.7434860472782 | -122.491928449962 | (37.7434860472782, -122.491928449962) | 1 | 8 | 3 | 29491 | 35 | |||
84118 | 217639 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 333 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5992202.9099 | 2096982.0539 | 37.7374651348279 | -122.469467078344 | (37.7374651348279, -122.469467078344) | 1 | 8 | 4 | 59 | 40 | |||
84236 | 205694 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 788 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5990530.51036 | 2099765.70343 | 37.7450115261664 | -122.47545247388 | (37.7450115261664, -122.47545247388) | 1 | 8 | 4 | 29491 | 40 | |||
85023 | 205680 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991377.35775 | 2104442.29027 | 37.7579012671485 | -122.472865199883 | (37.7579012671485, -122.472865199883) | 1 | 8 | 4 | 56 | 12 | |||
85157 | 120543 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2195 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5990654 | 2100514 | 37.7470733117967 | -122.475080088588 | (37.7470733117967, -122.475080088588) | 1 | 8 | 4 | 29491 | 40 | |||
85739 | 222230 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8 Aquavista Way | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5998088.24008 | 2101938.03895 | 37.7514114319011 | -122.449475816475 | (37.7514114319011, -122.449475816475) | 1 | 5 | 4 | 63 | 38 | |||
86371 | 39816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2135 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 3 | Permit Number 41147 | 5982300.3859 | 2100562.0651 | 37.746717599317 | -122.503969259712 | (37.746717599317, -122.503969259712) | 1 | 8 | 3 | 29491 | 35 | |
86867 | 104902 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 332 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
86953 | 183449 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2505 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5986419.2263 | 2098176.9478 | 37.740410049759 | -122.48955155596 | (37.740410049759, -122.48955155596) | 1 | 8 | 3 | 29491 | 35 |
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) );