trees
3,267 rows where qSpecies_id = 67 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119217 | 105958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1915 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6003627.84338 | 2119315.76937 | 37.7994417277114 | -122.431559722312 | (37.7994417277114, -122.431559722312) | 13 | 9 | 1 | 57 | 17 | ||||
79727 | 13246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2361 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001096.9833 | 2119276.5389 | 37.7991902392326 | -122.440314559231 | (37.7991902392326, -122.440314559231) | 13 | 9 | 1 | 57 | 17 | |||
91943 | 13273 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2499X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000515.185 | 2119195.2822 | 37.7989339874751 | -122.442321938486 | (37.7989339874751, -122.442321938486) | 13 | 9 | 1 | 57 | 17 | |||
58914 | 13272 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2499X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000478.6195 | 2119188.7816 | 37.7989140544396 | -122.442447999892 | (37.7989140544396, -122.442447999892) | 13 | 9 | 1 | 57 | 17 | |||
131813 | 125852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1294 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006829.97271 | 2119121.43017 | 37.799089094537 | -122.420465395978 | (37.799089094537, -122.420465395978) | 5 | 1 | 1 | 28858 | 32 | |||
41013 | 13288 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2639 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999748.1213 | 2119120.526 | 37.7986849783519 | -122.444970846589 | (37.7986849783519, -122.444970846589) | 13 | 9 | 1 | 57 | 17 | |||
163739 | 125858 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 774 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009308.82699 | 2119113.84916 | 37.7992076593521 | -122.411887153278 | (37.7992076593521, -122.411887153278) | 3 | 1 | 10 | 308 | 4 | |||
26428 | 125859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 774 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009302.33361 | 2119112.65566 | 37.7992040180028 | -122.411909538305 | (37.7992040180028, -122.411909538305) | 3 | 1 | 10 | 308 | 4 | |||
115379 | 125735 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3124 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000470.22373 | 2119054.48758 | 37.7985448401339 | -122.44246740516 | (37.7985448401339, -122.44246740516) | 13 | 9 | 1 | 57 | 17 | |||
53751 | 125862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 440 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011367.34488 | 2119048.19509 | 37.7991426608692 | -122.4047593111 | (37.7991426608692, -122.4047593111) | 3 | 1 | 10 | 308 | 23 | |||
142401 | 125736 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3124 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000473.08995 | 2119036.09992 | 37.7984945158666 | -122.44245616634 | (37.7984945158666, -122.44245616634) | 13 | 9 | 1 | 57 | 17 | |||
20326 | 125762 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001485.39053 | 2119019.34574 | 37.7985061611824 | -122.438952098255 | (37.7985061611824, -122.438952098255) | 13 | 9 | 1 | 57 | 17 | |||
29726 | 125761 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001466.33506 | 2119016.13086 | 37.7984962497695 | -122.439017805441 | (37.7984962497695, -122.439017805441) | 13 | 9 | 1 | 57 | 17 | |||
60932 | 98117 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001455.49775 | 2118981.69776 | 37.798401088908 | -122.439052836736 | (37.798401088908, -122.439052836736) | 13 | 9 | 1 | 57 | 17 | |||
55296 | 98116 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001457.2753 | 2118966.43976 | 37.7983592955935 | -122.439045591788 | (37.7983592955935, -122.439045591788) | 13 | 9 | 1 | 57 | 17 | |||
173061 | 63097 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1986 12:00:00 AM | 11 | Permit Number 23584 | 6001459.2061 | 2118948.46858 | 37.798310061319 | -122.439037622007 | (37.798310061319, -122.439037622007) | 13 | 9 | 1 | 57 | 17 | ||
142772 | 125847 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008754.65133 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) | 3 | 1 | 10 | 308 | 21 | |||
85165 | 125760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 253 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002145.57423 | 2118944.40464 | 37.7983379321998 | -122.436662293934 | (37.7983379321998, -122.436662293934) | 13 | 9 | 1 | 57 | 17 | |||
144759 | 58086 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1977 12:00:00 AM | 7 | Permit Number 17057 | 6002870.87342 | 2118942.93288 | 37.7983750823084 | -122.434152436312 | (37.7983750823084, -122.434152436312) | 13 | 9 | 1 | 57 | 17 | ||
98718 | 99596 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
151223 | 125757 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2102 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002844.99609 | 2118906.48858 | 37.7982735470321 | -122.434239372857 | (37.7982735470321, -122.434239372857) | 13 | 9 | 1 | 57 | 17 | |||
99137 | 125758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2102 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002844.96112 | 2118904.79694 | 37.7982689002438 | -122.434239372863 | (37.7982689002438, -122.434239372863) | 13 | 9 | 1 | 57 | 17 | |||
67757 | 98119 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060@Greenwich Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 23584 | 6001464 | 2118900 | 37.7981772521061 | -122.439017558255 | (37.7981772521061, -122.439017558255) | 13 | 9 | 1 | 57 | 17 | ||||
183848 | 98118 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060@Greenwich Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 23584 | 6001464 | 2118900 | 37.7981772521061 | -122.439017558255 | (37.7981772521061, -122.439017558255) | 13 | 9 | 1 | 57 | 17 | ||||
30828 | 143331 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004622.2604 | 2118810.3639 | 37.7981103264146 | -122.428082649557 | (37.7981103264146, -122.428082649557) | 13 | 9 | 1 | 57 | 17 | |||
28481 | 125745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1750 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004621.79826 | 2118809.27225 | 37.7981073028768 | -122.428084170861 | (37.7981073028768, -122.428084170861) | 13 | 9 | 1 | 57 | 17 | |||
31255 | 143332 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004607.3256 | 2118807.7665 | 37.7981023496411 | -122.428134143145 | (37.7981023496411, -122.428134143145) | 13 | 9 | 1 | 57 | 17 | |||
63668 | 125744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1750 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004605.15348 | 2118806.89342 | 37.7980998294914 | -122.428141597064 | (37.7980998294914, -122.428141597064) | 13 | 9 | 1 | 57 | 17 | |||
33928 | 125743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1782 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004488.21286 | 2118788.49943 | 37.7980427072573 | -122.428544934007 | (37.7980427072573, -122.428544934007) | 13 | 9 | 1 | 57 | 17 | |||
36418 | 143337 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1782 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004486.5484 | 2118787.637 | 37.7980402450526 | -122.428550632014 | (37.7980402450526, -122.428550632014) | 13 | 9 | 1 | 57 | 17 | |||
119563 | 61447 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1745 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 7 | Permit Number 33475 | 6004648.5784 | 2118760.76141 | 37.7979756196421 | -122.427988045036 | (37.7979756196421, -122.427988045036) | 13 | 9 | 1 | 57 | 17 | ||
24265 | 143366 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1745 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004644.9873 | 2118760.3647 | 37.7979743272134 | -122.428000442989 | (37.7979743272134, -122.428000442989) | 13 | 9 | 1 | 57 | 17 | |||
174621 | 125742 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001002.53319 | 2118754.0518 | 37.7977502495366 | -122.440603892067 | (37.7977502495366, -122.440603892067) | 13 | 9 | 1 | 57 | 17 | |||
79372 | 125741 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001003.19261 | 2118734.07853 | 37.7976954457528 | -122.440600176954 | (37.7976954457528, -122.440600176954) | 13 | 9 | 1 | 57 | 17 | |||
46737 | 125740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001004.89591 | 2118712.65785 | 37.7976367272048 | -122.440592745877 | (37.7976367272048, -122.440592745877) | 13 | 9 | 1 | 57 | 17 | |||
49142 | 125739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001008.7865 | 2118693.15243 | 37.7975833920075 | -122.440577883666 | (37.7975833920075, -122.440577883666) | 13 | 9 | 1 | 57 | 17 | |||
133397 | 125738 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3000 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001012.2526 | 2118670.44762 | 37.797521247954 | -122.440564260726 | (37.797521247954, -122.440564260726) | 13 | 9 | 1 | 57 | 17 | |||
67431 | 125759 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2490 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001059.99138 | 2118655.75982 | 37.7974836374112 | -122.44039801837 | (37.7974836374112, -122.44039801837) | 13 | 9 | 1 | 57 | 17 | |||
22729 | 125756 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2495 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001066.19876 | 2118613.86954 | 37.7973689711697 | -122.440373533438 | (37.7973689711697, -122.440373533438) | 13 | 9 | 1 | 57 | 17 | |||
112326 | 125848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6008008.91714 | 2118589.10669 | 37.7976938341652 | -122.416348113498 | (37.7976938341652, -122.416348113498) | 5 | 1 | 10 | 28858 | 21 | |||
61181 | 125737 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2964 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001026.02043 | 2118577.60099 | 37.7972670995394 | -122.440509957869 | (37.7972670995394, -122.440509957869) | 13 | 9 | 1 | 57 | 17 | |||
44792 | 58679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2823 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1979 12:00:00 AM | 11 | Permit Number 17907 | 5999510.1538 | 2118572.9915 | 37.7971680104441 | -122.445754889478 | (37.7971680104441, -122.445754889478) | 13 | 9 | 1 | 57 | 17 | ||
75829 | 125871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011628.14364 | 2118497.28701 | 37.7976445738046 | -122.403818067153 | (37.7976445738046, -122.403818067153) | 3 | 1 | 10 | 308 | 23 | |||
180792 | 125789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 5999154.23094 | 2118479.17049 | 37.7968900749607 | -122.446979711267 | (37.7968900749607, -122.446979711267) | 13 | 9 | 1 | 57 | 17 | |||
10804 | 125788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5999154.81918 | 2118474.67758 | 37.7968777722368 | -122.446977352345 | (37.7968777722368, -122.446977352345) | 13 | 9 | 1 | 57 | 17 | |||
88291 | 125872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011632.89499 | 2118465.53836 | 37.7975576651089 | -122.403799390925 | (37.7975576651089, -122.403799390925) | 3 | 1 | 10 | 308 | 23 | |||
172340 | 69335 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1994 12:00:00 AM | 13 | Permit Number 33420 | 5999154.94286 | 2118460.96082 | 37.7968401167431 | -122.446975936805 | (37.7968401167431, -122.446975936805) | 13 | 9 | 1 | 57 | 17 | ||
87892 | 125755 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999499.30193 | 2118438.9235 | 37.7967992758322 | -122.445782792755 | (37.7967992758322, -122.445782792755) | 13 | 9 | 1 | 57 | 17 | |||
84449 | 125754 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999481.92865 | 2118436.50892 | 37.7967916540714 | -122.44584273436 | (37.7967916540714, -122.44584273436) | 13 | 9 | 1 | 57 | 17 | |||
56123 | 125753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999461.74411 | 2118432.96288 | 37.7967807650693 | -122.445912322107 | (37.7967807650693, -122.445912322107) | 13 | 9 | 1 | 57 | 17 | |||
76408 | 125873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011640.68248 | 2118420.88773 | 37.7974355002954 | -122.403769300527 | (37.7974355002954, -122.403769300527) | 3 | 1 | 10 | 308 | 23 | |||
99803 | 125746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1824 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004290.24305 | 2118412.29995 | 37.796998554791 | -122.42920312802 | (37.796998554791, -122.42920312802) | 13 | 9 | 1 | 57 | 17 | |||
76395 | 125851 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1359 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007069.22573 | 2118411.66691 | 37.7971537427193 | -122.419587113579 | (37.7971537427193, -122.419587113579) | 5 | 1 | 10 | 28858 | 32 | |||
62087 | 125747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1830 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004263.23956 | 2118407.72557 | 37.7969844660126 | -122.429296240239 | (37.7969844660126, -122.429296240239) | 13 | 9 | 1 | 57 | 17 | |||
5346 | 125748 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1830 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004242.00992 | 2118405.50242 | 37.7969771599227 | -122.429369541272 | (37.7969771599227, -122.429369541272) | 13 | 9 | 1 | 57 | 17 | |||
187163 | 125752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5999213.3669 | 2118400.45561 | 37.7966773232594 | -122.446769420986 | (37.7966773232594, -122.446769420986) | 13 | 9 | 1 | 57 | 17 | |||
109081 | 125751 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999201.16809 | 2118397.93355 | 37.7966697014868 | -122.446811449891 | (37.7966697014868, -122.446811449891) | 13 | 9 | 1 | 57 | 17 | |||
7365 | 125750 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2870 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5999187.17827 | 2118395.44877 | 37.7966620797435 | -122.446859678745 | (37.7966620797435, -122.446859678745) | 13 | 9 | 1 | 57 | 17 | |||
86554 | 125874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011617.36417 | 2118380.15479 | 37.797322354795 | -122.403847120659 | (37.797322354795, -122.403847120659) | 3 | 1 | 10 | 308 | 23 | |||
63822 | 125875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011598.44427 | 2118378.74815 | 37.7973174355031 | -122.40391248968 | (37.7973174355031, -122.40391248968) | 3 | 1 | 10 | 308 | 23 | |||
85847 | 125790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2829 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999396.9981 | 2118378.46939 | 37.7966274432433 | -122.446132435676 | (37.7966274432433, -122.446132435676) | 13 | 9 | 1 | 57 | 17 | |||
84171 | 125876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011549.44134 | 2118372.57887 | 37.7972977583346 | -122.404081618882 | (37.7972977583346, -122.404081618882) | 3 | 1 | 10 | 308 | 23 | |||
186698 | 125877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011538.01485 | 2118371.01947 | 37.7972928381608 | -122.404121047862 | (37.7972928381608, -122.404121047862) | 3 | 1 | 10 | 308 | 23 | |||
194101 | 125826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1865 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004120.08533 | 2118341.02861 | 37.7967932278896 | -122.429786828517 | (37.7967932278896, -122.429786828517) | 13 | 9 | 1 | 57 | 17 | |||
136701 | 125825 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1871 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004090.00748 | 2118336.91412 | 37.7967802272889 | -122.429890611181 | (37.7967802272889, -122.429890611181) | 13 | 9 | 1 | 57 | 17 | |||
41957 | 125849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1562 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006082.20821 | 2118316.31248 | 37.7968362775269 | -122.422995662833 | (37.7968362775269, -122.422995662833) | 13 | 9 | 10 | 28858 | 32 | |||
105847 | 125850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1562 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006063.20747 | 2118313.29761 | 37.7968269272662 | -122.423061195515 | (37.7968269272662, -122.423061195515) | 13 | 9 | 10 | 28858 | 32 | |||
100183 | 125787 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2760 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999175.1799 | 2118283.40423 | 37.7963537498842 | -122.446893129025 | (37.7963537498842, -122.446893129025) | 13 | 9 | 1 | 57 | 17 | |||
100563 | 125827 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2411 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005396.53977 | 2118250.38526 | 37.7966165434615 | -122.4253635436 | (37.7966165434615, -122.4253635436) | 13 | 9 | 1 | 57 | 17 | |||
74980 | 115241 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2401 FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005332 | 2118242 | 37.7965898731316 | -122.425586268684 | (37.7965898731316, -122.425586268684) | 13 | 9 | 1 | 57 | 17 | |||
164827 | 115242 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2401 FRANKLIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005332 | 2118242 | 37.7965898731316 | -122.425586268684 | (37.7965898731316, -122.425586268684) | 13 | 9 | 1 | 57 | 17 | |||
146043 | 125828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2411 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005398.28798 | 2118235.77605 | 37.7965765290478 | -122.425356454246 | (37.7965765290478, -122.425356454246) | 13 | 9 | 1 | 57 | 17 | |||
42595 | 59553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1981 12:00:00 AM | 9 | Permit Number 18938 | 6005363.02873 | 2118214.93321 | 37.7965173077913 | -122.425476975078 | (37.7965173077913, -122.425476975078) | 13 | 9 | 1 | 28858 | 17 | ||
163136 | 125829 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005348.04756 | 2118212.32677 | 37.7965093047116 | -122.425528627648 | (37.7965093047116, -122.425528627648) | 13 | 9 | 1 | 28858 | 17 | |||
179886 | 125821 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2063 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003164.21537 | 2118208.30496 | 37.7963746285338 | -122.433084869086 | (37.7963746285338, -122.433084869086) | 13 | 9 | 1 | 57 | 17 | |||
101668 | 125831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005313.11199 | 2118207.21627 | 37.7964932985791 | -122.425649148516 | (37.7964932985791, -122.425649148516) | 13 | 9 | 1 | 28858 | 17 | |||
186572 | 125830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005331.8246 | 2118206.2485 | 37.7964916986797 | -122.425584329857 | (37.7964916986797, -122.425584329857) | 13 | 9 | 1 | 28858 | 17 | |||
186800 | 125820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2067 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003140.75191 | 2118205.20485 | 37.7963647854668 | -122.433165835937 | (37.7963647854668, -122.433165835937) | 13 | 9 | 1 | 57 | 17 | |||
11008 | 125832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005294.88878 | 2118203.51089 | 37.7964820948146 | -122.425711940964 | (37.7964820948146, -122.425711940964) | 13 | 9 | 1 | 28858 | 17 | |||
151752 | 125819 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003119.3814 | 2118201.7628 | 37.7963541221954 | -122.433239536279 | (37.7963541221954, -122.433239536279) | 13 | 9 | 1 | 57 | 17 | |||
14118 | 125818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003105.57534 | 2118201.45062 | 37.7963524818244 | -122.433287285795 | (37.7963524818244, -122.433287285795) | 13 | 9 | 1 | 57 | 17 | |||
56288 | 125817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003091.73227 | 2118199.34696 | 37.7963459203936 | -122.433335035292 | (37.7963459203936, -122.433335035292) | 13 | 9 | 1 | 57 | 17 | |||
167678 | 125816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003070.0987 | 2118197.70265 | 37.7963401782213 | -122.433409774364 | (37.7963401782213, -122.433409774364) | 13 | 9 | 1 | 57 | 17 | |||
5075 | 125815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003051.46393 | 2118195.99672 | 37.7963344369473 | -122.433474132552 | (37.7963344369473, -122.433474132552) | 13 | 9 | 1 | 57 | 17 | |||
18204 | 125749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2672 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000224.25426 | 2118193.8188 | 37.7961676486817 | -122.443256684343 | (37.7961676486817, -122.443256684343) | 13 | 9 | 1 | 57 | 17 | |||
152720 | 125846 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006507.97798 | 2117964.81941 | 37.7958951819816 | -122.421497421971 | (37.7958951819816, -122.421497421971) | 13 | 9 | 10 | 28858 | 32 | |||
109755 | 125845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006496.95223 | 2117963.36132 | 37.7958905567518 | -122.421535469611 | (37.7958905567518, -122.421535469611) | 13 | 9 | 10 | 28858 | 32 | |||
12522 | 125844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006489.38359 | 2117961.8198 | 37.7958858973642 | -122.421561549045 | (37.7958858973642, -122.421561549045) | 13 | 9 | 10 | 28858 | 32 | |||
187720 | 125843 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006477.878 | 2117960.43479 | 37.7958814457163 | -122.421601262209 | (37.7958814457163, -122.421601262209) | 13 | 9 | 10 | 28858 | 32 | |||
27592 | 42830 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
49776 | 42833 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
59979 | 42834 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
84962 | 42831 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
156889 | 42835 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
167315 | 42832 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
187929 | 125786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999208.49326 | 2117946.86067 | 37.7954315940422 | -122.446753630693 | (37.7954315940422, -122.446753630693) | 13 | 9 | 1 | 57 | 17 | |||
18867 | 53701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.7954019613927 | -122.446746130351 | (37.7954019613927, -122.446746130351) | 13 | 9 | 1 | 57 | 17 | ||
102204 | 125878 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 712 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011759.18652 | 2117854.8104 | 37.7958878075263 | -122.403319400277 | (37.7958878075263, -122.403319400277) | 3 | 1 | 10 | 28860 | 4 | |||
62837 | 125814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2400 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002028.8758 | 2117750.14346 | 37.7950521700829 | -122.436980560426 | (37.7950521700829, -122.436980560426) | 13 | 9 | 1 | 57 | 27 | |||
86872 | 54138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.7949665825052 | -122.437710167809 | (37.7949665825052, -122.437710167809) | 13 | 9 | 1 | 57 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );