trees
3,267 rows where qSpecies_id = 67 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
155675 | 30673 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1018 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 7 | Permit Number 34598 | 6007663.01696 | 2109836.11415 | 37.7736407906294 | -122.416924546537 | (37.7736407906294, -122.416924546537) | 8 | 2 | 9 | 28853 | 19 | |
169368 | 42187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
170526 | 189022 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010767.85313 | 2109551.04982 | 37.7730322274755 | -122.406164302148 | (37.7730322274755, -122.406164302148) | 14 | 2 | 9 | 28853 | 34 | ||
170806 | 188850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6010617.59281 | 2110376.13956 | 37.7752893270638 | -122.406742232588 | (37.7752893270638, -122.406742232588) | 8 | 2 | 9 | 28853 | 34 | |||
172394 | 42237 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010511.20245 | 2112266.55567 | 37.7804740149056 | -122.407243553343 | (37.7804740149056, -122.407243553343) | 14 | 2 | 9 | 28853 | 34 | |
173024 | 29053 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.06899 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | 8 | 2 | 9 | 28853 | 19 | ||
177519 | 188853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6009987.41661 | 2109987.90496 | 37.7741880460757 | -122.408894768882 | (37.7741880460757, -122.408894768882) | 8 | 2 | 9 | 28853 | 34 | |||
181438 | 189021 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010755.67796 | 2109540.70716 | 37.7730031478998 | -122.406205688962 | (37.7730031478998, -122.406205688962) | 14 | 2 | 9 | 28853 | 34 | ||
181749 | 222496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006343.14991 | 2109555.37804 | 37.7727956257483 | -122.42147023457 | (37.7727956257483, -122.42147023457) | 8 | 2 | 9 | 28853 | 19 | |||
185189 | 15229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
185378 | 82894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52441 | 6008668.81492 | 2110175.98825 | 37.7746305296131 | -122.413469367432 | (37.7746305296131, -122.413469367432) | 8 | 2 | 9 | 28853 | 34 | |
186848 | 220782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009149.20371 | 2106999.46315 | 37.7659354919643 | -122.411583121262 | (37.7659354919643, -122.411583121262) | 8 | 4 | 7 | 28853 | 19 | |||
186885 | 10043 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Guerrero St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005477.51423 | 2106859.76809 | 37.765345281278 | -122.424272816157 | (37.765345281278, -122.424272816157) | 8 | 4 | 5 | 28853 | 19 | |||
186897 | 82990 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.7748425951352 | -122.411296828379 | (37.7748425951352, -122.411296828379) | 8 | 2 | 9 | 28853 | 34 | |
189420 | 10044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Guerrero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005474.87318 | 2106843.21233 | 37.7652996739685 | -122.424280773353 | (37.7652996739685, -122.424280773353) | 8 | 4 | 5 | 28853 | 19 | |||
190773 | 36094 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
191017 | 189031 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010032.2441 | 2111878.47542 | 37.7793816210166 | -122.408873115008 | (37.7793816210166, -122.408873115008) | 14 | 2 | 9 | 28853 | 34 | |||
191984 | 7409 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010471.6875 | 2111110.743 | 37.7772982123977 | -122.407298752214 | (37.7772982123977, -122.407298752214) | 14 | 2 | 9 | 28853 | 34 | |||
192422 | 189030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010021.47788 | 2111859.88889 | 37.7793299837179 | -122.408909048327 | (37.7793299837179, -122.408909048327) | 14 | 2 | 9 | 28853 | 34 | |||
60912 | 89040 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
128724 | 89039 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
146725 | 89038 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
152630 | 89037 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
5159 | 83758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013046.15855 | 2104759.52511 | 37.7600029395994 | -122.397947120176 | (37.7600029395994, -122.397947120176) | 10 | 3 | 8 | 28856 | 29 | |||
6802 | 188921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012543.15348 | 2101838.55647 | 37.751954571155 | -122.399481710736 | (37.751954571155, -122.399481710736) | 10 | 3 | 8 | 28856 | 29 | |||
7440 | 78070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011825.39206 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | 10 | 3 | 8 | 28856 | 29 | |||
7441 | 101155 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
7526 | 54915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 491 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10781 | 6011237.02996 | 2106095.07508 | 37.7635691382211 | -122.404298060519 | (37.7635691382211, -122.404298060519) | 8 | 3 | 8 | 28856 | 29 | ||
9504 | 74038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014092.75077 | 2101968.09189 | 37.7523964980076 | -122.394132008099 | (37.7523964980076, -122.394132008099) | 10 | 3 | 8 | 28856 | 1 | |||
12851 | 188928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158 | (37.7519707940373, -122.39914787158) | 10 | 3 | 8 | 28856 | 29 | |||
14824 | 188911 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6012384.77523 | 2101833.46813 | 37.751931770655 | -122.400029051595 | (37.751931770655, -122.400029051595) | 10 | 3 | 8 | 28856 | 29 | |||
15208 | 56135 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 10 | Permit Number 12238 | 6012444.68154 | 2104578.12119 | 37.7594713278533 | -122.400014612979 | (37.7594713278533, -122.400014612979) | 10 | 3 | 8 | 28856 | 29 | ||
16154 | 188901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013030.31907 | 2104757.32999 | 37.7599960301161 | -122.39800174768 | (37.7599960301161, -122.39800174768) | 10 | 3 | 8 | 28856 | 29 | |||
16361 | 188907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6013010.92349 | 2105173.17566 | 37.7611367706692 | -122.398098002138 | (37.7611367706692, -122.398098002138) | 10 | 3 | 8 | 28856 | 29 | |||
22168 | 188924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012576.69697 | 2101839.95145 | 37.7519602710713 | -122.399365809709 | (37.7519602710713, -122.399365809709) | 10 | 3 | 8 | 28856 | 29 | |||
23424 | 188870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300x De Haro St | 30 | Median : Yard | Tree | DPW 1 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.400393822023 | (37.7524393767806, -122.400393822023) | 10 | 3 | 8 | 28856 | 29 | ||||
23515 | 188900 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 20th St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013884.30991 | 2104803.71969 | 37.7601709320582 | -122.395051432701 | (37.7601709320582, -122.395051432701) | 10 | 3 | 8 | 28856 | 29 | |||
25461 | 188931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012684.2362 | 2101844.79492 | 37.751979563304 | -122.398994261091 | (37.751979563304, -122.398994261091) | 10 | 3 | 8 | 28856 | 29 | |||
26306 | 188877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 711 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011296.96428 | 2105014.49573 | 37.7606054583887 | -122.404014716503 | (37.7606054583887, -122.404014716503) | 10 | 3 | 8 | 28856 | 29 | |||
31438 | 188881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 Vermont St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011300.93761 | 2104283.5706 | 37.7585987228662 | -122.403949537249 | (37.7585987228662, -122.403949537249) | 10 | 3 | 8 | 28856 | 29 | ||||
34694 | 188895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1050 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6012767.38997 | 2102598.59008 | 37.7540539548395 | -122.398759597378 | (37.7540539548395, -122.398759597378) | 10 | 3 | 8 | 28856 | 29 | |||
35134 | 188923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012568.02494 | 2101839.32896 | 37.7519580785092 | -122.399395755332 | (37.7519580785092, -122.399395755332) | 10 | 3 | 8 | 28856 | 29 | |||
37971 | 101154 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x5 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
38323 | 100251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 540 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6015234.41692 | 2113622.27838 | 37.7844597292764 | -122.390998376191 | (37.7844597292764, -122.390998376191) | 6 | 2 | 9 | 28856 | 6 | |||
40381 | 42165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.402562043425 | (37.7794657219919, -122.402562043425) | 14 | 2 | 9 | 28856 | 34 | ||
40401 | 188902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013016.18461 | 2104756.14871 | 37.7599919993531 | -122.398050549418 | (37.7599919993531, -122.398050549418) | 10 | 3 | 8 | 28856 | 29 | |||
40812 | 104971 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 752 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | 10 | 3 | 8 | 28856 | 29 | |||
41642 | 188868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1106 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012179.40591 | 2103244.12838 | 37.7557936834398 | -122.40083835062 | (37.7557936834398, -122.40083835062) | 10 | 3 | 8 | 28856 | 29 | |||
43111 | 188894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 613 Wisconsin St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012726.06776 | 2104548.45782 | 37.7594055631388 | -122.399039352197 | (37.7594055631388, -122.399039352197) | 10 | 3 | 8 | 28856 | 29 | |||
43554 | 188898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 801 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012769.9943 | 2103729.94433 | 37.7571605522208 | -122.39882998641 | (37.7571605522208, -122.39882998641) | 10 | 3 | 8 | 28856 | 29 | |||
44986 | 54440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.394428794276 | (37.7598699757444, -122.394428794276) | 10 | 3 | 8 | 28856 | 29 | ||
44988 | 188915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012439.14392 | 2101833.80139 | 37.7519357168614 | -122.39984105913 | (37.7519357168614, -122.39984105913) | 10 | 3 | 8 | 28856 | 29 | |||
49572 | 188879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 800 Vermont St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011290.47515 | 2104318.93293 | 37.7586952354223 | -122.403988209898 | (37.7586952354223, -122.403988209898) | 10 | 3 | 8 | 28856 | 29 | ||||
50963 | 188920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012536.08431 | 2101837.90146 | 37.7519523786127 | -122.399506111115 | (37.7519523786127, -122.399506111115) | 10 | 3 | 8 | 28856 | 29 | |||
52172 | 101147 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 455 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6012984.94495 | 2104946.73271 | 37.760513561162 | -122.398171964177 | (37.760513561162, -122.398171964177) | 10 | 3 | 8 | 28856 | 29 | |||
52173 | 188864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013678.34538 | 2105678.35713 | 37.7625610395872 | -122.395825059197 | (37.7625610395872, -122.395825059197) | 14 | 3 | 8 | 28856 | 29 | |||
54574 | 54441 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 516 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10218 | 6014063.35386 | 2104670.62124 | 37.7598154273534 | -122.394422880319 | (37.7598154273534, -122.394422880319) | 10 | 3 | 8 | 28856 | 29 | ||
54750 | 81857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.18813 | 2112205.75243 | 37.780470662242 | -122.397099557694 | (37.780470662242, -122.397099557694) | 6 | 2 | 9 | 28856 | 34 | |
55619 | 188884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011309.01524 | 2104361.95853 | 37.7588144099776 | -122.403927117158 | (37.7588144099776, -122.403927117158) | 10 | 3 | 8 | 28856 | 29 | ||||
57705 | 188874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 706 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011517.98161 | 2105035.49815 | 37.7606754724016 | -122.403251791052 | (37.7606754724016, -122.403251791052) | 10 | 3 | 8 | 28856 | 29 | |||
60996 | 39584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45485 | 6011827.16127123 | 2104595.75128112 | 37.759485287628 | -122.402151554664 | (37.759485287628, -122.402151554664) | 10 | 3 | 8 | 28856 | 29 | ||
66194 | 188905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 390 19th St | 4 | : | Tree | Private 2 | 13 | Width 3ft | 6013268.70779 | 2105235.79503 | 37.7613230643314 | -122.397210821847 | (37.7613230643314, -122.397210821847) | 10 | 3 | 8 | 28856 | 29 | |||
71321 | 188863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2018 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011355.7486 | 2106062.02841 | 37.7634850327243 | -122.403885122406 | (37.7634850327243, -122.403885122406) | 8 | 3 | 8 | 28856 | 29 | |||
72789 | 101152 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
74588 | 67715 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.7815181053298 | -122.396258423594 | (37.7815181053298, -122.396258423594) | 6 | 2 | 9 | 28856 | 34 |
75123 | 42164 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.7795376326187 | -122.40257363052 | (37.7795376326187, -122.40257363052) | 14 | 2 | 9 | 28856 | 34 | |||
76463 | 188861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011268.74623 | 2105511.94032 | 37.7619697533113 | -122.404147320653 | (37.7619697533113, -122.404147320653) | 10 | 3 | 8 | 28856 | 29 | |||
81657 | 188919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012522.72897 | 2101837.16706 | 37.7519496176856 | -122.399552244535 | (37.7519496176856, -122.399552244535) | 10 | 3 | 8 | 28856 | 29 | |||
86426 | 188880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 Vermont St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011314.3865 | 2104282.54331 | 37.7585966535287 | -122.403902952356 | (37.7585966535287, -122.403902952356) | 10 | 3 | 8 | 28856 | 29 | ||||
87723 | 188909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Mississippi St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6014064.59876 | 2105675.24732 | 37.7625739808237 | -122.394488921123 | (37.7625739808237, -122.394488921123) | 10 | 3 | 8 | 28856 | 29 | |||
92450 | 188925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012587.76707 | 2101840.20592 | 37.7519615867766 | -122.399327545327 | (37.7519615867766, -122.399327545327) | 10 | 3 | 8 | 28856 | 29 | |||
93132 | 188869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1164 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012189.44152 | 2103014.30234 | 37.7551631912308 | -122.400787498439 | (37.7551631912308, -122.400787498439) | 10 | 3 | 8 | 28856 | 29 | |||
95460 | 118310 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
96698 | 188927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012620.56924 | 2101841.45288 | 37.7519668387962 | -122.399214197496 | (37.7519668387962, -122.399214197496) | 10 | 3 | 8 | 28856 | 29 | |||
98014 | 188885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011299.70234 | 2104367.28532 | 37.7588285158534 | -122.403959700505 | (37.7588285158534, -122.403959700505) | 10 | 3 | 8 | 28856 | 29 | ||||
100688 | 122718 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014329.5757 | 2104932.99379 | 37.760550641114 | -122.393520505067 | (37.760550641114, -122.393520505067) | 10 | 3 | 8 | 28856 | 29 | |||
102231 | 47679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.81136 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | 10 | 3 | 8 | 28856 | 29 | |
102679 | 188858 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 497 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011238.17716 | 2106077.91638 | 37.7635220883952 | -122.404292884924 | (37.7635220883952, -122.404292884924) | 8 | 3 | 8 | 28856 | 29 | |||
103472 | 188930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6012673.63731 | 2101844.052 | 37.7519769327872 | -122.399030861684 | (37.7519769327872, -122.399030861684) | 10 | 3 | 8 | 28856 | 29 | |||
104028 | 188893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 721 Wisconsin St | 1 | : | Tree | Private 2 | 12 | Width 1ft | 6012746.65722 | 2104146.94793 | 37.7583042524484 | -122.398939962706 | (37.7583042524484, -122.398939962706) | 10 | 3 | 8 | 28856 | 29 | |||
105729 | 102246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 337 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x6 | 6013795.01675 | 2105505.95048 | 37.7620941385477 | -122.395409453676 | (37.7620941385477, -122.395409453676) | 10 | 3 | 8 | 28856 | 29 | |||
106602 | 188918 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012503.47423 | 2101836.59993 | 37.7519469871825 | -122.399618790794 | (37.7519469871825, -122.399618790794) | 10 | 3 | 8 | 28856 | 29 | |||
108514 | 101149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 455 Arkansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x4 | 6012981.15639 | 2104998.3662 | 37.7606551243498 | -122.398188689753 | (37.7606551243498, -122.398188689753) | 10 | 3 | 8 | 28856 | 29 | |||
110308 | 188899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 801 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012769.67955 | 2103741.86982 | 37.7571932794713 | -122.398831911879 | (37.7571932794713, -122.398831911879) | 10 | 3 | 8 | 28856 | 29 | |||
110405 | 188904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013484.89022 | 2104980.58732 | 37.7606343527251 | -122.396445243359 | (37.7606343527251, -122.396445243359) | 10 | 3 | 8 | 28856 | 29 | |||
112461 | 188916 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012464.32295 | 2101833.92886 | 37.7519374705385 | -122.39975399485 | (37.7519374705385, -122.39975399485) | 10 | 3 | 8 | 28856 | 29 | |||
114063 | 188878 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 800 Vermont St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011299.19502 | 2104323.40019 | 37.7587079887048 | -122.403958366804 | (37.7587079887048, -122.403958366804) | 10 | 3 | 8 | 28856 | 29 | ||||
114642 | 101153 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
115322 | 188897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 837 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 4ft | 6012777.55941 | 2103554.05206 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | 10 | 3 | 8 | 28856 | 29 | |||
115976 | 101148 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 455 Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6012983.73857 | 2104971.40242 | 37.7605812315668 | -122.398177867333 | (37.7605812315668, -122.398177867333) | 10 | 3 | 8 | 28856 | 29 | |||
117796 | 188873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 494 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011461.22854 | 2106087.39917 | 37.7635605874707 | -122.403522084087 | (37.7635605874707, -122.403522084087) | 8 | 3 | 8 | 28856 | 29 | |||
120395 | 188862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2145 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011298.33693 | 2105542.34604 | 37.7620548939477 | -122.404047117302 | (37.7620548939477, -122.404047117302) | 10 | 3 | 8 | 28856 | 29 | |||
121084 | 188872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.7576089119481 | -122.400804905738 | (37.7576089119481, -122.400804905738) | 10 | 3 | 8 | 28856 | 29 | |||
121206 | 54562 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 602 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 12 | Permit Number 10357 | 6014081.86268 | 2104331.94861 | 37.7588865346901 | -122.394335154162 | (37.7588865346901, -122.394335154162) | 10 | 3 | 8 | 28856 | 29 | ||
122259 | 188876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011515.64889 | 2104667.7602 | 37.7596656156021 | -122.403233989882 | (37.7596656156021, -122.403233989882) | 10 | 3 | 8 | 28856 | 29 | |||
123270 | 188883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011316.75844 | 2104356.66336 | 37.7588003032186 | -122.403899964826 | (37.7588003032186, -122.403899964826) | 10 | 3 | 8 | 28856 | 29 | ||||
123542 | 188875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 846 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011553.12561 | 2104399.72998 | 37.7589317571145 | -122.403085522592 | (37.7589317571145, -122.403085522592) | 10 | 3 | 8 | 28856 | 29 | |||
125387 | 102252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6013186.08579 | 2105322.73493 | 37.7615571821298 | -122.397502676109 | (37.7615571821298, -122.397502676109) | 10 | 3 | 8 | 28856 | 29 | |||
127329 | 107039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1315 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | 6013638.38831 | 2105678.022 | 37.7625578964607 | -122.39596323371 | (37.7625578964607, -122.39596323371) | 14 | 3 | 8 | 28856 | 29 |
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) );